diff options
| author | Mark Wells <mark@freeside.biz> | 2015-07-14 00:00:07 -0700 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2015-07-14 00:00:55 -0700 |
| commit | 8ec5976a838f840f5987280deb653b97562de5fa (patch) | |
| tree | 769a2865bab51f48648bfab757aa3e99324fdfaa /FS/FS | |
| parent | 2f8c8867a7f5b504070a6306adf9989283189a04 (diff) | |
fix invoice report when there are no customer classes, #37243, from #25943
Diffstat (limited to 'FS/FS')
| -rw-r--r-- | FS/FS/Report/Table.pm | 1 | ||||
| -rw-r--r-- | FS/FS/cust_bill/Search.pm | 2 |
2 files changed, 2 insertions, 1 deletions
diff --git a/FS/FS/Report/Table.pm b/FS/FS/Report/Table.pm index cba968b..0a0d24a 100644 --- a/FS/FS/Report/Table.pm +++ b/FS/FS/Report/Table.pm @@ -901,6 +901,7 @@ sub with_classnum { $classnum = [ $classnum ] if !ref($classnum); @$classnum = grep /^\d+$/, @$classnum; + return '' if !@$classnum; my $in = 'IN ('. join(',', @$classnum). ')'; if ( $use_override ) { diff --git a/FS/FS/cust_bill/Search.pm b/FS/FS/cust_bill/Search.pm index 38f11d1..925938d 100644 --- a/FS/FS/cust_bill/Search.pm +++ b/FS/FS/cust_bill/Search.pm @@ -232,7 +232,7 @@ sub search_sql_where { ? @{ $param->{'cust_classnum'} } : ( $param->{'cust_classnum'} ); - @classnum = grep /^(\d*)$/, @classnum; + @classnum = grep /^(\d+)$/, @classnum; if ( @classnum ) { push @search, 'COALESCE(cust_main.classnum, 0) IN ('.join(',', @classnum).')'; |