1 <% include('/elements/header.html', 'Time worked report criteria' ) %>
3 <FORM ACTION="rt_transaction.html" METHOD="GET">
7 <% include ( '/elements/tr-input-beginning_ending.html' ) %>
9 <& /elements/tr-td-label.html, label => 'Time category:' &>
11 <& /elements/select-rt-customfield.html,
13 lookuptype => 'RT::Transaction',
14 valuetype => 'TimeValue',
15 empty_label => 'Worked',
20 <% include ( '/elements/tr-select-otaker.html' ) %>
22 <% include ( '/elements/tr-input-text.html',
23 'label' => 'Ticket #',
24 'field' => 'ticketid',
29 <TD ALIGN="right">Account:</TD>
31 <SELECT NAME="svcnum">
32 <OPTION VALUE="">(all)
33 % foreach my $svc_acct (@svc_acct) {
34 <OPTION VALUE="<% $svc_acct->svcnum %>"><% $svc_acct->username %></OPTION>
43 <INPUT TYPE="submit" VALUE="Search">
47 <% include('/elements/footer.html') %>
51 unless $FS::CurrentUser::CurrentUser->access_right('List rating data');
53 my $conf = new FS::Conf;
55 my @pkgparts = $conf->config('support_packages');
60 'table' => 'svc_acct',
61 'addl_from' => ' LEFT JOIN cust_svc USING ( svcnum ) '.
62 ' LEFT JOIN cust_pkg USING ( pkgnum ) ',
63 'extra_sql' => 'WHERE pkgpart IN ('. join(',', @pkgparts). ')',
64 'order_by' => 'ORDER BY username',