diff options
Diffstat (limited to 'httemplate/search/report_cust_bill_pkg_discount.html')
-rw-r--r-- | httemplate/search/report_cust_bill_pkg_discount.html | 50 |
1 files changed, 0 insertions, 50 deletions
diff --git a/httemplate/search/report_cust_bill_pkg_discount.html b/httemplate/search/report_cust_bill_pkg_discount.html deleted file mode 100644 index f9ab901b5..000000000 --- a/httemplate/search/report_cust_bill_pkg_discount.html +++ /dev/null @@ -1,50 +0,0 @@ -<% include('/elements/header.html', 'Discount report' ) %> - -<FORM ACTION="cust_bill_pkg_discount.html" METHOD="GET"> - - -<TABLE> - - <% include( '/elements/tr-select-user.html', - 'label' => 'Discounts by employee: ', - 'access_user' => \%access_user, - ) - %> - - <% include( '/elements/tr-select-agent.html', - 'curr_value' => scalar( $cgi->param('agentnum') ), - 'label' => 'for agent: ', - 'disable_empty' => 0, - ) - %> - - <% include( '/elements/tr-input-beginning_ending.html' ) %> - - <% include( '/elements/tr-input-lessthan_greaterthan.html', - 'label' => 'Amount', - 'field' => 'amount', - ) - %> - -</TABLE> - -<BR> -<INPUT TYPE="submit" VALUE="Get Report"> - -</FORM> - -<% include('/elements/footer.html') %> -<%init> - -die "access denied" - unless $FS::CurrentUser::CurrentUser->access_right('Financial reports'); - -my $sth = dbh->prepare("SELECT DISTINCT usernum FROM cust_pkg_discount") - or die dbh->errstr; -$sth->execute or die $sth->errstr; -my @usernum = map $_->[0], @{$sth->fetchall_arrayref}; -my %access_user = - map { $_ => qsearchs('access_user',{'usernum'=>$_})->username } - @usernum; - -</%init> |