Bugzilla – Attachment 102673 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.16 KB, created by
Lari Taskula
on 2020-04-09 20:51:50 UTC
(
hide
)
Description:
Bug 25103: Add authorised values to sample data
Filename:
MIME Type:
Creator:
Lari Taskula
Created:
2020-04-09 20:51:50 UTC
Size:
9.16 KB
patch
obsolete
>From 5140548c3f8125c0474db6b96fb0290338bf0e52 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..b3c471a147 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', 'CHECKOUT', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'ONSITE', '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..974347a090 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: "CHECKOUT" >+ lib: "Normal checkout" >+ lib_opac: "Normal checkout" >+ >+ - category: "CHECKOUT_TYPE" >+ authorised_value: "ONSITE" >+ 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..0280b951ec 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', 'CHECKOUT', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'ONSITE', '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..8968f9f4b2 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', 'CHECKOUT', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'ONSITE', '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..6f631c494e 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', 'CHECKOUT', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'ONSITE', '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..cbc3a7fc16 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', 'CHECKOUT', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'ONSITE', '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..b4d214ec48 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', 'CHECKOUT', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'ONSITE', '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..b4d214ec48 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', 'CHECKOUT', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'ONSITE', '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..b4d214ec48 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', 'CHECKOUT', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'ONSITE', '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..fae2958e22 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', 'CHECKOUT', 'Normal checkout', 'Normal checkout'); >+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) >+ VALUES ('CHECKOUT_TYPE', 'ONSITE', '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