[Weberp-cvs] SF.net SVN: web-erp:[3694] trunk

[<tim...@us...>]

Revision: 3694
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3694&view=rev
Author:   tim_schofield
Date:     2010-08-18 17:27:18 +0000 (Wed, 18 Aug 2010)

Log Message:
-----------
Paul Thursby: PO_Items.php - Eliminate query; Moves the ONE field into a query above this point.

Modified Paths:
--------------
    trunk/PO_Items.php
    trunk/doc/Change.log.html

Modified: trunk/PO_Items.php
===================================================================
--- trunk/PO_Items.php	2010-08-15 09:26:03 UTC (rev 3693)
+++ trunk/PO_Items.php	2010-08-18 17:27:18 UTC (rev 3694)
@@ -267,7 +267,8 @@
 						supptel='" . $_SESSION['PO'.$identifier]->supptel . "',
 						contact='" . $_SESSION['PO'.$identifier]->contact . "',
 						paymentterms='" . $_SESSION['PO'.$identifier]->paymentterms . "',
-						allowprint='" . $_SESSION['PO'.$identifier]->AllowPrintPO . "'
+						allowprint='" . $_SESSION['PO'.$identifier]->AllowPrintPO . "',
+						status = '" . PurchOrder::STATUS_PENDING . "'
 						WHERE orderno = '" . $_SESSION['PO'.$identifier]->OrderNo ."'";
 
 			$ErrMsg =  _('The purchase order could not be updated because');
@@ -276,9 +277,6 @@
 
 			/*Now Update the purchase order detail records */
 			foreach ($_SESSION['PO'.$identifier]->LineItems as $POLine) {
-				$sql="UPDATE purchorders
-                      SET status = '" . PurchOrder::STATUS_PENDING . "'
-                      WHERE orderno = '" . $_SESSION['PO'.$identifier]->OrderNo . "'";
 				$result=DB_query($sql,$db,'','',true);
 				if ($POLine->Deleted==true) {
 					if ($POLine->PODetailRec!='') {

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-08-15 09:26:03 UTC (rev 3693)
+++ trunk/doc/Change.log.html	2010-08-18 17:27:18 UTC (rev 3694)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>18/08/10 Paul Thursby: PO_Items.php - Eliminate query; Moves the ONE field into a query above this point.</p>
 <p>15/08/10 Phil: Decided to have contracts as part of orders module since not really enough links to warrant a new module changes to index.php WWW_Users.php and sql upgrade.
 <p>15/08/10 Phil: New script for ContractCosting.php comparison of contract costs budgeted vs incurred. Lot of work on contracts
 <p>13/08/10 Phil: DefineSuppTransClass.php SupplierInvoice.php and SupplierCredit.php now allow entry of contract charges. New script for SuppContractChgs.php


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.