Bug 19677: Properly escape enumchrom/serialseq data
[koha.git] / members / statistics.pl
blob92fc59c2b37461c1ed801407337b277a5e0d9210
1 #!/usr/bin/perl
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
9 # version.
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
23 =cut
25 use Modern::Perl;
27 use CGI qw ( -utf8 );
28 use C4::Auth;
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 use Koha::Patron::Images;
36 my $input = new CGI;
38 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
39 { template_name => "members/statistics.tt",
40 query => $input,
41 type => "intranet",
42 authnotrequired => 0,
43 flagsrequired => { borrowers => 1 },
44 debug => 1,
48 my $borrowernumber = $input->param('borrowernumber');
50 # Set informations for the patron
51 my $borrower = GetMember( borrowernumber => $borrowernumber );
52 if ( not defined $borrower ) {
53 $template->param (unknowuser => 1);
54 output_html_with_http_headers $input, $cookie, $template->output;
55 exit;
58 foreach my $key ( keys %$borrower ) {
59 $template->param( $key => $borrower->{$key} );
61 $template->param(
62 categoryname => $borrower->{'description'},
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 );
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
78 add_actual_state( $r );
79 my ( $total, $datas ) = build_array( $r );
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);
87 if (C4::Context->preference('ExtendedPatronAttributes')) {
88 my $attributes = GetBorrowerAttributes($borrowernumber);
89 $template->param(
90 ExtendedPatronAttributes => 1,
91 extendedattributes => $attributes
95 my $patron_image = Koha::Patron::Images->find($borrower->{borrowernumber});
96 $template->param( picture => 1 ) if $patron_image;
98 $template->param(%$borrower);
100 $template->param( adultborrower => 1 ) if ( $borrower->{category_type} eq 'A' || $borrower->{category_type} eq 'I' );
102 $template->param(
103 statisticsview => 1,
104 datas => $datas,
105 column_names => \@statistic_column_names,
106 count_total_issues => $count_total_issues,
107 count_total_issues_returned => $count_total_issues_returned,
108 count_total_precedent_state => $count_total_precedent_state,
109 count_total_actual_state => $count_total_actual_state,
112 output_html_with_http_headers $input, $cookie, $template->output;
115 =head1 FUNCTIONS
117 =head2 add_actual_state
119 Add a 'count_actual_state' key in all hashes
120 count_actual_state = count_precedent_state - count_total_issues_returned_today + count_total_issues_today
122 =cut
124 sub add_actual_state {
125 my ( $array ) = @_;
126 for my $hash ( @$array ) {
127 $hash->{count_actual_state} = ( $hash->{count_precedent_state} // 0 ) - ( $hash->{count_total_issues_returned_today} // 0 ) + ( $hash->{count_total_issues_today} // 0 );
131 =head2 build_array
133 Build a new array containing values of hashes.
134 It used by template whitch display silly values.
136 $array = [
138 'count_total_issues_returned_today' => 1,
139 'ccode' => 'ccode',
140 'count_actual_state' => 1,
141 'count_precedent_state' => 1,
142 'homebranch' => 'homebranch',
143 'count_total_issues_today' => 1,
144 'itype' => 'itype'
147 and returns:
150 'homebranch',
151 'itype',
152 'ccode',
160 =cut
162 sub build_array {
163 my ( $array ) = @_;
164 my ( @r, $total );
165 for my $hash ( @$array) {
166 my @line;
167 for my $cn ( ( @column_names, 'count_actual_state') ) {
168 if ( grep /$cn/, ( @value_column_names, 'count_actual_state') ) {
169 $hash->{$cn} //= 0;
170 if ( exists $total->{$cn} ) {
171 $total->{$cn} += $hash->{$cn} if $hash->{$cn};
172 } else {
173 $total->{$cn} = $hash->{$cn};
176 push @line, $hash->{$cn};
178 push @r, \@line;
180 return ( $total, \@r );
183 =head2 merge
185 Merge hashes with the same statistic column names into one
186 param: array, a arrayref of arrayrefs
188 @array = (
190 'ccode' => 'ccode',
191 'count_precedent_state' => '1',
192 'homebranch' => 'homebranch',
193 'itype' => 'itype'
196 'count_total_issues_returned_today' => '1',
197 'ccode' => 'ccode',
198 'homebranch' => 'homebranch',
199 'itype' => 'itype'
202 and returns:
205 'count_total_issues_returned_today' => '1',
206 'ccode' => 'ccode',
207 'count_precedent_state' => '1',
208 'homebranch' => 'homebranch',
209 'itype' => 'itype'
213 =cut
215 sub merge {
216 my @array = @_;
217 my @r;
218 for my $h ( @array ) {
219 my $exists = 0;
220 for my $ch ( @r ) {
221 $exists = 1;
222 for my $cn ( @statistic_column_names ) {
223 if ( $ch->{$cn} and not $ch->{$cn} eq $h->{$cn} ) {
224 $exists = 0;
225 last;
228 if ($exists){
229 for my $cn ( @value_column_names ) {
230 next if not exists $h->{$cn};
231 $ch->{$cn} = $h->{$cn} ? $h->{$cn} : 0;
233 last;
237 if ( not $exists ) {push @r, $h;}
239 return \@r;