X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fincludes%2Fdb%2Fcredit_status_db.inc;h=c80cdc906fdf1fe0a96b1f3b71496951a35c3e1b;hb=6c40a3be4a79826087d7abbdd11b483f19decc2a;hp=e60d8cfaf4fd6c25d292e9973542def65a2a2488;hpb=e29ab37ef51f39c200c3772e07eeceef0ce39214;p=fa-stable.git

diff --git a/sales/includes/db/credit_status_db.inc b/sales/includes/db/credit_status_db.inc
index e60d8cfa..c80cdc90 100644
--- a/sales/includes/db/credit_status_db.inc
+++ b/sales/includes/db/credit_status_db.inc
@@ -13,39 +13,39 @@ 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()
+function get_all_credit_status($all=false)
 {
 	$sql = "SELECT * FROM ".TB_PREF."credit_status";
-	
+	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");
 }
 
-?>
\ No newline at end of file