Simplified Hold Pull List: Fix several sorting bugs user/senator/fix-pull-list-sort
authorLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Wed, 8 Aug 2012 17:50:33 +0000 (13:50 -0400)
committerLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Thu, 9 Aug 2012 18:26:40 +0000 (14:26 -0400)
commitae29ef73ddff747105d107802082710c3ee19604
treed370b2cecc759cc9fef61f13f1cbb6b4e9b499fb
parentf36156a19e3e0d04535a7ee839fa0e3a922f3d47
Simplified Hold Pull List: Fix several sorting bugs

First of all, sorting on most columns was broken due to a bug in the way
that the flattener methods of the open-ils.fielder service were
constructing their SQL JOINs.  We were coming up with way too many
joins, and then losing track of which JOIN's alias to refer to when
building the ORDER BY clause later.  This is fixed.

Secondly, the shelving location column now sorts automatically by the
shelving location *ordering* values, when avaiable.  These are the
values that you set up in the drag-and-drop staff client interface
titled "Copy Location Order."  When these values are not set for the org
unit whose pull list you're viewing, the sorting will fall back to
alphabetical.

Signed-off-by: Lebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/perlmods/lib/OpenILS/Application/Fielder.pm
Open-ILS/src/perlmods/lib/OpenILS/Application/Flattener.pm
Open-ILS/src/templates/circ/hold_pull_list.tt2