Bug 25875: Move check for module_bit and code to the JOIN
authorNick Clemens <nick@bywatersolutions.com>
Thu, 25 Jun 2020 10:38:26 +0000 (10:38 +0000)
committerLucas Gass <lucas@bywatersolutions.com>
Mon, 13 Jul 2020 16:22:27 +0000 (16:22 +0000)
commit59e1e78c6d59ee6ced202382e2910676a4e32360
treee79723f0f3383fe5b50c794d0efe3e1d3942eeb1
parent13ac8457d5ef1da87ecbc729ffb93b9f19fd84e1
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>
C4/Utils/DataTables/Members.pm