projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Improved Customer and Supplier Balances Report. Option to choose last column as balance.
[fa-stable.git]
/
sales
/
includes
/
db
/
customers_db.inc
diff --git
a/sales/includes/db/customers_db.inc
b/sales/includes/db/customers_db.inc
index b1f834336da10aeeff204fed7f3ab3a1c44b3374..36db9e1a93b453196facf1964841f61629ce7195 100644
(file)
--- a/
sales/includes/db/customers_db.inc
+++ b/
sales/includes/db/customers_db.inc
@@
-177,4
+177,14
@@
function is_new_customer($id)
return !key_in_foreign_table($id, $tables, 'debtor_no');
}
return !key_in_foreign_table($id, $tables, 'debtor_no');
}
+
+function get_customer_by_ref($reference)
+{
+ $sql = "SELECT * FROM ".TB_PREF."debtors_master WHERE debtor_ref=".db_escape($reference);
+
+ $result = db_query($sql, "could not get customer");
+
+ return db_fetch($result);
+}
+
?>
\ No newline at end of file
?>
\ No newline at end of file