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,
17 field => $opt{'field'}.'_classnum',
18 table => 'inventory_class',
19 extra_sql => "WHERE $classnum_sql",
20 name_col => 'classname',
21 empty_label => '(all)',
24 field => $opt{'field'},
25 table => 'inventory_item',
28 link_col => 'classnum',
29 extra_sql => delete($opt{'extra_sql'}),
34 'prefix' => $opt{'prefix'}. $opt{'field'}. '_', #after %opt so it overrides
44 if (ref($opt{'classnum'})) {
45 @classnums = @{ $opt{'classnum'} };
47 @classnums = split(',', $opt{'classnum'});
49 my $classnum_sql = 'classnum IN('.join(',', @classnums).')';