3 function add_account_type($name, $class_id, $parent)
5 $sql = "INSERT INTO ".TB_PREF."chart_types (name, class_id, parent)
6 VALUES (".db_escape($name).", $class_id, $parent)";
8 db_query($sql, "could not add account type");
11 function update_account_type($id, $name, $class_id, $parent)
13 $sql = "UPDATE ".TB_PREF."chart_types SET name=".db_escape($name).",
14 class_id=$class_id, parent=$parent WHERE id = $id";
16 db_query($sql, "could not update account type");
19 function get_account_types()
21 $sql = "SELECT * FROM ".TB_PREF."chart_types ORDER BY class_id, id";
23 return db_query($sql, "could not get account types");
26 function get_account_type($id)
28 $sql = "SELECT * FROM ".TB_PREF."chart_types WHERE id = $id";
30 $result = db_query($sql, "could not get account type");
32 return db_fetch($result);
35 function get_account_type_name($id)
37 $sql = "SELECT name FROM ".TB_PREF."chart_types WHERE id = $id";
39 $result = db_query($sql, "could not get account type");
41 $row = db_fetch_row($result);
46 function delete_account_type($id)
48 $sql = "DELETE FROM ".TB_PREF."chart_types WHERE id = $id";
50 db_query($sql, "could not delete account type");
53 function add_account_class($id, $name, $balance)
55 $sql = "INSERT INTO ".TB_PREF."chart_class (cid, class_name, balance_sheet)
56 VALUES ($id, ".db_escape($name).", $balance)";
58 db_query($sql, "could not add account type");
61 function update_account_class($id, $name, $balance)
63 $sql = "UPDATE ".TB_PREF."chart_class SET class_name=".db_escape($name).",
64 balance_sheet=$balance WHERE cid = $id";
66 db_query($sql, "could not update account type");
69 function get_account_classes()
71 $sql = "SELECT * FROM ".TB_PREF."chart_class ORDER BY cid";
73 return db_query($sql, "could not get account types");
76 function get_account_class($id)
78 $sql = "SELECT * FROM ".TB_PREF."chart_class WHERE cid = $id";
80 $result = db_query($sql, "could not get account type");
82 return db_fetch($result);
85 function get_account_class_name($id)
87 $sql = "SELECT class_name FROM ".TB_PREF."chart_class WHERE cid = $id";
89 $result = db_query($sql, "could not get account type");
91 $row = db_fetch_row($result);
96 function delete_account_class($id)
98 $sql = "DELETE FROM ".TB_PREF."chart_class WHERE cid = $id";
100 db_query($sql, "could not delete account type");