sub check_lnp {
my $self = shift;
- my $in_svcpart = 'IN ('. join( ',', map $_->svcpart, $self->export_svc). ')';
+ my @export_svc = $self->export_svc;
+ return unless @export_svc;
+
+ my $in_svcpart = 'IN ('. join( ',', map $_->svcpart, @export_svc). ')';
foreach my $svc_phone (
qsearch({ 'table' => 'svc_phone',
+ 'addl_from' => 'LEFT JOIN cust_svc USING (svcnum)',
'hashref' => {lnp_status=>'portingin'},
'extra_sql' => "AND svcpart $in_svcpart",
})