Added confirmation js dialogs for deleting and restoring backup file.

[fa-stable.git] / reporting / rep710.php

diff --git a/reporting/rep710.php b/reporting/rep710.php
index 76f232b71d4fc67d1b8e020002ef6bb66a611aa1..1c2e86ecfd2e62d57f292a1668b6abd6eac4f0a3 100644 (file)
--- a/reporting/rep710.php
+++ b/reporting/rep710.php
@@ -9,12 +9,12 @@
     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
 ***********************************************************************/
-$page_security = 15;
+$page_security = 'SA_GLANALYTIC';
 // ----------------------------------------------------------------
 // $ Revision: 2.0 $
 // Creator:    Joe Hunt
 // date_:      2005-05-19
-// Title:      List of Journal Entries
+// Title:      Audit Trail
 // ----------------------------------------------------------------
 $path_to_root="..";
 
@@ -30,8 +30,8 @@ print_audit_trail();
 
 function getTransactions($from, $to, $type, $user)
 {
-       $fromdate = date2sql($from);
-       $todate = date2sql($to);
+       $fromdate = date2sql($from) . " 00:00:00";
+       $todate = date2sql($to). " 23:59.59";
 
        $sql = "SELECT a.*, 
                SUM(IF(ISNULL(g.amount), NULL, IF(g.amount > 0, g.amount, 0))) AS amount,
@@ -45,8 +45,8 @@ function getTransactions($from, $to, $type, $user)
                $sql .= "AND a.type=$type ";
        if ($user != -1)        
                $sql .= "AND a.user='$user' ";
-       $sql .= "AND DATE(a.stamp) >= '$fromdate'
-                       AND DATE(a.stamp) <= '$todate'
+       $sql .= "AND a.stamp >= '$fromdate'
+                       AND a.stamp <= '$todate'
                GROUP BY a.trans_no,a.gl_seq,a.stamp    
                ORDER BY a.stamp,a.gl_seq";
     return db_query($sql,"No transactions were returned");