summaryrefslogtreecommitdiff
path: root/httemplate/elements/tr-select-taxclass.html
blob: 97f3cad0b3f04aeda7a4c73c4e96b2c6101f6530 (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
% if ( ! $conf->exists('enable_taxclasses')
%      || scalar(@{ $opt{'taxclasses'} }) == 0
% ) { 

  <INPUT TYPE="hidden" NAME="<% $opt{'element_name'} || $opt{'field'} || 'taxclass' %>" VALUE="<% $selected_taxclass %>">

% } else { 

  <TR>
    <TD ALIGN="right"><% $opt{'label'} || 'Tax class: ' %></TD>
    <TD>
      <% include( '/elements/select-taxclass.html',
                    'curr_value' => $selected_taxclass,
                    %opt
                )
      %>
    </TD>
  </TR>

% } 
<%init>

my( %opt ) = @_;
my $conf = new FS::Conf;
my $selected_taxclass = $opt{'curr_value'}; # || $opt{'value'} necessary?

unless ( $opt{'taxclasses'} ) {

  #my $sth = dbh->prepare('SELECT DISTINCT taxclass FROM cust_main_county')
  my $sth = dbh->prepare("SELECT taxclass FROM part_pkg_taxclass WHERE disabled IS NULL OR disabled = '' OR taxclass = ?")
    or die dbh->errstr;
  $sth->execute($selected_taxclass) or die $sth->errstr;
  my %taxclasses = map { $_->[0] => 1 } @{$sth->fetchall_arrayref};
  @{ $opt{'taxclasses'} } = grep $_, keys %taxclasses;

}

</%init>