diff options
| author | Mark Wells <mark@freeside.biz> | 2013-02-19 14:43:57 -0800 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2013-02-19 14:43:57 -0800 |
| commit | cd99d4ff00f359cfcdd35c1cebde5a67ae8218e3 (patch) | |
| tree | 6f142cd9630c104d1a8af1bb1a9838f956649363 | |
| parent | 3a75059f65a77191e755dc5a262b85f720936ae2 (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 dde546143..9f9eb30ce 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); @@ -105,7 +105,7 @@ push @search, $curuser->agentnums_sql({ table => 'pay_batch', 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; |