From 3650198cd9cae012988b2cc971d6d9a3fb6b397b Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 29 Nov 2010 09:02:45 +0000 Subject: [PATCH] [0000289] Duplicate records in view/print/void transaction pager --- admin/db/transactions_db.inc | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/admin/db/transactions_db.inc b/admin/db/transactions_db.inc index c4f48306..594c34d2 100644 --- a/admin/db/transactions_db.inc +++ b/admin/db/transactions_db.inc @@ -25,7 +25,7 @@ function get_sql_for_view_transactions($filtertype, $from, $to, &$trans_ref) $trans_ref = $db_info[3]; $trans_date = $db_info[4]; - $sql = "SELECT DISTINCT t.$trans_no_name as trans_no"; + $sql = "SELECT t.$trans_no_name as trans_no"; if ($trans_ref) $sql .= " ,t.$trans_ref as ref "; @@ -49,7 +49,8 @@ function get_sql_for_view_transactions($filtertype, $from, $to, &$trans_ref) } elseif ($type_name != null) $sql .= " AND t.`$type_name` = ".db_escape($filtertype); - + + $sql .= " GROUP BY t.$type_name, t.$trans_no_name"; $sql .= " ORDER BY t.$trans_no_name"; return $sql; -- 2.30.2