projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
show a warning when the OS goes EOL
[freeside.git]
/
httemplate
/
elements
/
tr-select-taxclass.html
diff --git
a/httemplate/elements/tr-select-taxclass.html
b/httemplate/elements/tr-select-taxclass.html
index
981c1a5
..
22c560e
100644
(file)
--- a/
httemplate/elements/tr-select-taxclass.html
+++ b/
httemplate/elements/tr-select-taxclass.html
@@
-7,9
+7,13
@@
% } else {
<TR>
% } else {
<TR>
- <T
D ALIGN="right"><% $opt{'label'} || 'Tax class: ' %></TD
>
+ <T
H ALIGN="right"><% $opt{'label'} || 'Tax class: ' %></TH
>
<TD>
<TD>
- <% include( '/elements/select-taxclass.html', 'curr_value' => $selected_taxclass, %opt ) %>
+ <% include( '/elements/select-taxclass.html',
+ 'curr_value' => $selected_taxclass,
+ %opt
+ )
+ %>
</TD>
</TR>
</TD>
</TR>
@@
-23,9
+27,9
@@
my $selected_taxclass = $opt{'curr_value'}; # || $opt{'value'} necessary?
unless ( $opt{'taxclasses'} ) {
#my $sth = dbh->prepare('SELECT DISTINCT taxclass FROM cust_main_county')
unless ( $opt{'taxclasses'} ) {
#my $sth = dbh->prepare('SELECT DISTINCT taxclass FROM cust_main_county')
- my $sth = dbh->prepare(
'SELECT taxclass FROM part_pkg_taxclass'
)
+ my $sth = dbh->prepare(
"SELECT taxclass FROM part_pkg_taxclass WHERE disabled IS NULL OR disabled = '' OR taxclass = ?"
)
or die dbh->errstr;
or die dbh->errstr;
- $sth->execute or die $sth->errstr;
+ $sth->execute
($selected_taxclass)
or die $sth->errstr;
my %taxclasses = map { $_->[0] => 1 } @{$sth->fetchall_arrayref};
@{ $opt{'taxclasses'} } = grep $_, keys %taxclasses;
my %taxclasses = map { $_->[0] => 1 } @{$sth->fetchall_arrayref};
@{ $opt{'taxclasses'} } = grep $_, keys %taxclasses;