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