X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Fphone_inventory_provisioned.html;h=b3efdbd77fa70ee41a7c67f85909e917de8c51b6;hp=c3de38f3777ff2cfd12b44fea1f594e6703d1d5a;hb=ff27c3f36240aee48ed50153dd5d8fe3ac3f2443;hpb=13a5d5ea7770ef1868e1d9af95a27065008484b7

diff --git a/httemplate/search/phone_inventory_provisioned.html b/httemplate/search/phone_inventory_provisioned.html
index c3de38f37..b3efdbd77 100644
--- a/httemplate/search/phone_inventory_provisioned.html
+++ b/httemplate/search/phone_inventory_provisioned.html
@@ -1,87 +1,86 @@
-<% include( 'elements/search.html',
-              'title'         => 'Phone Number (DID) Search Results',
-              'name_singular' => 'phone number',
+<& elements/search.html,
+              'title'         => 'LATA Search Results',
+              'name_singular' => 'LATA',
               'query'         => {
                                    'table'   => 'phone_avail',
                                    'hashref' => {},
-                                   'select'  => 'distinct npa||nxx as npanxx'
+                                   'select'  => 'distinct latanum',
                                  },
-              'count_query'   => 'SELECT COUNT(distinct npa||nxx) FROM phone_avail',
-              'header'        => [ 'NPANXX',
-				   'Available',
-				   'Provisioned',
-				   'Have Usage',
+              'count_query'   => 'SELECT COUNT(distinct latanum) FROM phone_avail',
+              'header'        => [ 
+                                   '#',
+                                   'LATA',
+                                   'Available',
+                                   'Provisioned',
+                                   'Have Usage',
                                  ],
               'fields'        => [
-                'npanxx',
-		sub {
-		    my $npanxx = shift->npanxx;
-		    my @dids = qsearch('phone_avail',
-					{ 'svcnum' => '',
-					  'npa' => substr($npanxx,0,3),
-					  'nxx' => substr($npanxx,3,3),
-					}
-				      );
-		    return scalar(@dids);
-		},
-		sub {
-		    my $npanxx = shift->npanxx;
-		    my @dids = provisioned_dids($npanxx);
-		    return scalar(@dids);
-		},
-		sub {
-		    my $npanxx = shift->npanxx;
-		    my @dids = provisioned_dids($npanxx);
-		    my $count = 0;
-		    foreach my $did ( @dids ) {
-			next unless $did->cust_svc;
-			my $svc_phone = $did->cust_svc->svc_x;
-			next unless $svc_phone;
-			my @cdrs = $svc_phone->get_cdrs;
-			$count++ if scalar(@cdrs);
-		    }
-		    $count;
-		},
+                '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',
+                                 'hashref'  => 
+                                    { 'svcnum' => '',
+                                      'latanum' => $latanum,
+                                    },
+                                 'select'   => 'count(1) as cnt',
+                          });
+                    ($cnt) ? $cnt->cnt : '';
+                },
+                sub { # Provisioned
+                    my $latanum = shift->latanum;
+                    my $cnt = qsearchs({   'table'     => 'phone_avail',
+                        'hashref'   => { 'latanum' => $latanum,
+                                         'svcnum' => { op => '>',
+                                                        value => '0'
+                                                     },
+                                        },
+                        '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;
+                },
               ],
-              '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
 
-sub provisioned_dids {
-    my $npanxx = shift;
-    qsearch({ 'table' => 'phone_avail',
-	      'hashref' => { 
-		'npa' => substr($npanxx,0,3),
-		'nxx' => substr($npanxx,3,3),
-	      },
-	      'extra_sql' => ' and svcnum is not null ',
-	  });
-}
-
 </%init>