X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fcust_pkg.pm;h=87acf0e52c8d2e937082bb8a8682f298df61189e;hb=8a26002c6bf6d2c42df5eb90ed760accb71acbb7;hp=92aa43f8e3bcc3122e775df21742c23183c6e58d;hpb=c6782ab85ea83e0c78d85b8975985aac9d467f9d;p=freeside.git diff --git a/FS/FS/cust_pkg.pm b/FS/FS/cust_pkg.pm index 92aa43f8e..87acf0e52 100644 --- a/FS/FS/cust_pkg.pm +++ b/FS/FS/cust_pkg.pm @@ -3337,6 +3337,12 @@ sub apply_usage { my $dbh = dbh; my $order = FS::Conf->new->config('cdr-minutes_priority'); + my $is_classnum; + if ( $classnum ) { + $is_classnum = ' part_pkg_usage_class.classnum = '.$classnum; + } else { + $is_classnum = ' part_pkg_usage_class.classnum IS NULL'; + } my @usage_recs = qsearch({ 'table' => 'cust_pkg_usage', 'addl_from' => ' JOIN part_pkg_usage USING (pkgusagepart)'. @@ -3346,7 +3352,7 @@ sub apply_usage { 'extra_sql' => " WHERE ( cust_pkg.pkgnum = $pkgnum OR ". " ( cust_pkg.custnum = $custnum AND ". " part_pkg_usage.shared IS NOT NULL ) ) AND ". - " part_pkg_usage_class.classnum = $classnum AND ". + $is_classnum . ' AND '. " cust_pkg_usage.minutes > 0", 'order_by' => " ORDER BY priority ASC", });