From: <tim...@us...> - 2010-11-05 11:08:05
|
Revision: 4142 http://web-erp.svn.sourceforge.net/web-erp/?rev=4142&view=rev Author: tim_schofield Date: 2010-11-05 11:07:59 +0000 (Fri, 05 Nov 2010) Log Message: ----------- Converted field name to lower case for consistency Modified Paths: -------------- trunk/PurchData.php trunk/doc/Change.log.html Modified: trunk/PurchData.php =================================================================== --- trunk/PurchData.php 2010-11-05 11:03:04 UTC (rev 4141) +++ trunk/PurchData.php 2010-11-05 11:07:59 UTC (rev 4142) @@ -80,7 +80,7 @@ supplierdescription, suppliers_partno, leadtime, - MinOrderQty, + minorderqty, preferred) VALUES ('" . $SupplierID . "', '" . $StockID . "', @@ -107,7 +107,7 @@ supplierdescription='" . $_POST['SupplierDescription'] . "', suppliers_partno='" . $_POST['SupplierCode'] . "', leadtime='" . $_POST['LeadTime'] . "', - MinOrderQty='" . $_POST['MinOrderQty'] . "', + minorderqty='" . $_POST['MinOrderQty'] . "', preferred='" . $_POST['Preferred'] . "' WHERE purchdata.stockid='".$StockID."' AND purchdata.supplierno='".$SupplierID."' @@ -156,7 +156,7 @@ purchdata.supplierdescription, purchdata.leadtime, purchdata.suppliers_partno, - purchdata.MinOrderQty, + purchdata.minorderqty, purchdata.preferred FROM purchdata INNER JOIN suppliers ON purchdata.supplierno=suppliers.supplierid @@ -176,7 +176,7 @@ <th>' . _('Currency') . '</th> <th>' . _('Effective From') . '</th> <th>' . _('Supplier Unit') . '</th> - <th>' . _('Min Order Qty') . '</th> + <th>' . _('Min Order Qty') . '</th> <th>' . _('Lead Time') . '</th> <th>' . _('Preferred') . '</th> </tr>'; @@ -209,7 +209,7 @@ <td>%s</td> <td><a href='%s?%s&StockID=%s&SupplierID=%s&Edit=1&EffectiveFrom=%s'>" . _('Edit') . "</a></td> <td><a href='%s?%s&StockID=%s&SupplierID=%s&Delete=1&EffectiveFrom=%s' onclick=\"return confirm('" . _('Are you sure you wish to delete this suppliers price?') . "');\">" . _('Delete') . "</a></td> - </tr>", $myrow['suppname'], number_format($myrow['price'], 3), $myrow['currcode'], ConvertSQLDate($myrow['effectivefrom']), $myrow['unitname'],$myrow['MinOrderQty'], $myrow['leadtime'], $DisplayPreferred, $_SERVER['PHP_SELF'], SID, $StockID, $myrow['supplierno'], $myrow['effectivefrom'], $_SERVER['PHP_SELF'], SID, $StockID, $myrow['supplierno'], $myrow['effectivefrom']); + </tr>", $myrow['suppname'], number_format($myrow['price'], 3), $myrow['currcode'], ConvertSQLDate($myrow['effectivefrom']), $myrow['unitname'],$myrow['minorderqty'], $myrow['leadtime'], $DisplayPreferred, $_SERVER['PHP_SELF'], SID, $StockID, $myrow['supplierno'], $myrow['effectivefrom'], $_SERVER['PHP_SELF'], SID, $StockID, $myrow['supplierno'], $myrow['effectivefrom']); } //end of while loop echo '</table><br/>'; if ($CountPreferreds > 1) { @@ -364,7 +364,7 @@ purchdata.leadtime, purchdata.conversionfactor, purchdata.suppliers_partno, - purchdata.MinOrderQty, + purchdata.minorderqty, purchdata.preferred, stockmaster.units FROM purchdata INNER JOIN suppliers @@ -386,7 +386,7 @@ $_POST['LeadTime'] = $myrow['leadtime']; $_POST['ConversionFactor'] = $myrow['conversionfactor']; $_POST['Preferred'] = $myrow['preferred']; - $_POST['MinOrderQty'] = $myrow['MinOrderQty']; + $_POST['MinOrderQty'] = $myrow['minorderqty']; $_POST['SupplierCode'] = $myrow['suppliers_partno']; $stockuom=$myrow['units']; } Modified: trunk/doc/Change.log.html =================================================================== --- trunk/doc/Change.log.html 2010-11-05 11:03:04 UTC (rev 4141) +++ trunk/doc/Change.log.html 2010-11-05 11:07:59 UTC (rev 4142) @@ -1,8 +1,9 @@ <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p> <p></p> -<p>02/11/10 Tim: SelectProduct.php. Change the standard order quantities to agree with Minimum order qty</p> -<p>02/11/10 Tim: PurchData.php. Make the Minimum order quantity field numeric only</p> -<p>02/11/10 Poul Bjerre-Jensen: SelectProduct.php,PurchData.php. Add in Minimum order quantity to Purchasing data</p> +<p>05/11/10 Tim: PurchData.php. Converted field name to lower case for consistency</p> +<p>05/11/10 Tim: SelectProduct.php. Change the standard order quantities to agree with Minimum order qty</p> +<p>05/11/10 Tim: PurchData.php. Make the Minimum order quantity field numeric only</p> +<p>05/11/10 Poul Bjerre-Jensen: SelectProduct.php,PurchData.php. Add in Minimum order quantity to Purchasing data</p> <p>02/11/10 Tim: SelectCustomer.php. Correction to work with debtors that have a - in the code</p> <p>31/10/10 Tim: SuppTransGLAnalysis.php. Minor bug fixes</p> <p>31/10/10 Tim: SuppTransGLAnalysis.php. Force the user to select a GL account code instaed of defaulting to first on the list</p> This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |