X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=taxes%2Fdb%2Ftax_groups_db.inc;h=df48e0a1793d3b6a370825df7c7f4aaa0535cb8a;hb=4a66afcbed7fb883d00c1a6a807497ccfd181378;hp=10f0256a2e4654826d50815ff76aa8ee8eec4c6e;hpb=5928cc0bb4164cfd1dfc77f279f6b12d7806294f;p=fa-stable.git diff --git a/taxes/db/tax_groups_db.inc b/taxes/db/tax_groups_db.inc index 10f0256a..df48e0a1 100644 --- a/taxes/db/tax_groups_db.inc +++ b/taxes/db/tax_groups_db.inc @@ -1,5 +1,14 @@ . +***********************************************************************/ function clear_shipping_tax_group() { $sql = "UPDATE ".TB_PREF."tax_groups SET tax_shipping=0 WHERE 1"; db_query($sql, "could not update tax_shipping fields"); @@ -38,9 +47,10 @@ function update_tax_group($id, $name, $tax_shipping, $taxes, $rates) commit_transaction(); } -function get_all_tax_groups() +function get_all_tax_groups($all=false) { $sql = "SELECT * FROM ".TB_PREF."tax_groups"; + if (!$all) $sql .= " WHERE !inactive"; return db_query($sql, "could not get all tax group"); }