X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fedit%2Fcust_main_county-expand.cgi;h=abf8e27f2e215b20afd63ef36f4d1f830df4a350;hb=1f0e0fb65fdd32d57a3134c018d5a1dc0f09e249;hp=f56d31941b4d5e846f8a816db145beb2e850244d;hpb=3b720b3194fb140737a87830b32b2e8d616215f4;p=freeside.git diff --git a/httemplate/edit/cust_main_county-expand.cgi b/httemplate/edit/cust_main_county-expand.cgi index f56d31941..abf8e27f2 100755 --- a/httemplate/edit/cust_main_county-expand.cgi +++ b/httemplate/edit/cust_main_county-expand.cgi @@ -1,59 +1,65 @@ - -% -% -%my($taxnum, $delim, $expansion, $taxclass ); -%my($query) = $cgi->keywords; -%if ( $cgi->param('error') ) { -% $taxnum = $cgi->param('taxnum'); -% $delim = $cgi->param('delim'); -% $expansion = $cgi->param('expansion'); -% $taxclass = $cgi->param('taxclass'); -%} else { -% $query =~ /^(taxclass)?(\d+)$/ -% or die "Illegal taxnum (query $query)"; -% $taxclass = $1 ? 'taxclass' : ''; -% $taxnum = $2; -% $delim = 'n'; -% $expansion = ''; -%} -% -%my $cust_main_county = qsearchs('cust_main_county',{'taxnum'=>$taxnum}) -% or die "cust_main_county.taxnum $taxnum not found"; -%if ( $taxclass ) { -% die "Can't expand entry!" if $cust_main_county->getfield('taxclass'); -%} else { -% die "Can't expand entry!" if $cust_main_county->getfield('county'); -%} -% -%my $p1 = popurl(1); -%print header("Tax Rate (expand)", menubar( -% 'Main Menu' => popurl(2), -%)); -% -%print qq!Error: !, $cgi->param('error'), -% "" -% if $cgi->param('error'); -% -%print < -% -% -% Separate by -%END -%print 'line (broken on some browsers) or', -% 'whitespace.'; -%print < -%
-% -% -% -% -%END -% -% +<% include('/elements/header-popup.html', "Enter $title") %> +<% include('/elements/error.html') %> + +
+ + + + + + +
+ + +
+ + + +<%init> + +my($taxnum, $expansion, $taxclass); +my($query) = $cgi->keywords; +if ( $cgi->param('error') ) { + $taxnum = $cgi->param('taxnum'); + $expansion = $cgi->param('expansion'); + $taxclass = $cgi->param('taxclass'); +} else { + $query =~ /^(taxclass)?(\d+)$/ + or die "Illegal taxnum (query $query)"; + $taxclass = $1 ? 'taxclass' : ''; + $taxnum = $2; + $expansion = ''; +} + +my $cust_main_county = qsearchs('cust_main_county',{'taxnum'=>$taxnum}) + or die "cust_main_county.taxnum $taxnum not found"; + +my $title; +if ( $taxclass ) { + die "Can't expand entry!" if $cust_main_county->taxclass; + + $title = 'Tax Classes'; + + # prepopuplate with other tax classes... which should really have a primary + # key of their own... also this could be more efficient in the error case... + my $sth = dbh->prepare("SELECT DISTINCT taxclass FROM cust_main_county") + or die dbh->errstr; + $sth->execute or die $sth->errstr; + my %taxclasses = map { $_->[0] => 1 } @{$sth->fetchall_arrayref}; + $expansion ||= join("\n", grep $_, keys %taxclasses ); + +} else { + die "Can't expand entry!" if $cust_main_county->county; + + if ( $cust_main_county->state ) { + $title = 'Counties'; + } else { + $title = 'States/Provinces'; + } + +} + +my $p1 = popurl(1); + +