From 37d0436d26c027547fe5306e77e2c8fb35714a0e Mon Sep 17 00:00:00 2001 From: Lebbeous Fogle-Weekley Date: Wed, 11 Jan 2012 14:53:50 -0500 Subject: [PATCH] Move csp definitions from 002 to 950, so they can use i18n. I don't /think/ there's a point in having an upgrade script to go along with this, but someone who understands oils_18n_gettext() better should weigh in. Signed-off-by: Lebbeous Fogle-Weekley Signed-off-by: Thomas Berezansky --- Open-ILS/src/sql/Pg/002.schema.config.sql | 72 ------------------- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 73 ++++++++++++++++++++ 2 files changed, 73 insertions(+), 72 deletions(-) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index db5fa70e89..5958ac7bef 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -125,78 +125,6 @@ CREATE TABLE config.standing_penalty ( staff_alert BOOL NOT NULL DEFAULT FALSE, org_depth INTEGER ); -INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) - VALUES (1,'PATRON_EXCEEDS_FINES','Patron exceeds fine threshold','CIRC|HOLD|RENEW', TRUE); -INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) - VALUES (2,'PATRON_EXCEEDS_OVERDUE_COUNT','Patron exceeds max overdue item threshold','CIRC|HOLD|RENEW', TRUE); -INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) - VALUES (3,'PATRON_EXCEEDS_CHECKOUT_COUNT','Patron exceeds max checked out item threshold','CIRC', TRUE); -INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) - VALUES (4,'PATRON_EXCEEDS_COLLECTIONS_WARNING','Patron exceeds pre-collections warning fine threshold','CIRC|HOLD|RENEW', TRUE); - -INSERT INTO config.standing_penalty (id,name,label,staff_alert) VALUES (20,'ALERT_NOTE','Alerting Note, no blocks',TRUE); -INSERT INTO config.standing_penalty (id,name,label) VALUES (21,'SILENT_NOTE','Note, no blocks'); -INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) VALUES (22,'STAFF_C','Alerting block on Circ','CIRC', TRUE); -INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) VALUES (23,'STAFF_CH','Alerting block on Circ and Hold','CIRC|HOLD', TRUE); -INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) VALUES (24,'STAFF_CR','Alerting block on Circ and Renew','CIRC|RENEW', TRUE); -INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) VALUES (25,'STAFF_CHR','Alerting block on Circ, Hold and Renew','CIRC|HOLD|RENEW', TRUE); -INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) VALUES (26,'STAFF_HR','Alerting block on Hold and Renew','HOLD|RENEW', TRUE); -INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) VALUES (27,'STAFF_H','Alerting block on Hold','HOLD', TRUE); -INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) VALUES (28,'STAFF_R','Alerting block on Renew','RENEW', TRUE); -INSERT INTO config.standing_penalty (id,name,label) VALUES (29,'INVALID_PATRON_ADDRESS','Patron has an invalid address'); -INSERT INTO config.standing_penalty (id,name,label) VALUES (30,'PATRON_IN_COLLECTIONS','Patron has been referred to a collections agency'); -INSERT INTO config.standing_penalty (id, name, label, staff_alert, org_depth) VALUES - ( - 31, - 'INVALID_PATRON_EMAIL_ADDRESS', - oils_i18n_gettext( - 31, - 'Patron had an invalid email address', - 'csp', - 'label' - ), - TRUE, - 0 - ), - ( - 32, - 'INVALID_PATRON_DAY_PHONE', - oils_i18n_gettext( - 32, - 'Patron had an invalid daytime phone number', - 'csp', - 'label' - ), - TRUE, - 0 - ), - ( - 33, - 'INVALID_PATRON_EVENING_PHONE', - oils_i18n_gettext( - 33, - 'Patron had an invalid evening phone number', - 'csp', - 'label' - ), - TRUE, - 0 - ), - ( - 34, - 'INVALID_PATRON_OTHER_PHONE', - oils_i18n_gettext( - 34, - 'Patron had an invalid other phone number', - 'csp', - 'label' - ), - TRUE, - 0 - ); - - -SELECT SETVAL('config.standing_penalty_id_seq', 100); CREATE TABLE config.xml_transform ( name TEXT PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index 4e72cdaf98..ddb6b39fe3 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -19,6 +19,79 @@ INSERT INTO config.standing (id, value) VALUES (1, oils_i18n_gettext(1, 'Good', INSERT INTO config.standing (id, value) VALUES (2, oils_i18n_gettext(2, 'Barred', 'cst', 'value')); SELECT SETVAL('config.standing_id_seq'::TEXT, 100); +INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) + VALUES (1,'PATRON_EXCEEDS_FINES',oils_i18n_gettext(1, 'Patron exceeds fine threshold', 'csp', 'label'),'CIRC|HOLD|RENEW', TRUE); +INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) + VALUES (2,'PATRON_EXCEEDS_OVERDUE_COUNT',oils_i18n_gettext(2, 'Patron exceeds max overdue item threshold', 'csp', 'label'),'CIRC|HOLD|RENEW', TRUE); +INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) + VALUES (3,'PATRON_EXCEEDS_CHECKOUT_COUNT',oils_i18n_gettext(3, 'Patron exceeds max checked out item threshold', 'csp', 'label'),'CIRC', TRUE); +INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) + VALUES (4,'PATRON_EXCEEDS_COLLECTIONS_WARNING',oils_i18n_gettext(4, 'Patron exceeds pre-collections warning fine threshold', 'csp', 'label'),'CIRC|HOLD|RENEW', TRUE); + +INSERT INTO config.standing_penalty (id,name,label,staff_alert) VALUES (20,'ALERT_NOTE',oils_i18n_gettext(20, 'Alerting Note, no blocks', 'csp', 'label'),TRUE); +INSERT INTO config.standing_penalty (id,name,label) VALUES (21,'SILENT_NOTE',oils_i18n_gettext(21, 'Note, no blocks', 'csp', 'label')); +INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) VALUES (22,'STAFF_C',oils_i18n_gettext(22, 'Alerting block on Circ', 'csp', 'label'),'CIRC', TRUE); +INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) VALUES (23,'STAFF_CH',oils_i18n_gettext(23, 'Alerting block on Circ and Hold', 'csp', 'label'),'CIRC|HOLD', TRUE); +INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) VALUES (24,'STAFF_CR',oils_i18n_gettext(24, 'Alerting block on Circ and Renew', 'csp', 'label'),'CIRC|RENEW', TRUE); +INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) VALUES (25,'STAFF_CHR',oils_i18n_gettext(25, 'Alerting block on Circ, Hold and Renew', 'csp', 'label'),'CIRC|HOLD|RENEW', TRUE); +INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) VALUES (26,'STAFF_HR',oils_i18n_gettext(26, 'Alerting block on Hold and Renew', 'csp', 'label'),'HOLD|RENEW', TRUE); +INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) VALUES (27,'STAFF_H',oils_i18n_gettext(27, 'Alerting block on Hold', 'csp', 'label'),'HOLD', TRUE); +INSERT INTO config.standing_penalty (id,name,label,block_list,staff_alert) VALUES (28,'STAFF_R',oils_i18n_gettext(28, 'Alerting block on Renew', 'csp', 'label'),'RENEW', TRUE); +INSERT INTO config.standing_penalty (id,name,label) VALUES (29,'INVALID_PATRON_ADDRESS',oils_i18n_gettext(29, 'Patron has an invalid address', 'csp', 'label')); +INSERT INTO config.standing_penalty (id,name,label) VALUES (30,'PATRON_IN_COLLECTIONS',oils_i18n_gettext(30, 'Patron has been referred to a collections agency', 'csp', 'label')); +INSERT INTO config.standing_penalty (id, name, label, staff_alert, org_depth) VALUES + ( + 31, + 'INVALID_PATRON_EMAIL_ADDRESS', + oils_i18n_gettext( + 31, + 'Patron had an invalid email address', + 'csp', + 'label' + ), + TRUE, + 0 + ), + ( + 32, + 'INVALID_PATRON_DAY_PHONE', + oils_i18n_gettext( + 32, + 'Patron had an invalid daytime phone number', + 'csp', + 'label' + ), + TRUE, + 0 + ), + ( + 33, + 'INVALID_PATRON_EVENING_PHONE', + oils_i18n_gettext( + 33, + 'Patron had an invalid evening phone number', + 'csp', + 'label' + ), + TRUE, + 0 + ), + ( + 34, + 'INVALID_PATRON_OTHER_PHONE', + oils_i18n_gettext( + 34, + 'Patron had an invalid other phone number', + 'csp', + 'label' + ), + TRUE, + 0 + ); + + +SELECT SETVAL('config.standing_penalty_id_seq', 100); + INSERT INTO config.metabib_class ( name, label ) VALUES ( 'identifier', oils_i18n_gettext('identifier', 'Identifier', 'cmc', 'label') ); INSERT INTO config.metabib_class ( name, label ) VALUES ( 'keyword', oils_i18n_gettext('keyword', 'Keyword', 'cmc', 'label') ); INSERT INTO config.metabib_class ( name, label ) VALUES ( 'title', oils_i18n_gettext('title', 'Title', 'cmc', 'label') ); -- 2.43.2