diff options
Diffstat (limited to 'httemplate/search/svc_phone.cgi')
| -rw-r--r-- | httemplate/search/svc_phone.cgi | 175 |
1 files changed, 0 insertions, 175 deletions
diff --git a/httemplate/search/svc_phone.cgi b/httemplate/search/svc_phone.cgi deleted file mode 100644 index 29434083f..000000000 --- a/httemplate/search/svc_phone.cgi +++ /dev/null @@ -1,175 +0,0 @@ -<% include( 'elements/search.html', - 'title' => "Phone number search results", - 'name' => 'phone numbers', - 'query' => $sql_query, - 'count_query' => $count_query, - 'redirect' => $redirect, - 'header' => [ '#', - 'Service', - 'Country code', - 'Phone number', - @header, - FS::UI::Web::cust_header(), - ], - 'fields' => [ 'svcnum', - 'svc', - 'countrycode', - 'phonenum', - @fields, - \&FS::UI::Web::cust_fields, - ], - 'links' => [ $link, - $link, - $link, - $link, - ( map '', @header ), - ( map { $_ ne 'Cust. Status' ? $link_cust : '' } - FS::UI::Web::cust_header() - ), - ], - 'align' => 'rlrr'. - join('', map 'r', @header). - FS::UI::Web::cust_aligns(), - 'color' => [ - '', - '', - '', - '', - ( map '', @header ), - FS::UI::Web::cust_colors(), - ], - 'style' => [ - '', - '', - '', - '', - ( map '', @header ), - FS::UI::Web::cust_styles(), - ], - ) -%> -<%init> - -die "access denied" - unless $FS::CurrentUser::CurrentUser->access_right('List services'); - -my $conf = new FS::Conf; - -my @select = (); -my %svc_phone = (); -my @extra_sql = (); -my $orderby = 'ORDER BY svcnum'; - -my @header = (); -my @fields = (); -my $link = [ "${p}view/svc_phone.cgi?", 'svcnum' ]; -my $redirect = $link; - -if ( $cgi->param('magic') =~ /^(all|unlinked)$/ ) { - - push @extra_sql, 'pkgnum IS NULL' - if $cgi->param('magic') eq 'unlinked'; - - if ( $cgi->param('sortby') =~ /^(\w+)$/ ) { - my $sortby = $1; - $orderby = "ORDER BY $sortby"; - } - - if ( $cgi->param('usage_total') ) { - - my($beginning,$ending) = FS::UI::Web::parse_beginning_ending($cgi, 'usage'); - - $redirect = ''; - - #my $and_date = " AND startdate >= $beginning AND startdate <= $ending "; - my $and_date = " AND enddate >= $beginning AND enddate <= $ending "; - - my $fromwhere = " FROM cdr WHERE cdr.svcnum = svc_phone.svcnum $and_date"; - - #more efficient to join against cdr just once... this will do for now - push @select, map { " ( SELECT SUM($_) $fromwhere ) AS $_ " } - qw( billsec rated_price ); - - my $money_char = $conf->config('money_char') || '$'; - - push @header, 'Minutes', 'Billed'; - push @fields, - sub { sprintf('%.3f', shift->get('billsec') / 60 ); }, - sub { $money_char. sprintf('%.2f', shift->get('rated_price') ); }; - - #XXX and termination... (this needs a config to turn on, not by default) - if ( 1 ) { # $conf->exists('cdr-termination_hack') { #} - - my $f_w = - " FROM cdr_termination LEFT JOIN cdr USING ( acctid ) ". - " WHERE cdr.carrierid = CAST(svc_phone.phonenum AS BIGINT) ". # XXX connectone-specific, has to match svc_external.id :/ - $and_date; - - push @select, - " ( SELECT SUM(billsec) $f_w ) AS term_billsec ", - " ( SELECT SUM(cdr_termination.rated_price) $f_w ) AS term_rated_price"; - - push @header, 'Term Min', 'Term Billed'; - push @fields, - sub { sprintf('%.3f', shift->get('term_billsec') / 60 ); }, - sub { $money_char. sprintf('%.2f', shift->get('rated_price') ); }; - - } - - - } - -} elsif ( $cgi->param('svcpart') =~ /^(\d+)$/ ) { - push @extra_sql, "svcpart = $1"; -} else { - $cgi->param('phonenum') =~ /^([\d\- ]+)$/; - ( $svc_phone{'phonenum'} = $1 ) =~ s/\D//g; -} - -my $addl_from = ' LEFT JOIN cust_svc USING ( svcnum ) '. - ' LEFT JOIN part_svc USING ( svcpart ) '. - ' LEFT JOIN cust_pkg USING ( pkgnum ) '. - ' LEFT JOIN cust_main USING ( custnum ) '; - -#here is the agent virtualization -push @extra_sql, $FS::CurrentUser::CurrentUser->agentnums_sql( - 'null_right' => 'View/link unlinked services' - ); - -my $extra_sql = ''; -if ( @extra_sql ) { - $extra_sql = ( keys(%svc_phone) ? ' AND ' : ' WHERE ' ). - join(' AND ', @extra_sql ); -} - -my $count_query = "SELECT COUNT(*) FROM svc_phone $addl_from "; -if ( keys %svc_phone ) { - $count_query .= ' WHERE '. - join(' AND ', map "$_ = ". dbh->quote($svc_phone{$_}), - keys %svc_phone - ); -} -$count_query .= $extra_sql; - -my $sql_query = { - 'table' => 'svc_phone', - 'hashref' => \%svc_phone, - 'select' => join(', ', - 'svc_phone.*', - 'part_svc.svc', - @select, - 'cust_main.custnum', - FS::UI::Web::cust_sql_fields(), - ), - 'extra_sql' => $extra_sql, - 'order_by' => $orderby, - 'addl_from' => $addl_from, -}; - -#smaller false laziness w/svc_*.cgi here -my $link_cust = sub { - my $svc_x = shift; - $svc_x->custnum ? [ "${p}view/cust_main.cgi?", 'custnum' ] : ''; -}; - -</%init> |