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 $did_order = shift;
38 my @dids = provisioned_dids($did_order->latanum);
41 foreach my $did ( @dids ) {
42 my $svcnum = $did->svcnum;
45 my $sql = "select count(1) from cdr where src =
46 (select phonenum from svc_phone where svcnum = $svcnum)
47 or charged_party = (select phonenum from svc_phone where
49 my $c = $did_order->scalar_sql($sql);
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 ',