Bugzilla – Attachment 35768 Details for
Bug 13380
Auto fill order cancellation reasons from authorised values
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 13380: Add ORDER_CANCELLATION_REASON AV to all language files
Bug-13380-Add-ORDERCANCELLATIONREASON-AV-to-all-la.patch (text/plain), 7.10 KB, created by
Jonathan Druart
on 2015-02-10 08:50:05 UTC
(
hide
)
Description:
Bug 13380: Add ORDER_CANCELLATION_REASON AV to all language files
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2015-02-10 08:50:05 UTC
Size:
7.10 KB
patch
obsolete
>From 8ed02ec7b31d0b8380d80fde70bbe9d08d832f4a Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@biblibre.com> >Date: Tue, 10 Feb 2015 09:47:18 +0100 >Subject: [PATCH] Bug 13380: Add ORDER_CANCELLATION_REASON AV to all language > files > >--- > installer/data/mysql/de-DE/optional/auth_val.sql | 5 +++++ > installer/data/mysql/es-ES/optional/auth_val.sql | 5 +++++ > installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql | 5 +++++ > installer/data/mysql/it-IT/necessari/auth_val.sql | 5 +++++ > installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql | 5 +++++ > installer/data/mysql/pl-PL/optional/auth_val.sql | 5 +++++ > 6 files changed, 30 insertions(+) > >diff --git a/installer/data/mysql/de-DE/optional/auth_val.sql b/installer/data/mysql/de-DE/optional/auth_val.sql >index 331363d..1ecd643 100644 >--- a/installer/data/mysql/de-DE/optional/auth_val.sql >+++ b/installer/data/mysql/de-DE/optional/auth_val.sql >@@ -70,3 +70,8 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '008', 'Buch mit Diskette'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Buch mit CD'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Buch mit Audio CD/Kassette'); >+ >+-- order cancellation reasons >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); >diff --git a/installer/data/mysql/es-ES/optional/auth_val.sql b/installer/data/mysql/es-ES/optional/auth_val.sql >index ed0fad4..71522ae 100644 >--- a/installer/data/mysql/es-ES/optional/auth_val.sql >+++ b/installer/data/mysql/es-ES/optional/auth_val.sql >@@ -63,3 +63,8 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '008', 'Book with diskette'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Book with CD'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Book with audio tape'); >+ >+-- order cancellation reasons >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); >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 c8eedfe..b4a0dd9 100644 >--- a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql >+++ b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql >@@ -704,3 +704,8 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED > -- Autres > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Pilon'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RESTRICTED','1','Exclu du prêt'); >+ >+-- order cancellation reasons >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); >diff --git a/installer/data/mysql/it-IT/necessari/auth_val.sql b/installer/data/mysql/it-IT/necessari/auth_val.sql >index 7866c9b..ce546fc 100644 >--- a/installer/data/mysql/it-IT/necessari/auth_val.sql >+++ b/installer/data/mysql/it-IT/necessari/auth_val.sql >@@ -99,4 +99,9 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Libro con CD'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Libro con audiocassette'); > >+-- order cancellation reasons >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); >+ > SET FOREIGN_KEY_CHECKS=1; >diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql >index 6b4acc3..1c34891 100644 >--- a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql >+++ b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql >@@ -91,3 +91,8 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '008', 'Book with diskette'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Book with CD'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Book with audio tape'); >+ >+-- order cancellation reasons >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); >diff --git a/installer/data/mysql/pl-PL/optional/auth_val.sql b/installer/data/mysql/pl-PL/optional/auth_val.sql >index 6e0b04c..6418ee7 100644 >--- a/installer/data/mysql/pl-PL/optional/auth_val.sql >+++ b/installer/data/mysql/pl-PL/optional/auth_val.sql >@@ -70,3 +70,8 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '008', 'Book with diskette'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Book with CD'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Book with audio tape'); >+ >+-- order cancellation reasons >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); >-- >2.1.0
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 13380
:
34090
|
34091
|
34140
|
34746
|
34747
|
35695
|
35696
|
35767
|
35768
|
35773
|
37144
|
37163
|
37179
|
37363