projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
self-service ticket priority and edit subject, #13199
[freeside.git]
/
httemplate
/
search
/
477partVI_census.html
diff --git
a/httemplate/search/477partVI_census.html
b/httemplate/search/477partVI_census.html
index
5f3039d
..
9134bac
100755
(executable)
--- a/
httemplate/search/477partVI_census.html
+++ b/
httemplate/search/477partVI_census.html
@@
-1,5
+1,13
@@
<% include( 'elements/search.html',
'html_init' => $html_init,
<% include( 'elements/search.html',
'html_init' => $html_init,
+ 'html_foot' => sub { if (scalar(keys %state_hash) > 1) {
+ '<BR><B>'.
+ 'WARNING: multiple states found'.
+ '</B><BR>';
+ } else {
+ '';
+ }
+ },
'name' => 'regions',
'query' => [ @sql_query ],
'count_query' => $count_query,
'name' => 'regions',
'query' => [ @sql_query ],
'count_query' => $count_query,
@@
-28,7
+36,10
@@
'percentage',
],
'fields' => [
'percentage',
],
'fields' => [
- sub { my $row = shift; substr($row->censustract, 2, 3) },
+ sub { my $row = shift;
+ $state_hash{substr($row->censustract, 0, 2)} = 1;
+ substr($row->censustract, 2, 3)
+ },
sub { my $row = shift; substr($row->censustract, 5) },
'upload',
'download',
sub { my $row = shift; substr($row->censustract, 5) },
'upload',
'download',
@@
-64,10
+75,12
@@
my $html_init = '<H2>Part VI</H2>';
my %search_hash = ();
my @sql_query = ();
my %search_hash = ();
my @sql_query = ();
+my %state_hash = ();
-for ( qw(agentnum magic
classnum
) ) {
+for ( qw(agentnum magic) ) {
$search_hash{$_} = $cgi->param($_) if $cgi->param($_);
}
$search_hash{$_} = $cgi->param($_) if $cgi->param($_);
}
+$search_hash{'classnum'} = [ $cgi->param('classnum') ];
my @column_option = grep { /^\d+$/ } $cgi->param('part1_column_option')
if $cgi->param('part1_column_option');
my @column_option = grep { /^\d+$/ } $cgi->param('part1_column_option')
if $cgi->param('part1_column_option');