From e497a444b638b1bb22e8949cd0703708da35008b Mon Sep 17 00:00:00 2001 From: levinse Date: Tue, 21 Jun 2011 22:59:01 +0000 Subject: [PATCH] improve performance of DID provisioning status report, RT10988 --- httemplate/search/phone_inventory_provisioned.html | 5 ++--- 1 file 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 -- 2.11.0