reports/stats.print.pl

   1 #!/usr/bin/perl
   2
   3 use strict;
   4 use CGI;
   5 use C4::Output;
   6 use HTML::Template;
   7 use C4::Auth;
   8 use C4::Interface::CGI::Output;
   9 use C4::Context;
  10 use Date::Manip;
  11 use C4::Stats;
  12 use Text::CSV_XS;
  13 &Date_Init("DateFormat=non-US"); # set non-USA date, eg:19/08/2005
  14
  15 my $csv = Text::CSV_XS->new(
  16     {
  17         'quote_char'  => '"',
  18         'escape_char' => '"',
  19         'sep_char'    => ',',
  20         'binary'      => 1
  21     }
  22 );
  23
  24 my $input=new CGI;
  25 my $time=$input->param('time');
  26
  27 my @loop1;
  28 my @loop2;
  29 my $date;
  30 my $date2;
  31 if ($time eq 'yesterday'){
  32         $date=ParseDate('yesterday');
  33         $date2=ParseDate('today');
  34 }
  35 if ($time eq 'today'){
  36         $date=ParseDate('today');
  37         $date2=ParseDate('tomorrow');
  38 }
  39 if ($time eq 'daybefore'){
  40         $date=ParseDate('2 days ago');
  41         $date2=ParseDate('yesterday');
  42 }
  43 if ($time eq 'month') {
  44         $date = ParseDate('1 month ago');
  45         $date2 = ParseDate('today');
  46
  47 }
  48 if ($time=~ /\//){
  49         $date=ParseDate($time);
  50         $date2=ParseDateDelta('+ 1 day');
  51         $date2=DateCalc($date,$date2);
  52 }
  53
  54 if ($time eq ''){
  55         $date=ParseDate('today');
  56         $date2=ParseDate('tomorrow');
  57 }
  58
  59
  60 my $date=UnixDate($date,'%Y-%m-%d');
  61 my $date2=UnixDate($date2,'%Y-%m-%d');
  62
  63 #warn "MASON: DATE: $date, $date2";
  64
  65 #get a list of every payment
  66 my @payments=TotalPaid($date,$date2);
  67
  68 my $count=@payments;
  69 # print "MASON: number of payments=$count\n";
  70
  71 my $i=0;
  72 my $totalcharges=0;
  73 my $totalcredits=0;
  74 my $totalpaid=0;
  75 my $totalwritten=0;
  76
  77 # lets get a a list of all individual item charges paid for by that payment
  78 while ($i<$count ){
  79
  80        my $count;
  81        my @charges;
  82
  83        if ($payments[$i]{'type'} ne 'writeoff'){         # lets ignore writeoff payments!.
  84            @charges=getcharges($payments[$i]{'borrowernumber'}, $payments[$i]{'timestamp'}, $payments[$i]{'proccode'});
  85            $totalcharges++;
  86            $count=@charges;
  87
  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++){
  91
  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'});
  98
  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'});
 108
 109                push (@loop1, \@rows1);
 110            }
 111        } else {
 112          ++$totalwritten;
 113        }
 114        $i++; #increment the while loop
 115        $totalpaid = $totalpaid + $payments[$i]->{'value'};
 116 }
 117
 118 #get credits and append to the bottom of payments
 119 my @credits=getcredits($date,$date2);
 120
 121 my $count=@credits;
 122 my $i=0;
 123
 124 while ($i<$count ){
 125
 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'});
 133
 134        push (@loop2, \@rows2);
 135        $i++;
 136        $totalcredits = $totalcredits + $credits[$i]->{'amount'};
 137 }
 138
 139 #takes off first char minus sign "-100.00"
 140 $totalcredits = substr($totalcredits, 1);
 141
 142 print $input->header(
 143     -type       => 'application/vnd.ms-excel',
 144     -attachment => "moo.csv",
 145 );
 146 print "Branch, Datetime, Surame, Firstnames, Description, Type, Invoice amount, Payment type, Payment Amount\n";
 147
 148
 149 for my $row ( @loop1 ) {
 150
 151     $csv->combine(@$row);
 152     my $string = $csv->string;
 153     print $string, "\n";
 154 }
 155
 156 print ",,,,,,,\n";
 157
 158 for my $row ( @loop2 ) {
 159
 160     $csv->combine(@$row);
 161     my $string = $csv->string;
 162     print $string, "\n";
 163 }
 164
 165 print ",,,,,,,\n";
 166 print ",,,,,,,\n";
 167 print ",,Total Amount Paid, $totalpaid\n";
 168 print ",,Total Number Written, $totalwritten\n";
 169 print ",,Total Amount Credits, $totalcredits\n";