diff options
| author | levinse <levinse> | 2011-06-22 17:01:45 +0000 |
|---|---|---|
| committer | levinse <levinse> | 2011-06-22 17:01:45 +0000 |
| commit | 376b1dfc27736a2d7060ad0ca140565c9d3de55d (patch) | |
| tree | 86600bd186dcad575f33fc95761a052e3a3182e4 /httemplate | |
| parent | 4a62363bef9734758dc246de66440037e3cc77f7 (diff) | |
improve performance of DID provisioning status report, RT10988
Diffstat (limited to 'httemplate')
| -rw-r--r-- | httemplate/search/phone_inventory_provisioned.html | 27 |
1 files changed, 9 insertions, 18 deletions
diff --git a/httemplate/search/phone_inventory_provisioned.html b/httemplate/search/phone_inventory_provisioned.html index 57eb6763b..52657e70a 100644 --- a/httemplate/search/phone_inventory_provisioned.html +++ b/httemplate/search/phone_inventory_provisioned.html @@ -7,17 +7,19 @@ 'select' => 'distinct latanum', }, 'count_query' => 'SELECT COUNT(distinct latanum) FROM phone_avail', - 'header' => [ 'LATA', + 'header' => [ + 'LATA #', + 'LATA Description', 'Available', 'Provisioned', 'Have Usage', ], 'fields' => [ - sub { # LATA + 'latanum', + sub { # LATA Description my $phone_avail = shift; - my $lata = $phone_avail->lata; - $lata = $lata ? $lata->description : ''; - $phone_avail->latanum . " - " . $lata; + return '' unless $phone_avail->lata; + $phone_avail->lata->description; }, sub { # Available my $latanum = shift->latanum; @@ -44,19 +46,8 @@ }, sub { # Have Usage my $phone_avail = shift; - return '' unless $phone_avail->latanum; - my $latanum = $phone_avail->latanum; - my $count = 0; - my $sql = "select count(1) from cdr where src in - (select phonenum from svc_phone where svcnum in ( - select svcnum from phone_avail where latanum = $latanum - and svcnum is not null) ) - or charged_party in (select phonenum from svc_phone where - svcnum in (select svcnum from phone_avail where - latanum = $latanum and svcnum is not null) )"; - my $c = $phone_avail->scalar_sql($sql); - $count++ if $c > 0; - $count; + return '' unless $phone_avail->lata; + $phone_avail->lata->have_usage; }, ], 'align' => 'lccc', |