Bug 5549 : Cannot use CUR_DATE on date_due column
[koha.git] / members / readingrec.pl
blob05ade6ab943fb83369eef84dbfdce214737f3de7
1 #!/usr/bin/perl
3 # written 27/01/2000
4 # script to display borrowers reading record
6 # Copyright 2000-2002 Katipo Communications
8 # This file is part of Koha.
10 # Koha is free software; you can redistribute it and/or modify it under the
11 # terms of the GNU General Public License as published by the Free Software
12 # Foundation; either version 2 of the License, or (at your option) any later
13 # version.
15 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
16 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
17 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
19 # You should have received a copy of the GNU General Public License along
20 # with Koha; if not, write to the Free Software Foundation, Inc.,
21 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
23 use strict;
24 use warnings;
26 use CGI;
28 use C4::Auth;
29 use C4::Output;
30 use C4::Members;
31 use C4::Branch;
32 use List::MoreUtils qw/any uniq/;
33 use Koha::DateUtils;
35 use C4::Dates qw/format_date/;
36 use C4::Members::Attributes qw(GetBorrowerAttributes);
38 my $input = CGI->new;
40 #get borrower details
41 my $data = undef;
42 my $borrowernumber = undef;
43 my $cardnumber = undef;
45 my ($template, $loggedinuser, $cookie)= get_template_and_user({template_name => "members/readingrec.tmpl",
46 query => $input,
47 type => "intranet",
48 authnotrequired => 0,
49 flagsrequired => {borrowers => 1},
50 debug => 1,
51 });
53 if ($input->param('cardnumber')) {
54 $cardnumber = $input->param('cardnumber');
55 $data = GetMember(cardnumber => $cardnumber);
56 $borrowernumber = $data->{'borrowernumber'}; # we must define this as it is used to retrieve other data about the patron
58 if ($input->param('borrowernumber')) {
59 $borrowernumber = $input->param('borrowernumber');
60 $data = GetMember(borrowernumber => $borrowernumber);
63 my $order = 'date_due desc';
64 my $limit = 0;
65 my ( $issues ) = GetAllIssues($borrowernumber,$order,$limit);
67 my @loop_reading;
68 my @barcodes;
69 my $today = C4::Dates->new();
70 $today = $today->output("iso");
72 foreach my $issue (@{$issues}){
73 my %line;
74 $line{issuestimestamp} = format_date($issue->{'issuestimestamp'});
75 $line{biblionumber} = $issue->{'biblionumber'};
76 $line{title} = $issue->{'title'};
77 $line{author} = $issue->{'author'};
78 $line{classification} = $issue->{'classification'} || $issue->{'itemcallnumber'};
79 my $dt = dt_from_string($issue->{date_due}, 'sql');
80 $line{date_due} = output_pref($dt);
81 $line{returndate} = format_date($issue->{'returndate'});
82 $line{issuedate} = format_date($issue->{'issuedate'});
83 $line{issuingbranch} = GetBranchName($issue->{'branchcode'});
84 $line{renewals} = $issue->{'renewals'};
85 $line{barcode} = $issue->{'barcode'};
86 $line{volumeddesc} = $issue->{'volumeddesc'};
87 push(@loop_reading,\%line);
88 if (($input->param('op') eq 'export_barcodes') and ($today eq $issue->{'returndate'})) {
89 push( @barcodes, $issue->{'barcode'} );
93 if ($input->param('op') eq 'export_barcodes') {
94 my $borrowercardnumber = GetMember( borrowernumber => $borrowernumber )->{'cardnumber'} ;
95 my $delimiter = "\n";
96 binmode( STDOUT, ":encoding(UTF-8)");
97 print $input->header(
98 -type => 'application/octet-stream',
99 -charset => 'utf-8',
100 -attachment => "$today-$borrowercardnumber-checkinexport.txt"
102 my $content = join($delimiter, uniq(@barcodes));
103 print $content;
104 exit;
107 if ( $data->{'category_type'} eq 'C') {
108 my ( $catcodes, $labels ) = GetborCatFromCatType( 'A', 'WHERE category_type = ?' );
109 my $cnt = scalar(@$catcodes);
110 $template->param( 'CATCODE_MULTI' => 1) if $cnt > 1;
111 $template->param( 'catcode' => $catcodes->[0]) if $cnt == 1;
114 $template->param( adultborrower => 1 ) if ( $data->{'category_type'} eq 'A' );
115 if (! $limit){
116 $limit = 'full';
119 my ($picture, $dberror) = GetPatronImage($data->{'cardnumber'});
120 $template->param( picture => 1 ) if $picture;
122 if (C4::Context->preference('ExtendedPatronAttributes')) {
123 my $attributes = GetBorrowerAttributes($borrowernumber);
124 $template->param(
125 ExtendedPatronAttributes => 1,
126 extendedattributes => $attributes
130 $template->param(
131 readingrecordview => 1,
132 biblionumber => $data->{'biblionumber'},
133 title => $data->{'title'},
134 initials => $data->{'initials'},
135 surname => $data->{'surname'},
136 othernames => $data->{'othernames'},
137 borrowernumber => $borrowernumber,
138 limit => $limit,
139 firstname => $data->{'firstname'},
140 cardnumber => $data->{'cardnumber'},
141 categorycode => $data->{'categorycode'},
142 category_type => $data->{'category_type'},
143 # category_description => $data->{'description'},
144 categoryname => $data->{'description'},
145 address => $data->{'address'},
146 address2 => $data->{'address2'},
147 city => $data->{'city'},
148 state => $data->{'state'},
149 zipcode => $data->{'zipcode'},
150 country => $data->{'country'},
151 phone => $data->{'phone'},
152 email => $data->{'email'},
153 branchcode => $data->{'branchcode'},
154 is_child => ($data->{'category_type'} eq 'C'),
155 branchname => GetBranchName($data->{'branchcode'}),
156 showfulllink => (scalar @loop_reading > 50),
157 loop_reading => \@loop_reading,
158 activeBorrowerRelationship => (C4::Context->preference('borrowerRelationship') ne ''),
160 output_html_with_http_headers $input, $cookie, $template->output;