projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Cannot insert a supplier transaction record in Direct Supplier Invoice (certain MySql...
[fa-stable.git]
/
reporting
/
rep201.php
diff --git
a/reporting/rep201.php
b/reporting/rep201.php
index 1c1ee43839ef40cc80b831805a6d3a0222a61af6..4004c8a219c335bb279198fb0ff014c5e721bd08 100644
(file)
--- a/
reporting/rep201.php
+++ b/
reporting/rep201.php
@@
-96,7
+96,7
@@
function print_supplier_balances()
else
include_once($path_to_root . "/reporting/includes/pdf_report.inc");
else
include_once($path_to_root . "/reporting/includes/pdf_report.inc");
- if ($fromsupp == ALL_
NUMERIC
)
+ if ($fromsupp == ALL_
TEXT
)
$supp = _('All');
else
$supp = get_supplier_name($fromsupp);
$supp = _('All');
else
$supp = get_supplier_name($fromsupp);
@@
-136,7
+136,7
@@
function print_supplier_balances()
$grandtotal = array(0,0,0,0);
$sql = "SELECT supplier_id, supp_name AS name, curr_code FROM ".TB_PREF."suppliers";
$grandtotal = array(0,0,0,0);
$sql = "SELECT supplier_id, supp_name AS name, curr_code FROM ".TB_PREF."suppliers";
- if ($fromsupp != ALL_
NUMERIC
)
+ if ($fromsupp != ALL_
TEXT
)
$sql .= " WHERE supplier_id=".db_escape($fromsupp);
$sql .= " ORDER BY supp_name";
$result = db_query($sql, "The customers could not be retrieved");
$sql .= " WHERE supplier_id=".db_escape($fromsupp);
$sql .= " ORDER BY supp_name";
$result = db_query($sql, "The customers could not be retrieved");
@@
-175,7
+175,7
@@
function print_supplier_balances()
$rep->Line($rep->row + 4);
while ($trans=db_fetch($res))
{
$rep->Line($rep->row + 4);
while ($trans=db_fetch($res))
{
- if ($no_zeros &&
$trans['TotalAmount'] == 0 && $trans['Allocated']
== 0) continue;
+ if ($no_zeros &&
floatcmp(abs($trans['TotalAmount']), $trans['Allocated'])
== 0) continue;
$rep->NewLine(1, 2);
$rep->TextCol(0, 1, $systypes_array[$trans['type']]);
$rep->TextCol(1, 2, $trans['reference']);
$rep->NewLine(1, 2);
$rep->TextCol(0, 1, $systypes_array[$trans['type']]);
$rep->TextCol(1, 2, $trans['reference']);