[Web-erp-svn] SF.net SVN: web-erp:[6602] trunk

[<dai...@us...>]

Revision: 6602
          http://sourceforge.net/p/web-erp/reponame/6602
Author:   daintree
Date:     2014-03-06 06:52:11 +0000 (Thu, 06 Mar 2014)
Log Message:
-----------
use DB abstraction function rather than mysql specific function

Modified Paths:
--------------
    trunk/PrintCustStatements.php
    trunk/ReverseGRN.php

Modified: trunk/PrintCustStatements.php
===================================================================
--- trunk/PrintCustStatements.php	2014-03-05 09:14:16 UTC (rev 6601)
+++ trunk/PrintCustStatements.php	2014-03-06 06:52:11 UTC (rev 6602)
@@ -461,7 +461,7 @@
 
         echo '<table class="selection">';
 		echo '<tr><td>' . _('Starting Customer statement to print (Customer code)'). '
-			</td><td><input type="text" maxlength="10" size="8" name="FromCust" value="1" /></td></tr>
+			</td><td><input type="text" maxlength="10" size="8" name="FromCust" value="0" /></td></tr>
 			<tr><td>' .  _('Ending Customer statement to print (Customer code)') . '</td><td>
 				<input type="text" maxlength="10" size="8" name="ToCust" value="zzzzzz" /></td></tr></table>
 				<br /><div class="centre">

Modified: trunk/ReverseGRN.php
===================================================================
--- trunk/ReverseGRN.php	2014-03-05 09:14:16 UTC (rev 6601)
+++ trunk/ReverseGRN.php	2014-03-06 06:52:11 UTC (rev 6602)
@@ -133,7 +133,7 @@
 /*Now the purchorder header status in case it was completed  - now incomplete - just printed */
 	$SQL = "UPDATE purchorders
 			SET status = 'Printed',
-				stat_comment = CONCAT('" . Date($_SESSION['DefaultDateFormat']) . ' ' . _('GRN Reversed for') . ' '  .  mysql_real_escape_string(stripslashes($GRN['itemdescription'])) . ' ' . _('by') . ' ' . $_SESSION['UsersRealName'] . "<br />', stat_comment )
+				stat_comment = CONCAT('" . Date($_SESSION['DefaultDateFormat']) . ' ' . _('GRN Reversed for') . ' '  .  DB_escape_string(stripslashes($GRN['itemdescription'])) . ' ' . _('by') . ' ' . $_SESSION['UsersRealName'] . "<br />', stat_comment )
 			WHERE orderno = '" . $GRN['orderno'] . "'";
 
 	$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The purchase order statusand status comment could not be changed because');