1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
<& /elements/header.html, mt('Credit package source report') &>
<FORM ACTION="cust_credit_source_bill_pkg.html" METHOD="GET">
<!--<INPUT TYPE="hidden" NAME="magic" VALUE="_date">-->
<TABLE BGCOLOR="#cccccc" CELLSPACING=0>
<& /elements/tr-select-user.html,
'label' => emt('Employee: '),
'access_user' => \%access_user,
&>
<& /elements/tr-select-agent.html,
curr_value => scalar( $cgi->param('agentnum') ),
#label => emt('Line items for agent: '),
disable_empty => 0,
&>
<!--
<& /elements/tr-select-cust_main-status.html,
label => emt('Customer status'),
&>
-->
<!-- customer
<& /elements/tr-select-cust_class.html,
'label' => emt('Class'),
'field' => 'cust_classnum',
'multiple' => 1,
'pre_options' => [ '' => emt('(none)') ],
'all_selected' => 1,
&>
-->
<!-- some sort of label saying this is the credit date... -->
<& /elements/tr-input-beginning_ending.html,
'prefix' => 'credit',
&>
<!--
<& /elements/tr-input-lessthan_greaterthan.html,
label => emt('Amount'),
field => 'amount',
&>
-->
<!-- customer payment method in a 4.x world? huh. how's that work?
<& /elements/tr-select-payby.html,
label => emt('Payment method:'),
payby_type => 'cust',
multiple => 1,
all_selected => 1,
&>
-->
</TABLE>
<BR>
<INPUT TYPE="submit" VALUE="<% mt('Get Report') |h %>">
</FORM>
<& /elements/footer.html &>
<%init>
#Financial reports?
die "access denied"
unless $FS::CurrentUser::CurrentUser->access_right('Financial reports');
#false laziness w/report_cust_credit.html
my $sth = dbh->prepare("SELECT DISTINCT usernum FROM cust_credit")
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;
my $conf = new FS::Conf;
</%init>
|