[Web-erp-svn] SF.net SVN: web-erp:[7411] trunk/ReprintGRN.php

[<ex...@us...>]

Revision: 7411
          http://sourceforge.net/p/web-erp/reponame/7411
Author:   exsonqu
Date:     2015-12-10 10:03:15 +0000 (Thu, 10 Dec 2015)
Log Message:
-----------
10/12/15 Exson: Add invoice no while reprint GRN in ReprintGRN.php.

Modified Paths:
--------------
    trunk/ReprintGRN.php

Modified: trunk/ReprintGRN.php
===================================================================
--- trunk/ReprintGRN.php	2015-12-10 09:35:17 UTC (rev 7410)
+++ trunk/ReprintGRN.php	2015-12-10 10:03:15 UTC (rev 7411)
@@ -49,16 +49,18 @@
 		exit;
 	}
 	$sql="SELECT grnbatch,
-				grnno,
+				grns.grnno,
 				grns.podetailitem,
 				grns.itemcode,
 				grns.itemdescription,
 				grns.deliverydate,
 				grns.qtyrecd,
+				suppinvstogrn.suppinv,
 				suppliers.suppname,
 				stockmaster.decimalplaces
 			FROM grns INNER JOIN suppliers
 			ON grns.supplierid=suppliers.supplierid
+			LEFT JOIN suppinvstogrn ON grns.grnno=suppinvstogrn.grnno
 			INNER JOIN purchorderdetails
 			ON grns.podetailitem=purchorderdetails.podetailitem
 			INNER JOIN purchorders on purchorders.orderno=purchorderdetails.orderno
@@ -87,6 +89,7 @@
 				<th>' . _('Item Description') . '</th>
 				<th>' . _('Delivery Date') . '</th>
 				<th>' . _('Quantity Received') . '</th>
+				<th>' . _('Invoice No') . '</th>
 				<th>' . _('Action') . '</th>
 			</tr>';
 
@@ -105,6 +108,7 @@
 			<td>' . $myrow['itemdescription'] . '</td>
 			<td>' . $myrow['deliverydate'] . '</td>
 			<td class="number">' . locale_number_format($myrow['qtyrecd'], $myrow['decimalplaces']) . '</td>
+			<td>' . $myrow['suppinv'] . '</td>
 			<td><a href="PDFGrn.php?GRNNo=' . $myrow['grnbatch'] .'&PONo=' . $_POST['PONumber'] . '">' . _('Reprint GRN ') . '</a>
 			&nbsp;<a href="PDFQALabel.php?GRNNo=' . $myrow['grnbatch'] .'&PONo=' . $_POST['PONumber'] . '">' . _('Reprint Labels') . '</a></td>
 		</tr>';
@@ -114,4 +118,4 @@
 
 include('includes/footer.inc');
 
-?>
\ No newline at end of file
+?>