diff options
| author | levinse <levinse> | 2011-06-21 22:59:03 +0000 |
|---|---|---|
| committer | levinse <levinse> | 2011-06-21 22:59:03 +0000 |
| commit | d8966b98b46138efeaf853cfefc2c80e3c92a306 (patch) | |
| tree | 00d7b14a107b718e0aedc9df577af3d2166d4de8 /httemplate | |
| parent | 02ba6622765acfc92e7bc452f29b37fb52fdd295 (diff) | |
improve performance of DID provisioning status report, RT10988
Diffstat (limited to 'httemplate')
| -rw-r--r-- | httemplate/search/phone_inventory_provisioned.html | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/httemplate/search/phone_inventory_provisioned.html b/httemplate/search/phone_inventory_provisioned.html index 37fef8a21..eb5f21ef0 100644 --- a/httemplate/search/phone_inventory_provisioned.html +++ b/httemplate/search/phone_inventory_provisioned.html @@ -39,10 +39,9 @@ my $count = 0; foreach my $did ( @dids ) { - my $cust_svc = $did->cust_svc; - next unless $cust_svc; + my $svcnum = $did->svcnum; + next unless $svcnum; - my $svcnum = $cust_svc->svcnum; my $sql = "select count(1) from cdr where src = (select phonenum from svc_phone where svcnum = $svcnum) or charged_party = (select phonenum from svc_phone where |