2 files changed, 14 insertions, 1 deletions
diff --git a/src/modules/result/components/ImportModal.tsx b/src/modules/result/components/ImportModal.tsx
index 1bb7b26..daacb55 100644
--- a/src/modules/result/components/ImportModal.tsx
+++ b/src/modules/result/components/ImportModal.tsx
@@ -62,6 +62,17 @@ const ImportModal = ({ modal }: Props) => {
           <form className='pb-6' onSubmit={handleSubmit}>
             <input type='file' onChange={handleFileChange} accept='.xls, .xlsx' />
             <Spacer y={4} />
+            
+            <div className='text-xs p-3 bg-info-100 border border-info-200 text-info-700 rounded-medium flex items-start gap-2'>
+              <div className='flex-shrink-0'>ℹ️</div>
+              <div>
+                <p className='font-semibold'>Format File Excel:</p>
+                <p>Kolom 1-7: Nama, Barcode, Item Code, Qty On-hand, Qty Gudang Selisih, companyId, ID / External ID, value (per Unit)</p>
+                <p>Kolom 8 (opsional): Location</p>
+              </div>
+            </div>
+            <Spacer y={4} />
+            
             <Input
               type="text"
               label='Ketik ulang untuk konfirmasi'
diff --git a/src/modules/result/components/ProductModal.tsx b/src/modules/result/components/ProductModal.tsx
index cfd7382..df0a911 100644
--- a/src/modules/result/components/ProductModal.tsx
+++ b/src/modules/result/components/ProductModal.tsx
@@ -36,7 +36,7 @@ const ProductModal = ({ modal }: Props) => {
       })
       const response = await fetch(`/api/product?${searchParams}`)
       const data: {
-        products: (Product & { company: { id: number, name: string } })[],
+        products: (Product & { company: { id: number, name: string }, location?: { id: number, name: string } | null })[],
         page: number,
         totalPage: number
       } = await response.json()
@@ -89,6 +89,7 @@ const ProductModal = ({ modal }: Props) => {
                 <TableColumn>BARCODE</TableColumn>
                 <TableColumn>ON-HAND QTY</TableColumn>
                 <TableColumn>DIFFERENCE QTY</TableColumn>
+                <TableColumn>LOCATION</TableColumn>
                 <TableColumn>COMPANY</TableColumn>
               </TableHeader>
               <TableBody items={data?.products || []}>
@@ -99,6 +100,7 @@ const ProductModal = ({ modal }: Props) => {
                     <TableCell>{product.barcode}</TableCell>
                     <TableCell>{product.onhandQty}</TableCell>
                     <TableCell>{product.differenceQty}</TableCell>
+                    <TableCell>{(product as any).location?.name || '-'}</TableCell>
                     <TableCell>{product.company.name}</TableCell>
                   </TableRow>
                 )}