X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2F477partVI_census.html;h=fc260bef8e7fe352b269d1ed0d10fceb52451f5c;hb=e14d7e0417e4e81ccf2e5b1edaac957c9b914ac1;hp=5f3039d1af3fbf059a14b20e068b9b73ef91b806;hpb=51add281a0ca46ffa75bfa5e2aa45c0da9bb9643;p=freeside.git diff --git a/httemplate/search/477partVI_census.html b/httemplate/search/477partVI_census.html index 5f3039d1a..fc260bef8 100755 --- a/httemplate/search/477partVI_census.html +++ b/httemplate/search/477partVI_census.html @@ -1,5 +1,6 @@ <% include( 'elements/search.html', 'html_init' => $html_init, + 'html_foot' => $html_foot,, 'name' => 'regions', 'query' => [ @sql_query ], 'count_query' => $count_query, @@ -28,12 +29,17 @@ 'percentage', ], 'fields' => [ - sub { my $row = shift; substr($row->censustract, 2, 3) }, - sub { my $row = shift; substr($row->censustract, 5) }, + sub { my $row = shift; + $state_hash{substr($row->censustract, 0, 2)}++; + substr($row->censustract, 2, 3) || 'None' + }, + sub { my $row = shift; + substr($row->censustract, 5) || 'None' + }, 'upload', 'download', 'technology_code', - sub { $cgi->param('_type') eq 'xml' ? '0' : '' }, # doesn't really work + sub { $cgi->param('_type') eq 'xml' ? '0' : '' },#broken 'quantity', sub { my $row = shift; sprintf "%.2f", $row->residential }, ], @@ -64,10 +70,12 @@ my $html_init = '
'. + ( &FS::Report::FCC_477::statenum2state($_) || 'None' ). + ' | '. + ''. + qq(). + $state_hash{$_}. ' census tracts'. + ' | '. + '