projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
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>.
***********************************************************************/
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
// ----------------------------------------------------------------
// $ Revision: 2.0 $
// Creator: Joe Hunt
// date_: 2005-05-19
-// Title:
List of Journal Entries
+// Title:
Audit Trail
// ----------------------------------------------------------------
$path_to_root="..";
// ----------------------------------------------------------------
$path_to_root="..";
@@
-30,8
+30,8
@@
print_audit_trail();
function getTransactions($from, $to, $type, $user)
{
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,
$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 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");
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");