Bugzilla – Attachment 73819 Details for
Bug 19289
Allow configuration of the fields on the 'Catalog details' form in the acquisition baskets
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 19289: Add existing fields to the ACQ framework
Bug-19289-Add-existing-fields-to-the-ACQ-framework.patch (text/plain), 6.18 KB, created by
Katrin Fischer
on 2018-04-07 09:08:38 UTC
(
hide
)
Description:
Bug 19289: Add existing fields to the ACQ framework
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2018-04-07 09:08:38 UTC
Size:
6.18 KB
patch
obsolete
>From 4fe2270dbb49d428e6be7ac91cd9ac76b65fb27e Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Thu, 26 Oct 2017 17:29:36 -0300 >Subject: [PATCH] Bug 19289: Add existing fields to the ACQ framework > >When ordering, the bibliographic details contain the title, author, >publisher code, publication year, isbn and series info. >To avoid regression to provide the same behaviour, we will add these >fields to the ACQ framework > >NOTE: This patch makes the change only for > - en > - fr / unimarc complet > >Other frameworks will be updated before to be pushed, to avoid >unecessary rebases > >Signed-off-by: Josef Moravec <josef.moravec@gmail.com> > >Signed-off-by: Nicolas Legrand <nicolas.legrand@bulac.fr> > >Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> >--- > .../marc21/mandatory/marc21_framework_DEFAULT.sql | 22 +++++++++++++++++++ > .../Obligatoire/framework_DEFAULT.sql | 25 ++++++++++++++++++++++ > 2 files changed, 47 insertions(+) > >diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >index 46bf421296..33997d1bc4 100644 >--- a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >+++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >@@ -4472,3 +4472,25 @@ SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, > > INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) > SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='952' AND frameworkcode=''; >+ >+INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) >+SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' >+FROM marc_tag_structure >+WHERE frameworkcode="" AND tagfield IN ( >+ SELECT tagfield >+ FROM marc_subfield_structure >+ WHERE ( >+ kohafield="biblio.title" >+ OR kohafield="biblio.author" >+ OR kohafield="biblioitems.publishercode" >+ OR kohafield="biblioitems.editionstatement" >+ OR kohafield="biblioitems.publicationyear" >+ OR kohafield="biblioitems.isbn" >+ OR kohafield="biblio.seriestitle" >+ ) AND frameworkcode="" >+); >+INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) >+SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength >+FROM marc_subfield_structure >+WHERE frameworkcode="" >+AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblioitems.publicationyear", "biblioitems.isbn", "biblio.seriestitle" ); >diff --git a/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql b/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql >index b50ba6027d..23f4b98506 100644 >--- a/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql >+++ b/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/framework_DEFAULT.sql >@@ -2144,3 +2144,28 @@ SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, > > INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) > SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='995' AND frameworkcode=''; >+ >+INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) >+SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='952' AND frameworkcode=''; >+ >+INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) >+SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' >+FROM marc_tag_structure >+WHERE frameworkcode="" AND tagfield IN ( >+ SELECT tagfield >+ FROM marc_subfield_structure >+ WHERE ( >+ kohafield="biblio.title" >+ OR kohafield="biblio.author" >+ OR kohafield="biblioitems.publishercode" >+ OR kohafield="biblioitems.editionstatement" >+ OR kohafield="biblioitems.publicationyear" >+ OR kohafield="biblioitems.isbn" >+ OR kohafield="biblio.seriestitle" >+ ) AND frameworkcode="" >+); >+INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) >+SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength >+FROM marc_subfield_structure >+WHERE frameworkcode="" >+AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblioitems.publicationyear", "biblioitems.isbn", "biblio.seriestitle" ); >-- >2.14.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 19289
:
68640
|
68641
|
68810
|
68811
|
69015
|
69016
|
69114
|
69115
|
70706
|
70765
|
72256
|
72257
|
72258
|
72259
|
73800
| 73819 |
73820
|
73821
|
73822
|
73823
|
73878
|
73948
|
73994