add package class selection to package summary report, RT#23555

[freeside.git] / httemplate / search / cust_pkg_summary.cgi

diff --git a/httemplate/search/cust_pkg_summary.cgi b/httemplate/search/cust_pkg_summary.cgi
index fbeeb92..d327489 100644 (file)
--- a/httemplate/search/cust_pkg_summary.cgi
+++ b/httemplate/search/cust_pkg_summary.cgi
@@ -71,6 +71,15 @@ my $agentnums_sql = $curuser->agentnums_sql(
 
 my $extra_sql = " WHERE $agentnums_sql";
 
+#tiny bit of false laziness w/cust_pkg.pm::search
+if ( grep { $_ eq 'classnum' } $cgi->param ) {
+  if ( $cgi->param('classnum') eq '' ) {
+    $extra_sql .= ' AND part_pkg.classnum IS NULL';
+  } elsif ( $cgi->param('classnum') =~ /^(\d+)$/ && $1 ne '0' ) {
+    $extra_sql .= " AND part_pkg.classnum = $1 ";
+  }
+}
+
 foreach my $part_pkg (qsearch({ 'table'     => 'part_pkg',
                                 'hashref'   => {},
                                 'extra_sql' => $extra_sql,