X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=dimensions%2Fincludes%2Fdimensions_db.inc;h=2a89b59643b1551d7c8856bb5471ba022e95ab78;hb=80dd97a37f674cc3691fa04af4c29607067566b2;hp=344305a209f76adf1333767ffd5a0cb7e170b109;hpb=1a851e527fe366364c6d2baaf2684222f9394b48;p=fa-stable.git diff --git a/dimensions/includes/dimensions_db.inc b/dimensions/includes/dimensions_db.inc index 344305a2..2a89b596 100644 --- a/dimensions/includes/dimensions_db.inc +++ b/dimensions/includes/dimensions_db.inc @@ -11,6 +11,8 @@ ***********************************************************************/ function add_dimension($reference, $name, $type_, $date_, $due_date, $memo_) { + global $Refs; + begin_transaction(); $date = date2sql($date_); @@ -22,9 +24,9 @@ function add_dimension($reference, $name, $type_, $date_, $due_date, $memo_) $id = db_insert_id(); - add_comments(systypes::dimension(), $id, $date_, $memo_); + add_comments(ST_DIMENSION, $id, $date_, $memo_); - references::save(systypes::dimension(), $id, $reference); + $Refs->save(ST_DIMENSION, $id, $reference); commit_transaction(); @@ -46,7 +48,7 @@ function update_dimension($id, $name, $type_, $date_, $due_date, $memo_) db_query($sql, "could not update dimension"); - update_comments(systypes::dimension(), $id, null, $memo_); + update_comments(ST_DIMENSION, $id, null, $memo_); commit_transaction(); @@ -61,7 +63,7 @@ function delete_dimension($id) $sql="DELETE FROM ".TB_PREF."dimensions WHERE id=$id"; db_query($sql,"The dimension could not be deleted"); - delete_comments(systypes::dimension(), $id); + delete_comments(ST_DIMENSION, $id); commit_transaction(); } @@ -142,4 +144,10 @@ function close_dimension($id) //-------------------------------------------------------------------------------------- +function reopen_dimension($id) +{ + $sql = "UPDATE ".TB_PREF."dimensions SET closed='0' WHERE id = $id"; + db_query($sql, "could not close dimension"); +} + ?> \ No newline at end of file