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
7 # under the terms of the GNU General Public License as published by
8 # the Free Software Foundation; either version 3 of the License, or
9 # (at your option) any later version.
11 # Koha is distributed in the hope that it will be useful, but
12 # WITHOUT ANY WARRANTY; without even the implied warranty of
13 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 # GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License
17 # along with Koha; if not, see <http://www.gnu.org/licenses>.
21 #use warnings; FIXME - Bug 2505
30 use C4
::Members
::AttributeTypes
;
31 use C4
::Members
::Attributes qw
/GetBorrowerAttributeValue/;
36 use Koha
::Account
::Lines
;
42 use Koha
::Patron
::Attribute
::Types
;
43 use Koha
::Patron
::Messages
;
44 use Koha
::Patron
::Discharge
;
47 use constant ATTRIBUTE_SHOW_BARCODE
=> 'SHOW_BCODE';
49 use Scalar
::Util
qw(looks_like_number);
59 if (C4
::Context
->preference('BakerTaylorEnabled')) {
60 require C4
::External
::BakerTaylor
;
61 import C4
::External
::BakerTaylor
qw(&image_url &link_url);
65 # CAS single logout handling
66 # Will print header and exit
67 C4
::Context
->preference('casAuthentication') and C4
::Auth_with_cas
::logout_if_required
($query);
69 my ( $template, $borrowernumber, $cookie ) = get_template_and_user
(
71 template_name
=> "opac-user.tt",
79 my %renewed = map { $_ => 1 } split( ':', $query->param('renewed') );
82 for ( C4
::Context
->preference("OPACShowHoldQueueDetails") ) {
83 m/priority/ and $show_priority = 1;
86 my $patronupdate = $query->param('patronupdate');
89 $template->param( shibbolethAuthentication
=> C4
::Context
->config('useshibboleth') );
91 if (!$borrowernumber) {
92 $template->param( adminWarning
=> 1 );
95 # get borrower information ....
96 my $patron = Koha
::Patrons
->find( $borrowernumber );
97 my $borr = $patron->unblessed;
99 my ( $today_year, $today_month, $today_day) = Today
();
100 my ($warning_year, $warning_month, $warning_day) = split /-/, $borr->{'dateexpiry'};
102 my $debar = Koha
::Patrons
->find( $borrowernumber )->is_debarred;
107 $template->param( 'userdebarred' => $userdebarred );
108 if ( $debar ne "9999-12-31" ) {
109 $borr->{'userdebarreddate'} = $debar;
111 # FIXME looks like $available is not needed
112 # If a user is discharged they have a validated discharge available
113 my $available = Koha
::Patron
::Discharge
::count
({
114 borrowernumber
=> $borrowernumber,
117 $template->param( 'discharge_available' => $available && Koha
::Patron
::Discharge
::is_discharged
({borrowernumber
=> $borrowernumber}) );
120 if ( $userdebarred || $borr->{'gonenoaddress'} || $borr->{'lost'} ) {
121 $borr->{'flagged'} = 1;
125 my $amountoutstanding = $patron->account->balance;
126 if ( $amountoutstanding > 5 ) {
127 $borr->{'amountoverfive'} = 1;
129 if ( 5 >= $amountoutstanding && $amountoutstanding > 0 ) {
130 $borr->{'amountoverzero'} = 1;
132 my $no_renewal_amt = C4
::Context
->preference( 'OPACFineNoRenewals' );
133 $no_renewal_amt = undef unless looks_like_number
( $no_renewal_amt );
135 if ( C4
::Context
->preference('OpacRenewalAllowed')
136 && defined($no_renewal_amt)
137 && $amountoutstanding > $no_renewal_amt )
139 $borr->{'flagged'} = 1;
142 renewal_blocked_fines
=> $no_renewal_amt,
143 renewal_blocked_fines_amountoutstanding
=> $amountoutstanding,
147 if ( $amountoutstanding < 0 ) {
148 $borr->{'amountlessthanzero'} = 1;
149 $amountoutstanding = -1 * ( $amountoutstanding );
152 # Warningdate is the date that the warning starts appearing
153 if ( $borr->{'dateexpiry'} && C4
::Context
->preference('NotifyBorrowerDeparture') ) {
154 my $days_to_expiry = Date_to_Days
( $warning_year, $warning_month, $warning_day ) - Date_to_Days
( $today_year, $today_month, $today_day );
155 if ( $days_to_expiry < 0 ) {
156 #borrower card has expired, warn the borrower
157 $borr->{'warnexpired'} = $borr->{'dateexpiry'};
158 } elsif ( $days_to_expiry < C4
::Context
->preference('NotifyBorrowerDeparture') ) {
159 # borrower card soon to expire, warn the borrower
160 $borr->{'warndeparture'} = $borr->{dateexpiry
};
161 if (C4
::Context
->preference('ReturnBeforeExpiry')){
162 $borr->{'returnbeforeexpiry'} = 1;
167 # pass on any renew errors to the template for displaying
168 my $renew_error = $query->param('renew_error');
170 $template->param( BORROWER_INFO
=> $borr,
171 amountoutstanding
=> $amountoutstanding,
172 borrowernumber
=> $borrowernumber,
173 patron_flagged
=> $borr->{flagged
},
174 OPACMySummaryHTML
=> (C4
::Context
->preference("OPACMySummaryHTML")) ?
1 : 0,
175 surname
=> $borr->{surname
},
176 RENEW_ERROR
=> $renew_error,
180 #get issued items ....
183 my $overdues_count = 0;
186 my $itemtypes = { map { $_->{itemtype
} => $_ } @
{ Koha
::ItemTypes
->search_with_localization->unblessed } };
187 my $pending_checkouts = $patron->pending_checkouts->search({}, { order_by
=> [ { -desc
=> 'date_due' }, { -asc
=> 'issue_id' } ] });
188 if ( $pending_checkouts->count ) { # Useless test
189 while ( my $c = $pending_checkouts->next ) {
190 my $issue = $c->unblessed_all_relateds;
192 my $restype = GetReserveStatus
( $issue->{'itemnumber'} );
194 $issue->{'reserved'} = 1;
197 # Must be moved in a module if reused
198 my $charges = Koha
::Account
::Lines
->search(
200 borrowernumber
=> $patron->borrowernumber,
201 amountoutstanding
=> { '>' => 0 },
202 accounttype
=> [ 'F', 'FU', 'L' ],
203 itemnumber
=> $issue->{itemnumber
}
205 { select => [ { sum
=> 'amountoutstanding' } ], as
=> ['charges'] }
207 $issue->{charges
} = $charges->count ?
$charges->next->get_column('charges') : 0;
209 my $rental_fines = Koha
::Account
::Lines
->search(
211 borrowernumber
=> $patron->borrowernumber,
212 amountoutstanding
=> { '>' => 0 },
213 accounttype
=> 'Rent',
214 itemnumber
=> $issue->{itemnumber
}
217 select => [ { sum
=> 'amountoutstanding' } ],
218 as
=> ['rental_fines']
221 $issue->{rentalfines
} = $charges->count ?
$charges->next->get_column('rental_fines') : 0;
223 my $marcrecord = GetMarcBiblio
({ biblionumber
=> $issue->{'biblionumber'} });
224 $issue->{'subtitle'} = GetRecordValue
('subtitle', $marcrecord, GetFrameworkCode
($issue->{'biblionumber'}));
225 # check if item is renewable
226 my ($status,$renewerror) = CanBookBeRenewed
( $borrowernumber, $issue->{'itemnumber'} );
227 ($issue->{'renewcount'},$issue->{'renewsallowed'},$issue->{'renewsleft'}) = GetRenewCount
($borrowernumber, $issue->{'itemnumber'});
228 ( $issue->{'renewalfee'}, $issue->{'renewalitemtype'} ) = GetIssuingCharges
( $issue->{'itemnumber'}, $borrowernumber );
229 if($status && C4
::Context
->preference("OpacRenewalAllowed")){
230 $issue->{'status'} = $status;
233 $issue->{'renewed'} = $renewed{ $issue->{'itemnumber'} };
236 $issue->{'too_many'} = 1 if $renewerror eq 'too_many';
237 $issue->{'on_reserve'} = 1 if $renewerror eq 'on_reserve';
238 $issue->{'norenew_overdue'} = 1 if $renewerror eq 'overdue';
239 $issue->{'auto_renew'} = 1 if $renewerror eq 'auto_renew';
240 $issue->{'auto_too_soon'} = 1 if $renewerror eq 'auto_too_soon';
241 $issue->{'auto_too_late'} = 1 if $renewerror eq 'auto_too_late';
242 $issue->{'auto_too_much_oweing'} = 1 if $renewerror eq 'auto_too_much_oweing';
244 if ( $renewerror eq 'too_soon' ) {
245 $issue->{'too_soon'} = 1;
246 $issue->{'soonestrenewdate'} = output_pref
(
247 C4
::Circulation
::GetSoonestRenewDate
(
248 $issue->{borrowernumber
},
255 if ( $c->is_overdue ) {
256 push @overdues, $issue;
258 $issue->{'overdue'} = 1;
261 $issue->{'issued'} = 1;
264 my $itemtype = $issue->{'itemtype'};
266 $issue->{'imageurl'} = getitemtypeimagelocation
( 'opac', $itemtypes->{$itemtype}->{'imageurl'} );
267 $issue->{'description'} = $itemtypes->{$itemtype}->{'description'};
269 push @issuedat, $issue;
272 my $isbn = GetNormalizedISBN
($issue->{'isbn'});
273 $issue->{normalized_isbn
} = $isbn;
274 $issue->{normalized_upc
} = GetNormalizedUPC
( $marcrecord, C4
::Context
->preference('marcflavour') );
277 if (my $my_summary_html = C4
::Context
->preference('OPACMySummaryHTML')){
278 $issue->{author
} ?
$my_summary_html =~ s/{AUTHOR}/$issue->{author}/g : $my_summary_html =~ s/{AUTHOR}//g;
279 $issue->{title
} =~ s/\/+$//; # remove trailing slash
280 $issue->{title
} =~ s/\s+$//; # remove trailing space
281 $issue->{title
} ?
$my_summary_html =~ s/{TITLE}/$issue->{title}/g : $my_summary_html =~ s/{TITLE}//g;
282 $issue->{isbn
} ?
$my_summary_html =~ s/{ISBN}/$isbn/g : $my_summary_html =~ s/{ISBN}//g;
283 $issue->{biblionumber
} ?
$my_summary_html =~ s/{BIBLIONUMBER}/$issue->{biblionumber}/g : $my_summary_html =~ s/{BIBLIONUMBER}//g;
284 $issue->{MySummaryHTML
} = $my_summary_html;
288 my $overduesblockrenewing = C4
::Context
->preference('OverduesBlockRenewing');
289 $canrenew = 0 if ($overduesblockrenewing ne 'allow' and $overdues_count == $count);
291 $template->param( ISSUES
=> \
@issuedat );
292 $template->param( issues_count
=> $count );
293 $template->param( canrenew
=> $canrenew );
294 $template->param( OVERDUES
=> \
@overdues );
295 $template->param( overdues_count
=> $overdues_count );
297 my $show_barcode = Koha
::Patron
::Attribute
::Types
->search(
298 { code
=> ATTRIBUTE_SHOW_BARCODE
} )->count;
300 my $patron_show_barcode = GetBorrowerAttributeValue
($borrowernumber, ATTRIBUTE_SHOW_BARCODE
);
301 undef $show_barcode if defined($patron_show_barcode) && !$patron_show_barcode;
303 $template->param( show_barcode
=> 1 ) if $show_barcode;
305 # now the reserved items....
306 my $reserves = Koha
::Holds
->search( { borrowernumber
=> $borrowernumber } );
309 RESERVES
=> $reserves,
310 showpriority
=> $show_priority,
313 # current alert subscriptions
314 my $alerts = getalert
($borrowernumber);
315 foreach ( @
$alerts ) {
316 $_->{ $_->{type
} } = 1;
317 $_->{relatedto
} = findrelatedto
( $_->{type
}, $_->{externalid
} );
320 if (C4
::Context
->preference('BakerTaylorEnabled')) {
322 BakerTaylorEnabled
=> 1,
323 BakerTaylorImageURL
=> &image_url
(),
324 BakerTaylorLinkURL
=> &link_url
(),
325 BakerTaylorBookstoreURL
=> C4
::Context
->preference('BakerTaylorBookstoreURL'),
329 if (C4
::Context
->preference("OPACAmazonCoverImages") or
330 C4
::Context
->preference("GoogleJackets") or
331 C4
::Context
->preference("BakerTaylorEnabled") or
332 C4
::Context
->preference("SyndeticsCoverImages")) {
333 $template->param(JacketImages
=>1);
337 OverDriveCirculation
=> C4
::Context
->preference('OverDriveCirculation') || 0,
338 overdrive_error
=> scalar $query->param('overdrive_error') || undef,
339 overdrive_tab
=> scalar $query->param('overdrive_tab') || 0,
342 my $patron_messages = Koha
::Patron
::Messages
->search(
344 borrowernumber
=> $borrowernumber,
349 if ( C4
::Context
->preference('AllowPatronToSetCheckoutsVisibilityForGuarantor')
350 || C4
::Context
->preference('AllowStaffToSetCheckoutsVisibilityForGuarantor') )
353 Koha
::Database
->new()->schema()->resultset("Borrower")->search(
355 privacy_guarantor_checkouts
=> 1,
356 'me.guarantorid' => $borrowernumber
358 { prefetch
=> [ { 'issues' => { 'item' => 'biblio' } } ] }
360 $template->param( relatives
=> \
@relatives );
364 borrower
=> scalar Koha
::Patrons
->find($borrowernumber),
365 patron_messages
=> $patron_messages,
366 opacnote
=> $borr->{opacnote
},
367 patronupdate
=> $patronupdate,
368 OpacRenewalAllowed
=> C4
::Context
->preference("OpacRenewalAllowed"),
370 SuspendHoldsOpac
=> C4
::Context
->preference('SuspendHoldsOpac'),
371 AutoResumeSuspendedHolds
=> C4
::Context
->preference('AutoResumeSuspendedHolds'),
372 OpacHoldNotes
=> C4
::Context
->preference('OpacHoldNotes'),
373 failed_holds
=> scalar $query->param('failed_holds'),
376 output_html_with_http_headers
$query, $cookie, $template->output, undef, { force_no_caching
=> 1 };