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

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

Revision: 3648
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3648&view=rev
Author:   tim_schofield
Date:     2010-07-20 11:19:57 +0000 (Tue, 20 Jul 2010)

Log Message:
-----------
Daily Transactions listings - Show reports correctly even in mysql strict mode

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

Modified: trunk/PDFCustTransListing.php
===================================================================
--- trunk/PDFCustTransListing.php	2010-07-19 20:49:50 UTC (rev 3647)
+++ trunk/PDFCustTransListing.php	2010-07-20 11:19:57 UTC (rev 3648)
@@ -63,7 +63,7 @@
 		invtext
 	FROM debtortrans
 	WHERE type=" . $_POST['TransType'] . "
-	AND date_format(inputdate, '%Y/%m/%d')='".FormatDateForSQL($_POST['Date'])."'";
+	AND date_format(inputdate, '%Y-%m-%d')='".FormatDateForSQL($_POST['Date'])."'";
 
 $result=DB_query($sql,$db,'','',false,false);
 

Modified: trunk/PDFSuppTransListing.php
===================================================================
--- trunk/PDFSuppTransListing.php	2010-07-19 20:49:50 UTC (rev 3647)
+++ trunk/PDFSuppTransListing.php	2010-07-20 11:19:57 UTC (rev 3648)
@@ -63,7 +63,7 @@
 		transtext
 	FROM supptrans
 	WHERE type=" . $_POST['TransType'] . "
-	AND date_format(inputdate, '%Y/%m/%d')='".FormatDateForSQL($_POST['Date'])."'";
+	AND date_format(inputdate, '%Y-%m-%d')='".FormatDateForSQL($_POST['Date'])."'";
 
 $result=DB_query($sql,$db,'','',false,false);
 

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-07-19 20:49:50 UTC (rev 3647)
+++ trunk/doc/Change.log.html	2010-07-20 11:19:57 UTC (rev 3648)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>20/07/10 Tim: Daily Transactions listings - Show reports correctly even in mysql strict mode</p>
 <p>19/07/10 Tim: FixedassetTransfer.php - Layout changes and sql quoting, use javascript to change location</p>
 <p>19/07/10 Tim: FixedassetLocations.php - Layout changes and sql quoting, proper checks for deletion of location</p>
 <p>19/07/10 Tim: PO_SelectOSPurchOrder.php - Remove order values when security token 12 is not set</p>


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