diff options
| author | levinse <levinse> | 2011-06-21 22:59:01 +0000 |
|---|---|---|
| committer | levinse <levinse> | 2011-06-21 22:59:01 +0000 |
| commit | e497a444b638b1bb22e8949cd0703708da35008b (patch) | |
| tree | b5979d5835bc9ab6b51a0eee57e59659b2f45a01 | |
| parent | a9579d4fc556a54ad76b863cdd19abba79f3fc5f (diff) | |
improve performance of DID provisioning status report, RT10988
| -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 |