<% include('/elements/header.html', 'Time worked report criteria' ) %>
<% include ( '/elements/tr-input-beginning_ending.html' ) %> <& /elements/tr-select.html, label => 'Time category:', field => 'category', options => [ '', 'development', 'support' ], option_labels => { '' => 'all' }, curr_value => 'development', &> <% include ( '/elements/tr-select-otaker.html' ) %> <% include ( '/elements/tr-input-text.html', 'label' => 'Ticket #', 'field' => 'ticketid', ) %>
Account:

<% 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', }); }