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:01:00 -0700 |
| commit | 57e3a0e08b81d52851314c60f37115a05b9be79e (patch) | |
| tree | 6b82b5d75720ea862fb064992ee906c3c878ddd1 | |
| parent | 7c1e0242d6e2d8d45001bbb3b1b828fb425953c1 (diff) | |
fix invoice report when there are no customer classes, #37243, from #25943
| -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 cba968b43..0a0d24a79 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 38f11d165..925938d82 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).')'; |