Bugzilla – Attachment 102668 Details for
Bug 25103
Dynamically add checkout types
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 25103: Add authorised values to sample data
Bug-25103-Add-authorised-values-to-sample-data.patch (text/plain), 9.05 KB, created by
Lari Taskula
on 2020-04-09 20:40:22 UTC
(
hide
)
Description:
Bug 25103: Add authorised values to sample data
Filename:
MIME Type:
Creator:
Lari Taskula
Created:
2020-04-09 20:40:22 UTC
Size:
9.05 KB
patch
obsolete
>From 7c0ede1f94f8d4b25938f544c2f95437a7780c7b Mon Sep 17 00:00:00 2001 >From: Lari Taskula <lari.taskula@hypernova.fi> >Date: Wed, 1 Apr 2020 17:29:33 +0000 >Subject: [PATCH] Bug 25103: Add authorised values to sample data > >Sponsored-by: The National Library of Finland >--- > installer/data/mysql/de-DE/mandatory/auth_values.sql | 2 ++ > installer/data/mysql/en/mandatory/auth_values.yml | 10 ++++++++++ > installer/data/mysql/es-ES/mandatory/auth_values.sql | 2 ++ > installer/data/mysql/fr-CA/obligatoire/auth_values.sql | 2 ++ > .../mysql/fr-FR/1-Obligatoire/authorised_values.sql | 4 ++++ > installer/data/mysql/it-IT/necessari/auth_val.sql | 4 ++++ > .../data/mysql/nb-NO/1-Obligatorisk/auth_values.sql | 2 ++ > installer/data/mysql/pl-PL/mandatory/auth_values.sql | 2 ++ > installer/data/mysql/ru-RU/mandatory/auth_values.sql | 2 ++ > installer/data/mysql/uk-UA/mandatory/auth_values.sql | 6 ++++++ > 10 files changed, 36 insertions(+) > >diff --git a/installer/data/mysql/de-DE/mandatory/auth_values.sql b/installer/data/mysql/de-DE/mandatory/auth_values.sql >index e1a27977f0..930e587e9b 100644 >--- a/installer/data/mysql/de-DE/mandatory/auth_values.sql >+++ b/installer/data/mysql/de-DE/mandatory/auth_values.sql >@@ -1,3 +1,5 @@ > INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','Nein','Nein'); > INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Ja','Ja'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Jede Woche'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); >diff --git a/installer/data/mysql/en/mandatory/auth_values.yml b/installer/data/mysql/en/mandatory/auth_values.yml >index 19f73d4f39..17f6622426 100644 >--- a/installer/data/mysql/en/mandatory/auth_values.yml >+++ b/installer/data/mysql/en/mandatory/auth_values.yml >@@ -50,6 +50,16 @@ tables: > lib: "Creditcard via SIP2" > lib_opac: "Creditcard" > >+ - category: "CHECKOUT_TYPE" >+ authorised_value: "C" >+ lib: "Normal checkout" >+ lib_opac: "Normal checkout" >+ >+ - category: "CHECKOUT_TYPE" >+ authorised_value: "OS" >+ lib: "On-site checkout" >+ lib_opac: "On-site checkout" >+ > - authorised_values: > translatable: [ lib ] > multiline: [] >diff --git a/installer/data/mysql/es-ES/mandatory/auth_values.sql b/installer/data/mysql/es-ES/mandatory/auth_values.sql >index 26328ef6c1..46b26595dd 100644 >--- a/installer/data/mysql/es-ES/mandatory/auth_values.sql >+++ b/installer/data/mysql/es-ES/mandatory/auth_values.sql >@@ -1,3 +1,5 @@ > INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No'); > INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); >diff --git a/installer/data/mysql/fr-CA/obligatoire/auth_values.sql b/installer/data/mysql/fr-CA/obligatoire/auth_values.sql >index c92494921f..cc861d8503 100644 >--- a/installer/data/mysql/fr-CA/obligatoire/auth_values.sql >+++ b/installer/data/mysql/fr-CA/obligatoire/auth_values.sql >@@ -1,3 +1,5 @@ > INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','Non','Non'); > INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Oui','Oui'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Chaque Semaine'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); >diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql >index 46539144e6..17f757e874 100644 >--- a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql >+++ b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql >@@ -724,3 +724,7 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_F > -- return claims > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); >+ >+-- Checkout types >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); >diff --git a/installer/data/mysql/it-IT/necessari/auth_val.sql b/installer/data/mysql/it-IT/necessari/auth_val.sql >index 9fff795732..4fa1bdc799 100644 >--- a/installer/data/mysql/it-IT/necessari/auth_val.sql >+++ b/installer/data/mysql/it-IT/necessari/auth_val.sql >@@ -119,3 +119,7 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_F > -- return claims > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); >+ >+-- Checkout types >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); >diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/auth_values.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/auth_values.sql >index dbcc74f674..2ac677d890 100644 >--- a/installer/data/mysql/nb-NO/1-Obligatorisk/auth_values.sql >+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/auth_values.sql >@@ -1 +1,3 @@ > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); >diff --git a/installer/data/mysql/pl-PL/mandatory/auth_values.sql b/installer/data/mysql/pl-PL/mandatory/auth_values.sql >index dbcc74f674..2ac677d890 100644 >--- a/installer/data/mysql/pl-PL/mandatory/auth_values.sql >+++ b/installer/data/mysql/pl-PL/mandatory/auth_values.sql >@@ -1 +1,3 @@ > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); >diff --git a/installer/data/mysql/ru-RU/mandatory/auth_values.sql b/installer/data/mysql/ru-RU/mandatory/auth_values.sql >index dbcc74f674..2ac677d890 100644 >--- a/installer/data/mysql/ru-RU/mandatory/auth_values.sql >+++ b/installer/data/mysql/ru-RU/mandatory/auth_values.sql >@@ -1 +1,3 @@ > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); >diff --git a/installer/data/mysql/uk-UA/mandatory/auth_values.sql b/installer/data/mysql/uk-UA/mandatory/auth_values.sql >index c7b73d6bf0..dfed602ea8 100644 >--- a/installer/data/mysql/uk-UA/mandatory/auth_values.sql >+++ b/installer/data/mysql/uk-UA/mandatory/auth_values.sql >@@ -10,3 +10,9 @@ INSERT INTO `authorised_values` (category, authorised_value, lib, lib_opac) VALU > -- Housebound > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES > ('HSBND_FREQ','EW','Ðожного ÑижнÑ'); >+ >+-- Checkout types >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) >+ VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) >+ VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); >-- >2.17.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 25103
:
102667
|
102668
|
102669
|
102670
|
102671
|
102672
|
102673
|
102674