projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
RT# 75817 - added new file to hold javascript for password validation
[freeside.git]
/
httemplate
/
search
/
cust_main_churn.html
diff --git
a/httemplate/search/cust_main_churn.html
b/httemplate/search/cust_main_churn.html
index
59f92cb
..
f1ba450
100644
(file)
--- a/
httemplate/search/cust_main_churn.html
+++ b/
httemplate/search/cust_main_churn.html
@@
-33,6
+33,16
@@
'e_suspended',
'e_cancelled',
],
'e_suspended',
'e_cancelled',
],
+ 'sort_fields' => [
+ 'custnum',
+ FS::UI::Web::cust_sql_fields,
+ 's_active',
+ 's_suspended',
+ 's_cancelled',
+ 'e_active',
+ 'e_suspended',
+ 'e_cancelled',
+ ],
'color' => [
'',
FS::UI::Web::cust_colors(),
'color' => [
'',
FS::UI::Web::cust_colors(),
@@
-77,13
+87,20
@@
if ($cgi->param('agentnum') =~ /^(\d+)$/) {
# can't use this directly as it doesn't have any cust_main fields.
my $churn = FS::cust_main::Status->churn_sql($speriod, $eperiod);
# can't use this directly as it doesn't have any cust_main fields.
my $churn = FS::cust_main::Status->churn_sql($speriod, $eperiod);
+my $select = join(',',
+ 'churn.*',
+ 'cust_main.*',
+ FS::UI::Web::cust_sql_fields()
+);
+my $addl_from = " JOIN ($churn) AS churn USING (custnum) ".
+ FS::UI::Web::join_cust_main('cust_main.custnum') ;
my $query = {
'table' => 'cust_main',
my $query = {
'table' => 'cust_main',
- 'select' =>
'cust_main.*, churn.*'
,
- 'addl_from' =>
" JOIN ($churn) AS churn USING (custnum) "
,
+ 'select' =>
$select
,
+ 'addl_from' =>
$addl_from
,
};
};
-my $count_query = "SELECT COUNT(*) FROM cust_main
JOIN ($churn) AS churn USING (custnum)
";
+my $count_query = "SELECT COUNT(*) FROM cust_main
$addl_from
";
my @where;
my $status = $cgi->param('status');
my @where;
my $status = $cgi->param('status');