summaryrefslogtreecommitdiff
path: root/httemplate/search/cdr.html
diff options
context:
space:
mode:
Diffstat (limited to 'httemplate/search/cdr.html')
-rw-r--r--httemplate/search/cdr.html91
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>