1 % if ( scalar(@classnums) == 0 ) {
2 <& tr-fixed.html, %opt &>
3 % } elsif ( scalar(@classnums) == 1 ) {
4 % $opt{'extra_sql'} .= ' AND '.$classnum_sql;
5 <& tr-select-table.html,
6 'table' => 'inventory_item',
12 <& tr-td-label.html, %opt &>
14 <& select-tiered.html,
15 'prefix' => $opt{'field'}.'_',
18 field => $opt{'field'}.'_classnum',
19 table => 'inventory_class',
20 extra_sql => "WHERE $classnum_sql",
21 name_col => 'classname',
22 empty_label => '(all)',
25 field => $opt{'field'},
26 table => 'inventory_item',
29 link_col => 'classnum',
30 extra_sql => delete($opt{'extra_sql'}),
42 if (ref($opt{'classnum'})) {
43 @classnums = @{ $opt{'classnum'} };
45 @classnums = split(',', $opt{'classnum'});
47 my $classnum_sql = 'classnum IN('.join(',', @classnums).')';