[Weberp-svn] SF.net SVN: weberp:[4290] trunk
Brought to you by:
sotandeka,
tim_schofield
|
From: <tim...@us...> - 2011-01-13 19:32:16
|
Revision: 4290
http://weberp.svn.sourceforge.net/weberp/?rev=4290&view=rev
Author: tim_schofield
Date: 2011-01-13 19:32:09 +0000 (Thu, 13 Jan 2011)
Log Message:
-----------
Remove unnecessary year and month from options
Modified Paths:
--------------
trunk/SupplierBalsAtPeriodEnd.php
trunk/includes/SQL_CommonFunctions.inc
Modified: trunk/SupplierBalsAtPeriodEnd.php
===================================================================
--- trunk/SupplierBalsAtPeriodEnd.php 2011-01-13 18:38:17 UTC (rev 4289)
+++ trunk/SupplierBalsAtPeriodEnd.php 2011-01-13 19:32:09 UTC (rev 4290)
@@ -143,12 +143,12 @@
$Periods = DB_query($sql,$db,$ErrMsg);
while ($myrow = DB_fetch_array($Periods,$db)){
- if ($myrow['YearMonth'] == date("Ym")) { // get the current month
-
+ if ($myrow['YearMonth'] == date("Ym")) { // get the current month
+
echo '<option VALUE=' . $myrow['lastdate_in_period'] . ' selected="TRUE">' . MonthAndYearFromSQLDate($myrow['lastdate_in_period'],'M',-1);
}
- else {
- echo '<option VALUE=' . $myrow['lastdate_in_period'] . '> '.$myrow['YearMonth'].' '.MonthAndYearFromSQLDate($myrow['lastdate_in_period']).'</option>';
+ else {
+ echo '<option VALUE=' . $myrow['lastdate_in_period'] . '> '.MonthAndYearFromSQLDate($myrow['lastdate_in_period']).'</option>';
}
}
echo '</select></td></tr>';
@@ -159,4 +159,4 @@
include('includes/footer.inc');
}/*end of else not PrintPDF */
-?>
+?>
\ No newline at end of file
Modified: trunk/includes/SQL_CommonFunctions.inc
===================================================================
--- trunk/includes/SQL_CommonFunctions.inc 2011-01-13 18:38:17 UTC (rev 4289)
+++ trunk/includes/SQL_CommonFunctions.inc 2011-01-13 19:32:09 UTC (rev 4290)
@@ -237,7 +237,7 @@
while ($MyRow=DB_fetch_array($result)){
$NewParent = $MyRow['parent'];
$MaterialCost = BomMaterialCost($NewParent, $db);
- $SQL = 'UPDATE stockmaster SET materialcost=' . $MaterialCost . " WHERE stockid='" . $NewParent . "'";
+ $SQL = "UPDATE stockmaster SET materialcost='" . $MaterialCost . "' WHERE stockid='" . $NewParent . "'";
$result1 = DB_query($SQL,$db);
if (DB_error_no($db)!=0) {
return 1;
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|