add options for balance over/under to advanced customer report
[freeside.git] / httemplate / search / report_cust_main.html
1 <% include('/elements/header.html', 'Customer Report' ) %>
2
3 <FORM ACTION="cust_main.html" METHOD="GET">
4 <INPUT TYPE="hidden" NAME="magic" VALUE="bill">
5
6   <TABLE BGCOLOR="#cccccc" CELLSPACING=0>
7
8     <TR>
9       <TH BGCOLOR="#e8e8e8" COLSPAN=2 ALIGN="left"><FONT SIZE="+1">Search options</FONT></TH>
10     </TR>
11     <% include( '/elements/tr-select-agent.html',
12                    ($cgi->param('agentnum') || ''),
13                )
14     %>
15
16 %   foreach my $field (qw( signupdate )) {
17
18       <TR>
19         <TD ALIGN="right" VALIGN="center"><% $label{$field} %></TD>
20         <TD>
21           <TABLE>
22             <% include( '/elements/tr-input-beginning_ending.html',
23                           prefix   => $field,
24                           layout   => 'horiz',
25                       )
26             %>
27           </TABLE>
28         </TD>
29       </TR>
30
31 %   }
32     
33     <% include( '/elements/tr-input-lessthan_greaterthan.html',
34                   label   => 'Current Balance',
35                   field   => 'current_balance',
36               )
37     %>
38
39     <TR>
40       <TD ALIGN="right" VALIGN="center">Include cancelled packages</TD>
41         <TD><INPUT TYPE="checkbox" NAME="cancelled_pkgs"></TD>
42     </TR>
43
44     <TR>
45       <TH BGCOLOR="#e8e8e8" COLSPAN=2 ALIGN="left"><FONT SIZE="+1">Display options</FONT></TH>
46     </TR>
47     <% include( '/elements/tr-select-cust-fields.html' ) %>
48
49     <TR>
50       <TD ALIGN="right" VALIGN="center">Add package columns</TD>
51         <TD><INPUT TYPE="checkbox" NAME="flattened_pkgs"></TD>
52     </TR>
53   </TABLE>
54
55 <BR>
56 <INPUT TYPE="submit" VALUE="Get Report">
57
58 </FORM>
59
60 <% include('/elements/footer.html') %>
61 <%init>
62
63 die "access denied"
64   unless ( $FS::CurrentUser::CurrentUser->access_right('List customers') &&
65            $FS::CurrentUser::CurrentUser->access_right('List packages')
66          );;
67
68 </%init>
69 <%once>
70
71 my %label = (
72   'signupdate'     => 'Signup Date',
73 );
74
75 </%once>