3 function add_item_tax_type($name, $exempt, $exempt_from)
7 $sql = "INSERT INTO ".TB_PREF."item_tax_types (name, exempt)
8 VALUES ('$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='$name', exempt=$exempt WHERE id=$id";
26 db_query($sql, "could not update item tax type");
28 // readd the exemptions
29 delete_item_tax_type_exemptions($id);
30 add_item_tax_type_exemptions($id, $exempt_from);
35 function get_all_item_tax_types()
37 $sql = "SELECT * FROM ".TB_PREF."item_tax_types";
39 return db_query($sql, "could not get all item tax type");
42 function get_item_tax_type($id)
44 $sql = "SELECT * FROM ".TB_PREF."item_tax_types WHERE id=$id";
46 $result = db_query($sql, "could not get item tax type");
48 return db_fetch($result);
51 function get_item_tax_type_for_item($stock_id)
53 $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'
54 AND ".TB_PREF."item_tax_types.id=".TB_PREF."stock_master.tax_type_id";
56 $result = db_query($sql, "could not get item tax type");
58 return db_fetch($result);
61 function delete_item_tax_type($id)
65 $sql = "DELETE FROM ".TB_PREF."item_tax_types WHERE id=$id";
67 db_query($sql, "could not delete item tax type");
68 // also delete all exemptions
69 delete_item_tax_type_exemptions($id);
74 function add_item_tax_type_exemptions($id, $exemptions)
76 for ($i = 0; $i < count($exemptions); $i++)
78 $sql = "INSERT INTO ".TB_PREF."item_tax_type_exemptions (item_tax_type_id, tax_type_id)
79 VALUES ($id, " . $exemptions[$i] . ")";
80 db_query($sql, "could not add item tax type exemptions");
84 function delete_item_tax_type_exemptions($id)
86 $sql = "DELETE FROM ".TB_PREF."item_tax_type_exemptions WHERE item_tax_type_id=$id";
88 db_query($sql, "could not delete item tax type exemptions");
91 function get_item_tax_type_exemptions($id)
93 $sql = "SELECT * FROM ".TB_PREF."item_tax_type_exemptions WHERE item_tax_type_id=$id";
95 return db_query($sql, "could not get item tax type exemptions");