summaryrefslogtreecommitdiff
path: root/httemplate/elements/tr-select-taxclass.html
blob: 95cabf7f7eca7e53930d770b0a90443d3a2674e2 (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
% 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>