X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_pay_batch.cgi;h=c0f84ec877df2f0c1a4c2dd718f21da7cd90a221;hb=786cc8367ea7c504a762eb698ae4f93fc76b0dc1;hp=9f9eb30ceecb2a9e5617bcdc6870a56e9ea46557;hpb=3d0a1bb06b895c5be6e3f0517d355442a6b1e125;p=freeside.git diff --git a/httemplate/search/cust_pay_batch.cgi b/httemplate/search/cust_pay_batch.cgi index 9f9eb30ce..c0f84ec87 100755 --- a/httemplate/search/cust_pay_batch.cgi +++ b/httemplate/search/cust_pay_batch.cgi @@ -30,10 +30,10 @@ sub { sprintf('%.02f', $_[0]->amount) }, - 'status', + sub { $_[0]->display_status }, 'error_message', ], - 'align' => 'rrrlllcrll', + 'align' => 'rrrlllcrlll', 'links' => [ '', ["${p}view/cust_bill.cgi?", 'invnum'], (["${p}view/cust_main.cgi?", 'custnum']) x 2, @@ -72,7 +72,7 @@ if ( $cgi->param('batchnum') && $cgi->param('batchnum') =~ /^(\d+)$/ ) { } if ( $cgi->param('custnum') && $cgi->param('custnum') =~ /^(\d+)$/ ) { - push @search, "custnum = $1"; + push @search, "cust_pay_batch.custnum = $1"; } if ( $cgi->param('status') && $cgi->param('status') =~ /^(\w)$/ ) { @@ -116,7 +116,6 @@ $sql_query = { 'hashref' => {}, 'addl_from' => 'LEFT JOIN pay_batch USING ( batchnum ) '. 'LEFT JOIN cust_main USING ( custnum ) '. - 'LEFT JOIN cust_pay USING ( batchnum, custnum ) ', 'extra_sql' => $search, 'order_by' => "ORDER BY $orderby",