From 9124e0199c88847976db29e2291e9fe66beab9cd Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Tue, 13 Dec 2022 20:59:50 +0000 Subject: [PATCH] Bug 30624: Add loggedinlibrary permission and DB update To test: 1. Apply patch, updatedatabase, restart_all 2. Have a user with superlibrarian privileges ( User1 ) 3. Have a user who has staff access and circulate privileges but is not a super librarian. ( User2 ) Make note of this users home library 4. Turn on the system preference 'CircSidebar'. -MAIN log in ( auth.tt ) 5. As User1, go to the main login screen and try logging in. You should be able to log in AND you should be able to properly chnage your branch BEFORE logging in. 6. As User2, to to the main login screnn amd try logging in. You should be able to but if you try and switch your libraray to anything beside the user's home branch it will not work. You will be logged in at your home branch. 7. For User2, set the new top level permission 'Allow staff to change logged in library (loggedinlibrary). 8. Now you should be able to successfully switch libraries before log in. 9. Turn the 'loggedinlibrary' permission back off for User2. -AFTER log in- 10. With User1, click on your name/branch in the top right, you should see the the link 'Set library' at the top. If you turn on 'UseCirculationDesks' the link will be 'Set library and desk'. 11. With User2, click on your name/branch in the top right. If you have 'UseCirculationDesks' on, you should see 'Set desk', otherwise you should see nothing. 12. Repeat step 7. 13. NOw if you click on your name/branch in the top right, you should see the the link 'Set library' at the top. If you turn on 'UseCirculationDesks' the link will be 'Set library and desk'. 14. Repeat Step 9. -CircSideBar- 15. With 'CircSideBar' turned on, go to any ciculation page (Holds queue, Holds to pull, Holds awaiting pickup) with User1. You will see the 'Set library' link. If 'UseCirculationDesks' is on you will see a 'Set library and desk'. 16. Try with User2 and you will not see a 'Set library' link. If 'UseCirculationDesks' is on you will see a 'Set desk' link. 17. Repeat step 7. 18. For with User2 you go to any ciculation page (Holds queue, Holds to pull, Holds awaiting pickup). You will see the 'Set library' link. If 'UseCirculationDesks' is on you will see a 'Set library and desk'. 19. Repeat step 9. -Set library page- 20. Go to the set library page (http://localhost:8081/cgi-bin/koha/circ/set-library.pl) with User1. You will see a dropdown for 'Set library'. Make sure you can change your library successfully. 21. Go to the set library page (http://localhost:8081/cgi-bin/koha/circ/set-library.pl) with User2. You should NOT see see a dropdown for 'Set library'. 22. Repeat step 7. 23. Go to the set library page (http://localhost:8081/cgi-bin/koha/circ/set-library.pl) with User2. Now you should see a dropdown for 'Set library'. --- C4/Auth.pm | 3 ++- .../atomicupdate/bug_30624_add_userflag.pl | 20 +++++++++++++++++++ installer/data/mysql/mandatory/userflags.sql | 3 ++- .../prog/en/includes/circ-nav.inc | 7 +++++-- .../intranet-tmpl/prog/en/includes/header.inc | 2 +- .../prog/en/includes/permissions.inc | 3 +++ .../prog/en/modules/circ/circulation-home.tt | 6 +++++- .../prog/en/modules/circ/set-library.tt | 2 +- 8 files changed, 39 insertions(+), 7 deletions(-) create mode 100755 installer/data/mysql/atomicupdate/bug_30624_add_userflag.pl diff --git a/C4/Auth.pm b/C4/Auth.pm index d8ddb170985..f6127fe8e38 100644 --- a/C4/Auth.pm +++ b/C4/Auth.pm @@ -1154,7 +1154,8 @@ sub checkauth { my $ip = $ENV{'REMOTE_ADDR'}; # if they specify at login, use that - if ( $query->param('branch') ) { + my $patron = Koha::Patrons->find({userid => $userid}); + if ( $query->param('branch') && ( haspermission($userid, { 'loggedinlibrary'=> 1 }) || $patron->is_superlibrarian ) ) { $branchcode = $query->param('branch'); my $library = Koha::Libraries->find($branchcode); $branchname = $library? $library->branchname: ''; diff --git a/installer/data/mysql/atomicupdate/bug_30624_add_userflag.pl b/installer/data/mysql/atomicupdate/bug_30624_add_userflag.pl new file mode 100755 index 00000000000..38735f1f997 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_30624_add_userflag.pl @@ -0,0 +1,20 @@ +use Modern::Perl; + +return { + bug_number => "30624", + description => "Add loggedinlibrary permission", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + $dbh->do(q{ + INSERT IGNORE INTO userflags (bit, flag, flagdesc, defaulton) VALUES (29, 'loggedinlibrary', 'Allow staff to change logged in library', 0) + }); + + my $IndependentBranches = C4::Context->preference('IndependentBranches'); + unless ( $IndependentBranches ) { + $dbh->do(q{ + UPDATE borrowers SET flags = flags + (2<<28) WHERE flags & 4; + }); + } + }, +}; diff --git a/installer/data/mysql/mandatory/userflags.sql b/installer/data/mysql/mandatory/userflags.sql index 137612f14cd..b9905e2f5e7 100644 --- a/installer/data/mysql/mandatory/userflags.sql +++ b/installer/data/mysql/mandatory/userflags.sql @@ -25,5 +25,6 @@ INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES (25, 'cash_management', 'Cash management', 0), (26, 'problem_reports', 'Manage problem reports', 0), (27, 'recalls', 'Recalls', 0), -(28, 'erm', 'Manage electronic resources', 0) +(28, 'erm', 'Manage electronic resources', 0), +(29, 'loggedinlibrary', 'Change logged in library', 0) ; diff --git a/koha-tmpl/intranet-tmpl/prog/en/includes/circ-nav.inc b/koha-tmpl/intranet-tmpl/prog/en/includes/circ-nav.inc index 61d82953b47..e10a4805897 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/includes/circ-nav.inc +++ b/koha-tmpl/intranet-tmpl/prog/en/includes/circ-nav.inc @@ -2,7 +2,6 @@ [% USE Branches %]