3 # Copyright 2012 BibLibre
4 # This file is part of Koha.
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
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.
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
20 =head1 members/statistics.pl
21 Generate statistic issues for a member
31 use C4
::Members
::Statistics
;
32 use C4
::Members
::Attributes
qw(GetBorrowerAttributes);
37 my ( $template, $loggedinuser, $cookie ) = get_template_and_user
(
38 { template_name
=> "members/statistics.tmpl",
42 flagsrequired
=> { borrowers
=> 1 },
47 my $borrowernumber = $input->param('borrowernumber');
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;
57 foreach my $key ( keys %$borrower ) {
58 $template->param( $key => $borrower->{$key} );
61 categoryname
=> $borrower->{'description'},
62 branchname
=> GetBranchName
($borrower->{'branchcode'}),
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 );
71 my $precedent_state = GetPrecedentStateByBorrower
( $borrowernumber );
72 my $total_issues_today = GetTotalIssuesTodayByBorrower
( $borrowernumber );
73 my $total_issues_returned_today = GetTotalIssuesReturnedTodayByBorrower
( $borrowernumber );
75 @
$precedent_state, @
$total_issues_today, @
$total_issues_returned_today
78 add_actual_state
( $r );
79 my ( $total, $datas ) = build_array
( $r );
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);
87 if (C4
::Context
->preference('ExtendedPatronAttributes')) {
88 my $attributes = GetBorrowerAttributes
($borrowernumber);
90 ExtendedPatronAttributes
=> 1,
91 extendedattributes
=> $attributes
95 my ($picture, $dberror) = GetPatronImage
($borrower->{'cardnumber'});
96 $template->param( picture
=> 1 ) if $picture;
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'),
110 output_html_with_http_headers
$input, $cookie, $template->output;
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
119 sub add_actual_state
{
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 );
127 Build a new array containing values of hashes.
128 It used by template whitch display silly values.
132 'count_total_issues_returned_today' => 1,
134 'count_actual_state' => 1,
135 'count_precedent_state' => 1,
136 'homebranch' => 'homebranch',
137 'count_total_issues_today' => 1,
158 for my $hash ( @
$array) {
160 for my $cn ( ( @column_names, 'count_actual_state') ) {
161 if ( grep /$cn/, ( @value_column_names, 'count_actual_state') ) {
163 if ( exists $total->{$cn} ) {
164 $total->{$cn} += $hash->{$cn} if $hash->{$cn};
166 $total->{$cn} = $hash->{$cn};
169 push @line, $hash->{$cn};
173 return ( $total, \
@r );
177 Merge hashes with the same statistic column names into one
178 param: array, a arrayref of arrayrefs
183 'count_precedent_state' => '1',
184 'homebranch' => 'homebranch',
188 'count_total_issues_returned_today' => '1',
190 'homebranch' => 'homebranch',
197 'count_total_issues_returned_today' => '1',
199 'count_precedent_state' => '1',
200 'homebranch' => 'homebranch',
209 for my $h ( @array ) {
213 for my $cn ( @statistic_column_names ) {
214 if ( $ch->{$cn} and not $ch->{$cn} eq $h->{$cn} ) {
220 for my $cn ( @value_column_names ) {
221 next if not exists $h->{$cn};
222 $ch->{$cn} = $h->{$cn} ?
$h->{$cn} : 0;
228 if ( not $exists ) {push @r, $h;}