From 3441b72eea451f1d0b51345956edd6ea4ff9aa8d Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 4 Jun 2021 11:56:18 +0200 Subject: [PATCH] Bug 27619: FA for UNIMARC and custom for fr-FR --- .../unimarc_sample_fastadd_framework.yml | 63 +++++++++++++++++++ .../data/mysql/localization/fr-FR/custom.sql | 26 ++++++++ 2 files changed, 89 insertions(+) create mode 100644 installer/data/mysql/en/marcflavour/unimarc/optional/unimarc_sample_fastadd_framework.yml create mode 100644 installer/data/mysql/localization/fr-FR/custom.sql diff --git a/installer/data/mysql/en/marcflavour/unimarc/optional/unimarc_sample_fastadd_framework.yml b/installer/data/mysql/en/marcflavour/unimarc/optional/unimarc_sample_fastadd_framework.yml new file mode 100644 index 00000000000..77ab841b771 --- /dev/null +++ b/installer/data/mysql/en/marcflavour/unimarc/optional/unimarc_sample_fastadd_framework.yml @@ -0,0 +1,63 @@ +--- +# +# Copyright 2020 Koha Development Team +# +# This file is part of Koha. +# +# Koha is free software; you can redistribute it and/or modify it +# under the terms of the GNU General Public License as published by +# the Free Software Foundation; either version 3 of the License, or +# (at your option) any later version. +# +# Koha is distributed in the hope that it will be useful, but +# WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with Koha; if not, see . + +# +# ************************************************************* +# FASTADD KOHA UNIMARC BIBLIOGRAPHIC FRAMEWORK +# ************************************************************* + +description: + - "'FA', a 'Fast Add' minimal UNIMARC framework suitable for ILL or on-the-fly cataloguing." + +tables: + - biblio_framework: + translatable: [ frameworktext ] + multiline: [] + rows: + - frameworkcode: FA + frameworktext: "Fast Add Framework" + +sql_statements: + - "INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) + SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'FA' + FROM marc_tag_structure + WHERE frameworkcode = '' AND + tagfield IN ('000', '001', '090', '100', '200', '205', '210', '225', '995');" + + - "INSERT IGNORE INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) + SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'FA', seealso, link, defaultvalue + FROM marc_subfield_structure + WHERE frameworkcode = '' AND + tagfield IN ('000', '001', '090', '100', '200', '205', '210', '225') + OR ( tagfield = '995' AND tagsubfield IN ('9', 'b', 'c', 'e', 'f', 'j', 'k') );" + + # REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES + - "UPDATE marc_subfield_structure SET tab = 0 WHERE tagfield IN ('000', '001', '090', '100', '200', '205', '210', '225') AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '090' AND tagsubfield = '9' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '090' AND tagsubfield = 'a' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '090' AND tagsubfield = 't' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'a' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '200' AND tagsubfield = 'a' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '200' AND tagsubfield = 'f' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '205' AND tagsubfield = 'a' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '210' AND tagsubfield = 'a' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '210' AND tagsubfield = 'c' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '210' AND tagsubfield = 'd' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '225' AND tagsubfield = 'a' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '995' frameworkcode = 'FA';" diff --git a/installer/data/mysql/localization/fr-FR/custom.sql b/installer/data/mysql/localization/fr-FR/custom.sql new file mode 100644 index 00000000000..b429980adc7 --- /dev/null +++ b/installer/data/mysql/localization/fr-FR/custom.sql @@ -0,0 +1,26 @@ +UPDATE systempreferences SET value = 'Père|Mère|grand-parent|Tuteur légal|Autre' WHERE variable = 'borrowerRelationship'; +UPDATE systempreferences SET value = 'M|Mme|Mlle' WHERE variable = 'BorrowersTitles'; +UPDATE systempreferences SET value = '676a' WHERE variable = 'itemcallnumber'; +UPDATE systempreferences SET value = 'fr-FR' WHERE variable = 'language'; +UPDATE systempreferences SET value = 'Ma bibliothèque' WHERE variable = 'LibraryName'; +UPDATE systempreferences SET value = 'fr-FR' WHERE variable = 'OPACLanguages'; +UPDATE systempreferences SET value = 1 WHERE variable = 'opaclanguagesdisplay'; +UPDATE systempreferences SET value = 'bibtex,dc,marcxml,marc8,utf8,marcstd,ris' WHERE variable = 'OpacExportOptions'; + +INSERT INTO `z3950servers` +(`host`, `port`, `db`, `userid`, `password`, `servername`, `id`, `checked`, `rank`, `syntax`, `servertype`, `encoding`) VALUES +('z3950.bnf.fr', 2211, 'TOUT-UTF8', 'Z3950', 'Z3950_BNF', 'BNF2', 2, 1, 2, 'UNIMARC', 'zed', 'utf8'); + +DELETE FROM `itemtypes`; +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('LIVR', ' Livre', 0.0000, 0, '', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('BD', 'BD', 0.0000, 0, '', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('LOC', 'Fonds Local', 0.0000, 0, '', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('PERI', 'Périodique', 0.0000, 0, '', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('USUE', 'Usuel', 0.0000, 1, '', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ARTI', 'Article', 0.0000, 1, '', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('CD', 'CD musique', 0.0000, 0, '', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('CDR', 'CD-ROM', 0.0000, 0, '', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('DVD', 'DVD', 0.0000, 0, '', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('WEB', 'Ressource Web', 0.0000, 1, '', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ADAP', 'Document Adapté', 0.0000, 0, '', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('VHS', 'VHS', 0.0000, 0, '', ''); -- 2.20.1