From 718ed983de9e42792408e11aad5da10c05472148 Mon Sep 17 00:00:00 2001 From: Joe Date: Wed, 1 Oct 2014 23:08:26 +0200 Subject: [PATCH] Improved layout Reports Customer / Supplier Balances. --- reporting/rep101.php | 8 ++++---- reporting/rep201.php | 6 ++++-- 2 files changed, 8 insertions(+), 6 deletions(-) diff --git a/reporting/rep101.php b/reporting/rep101.php index 74b355d8..3584a025 100644 --- a/reporting/rep101.php +++ b/reporting/rep101.php @@ -142,7 +142,6 @@ function print_customer_balances() $sql .= "WHERE debtor_no=".db_escape($fromcust); $sql .= " ORDER BY name"; $result = db_query($sql, "The customers could not be retrieved"); - $num_lines = 0; while ($myrow = db_fetch($result)) { @@ -166,7 +165,6 @@ function print_customer_balances() $res = get_transactions($myrow['debtor_no'], $from, $to); if ($no_zeros && db_num_rows($res) == 0) continue; - $num_lines++; $rep->fontSize += 2; $rep->TextCol(0, 2, $myrow['name']); if ($convert) @@ -184,9 +182,11 @@ function print_customer_balances() $grandtotal[$i] += $init[$i]; } $rep->NewLine(1, 2); - if (db_num_rows($res)==0) - continue; $rep->Line($rep->row + 4); + if (db_num_rows($res)==0) { + $rep->NewLine(1, 2); + continue; + } while ($trans = db_fetch($res)) { if ($no_zeros && floatcmp($trans['TotalAmount'], $trans['Allocated']) == 0) continue; diff --git a/reporting/rep201.php b/reporting/rep201.php index 1d25b8af..3a1288ac 100644 --- a/reporting/rep201.php +++ b/reporting/rep201.php @@ -174,9 +174,11 @@ function print_supplier_balances() $grandtotal[$i] += $init[$i]; } $rep->NewLine(1, 2); - if (db_num_rows($res)==0) continue; - $rep->Line($rep->row + 4); + if (db_num_rows($res)==0) { + $rep->NewLine(1, 2); + continue; + } while ($trans=db_fetch($res)) { if ($no_zeros && floatcmp(abs($trans['TotalAmount']), $trans['Allocated']) == 0) continue; -- 2.30.2