projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Added transaction ref display in cust/supp payments.
[fa-stable.git]
/
purchasing
/
includes
/
db
/
suppalloc_db.inc
diff --git
a/purchasing/includes/db/suppalloc_db.inc
b/purchasing/includes/db/suppalloc_db.inc
index a68c9cfe6ee481845d96c0ca678cc61467e9524f..959be3e2f2d6a1274737a739c27fb4a838df62a9 100644
(file)
--- a/
purchasing/includes/db/suppalloc_db.inc
+++ b/
purchasing/includes/db/suppalloc_db.inc
@@
-170,7
+170,7
@@
function get_allocatable_to_supp_transactions($supplier_id, $trans_no=null, $typ
{
$sql = get_alloc_supp_sql(null, "round(ABS(ov_amount+ov_gst+ov_discount)-alloc,6) > 0
AND trans.type != ".ST_SUPPAYMENT."
{
$sql = get_alloc_supp_sql(null, "round(ABS(ov_amount+ov_gst+ov_discount)-alloc,6) > 0
AND trans.type != ".ST_SUPPAYMENT."
- AND trans.supplier_id=
$supplier_id"
);
+ AND trans.supplier_id=
".db_escape($supplier_id)
);
}
return db_query($sql." ORDER BY trans_no", "Cannot retreive alloc to transactions");
}
return db_query($sql." ORDER BY trans_no", "Cannot retreive alloc to transactions");