X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=blobdiff_plain;f=includes%2Fdb%2Faudit_trail_db.inc;h=feb85a991f744b6ed3facf54fd4fffaff18d7964;hp=6aa91d9833689c0fdfd4db3a70f2f653f747ab08;hb=c7fa25a75b6a5c51aac91dec186217b134d7bcbc;hpb=2bcdab793e406bb5a44d2c4e079ec7cc2a1aa857

diff --git a/includes/db/audit_trail_db.inc b/includes/db/audit_trail_db.inc
index 6aa91d98..feb85a99 100644
--- a/includes/db/audit_trail_db.inc
+++ b/includes/db/audit_trail_db.inc
@@ -16,17 +16,17 @@ function add_audit_trail($trans_type, $trans_no, $trans_date, $descr='')
 
 	$date = date2sql($trans_date);
 	$sql = "INSERT INTO ".TB_PREF."audit_trail"
-		. " (type, trans_no, user, gl_date, description)
+		. " (type, trans_no, user, gl_date, description, stamp)
 			VALUES(".db_escape($trans_type).", ".db_escape($trans_no).","
 			. $_SESSION["wa_current_user"]->user . ","
-			. "'$date',". db_escape($descr). ")";
+			. "'$date',". db_escape($descr). ", CURRENT_TIMESTAMP)";
 
 	db_query($sql, "Cannot add audit info");
 	// all audit records beside just inserted one should have gl_seq set to NULL
 	// to avoid need for subqueries (not existing in MySQL 3) all over the code
 	$sql = "UPDATE ".TB_PREF."audit_trail audit LEFT JOIN ".TB_PREF."fiscal_year year ON year.begin<='$date' AND year.end>='$date'
 		SET audit.gl_seq = IF(audit.id=".db_insert_id().", 0, NULL),"
-		."audit.fiscal_year=year.id"
+		."audit.fiscal_year=year.id, stamp=CURRENT_TIMESTAMP"
 		. " WHERE type=".db_escape($trans_type)." AND trans_no="
 		. db_escape($trans_no);