projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Mark Inactive Customers and Suppliers in Reports (when no Filter).
[fa-stable.git]
/
reporting
/
rep201.php
diff --git
a/reporting/rep201.php
b/reporting/rep201.php
index 3b7ee708c7dacdad817dae3be7d6c43669eacedf..00c48d5b00d70aad6945e40de5cdf256d6e537af 100644
(file)
--- a/
reporting/rep201.php
+++ b/
reporting/rep201.php
@@
-136,11
+136,11
@@
function print_supplier_balances()
$total = array();
$grandtotal = array(0,0,0,0);
$total = array();
$grandtotal = array(0,0,0,0);
- $sql = "SELECT supplier_id, supp_name AS name, curr_code FROM ".TB_PREF."suppliers";
+ $sql = "SELECT supplier_id, supp_name AS name, curr_code
, inactive
FROM ".TB_PREF."suppliers";
if ($fromsupp != ALL_TEXT)
$sql .= " WHERE supplier_id=".db_escape($fromsupp);
$sql .= " ORDER BY supp_name";
if ($fromsupp != ALL_TEXT)
$sql .= " WHERE supplier_id=".db_escape($fromsupp);
$sql .= " ORDER BY supp_name";
- $result = db_query($sql, "The
custom
ers could not be retrieved");
+ $result = db_query($sql, "The
suppli
ers could not be retrieved");
while ($myrow=db_fetch($result))
{
while ($myrow=db_fetch($result))
{
@@
-164,7
+164,7
@@
function print_supplier_balances()
if ($no_zeros && db_num_rows($res) == 0) continue;
$rep->fontSize += 2;
if ($no_zeros && db_num_rows($res) == 0) continue;
$rep->fontSize += 2;
- $rep->TextCol(0, 2, $myrow['name']);
+ $rep->TextCol(0, 2, $myrow['name']
.($myrow['inactive']==1 ? " ("._("Inactive").")" : "")
);
if ($convert) $rep->TextCol(2, 3, $myrow['curr_code']);
$rep->fontSize -= 2;
$rep->TextCol(3, 4, _("Open Balance"));
if ($convert) $rep->TextCol(2, 3, $myrow['curr_code']);
$rep->fontSize -= 2;
$rep->TextCol(3, 4, _("Open Balance"));