From f05e5e44e3472e70f121f264ed39bd708673bcf7 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 19 Jul 2011 21:27:06 +0000 Subject: [PATCH] fix geocode guessing w/a 5 digit zip, RT#13595 --- FS/FS/geocode_Mixin.pm | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) 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; } -- 2.11.0