Simplified Hold Pull List: Fix several sorting bugs
authorLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Wed, 8 Aug 2012 17:50:33 +0000 (13:50 -0400)
committerMike Rylander <mrylander@gmail.com>
Fri, 10 Aug 2012 12:39:23 +0000 (08:39 -0400)
commitfbc36bfdb1098df6b4cd8f48d59bc9b09cc679d4
tree6509e436ededa6b3c2756cbd7fae3edfbe7d8008
parente0e0b53bedae81c6f687cd2ea6db020f9ce9f9b4
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>
Signed-off-by: Mike Rylander <mrylander@gmail.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