- if ( $cgi->param('classnum'.$1.'typenum') =~ /^(\d+)$/ ) {
- push @extra_sql, "svc_hardware.typenum = $1";
+}
+
+if ( $cgi->param('model') =~ /^([\w\s]+)$/ ) {
+ push @extra_sql, "hardware_type.model = '$1'";
+}
+
+if ( $cgi->param('typenum') =~ /^(\d+)$/ ) {
+ push @extra_sql, "svc_hardware.typenum = $1";
+}
+
+if ( $cgi->param('svcpart') =~ /^(\d+)$/ ) {
+ push @extra_sql, "cust_svc.svcpart = $1";
+ if (defined($cgi->param('cancelled'))) {
+ if ($cgi->param('cancelled')) {
+ push @extra_sql, "cust_pkg.cancel IS NOT NULL";
+ } else {
+ push @extra_sql, "cust_pkg.cancel IS NULL";
+ }