suspension and cancellation reasons
[freeside.git] / httemplate / browse / reason.html
diff --git a/httemplate/browse/reason.html b/httemplate/browse/reason.html
new file mode 100644 (file)
index 0000000..e666142
--- /dev/null
@@ -0,0 +1,64 @@
+%
+%$cgi->param('class') =~ /^(\w)$/ or die "illegal class";
+%my $class = $1;
+%
+%my %classmap = ( 'C' => 'cancel',
+%                 'S' => 'suspend',
+%               );
+%
+%my $classname = $classmap{$class};
+%
+%my $html_init = ucfirst($classname) .
+%  " reasons explain why we $classname a package.<BR><BR>".
+%  qq!<A HREF="${p}edit/reason.html?class=$class">!.
+%  "<I>Add a $classname reason</I></A><BR><BR>";
+%
+%my $where_clause = "WHERE class='$class'";
+%$where_clause .= " AND (disabled = '' OR disabled IS NULL)"
+%  unless $cgi->param('showdisabled');
+
+%my $disabledurl = $cgi->param('showdisabled')
+%     ? do { $cgi->param('showdisabled', 0);
+%           '( <a href="'. $cgi->self_url. '">hide disabled reasons</a> )'; }
+%     : do { $cgi->param('showdisabled', 1);
+%           '( <a href="'. $cgi->self_url. '">show disabled reasons</a> )'; }
+%     ;
+%
+%$html_init .= $disabledurl;
+%
+%my $count_query = 'SELECT COUNT(*) FROM reason LEFT JOIN reason_type on ' .
+%                  'reason_type.typenum = reason.reason_type ' . $where_clause;
+%
+%my $link = [ $p."edit/reason.html?class=$class&reasonnum=", 'reasonnum' ];
+%
+%
+<% include( 'elements/browse.html',
+                 'title'       => ucfirst($classname) . ' Reasons',
+                 'menubar'     => [ # 'Main menu' => $p,
+                                    ucfirst($classname) . ' Reason Types' =>
+                                      $p.'browse/reason_type.html?class='.
+                                      $class,
+                                  ],
+                 'html_init'   => $html_init,
+                 'name'        => $classname . ' reasons',
+                 'query'       => { 'table'     => 'reason',
+                                    'hashref'   => {},
+                                    'extra_sql' => $where_clause . 
+                                                  'ORDER BY reason_type', 
+                                    'addl_from' => 'LEFT JOIN reason_type ON reason_type.typenum = reason.reason_type', 
+                                  },
+                 'count_query' => $count_query,
+                 'header'      => [ '#',
+                                    ucfirst($classname) . ' Reason Type',
+                                    ucfirst($classname) . ' Reason',
+                                  ],
+                 'fields'      => [ 'reasonnum',
+                                    sub { shift->reasontype->type },
+                                    'reason',
+                                  ],
+                 'links'       => [ $link,
+                                    $link,
+                                    '',
+                                  ],
+             )
+%>