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 (".db_escape($reference).", ".db_escape($name).", $type_, '$date', '$duedate')";
12 db_query($sql, "could not add dimension");
16 add_comments(systypes::dimension(), $id, $date_, $memo_);
18 references::save_last($reference, systypes::dimension());
25 function update_dimension($id, $name, $type_, $date_, $due_date, $memo_)
29 $date = date2sql($date_);
30 $duedate = date2sql($due_date);
32 $sql = "UPDATE ".TB_PREF."dimensions SET name=".db_escape($name).",
38 db_query($sql, "could not update dimension");
40 update_comments(systypes::dimension(), $id, null, $memo_);
47 function delete_dimension($id)
51 // delete the actual dimension
52 $sql="DELETE FROM ".TB_PREF."dimensions WHERE id=$id";
53 db_query($sql,"The dimension could not be deleted");
55 delete_comments(systypes::dimension(), $id);
60 //--------------------------------------------------------------------------------------
62 function get_dimension($id, $allow_null=false)
64 $sql = "SELECT * FROM ".TB_PREF."dimensions WHERE id=$id";
66 $result = db_query($sql, "The dimension could not be retrieved");
68 if (!$allow_null && db_num_rows($result) == 0)
69 display_db_error("Could not find dimension $id", $sql);
71 return db_fetch($result);
74 //--------------------------------------------------------------------------------------
76 function get_dimension_string($id, $html=false, $space=' ')
87 $row = get_dimension($id, true);
88 $dim = $row['reference'] . $space . $row['name'];
94 //--------------------------------------------------------------------------------------
96 function get_dimensions()
98 $sql = "SELECT * FROM ".TB_PREF."dimensions ORDER BY date_";
100 return db_query($sql, "The dimensions could not be retrieved");
103 //--------------------------------------------------------------------------------------
105 function dimension_has_deposits($id)
107 return dimension_has_payments($id);
110 //--------------------------------------------------------------------------------------
112 function dimension_has_payments($id)
114 $sql = "SELECT SUM(amount) FROM ".TB_PREF."gl_trans WHERE dimension_id = $id";
115 $res = db_query($sql, "Transactions could not be calculated");
116 $row = db_fetch_row($res);
117 return ($row[0] != 0.0);
120 function dimension_is_closed($id)
122 $result = get_dimension($id);
123 return ($result['closed'] == '1');
126 //--------------------------------------------------------------------------------------
128 function close_dimension($id)
130 $sql = "UPDATE ".TB_PREF."dimensions SET closed='1' WHERE id = $id";
131 db_query($sql, "could not close dimension");
134 //--------------------------------------------------------------------------------------