summaryrefslogtreecommitdiff
path: root/httemplate/graph/money_time.cgi
blob: e5903168db8d8ccd8820653a5a3de8bc24a34481 (plain)
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
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
<!-- mason kludge -->
<%

#my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(time);
my ($curmon,$curyear) = (localtime(time))[4,5];

#find first month
my $syear = $cgi->param('syear') || 1899+$curyear;
my $smonth = $cgi->param('smonth') || $curmon+1;

#find last month
my $eyear = $cgi->param('eyear') || 1900+$curyear;
my $emonth = $cgi->param('emonth') || $curmon+1;

%>

<HTML>
  <HEAD>
    <TITLE>Sales, Credits and Receipts Summary</TITLE>
  </HEAD>
<BODY BGCOLOR="#e8e8e8">
<IMG SRC="money_time-graph.cgi?<%= $cgi->query_string %>" WIDTH="976" HEIGHT="384">
<BR>

<%= table('e8e8e8') %>
<%

my @items = qw( invoiced netsales credits receipts );
my %label = (
  'invoiced' => 'Gross Sales',
  'netsales' => 'Net Sales',
  'credits'  => 'Credits',
  'receipts' => 'Receipts',
);
my %color = (
  'invoiced' => '9999ff', #light blue
  'netsales' => '0000cc', #blue
  'credits'  => 'cc0000', #red
  'receipts' => '00cc00', #green
);

my $report = new FS::Report::Table::Monthly (
  'items' => \@items,
  'start_month' => $smonth,
  'start_year'  => $syear,
  'end_month'   => $emonth,
  'end_year'    => $eyear,
);
my $data = $report->data;


my @mon = qw(Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec);

%>

<TR><TD></TD>
<% foreach my $column ( @{$data->{label}} ) {
     #$column =~ s/^(\d+)\//$mon[$1-1]<BR>/e;
     $column =~ s/^(\d+)\//$mon[$1-1]<BR>/;
     %>
     <TH><%= $column %></TH>
<% } %>
</TR>

<% foreach my $row (@items) { %>
  <TR><TH><FONT COLOR="#<%= $color{$row} %>"><%= $label{$row} %></FONT></TH>
  <% foreach my $column ( @{$data->{$row}} ) { %>
    <TD ALIGN="right" BGCOLOR="#ffffff">
      <FONT COLOR="#<%= $color{$row} %>">$<%= sprintf("%.2f", $column) %></FONT>
    </TD>
  <% } %>
  </TR>
<% } %>
</TABLE>

<BR>
<FORM METHOD="POST">
<!--
<INPUT TYPE="checkbox" NAME="ar">
  Accounts receivable (invoices - applied credits)<BR>
<INPUT TYPE="checkbox" NAME="charged">
  Just Invoices<BR>
<INPUT TYPE="checkbox" NAME="defer">
  Accounts receivable, with deferred revenue (invoices - applied credits, with charges for annual/semi-annual/quarterly/etc. services deferred over applicable time period) (there has got to be a shorter description for this)<BR>
<INPUT TYPE="checkbox" NAME="cash">
  Cashflow (payments - refunds)<BR>
<BR>
-->
From <SELECT NAME="smonth">
<% foreach my $mon ( 1..12 ) { %>
<OPTION VALUE="<%= $mon %>"<%= $mon == $smonth ? ' SELECTED' : '' %>><%= $mon[$mon-1] %>
<% } %>
</SELECT>
<SELECT NAME="syear">
<% foreach my $y ( 1999 .. 2010 ) { %>
<OPTION VALUE="<%= $y %>"<%= $y == $syear ? ' SELECTED' : '' %>><%= $y %>
<% } %>
</SELECT>
 to <SELECT NAME="emonth">
<% foreach my $mon ( 1..12 ) { %>
<OPTION VALUE="<%= $mon %>"<%= $mon == $emonth ? ' SELECTED' : '' %>><%= $mon[$mon-1] %>
<% } %>
</SELECT>
<SELECT NAME="eyear">
<% foreach my $y ( 1999 .. 2010 ) { %>
<OPTION VALUE="<%= $y %>"<%= $y == $eyear ? ' SELECTED' : '' %>><%= $y %>
<% } %>
</SELECT>

<INPUT TYPE="submit" VALUE="Redisplay">
</FORM>
</BODY>
</HTML>