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>
Tue, 25 Aug 2020 16:31:05 +0000 (12:31 -0400)
commita365529d5b8fdf8533211b959a51347d786239f9
tree4d02c8ae2b43c3eb8ff1be70a31d3c2ea7ed2859
parentd617689499edc52a245908a82a065820f6b8d65d
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]