LP#1850547: add views for PO and line item state labels
authorGalen Charlton <gmc@equinoxinitiative.org>
Tue, 11 Feb 2020 19:18:49 +0000 (14:18 -0500)
committerGalen Charlton <gmc@equinoxinitiative.org>
Wed, 26 Aug 2020 17:25:02 +0000 (13:25 -0400)
commita566e5bfc2879f69b6eb9cf81cee81596ef5606a
treed2dc933251eaa821e06c800a83eb6fd45936230f
parent8c8887611bfb1b3f5be0e99395199318a7e2dad1
LP#1850547: add views for PO and line item 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: Galen Charlton <gmc@equinoxinitiative.org>
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]