CDR report: add cdrtypenum search criteria, RT13402

diff --git a/httemplate/search/cdr.html b/httemplate/search/cdr.html
index c77fc35..cefc0fe 100644 (file)
--- a/httemplate/search/cdr.html
+++ b/httemplate/search/cdr.html
@@ -95,6 +95,19 @@ if ( $cgi->param('freesidestatus') eq 'NULL' ) {
 }
 
 ###
+# cdrtypenum
+###
+
+if ( $cgi->param('cdrtypenum') =~ /^(\d+)$/ ) {
+    $hashref->{'cdrtypenum'} = $1;
+    push @search, "cdrtypenum = $1";
+}
+elsif ( $cgi->param('cdrtypenum') eq 'none' ) {
+    $hashref->{'cdrtypenum'} = '';
+    push @search, "cdrtypenum is null";
+}
+
+###
 # termpartNstatus
 ###
 

diff --git a/httemplate/search/report_cdr.html b/httemplate/search/report_cdr.html
index 11049ac..07299d5 100644 (file)
--- a/httemplate/search/report_cdr.html
+++ b/httemplate/search/report_cdr.html
@@ -46,6 +46,14 @@
 %   }
 % #}
 
+  <% include('/elements/tr-select-table.html',
+            field   => 'cdrtypenum',
+            label   => 'CDR Type',
+            table   => 'cdr_type',
+            name_col    => 'cdrtypename',
+            post_options => [ 'none', 'none' ] )
+  %>
+
   <% include ( '/elements/tr-input-beginning_ending.html' ) %>
 
   <TR>