X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Fphone_inventory_provisioned.html;h=b3efdbd77fa70ee41a7c67f85909e917de8c51b6;hp=52657e70a30ebee9d63192676cfeee091911dd3f;hb=ff27c3f36240aee48ed50153dd5d8fe3ac3f2443;hpb=376b1dfc27736a2d7060ad0ca140565c9d3de55d diff --git a/httemplate/search/phone_inventory_provisioned.html b/httemplate/search/phone_inventory_provisioned.html index 52657e70a..b3efdbd77 100644 --- a/httemplate/search/phone_inventory_provisioned.html +++ b/httemplate/search/phone_inventory_provisioned.html @@ -1,4 +1,4 @@ -<% include( 'elements/search.html', +<& elements/search.html, 'title' => 'LATA Search Results', 'name_singular' => 'LATA', 'query' => { @@ -8,33 +8,33 @@ }, 'count_query' => 'SELECT COUNT(distinct latanum) FROM phone_avail', 'header' => [ - 'LATA #', - 'LATA Description', - 'Available', - 'Provisioned', - 'Have Usage', + '#', + 'LATA', + 'Available', + 'Provisioned', + 'Have Usage', ], 'fields' => [ 'latanum', - sub { # LATA Description - my $phone_avail = shift; - return '' unless $phone_avail->lata; - $phone_avail->lata->description; - }, - sub { # Available - my $latanum = shift->latanum; - my $cnt = qsearchs({ 'table' => 'phone_avail', + sub { # LATA Description + my $phone_avail = shift; + return '' unless $phone_avail->lata; + $phone_avail->lata->description; + }, + sub { # Available + my $latanum = shift->latanum; + my $cnt = qsearchs({ 'table' => 'phone_avail', 'hashref' => { 'svcnum' => '', 'latanum' => $latanum, }, 'select' => 'count(1) as cnt', }); - ($cnt) ? $cnt->cnt : ''; - }, - sub { # Provisioned - my $latanum = shift->latanum; - my $cnt = qsearchs({ 'table' => 'phone_avail', + ($cnt) ? $cnt->cnt : ''; + }, + sub { # Provisioned + my $latanum = shift->latanum; + my $cnt = qsearchs({ 'table' => 'phone_avail', 'hashref' => { 'latanum' => $latanum, 'svcnum' => { op => '>', value => '0' @@ -42,41 +42,44 @@ }, 'select' => 'count(1) as cnt' }); - ($cnt) ? $cnt->cnt : ''; - }, - sub { # Have Usage - my $phone_avail = shift; - return '' unless $phone_avail->lata; - $phone_avail->lata->have_usage; - }, + ($cnt) ? $cnt->cnt : ''; + }, + sub { # Have Usage + my $phone_avail = shift; + return '' unless $phone_avail->lata; + $phone_avail->lata->have_usage; + }, ], - 'align' => 'lccc', + 'align' => 'rlrrr', 'links' => [ '', '', '', '', + '', ], 'color' => [ '', '', '', '', + '', ], 'style' => [ '', '', '', '', + '', ], - ) -%> + +&> <%init> die "access denied" unless ( $FS::CurrentUser::CurrentUser->access_right('List inventory') - && $FS::CurrentUser::CurrentUser->access_right('List services') - ); + && $FS::CurrentUser::CurrentUser->access_right('List services') + ); # XXX: agent virtualize