X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep710.php;h=1c2e86ecfd2e62d57f292a1668b6abd6eac4f0a3;hb=11e485e4a7c5f12c9424713b7330815a9cc5e4ae;hp=76f232b71d4fc67d1b8e020002ef6bb66a611aa1;hpb=11861a415cd5166003ee6b150096ccfe2540d138;p=fa-stable.git

diff --git a/reporting/rep710.php b/reporting/rep710.php
index 76f232b7..1c2e86ec 100644
--- 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");