From: Joe Hunt <joe.hunt.consulting@gmail.com>
Date: Fri, 4 Oct 2019 07:48:59 +0000 (+0200)
Subject: Additional Transaction Date presence check
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=5bcc7a4ccbb360794669a098b48d8eb3dcf77119

Additional Transaction Date presence check
---

diff --git a/admin/db/transactions_db.inc b/admin/db/transactions_db.inc
index f7d2d295..466ded81 100644
--- a/admin/db/transactions_db.inc
+++ b/admin/db/transactions_db.inc
@@ -31,7 +31,8 @@ function get_sql_for_view_transactions($filtertype, $from, $to, &$trans_ref)
 		$sql .= " ,t.$trans_ref as ref ";
 	else
 		$sql .= ", r.reference as ref";
- 	$sql .= ",t.$trans_date as trans_date";
+	if ($trans_date)
+		$sql .= ",t.$trans_date as trans_date";
  	if ($type_name)
 		$sql .= ", t.$type_name as type";
 	$sql .= " FROM $table_name t LEFT JOIN ".TB_PREF."voided v ON"