X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fincludes%2Fdb%2Fsales_types_db.inc;h=9e462bc2a26c60e9991e3911579b538eaa19dbb7;hb=5dec41f0d87e407e1c9ffcb8eb63b92e4e471a9b;hp=4bde37506bf08cc65b12fe54ff816b6fa8da8ec2;hpb=921b0e7df6265ed280080b7810105fa4d93d9aa6;p=fa-stable.git diff --git a/sales/includes/db/sales_types_db.inc b/sales/includes/db/sales_types_db.inc index 4bde3750..9e462bc2 100644 --- a/sales/includes/db/sales_types_db.inc +++ b/sales/includes/db/sales_types_db.inc @@ -1,12 +1,17 @@ . +***********************************************************************/ function add_sales_type($name, $tax_included, $factor) { - // maximum one base price list - clear_base_sales_type(); - $sql = "INSERT INTO ".TB_PREF."sales_types (sales_type,tax_included,factor) VALUES (".db_escape($name).",'$tax_included',$factor)"; - db_query($sql, "could not add sales type"); } @@ -19,9 +24,11 @@ function update_sales_type($id, $name, $tax_included, $factor) db_query($sql, "could not update sales type"); } -function get_all_sales_types() +function get_all_sales_types($all=false) { $sql = "SELECT * FROM ".TB_PREF."sales_types"; + if (!$all) + $sql .= " WHERE !inactive"; return db_query($sql, "could not get all sales types"); }