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

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

Revision: 3717
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3717&view=rev
Author:   tim_schofield
Date:     2010-09-08 19:25:29 +0000 (Wed, 08 Sep 2010)

Log Message:
-----------
Screen layout improvements. Correct the sql quoting

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

Modified: trunk/PDFStockCheckComparison.php
===================================================================
--- trunk/PDFStockCheckComparison.php	2010-09-08 07:40:26 UTC (rev 3716)
+++ trunk/PDFStockCheckComparison.php	2010-09-08 19:25:29 UTC (rev 3717)
@@ -110,13 +110,13 @@
 								newqoh)
 						VALUES ('" . $myrow['stockid'] . "',
 							17,
-							" . $AdjustmentNumber . ",
+							'" . $AdjustmentNumber . "',
 							'" . $myrow['loccode'] . "',
 							'" . $SQLAdjustmentDate . "',
-							" . $PeriodNo . ",
+							'" . $PeriodNo . "',
 							'" . _('Inventory Check') . "',
-							" . $StockQtyDifference . ",
-							" . ($QtyOnHandPrior + $StockQtyDifference) . "
+							'" . $StockQtyDifference . "',
+							'" . ($QtyOnHandPrior + $StockQtyDifference) . "'
 						)";
 
 				$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The stock movement record cannot be inserted because');
@@ -124,7 +124,7 @@
 				$Result = DB_query($SQL,$db, $ErrMsg, $DbgMsg, true);
 
 				$SQL = "UPDATE locstock
-						SET quantity = quantity + " . $StockQtyDifference . "
+						SET quantity = quantity + '" . $StockQtyDifference . "'
 						WHERE stockid='" . $myrow['stockid'] . "'
 						AND loccode='" . $myrow['loccode'] . "'";
 				$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The location stock record could not be updated because');
@@ -145,11 +145,11 @@
 									amount,
 									narrative)
 							VALUES (17,
-								" .$AdjustmentNumber . ",
+								'" .$AdjustmentNumber . "',
 								'" . $SQLAdjustmentDate . "',
-								" . $PeriodNo . ",
-								" .  $StockGLCodes['adjglact'] . ",
-								" . $myrow['standardcost'] * -($StockQtyDifference) . ",
+								'" . $PeriodNo . "',
+								'" .  $StockGLCodes['adjglact'] . "',
+								'" . $myrow['standardcost'] * -($StockQtyDifference) . "',
 								'" . $myrow['stockid'] . " x " . $StockQtyDifference . " @ " . $myrow['standardcost'] . " - " . _('Inventory Check') . "')";
 					$Result = DB_query($SQL,$db, $ErrMsg, $DbgMsg, true);
 
@@ -164,11 +164,11 @@
 									amount,
 									narrative)
 							VALUES (17,
-								" .$AdjustmentNumber . ",
+								'" .$AdjustmentNumber . "',
 								'" . $SQLAdjustmentDate . "',
-								" . $PeriodNo . ",
-								" .  $StockGLCodes['stockact'] . ",
-								" . $myrow['standardcost'] * $StockQtyDifference . ", '" . $myrow['stockid'] . " x " . $StockQtyDifference . " @ " . $myrow['standardcost'] . " - " . _('Inventory Check') . "')";
+								'" . $PeriodNo . "',
+								'" .  $StockGLCodes['stockact'] . "',
+								'" . $myrow['standardcost'] * $StockQtyDifference . ", '" . $myrow['stockid'] . " x " . $StockQtyDifference . " @ " . $myrow['standardcost'] . " - " . _('Inventory Check') . "')";
 					$Result = DB_query($SQL,$db, $ErrMsg, $DbgMsg, true);
 
 				} //END INSERT GL TRANS
@@ -347,8 +347,11 @@
 	$title= _('Inventory Comparison Report');
 	include('includes/header.inc');
 
-	echo '<form action="' . $_SERVER['PHP_SELF'] . '" method="POST"><table>';
+	echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/transactions.png" title="' . $title . '" alt=""></img>' . ' '
+		. $title . '</p>';
 
+	echo '<form action="' . $_SERVER['PHP_SELF'] . '" method="POST"><table class=selection>';
+
 	echo '<tr><td>' . _('Choose Option'). ':</font></td><td><select name="ReportOrClose">';
 
 	if ($_POST['ReportOrClose']=='ReportAndClose'){
@@ -372,10 +375,10 @@
 		echo '<option selected VALUE="Leave">' . _("Don't Adjust System stock to Nil");
 	}
 
-	echo '</table><div class="centre"><input type=Submit Name="PrintPDF" Value="' . _('Print PDF'). '"></div>';
+	echo '</table><br><div class="centre"><input type=Submit Name="PrintPDF" Value="' . _('Print PDF'). '"></div>';
 
 	include('includes/footer.inc');
 
 } /*end of else not PrintPDF */
 
-?>
+?>
\ No newline at end of file

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-09-08 07:40:26 UTC (rev 3716)
+++ trunk/doc/Change.log.html	2010-09-08 19:25:29 UTC (rev 3717)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>08/09/10 Tim: PDFStockCheckComparison.php - Screen layout improvements. Correct the sql quoting</p>
 <p>07/09/10 Tim: PDFRemittanceAdvice.php - Correct the sql quoting</p>
 <p>07/09/10 Tim: PDFReceipt.php - Correct the sql quoting</p>
 <p>07/09/10 Tim: PDFQuotation.php - Correct the sql quoting</p>


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