Attachment 43317 Details for Bug 12072 – Bug 12072 - Step 1: Add system preference for New dateformat dd.mm.yyyy

[patch] Bug 12072 - Step 1: Add system preference for New dateformat dd.mm.yyyy

Bug-12072---Step-1-Add-system-preference-for-New-d.patch (text/plain), 3.71 KB, created by Marc Véron on 2015-10-10 11:36:30 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marc Véron

Created: 2015-10-10 11:36:30 UTC

Size: 3.71 KB

patch

obsolete

>From bd9fdbf543930f6d4e60ba85ca6a6c13a7a76619 Mon Sep 17 00:00:00 2001
>From: =?UTF-8?q?Marc=20V=C3=A9ron?= <veron@veron.ch>
>Date: Sat, 7 Mar 2015 08:38:04 +0100
>Subject: [PATCH] Bug 12072 - Step 1: Add system preference for New dateformat
> dd.mm.yyyy
>
>As a first step, this patch adds a new system preference for the dateformat dd.mm.yyy
>No other changes are made.
>
>To test:
>1. apply the patch
>2. run updatedatabase.pl
>3. go to Admin > Sysprefs > I18N, change dateformat to dd.mm.yyyy, save
>4. verify that the value was saved
>
>Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
>New preference brakes a lot of things, hopefully will be fixed
>on 13813
>No koha-qa errors
>
>Amended to replace changes to updatedatabase.pl with atomic update. /mv
>---
> .../data/mysql/atomicupdate/bug_12072_update_syspref_dateformat.sql  |    2 ++
> installer/data/mysql/sysprefs.sql                                    |    2 +-
> .../intranet-tmpl/prog/en/modules/admin/preferences/i18n_l10n.pref   |    1 +
> 3 files changed, 4 insertions(+), 1 deletion(-)
> create mode 100644 installer/data/mysql/atomicupdate/bug_12072_update_syspref_dateformat.sql
>
>diff --git a/installer/data/mysql/atomicupdate/bug_12072_update_syspref_dateformat.sql b/installer/data/mysql/atomicupdate/bug_12072_update_syspref_dateformat.sql
>new file mode 100644
>index 0000000..486a674
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_12072_update_syspref_dateformat.sql
>@@ -0,0 +1,2 @@
>+UPDATE systempreferences SET options = 'metric|us|iso|dmydot', explanation = 'Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd, DMY separated by dots dd.mm.yyyy)' WHERE variable = 'dateformat'
>+
>diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql
>index 13639f0..e0ddc17 100644
>--- a/installer/data/mysql/sysprefs.sql
>+++ b/installer/data/mysql/sysprefs.sql
>@@ -95,7 +95,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
> ('ConfirmFutureHolds','0','','Number of days for confirming future holds','Integer'),
> ('CronjobLog','0',NULL,'If ON, log information from cron jobs.','YesNo'),
> ('CurrencyFormat','US','US|FR','Determines the display format of currencies. eg: \'36000\' is displayed as \'360 000,00\'  in \'FR\' or \'360,000.00\'  in \'US\'.','Choice'),
>-('dateformat','us','metric|us|iso','Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd)','Choice'),
>+('dateformat','us','metric|us|iso|dmydot','Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd, dmydot dd.mm.yyyy)','Choice'),
> ('DebugLevel','2','0|1|2','Define the level of debugging information sent to the browser when errors are encountered (set to 0 in production). 0=none, 1=some, 2=most','Choice'),
> ('decreaseLoanHighHolds',NULL,'','Decreases the loan period for items with number of holds above the threshold specified in decreaseLoanHighHoldsValue','YesNo'),
> ('decreaseLoanHighHoldsDuration',NULL,'','Specifies a number of days that a loan is reduced to when used in conjunction with decreaseLoanHighHolds','Integer'),
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/i18n_l10n.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/i18n_l10n.pref
>index 6bf9793..89e4436 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/i18n_l10n.pref
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/i18n_l10n.pref
>@@ -6,6 +6,7 @@ I18N/L10N:
>           choices:
>               us: mm/dd/yyyy
>               metric: dd/mm/yyyy
>+              dmydot: dd.mm.yyyy
>               iso: yyyy-mm-dd
>         - . <b>Note:</b> Do not change this preference on a production server with overdue items that are accruing fines. Doing so will result in duplicate fines!
>     -
>-- 
>1.7.10.4

Actions: View | Diff | Splinter Review

Attachments on bug 12072: 27068 | 27069 | 27082 | 27107 | 27108 | 27109 | 27118 | 27130 | 36726 | 36761 | 43317 | 43318 | 44463 | 44606 | 44747 | 44964 | 44966 | 44980 | 45020 | 45022