From: ivan Date: Tue, 19 Jul 2011 21:27:06 +0000 (+0000) Subject: fix geocode guessing w/a 5 digit zip, RT#13595 X-Git-Tag: freeside_2_3_0~15 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=f05e5e44e3472e70f121f264ed39bd708673bcf7 fix geocode guessing w/a 5 digit zip, RT#13595 --- diff --git a/FS/FS/geocode_Mixin.pm b/FS/FS/geocode_Mixin.pm index 4f8d1e85c..c1b9f865b 100644 --- a/FS/FS/geocode_Mixin.pm +++ b/FS/FS/geocode_Mixin.pm @@ -155,7 +155,8 @@ sub geocode { $zip ||= ''; $plus4 ||= ''; #CCH specific location stuff - my $extra_sql = "AND plus4lo <= '$plus4' AND plus4hi >= '$plus4'"; + my $extra_sql = $plus4 ? "AND plus4lo <= '$plus4' AND plus4hi >= '$plus4'" + : ''; my @cust_tax_location = qsearch( { @@ -168,6 +169,11 @@ sub geocode { $geocode = $cust_tax_location[0]->geocode if scalar(@cust_tax_location); + warn "WARNING: customer ". $self->custnum. + ": multiple locations for zip ". $self->get("${prefix}zip"). + "; using arbitrary geocode $geocode\n" + if scalar(@cust_tax_location) > 1; + $geocode; }