From a447e177aab18acbaedf8d997b70d0722522c5c0 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Sun, 31 Jan 2010 22:09:57 +0000 Subject: [PATCH] Added cash_sale return form get_payment_term --- admin/db/company_db.inc | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/admin/db/company_db.inc b/admin/db/company_db.inc index 0948546c..bca6a1cc 100644 --- a/admin/db/company_db.inc +++ b/admin/db/company_db.inc @@ -133,9 +133,11 @@ function delete_payment_terms($selected_id) function get_payment_terms($selected_id) { - $sql = "SELECT * FROM ".TB_PREF."payment_terms WHERE terms_indicator=".db_escape($selected_id); + $sql = "SELECT *, (t.days_before_due=0) AND (t.day_in_following_month=0) as cash_sale + FROM ".TB_PREF."payment_terms t WHERE terms_indicator=".db_escape($selected_id); $result = db_query($sql,"could not get payment term"); + return db_fetch($result); } -- 2.30.2