1 <FORM NAME="choosegeocodeform">
2 <CENTER><BR><B>Choose tax location</B><BR><BR>
3 <P STYLE="<% $style %>"><% $header %></P>
5 <SELECT NAME='geocodes' ID='geocodes' STYLE="<% $style %>">
6 % foreach my $location (@cust_tax_location) {
7 % my %value = ( zip => $zip5,
8 % map { $_ => $location->$_ }
9 % qw ( city state geocode )
11 % map { $value{$_} = $location{$_} } qw ( city state )
12 % if $location{country} eq 'CA';
14 % my $value = encode_entities(encode_json({ %value })
17 % $content .= $location->$_. ' ' x ( $max{$_} - length($location->$_) )
18 % foreach qw( city county state );
19 % $content .= $location->cityflag eq 'I' ? 'Y' : 'N' ;
21 % if ($geocode && $location->geocode eq $geocode) {
22 % $selected = 'SELECTED';
24 <OPTION VALUE="<% $value %>" STYLE="<% $style %>" <% $selected %>><% $content %>
29 <TD> <BUTTON TYPE="button" onClick="set_geocode(document.getElementById('geocodes'));"><IMG SRC="<%$p%>images/tick.png" ALT=""> Set location </BUTTON></TD>
30 <TD><BUTTON TYPE="button" onClick="document.<% $formname %>.submitButton.disabled=false; parent.cClick();"><IMG SRC="<%$p%>images/cross.png" ALT=""> Cancel submission </BUTTON></TD>
38 my $conf = new FS::Conf;
42 ($location{data_vendor}) = $cgi->param('data_vendor') =~ /^([-\w]+)$/;
43 ($location{city}) = $cgi->param('city') =~ /^([\w ]+)$/;
44 ($location{state}) = $cgi->param('state') =~ /^(\w+)$/;
45 ($location{zip}) = $cgi->param('zip') =~ /^([-\w ]+)$/;
46 ($location{country}) = $cgi->param('country') =~ /^([\w ]+)$/;
48 my($geocode) = $cgi->param('geocode') =~ /^([\w]+)$/;
50 my($formname) = $cgi->param('formname') =~ /^([\w]*)$/;
51 $formname ||= 'CustomerForm';
53 my($zip5, $zip4) = split('-', $location{zip});
56 my $hashref = { 'data_vendor' => $location{data_vendor} };
57 $hashref->{zip} = $location{country} eq 'CA' ? substr($zip5,0,1) : $zip5,
59 my @keys = keys(%$hashref);
60 my @cust_tax_location = ();
61 until ( @cust_tax_location ) {
62 @cust_tax_location = qsearch({ table => 'cust_tax_location',
64 order_by => 'LIMIT 50',
66 last unless scalar(@keys);
67 delete $hashref->{ shift @keys };
70 my %max = ( city => 4, county => 6, state => 5);
71 foreach my $location (@cust_tax_location) {
72 foreach ( qw( city county state ) ) {
73 my $length = length($location->$_);
74 $max{$_} = ($length > $max{$_}) ? $length : $max{$_};
77 foreach ( qw( city county state ) ) {
78 $max{$_} = $location{$_} if $location{$_} > $max{$_};
82 my $header = ' ';
83 $header .= $_. ' ' x ( $max{lc($_)} - length($_) )
84 foreach qw( City County State );
85 $header .= "In city?";
87 my $style = "font-family:monospace;";