X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Ftax_rate_location.pm;h=e33859123685a8f78ead094ea8379928795117d8;hp=ad3618a9835dd347f5012318f724cb420e992082;hb=11b4982061aac4c57c1a694cc87f8c1f264ac22a;hpb=5f7c4a6025b9e3a49bee72dbc06cac37a45e6f10 diff --git a/FS/FS/tax_rate_location.pm b/FS/FS/tax_rate_location.pm index ad3618a98..e33859123 100644 --- a/FS/FS/tax_rate_location.pm +++ b/FS/FS/tax_rate_location.pm @@ -111,6 +111,7 @@ sub check { $self->ut_numbern('taxratelocationnum') || $self->ut_textn('data_vendor') || $self->ut_alpha('geocode') + || $self->ut_textn('district') || $self->ut_textn('city') || $self->ut_textn('county') || $self->ut_textn('state') @@ -171,13 +172,9 @@ sub find_or_insert { sub existing_search { my $self = shift; - my @unique = qw( data_vendor geocode ); - push @unique, qw( state country ) - if $self->data_vendor eq 'compliance_solutions'; - qsearchs( 'tax_rate_location', { disabled => '', - map { $_ => $self->$_ } @unique + map { $_ => $self->$_ } qw( data_vendor geocode ) } ); } @@ -399,13 +396,14 @@ sub batch_import { } sub _upgrade_data { - my $class = shift; - - my $sql = "UPDATE tax_rate_location SET data_vendor = 'compliance_solutions' WHERE data_vendor = 'compliance solutions'"; - - my $sth = dbh->prepare($sql) or die $DBI::errstr; - $sth->execute() or die $sth->errstr; - +#actually no, we want to leave those records behind now that they're giving us +# geo_state etc. +# my $class = shift; +# +# my $sql = "UPDATE tax_rate_location SET data_vendor = 'compliance_solutions' WHERE data_vendor = 'compliance solutions'"; +# +# my $sth = dbh->prepare($sql) or die $DBI::errstr; +# $sth->execute() or die $sth->errstr; } =head1 BUGS