3 # Copyright 2000-2002 Katipo Communications
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
24 use Digest::MD5 qw(md5_base64);
25 use JSON qw/encode_json/;
31 use C4::Templates; # to get the template
33 use C4::Search::History;
36 use Koha::AuthUtils qw(get_script_name hash_password);
38 use Koha::DateUtils qw(dt_from_string);
39 use Koha::Library::Groups;
42 use Koha::Patron::Consents;
43 use POSIX qw/strftime/;
44 use List::MoreUtils qw/ any /;
45 use Encode qw( encode is_utf8);
46 use C4::Auth_with_shibboleth;
50 use vars qw(@ISA @EXPORT @EXPORT_OK %EXPORT_TAGS $debug $ldap $cas $caslogout);
53 sub psgi_env { any { /^psgi\./ } keys %ENV }
56 if (psgi_env) { die 'psgi:exit' }
60 C4::Context->set_remote_address;
64 @EXPORT = qw(&checkauth &get_template_and_user &haspermission &get_user_subpermissions);
65 @EXPORT_OK = qw(&check_api_auth &get_session &check_cookie_auth &checkpw &checkpw_internal &checkpw_hash
66 &get_all_subpermissions &get_user_subpermissions track_login_daily &in_iprange
68 %EXPORT_TAGS = ( EditPermissions => [qw(get_all_subpermissions get_user_subpermissions)] );
69 $ldap = C4::Context->config('useldapserver') || 0;
70 $cas = C4::Context->preference('casAuthentication');
71 $caslogout = C4::Context->preference('casLogout');
72 require C4::Auth_with_cas; # no import
75 require C4::Auth_with_ldap;
76 import C4::Auth_with_ldap qw(checkpw_ldap);
79 import C4::Auth_with_cas qw(check_api_auth_cas checkpw_cas login_cas logout_cas login_cas_url logout_if_required);
86 C4::Auth - Authenticates Koha users
96 my ($template, $borrowernumber, $cookie)
97 = get_template_and_user(
99 template_name => "opac-main.tt",
102 authnotrequired => 0,
103 flagsrequired => { catalogue => '*', tools => 'import_patrons' },
107 output_html_with_http_headers $query, $cookie, $template->output;
111 The main function of this module is to provide
112 authentification. However the get_template_and_user function has
113 been provided so that a users login information is passed along
114 automatically. This gets loaded into the template.
118 =head2 get_template_and_user
120 my ($template, $borrowernumber, $cookie)
121 = get_template_and_user(
123 template_name => "opac-main.tt",
126 authnotrequired => 0,
127 flagsrequired => { catalogue => '*', tools => 'import_patrons' },
131 This call passes the C<query>, C<flagsrequired> and C<authnotrequired>
132 to C<&checkauth> (in this module) to perform authentification.
133 See C<&checkauth> for an explanation of these parameters.
135 The C<template_name> is then used to find the correct template for
136 the page. The authenticated users details are loaded onto the
137 template in the logged_in_user variable (which is a Koha::Patron object). Also the
138 C<sessionID> is passed to the template. This can be used in templates
139 if cookies are disabled. It needs to be put as and input to every
142 More information on the C<gettemplate> sub can be found in the
147 sub get_template_and_user {
150 my ( $user, $cookie, $sessionID, $flags );
152 # Get shibboleth login attribute
153 my $shib = C4::Context->config('useshibboleth') && shib_ok();
154 my $shib_login = $shib ? get_login_shib() : undef;
156 C4::Context->interface( $in->{type} );
158 $in->{'authnotrequired'} ||= 0;
160 # the following call includes a bad template check; might croak
161 my $template = C4::Templates::gettemplate(
162 $in->{'template_name'},
167 if ( $in->{'template_name'} !~ m/maintenance/ ) {
168 ( $user, $cookie, $sessionID, $flags ) = checkauth(
170 $in->{'authnotrequired'},
171 $in->{'flagsrequired'},
174 $in->{template_name},
178 # If we enforce GDPR and the user did not consent, redirect
179 # Exceptions for consent page itself and SCI/SCO system
180 if( $in->{type} eq 'opac' && $user &&
181 $in->{'template_name'} !~ /^(opac-patron-consent|sc[io]\/)/ &&
182 C4::Context->preference('GDPR_Policy') eq 'Enforced' )
184 my $consent = Koha::Patron::Consents->search({
185 borrowernumber => getborrowernumber($user),
186 type => 'GDPR_PROCESSING',
187 given_on => { '!=', undef },
190 print $in->{query}->redirect(-uri => '/cgi-bin/koha/opac-patron-consent.pl', -cookie => $cookie);
195 if ( $in->{type} eq 'opac' && $user ) {
199 # If the user logged in is the SCO user and they try to go out of the SCO module,
200 # log the user out removing the CGISESSID cookie
201 $in->{template_name} !~ m|sco/| && $in->{template_name} !~ m|errors/errorpage.tt|
202 && C4::Context->preference('AutoSelfCheckID')
203 && $user eq C4::Context->preference('AutoSelfCheckID')
209 # If the user logged in is the SCI user and they try to go out of the SCI module,
210 # kick them out unless it is SCO with a valid permission
211 # or they are a superlibrarian
212 $in->{template_name} !~ m|sci/|
213 && haspermission( $user, { self_check => 'self_checkin_module' } )
215 $in->{template_name} =~ m|sco/| && haspermission(
216 $user, { self_check => 'self_checkout_module' }
219 && $flags && $flags->{superlibrarian} != 1
226 $template = C4::Templates::gettemplate( 'opac-auth.tt', 'opac',
228 $cookie = $in->{query}->cookie(
229 -name => 'CGISESSID',
233 -secure => ( C4::Context->https_enabled() ? 1 : 0 ),
238 script_name => get_script_name(),
241 print $in->{query}->header(
246 'X-Frame-Options' => 'SAMEORIGIN'
257 # It's possible for $user to be the borrowernumber if they don't have a
258 # userid defined (and are logging in through some other method, such
259 # as SSL certs against an email address)
261 $borrowernumber = getborrowernumber($user) if defined($user);
262 if ( !defined($borrowernumber) && defined($user) ) {
263 $patron = Koha::Patrons->find( $user );
265 $borrowernumber = $user;
267 # A bit of a hack, but I don't know there's a nicer way
269 $user = $patron->firstname . ' ' . $patron->surname;
272 $patron = Koha::Patrons->find( $borrowernumber );
273 # FIXME What to do if $patron does not exist?
277 $template->param( loggedinusername => $user ); # OBSOLETE - Do not reuse this in template, use logged_in_user.userid instead
278 $template->param( loggedinusernumber => $borrowernumber ); # FIXME Should be replaced with logged_in_user.borrowernumber
279 $template->param( logged_in_user => $patron );
280 $template->param( sessionID => $sessionID );
282 if ( $in->{'type'} eq 'opac' ) {
283 require Koha::Virtualshelves;
284 my $some_private_shelves = Koha::Virtualshelves->get_some_shelves(
286 borrowernumber => $borrowernumber,
290 my $some_public_shelves = Koha::Virtualshelves->get_some_shelves(
296 some_private_shelves => $some_private_shelves,
297 some_public_shelves => $some_public_shelves,
301 my $all_perms = get_all_subpermissions();
303 my @flagroots = qw(circulate catalogue parameters borrowers permissions reserveforothers borrow
304 editcatalogue updatecharges tools editauthorities serials reports acquisition clubs);
306 # We are going to use the $flags returned by checkauth
307 # to create the template's parameters that will indicate
308 # which menus the user can access.
309 if ( $flags && $flags->{superlibrarian} == 1 ) {
310 $template->param( CAN_user_circulate => 1 );
311 $template->param( CAN_user_catalogue => 1 );
312 $template->param( CAN_user_parameters => 1 );
313 $template->param( CAN_user_borrowers => 1 );
314 $template->param( CAN_user_permissions => 1 );
315 $template->param( CAN_user_reserveforothers => 1 );
316 $template->param( CAN_user_editcatalogue => 1 );
317 $template->param( CAN_user_updatecharges => 1 );
318 $template->param( CAN_user_acquisition => 1 );
319 $template->param( CAN_user_tools => 1 );
320 $template->param( CAN_user_editauthorities => 1 );
321 $template->param( CAN_user_serials => 1 );
322 $template->param( CAN_user_reports => 1 );
323 $template->param( CAN_user_staffaccess => 1 );
324 $template->param( CAN_user_plugins => 1 );
325 $template->param( CAN_user_coursereserves => 1 );
326 $template->param( CAN_user_clubs => 1 );
327 $template->param( CAN_user_ill => 1 );
328 $template->param( CAN_user_stockrotation => 1 );
330 foreach my $module ( keys %$all_perms ) {
331 foreach my $subperm ( keys %{ $all_perms->{$module} } ) {
332 $template->param( "CAN_user_${module}_${subperm}" => 1 );
338 foreach my $module ( keys %$all_perms ) {
339 if ( defined($flags->{$module}) && $flags->{$module} == 1 ) {
340 foreach my $subperm ( keys %{ $all_perms->{$module} } ) {
341 $template->param( "CAN_user_${module}_${subperm}" => 1 );
343 } elsif ( ref( $flags->{$module} ) ) {
344 foreach my $subperm ( keys %{ $flags->{$module} } ) {
345 $template->param( "CAN_user_${module}_${subperm}" => 1 );
352 foreach my $module ( keys %$flags ) {
353 if ( $flags->{$module} == 1 or ref( $flags->{$module} ) ) {
354 $template->param( "CAN_user_$module" => 1 );
359 # Logged-in opac search history
360 # If the requested template is an opac one and opac search history is enabled
361 if ( $in->{type} eq 'opac' && C4::Context->preference('EnableOpacSearchHistory') ) {
362 my $dbh = C4::Context->dbh;
363 my $query = "SELECT COUNT(*) FROM search_history WHERE userid=?";
364 my $sth = $dbh->prepare($query);
365 $sth->execute($borrowernumber);
367 # If at least one search has already been performed
368 if ( $sth->fetchrow_array > 0 ) {
370 # We show the link in opac
371 $template->param( EnableOpacSearchHistory => 1 );
373 if (C4::Context->preference('LoadSearchHistoryToTheFirstLoggedUser'))
375 # And if there are searches performed when the user was not logged in,
376 # we add them to the logged-in search history
377 my @recentSearches = C4::Search::History::get_from_session( { cgi => $in->{'query'} } );
378 if (@recentSearches) {
379 my $dbh = C4::Context->dbh;
381 INSERT INTO search_history(userid, sessionid, query_desc, query_cgi, type, total, time )
382 VALUES (?, ?, ?, ?, ?, ?, ?)
384 my $sth = $dbh->prepare($query);
385 $sth->execute( $borrowernumber,
386 $in->{query}->cookie("CGISESSID"),
389 $_->{type} || 'biblio',
392 ) foreach @recentSearches;
394 # clear out the search history from the session now that
395 # we've saved it to the database
398 C4::Search::History::set_to_session( { cgi => $in->{'query'}, search_history => [] } );
400 } elsif ( $in->{type} eq 'intranet' and C4::Context->preference('EnableSearchHistory') ) {
401 $template->param( EnableSearchHistory => 1 );
404 else { # if this is an anonymous session, setup to display public lists...
406 # If shibboleth is enabled, and we're in an anonymous session, we should allow
407 # the user to attempt login via shibboleth.
409 $template->param( shibbolethAuthentication => $shib,
410 shibbolethLoginUrl => login_shib_url( $in->{'query'} ),
413 # If shibboleth is enabled and we have a shibboleth login attribute,
414 # but we are in an anonymous session, then we clearly have an invalid
415 # shibboleth koha account.
417 $template->param( invalidShibLogin => '1' );
421 $template->param( sessionID => $sessionID );
423 if ( $in->{'type'} eq 'opac' ){
424 require Koha::Virtualshelves;
425 my $some_public_shelves = Koha::Virtualshelves->get_some_shelves(
431 some_public_shelves => $some_public_shelves,
436 # Sysprefs disabled via URL param
437 # Note that value must be defined in order to override via ENV
438 foreach my $syspref (
444 OpacAdditionalStylesheet
446 intranetcolorstylesheet
451 $ENV{"OVERRIDE_SYSPREF_$syspref"} = q{}
452 if $in->{'query'}->param("DISABLE_SYSPREF_$syspref");
455 # Anonymous opac search history
456 # If opac search history is enabled and at least one search has already been performed
457 if ( C4::Context->preference('EnableOpacSearchHistory') ) {
458 my @recentSearches = C4::Search::History::get_from_session( { cgi => $in->{'query'} } );
459 if (@recentSearches) {
460 $template->param( EnableOpacSearchHistory => 1 );
464 if ( C4::Context->preference('dateformat') ) {
465 $template->param( dateformat => C4::Context->preference('dateformat') );
468 $template->param(auth_forwarded_hash => scalar $in->{'query'}->param('auth_forwarded_hash'));
470 # these template parameters are set the same regardless of $in->{'type'}
472 my $minPasswordLength = C4::Context->preference('minPasswordLength');
473 $minPasswordLength = 3 if not $minPasswordLength or $minPasswordLength < 3;
475 "BiblioDefaultView" . C4::Context->preference("BiblioDefaultView") => 1,
476 EnhancedMessagingPreferences => C4::Context->preference('EnhancedMessagingPreferences'),
477 GoogleJackets => C4::Context->preference("GoogleJackets"),
478 OpenLibraryCovers => C4::Context->preference("OpenLibraryCovers"),
479 KohaAdminEmailAddress => "" . C4::Context->preference("KohaAdminEmailAddress"),
480 LoginBranchcode => ( C4::Context->userenv ? C4::Context->userenv->{"branch"} : undef ),
481 LoginFirstname => ( C4::Context->userenv ? C4::Context->userenv->{"firstname"} : "Bel" ),
482 LoginSurname => C4::Context->userenv ? C4::Context->userenv->{"surname"} : "Inconnu",
483 emailaddress => C4::Context->userenv ? C4::Context->userenv->{"emailaddress"} : undef,
484 TagsEnabled => C4::Context->preference("TagsEnabled"),
485 hide_marc => C4::Context->preference("hide_marc"),
486 item_level_itypes => C4::Context->preference('item-level_itypes'),
487 patronimages => C4::Context->preference("patronimages"),
488 singleBranchMode => ( Koha::Libraries->search->count == 1 ),
489 XSLTDetailsDisplay => C4::Context->preference("XSLTDetailsDisplay"),
490 XSLTResultsDisplay => C4::Context->preference("XSLTResultsDisplay"),
491 noItemTypeImages => C4::Context->preference("noItemTypeImages"),
492 marcflavour => C4::Context->preference("marcflavour"),
493 OPACBaseURL => C4::Context->preference('OPACBaseURL'),
494 minPasswordLength => $minPasswordLength,
496 if ( $in->{'type'} eq "intranet" ) {
498 AmazonCoverImages => C4::Context->preference("AmazonCoverImages"),
499 AutoLocation => C4::Context->preference("AutoLocation"),
500 "BiblioDefaultView" . C4::Context->preference("IntranetBiblioDefaultView") => 1,
501 PatronAutoComplete => C4::Context->preference("PatronAutoComplete"),
502 FRBRizeEditions => C4::Context->preference("FRBRizeEditions"),
503 IndependentBranches => C4::Context->preference("IndependentBranches"),
504 IntranetNav => C4::Context->preference("IntranetNav"),
505 IntranetmainUserblock => C4::Context->preference("IntranetmainUserblock"),
506 LibraryName => C4::Context->preference("LibraryName"),
507 LoginBranchname => ( C4::Context->userenv ? C4::Context->userenv->{"branchname"} : undef ),
508 advancedMARCEditor => C4::Context->preference("advancedMARCEditor"),
509 canreservefromotherbranches => C4::Context->preference('canreservefromotherbranches'),
510 intranetcolorstylesheet => C4::Context->preference("intranetcolorstylesheet"),
511 IntranetFavicon => C4::Context->preference("IntranetFavicon"),
512 intranetreadinghistory => C4::Context->preference("intranetreadinghistory"),
513 intranetstylesheet => C4::Context->preference("intranetstylesheet"),
514 IntranetUserCSS => C4::Context->preference("IntranetUserCSS"),
515 IntranetUserJS => C4::Context->preference("IntranetUserJS"),
516 intranetbookbag => C4::Context->preference("intranetbookbag"),
517 suggestion => C4::Context->preference("suggestion"),
518 virtualshelves => C4::Context->preference("virtualshelves"),
519 StaffSerialIssueDisplayCount => C4::Context->preference("StaffSerialIssueDisplayCount"),
520 EasyAnalyticalRecords => C4::Context->preference('EasyAnalyticalRecords'),
521 LocalCoverImages => C4::Context->preference('LocalCoverImages'),
522 OPACLocalCoverImages => C4::Context->preference('OPACLocalCoverImages'),
523 AllowMultipleCovers => C4::Context->preference('AllowMultipleCovers'),
524 EnableBorrowerFiles => C4::Context->preference('EnableBorrowerFiles'),
525 UseKohaPlugins => C4::Context->preference('UseKohaPlugins'),
526 UseCourseReserves => C4::Context->preference("UseCourseReserves"),
527 useDischarge => C4::Context->preference('useDischarge'),
528 pending_checkout_notes => scalar Koha::Checkouts->search({ noteseen => 0 }),
532 warn "template type should be OPAC, here it is=[" . $in->{'type'} . "]" unless ( $in->{'type'} eq 'opac' );
534 #TODO : replace LibraryName syspref with 'system name', and remove this html processing
535 my $LibraryNameTitle = C4::Context->preference("LibraryName");
536 $LibraryNameTitle =~ s/<(?:\/?)(?:br|p)\s*(?:\/?)>/ /sgi;
537 $LibraryNameTitle =~ s/<(?:[^<>'"]|'(?:[^']*)'|"(?:[^"]*)")*>//sg;
539 # clean up the busc param in the session
540 # if the page is not opac-detail and not the "add to list" page
541 # and not the "edit comments" page
542 if ( C4::Context->preference("OpacBrowseResults")
543 && $in->{'template_name'} =~ /opac-(.+)\.(?:tt|tmpl)$/ ) {
545 unless ( $pagename =~ /^(?:MARC|ISBD)?detail$/
546 or $pagename =~ /^addbybiblionumber$/
547 or $pagename =~ /^review$/ ) {
548 my $sessionSearch = get_session( $sessionID || $in->{'query'}->cookie("CGISESSID") );
549 $sessionSearch->clear( ["busc"] ) if ( $sessionSearch->param("busc") );
553 # variables passed from CGI: opac_css_override and opac_search_limits.
554 my $opac_search_limit = $ENV{'OPAC_SEARCH_LIMIT'};
555 my $opac_limit_override = $ENV{'OPAC_LIMIT_OVERRIDE'};
558 ( $opac_limit_override && $opac_search_limit && $opac_search_limit =~ /branch:([\w-]+)/ ) ||
559 ( $in->{'query'}->param('limit') && $in->{'query'}->param('limit') =~ /branch:([\w-]+)/ ) ||
560 ( $in->{'query'}->param('multibranchlimit') && $in->{'query'}->param('multibranchlimit') =~ /multibranchlimit-(\w+)/ )
562 $opac_name = $1; # opac_search_limit is a branch, so we use it.
563 } elsif ( $in->{'query'}->param('multibranchlimit') ) {
564 $opac_name = $in->{'query'}->param('multibranchlimit');
565 } elsif ( C4::Context->preference("SearchMyLibraryFirst") && C4::Context->userenv && C4::Context->userenv->{'branch'} ) {
566 $opac_name = C4::Context->userenv->{'branch'};
569 my @search_groups = Koha::Library::Groups->get_search_groups({ interface => 'opac' });
571 AnonSuggestions => "" . C4::Context->preference("AnonSuggestions"),
572 LibrarySearchGroups => \@search_groups,
573 opac_name => $opac_name,
574 LibraryName => "" . C4::Context->preference("LibraryName"),
575 LibraryNameTitle => "" . $LibraryNameTitle,
576 LoginBranchname => C4::Context->userenv ? C4::Context->userenv->{"branchname"} : "",
577 OPACAmazonCoverImages => C4::Context->preference("OPACAmazonCoverImages"),
578 OPACFRBRizeEditions => C4::Context->preference("OPACFRBRizeEditions"),
579 OpacHighlightedWords => C4::Context->preference("OpacHighlightedWords"),
580 OPACShelfBrowser => "" . C4::Context->preference("OPACShelfBrowser"),
581 OPACURLOpenInNewWindow => "" . C4::Context->preference("OPACURLOpenInNewWindow"),
582 OPACUserCSS => "" . C4::Context->preference("OPACUserCSS"),
583 OpacAuthorities => C4::Context->preference("OpacAuthorities"),
584 opac_css_override => $ENV{'OPAC_CSS_OVERRIDE'},
585 opac_search_limit => $opac_search_limit,
586 opac_limit_override => $opac_limit_override,
587 OpacBrowser => C4::Context->preference("OpacBrowser"),
588 OpacCloud => C4::Context->preference("OpacCloud"),
589 OpacKohaUrl => C4::Context->preference("OpacKohaUrl"),
590 OpacMainUserBlock => "" . C4::Context->preference("OpacMainUserBlock"),
591 OpacNav => "" . C4::Context->preference("OpacNav"),
592 OpacNavBottom => "" . C4::Context->preference("OpacNavBottom"),
593 OpacPasswordChange => C4::Context->preference("OpacPasswordChange"),
594 OPACPatronDetails => C4::Context->preference("OPACPatronDetails"),
595 OPACPrivacy => C4::Context->preference("OPACPrivacy"),
596 OPACFinesTab => C4::Context->preference("OPACFinesTab"),
597 OpacTopissue => C4::Context->preference("OpacTopissue"),
598 RequestOnOpac => C4::Context->preference("RequestOnOpac"),
599 'Version' => C4::Context->preference('Version'),
600 hidelostitems => C4::Context->preference("hidelostitems"),
601 mylibraryfirst => ( C4::Context->preference("SearchMyLibraryFirst") && C4::Context->userenv ) ? C4::Context->userenv->{'branch'} : '',
602 opacbookbag => "" . C4::Context->preference("opacbookbag"),
603 opaccredits => "" . C4::Context->preference("opaccredits"),
604 OpacFavicon => C4::Context->preference("OpacFavicon"),
605 opacheader => "" . C4::Context->preference("opacheader"),
606 opaclanguagesdisplay => "" . C4::Context->preference("opaclanguagesdisplay"),
607 opacreadinghistory => C4::Context->preference("opacreadinghistory"),
608 OPACUserJS => C4::Context->preference("OPACUserJS"),
609 opacuserlogin => "" . C4::Context->preference("opacuserlogin"),
610 OpenLibrarySearch => C4::Context->preference("OpenLibrarySearch"),
611 ShowReviewer => C4::Context->preference("ShowReviewer"),
612 ShowReviewerPhoto => C4::Context->preference("ShowReviewerPhoto"),
613 suggestion => "" . C4::Context->preference("suggestion"),
614 virtualshelves => "" . C4::Context->preference("virtualshelves"),
615 OPACSerialIssueDisplayCount => C4::Context->preference("OPACSerialIssueDisplayCount"),
616 OPACXSLTDetailsDisplay => C4::Context->preference("OPACXSLTDetailsDisplay"),
617 OPACXSLTResultsDisplay => C4::Context->preference("OPACXSLTResultsDisplay"),
618 SyndeticsClientCode => C4::Context->preference("SyndeticsClientCode"),
619 SyndeticsEnabled => C4::Context->preference("SyndeticsEnabled"),
620 SyndeticsCoverImages => C4::Context->preference("SyndeticsCoverImages"),
621 SyndeticsTOC => C4::Context->preference("SyndeticsTOC"),
622 SyndeticsSummary => C4::Context->preference("SyndeticsSummary"),
623 SyndeticsEditions => C4::Context->preference("SyndeticsEditions"),
624 SyndeticsExcerpt => C4::Context->preference("SyndeticsExcerpt"),
625 SyndeticsReviews => C4::Context->preference("SyndeticsReviews"),
626 SyndeticsAuthorNotes => C4::Context->preference("SyndeticsAuthorNotes"),
627 SyndeticsAwards => C4::Context->preference("SyndeticsAwards"),
628 SyndeticsSeries => C4::Context->preference("SyndeticsSeries"),
629 SyndeticsCoverImageSize => C4::Context->preference("SyndeticsCoverImageSize"),
630 OPACLocalCoverImages => C4::Context->preference("OPACLocalCoverImages"),
631 PatronSelfRegistration => C4::Context->preference("PatronSelfRegistration"),
632 PatronSelfRegistrationDefaultCategory => C4::Context->preference("PatronSelfRegistrationDefaultCategory"),
633 useDischarge => C4::Context->preference('useDischarge'),
636 $template->param( OpacPublic => '1' ) if ( $user || C4::Context->preference("OpacPublic") );
639 # Check if we were asked using parameters to force a specific language
640 if ( defined $in->{'query'}->param('language') ) {
642 # Extract the language, let C4::Languages::getlanguage choose
644 my $language = C4::Languages::getlanguage( $in->{'query'} );
645 my $languagecookie = C4::Templates::getlanguagecookie( $in->{'query'}, $language );
646 if ( ref $cookie eq 'ARRAY' ) {
647 push @{$cookie}, $languagecookie;
649 $cookie = [ $cookie, $languagecookie ];
653 return ( $template, $borrowernumber, $cookie, $flags );
658 ($userid, $cookie, $sessionID) = &checkauth($query, $noauth, $flagsrequired, $type);
660 Verifies that the user is authorized to run this script. If
661 the user is authorized, a (userid, cookie, session-id, flags)
662 quadruple is returned. If the user is not authorized but does
663 not have the required privilege (see $flagsrequired below), it
664 displays an error page and exits. Otherwise, it displays the
665 login page and exits.
667 Note that C<&checkauth> will return if and only if the user
668 is authorized, so it should be called early on, before any
669 unfinished operations (e.g., if you've opened a file, then
670 C<&checkauth> won't close it for you).
672 C<$query> is the CGI object for the script calling C<&checkauth>.
674 The C<$noauth> argument is optional. If it is set, then no
675 authorization is required for the script.
677 C<&checkauth> fetches user and session information from C<$query> and
678 ensures that the user is authorized to run scripts that require
681 The C<$flagsrequired> argument specifies the required privileges
682 the user must have if the username and password are correct.
683 It should be specified as a reference-to-hash; keys in the hash
684 should be the "flags" for the user, as specified in the Members
685 intranet module. Any key specified must correspond to a "flag"
686 in the userflags table. E.g., { circulate => 1 } would specify
687 that the user must have the "circulate" privilege in order to
688 proceed. To make sure that access control is correct, the
689 C<$flagsrequired> parameter must be specified correctly.
691 Koha also has a concept of sub-permissions, also known as
692 granular permissions. This makes the value of each key
693 in the C<flagsrequired> hash take on an additional
698 The user must have access to all subfunctions of the module
699 specified by the hash key.
703 The user must have access to at least one subfunction of the module
704 specified by the hash key.
706 specific permission, e.g., 'export_catalog'
708 The user must have access to the specific subfunction list, which
709 must correspond to a row in the permissions table.
711 The C<$type> argument specifies whether the template should be
712 retrieved from the opac or intranet directory tree. "opac" is
713 assumed if it is not specified; however, if C<$type> is specified,
714 "intranet" is assumed if it is not "opac".
716 If C<$query> does not have a valid session ID associated with it
717 (i.e., the user has not logged in) or if the session has expired,
718 C<&checkauth> presents the user with a login page (from the point of
719 view of the original script, C<&checkauth> does not return). Once the
720 user has authenticated, C<&checkauth> restarts the original script
721 (this time, C<&checkauth> returns).
723 The login page is provided using a HTML::Template, which is set in the
724 systempreferences table or at the top of this file. The variable C<$type>
725 selects which template to use, either the opac or the intranet
726 authentification template.
728 C<&checkauth> returns a user ID, a cookie, and a session ID. The
729 cookie should be sent back to the browser; it verifies that the user
739 # If version syspref is unavailable, it means Koha is being installed,
740 # and so we must redirect to OPAC maintenance page or to the WebInstaller
741 # also, if OpacMaintenance is ON, OPAC should redirect to maintenance
742 if ( C4::Context->preference('OpacMaintenance') && $type eq 'opac' ) {
743 warn "OPAC Install required, redirecting to maintenance";
744 print $query->redirect("/cgi-bin/koha/maintenance.pl");
747 unless ( $version = C4::Context->preference('Version') ) { # assignment, not comparison
748 if ( $type ne 'opac' ) {
749 warn "Install required, redirecting to Installer";
750 print $query->redirect("/cgi-bin/koha/installer/install.pl");
752 warn "OPAC Install required, redirecting to maintenance";
753 print $query->redirect("/cgi-bin/koha/maintenance.pl");
758 # check that database and koha version are the same
759 # there is no DB version, it's a fresh install,
760 # go to web installer
761 # there is a DB version, compare it to the code version
762 my $kohaversion = Koha::version();
764 # remove the 3 last . to have a Perl number
765 $kohaversion =~ s/(.*\..*)\.(.*)\.(.*)/$1$2$3/;
766 $debug and print STDERR "kohaversion : $kohaversion\n";
767 if ( $version < $kohaversion ) {
768 my $warning = "Database update needed, redirecting to %s. Database is $version and Koha is $kohaversion";
769 if ( $type ne 'opac' ) {
770 warn sprintf( $warning, 'Installer' );
771 print $query->redirect("/cgi-bin/koha/installer/install.pl?step=1&op=updatestructure");
773 warn sprintf( "OPAC: " . $warning, 'maintenance' );
774 print $query->redirect("/cgi-bin/koha/maintenance.pl");
782 open my $fh, '>>', "/tmp/sessionlog" or warn "ERROR: Cannot append to /tmp/sessionlog";
783 printf $fh join( "\n", @_ );
787 sub _timeout_syspref {
788 my $default_timeout = 600;
789 my $timeout = C4::Context->preference('timeout') || $default_timeout;
791 # value in days, convert in seconds
792 if ( $timeout =~ /^(\d+)[dD]$/ ) {
793 $timeout = $1 * 86400;
795 # value in hours, convert in seconds
796 elsif ( $timeout =~ /^(\d+)[hH]$/ ) {
797 $timeout = $1 * 3600;
799 elsif ( $timeout !~ m/^\d+$/ ) {
800 warn "The value of the system preference 'timeout' is not correct, defaulting to $default_timeout";
801 $timeout = $default_timeout;
809 $debug and warn "Checking Auth";
811 # Get shibboleth login attribute
812 my $shib = C4::Context->config('useshibboleth') && shib_ok();
813 my $shib_login = $shib ? get_login_shib() : undef;
815 # $authnotrequired will be set for scripts which will run without authentication
816 my $authnotrequired = shift;
817 my $flagsrequired = shift;
819 my $emailaddress = shift;
820 my $template_name = shift;
821 $type = 'opac' unless $type;
823 unless ( C4::Context->preference("OpacPublic") ) {
824 my @allowed_scripts_for_private_opac = qw(
826 opac-registration-email-sent.tt
827 opac-registration-confirmation.tt
828 opac-memberentry-update-submitted.tt
829 opac-password-recovery.tt
831 $authnotrequired = 0 unless grep { $_ eq $template_name }
832 @allowed_scripts_for_private_opac;
835 my $dbh = C4::Context->dbh;
836 my $timeout = _timeout_syspref();
838 _version_check( $type, $query );
843 my ( $userid, $cookie, $sessionID, $flags );
844 my $logout = $query->param('logout.x');
846 my $anon_search_history;
848 # This parameter is the name of the CAS server we want to authenticate against,
849 # when using authentication against multiple CAS servers, as configured in Auth_cas_servers.yaml
850 my $casparam = $query->param('cas');
851 my $q_userid = $query->param('userid') // '';
855 # Basic authentication is incompatible with the use of Shibboleth,
856 # as Shibboleth may return REMOTE_USER as a Shibboleth attribute,
857 # and it may not be the attribute we want to use to match the koha login.
859 # Also, do not consider an empty REMOTE_USER.
861 # Finally, after those tests, we can assume (although if it would be better with
862 # a syspref) that if we get a REMOTE_USER, that's from basic authentication,
863 # and we can affect it to $userid.
864 if ( !$shib and defined( $ENV{'REMOTE_USER'} ) and $ENV{'REMOTE_USER'} ne '' and $userid = $ENV{'REMOTE_USER'} ) {
866 # Using Basic Authentication, no cookies required
867 $cookie = $query->cookie(
868 -name => 'CGISESSID',
872 -secure => ( C4::Context->https_enabled() ? 1 : 0 ),
876 elsif ( $emailaddress) {
877 # the Google OpenID Connect passes an email address
879 elsif ( $sessionID = $query->cookie("CGISESSID") )
880 { # assignment, not comparison
881 $session = get_session($sessionID);
882 C4::Context->_new_userenv($sessionID);
883 my ( $ip, $lasttime, $sessiontype );
886 $s_userid = $session->param('id') // '';
887 C4::Context->set_userenv(
888 $session->param('number'), $s_userid,
889 $session->param('cardnumber'), $session->param('firstname'),
890 $session->param('surname'), $session->param('branch'),
891 $session->param('branchname'), $session->param('flags'),
892 $session->param('emailaddress'), $session->param('branchprinter'),
893 $session->param('shibboleth')
895 C4::Context::set_shelves_userenv( 'bar', $session->param('barshelves') );
896 C4::Context::set_shelves_userenv( 'pub', $session->param('pubshelves') );
897 C4::Context::set_shelves_userenv( 'tot', $session->param('totshelves') );
898 $debug and printf STDERR "AUTH_SESSION: (%s)\t%s %s - %s\n", map { $session->param($_) } qw(cardnumber firstname surname branch);
899 $ip = $session->param('ip');
900 $lasttime = $session->param('lasttime');
902 $sessiontype = $session->param('sessiontype') || '';
904 if ( ( $query->param('koha_login_context') && ( $q_userid ne $s_userid ) )
905 || ( $cas && $query->param('ticket') && !C4::Context->userenv->{'id'} )
906 || ( $shib && $shib_login && !$logout && !C4::Context->userenv->{'id'} )
909 #if a user enters an id ne to the id in the current session, we need to log them in...
910 #first we need to clear the anonymous session...
911 $debug and warn "query id = $q_userid but session id = $s_userid";
912 $anon_search_history = $session->param('search_history');
915 C4::Context->_unset_userenv($sessionID);
921 # voluntary logout the user
922 # check wether the user was using their shibboleth session or a local one
923 my $shibSuccess = C4::Context->userenv->{'shibboleth'};
926 C4::Context->_unset_userenv($sessionID);
928 #_session_log(sprintf "%20s from %16s logged out at %30s (manually).\n", $userid,$ip,(strftime "%c",localtime));
932 if ($cas and $caslogout) {
933 logout_cas($query, $type);
936 # If we are in a shibboleth session (shibboleth is enabled, a shibboleth match attribute is set and matches koha matchpoint)
937 if ( $shib and $shib_login and $shibSuccess) {
941 elsif ( !$lasttime || ( $lasttime < time() - $timeout ) ) {
944 $info{'timed_out'} = 1;
949 C4::Context->_unset_userenv($sessionID);
951 #_session_log(sprintf "%20s from %16s logged out at %30s (inactivity).\n", $userid,$ip,(strftime "%c",localtime));
955 elsif ( C4::Context->preference('SessionRestrictionByIP') && $ip ne $ENV{'REMOTE_ADDR'} ) {
957 # Different ip than originally logged in from
958 $info{'oldip'} = $ip;
959 $info{'newip'} = $ENV{'REMOTE_ADDR'};
960 $info{'different_ip'} = 1;
963 C4::Context->_unset_userenv($sessionID);
965 #_session_log(sprintf "%20s from %16s logged out at %30s (ip changed to %16s).\n", $userid,$ip,(strftime "%c",localtime), $info{'newip'});
970 $cookie = $query->cookie(
971 -name => 'CGISESSID',
972 -value => $session->id,
974 -secure => ( C4::Context->https_enabled() ? 1 : 0 ),
976 $session->param( 'lasttime', time() );
977 unless ( $sessiontype && $sessiontype eq 'anon' ) { #if this is an anonymous session, we want to update the session, but not behave as if they are logged in...
978 $flags = haspermission( $userid, $flagsrequired );
982 $info{'nopermission'} = 1;
987 unless ( $userid || $sessionID ) {
988 #we initiate a session prior to checking for a username to allow for anonymous sessions...
989 my $session = get_session("") or die "Auth ERROR: Cannot get_session()";
991 # Save anonymous search history in new session so it can be retrieved
992 # by get_template_and_user to store it in user's search history after
993 # a successful login.
994 if ($anon_search_history) {
995 $session->param( 'search_history', $anon_search_history );
998 $sessionID = $session->id;
999 C4::Context->_new_userenv($sessionID);
1000 $cookie = $query->cookie(
1001 -name => 'CGISESSID',
1002 -value => $session->id,
1004 -secure => ( C4::Context->https_enabled() ? 1 : 0 ),
1006 my $pki_field = C4::Context->preference('AllowPKIAuth');
1007 if ( !defined($pki_field) ) {
1008 print STDERR "ERROR: Missing system preference AllowPKIAuth.\n";
1009 $pki_field = 'None';
1011 if ( ( $cas && $query->param('ticket') )
1013 || ( $shib && $shib_login )
1014 || $pki_field ne 'None'
1017 my $password = $query->param('password');
1018 my $shibSuccess = 0;
1019 my ( $return, $cardnumber );
1021 # If shib is enabled and we have a shib login, does the login match a valid koha user
1022 if ( $shib && $shib_login ) {
1025 # Do not pass password here, else shib will not be checked in checkpw.
1026 ( $return, $cardnumber, $retuserid ) = checkpw( $dbh, $q_userid, undef, $query );
1027 $userid = $retuserid;
1028 $shibSuccess = $return;
1029 $info{'invalidShibLogin'} = 1 unless ($return);
1032 # If shib login and match were successful, skip further login methods
1033 unless ($shibSuccess) {
1034 if ( $cas && $query->param('ticket') ) {
1036 ( $return, $cardnumber, $retuserid, $cas_ticket ) =
1037 checkpw( $dbh, $userid, $password, $query, $type );
1038 $userid = $retuserid;
1039 $info{'invalidCasLogin'} = 1 unless ($return);
1042 elsif ( $emailaddress ) {
1043 my $value = $emailaddress;
1045 # If we're looking up the email, there's a chance that the person
1046 # doesn't have a userid. So if there is none, we pass along the
1047 # borrower number, and the bits of code that need to know the user
1048 # ID will have to be smart enough to handle that.
1049 my $patrons = Koha::Patrons->search({ email => $value });
1050 if ($patrons->count) {
1052 # First the userid, then the borrowernum
1053 my $patron = $patrons->next;
1054 $value = $patron->userid || $patron->borrowernumber;
1058 $return = $value ? 1 : 0;
1063 ( $pki_field eq 'Common Name' && $ENV{'SSL_CLIENT_S_DN_CN'} )
1064 || ( $pki_field eq 'emailAddress'
1065 && $ENV{'SSL_CLIENT_S_DN_Email'} )
1069 if ( $pki_field eq 'Common Name' ) {
1070 $value = $ENV{'SSL_CLIENT_S_DN_CN'};
1072 elsif ( $pki_field eq 'emailAddress' ) {
1073 $value = $ENV{'SSL_CLIENT_S_DN_Email'};
1075 # If we're looking up the email, there's a chance that the person
1076 # doesn't have a userid. So if there is none, we pass along the
1077 # borrower number, and the bits of code that need to know the user
1078 # ID will have to be smart enough to handle that.
1079 my $patrons = Koha::Patrons->search({ email => $value });
1080 if ($patrons->count) {
1082 # First the userid, then the borrowernum
1083 my $patron = $patrons->next;
1084 $value = $patron->userid || $patron->borrowernumber;
1090 $return = $value ? 1 : 0;
1096 ( $return, $cardnumber, $retuserid, $cas_ticket ) =
1097 checkpw( $dbh, $q_userid, $password, $query, $type );
1098 $userid = $retuserid if ($retuserid);
1099 $info{'invalid_username_or_password'} = 1 unless ($return);
1103 # $return: 1 = valid user
1106 #_session_log(sprintf "%20s from %16s logged in at %30s.\n", $userid,$ENV{'REMOTE_ADDR'},(strftime '%c', localtime));
1107 if ( $flags = haspermission( $userid, $flagsrequired ) ) {
1111 $info{'nopermission'} = 1;
1112 C4::Context->_unset_userenv($sessionID);
1114 my ( $borrowernumber, $firstname, $surname, $userflags,
1115 $branchcode, $branchname, $branchprinter, $emailaddress );
1117 if ( $return == 1 ) {
1119 SELECT borrowernumber, firstname, surname, flags, borrowers.branchcode,
1120 branches.branchname as branchname,
1121 branches.branchprinter as branchprinter,
1124 LEFT JOIN branches on borrowers.branchcode=branches.branchcode
1126 my $sth = $dbh->prepare("$select where userid=?");
1127 $sth->execute($userid);
1128 unless ( $sth->rows ) {
1129 $debug and print STDERR "AUTH_1: no rows for userid='$userid'\n";
1130 $sth = $dbh->prepare("$select where cardnumber=?");
1131 $sth->execute($cardnumber);
1133 unless ( $sth->rows ) {
1134 $debug and print STDERR "AUTH_2a: no rows for cardnumber='$cardnumber'\n";
1135 $sth->execute($userid);
1136 unless ( $sth->rows ) {
1137 $debug and print STDERR "AUTH_2b: no rows for userid='$userid' AS cardnumber\n";
1142 ( $borrowernumber, $firstname, $surname, $userflags,
1143 $branchcode, $branchname, $branchprinter, $emailaddress ) = $sth->fetchrow;
1144 $debug and print STDERR "AUTH_3 results: " .
1145 "$cardnumber,$borrowernumber,$userid,$firstname,$surname,$userflags,$branchcode,$emailaddress\n";
1147 print STDERR "AUTH_3: no results for userid='$userid', cardnumber='$cardnumber'.\n";
1150 # launch a sequence to check if we have a ip for the branch, i
1151 # if we have one we replace the branchcode of the userenv by the branch bound in the ip.
1153 my $ip = $ENV{'REMOTE_ADDR'};
1155 # if they specify at login, use that
1156 if ( $query->param('branch') ) {
1157 $branchcode = $query->param('branch');
1158 my $library = Koha::Libraries->find($branchcode);
1159 $branchname = $library? $library->branchname: '';
1161 my $branches = { map { $_->branchcode => $_->unblessed } Koha::Libraries->search };
1162 if ( $type ne 'opac' and C4::Context->boolean_preference('AutoLocation') ) {
1164 # we have to check they are coming from the right ip range
1165 my $domain = $branches->{$branchcode}->{'branchip'};
1166 $domain =~ s|\.\*||g;
1167 if ( $ip !~ /^$domain/ ) {
1169 $cookie = $query->cookie(
1170 -name => 'CGISESSID',
1173 -secure => ( C4::Context->https_enabled() ? 1 : 0 ),
1175 $info{'wrongip'} = 1;
1179 foreach my $br ( keys %$branches ) {
1181 # now we work with the treatment of ip
1182 my $domain = $branches->{$br}->{'branchip'};
1183 if ( $domain && $ip =~ /^$domain/ ) {
1184 $branchcode = $branches->{$br}->{'branchcode'};
1186 # new op dev : add the branchprinter and branchname in the cookie
1187 $branchprinter = $branches->{$br}->{'branchprinter'};
1188 $branchname = $branches->{$br}->{'branchname'};
1191 $session->param( 'number', $borrowernumber );
1192 $session->param( 'id', $userid );
1193 $session->param( 'cardnumber', $cardnumber );
1194 $session->param( 'firstname', $firstname );
1195 $session->param( 'surname', $surname );
1196 $session->param( 'branch', $branchcode );
1197 $session->param( 'branchname', $branchname );
1198 $session->param( 'flags', $userflags );
1199 $session->param( 'emailaddress', $emailaddress );
1200 $session->param( 'ip', $session->remote_addr() );
1201 $session->param( 'lasttime', time() );
1202 $session->param( 'interface', $type);
1203 $session->param( 'shibboleth', $shibSuccess );
1204 $debug and printf STDERR "AUTH_4: (%s)\t%s %s - %s\n", map { $session->param($_) } qw(cardnumber firstname surname branch);
1206 $session->param('cas_ticket', $cas_ticket) if $cas_ticket;
1207 C4::Context->set_userenv(
1208 $session->param('number'), $session->param('id'),
1209 $session->param('cardnumber'), $session->param('firstname'),
1210 $session->param('surname'), $session->param('branch'),
1211 $session->param('branchname'), $session->param('flags'),
1212 $session->param('emailaddress'), $session->param('branchprinter'),
1213 $session->param('shibboleth')
1217 # $return: 0 = invalid user
1218 # reset to anonymous session
1220 $debug and warn "Login failed, resetting anonymous session...";
1222 $info{'invalid_username_or_password'} = 1;
1223 C4::Context->_unset_userenv($sessionID);
1225 $session->param( 'lasttime', time() );
1226 $session->param( 'ip', $session->remote_addr() );
1227 $session->param( 'sessiontype', 'anon' );
1228 $session->param( 'interface', $type);
1230 } # END if ( $q_userid
1231 elsif ( $type eq "opac" ) {
1233 # if we are here this is an anonymous session; add public lists to it and a few other items...
1234 # anonymous sessions are created only for the OPAC
1235 $debug and warn "Initiating an anonymous session...";
1237 # setting a couple of other session vars...
1238 $session->param( 'ip', $session->remote_addr() );
1239 $session->param( 'lasttime', time() );
1240 $session->param( 'sessiontype', 'anon' );
1241 $session->param( 'interface', $type);
1243 } # END unless ($userid)
1245 # finished authentification, now respond
1246 if ( $loggedin || $authnotrequired )
1250 $cookie = $query->cookie(
1251 -name => 'CGISESSID',
1254 -secure => ( C4::Context->https_enabled() ? 1 : 0 ),
1258 track_login_daily( $userid );
1260 # In case, that this request was a login attempt, we want to prevent that users can repost the opac login
1261 # request. We therefore redirect the user to the requested page again without the login parameters.
1262 # See Post/Redirect/Get (PRG) design pattern: https://en.wikipedia.org/wiki/Post/Redirect/Get
1263 if ( $type eq "opac" && $query->param('koha_login_context') && $query->param('koha_login_context') ne 'sco' && $query->param('password') && $query->param('userid') ) {
1264 my $uri = URI->new($query->url(-relative=>1, -query_string=>1));
1265 $uri->query_param_delete('userid');
1266 $uri->query_param_delete('password');
1267 $uri->query_param_delete('koha_login_context');
1268 print $query->redirect(-uri => $uri->as_string, -cookie => $cookie, -status=>'303 See other');
1272 return ( $userid, $cookie, $sessionID, $flags );
1277 # AUTH rejected, show the login/password template, after checking the DB.
1281 # get the inputs from the incoming query
1283 foreach my $name ( param $query) {
1284 (next) if ( $name eq 'userid' || $name eq 'password' || $name eq 'ticket' );
1285 my @value = $query->multi_param($name);
1286 push @inputs, { name => $name, value => $_ } for @value;
1289 my $patron = Koha::Patrons->find({ userid => $q_userid }); # Not necessary logged in!
1291 my $LibraryNameTitle = C4::Context->preference("LibraryName");
1292 $LibraryNameTitle =~ s/<(?:\/?)(?:br|p)\s*(?:\/?)>/ /sgi;
1293 $LibraryNameTitle =~ s/<(?:[^<>'"]|'(?:[^']*)'|"(?:[^"]*)")*>//sg;
1295 my $auth_template_name = ( $type eq 'opac' ) ? 'opac-auth.tt' : 'auth.tt';
1296 my $template = C4::Templates::gettemplate( $auth_template_name, $type, $query );
1300 script_name => get_script_name(),
1301 casAuthentication => C4::Context->preference("casAuthentication"),
1302 shibbolethAuthentication => $shib,
1303 SessionRestrictionByIP => C4::Context->preference("SessionRestrictionByIP"),
1304 suggestion => C4::Context->preference("suggestion"),
1305 virtualshelves => C4::Context->preference("virtualshelves"),
1306 LibraryName => "" . C4::Context->preference("LibraryName"),
1307 LibraryNameTitle => "" . $LibraryNameTitle,
1308 opacuserlogin => C4::Context->preference("opacuserlogin"),
1309 OpacNav => C4::Context->preference("OpacNav"),
1310 OpacNavBottom => C4::Context->preference("OpacNavBottom"),
1311 opaccredits => C4::Context->preference("opaccredits"),
1312 OpacFavicon => C4::Context->preference("OpacFavicon"),
1313 opacreadinghistory => C4::Context->preference("opacreadinghistory"),
1314 opaclanguagesdisplay => C4::Context->preference("opaclanguagesdisplay"),
1315 OPACUserJS => C4::Context->preference("OPACUserJS"),
1316 opacbookbag => "" . C4::Context->preference("opacbookbag"),
1317 OpacCloud => C4::Context->preference("OpacCloud"),
1318 OpacTopissue => C4::Context->preference("OpacTopissue"),
1319 OpacAuthorities => C4::Context->preference("OpacAuthorities"),
1320 OpacBrowser => C4::Context->preference("OpacBrowser"),
1321 opacheader => C4::Context->preference("opacheader"),
1322 TagsEnabled => C4::Context->preference("TagsEnabled"),
1323 OPACUserCSS => C4::Context->preference("OPACUserCSS"),
1324 intranetcolorstylesheet => C4::Context->preference("intranetcolorstylesheet"),
1325 intranetstylesheet => C4::Context->preference("intranetstylesheet"),
1326 intranetbookbag => C4::Context->preference("intranetbookbag"),
1327 IntranetNav => C4::Context->preference("IntranetNav"),
1328 IntranetFavicon => C4::Context->preference("IntranetFavicon"),
1329 IntranetUserCSS => C4::Context->preference("IntranetUserCSS"),
1330 IntranetUserJS => C4::Context->preference("IntranetUserJS"),
1331 IndependentBranches => C4::Context->preference("IndependentBranches"),
1332 AutoLocation => C4::Context->preference("AutoLocation"),
1333 wrongip => $info{'wrongip'},
1334 PatronSelfRegistration => C4::Context->preference("PatronSelfRegistration"),
1335 PatronSelfRegistrationDefaultCategory => C4::Context->preference("PatronSelfRegistrationDefaultCategory"),
1336 opac_css_override => $ENV{'OPAC_CSS_OVERRIDE'},
1337 too_many_login_attempts => ( $patron and $patron->account_locked )
1340 $template->param( SCO_login => 1 ) if ( $query->param('sco_user_login') );
1341 $template->param( SCI_login => 1 ) if ( $query->param('sci_user_login') );
1342 $template->param( OpacPublic => C4::Context->preference("OpacPublic") );
1343 $template->param( loginprompt => 1 ) unless $info{'nopermission'};
1345 if ( $type eq 'opac' ) {
1346 require Koha::Virtualshelves;
1347 my $some_public_shelves = Koha::Virtualshelves->get_some_shelves(
1353 some_public_shelves => $some_public_shelves,
1359 # Is authentication against multiple CAS servers enabled?
1360 if ( C4::Auth_with_cas::multipleAuth && !$casparam ) {
1361 my $casservers = C4::Auth_with_cas::getMultipleAuth();
1363 foreach my $key ( keys %$casservers ) {
1364 push @tmplservers, { name => $key, value => login_cas_url( $query, $key, $type ) . "?cas=$key" };
1367 casServersLoop => \@tmplservers
1371 casServerUrl => login_cas_url($query, undef, $type),
1376 invalidCasLogin => $info{'invalidCasLogin'}
1382 shibbolethAuthentication => $shib,
1383 shibbolethLoginUrl => login_shib_url($query),
1387 if (C4::Context->preference('GoogleOpenIDConnect')) {
1388 if ($query->param("OpenIDConnectFailed")) {
1389 my $reason = $query->param('OpenIDConnectFailed');
1390 $template->param(invalidGoogleOpenIDConnectLogin => $reason);
1395 LibraryName => C4::Context->preference("LibraryName"),
1397 $template->param(%info);
1399 # $cookie = $query->cookie(CGISESSID => $session->id
1401 print $query->header(
1402 { type => 'text/html',
1405 'X-Frame-Options' => 'SAMEORIGIN'
1412 =head2 check_api_auth
1414 ($status, $cookie, $sessionId) = check_api_auth($query, $userflags);
1416 Given a CGI query containing the parameters 'userid' and 'password' and/or a session
1417 cookie, determine if the user has the privileges specified by C<$userflags>.
1419 C<check_api_auth> is is meant for authenticating users of web services, and
1420 consequently will always return and will not attempt to redirect the user
1423 If a valid session cookie is already present, check_api_auth will return a status
1424 of "ok", the cookie, and the Koha session ID.
1426 If no session cookie is present, check_api_auth will check the 'userid' and 'password
1427 parameters and create a session cookie and Koha session if the supplied credentials
1430 Possible return values in C<$status> are:
1434 =item "ok" -- user authenticated; C<$cookie> and C<$sessionid> have valid values.
1436 =item "failed" -- credentials are not correct; C<$cookie> and C<$sessionid> are undef
1438 =item "maintenance" -- DB is in maintenance mode; no login possible at the moment
1440 =item "expired -- session cookie has expired; API user should resubmit userid and password
1446 sub check_api_auth {
1449 my $flagsrequired = shift;
1450 my $dbh = C4::Context->dbh;
1451 my $timeout = _timeout_syspref();
1453 unless ( C4::Context->preference('Version') ) {
1455 # database has not been installed yet
1456 return ( "maintenance", undef, undef );
1458 my $kohaversion = Koha::version();
1459 $kohaversion =~ s/(.*\..*)\.(.*)\.(.*)/$1$2$3/;
1460 if ( C4::Context->preference('Version') < $kohaversion ) {
1462 # database in need of version update; assume that
1463 # no API should be called while databsae is in
1465 return ( "maintenance", undef, undef );
1468 # FIXME -- most of what follows is a copy-and-paste
1469 # of code from checkauth. There is an obvious need
1470 # for refactoring to separate the various parts of
1471 # the authentication code, but as of 2007-11-19 this
1472 # is deferred so as to not introduce bugs into the
1473 # regular authentication code for Koha 3.0.
1475 # see if we have a valid session cookie already
1476 # however, if a userid parameter is present (i.e., from
1477 # a form submission, assume that any current cookie
1479 my $sessionID = undef;
1480 unless ( $query->param('userid') ) {
1481 $sessionID = $query->cookie("CGISESSID");
1483 if ( $sessionID && not( $cas && $query->param('PT') ) ) {
1484 my $session = get_session($sessionID);
1485 C4::Context->_new_userenv($sessionID);
1487 C4::Context->interface($session->param('interface'));
1488 C4::Context->set_userenv(
1489 $session->param('number'), $session->param('id'),
1490 $session->param('cardnumber'), $session->param('firstname'),
1491 $session->param('surname'), $session->param('branch'),
1492 $session->param('branchname'), $session->param('flags'),
1493 $session->param('emailaddress'), $session->param('branchprinter')
1496 my $ip = $session->param('ip');
1497 my $lasttime = $session->param('lasttime');
1498 my $userid = $session->param('id');
1499 if ( $lasttime < time() - $timeout ) {
1504 C4::Context->_unset_userenv($sessionID);
1507 return ( "expired", undef, undef );
1508 } elsif ( C4::Context->preference('SessionRestrictionByIP') && $ip ne $ENV{'REMOTE_ADDR'} ) {
1510 # IP address changed
1513 C4::Context->_unset_userenv($sessionID);
1516 return ( "expired", undef, undef );
1518 my $cookie = $query->cookie(
1519 -name => 'CGISESSID',
1520 -value => $session->id,
1522 -secure => ( C4::Context->https_enabled() ? 1 : 0 ),
1524 $session->param( 'lasttime', time() );
1525 my $flags = haspermission( $userid, $flagsrequired );
1527 return ( "ok", $cookie, $sessionID );
1531 C4::Context->_unset_userenv($sessionID);
1534 return ( "failed", undef, undef );
1538 return ( "expired", undef, undef );
1543 my $userid = $query->param('userid');
1544 my $password = $query->param('password');
1545 my ( $return, $cardnumber, $cas_ticket );
1548 if ( $cas && $query->param('PT') ) {
1550 $debug and print STDERR "## check_api_auth - checking CAS\n";
1552 # In case of a CAS authentication, we use the ticket instead of the password
1553 my $PT = $query->param('PT');
1554 ( $return, $cardnumber, $userid, $cas_ticket ) = check_api_auth_cas( $dbh, $PT, $query ); # EXTERNAL AUTH
1557 # User / password auth
1558 unless ( $userid and $password ) {
1560 # caller did something wrong, fail the authenticateion
1561 return ( "failed", undef, undef );
1564 ( $return, $cardnumber, $newuserid, $cas_ticket ) = checkpw( $dbh, $userid, $password, $query );
1567 if ( $return and haspermission( $userid, $flagsrequired ) ) {
1568 my $session = get_session("");
1569 return ( "failed", undef, undef ) unless $session;
1571 my $sessionID = $session->id;
1572 C4::Context->_new_userenv($sessionID);
1573 my $cookie = $query->cookie(
1574 -name => 'CGISESSID',
1575 -value => $sessionID,
1577 -secure => ( C4::Context->https_enabled() ? 1 : 0 ),
1579 if ( $return == 1 ) {
1581 $borrowernumber, $firstname, $surname,
1582 $userflags, $branchcode, $branchname,
1583 $branchprinter, $emailaddress
1587 "select borrowernumber, firstname, surname, flags, borrowers.branchcode, branches.branchname as branchname,branches.branchprinter as branchprinter, email from borrowers left join branches on borrowers.branchcode=branches.branchcode where userid=?"
1589 $sth->execute($userid);
1591 $borrowernumber, $firstname, $surname,
1592 $userflags, $branchcode, $branchname,
1593 $branchprinter, $emailaddress
1594 ) = $sth->fetchrow if ( $sth->rows );
1596 unless ( $sth->rows ) {
1597 my $sth = $dbh->prepare(
1598 "select borrowernumber, firstname, surname, flags, borrowers.branchcode, branches.branchname as branchname, branches.branchprinter as branchprinter, email from borrowers left join branches on borrowers.branchcode=branches.branchcode where cardnumber=?"
1600 $sth->execute($cardnumber);
1602 $borrowernumber, $firstname, $surname,
1603 $userflags, $branchcode, $branchname,
1604 $branchprinter, $emailaddress
1605 ) = $sth->fetchrow if ( $sth->rows );
1607 unless ( $sth->rows ) {
1608 $sth->execute($userid);
1610 $borrowernumber, $firstname, $surname, $userflags,
1611 $branchcode, $branchname, $branchprinter, $emailaddress
1612 ) = $sth->fetchrow if ( $sth->rows );
1616 my $ip = $ENV{'REMOTE_ADDR'};
1618 # if they specify at login, use that
1619 if ( $query->param('branch') ) {
1620 $branchcode = $query->param('branch');
1621 my $library = Koha::Libraries->find($branchcode);
1622 $branchname = $library? $library->branchname: '';
1624 my $branches = { map { $_->branchcode => $_->unblessed } Koha::Libraries->search };
1625 foreach my $br ( keys %$branches ) {
1627 # now we work with the treatment of ip
1628 my $domain = $branches->{$br}->{'branchip'};
1629 if ( $domain && $ip =~ /^$domain/ ) {
1630 $branchcode = $branches->{$br}->{'branchcode'};
1632 # new op dev : add the branchprinter and branchname in the cookie
1633 $branchprinter = $branches->{$br}->{'branchprinter'};
1634 $branchname = $branches->{$br}->{'branchname'};
1637 $session->param( 'number', $borrowernumber );
1638 $session->param( 'id', $userid );
1639 $session->param( 'cardnumber', $cardnumber );
1640 $session->param( 'firstname', $firstname );
1641 $session->param( 'surname', $surname );
1642 $session->param( 'branch', $branchcode );
1643 $session->param( 'branchname', $branchname );
1644 $session->param( 'flags', $userflags );
1645 $session->param( 'emailaddress', $emailaddress );
1646 $session->param( 'ip', $session->remote_addr() );
1647 $session->param( 'lasttime', time() );
1648 $session->param( 'interface', 'api' );
1650 $session->param( 'cas_ticket', $cas_ticket);
1651 C4::Context->set_userenv(
1652 $session->param('number'), $session->param('id'),
1653 $session->param('cardnumber'), $session->param('firstname'),
1654 $session->param('surname'), $session->param('branch'),
1655 $session->param('branchname'), $session->param('flags'),
1656 $session->param('emailaddress'), $session->param('branchprinter')
1658 return ( "ok", $cookie, $sessionID );
1660 return ( "failed", undef, undef );
1665 =head2 check_cookie_auth
1667 ($status, $sessionId) = check_api_auth($cookie, $userflags);
1669 Given a CGISESSID cookie set during a previous login to Koha, determine
1670 if the user has the privileges specified by C<$userflags>. C<$userflags>
1671 is passed unaltered into C<haspermission> and as such accepts all options
1672 avaiable to that routine with the one caveat that C<check_api_auth> will
1673 also allow 'undef' to be passed and in such a case the permissions check
1674 will be skipped altogether.
1676 C<check_cookie_auth> is meant for authenticating special services
1677 such as tools/upload-file.pl that are invoked by other pages that
1678 have been authenticated in the usual way.
1680 Possible return values in C<$status> are:
1684 =item "ok" -- user authenticated; C<$sessionID> have valid values.
1686 =item "failed" -- credentials are not correct; C<$sessionid> are undef
1688 =item "maintenance" -- DB is in maintenance mode; no login possible at the moment
1690 =item "expired -- session cookie has expired; API user should resubmit userid and password
1696 sub check_cookie_auth {
1698 my $flagsrequired = shift;
1701 my $remote_addr = $params->{remote_addr} || $ENV{REMOTE_ADDR};
1702 my $dbh = C4::Context->dbh;
1703 my $timeout = _timeout_syspref();
1705 unless ( C4::Context->preference('Version') ) {
1707 # database has not been installed yet
1708 return ( "maintenance", undef );
1710 my $kohaversion = Koha::version();
1711 $kohaversion =~ s/(.*\..*)\.(.*)\.(.*)/$1$2$3/;
1712 if ( C4::Context->preference('Version') < $kohaversion ) {
1714 # database in need of version update; assume that
1715 # no API should be called while databsae is in
1717 return ( "maintenance", undef );
1720 # FIXME -- most of what follows is a copy-and-paste
1721 # of code from checkauth. There is an obvious need
1722 # for refactoring to separate the various parts of
1723 # the authentication code, but as of 2007-11-23 this
1724 # is deferred so as to not introduce bugs into the
1725 # regular authentication code for Koha 3.0.
1727 # see if we have a valid session cookie already
1728 # however, if a userid parameter is present (i.e., from
1729 # a form submission, assume that any current cookie
1731 unless ( defined $cookie and $cookie ) {
1732 return ( "failed", undef );
1734 my $sessionID = $cookie;
1735 my $session = get_session($sessionID);
1736 C4::Context->_new_userenv($sessionID);
1738 C4::Context->interface($session->param('interface'));
1739 C4::Context->set_userenv(
1740 $session->param('number'), $session->param('id'),
1741 $session->param('cardnumber'), $session->param('firstname'),
1742 $session->param('surname'), $session->param('branch'),
1743 $session->param('branchname'), $session->param('flags'),
1744 $session->param('emailaddress'), $session->param('branchprinter')
1747 my $ip = $session->param('ip');
1748 my $lasttime = $session->param('lasttime');
1749 my $userid = $session->param('id');
1750 if ( $lasttime < time() - $timeout ) {
1755 C4::Context->_unset_userenv($sessionID);
1758 return ("expired", undef);
1759 } elsif ( C4::Context->preference('SessionRestrictionByIP') && $ip ne $remote_addr ) {
1761 # IP address changed
1764 C4::Context->_unset_userenv($sessionID);
1767 return ( "expired", undef );
1769 $session->param( 'lasttime', time() );
1770 my $flags = defined($flagsrequired) ? haspermission( $userid, $flagsrequired ) : 1;
1772 return ( "ok", $sessionID );
1776 C4::Context->_unset_userenv($sessionID);
1779 return ( "failed", undef );
1783 return ( "expired", undef );
1790 my $session = get_session($sessionID);
1792 Given a session ID, retrieve the CGI::Session object used to store
1793 the session's state. The session object can be used to store
1794 data that needs to be accessed by different scripts during a
1797 If the C<$sessionID> parameter is an empty string, a new session
1802 sub _get_session_params {
1803 my $storage_method = C4::Context->preference('SessionStorage');
1804 if ( $storage_method eq 'mysql' ) {
1805 my $dbh = C4::Context->dbh;
1806 return { dsn => "driver:MySQL;serializer:yaml;id:md5", dsn_args => { Handle => $dbh } };
1808 elsif ( $storage_method eq 'Pg' ) {
1809 my $dbh = C4::Context->dbh;
1810 return { dsn => "driver:PostgreSQL;serializer:yaml;id:md5", dsn_args => { Handle => $dbh } };
1812 elsif ( $storage_method eq 'memcached' && Koha::Caches->get_instance->memcached_cache ) {
1813 my $memcached = Koha::Caches->get_instance()->memcached_cache;
1814 return { dsn => "driver:memcached;serializer:yaml;id:md5", dsn_args => { Memcached => $memcached } };
1817 # catch all defaults to tmp should work on all systems
1818 my $dir = C4::Context::temporary_directory;
1819 my $instance = C4::Context->config( 'database' ); #actually for packages not exactly the instance name, but generally safer to leave it as it is
1820 return { dsn => "driver:File;serializer:yaml;id:md5", dsn_args => { Directory => "$dir/cgisess_$instance" } };
1825 my $sessionID = shift;
1826 my $params = _get_session_params();
1827 return new CGI::Session( $params->{dsn}, $sessionID, $params->{dsn_args} );
1831 # FIXME no_set_userenv may be replaced with force_branchcode_for_userenv
1832 # (or something similar)
1833 # Currently it's only passed from C4::SIP::ILS::Patron::check_password, but
1834 # not having a userenv defined could cause a crash.
1836 my ( $dbh, $userid, $password, $query, $type, $no_set_userenv ) = @_;
1837 $type = 'opac' unless $type;
1839 # Get shibboleth login attribute
1840 my $shib = C4::Context->config('useshibboleth') && shib_ok();
1841 my $shib_login = $shib ? get_login_shib() : undef;
1845 if ( defined $userid ){
1846 $patron = Koha::Patrons->find({ userid => $userid });
1847 $patron = Koha::Patrons->find({ cardnumber => $userid }) unless $patron;
1849 my $check_internal_as_fallback = 0;
1851 # Note: checkpw_* routines returns:
1854 # -1 if user bind failed (LDAP only)
1856 if ( $patron and $patron->account_locked ) {
1857 # Nothing to check, account is locked
1858 } elsif ($ldap && defined($password)) {
1859 $debug and print STDERR "## checkpw - checking LDAP\n";
1860 my ( $retval, $retcard, $retuserid ) = checkpw_ldap(@_); # EXTERNAL AUTH
1861 if ( $retval == 1 ) {
1862 @return = ( $retval, $retcard, $retuserid );
1865 $check_internal_as_fallback = 1 if $retval == 0;
1867 } elsif ( $cas && $query && $query->param('ticket') ) {
1868 $debug and print STDERR "## checkpw - checking CAS\n";
1870 # In case of a CAS authentication, we use the ticket instead of the password
1871 my $ticket = $query->param('ticket');
1872 $query->delete('ticket'); # remove ticket to come back to original URL
1873 my ( $retval, $retcard, $retuserid, $cas_ticket ) = checkpw_cas( $dbh, $ticket, $query, $type ); # EXTERNAL AUTH
1875 @return = ( $retval, $retcard, $retuserid, $cas_ticket );
1879 $passwd_ok = $retval;
1882 # If we are in a shibboleth session (shibboleth is enabled, and a shibboleth match attribute is present)
1883 # Check for password to asertain whether we want to be testing against shibboleth or another method this
1885 elsif ( $shib && $shib_login && !$password ) {
1887 $debug and print STDERR "## checkpw - checking Shibboleth\n";
1889 # In case of a Shibboleth authentication, we expect a shibboleth user attribute
1890 # (defined under shibboleth mapping in koha-conf.xml) to contain the login of the
1891 # shibboleth-authenticated user
1893 # Then, we check if it matches a valid koha user
1895 my ( $retval, $retcard, $retuserid ) = C4::Auth_with_shibboleth::checkpw_shib($shib_login); # EXTERNAL AUTH
1897 @return = ( $retval, $retcard, $retuserid );
1899 $passwd_ok = $retval;
1902 $check_internal_as_fallback = 1;
1906 if ( $check_internal_as_fallback ) {
1907 @return = checkpw_internal( $dbh, $userid, $password, $no_set_userenv);
1908 $passwd_ok = 1 if $return[0] > 0; # 1 or 2
1913 $patron->update({ login_attempts => 0 });
1914 } elsif( !$patron->account_locked ) {
1915 $patron->update({ login_attempts => $patron->login_attempts + 1 });
1921 sub checkpw_internal {
1922 my ( $dbh, $userid, $password, $no_set_userenv ) = @_;
1924 $password = Encode::encode( 'UTF-8', $password )
1925 if Encode::is_utf8($password);
1929 "select password,cardnumber,borrowernumber,userid,firstname,surname,borrowers.branchcode,branches.branchname,flags from borrowers join branches on borrowers.branchcode=branches.branchcode where userid=?"
1931 $sth->execute($userid);
1933 my ( $stored_hash, $cardnumber, $borrowernumber, $userid, $firstname,
1934 $surname, $branchcode, $branchname, $flags )
1937 if ( checkpw_hash( $password, $stored_hash ) ) {
1939 C4::Context->set_userenv( "$borrowernumber", $userid, $cardnumber,
1940 $firstname, $surname, $branchcode, $branchname, $flags ) unless $no_set_userenv;
1941 return 1, $cardnumber, $userid;
1946 "select password,cardnumber,borrowernumber,userid,firstname,surname,borrowers.branchcode,branches.branchname,flags from borrowers join branches on borrowers.branchcode=branches.branchcode where cardnumber=?"
1948 $sth->execute($userid);
1950 my ( $stored_hash, $cardnumber, $borrowernumber, $userid, $firstname,
1951 $surname, $branchcode, $branchname, $flags )
1954 if ( checkpw_hash( $password, $stored_hash ) ) {
1956 C4::Context->set_userenv( $borrowernumber, $userid, $cardnumber,
1957 $firstname, $surname, $branchcode, $branchname, $flags ) unless $no_set_userenv;
1958 return 1, $cardnumber, $userid;
1965 my ( $password, $stored_hash ) = @_;
1967 return if $stored_hash eq '!';
1969 # check what encryption algorithm was implemented: Bcrypt - if the hash starts with '$2' it is Bcrypt else md5
1971 if ( substr( $stored_hash, 0, 2 ) eq '$2' ) {
1972 $hash = hash_password( $password, $stored_hash );
1974 $hash = md5_base64($password);
1976 return $hash eq $stored_hash;
1981 my $authflags = getuserflags($flags, $userid, [$dbh]);
1983 Translates integer flags into permissions strings hash.
1985 C<$flags> is the integer userflags value ( borrowers.userflags )
1986 C<$userid> is the members.userid, used for building subpermissions
1987 C<$authflags> is a hashref of permissions
1994 my $dbh = @_ ? shift : C4::Context->dbh;
1997 # I don't want to do this, but if someone logs in as the database
1998 # user, it would be preferable not to spam them to death with
1999 # numeric warnings. So, we make $flags numeric.
2000 no warnings 'numeric';
2003 my $sth = $dbh->prepare("SELECT bit, flag, defaulton FROM userflags");
2006 while ( my ( $bit, $flag, $defaulton ) = $sth->fetchrow ) {
2007 if ( ( $flags & ( 2**$bit ) ) || $defaulton ) {
2008 $userflags->{$flag} = 1;
2011 $userflags->{$flag} = 0;
2015 # get subpermissions and merge with top-level permissions
2016 my $user_subperms = get_user_subpermissions($userid);
2017 foreach my $module ( keys %$user_subperms ) {
2018 next if $userflags->{$module} == 1; # user already has permission for everything in this module
2019 $userflags->{$module} = $user_subperms->{$module};
2025 =head2 get_user_subpermissions
2027 $user_perm_hashref = get_user_subpermissions($userid);
2029 Given the userid (note, not the borrowernumber) of a staff user,
2030 return a hashref of hashrefs of the specific subpermissions
2031 accorded to the user. An example return is
2035 export_catalog => 1,
2036 import_patrons => 1,
2040 The top-level hash-key is a module or function code from
2041 userflags.flag, while the second-level key is a code
2044 The results of this function do not give a complete picture
2045 of the functions that a staff user can access; it is also
2046 necessary to check borrowers.flags.
2050 sub get_user_subpermissions {
2053 my $dbh = C4::Context->dbh;
2054 my $sth = $dbh->prepare( "SELECT flag, user_permissions.code
2055 FROM user_permissions
2056 JOIN permissions USING (module_bit, code)
2057 JOIN userflags ON (module_bit = bit)
2058 JOIN borrowers USING (borrowernumber)
2059 WHERE userid = ?" );
2060 $sth->execute($userid);
2062 my $user_perms = {};
2063 while ( my $perm = $sth->fetchrow_hashref ) {
2064 $user_perms->{ $perm->{'flag'} }->{ $perm->{'code'} } = 1;
2069 =head2 get_all_subpermissions
2071 my $perm_hashref = get_all_subpermissions();
2073 Returns a hashref of hashrefs defining all specific
2074 permissions currently defined. The return value
2075 has the same structure as that of C<get_user_subpermissions>,
2076 except that the innermost hash value is the description
2077 of the subpermission.
2081 sub get_all_subpermissions {
2082 my $dbh = C4::Context->dbh;
2083 my $sth = $dbh->prepare( "SELECT flag, code
2085 JOIN userflags ON (module_bit = bit)" );
2089 while ( my $perm = $sth->fetchrow_hashref ) {
2090 $all_perms->{ $perm->{'flag'} }->{ $perm->{'code'} } = 1;
2095 =head2 haspermission
2097 $flagsrequired = '*'; # Any permission at all
2098 $flagsrequired = 'a_flag'; # a_flag must be satisfied (all subpermissions)
2099 $flagsrequired = [ 'a_flag', 'b_flag' ]; # a_flag OR b_flag must be satisfied
2100 $flagsrequired = { 'a_flag => 1, 'b_flag' => 1 }; # a_flag AND b_flag must be satisfied
2101 $flagsrequired = { 'a_flag' => 'sub_a' }; # sub_a of a_flag must be satisfied
2102 $flagsrequired = { 'a_flag' => [ 'sub_a, 'sub_b' ] }; # sub_a OR sub_b of a_flag must be satisfied
2104 $flags = ($userid, $flagsrequired);
2106 C<$userid> the userid of the member
2107 C<$flags> is a query structure similar to that used by SQL::Abstract that
2108 denotes the combination of flags required. It is a required parameter.
2110 The main logic of this method is that things in arrays are OR'ed, and things
2111 in hashes are AND'ed. The `*` character can be used, at any depth, to denote `ANY`
2113 Returns member's flags or 0 if a permission is not met.
2118 my ($required, $flags) = @_;
2120 my $ref = ref($required);
2122 if ($required eq '*') {
2123 return 0 unless ( $flags or ref( $flags ) );
2125 return 0 unless ( $flags and (!ref( $flags ) || $flags->{$required} ));
2127 } elsif ($ref eq 'HASH') {
2128 foreach my $key (keys %{$required}) {
2129 next if $flags == 1;
2130 my $require = $required->{$key};
2131 my $rflags = $flags->{$key};
2132 return 0 unless _dispatch($require, $rflags);
2134 } elsif ($ref eq 'ARRAY') {
2136 foreach my $require ( @{$required} ) {
2138 ( ref($flags) && !ref($require) && ( $require ne '*' ) )
2139 ? $flags->{$require}
2141 $satisfied++ if _dispatch( $require, $rflags );
2143 return 0 unless $satisfied;
2145 croak "Unexpected structure found: $ref";
2152 my ( $userid, $flagsrequired ) = @_;
2154 #Koha::Exceptions::WrongParameter->throw('$flagsrequired should not be undef')
2155 # unless defined($flagsrequired);
2157 my $sth = C4::Context->dbh->prepare("SELECT flags FROM borrowers WHERE userid=?");
2158 $sth->execute($userid);
2159 my $row = $sth->fetchrow();
2160 my $flags = getuserflags( $row, $userid );
2162 return $flags unless defined($flagsrequired);
2163 return $flags if $flags->{superlibrarian};
2164 return _dispatch($flagsrequired, $flags);
2166 #FIXME - This fcn should return the failed permission so a suitable error msg can be delivered.
2171 $flags = ($iprange);
2173 C<$iprange> A space separated string describing an IP range. Can include single IPs or ranges
2175 Returns 1 if the remote address is in the provided iprange, or 0 otherwise.
2182 my @allowedipranges = $iprange ? split(' ', $iprange) : ();
2183 if (scalar @allowedipranges > 0) {
2185 eval { @rangelist = Net::CIDR::range2cidr(@allowedipranges); }; return 0 if $@;
2186 eval { $result = Net::CIDR::cidrlookup($ENV{'REMOTE_ADDR'}, @rangelist) } || ( $ENV{DEBUG} && warn 'cidrlookup failed for ' . join(' ',@rangelist) );
2188 return $result ? 1 : 0;
2191 sub getborrowernumber {
2193 my $userenv = C4::Context->userenv;
2194 if ( defined($userenv) && ref($userenv) eq 'HASH' && $userenv->{number} ) {
2195 return $userenv->{number};
2197 my $dbh = C4::Context->dbh;
2198 for my $field ( 'userid', 'cardnumber' ) {
2200 $dbh->prepare("select borrowernumber from borrowers where $field=?");
2201 $sth->execute($userid);
2203 my ($bnumber) = $sth->fetchrow;
2210 =head2 track_login_daily
2212 track_login_daily( $userid );
2214 Wraps the call to $patron->track_login, the method used to update borrowers.lastseen. We only call track_login once a day.
2218 sub track_login_daily {
2220 return if !$userid || !C4::Context->preference('TrackLastPatronActivity');
2222 my $cache = Koha::Caches->get_instance();
2223 my $cache_key = "track_login_" . $userid;
2224 my $cached = $cache->get_from_cache($cache_key);
2225 my $today = dt_from_string()->ymd;
2226 return if $cached && $cached eq $today;
2228 my $patron = Koha::Patrons->find({ userid => $userid });
2229 return unless $patron;
2230 $patron->track_login;
2231 $cache->set_in_cache( $cache_key, $today );
2234 END { } # module clean-up code here (global destructor)
2244 Crypt::Eksblowfish::Bcrypt(3)