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)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Thu, 18 Mar 2021 14:03:26 +0000 (15:03 +0100)
commit1b32e66380d5d7701b3f252e8d2be1cbf1622388
tree310d71059ec6550a7e7a0ddf3e41a2cd951b31eb
parent675088752afcee77ddfd3279e617f0d657f1f81d
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>
koha-tmpl/intranet-tmpl/prog/en/modules/common/patron_search.tt
koha-tmpl/intranet-tmpl/prog/en/modules/members/member.tt