],
'fields' => [
sub { my $row = shift;
- $state_hash{substr($row->censustract, 0, 2)}++;
+ my $state = substr($row->censustract, 0, 2);
+ $state_hash{$state}++;
substr($row->censustract, 2, 3) || 'None'
},
sub { my $row = shift;
'download',
'technology_code',
sub { $cgi->param('_type') eq 'xml' ? '0' : '' },#broken
- 'quantity',
+ sub { my $row = shift;
+ my $state = substr($row->censustract, 0, 2);
+ $state_pkgcount{$state} += $row->quantity;
+ $row->quantity;
+ },
sub { my $row = shift; sprintf "%.2f", $row->residential },
],
'links' => [
my %search_hash = ();
my @sql_query = ();
my %state_hash = ();
+my %state_pkgcount = ();
for ( qw(agentnum magic) ) {
$search_hash{$_} = $cgi->param($_) if $cgi->param($_);
'</TD>'.
'<TD>'.
qq(<A HREF="${link}censustract2=$_">).
- $state_hash{$_}. ' census tracts</A>'.
+ $state_pkgcount{$_}. ' packages</A> in '.
+ $state_hash{$_}. ' census tracts'.
'</TD>'.
'</TR>';
}