CDR search by dcontext, charged_party, toggle of display fields, RT#4081
[freeside.git] / httemplate / search / report_cdr.html
1 <% include('/elements/header.html', 'Call Detail Record Search' ) %>
2
3 <FORM ACTION="cdr.html" METHOD="GET">
4
5 <TABLE BGCOLOR="#cccccc" CELLSPACING=0>
6
7   <TR>
8     <TH BGCOLOR="#e8e8e8" COLSPAN=2 ALIGN="left">
9       <FONT SIZE="+1">Search options</FONT>
10     </TH>
11   </TR>
12
13   <TR>
14     <TD ALIGN="right">Status: </TD>
15     <TD>
16       <SELECT NAME="freesidestatus">
17         <OPTION VALUE="">(all)
18         <OPTION VALUE="NULL">unprocessed
19         <OPTION VALUE="done">processed
20       </SELECT>
21     </TD>
22   </TR>
23
24 % #if ( ) {  # disable for everyone not using termination billing...
25 %   foreach my $termpart ( 1..1 ) { #qsearch('part_termination
26
27     <TR>
28       <TD ALIGN="right">Termination Status: </TD>
29       <TD>
30         <SELECT NAME="termpart<%$termpart%>status">
31           <OPTION VALUE="">(all)
32           <OPTION VALUE="NULL">unprocessed
33           <OPTION VALUE="done">processed
34         </SELECT>
35       </TD>
36     </TR>
37
38 %   }
39 % #}
40
41   <% include ( '/elements/tr-input-beginning_ending.html' ) %>
42
43   <TR>
44     <TD ALIGN="right">Source #: </TD>
45     <TD>
46       <INPUT TYPE="text" NAME="src">
47     </TD>
48   </TR>
49
50   <TR>
51     <TD ALIGN="right">Destination #: </TD>
52     <TD>
53       <INPUT TYPE="text" NAME="dst">
54     </TD>
55   </TR>
56
57   <TR>
58     <TD ALIGN="right">Destination Context: </TD>
59     <TD>
60       <INPUT TYPE="text" NAME="dcontext">
61     </TD>
62   </TR>
63
64
65   <TR>
66     <TD ALIGN="right">Charged Party #: </TD>
67     <TD>
68       <INPUT TYPE="text" NAME="charged_party">
69     </TD>
70   </TR>
71
72   <% include( '/elements/tr-input-lessthan_greaterthan.html',
73                 'label' => 'Duration (sec)',
74                 'field' => 'duration',
75             )
76   %>
77
78   <% include( '/elements/tr-input-lessthan_greaterthan.html',
79                 'label' => 'Billable duration (sec)',
80                 'field' => 'billsec',
81             )
82   %>
83
84   <% include( '/elements/tr-select-cdrbatch.html' ) %>
85
86   <TR>
87     <TH BGCOLOR="#e8e8e8" COLSPAN=2>&nbsp;</TH>
88   </TR>
89
90   <TR>
91     <TH BGCOLOR="#e8e8e8" COLSPAN=2 ALIGN="left"><FONT SIZE="+1">Display options</FONT></TH>
92   </TR>
93
94   <INPUT TYPE="hidden" NAME="show" VALUE="1">
95
96   <TR>
97     <TD COLSPAN=2>
98       <% include('/elements/checkboxes.html',
99                    'names_list'          => $names_list,
100                    'element_name_prefix' => 'show_',
101                    'checked_callback'    => sub { $show_default{$_[1]} },
102                                                   # my($cgi, $name) = @_;
103                 )
104       %>
105     </TD>
106   </TR>
107
108 </TABLE>
109
110 <BR>
111 <INPUT TYPE="submit" VALUE="Search Call Detail Records">
112
113 <% include('/elements/footer.html') %>
114 <%init>
115
116 die "access denied"
117   unless $FS::CurrentUser::CurrentUser->access_right('List rating data');
118
119 my @fields = fields('cdr');
120 my $labels = FS::cdr->table_info->{'fields'};
121
122 #XXX config
123 my @show_default = qw(
124   calldate clid src dst dcontext charged_party
125   startdate answerdate enddate duration billsec
126   disposition amaflags accountcode userfield
127   rated_price upstream_price carrierid 
128   svcnum freesidestatus freesiderewritestatus cdrbatch
129 );
130 my %show_default = map { $_=>1 } @show_default;
131
132 my $names_list = [ map {
133                          [ $_ => {
134                                    'label' => 'Show '. ( $labels->{$_} || $_ )
135                                  }
136                          ]
137                        } 
138                    @fields
139                  ];
140
141 </%init>