[Web-erp-svn] SF.net SVN: web-erp:[7583] trunk/PO_Items.php

[<te...@us...>]

Revision: 7583
          http://sourceforge.net/p/web-erp/reponame/7583
Author:   tehonu
Date:     2016-08-09 07:17:19 +0000 (Tue, 09 Aug 2016)
Log Message:
-----------
Fixed bug showing N rows instead of 1 when SepplierItemsOnly = on

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

Modified: trunk/PO_Items.php
===================================================================
--- trunk/PO_Items.php	2016-08-06 21:44:43 UTC (rev 7582)
+++ trunk/PO_Items.php	2016-08-09 07:17:19 UTC (rev 7583)
@@ -871,9 +871,9 @@
 						AND stockmaster.discontinued<>1
 						AND purchdata.supplierno='" . $_SESSION['PO'.$identifier]->SupplierID . "'
 						AND stockmaster.description " . LIKE . " '" . $SearchString ."'
-						ORDER BY stockmaster.stockid ";
+						GROUP BY stockmaster.stockid
+						ORDER BY stockmaster.stockid";
 			} else { // not just supplier purchdata items
-
 				$sql = "SELECT stockmaster.stockid,
 							stockmaster.description,
 							stockmaster.units
@@ -904,6 +904,7 @@
 						AND stockmaster.discontinued<>1
 						AND stockmaster.description " . LIKE . " '". $SearchString ."'
 						AND stockmaster.categoryid='" . $_POST['StockCat'] . "'
+						GROUP BY stockmaster.stockid
 						ORDER BY stockmaster.stockid ";
 			} else {
 				$sql = "SELECT stockmaster.stockid,
@@ -942,6 +943,7 @@
 						AND purchdata.supplierno='" . $_SESSION['PO'.$identifier]->SupplierID . "'
 						AND stockmaster.discontinued<>1
 						AND stockmaster.stockid " . LIKE . " '" . $_POST['StockCode'] . "'
+						GROUP BY stockmaster.stockid
 						ORDER BY stockmaster.stockid ";
 			} else {
 				$sql = "SELECT stockmaster.stockid,
@@ -974,6 +976,7 @@
 						and stockmaster.discontinued<>1
 						AND stockmaster.stockid " . LIKE  . " '" . $_POST['StockCode'] . "'
 						AND stockmaster.categoryid='" . $_POST['StockCat'] . "'
+						GROUP BY stockmaster.stockid
 						ORDER BY stockmaster.stockid ";
 			} else {
 				$sql = "SELECT stockmaster.stockid,
@@ -1008,6 +1011,7 @@
 						AND stockmaster.mbflag<>'G'
 						AND purchdata.supplierno='" . $_SESSION['PO'.$identifier]->SupplierID . "'
 						AND stockmaster.discontinued<>1
+						GROUP BY stockmaster.stockid
 						ORDER BY stockmaster.stockid ";
 			} else {
 				$sql = "SELECT stockmaster.stockid,
@@ -1038,6 +1042,7 @@
 						AND purchdata.supplierno='" . $_SESSION['PO'.$identifier]->SupplierID . "'
 						AND stockmaster.discontinued<>1
 						AND stockmaster.categoryid='" . $_POST['StockCat'] . "'
+						GROUP BY stockmaster.stockid
 						ORDER BY stockmaster.stockid ";
 			} else {
 				$sql = "SELECT stockmaster.stockid,