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.,
17 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
19 =head1 members/statistics.pl
21 Generate statistic issues for a member
31 use C4::Members::Statistics;
32 use C4::Members::Attributes qw(GetBorrowerAttributes);
35 use Koha::Patron::Categories;
39 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
40 { template_name => "members/statistics.tt",
44 flagsrequired => { borrowers => 'edit_borrowers' },
49 my $borrowernumber = $input->param('borrowernumber');
51 my $logged_in_user = Koha::Patrons->find( $loggedinuser ) or die "Not logged in";
52 my $patron = Koha::Patrons->find( $borrowernumber );
53 output_and_exit_if_error( $input, $cookie, $template, { module => 'members', logged_in_user => $logged_in_user, current_patron => $patron } );
55 my $category = $patron->category;
57 # Construct column names
58 my $fields = C4::Members::Statistics::get_fields();
59 our @statistic_column_names = split '\|', $fields;
60 our @value_column_names = ( 'count_precedent_state', 'count_total_issues_today', 'count_total_issues_returned_today' );
61 our @column_names = ( @statistic_column_names, @value_column_names );
64 my $precedent_state = GetPrecedentStateByBorrower( $borrowernumber );
65 my $total_issues_today = GetTotalIssuesTodayByBorrower( $borrowernumber );
66 my $total_issues_returned_today = GetTotalIssuesReturnedTodayByBorrower( $borrowernumber );
68 @$precedent_state, @$total_issues_today, @$total_issues_returned_today
71 add_actual_state( $r );
72 my ( $total, $datas ) = build_array( $r );
75 my $count_total_precedent_state = $total->{count_precedent_state} || 0;
76 my $count_total_issues = $total->{count_total_issues_today} || 0;
77 my $count_total_issues_returned = $total->{count_total_issues_returned_today} || 0;
78 my $count_total_actual_state = ($count_total_precedent_state - $count_total_issues_returned + $count_total_issues);
80 if (C4::Context->preference('ExtendedPatronAttributes')) {
81 my $attributes = GetBorrowerAttributes($borrowernumber);
83 ExtendedPatronAttributes => 1,
84 extendedattributes => $attributes
88 if ( $patron->is_child ) {
89 my $patron_categories = Koha::Patron::Categories->search_limited({ category_type => 'A' }, {order_by => ['categorycode']});
90 $template->param( 'CATCODE_MULTI' => 1) if $patron_categories->count > 1;
91 $template->param( 'catcode' => $patron_categories->next->categorycode ) if $patron_categories->count == 1;
98 column_names => \@statistic_column_names,
99 count_total_issues => $count_total_issues,
100 count_total_issues_returned => $count_total_issues_returned,
101 count_total_precedent_state => $count_total_precedent_state,
102 count_total_actual_state => $count_total_actual_state,
105 output_html_with_http_headers $input, $cookie, $template->output;
110 =head2 add_actual_state
112 Add a 'count_actual_state' key in all hashes
113 count_actual_state = count_precedent_state - count_total_issues_returned_today + count_total_issues_today
117 sub add_actual_state {
119 for my $hash ( @$array ) {
120 $hash->{count_actual_state} = ( $hash->{count_precedent_state} // 0 ) - ( $hash->{count_total_issues_returned_today} // 0 ) + ( $hash->{count_total_issues_today} // 0 );
126 Build a new array containing values of hashes.
127 It used by template whitch display silly values.
131 'count_total_issues_returned_today' => 1,
133 'count_actual_state' => 1,
134 'count_precedent_state' => 1,
135 'homebranch' => 'homebranch',
136 '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 );
178 Merge hashes with the same statistic column names into one
179 param: array, a arrayref of arrayrefs
184 'count_precedent_state' => '1',
185 'homebranch' => 'homebranch',
189 'count_total_issues_returned_today' => '1',
191 'homebranch' => 'homebranch',
198 'count_total_issues_returned_today' => '1',
200 'count_precedent_state' => '1',
201 'homebranch' => 'homebranch',
211 for my $h ( @array ) {
215 for my $cn ( @statistic_column_names ) {
216 if ( $ch->{$cn} and not $ch->{$cn} eq $h->{$cn} ) {
222 for my $cn ( @value_column_names ) {
223 next if not exists $h->{$cn};
224 $ch->{$cn} = $h->{$cn} ? $h->{$cn} : 0;
230 if ( not $exists ) {push @r, $h;}