LP#1850547: add views for PO and LI state labels
authorGalen Charlton <gmc@equinoxinitiative.org>
Tue, 11 Feb 2020 19:18:49 +0000 (14:18 -0500)
committerBill Erickson <berickxx@gmail.com>
Thu, 3 Sep 2020 15:52:19 +0000 (11:52 -0400)
commit2e75544de15dd0a5a011aea4e8f2dc50fd8b74a9
tree6bea88bddeecb5a9dd9b3df9ab475ddc93878cff
parent20ac557e84d7477906c4bd502a46bc91bcacfa5e
LP#1850547: add views for PO and LI state labels

This patch adds two new views, acq.po_state_label and
acq.li_state_label, to map from the state codes to human-friendly
labels in a way that allows the labels to be retrieved and
translated.

This patch also changes the fieldmapper label of the PO
and LI state column from "State" to "Status".

This patch includes contributions by Mike Rylander.

Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Tiffany Little <tlittle@georgialibraries.org>
Signed-off-by: Bill Erickson <berickxx@gmail.com>
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/sql/Pg/200.schema.acq.sql
Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.acq_state_views.sql [new file with mode: 0644]