3 function add_item_tax_type($name, $exempt, $exempt_from)
7 $sql = "INSERT INTO ".TB_PREF."item_tax_types (name, exempt)
8 VALUES (".db_escape($name).",$exempt)";
10 db_query($sql, "could not add item tax type");
15 add_item_tax_type_exemptions($id, $exempt_from);
20 function update_item_tax_type($id, $name, $exempt, $exempt_from)
24 $sql = "UPDATE ".TB_PREF."item_tax_types SET name=".db_escape($name).
25 ", exempt=$exempt WHERE id=$id";
27 db_query($sql, "could not update item tax type");
29 // readd the exemptions
30 delete_item_tax_type_exemptions($id);
31 add_item_tax_type_exemptions($id, $exempt_from);
36 function get_all_item_tax_types()
38 $sql = "SELECT * FROM ".TB_PREF."item_tax_types";
40 return db_query($sql, "could not get all item tax type");
43 function get_item_tax_type($id)
45 $sql = "SELECT * FROM ".TB_PREF."item_tax_types WHERE id=$id";
47 $result = db_query($sql, "could not get item tax type");
49 return db_fetch($result);
52 function get_item_tax_type_for_item($stock_id)
54 $sql = "SELECT ".TB_PREF."item_tax_types.* FROM ".TB_PREF."item_tax_types,".TB_PREF."stock_master WHERE ".TB_PREF."stock_master.stock_id='$stock_id'
55 AND ".TB_PREF."item_tax_types.id=".TB_PREF."stock_master.tax_type_id";
57 $result = db_query($sql, "could not get item tax type");
59 return db_fetch($result);
62 function delete_item_tax_type($id)
66 $sql = "DELETE FROM ".TB_PREF."item_tax_types WHERE id=$id";
68 db_query($sql, "could not delete item tax type");
69 // also delete all exemptions
70 delete_item_tax_type_exemptions($id);
75 function add_item_tax_type_exemptions($id, $exemptions)
77 for ($i = 0; $i < count($exemptions); $i++)
79 $sql = "INSERT INTO ".TB_PREF."item_tax_type_exemptions (item_tax_type_id, tax_type_id)
80 VALUES ($id, " . $exemptions[$i] . ")";
81 db_query($sql, "could not add item tax type exemptions");
85 function delete_item_tax_type_exemptions($id)
87 $sql = "DELETE FROM ".TB_PREF."item_tax_type_exemptions WHERE item_tax_type_id=$id";
89 db_query($sql, "could not delete item tax type exemptions");
92 function get_item_tax_type_exemptions($id)
94 $sql = "SELECT * FROM ".TB_PREF."item_tax_type_exemptions WHERE item_tax_type_id=$id";
96 return db_query($sql, "could not get item tax type exemptions");