1 <% include( 'elements/search.html',
2 'title' => 'Phone Number (DID) Search Results',
3 'name_singular' => 'phone number',
5 'table' => 'phone_avail',
7 'select' => 'distinct latanum',
9 'count_query' => 'SELECT COUNT(distinct latanum) FROM phone_avail',
10 'header' => [ 'LATA #',
18 my $latanum = shift->latanum;
19 my @dids = qsearch('phone_avail',
21 'latanum' => $latanum,
27 my $latanum = shift->latanum;
28 my @dids = provisioned_dids($latanum);
32 my $latanum = shift->latanum;
33 my @dids = provisioned_dids($latanum);
35 foreach my $did ( @dids ) {
36 next unless $did->cust_svc;
37 my $svc_phone = $did->cust_svc->svc_x;
38 next unless $svc_phone;
39 my @cdrs = $svc_phone->get_cdrs;
40 $count++ if scalar(@cdrs);
69 unless ( $FS::CurrentUser::CurrentUser->access_right('List inventory')
70 && $FS::CurrentUser::CurrentUser->access_right('List services')
73 # XXX: agent virtualize
75 sub provisioned_dids {
77 qsearch({ 'table' => 'phone_avail',
79 'latanum' => $latanum,
81 'extra_sql' => ' and svcnum is not null ',