X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fincludes%2Fdb%2Fcredit_status_db.inc;h=c80cdc906fdf1fe0a96b1f3b71496951a35c3e1b;hb=f44132511cc91b83f20f91af0625d4b112b4c26e;hp=b011b301966dbfb3e10bd7884d4e3e96bbae485d;hpb=9a1b3abd5371ad7f6315db1d56f8356587444314;p=fa-stable.git diff --git a/sales/includes/db/credit_status_db.inc b/sales/includes/db/credit_status_db.inc index b011b301..c80cdc90 100644 --- a/sales/includes/db/credit_status_db.inc +++ b/sales/includes/db/credit_status_db.inc @@ -13,16 +13,16 @@ function add_credit_status($description, $disallow_invoicing) { $sql = "INSERT INTO ".TB_PREF."credit_status (reason_description, dissallow_invoices) VALUES (".db_escape($description).",".db_escape($disallow_invoicing).")"; - - db_query($sql, "could not add credit status"); + + db_query($sql, "could not add credit status"); } function update_credit_status($status_id, $description, $disallow_invoicing) { $sql = "UPDATE ".TB_PREF."credit_status SET reason_description=".db_escape($description).", dissallow_invoices=".db_escape($disallow_invoicing)." WHERE id=".db_escape($status_id); - - db_query($sql, "could not update credit status"); + + db_query($sql, "could not update credit status"); } function get_all_credit_status($all=false) @@ -31,21 +31,21 @@ function get_all_credit_status($all=false) if (!$all) $sql .= " WHERE !inactive"; return db_query($sql, "could not get all credit status"); -} +} function get_credit_status($status_id) { $sql = "SELECT * FROM ".TB_PREF."credit_status WHERE id=".db_escape($status_id); - + $result = db_query($sql, "could not get credit status"); - + return db_fetch($result); } function delete_credit_status($status_id) { $sql="DELETE FROM ".TB_PREF."credit_status WHERE id=".db_escape($status_id); - - db_query($sql, "could not delete credit status"); + + db_query($sql, "could not delete credit status"); }