use vars qw( $DEBUG $me );
use Carp;
use Locale::Country;
+use Geo::Coder::Googlev3; #compile time for now, until others are supported
use FS::Record qw( qsearchs qsearch );
use FS::Conf;
use FS::cust_pkg;
$notfirst++;
}
- if ( $self->get($prefix.'location_type') ) {
+ my $lt = $self->get($prefix.'location_type');
+ if ( $lt ) {
my %location_type;
if ( 1 ) { #ikano, switch on via config
{ no warnings 'void';
%location_type = (); #?
}
- $line .= ' '.&$escape( $location_type{ $self->get($prefix.'location_type') }
- || $self->get($prefix.'location_type')
- );
+ $line .= ' '.&$escape( $location_type{$lt} || $lt );
}
$line .= ' '. &$escape($self->get($prefix.'location_number'))
$line;
}
+=item set_coord [ PREFIX ]
+
+Look up the coordinates of the location using (currently) the Google Maps
+API and set the 'latitude' and 'longitude' fields accordingly.
+
+PREFIX, if specified, will be prepended to all location field names,
+including latitude and longitude.
+
+=cut
+
+sub set_coord {
+ my $self = shift;
+ my $pre = scalar(@_) ? shift : '';
+
+ #my $module = FS::Conf->new->config('geocode_module') || 'Geo::Coder::Googlev3';
+
+ my $geocoder = Geo::Coder::Googlev3->new;
+
+ my $location = eval {
+ $geocoder->geocode( location =>
+ $self->get($pre.'address1'). ','.
+ ( $self->get($pre.'address2') ? $self->get($pre.'address2').',' : '' ).
+ $self->get($pre.'city'). ','.
+ $self->get($pre.'state'). ','.
+ code2country($self->get($pre.'country'))
+ );
+ };
+ if ( $@ ) {
+ warn "geocoding error: $@\n";
+ return;
+ }
+
+ my $geo_loc = $location->{'geometry'}{'location'} or return;
+ if ( $geo_loc->{'lat'} && $geo_loc->{'lng'} ) {
+ $self->set($pre.'latitude', $geo_loc->{'lat'} );
+ $self->set($pre.'longitude', $geo_loc->{'lng'} );
+ $self->set($pre.'coord_auto', 'Y');
+ }
+
+}
+
=item geocode DATA_VENDOR
Returns a value for the customer location as encoded by DATA_VENDOR.
$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( {
$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;
}
-=item alternize
+=item process_district_update CLASS ID
-Attempts to parse data for location_type and location_number from address1
-and address2.
+Queueable function to update the tax district code using the selected method
+(config 'tax_district_method'). CLASS is either 'FS::cust_main' or
+'FS::cust_location'; ID is the key in one of those tables.
=cut
-sub alternize {
- my $self = shift;
- my $prefix = $self->has_ship_address ? 'ship_' : '';
-
- return '' if $self->get($prefix.'location_type')
- || $self->get($prefix.'location_number');
-
- my %parse;
- if ( 1 ) { #ikano, switch on via config
- { no warnings 'void';
- eval { 'use FS::part_export::ikano;' };
- die $@ if $@;
+sub process_district_update {
+ my $class = shift;
+ my $id = shift;
+
+ eval "use FS::Misc::Geo qw(get_district); use FS::Conf; use $class;";
+ die $@ if $@;
+ die "$class has no location data" if !$class->can('location_hash');
+
+ my $conf = FS::Conf->new;
+ my $method = $conf->config('tax_district_method')
+ or return; #nothing to do if null
+ my $self = $class->by_key($id) or die "object $id not found";
+
+ # dies on error, fine
+ my $tax_info = get_district({ $self->location_hash }, $method);
+
+ if ( $tax_info ) {
+ $self->set('district', $tax_info->{'district'} );
+ my $error = $self->replace;
+ die $error if $error;
+
+ my %hash = map { $_ => $tax_info->{$_} }
+ qw( district city county state country );
+ my $old = qsearchs('cust_main_county', \%hash);
+ if ( $old ) {
+ my $new = new FS::cust_main_county { $old->hash, %$tax_info };
+ warn "updating tax rate for district ".$tax_info->{'district'} if $DEBUG;
+ $error = $new->replace($old);
}
- %parse = FS::part_export::ikano->location_types_parse;
- } else {
- %parse = (); #?
- }
-
- foreach my $from ('address1', 'address2') {
- foreach my $parse ( keys %parse ) {
- my $value = $self->get($prefix.$from);
- if ( $value =~ s/(^|\W+)$parse\W+(\w+)\W*$//i ) {
- $self->set($prefix.'location_type', $parse{$parse});
- $self->set($prefix.'location_number', $2);
- $self->set($prefix.$from, $value);
- return '';
- }
+ else {
+ my $new = new FS::cust_main_county $tax_info;
+ warn "creating tax rate for district ".$tax_info->{'district'} if $DEBUG;
+ $error = $new->insert;
}
- }
+ die $error if $error;
- #nothing matched, no changes
- $self->get($prefix.'address2')
- ? "Can't parse unit type and number from ${prefix}address2"
- : '';
+ }
+ return;
}
=back