1 <% include('/elements/header.html', 'Customer Report' ) %>
3 <FORM ACTION="cust_main.html" METHOD="GET">
4 <INPUT TYPE="hidden" NAME="magic" VALUE="bill">
6 <TABLE BGCOLOR="#cccccc" CELLSPACING=0>
9 <TH BGCOLOR="#e8e8e8" COLSPAN=2 ALIGN="left"><FONT SIZE="+1">Search options</FONT></TH>
12 <% include( '/elements/tr-select-agent.html',
13 'curr_value' => scalar($cgi->param('agentnum')),
18 <% include( '/elements/tr-select-cust_main-status.html',
23 <% include( '/elements/tr-select-cust_class.html',
26 'pre_options' => [ '' => '(none)' ],
31 % foreach my $field (qw( signupdate )) {
34 <TD ALIGN="right" VALIGN="center"><% $label{$field} %></TD>
37 <% include( '/elements/tr-input-beginning_ending.html',
48 <% include( '/elements/tr-select-payby.html',
49 'payby_type' => 'cust',
51 'curr_value' => { map { $_ => 1 } FS::payby->cust_payby },
55 <% include( '/elements/tr-input-lessthan_greaterthan.html',
56 label => 'Current balance',
57 field => 'current_balance',
62 <TD ALIGN="right" VALIGN="center">Include cancelled packages</TD>
63 <TD><INPUT TYPE="checkbox" NAME="cancelled_pkgs"></TD>
66 % if ( $conf->exists('cust_main-require_censustract') ) {
69 <TD ALIGN="right" VALIGN="center">Without census tract</TD>
70 <TD><INPUT TYPE="checkbox" NAME="no_censustract"></TD>
76 <TH BGCOLOR="#e8e8e8" COLSPAN=2> </TH>
80 <TH BGCOLOR="#e8e8e8" COLSPAN=2 ALIGN="left"><FONT SIZE="+1">Display options</FONT></TH>
82 <% include( '/elements/tr-select-cust-fields.html' ) %>
85 <TD ALIGN="right" VALIGN="center">Add package columns</TD>
86 <TD><INPUT TYPE="checkbox" NAME="flattened_pkgs"></TD>
91 <INPUT TYPE="submit" VALUE="Get Report">
95 <% include('/elements/footer.html') %>
99 unless ( $FS::CurrentUser::CurrentUser->access_right('List customers') &&
100 $FS::CurrentUser::CurrentUser->access_right('List packages')
103 my $conf = new FS::Conf;
109 'signupdate' => 'Signup date',