[Web-erp-svn] SF.net SVN: web-erp:[6574] trunk/PO_SelectOSPurchOrder.php

[<vv...@us...>]

Revision: 6574
          http://sourceforge.net/p/web-erp/reponame/6574
Author:   vvs2012
Date:     2014-02-14 23:13:15 +0000 (Fri, 14 Feb 2014)
Log Message:
-----------
Show all POs when enter PO_SelectOSPurchOrder.php page. Then allow filter by date range

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

Modified: trunk/PO_SelectOSPurchOrder.php
===================================================================
--- trunk/PO_SelectOSPurchOrder.php	2014-02-14 23:09:45 UTC (rev 6573)
+++ trunk/PO_SelectOSPurchOrder.php	2014-02-14 23:13:15 UTC (rev 6574)
@@ -320,8 +320,8 @@
 				INNER JOIN currencies
 				ON suppliers.currcode=currencies.currabrev
 				WHERE purchorderdetails.completed=0
-				AND orddate>='" . FormatDateForSQL($_POST['DateFrom']) . "'
-				AND orddate<='" . FormatDateForSQL($_POST['DateTo']) . "'
+				AND orddate>='" . $DateFrom . "'
+				AND orddate<='" . $DateTo . "'
 				AND purchorders.orderno='" . $OrderNumber . "'
 				GROUP BY purchorders.orderno ASC,
 					suppliers.suppname,
@@ -358,8 +358,8 @@
 						INNER JOIN currencies
 						ON suppliers.currcode=currencies.currabrev
 						WHERE purchorderdetails.completed=0
-						AND orddate>='" . FormatDateForSQL($_POST['DateFrom']) . "'
-						AND orddate<='" . FormatDateForSQL($_POST['DateTo']) . "'
+						AND orddate>='" . $DateFrom . "'
+						AND orddate<='" . $DateTo . "'
 						AND purchorderdetails.itemcode='" . $SelectedStockItem . "'
 						AND purchorders.supplierno='" . $SelectedSupplier . "'
 						AND purchorders.intostocklocation = '" . $_POST['StockLocation'] . "'
@@ -394,8 +394,8 @@
 						INNER JOIN currencies
 						ON suppliers.currcode=currencies.currabrev
 						WHERE purchorderdetails.completed=0
-						AND orddate>='" . FormatDateForSQL($_POST['DateFrom']) . "'
-						AND orddate<='" . FormatDateForSQL($_POST['DateTo']) . "'
+						AND orddate>='" . $DateFrom . "'
+						AND orddate<='" . $DateTo . "'
 						AND purchorders.supplierno='" . $SelectedSupplier . "'
 						AND purchorders.intostocklocation = '" . $_POST['StockLocation'] . "'
 						" . $StatusCriteria . "
@@ -435,8 +435,8 @@
 						INNER JOIN currencies
 						ON suppliers.currcode=currencies.currabrev
 						WHERE purchorderdetails.completed=0
-						AND orddate>='" . FormatDateForSQL($_POST['DateFrom']) . "'
-						AND orddate<='" . FormatDateForSQL($_POST['DateTo']) . "'
+						AND orddate>='" . $DateFrom . "'
+						AND orddate<='" . $DateTo . "'
 						AND purchorderdetails.itemcode='" . $SelectedStockItem . "'
 						AND purchorders.intostocklocation = '" . $_POST['StockLocation'] . "'
 						" . $StatusCriteria . "
@@ -470,8 +470,8 @@
 						INNER JOIN currencies
 						ON suppliers.currcode=currencies.currabrev
 						WHERE purchorderdetails.completed=0
-						AND orddate>='" . FormatDateForSQL($_POST['DateFrom']) . "'
-						AND orddate<='" . FormatDateForSQL($_POST['DateTo']) . "'
+						AND orddate>='" . $DateFrom . "'
+						AND orddate<='" . $DateTo . "'
 						AND purchorders.intostocklocation = '" . $_POST['StockLocation'] . "'
 						" . $StatusCriteria . "
 						GROUP BY purchorders.orderno ASC,