Bug 25875: Move check for module_bit and code to the JOIN 19.05.x
authorNick Clemens <nick@bywatersolutions.com>
Thu, 25 Jun 2020 10:38:26 +0000 (10:38 +0000)
committerVictor Grousset/tuxayo <victor@tuxayo.net>
Sun, 26 Jul 2020 15:47:44 +0000 (17:47 +0200)
commit31900b557d1bca3245f239a2856e2a7694a28ecb
tree243464b3d590c090b1b267c41b674a94e8f907f8
parentd43a237884301163daed3e9a199347b42ce30dd5
Bug 25875: Move check for module_bit and code to the JOIN

If we limit the JOIN to rows with the correct subpermission we won't
duplicate the returned patrons

To test:
 1 - Give a patron full acquisitions permissions
 2 - Also give them several subpermissions on other areas
 3 - Go to Acquisitions
 4 - Edit a fund
 5 - Add a user to the fund
 6 - Search for user above
 7 - They return multiple times in results
 8 - Apply patch
 9 - Restart all the things
10 - Repeat search
11 - Patron appears once

Signed-off-by: Owen Leonard <oleonard@myacpl.org>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
(cherry picked from commit 721876785142fea84f02c7dbe4f325e2a605bd0f)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
(cherry picked from commit 59e1e78c6d59ee6ced202382e2910676a4e32360)

Signed-off-by: Aleisha Amohia <aleishaamohia@hotmail.com>

(cherry picked from commit 0cb156cba54e8433a3ea351a322f93c807a934e5)
Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net>
C4/Utils/DataTables/Members.pm