1 <% include( 'elements/search.html',
2 'title' => 'LATA Search Results',
3 'name_singular' => 'LATA',
5 'table' => 'phone_avail',
7 'select' => 'distinct latanum',
9 'count_query' => 'SELECT COUNT(distinct latanum) FROM phone_avail',
17 my $did_order = shift;
18 my $lata = $did_order->lata;
19 $lata = $lata ? $lata->description : '';
20 $did_order->latanum . " - " . $lata;
23 my $latanum = shift->latanum;
24 my @dids = qsearch('phone_avail',
26 'latanum' => $latanum,
32 my $latanum = shift->latanum;
33 my @dids = provisioned_dids($latanum);
37 my $latanum = shift->latanum;
38 my @dids = provisioned_dids($latanum);
40 warn "have usage ".time;
41 return ''; # XXX disabled temporarily
44 foreach my $did ( @dids ) {
45 next unless $did->cust_svc;
46 my $svc_phone = $did->cust_svc->svc_x;
47 warn "inside loop ".time;
48 next unless $svc_phone;
49 my @cdrs = $svc_phone->get_cdrs;
50 $count++ if scalar(@cdrs);
78 warn "started @ ".time;
81 unless ( $FS::CurrentUser::CurrentUser->access_right('List inventory')
82 && $FS::CurrentUser::CurrentUser->access_right('List services')
85 # XXX: agent virtualize
87 sub provisioned_dids {
89 qsearch({ 'table' => 'phone_avail',
90 'hashref' => { 'latanum' => $latanum, },
91 'extra_sql' => ' and svcnum is not null ',