From: levinse <levinse>
Date: Tue, 21 Jun 2011 22:59:01 +0000 (+0000)
Subject: improve performance of DID provisioning status report, RT10988
X-Git-Tag: freeside_2_3_0~93
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=e497a444b638b1bb22e8949cd0703708da35008b

improve performance of DID provisioning status report, RT10988
---

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