Added is_closed_trans()

[fa-stable.git] / includes / db / audit_trail_db.inc

diff --git a/includes/db/audit_trail_db.inc b/includes/db/audit_trail_db.inc
index 6113bfd3421c4f36a4ea7dc5b30f4f27e76e4adc..e7958805dd184fb7c4521d331a6f5c959746dbac 100644 (file)
--- a/includes/db/audit_trail_db.inc
+++ b/includes/db/audit_trail_db.inc
@@ -120,5 +120,16 @@ function open_transactions($fromdate) {
                }
        }
 }
+/*
+       Closed transactions have gl_seq number assigned.
+*/
+function is_closed_trans($type, $trans_no) {
+       $sql = "SELECT  gl_seq  FROM ".TB_PREF."audit_trail"
+               . " WHERE type=$type AND trans_no=$trans_no AND gl_seq>0";
+
+       $res = db_query($sql, "Cannot check transaction");
+
+       return db_num_rows($res);
+}
 
 ?>