X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Freport_rt_transaction.html;h=b8454d96888c028135b81be7b51118a8a83c1008;hb=df1ebf662a9fc3f89503036e0dbf6833c1b95f9e;hp=89629e8434b50533cd6cdae924b106ad75ad247e;hpb=5e05724a635a22776f1b973f5d7e77989da4e048;p=freeside.git
diff --git a/httemplate/search/report_rt_transaction.html b/httemplate/search/report_rt_transaction.html
index 89629e843..b8454d968 100644
--- a/httemplate/search/report_rt_transaction.html
+++ b/httemplate/search/report_rt_transaction.html
@@ -6,17 +6,63 @@
<% include ( '/elements/tr-input-beginning_ending.html' ) %>
+ <& /elements/tr-td-label.html, label => 'Time category:' &>
+
+ <& /elements/select-rt-customfield.html,
+ name => 'cfname',
+ lookuptype => 'RT::Transaction',
+ valuetype => 'TimeValue',
+ empty_label => 'Worked',
+ &>
+ |
+
+
<% 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',
+ });
+}
+
%init>