restore masked card info on batched payment report, RT#78166
authorIvan Kohler <ivan@freeside.biz>
Thu, 19 Apr 2018 21:47:42 +0000 (14:47 -0700)
committerIvan Kohler <ivan@freeside.biz>
Thu, 19 Apr 2018 21:47:42 +0000 (14:47 -0700)
httemplate/search/cust_pay_batch.cgi

index cc958b9..6b175ad 100755 (executable)
@@ -114,7 +114,7 @@ $count_query = 'SELECT COUNT(*) FROM cust_pay_batch ' .
 
 $sql_query = {
   'table'     => 'cust_pay_batch',
-  'select'    => 'cust_pay_batch.*, cust_main.*, cust_pay.paynum',
+  'select'    => 'cust_pay_batch.*, cust_pay.paynum',
   'hashref'   => {},
   'addl_from' => 'LEFT JOIN pay_batch USING ( batchnum ) '.
                  'LEFT JOIN cust_main USING ( custnum ) '.