8 use C4::Interface::CGI::Output;
13 &Date_Init("DateFormat=non-US"); # set non-USA date, eg:19/08/2005
15 my $csv = Text::CSV_XS->new(
25 my $time=$input->param('time');
31 if ($time eq 'yesterday'){
32 $date=ParseDate('yesterday');
33 $date2=ParseDate('today');
35 if ($time eq 'today'){
36 $date=ParseDate('today');
37 $date2=ParseDate('tomorrow');
39 if ($time eq 'daybefore'){
40 $date=ParseDate('2 days ago');
41 $date2=ParseDate('yesterday');
43 if ($time eq 'month') {
44 $date = ParseDate('1 month ago');
45 $date2 = ParseDate('today');
49 $date=ParseDate($time);
50 $date2=ParseDateDelta('+ 1 day');
51 $date2=DateCalc($date,$date2);
55 $date=ParseDate('today');
56 $date2=ParseDate('tomorrow');
60 my $date=UnixDate($date,'%Y-%m-%d');
61 my $date2=UnixDate($date2,'%Y-%m-%d');
63 #warn "MASON: DATE: $date, $date2";
65 #get a list of every payment
66 my @payments=TotalPaid($date,$date2);
69 # print "MASON: number of payments=$count\n";
77 # lets get a a list of all individual item charges paid for by that payment
83 if ($payments[$i]{'type'} ne 'writeoff'){ # lets ignore writeoff payments!.
84 @charges=getcharges($payments[$i]{'borrowernumber'}, $payments[$i]{'timestamp'}, $payments[$i]{'proccode'});
88 # getting each of the charges and putting them into a array to be printed out
89 #this loops per charge per person
90 for (my $i2=0;$i2<$count;$i2++){
92 my $hour=substr($payments[$i]{'timestamp'},8,2);
93 my $min=substr($payments[$i]{'timestamp'},10,2);
94 my $sec=substr($payments[$i]{'timestamp'},12,2);
95 my $time="$hour:$min:$sec";
96 my $time2="$payments[$i]{'date'}";
97 my $branch=Getpaidbranch($time2,$payments[$i]{'borrowernumber'});
99 my @rows1 = ($branch, # lets build up a row
100 $payments[$i]->{'datetime'},
101 $payments[$i]->{'surname'},
102 $payments[$i]->{'firstname'},
103 $charges[$i2]->{'description'},
104 $charges[$i2]->{'accounttype'},
105 sprintf("%.2f", $charges[$i2]->{'amount'}), # rounding amounts to 2dp
106 $payments[$i]->{'type'},
107 $payments[$i]->{'value'});
109 push (@loop1, \@rows1);
114 $i++; #increment the while loop
115 $totalpaid = $totalpaid + $payments[$i]->{'value'};
118 #get credits and append to the bottom of payments
119 my @credits=getcredits($date,$date2);
126 my @rows2 = ($credits[$i]->{'branchcode'},
127 $credits[$i]->{'date'},
128 $credits[$i]->{'surname'},
129 $credits[$i]->{'firstname'},
130 $credits[$i]->{'description'},
131 $credits[$i]->{'accounttype'},
132 $credits[$i]->{'amount'});
134 push (@loop2, \@rows2);
136 $totalcredits = $totalcredits + $credits[$i]->{'amount'};
139 #takes off first char minus sign "-100.00"
140 $totalcredits = substr($totalcredits, 1);
142 print $input->header(
143 -type => 'application/vnd.ms-excel',
144 -attachment => "moo.csv",
146 print "Branch, Datetime, Surame, Firstnames, Description, Type, Invoice amount, Payment type, Payment Amount\n";
149 for my $row ( @loop1 ) {
151 $csv->combine(@$row);
152 my $string = $csv->string;
158 for my $row ( @loop2 ) {
160 $csv->combine(@$row);
161 my $string = $csv->string;
167 print ",,Total Amount Paid, $totalpaid\n";
168 print ",,Total Number Written, $totalwritten\n";
169 print ",,Total Amount Credits, $totalcredits\n";