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)
committerGalen Charlton <gmc@equinoxinitiative.org>
Thu, 13 Aug 2020 15:49:33 +0000 (11:49 -0400)
commit8c83473d135e9f2bdbddefaa0dbd299dba0ffaaf
treea084b5965aeabaec972259b13fd7385d849455e9
parent51ccfc9899893f51136a21e133472d55a0d7b7c4
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>
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]