diff options
| author | Mark Wells <mark@freeside.biz> | 2013-02-19 14:42:49 -0800 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2013-02-19 14:42:49 -0800 |
| commit | d83a701ddf329654360afb8c3b119b4f733714bc (patch) | |
| tree | c513868c44089fa5c9f03ddd251474953333cc39 | |
| parent | 7b3c18f90c6677884bd39d29f011ea59a257184b (diff) | |
fix misspelled table name, from #21117
| -rwxr-xr-x | httemplate/search/cust_pay_batch.cgi | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/httemplate/search/cust_pay_batch.cgi b/httemplate/search/cust_pay_batch.cgi index b5e582f7c..a41427188 100755 --- a/httemplate/search/cust_pay_batch.cgi +++ b/httemplate/search/cust_pay_batch.cgi @@ -87,7 +87,7 @@ if ( $cgi->param('payby') ) { } if ( not $cgi->param('dcln') ) { - push @search, "cpb.status IS DISTINCT FROM 'Approved'"; + push @search, "cust_pay_batch.status IS DISTINCT FROM 'Approved'"; } my ($beginning, $ending) = FS::UI::Web::parse_beginning_ending($cgi); @@ -101,7 +101,7 @@ push @search, $curuser->agentnums_sql({ table=>'cust_main' }); my $search = ' WHERE ' . join(' AND ', @search); -$count_query = 'SELECT COUNT(*) FROM cust_pay_batch AS cpb ' . +$count_query = 'SELECT COUNT(*) FROM cust_pay_batch ' . 'LEFT JOIN cust_main USING ( custnum ) ' . 'LEFT JOIN pay_batch USING ( batchnum )' . $search; |