[Web-erp-svn] SF.net SVN: web-erp:[7597] trunk/CustomerInquiry.php

[<te...@us...>]

Revision: 7597
          http://sourceforge.net/p/web-erp/reponame/7597
Author:   tehonu
Date:     2016-08-19 12:03:21 +0000 (Fri, 19 Aug 2016)
Log Message:
-----------
Change in ORDER BY to show transactions in cronological order

Modified Paths:
--------------
    trunk/CustomerInquiry.php

Modified: trunk/CustomerInquiry.php
===================================================================
--- trunk/CustomerInquiry.php	2016-08-18 08:51:16 UTC (rev 7596)
+++ trunk/CustomerInquiry.php	2016-08-19 12:03:21 UTC (rev 7597)
@@ -231,7 +231,8 @@
 				ON salesorders.orderno=debtortrans.order_
 			WHERE debtortrans.debtorno = '" . $CustomerID . "'
 				AND debtortrans.trandate >= '" . $DateAfterCriteria . "'
-				ORDER BY debtortrans.id";
+				ORDER BY debtortrans.trandate,
+					debtortrans.id";
 
 $ErrMsg = _('No transactions were returned by the SQL because');
 $TransResult = DB_query($SQL, $ErrMsg);