projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
package churn report filtering by advertising source, tower, and zip code, #26999
[freeside.git]
/
httemplate
/
search
/
cust_pkg.cgi
diff --git
a/httemplate/search/cust_pkg.cgi
b/httemplate/search/cust_pkg.cgi
index
8f4cce1
..
c388487
100755
(executable)
--- a/
httemplate/search/cust_pkg.cgi
+++ b/
httemplate/search/cust_pkg.cgi
@@
-9,6
+9,8
@@
emt('Package'),
emt('Class'),
emt('Status'),
emt('Package'),
emt('Class'),
emt('Status'),
+ emt('Sales Person'),
+ emt('Ordered by'),
emt('Setup'),
emt('Base Recur'),
emt('Freq.'),
emt('Setup'),
emt('Base Recur'),
emt('Freq.'),
@@
-20,6
+22,7
@@
emt('Susp. delay'),
emt('Expire'),
emt('Contract end'),
emt('Susp. delay'),
emt('Expire'),
emt('Contract end'),
+ emt('Changed'),
emt('Cancel'),
emt('Reason'),
FS::UI::Web::cust_header(
emt('Cancel'),
emt('Reason'),
FS::UI::Web::cust_header(
@@
-33,6
+36,8
@@
sub { $_[0]->pkg; },
'classname',
sub { ucfirst(shift->status); },
sub { $_[0]->pkg; },
'classname',
sub { ucfirst(shift->status); },
+ 'salesperson',
+ 'otaker',
sub { sprintf( $money_char.'%.2f',
shift->part_pkg->option('setup_fee'),
);
sub { sprintf( $money_char.'%.2f',
shift->part_pkg->option('setup_fee'),
);
@@
-45,7
+50,7
@@
sub { FS::part_pkg::freq_pretty(shift); },
( map { time_or_blank($_) }
sub { FS::part_pkg::freq_pretty(shift); },
( map { time_or_blank($_) }
- qw( setup last_bill bill adjourn susp dundate expire contract_end cancel ) ),
+ qw( setup last_bill bill adjourn susp dundate expire contract_end c
hange_date c
ancel ) ),
sub { my $self = shift;
my $return = '';
sub { my $self = shift;
my $return = '';
@@
-94,13
+99,16
@@
'',
'',
'',
'',
'',
'',
+ '',
+ '',
+ '',
FS::UI::Web::cust_colors(),
'',
],
FS::UI::Web::cust_colors(),
'',
],
- 'style' => [ '', '', '', '', 'b', '', '', '', '', '', '', '', '', '', '', '', '', '',
+ 'style' => [ '', '', '', '', 'b', '', '', '', '', '', '', '', '', '', '', '', '', '',
'', '', '',
FS::UI::Web::cust_styles() ],
'size' => [ '', '', '', '', '-1' ],
FS::UI::Web::cust_styles() ],
'size' => [ '', '', '', '', '-1' ],
- 'align' => 'rrlcc
rrl
rrrrrrrrrl'. FS::UI::Web::cust_aligns(). 'r',
+ 'align' => 'rrlcc
ccrrlr
rrrrrrrrrl'. FS::UI::Web::cust_aligns(). 'r',
'links' => [
$link,
$link,
'links' => [
$link,
$link,
@@
-119,6
+127,9
@@
'',
'',
'',
'',
'',
'',
+ '', # link to changed-from package?
+ '',
+ '',
'',
( map { $_ ne 'Cust. Status' ? $clink : '' }
FS::UI::Web::cust_header(
'',
( map { $_ ne 'Cust. Status' ? $clink : '' }
FS::UI::Web::cust_header(
@@
-145,12
+156,15
@@
my %search_hash = ();
$search_hash{'query'} = $cgi->keywords;
#scalars
$search_hash{'query'} = $cgi->keywords;
#scalars
-for (qw( agentnum custnum magic status custom cust_fields pkgbatch )) {
- $search_hash{$_} = $cgi->param($_) if $cgi->param($_);
+for (qw( agentnum cust_status cust_main_salesnum salesnum custnum magic status
+ custom cust_fields pkgbatch zip
+ ))
+{
+ $search_hash{$_} = $cgi->param($_) if length($cgi->param($_));
}
#arrays
}
#arrays
-for my $param (qw( pkgpart classnum )) {
+for my $param (qw( pkgpart classnum
refnum towernum
)) {
$search_hash{$param} = [ $cgi->param($param) ]
if grep { $_ eq $param } $cgi->param;
}
$search_hash{$param} = [ $cgi->param($param) ]
if grep { $_ eq $param } $cgi->param;
}
@@
-161,10
+175,14
@@
for my $param (qw( censustract censustract2 )) {
if grep { $_ eq $param } $cgi->param;
}
if grep { $_ eq $param } $cgi->param;
}
+#location flags (checkboxes)
+my @loc = grep /^\w+$/, $cgi->param('loc');
+$search_hash{"location_$_"} = 1 foreach @loc;
+
my $report_option = $cgi->param('report_option');
$search_hash{report_option} = $report_option if $report_option;
my $report_option = $cgi->param('report_option');
$search_hash{report_option} = $report_option if $report_option;
-for my $param (grep /^report_option_any/, $cgi->param
s
) {
+for my $param (grep /^report_option_any/, $cgi->param) {
$search_hash{$param} = $cgi->param($param);
}
$search_hash{$param} = $cgi->param($param);
}
@@
-182,7
+200,7
@@
my %disable = (
'' => {},
);
'' => {},
);
-foreach my $field (qw( setup last_bill bill adjourn susp expire contract_end cancel active )) {
+foreach my $field (qw( setup last_bill bill adjourn susp expire contract_end c
hange_date c
ancel active )) {
my($beginning, $ending) = FS::UI::Web::parse_beginning_ending($cgi, $field);
my($beginning, $ending) = FS::UI::Web::parse_beginning_ending($cgi, $field);