Bug 27933: Fix patron search result ordering
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Wed, 17 Mar 2021 09:14:43 +0000 (10:14 +0100)
committerFridolin Somers <fridolin.somers@biblibre.com>
Mon, 22 Mar 2021 09:40:50 +0000 (10:40 +0100)
commit18e10f100774dfc87cbcaf9e1ebbd28ab9b63de0
tree5a6d0845e5c52efb43f497d84f37d45c600d52fc
parent4d4be17afc0dc2fda311f2eea3ff32ea10a45049
Bug 27933: Fix patron search result ordering

On bug 27715 we restrict the order by dt params for security reasons.
However in some cases the param passed is "columnname" instead of
"table.columnname".
We should make sure the table is part of the sort fieldname.

Test plan:
Do a "normal" patron search (from the patrons home page) and another
patron search (guarantor for instance).
Sort by cardnumber, date of birth, expiration date, asc, desc and
confirm it works as expected.

Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
(cherry picked from commit 1b32e66380d5d7701b3f252e8d2be1cbf1622388)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
koha-tmpl/intranet-tmpl/prog/en/modules/common/patron_search.tt
koha-tmpl/intranet-tmpl/prog/en/modules/members/member.tt