diff options
Diffstat (limited to 'httemplate/search/cdr.html')
-rw-r--r-- | httemplate/search/cdr.html | 91 |
1 files changed, 0 insertions, 91 deletions
diff --git a/httemplate/search/cdr.html b/httemplate/search/cdr.html deleted file mode 100644 index 0facc7fab..000000000 --- a/httemplate/search/cdr.html +++ /dev/null @@ -1,91 +0,0 @@ -<% include( 'elements/search.html', - 'title' => $title, - 'name' => 'call detail records', - 'query' => { 'table' => 'cdr', - 'hashref' => $hashref, - 'extra_sql' => $qsearch, - 'order_by' => 'ORDER BY calldate', - }, - 'count_query' => $count_query, - 'header' => [ fields('cdr') ], #XXX fill in some nice names - 'fields' => [ fields('cdr') ], #XXX fill in some pretty-print - # processing, etc. - ) -%> -<%init> - -die "access denied" - unless $FS::CurrentUser::CurrentUser->access_right('List rating data'); - -my $title = 'Call Detail Records'; -my $hashref = {}; - -#process params for CDR search, populate $hashref... -# and fixup $count_query - -my @search = (); -my @qsearch = (); - -### -# freesidestatus -### - -if ( $cgi->param('freesidestatus') eq 'NULL' ) { - - my $title = "Unprocessed $title"; - $hashref->{'freesidestatus'} = ''; # Record.pm will take care of it - push @search, "( freesidestatus IS NULL OR freesidestatus = '' )"; - -} elsif ( $cgi->param('freesidestatus') =~ /^([\w ]+)$/ ) { - - my $title = "Processed $title"; - $hashref->{'freesidestatus'} = $1; - push @search, "freesidestatus = '$1'"; - -} - -### -# dates -### - -my $str2time_sql = str2time_sql; - -my($beginning, $ending) = FS::UI::Web::parse_beginning_ending($cgi); -push @search, -my @dsearch = ( "$str2time_sql calldate) >= $beginning ", - "$str2time_sql calldate) <= $ending" - ); -push @search, @dsearch; -push @qsearch, @search; - - -### -# src/dest -### - -if ( $cgi->param('src') =~ /^\s*([\d\-\+\ ]+)\s*$/ ) { - ( my $src = $1 ) =~ s/\D//g; - $hashref->{'src'} = $src; - push @search, "src = '$src'"; -} - -if ( $cgi->param('dst') =~ /^\s*([\d\-\+ ]+)\s*$/ ) { - ( my $dst = $1 ) =~ s/\D//g; - $hashref->{'dst'} = $dst; - push @search, "dst = '$dst'"; -} - -### -# finish it up -### - -my $search = join(' AND ', @search); -$search = "WHERE $search" if $search; - -my $count_query = "SELECT COUNT(*) FROM cdr $search"; - -my $qsearch = join(' AND ', @qsearch); -$qsearch = ( scalar(keys %$hashref) ? ' AND ' : ' WHERE ' ) . $qsearch - if $qsearch; - -</%init> |