members/statistics.pl

   1 #!/usr/bin/perl
   2
   3 # Copyright 2012 BibLibre
   4 # This file is part of Koha.
   5 #
   6 # Koha is free software; you can redistribute it and/or modify it under the
   7 # terms of the GNU General Public License as published by the Free Software
   8 # Foundation; either version 2 of the License, or (at your option) any later
   9 # version.
  10 #
  11 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
  12 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
  13 # A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
  14 #
  15 # You should have received a copy of the GNU General Public License along with
  16 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
  17 # Suite 330, Boston, MA  02111-1307 USA
  18
  19
  20 =head1 members/statistics.pl
  21   Generate statistic issues for a member
  22 =cut
  23
  24 use Modern::Perl;
  25
  26 use CGI;
  27 use C4::Auth;
  28 use C4::Branch;
  29 use C4::Context;
  30 use C4::Members;
  31 use C4::Members::Statistics;
  32 use C4::Members::Attributes qw(GetBorrowerAttributes);
  33 use C4::Output;
  34
  35 my $input = new CGI;
  36
  37 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
  38     {   template_name   => "members/statistics.tmpl",
  39         query           => $input,
  40         type            => "intranet",
  41         authnotrequired => 0,
  42         flagsrequired   => { borrowers => 1 },
  43         debug           => 1,
  44     }
  45 );
  46
  47 my $borrowernumber = $input->param('borrowernumber');
  48
  49 # Set informations for the patron
  50 my $borrower = GetMemberDetails( $borrowernumber, 0 );
  51 if ( not defined $borrower ) {
  52     $template->param (unknowuser => 1);
  53     output_html_with_http_headers $input, $cookie, $template->output;
  54     exit;
  55 }
  56
  57 foreach my $key ( keys %$borrower ) {
  58     $template->param( $key => $borrower->{$key} );
  59 }
  60 $template->param(
  61     categoryname    => $borrower->{'description'},
  62     branchname      => GetBranchName($borrower->{'branchcode'}),
  63 );
  64 # Construct column names
  65 my $fields = C4::Members::Statistics::get_fields();
  66 our @statistic_column_names = split '\|', $fields;
  67 our @value_column_names = ( 'count_precedent_state', 'count_total_issues_today', 'count_total_issues_returned_today' );
  68 our @column_names = ( @statistic_column_names, @value_column_names );
  69
  70 # Get statistics
  71 my $precedent_state = GetPrecedentStateByBorrower( $borrowernumber );
  72 my $total_issues_today = GetTotalIssuesTodayByBorrower( $borrowernumber );
  73 my $total_issues_returned_today = GetTotalIssuesReturnedTodayByBorrower( $borrowernumber );
  74 my $r = merge (
  75     @$precedent_state, @$total_issues_today, @$total_issues_returned_today
  76 );
  77
  78 add_actual_state( $r );
  79 my ( $total, $datas ) = build_array( $r );
  80
  81 # Gettings sums
  82 my $count_total_precedent_state = $total->{count_precedent_state} || 0;
  83 my $count_total_issues = $total->{count_total_issues_today} || 0;
  84 my $count_total_issues_returned = $total->{count_total_issues_returned_today} || 0;
  85 my $count_total_actual_state = ($count_total_precedent_state - $count_total_issues_returned + $count_total_issues);
  86
  87 if (C4::Context->preference('ExtendedPatronAttributes')) {
  88     my $attributes = GetBorrowerAttributes($borrowernumber);
  89     $template->param(
  90         ExtendedPatronAttributes => 1,
  91         extendedattributes => $attributes
  92     );
  93 }
  94
  95 my ($picture, $dberror) = GetPatronImage($borrower->{'cardnumber'});
  96 $template->param( picture => 1 ) if $picture;
  97
  98 $template->param(
  99     statisticsview => 1,
 100     datas          => $datas,
 101     column_names   => \@statistic_column_names,
 102     length_keys    => scalar( @statistic_column_names),
 103     count_total_issues => $count_total_issues,
 104     count_total_issues_returned => $count_total_issues_returned,
 105     count_total_precedent_state => $count_total_precedent_state,
 106     count_total_actual_state => $count_total_actual_state,
 107     RoutingSerials => C4::Context->preference('RoutingSerials'),
 108 );
 109
 110 output_html_with_http_headers $input, $cookie, $template->output;
 111
 112
 113 =head1 FUNCTIONS
 114
 115 =head2 add_actual_state
 116   Add a 'count_actual_state' key in all hashes
 117   count_actual_state = count_precedent_state - count_total_issues_returned_today + count_total_issues_today
 118 =cut
 119 sub add_actual_state {
 120     my ( $array ) = @_;
 121     for my $hash ( @$array ) {
 122         $hash->{count_actual_state} = ( $hash->{count_precedent_state} // 0 ) - ( $hash->{count_total_issues_returned_today} // 0 ) + ( $hash->{count_total_issues_today} // 0 );
 123     }
 124 }
 125
 126 =head2 build_array
 127   Build a new array containing values of hashes.
 128   It used by template whitch display silly values.
 129   ex:
 130     $array = [
 131       {
 132         'count_total_issues_returned_today' => 1,
 133         'ccode' => 'ccode',
 134         'count_actual_state' => 1,
 135         'count_precedent_state' => 1,
 136         'homebranch' => 'homebranch',
 137         'count_total_issues_today' => 1,
 138         'itype' => 'itype'
 139       }
 140     ];
 141   and returns:
 142     [
 143       [
 144         'homebranch',
 145         'itype',
 146         'ccode',
 147         1,
 148         1,
 149         1,
 150         1
 151       ]
 152     ];
 153
 154 =cut
 155 sub build_array {
 156     my ( $array ) = @_;
 157     my ( @r, $total );
 158     for my $hash ( @$array) {
 159         my @line;
 160         for my $cn ( ( @column_names, 'count_actual_state') ) {
 161             if ( grep /$cn/, ( @value_column_names, 'count_actual_state') ) {
 162                 $hash->{$cn} //= 0;
 163                 if ( exists $total->{$cn} ) {
 164                     $total->{$cn} += $hash->{$cn} if $hash->{$cn};
 165                 } else {
 166                     $total->{$cn} = $hash->{$cn};
 167                 }
 168             }
 169             push @line, $hash->{$cn};
 170         }
 171         push @r, \@line;
 172     }
 173     return ( $total, \@r );
 174 }
 175
 176 =head2 merge
 177   Merge hashes with the same statistic column names into one
 178   param: array, a arrayref of arrayrefs
 179   ex:
 180   @array = (
 181      {
 182        'ccode' => 'ccode',
 183        'count_precedent_state' => '1',
 184        'homebranch' => 'homebranch',
 185        'itype' => 'itype'
 186      },
 187      {
 188        'count_total_issues_returned_today' => '1',
 189        'ccode' => 'ccode',
 190        'homebranch' => 'homebranch',
 191        'itype' => 'itype'
 192      }
 193    );
 194    and returns:
 195    [
 196      {
 197        'count_total_issues_returned_today' => '1',
 198        'ccode' => 'ccode',
 199        'count_precedent_state' => '1',
 200        'homebranch' => 'homebranch',
 201        'itype' => 'itype'
 202      }
 203    ];
 204
 205 =cut
 206 sub merge {
 207     my @array = @_;
 208     my @r;
 209     for my $h ( @array ) {
 210         my $exists = 0;
 211         for my $ch ( @r ) {
 212             $exists = 1;
 213             for my $cn ( @statistic_column_names ) {
 214                 if ( $ch->{$cn} and not $ch->{$cn} eq $h->{$cn} ) {
 215                     $exists = 0;
 216                     last;
 217                 }
 218             }
 219             if ($exists){
 220                 for my $cn ( @value_column_names ) {
 221                     next if not exists $h->{$cn};
 222                     $ch->{$cn} = $h->{$cn} ? $h->{$cn} : 0;
 223                 }
 224                 last;
 225             }
 226         }
 227
 228         if ( not $exists ) {push @r, $h;}
 229     }
 230     return \@r;
 231 }