2 %$cgi->param('class') =~ /^(\w)$/ or die "illegal class";
5 %my %classmap = ( 'C' => 'cancel',
9 %my $classname = $classmap{$class};
11 %my $html_init = ucfirst($classname) .
12 % " reasons explain why we $classname a package.<BR><BR>".
13 % qq!<A HREF="${p}edit/reason.html?class=$class">!.
14 % "<I>Add a $classname reason</I></A><BR><BR>";
16 %my $where_clause = "WHERE class='$class'";
17 %$where_clause .= " AND (disabled = '' OR disabled IS NULL)"
18 % unless $cgi->param('showdisabled');
20 %my $disabledurl = $cgi->param('showdisabled')
21 % ? do { $cgi->param('showdisabled', 0);
22 % '( <a href="'. $cgi->self_url. '">hide disabled reasons</a> )'; }
23 % : do { $cgi->param('showdisabled', 1);
24 % '( <a href="'. $cgi->self_url. '">show disabled reasons</a> )'; }
27 %$html_init .= $disabledurl;
29 %my $count_query = 'SELECT COUNT(*) FROM reason LEFT JOIN reason_type on ' .
30 % 'reason_type.typenum = reason.reason_type ' . $where_clause;
32 %my $link = [ $p."edit/reason.html?class=$class&reasonnum=", 'reasonnum' ];
35 <% include( 'elements/browse.html',
36 'title' => ucfirst($classname) . ' Reasons',
37 'menubar' => [ # 'Main menu' => $p,
38 ucfirst($classname) . ' Reason Types' =>
39 $p.'browse/reason_type.html?class='.
42 'html_init' => $html_init,
43 'name' => $classname . ' reasons',
44 'query' => { 'table' => 'reason',
46 'extra_sql' => $where_clause .
47 'ORDER BY reason_type',
48 'addl_from' => 'LEFT JOIN reason_type ON reason_type.typenum = reason.reason_type',
50 'count_query' => $count_query,
52 ucfirst($classname) . ' Reason Type',
53 ucfirst($classname) . ' Reason',
55 'fields' => [ 'reasonnum',
56 sub { shift->reasontype->type },