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)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Mon, 29 Jun 2020 10:37:01 +0000 (12:37 +0200)
commit721876785142fea84f02c7dbe4f325e2a605bd0f
treeb0d26e802e060d3184dd91d5c8b58e1ede3ee46f
parent23ed2e110e16f04a34c01ac866b470ec725b7522
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>
C4/Utils/DataTables/Members.pm