From 5b2360be6df88ae1d44f32753efb8151aec50c57 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Wed, 13 May 2009 12:46:31 +0000 Subject: [PATCH] Added is_closed_trans() --- includes/db/audit_trail_db.inc | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/includes/db/audit_trail_db.inc b/includes/db/audit_trail_db.inc index 6113bfd3..e7958805 100644 --- 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); +} ?> -- 2.30.2