Bug 12728: Add StatisticsFields to sysprefs.sql
[koha.git] / opac / opac-user.pl
blob9f88c1ad39b9d163b435059f3d67aefc8509c5fb
1 #!/usr/bin/perl
3 # This file is part of Koha.
4 # parts copyright 2010 BibLibre
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
16 # with Koha; if not, write to the Free Software Foundation, Inc.,
17 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
20 use strict;
21 #use warnings; FIXME - Bug 2505
23 use CGI;
25 use C4::Auth;
26 use C4::Koha;
27 use C4::Circulation;
28 use C4::Reserves;
29 use C4::Members;
30 use C4::Members::AttributeTypes;
31 use C4::Members::Attributes qw/GetBorrowerAttributeValue/;
32 use C4::Output;
33 use C4::Biblio;
34 use C4::Items;
35 use C4::Letters;
36 use C4::Branch; # GetBranches
37 use Koha::DateUtils;
39 use constant ATTRIBUTE_SHOW_BARCODE => 'SHOW_BCODE';
41 use Date::Calc qw(
42 Today
43 Add_Delta_Days
44 Date_to_Days
47 my $query = new CGI;
49 BEGIN {
50 if (C4::Context->preference('BakerTaylorEnabled')) {
51 require C4::External::BakerTaylor;
52 import C4::External::BakerTaylor qw(&image_url &link_url);
56 my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
58 template_name => "opac-user.tt",
59 query => $query,
60 type => "opac",
61 authnotrequired => 0,
62 flagsrequired => { borrow => 1 },
63 debug => 1,
67 my %renewed = map { $_ => 1 } split( ':', $query->param('renewed') );
69 my $show_priority;
70 for ( C4::Context->preference("OPACShowHoldQueueDetails") ) {
71 m/priority/ and $show_priority = 1;
74 my $patronupdate = $query->param('patronupdate');
75 my $canrenew = 1;
77 # get borrower information ....
78 my ( $borr ) = GetMemberDetails( $borrowernumber );
80 my ( $today_year, $today_month, $today_day) = Today();
81 my ($warning_year, $warning_month, $warning_day) = split /-/, $borr->{'dateexpiry'};
83 $borr->{'ethnicity'} = fixEthnicity( $borr->{'ethnicity'} );
85 my $debar = $borr->{'debarred'};
86 my $userdebarred;
88 if ($debar) {
89 $userdebarred = 1;
90 $template->param( 'userdebarred' => $userdebarred );
91 if ( $debar ne "9999-12-31" ) {
92 $borr->{'userdebarreddate'} = $debar;
96 if ( $userdebarred || $borr->{'gonenoaddress'} || $borr->{'lost'} ) {
97 $borr->{'flagged'} = 1;
98 $canrenew = 0;
101 if ( $borr->{'amountoutstanding'} > 5 ) {
102 $borr->{'amountoverfive'} = 1;
104 if ( 5 >= $borr->{'amountoutstanding'} && $borr->{'amountoutstanding'} > 0 ) {
105 $borr->{'amountoverzero'} = 1;
107 my $no_renewal_amt = C4::Context->preference( 'OPACFineNoRenewals' );
108 $no_renewal_amt ||= 0;
110 if ( C4::Context->preference( 'OpacRenewalAllowed' ) && $borr->{amountoutstanding} > $no_renewal_amt ) {
111 $borr->{'flagged'} = 1;
112 $canrenew = 0;
113 $template->param(
114 renewal_blocked_fines => sprintf( '%.02f', $no_renewal_amt ),
115 renewal_blocked_fines_amountoutstanding => sprintf( '%.02f', $borr->{amountoutstanding} ),
119 if ( $borr->{'amountoutstanding'} < 0 ) {
120 $borr->{'amountlessthanzero'} = 1;
121 $borr->{'amountoutstanding'} = -1 * ( $borr->{'amountoutstanding'} );
124 $borr->{'amountoutstanding'} = sprintf "%.02f", $borr->{'amountoutstanding'};
126 my @bordat;
127 $bordat[0] = $borr;
129 # Warningdate is the date that the warning starts appearing
130 if ( $borr->{'dateexpiry'} && C4::Context->preference('NotifyBorrowerDeparture') ) {
131 my $days_to_expiry = Date_to_Days( $warning_year, $warning_month, $warning_day ) - Date_to_Days( $today_year, $today_month, $today_day );
132 if ( $days_to_expiry < 0 ) {
133 #borrower card has expired, warn the borrower
134 $borr->{'warnexpired'} = $borr->{'dateexpiry'};
135 } elsif ( $days_to_expiry < C4::Context->preference('NotifyBorrowerDeparture') ) {
136 # borrower card soon to expire, warn the borrower
137 $borr->{'warndeparture'} = $borr->{dateexpiry};
138 if (C4::Context->preference('ReturnBeforeExpiry')){
139 $borr->{'returnbeforeexpiry'} = 1;
144 # pass on any renew errors to the template for displaying
145 my $renew_error = $query->param('renew_error');
147 $template->param( BORROWER_INFO => \@bordat,
148 borrowernumber => $borrowernumber,
149 patron_flagged => $borr->{flagged},
150 OPACMySummaryHTML => (C4::Context->preference("OPACMySummaryHTML")) ? 1 : 0,
151 surname => $borr->{surname},
152 showname => $borr->{showname},
153 RENEW_ERROR => $renew_error,
154 borrower => $borr,
157 #get issued items ....
159 my $count = 0;
160 my $overdues_count = 0;
161 my @overdues;
162 my @issuedat;
163 my $itemtypes = GetItemTypes();
164 my $issues = GetPendingIssues($borrowernumber);
165 if ($issues){
166 foreach my $issue ( sort { $b->{date_due}->datetime() cmp $a->{date_due}->datetime() } @{$issues} ) {
167 # check for reserves
168 my $restype = GetReserveStatus( $issue->{'itemnumber'} );
169 if ( $restype ) {
170 $issue->{'reserved'} = 1;
173 my ( $total , $accts, $numaccts) = GetMemberAccountRecords( $borrowernumber );
174 my $charges = 0;
175 foreach my $ac (@$accts) {
176 if ( $ac->{'itemnumber'} == $issue->{'itemnumber'} ) {
177 $charges += $ac->{'amountoutstanding'}
178 if $ac->{'accounttype'} eq 'F';
179 $charges += $ac->{'amountoutstanding'}
180 if $ac->{'accounttype'} eq 'FU';
181 $charges += $ac->{'amountoutstanding'}
182 if $ac->{'accounttype'} eq 'L';
185 $issue->{'charges'} = $charges;
186 $issue->{'subtitle'} = GetRecordValue('subtitle', GetMarcBiblio($issue->{'biblionumber'}), GetFrameworkCode($issue->{'biblionumber'}));
187 # check if item is renewable
188 my ($status,$renewerror) = CanBookBeRenewed( $borrowernumber, $issue->{'itemnumber'} );
189 ($issue->{'renewcount'},$issue->{'renewsallowed'},$issue->{'renewsleft'}) = GetRenewCount($borrowernumber, $issue->{'itemnumber'});
190 if($status && C4::Context->preference("OpacRenewalAllowed")){
191 $issue->{'status'} = $status;
194 $issue->{'renewed'} = $renewed{ $issue->{'itemnumber'} };
196 if ($renewerror) {
197 $issue->{'too_many'} = 1 if $renewerror eq 'too_many';
198 $issue->{'on_reserve'} = 1 if $renewerror eq 'on_reserve';
199 $issue->{'auto_renew'} = 1 if $renewerror eq 'auto_renew';
200 $issue->{'auto_too_soon'} = 1 if $renewerror eq 'auto_too_soon';
202 if ( $renewerror eq 'too_soon' ) {
203 $issue->{'too_soon'} = 1;
204 $issue->{'soonestrenewdate'} = output_pref(
205 C4::Circulation::GetSoonestRenewDate(
206 $issue->{borrowernumber},
207 $issue->{itemnumber}
213 if ( $issue->{'overdue'} ) {
214 push @overdues, $issue;
215 $overdues_count++;
216 $issue->{'overdue'} = 1;
218 else {
219 $issue->{'issued'} = 1;
221 # imageurl:
222 my $itemtype = $issue->{'itemtype'};
223 if ( $itemtype ) {
224 $issue->{'imageurl'} = getitemtypeimagelocation( 'opac', $itemtypes->{$itemtype}->{'imageurl'} );
225 $issue->{'description'} = $itemtypes->{$itemtype}->{'description'};
227 push @issuedat, $issue;
228 $count++;
230 my $isbn = GetNormalizedISBN($issue->{'isbn'});
231 $issue->{normalized_isbn} = $isbn;
233 # My Summary HTML
234 if (my $my_summary_html = C4::Context->preference('OPACMySummaryHTML')){
235 $issue->{author} ? $my_summary_html =~ s/{AUTHOR}/$issue->{author}/g : $my_summary_html =~ s/{AUTHOR}//g;
236 $issue->{title} =~ s/\/+$//; # remove trailing slash
237 $issue->{title} =~ s/\s+$//; # remove trailing space
238 $issue->{title} ? $my_summary_html =~ s/{TITLE}/$issue->{title}/g : $my_summary_html =~ s/{TITLE}//g;
239 $issue->{isbn} ? $my_summary_html =~ s/{ISBN}/$isbn/g : $my_summary_html =~ s/{ISBN}//g;
240 $issue->{biblionumber} ? $my_summary_html =~ s/{BIBLIONUMBER}/$issue->{biblionumber}/g : $my_summary_html =~ s/{BIBLIONUMBER}//g;
241 $issue->{MySummaryHTML} = $my_summary_html;
245 $template->param( ISSUES => \@issuedat );
246 $template->param( issues_count => $count );
247 $template->param( canrenew => $canrenew );
248 $template->param( OVERDUES => \@overdues );
249 $template->param( overdues_count => $overdues_count );
251 my $show_barcode = C4::Members::AttributeTypes::AttributeTypeExists( ATTRIBUTE_SHOW_BARCODE );
252 if ($show_barcode) {
253 my $patron_show_barcode = GetBorrowerAttributeValue($borrowernumber, ATTRIBUTE_SHOW_BARCODE);
254 undef $show_barcode if defined($patron_show_barcode) && !$patron_show_barcode;
256 $template->param( show_barcode => 1 ) if $show_barcode;
258 # load the branches
259 my $branches = GetBranches();
260 my @branch_loop;
261 for my $branch_hash ( sort keys %{$branches} ) {
262 my $selected;
263 if ( C4::Context->preference('SearchMyLibraryFirst') ) {
264 $selected =
265 ( C4::Context->userenv
266 && ( $branch_hash eq C4::Context->userenv->{branch} ) );
268 push @branch_loop,
269 { value => "branch: $branch_hash",
270 branchname => $branches->{$branch_hash}->{'branchname'},
271 selected => $selected,
274 $template->param( branchloop => \@branch_loop );
276 # now the reserved items....
277 my @reserves = GetReservesFromBorrowernumber( $borrowernumber );
278 foreach my $res (@reserves) {
280 if ( $res->{'expirationdate'} eq '0000-00-00' ) {
281 $res->{'expirationdate'} = '';
283 $res->{'subtitle'} = GetRecordValue('subtitle', GetMarcBiblio($res->{'biblionumber'}), GetFrameworkCode($res->{'biblionumber'}));
284 $res->{'waiting'} = 1 if $res->{'found'} eq 'W';
285 $res->{'branch'} = $branches->{ $res->{'branchcode'} }->{'branchname'};
286 my $biblioData = GetBiblioData($res->{'biblionumber'});
287 $res->{'reserves_title'} = $biblioData->{'title'};
288 $res->{'author'} = $biblioData->{'author'};
290 if ($show_priority) {
291 $res->{'priority'} ||= '';
293 $res->{'suspend_until'} = C4::Dates->new( $res->{'suspend_until'}, "iso")->output("syspref") if ( $res->{'suspend_until'} );
296 # use Data::Dumper;
297 # warn Dumper(@reserves);
299 $template->param( RESERVES => \@reserves );
300 $template->param( reserves_count => $#reserves+1 );
301 $template->param( showpriority=>$show_priority );
303 my @waiting;
304 my $wcount = 0;
305 foreach my $res (@reserves) {
306 if ( $res->{'itemnumber'} ) {
307 my $item = GetItem( $res->{'itemnumber'});
308 $res->{'holdingbranch'} =
309 $branches->{ $item->{'holdingbranch'} }->{'branchname'};
310 $res->{'branch'} = $branches->{ $res->{'branchcode'} }->{'branchname'};
311 # get document reserve status
312 my $biblioData = GetBiblioData($res->{'biblionumber'});
313 $res->{'waiting_title'} = $biblioData->{'title'};
314 if ( ( $res->{'found'} eq 'W' ) ) {
315 my $item = $res->{'itemnumber'};
316 $item = GetBiblioFromItemNumber($item,undef);
317 $res->{'wait'}= 1;
318 $res->{'holdingbranch'}=$item->{'holdingbranch'};
319 $res->{'biblionumber'}=$item->{'biblionumber'};
320 $res->{'barcode'} = $item->{'barcode'};
321 $res->{'wbrcode'} = $res->{'branchcode'};
322 $res->{'itemnumber'} = $res->{'itemnumber'};
323 $res->{'wbrname'} = $branches->{$res->{'branchcode'}}->{'branchname'};
324 if($res->{'holdingbranch'} eq $res->{'wbrcode'}){
325 $res->{'atdestination'} = 1;
327 # set found to 1 if reserve is waiting for patron pickup
328 $res->{'found'} = 1 if $res->{'found'} eq 'W';
329 } else {
330 my ($transfertwhen, $transfertfrom, $transfertto) = GetTransfers( $res->{'itemnumber'} );
331 if ($transfertwhen) {
332 $res->{intransit} = 1;
333 $res->{datesent} = $transfertwhen;
334 $res->{frombranch} = GetBranchName($transfertfrom);
337 push @waiting, $res;
338 $wcount++;
340 # can be cancelled
341 #$res->{'cancelable'} = 1 if ($res->{'wait'} && $res->{'atdestination'} && $res->{'found'} ne "1");
342 $res->{'cancelable'} = 1 if ($res->{wait} and not $res->{found}) or (not $res->{wait} and not $res->{intransit});
346 $template->param( WAITING => \@waiting );
348 # current alert subscriptions
349 my $alerts = getalert($borrowernumber);
350 foreach ( @$alerts ) {
351 $_->{ $_->{type} } = 1;
352 $_->{relatedto} = findrelatedto( $_->{type}, $_->{externalid} );
355 if (C4::Context->preference('BakerTaylorEnabled')) {
356 $template->param(
357 BakerTaylorEnabled => 1,
358 BakerTaylorImageURL => &image_url(),
359 BakerTaylorLinkURL => &link_url(),
360 BakerTaylorBookstoreURL => C4::Context->preference('BakerTaylorBookstoreURL'),
364 if (C4::Context->preference("OPACAmazonCoverImages") or
365 C4::Context->preference("GoogleJackets") or
366 C4::Context->preference("BakerTaylorEnabled") or
367 C4::Context->preference("SyndeticsCoverImages")) {
368 $template->param(JacketImages=>1);
371 if ( GetMessagesCount( $borrowernumber, 'B' ) ) {
372 $template->param( bor_messages => 1 );
375 if ( $borr->{'opacnote'} ) {
376 $template->param(
377 bor_messages => 1,
378 opacnote => $borr->{'opacnote'},
382 $template->param(
383 bor_messages_loop => GetMessages( $borrowernumber, 'B', 'NONE' ),
384 waiting_count => $wcount,
385 patronupdate => $patronupdate,
386 OpacRenewalAllowed => C4::Context->preference("OpacRenewalAllowed"),
387 userview => 1,
390 $template->param(
391 SuspendHoldsOpac => C4::Context->preference('SuspendHoldsOpac'),
392 AutoResumeSuspendedHolds => C4::Context->preference('AutoResumeSuspendedHolds'),
393 OpacHoldNotes => C4::Context->preference('OpacHoldNotes'),
396 output_html_with_http_headers $query, $cookie, $template->output;