diff options
Diffstat (limited to 'httemplate/search/report_rt_ticket.html')
-rw-r--r-- | httemplate/search/report_rt_ticket.html | 51 |
1 files changed, 0 insertions, 51 deletions
diff --git a/httemplate/search/report_rt_ticket.html b/httemplate/search/report_rt_ticket.html deleted file mode 100644 index 79a601b4b..000000000 --- a/httemplate/search/report_rt_ticket.html +++ /dev/null @@ -1,51 +0,0 @@ -<% include('/elements/header.html', 'Time worked summary report criteria' ) %> - -<FORM ACTION="rt_ticket.html" METHOD="GET"> - -<TABLE> - - <% include ( '/elements/tr-input-beginning_ending.html' ) %> - - <% include ( '/elements/tr-select-otaker.html' ) %> - - <TR> - <TD>Account</TD> - <TD> - <SELECT NAME="svcnum"> - <OPTION VALUE="">(all) -% foreach my $svc_acct (@svc_acct) { - <OPTION VALUE="<% $svc_acct->svcnum %>"><% $svc_acct->username %></OPTION> -% } - </SELECT> - </TD> - </TR> - -</TABLE> - -<BR> -<INPUT TYPE="submit" VALUE="Search"> - -</FORM> - -<% include('/elements/footer.html') %> -<%init> - -die "access denied" - unless $FS::CurrentUser::CurrentUser->access_right('List rating data'); - -my $conf = new FS::Conf; - -my @pkgparts = $conf->config('support_packages'); - -my @svc_acct = (); -if ( @pkgparts ) { - @svc_acct = qsearch({ - 'table' => 'svc_acct', - 'addl_from' => ' LEFT JOIN cust_svc USING ( svcnum ) '. - ' LEFT JOIN cust_pkg USING ( pkgnum ) ', - 'extra_sql' => 'WHERE pkgpart IN ('. join(',', @pkgparts). ')', - 'order_by' => 'ORDER BY username', - }); -} - -</%init> |