3 function add_dimension($reference, $name, $type_, $date_, $due_date, $memo_)
7 $date = date2sql($date_);
8 $duedate = date2sql($due_date);
10 $sql = "INSERT INTO ".TB_PREF."dimensions (reference, name, type_, date_, due_date)
11 VALUES ('$reference', '$name', $type_, '$date', '$duedate')";
12 db_query($sql, "could not add dimension");
16 add_comments(systypes::dimension(), $id, $date_, $memo_);
18 add_forms_for_sys_type(systypes::dimension(), $id);
20 references::save_last($reference, systypes::dimension());
27 function update_dimension($id, $name, $type_, $date_, $due_date, $memo_)
31 $date = date2sql($date_);
32 $duedate = date2sql($due_date);
34 $sql = "UPDATE ".TB_PREF."dimensions SET name='$name',
40 db_query($sql, "could not update dimension");
42 update_comments(systypes::dimension(), $id, null, $memo_);
49 function delete_dimension($id)
53 // delete the actual dimension
54 $sql="DELETE FROM ".TB_PREF."dimensions WHERE id=$id";
55 db_query($sql,"The dimension could not be deleted");
57 delete_comments(systypes::dimension(), $id);
59 delete_forms_for_systype(systypes::dimension(), $id);
64 //--------------------------------------------------------------------------------------
66 function get_dimension($id, $allow_null=false)
68 $sql = "SELECT * FROM ".TB_PREF."dimensions WHERE id=$id";
70 $result = db_query($sql, "The dimension could not be retrieved");
72 if (!$allow_null && db_num_rows($result) == 0)
73 display_db_error("Could not find dimension $id", $sql);
75 return db_fetch($result);
78 //--------------------------------------------------------------------------------------
80 function get_dimension_string($id, $html=false, $space=' ')
91 $row = get_dimension($id, true);
92 $dim = $row['reference'] . $space . $row['name'];
98 //--------------------------------------------------------------------------------------
100 function get_dimensions()
102 $sql = "SELECT * FROM ".TB_PREF."dimensions ORDER BY date_";
104 return db_query($sql, "The dimensions could not be retrieved");
107 //--------------------------------------------------------------------------------------
109 function dimension_has_deposits($id)
111 return dimension_has_payments($id);
114 //--------------------------------------------------------------------------------------
116 function dimension_has_payments($id)
118 $sql = "SELECT SUM(amount) FROM ".TB_PREF."gl_trans WHERE dimension_id = $id";
119 $res = db_query($sql, "Transactions could not be calculated");
120 $row = db_fetch_row($res);
121 return ($row[0] != 0.0);
124 function dimension_is_closed($id)
126 $result = get_dimension($id);
127 return ($result['closed'] == '1');
130 //--------------------------------------------------------------------------------------
132 function close_dimension($id)
134 $sql = "UPDATE ".TB_PREF."dimensions SET closed='1' WHERE id = $id";
135 db_query($sql, "could not close dimension");
138 //--------------------------------------------------------------------------------------