Report Audit Trail. Added totals when type != -1.
authorJoe Hunt <joe.hunt.consulting@gmail.com>
Mon, 16 Nov 2020 07:54:34 +0000 (08:54 +0100)
committerJoe Hunt <joe.hunt.consulting@gmail.com>
Mon, 16 Nov 2020 07:54:34 +0000 (08:54 +0100)
reporting/rep710.php

index d0cb82bfbfbd47e77f4f48e1faa58f8bba67e2de..fdf1db846a1ea9a28f38dd89bb099cf137e6a3ae 100644 (file)
@@ -96,6 +96,7 @@ function print_audit_trail()
 
     $trans = getTransactions($from, $to, $systype, $user);
 
+       $tot_amount = 0;
     while ($myrow=db_fetch($trans))
     {
         $rep->TextCol(0, 1, sql2date(date("Y-m-d", $myrow['unix_stamp'])));
@@ -112,11 +113,19 @@ function print_audit_trail()
         else
                $action = _('Closed');
         $rep->TextCol(6, 7, $action);
-        if ($myrow['amount'] != null)
+        if ($myrow['amount'] != null) {
                $rep->AmountCol(7, 8, $myrow['amount'], $dec);
+                       if ($systype != -1)
+                               $tot_amount += $myrow['amount'];
+               }
         $rep->NewLine(1, 2);
     }
     $rep->Line($rep->row  + 4);
+       if ($systype != -1) {
+        $rep->NewLine(1, 2);
+        $rep->TextCol(6, 7, _('Total'));
+               $rep->AmountCol(7, 8, $tot_amount, $dec);
+       }
     $rep->End();
 }