blob: 8f149bb94dedb31dcfe506d1c5121118be5e3940 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
% if ( $error ) {
% $cgi->param('error', $error);
<% $cgi->redirect(popurl(2). "part_pkg_taxclass.html?". $cgi->query_string ) %>
%} else {
<% $cgi->redirect(popurl(3). "browse/cust_main_county.cgi?taxclass=". uri_escape($part_pkg_taxclass->taxclass) ) %>
%}
<%init>
die "access denied"
unless $FS::CurrentUser::CurrentUser->access_right('Configuration');
my $part_pkg_taxclass = new FS::part_pkg_taxclass {
'taxclass' => $cgi->param('taxclass'),
};
#maybe this whole thing should be in a transaction. at some point, no biggie
#none of the follow-up stuff will fail unless there's a more serious problem
#than a hanging record in part_pkg_taxclass...
my $error = $part_pkg_taxclass->insert;
unless ( $error ) {
#auto-add the new taxclass to any regions that have taxclasses already
my $sth = dbh->prepare("
SELECT country, state, county FROM cust_main_county
WHERE taxclass IS NOT NULL AND taxclass != ''
GROUP BY country, state, county
") or die dbh->errstr;
$sth->execute or die $sth->errstr;
while ( my $row = $sth->fetchrow_hashref ) {
warn "inserting for $row";
my $cust_main_county = new FS::cust_main_county {
'country' => $row->{country},
'state' => $row->{state},
'county' => $row->{county},
'tax' => 0,
'taxclass' => $part_pkg_taxclass->taxclass,
#exempt_amount
#taxname
#setuptax
#recurtax
};
$error = $cust_main_county->insert;
#last if $error;
die $error if $error;
}
}
</%init>
|
