% include('/elements/header.html', 'Time worked report criteria' ) %>
<% 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>