projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
This commit was generated by cvs2svn to compensate for changes in r11022,
[freeside.git]
/
httemplate
/
search
/
phone_inventory_provisioned.html
diff --git
a/httemplate/search/phone_inventory_provisioned.html
b/httemplate/search/phone_inventory_provisioned.html
index
c3de38f
..
5d4b421
100644
(file)
--- a/
httemplate/search/phone_inventory_provisioned.html
+++ b/
httemplate/search/phone_inventory_provisioned.html
@@
-4,34
+4,33
@@
'query' => {
'table' => 'phone_avail',
'hashref' => {},
'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
',
+ 'count_query' => 'SELECT COUNT(distinct
latanum
) FROM phone_avail',
+ 'header' => [ '
LATA #
',
'Available',
'Provisioned',
'Have Usage',
],
'fields' => [
'Available',
'Provisioned',
'Have Usage',
],
'fields' => [
- '
npanxx
',
+ '
latanum
',
sub {
sub {
- my $
npanxx = shift->npanxx
;
+ my $
latanum = shift->latanum
;
my @dids = qsearch('phone_avail',
{ 'svcnum' => '',
my @dids = qsearch('phone_avail',
{ 'svcnum' => '',
- 'npa' => substr($npanxx,0,3),
- 'nxx' => substr($npanxx,3,3),
+ 'latanum' => $latanum,
}
);
return scalar(@dids);
},
sub {
}
);
return scalar(@dids);
},
sub {
- my $
npanxx = shift->npanxx
;
- my @dids = provisioned_dids($
npanxx
);
+ my $
latanum = shift->latanum
;
+ my @dids = provisioned_dids($
latanum
);
return scalar(@dids);
},
sub {
return scalar(@dids);
},
sub {
- my $
npanxx = shift->npanxx
;
- my @dids = provisioned_dids($
npanxx
);
+ my $
latanum = shift->latanum
;
+ my @dids = provisioned_dids($
latanum
);
my $count = 0;
foreach my $did ( @dids ) {
next unless $did->cust_svc;
my $count = 0;
foreach my $did ( @dids ) {
next unless $did->cust_svc;
@@
-74,11
+73,10
@@
die "access denied"
# XXX: agent virtualize
sub provisioned_dids {
# XXX: agent virtualize
sub provisioned_dids {
- my $
npanxx
= shift;
+ my $
latanum
= shift;
qsearch({ 'table' => 'phone_avail',
'hashref' => {
qsearch({ 'table' => 'phone_avail',
'hashref' => {
- 'npa' => substr($npanxx,0,3),
- 'nxx' => substr($npanxx,3,3),
+ 'latanum' => $latanum,
},
'extra_sql' => ' and svcnum is not null ',
});
},
'extra_sql' => ' and svcnum is not null ',
});