my @or =
map { my $table = $_;
my $search_sql = "FS::$table"->search_sql($string);
+ my $addl_from = "FS::$table"->search_sql_addl_from();
"SELECT $table.svcnum AS svcnum, '$table' AS svcdb ".
- "FROM $table WHERE $search_sql";
+ "FROM $table $addl_from WHERE $search_sql";
}
FS::part_svc->svc_tables;
# check status of cust_pkg
my $cust_pkg = $self->cust_pkg;
- return '' unless $cust_pkg->status eq 'on hold';
+ return '' unless $cust_pkg && $cust_pkg->status eq 'on hold';
# check flag on this svc
# small false laziness with $self->pkg_svc