From 82a353a6bf108b2f3d8b255d205fd2a229498982 Mon Sep 17 00:00:00 2001 From: Alex Buckley Date: Thu, 30 Mar 2023 21:56:15 +0000 Subject: [PATCH] Bug 33393: Add system preference Sponsored-by: Pymble Ladies' College --- .../bug_33393-add_1PageOrderPDFText.pl | 14 ++++++++++++++ installer/data/mysql/mandatory/sysprefs.sql | 1 + .../en/modules/admin/preferences/acquisitions.pref | 4 ++++ 3 files changed, 19 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_33393-add_1PageOrderPDFText.pl diff --git a/installer/data/mysql/atomicupdate/bug_33393-add_1PageOrderPDFText.pl b/installer/data/mysql/atomicupdate/bug_33393-add_1PageOrderPDFText.pl new file mode 100755 index 00000000000..3eef1d696df --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_33393-add_1PageOrderPDFText.pl @@ -0,0 +1,14 @@ +use Modern::Perl; + +return { + bug_number => "33393", + description => "Modify sentence above the order table in English 1-page order PDF", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + + $dbh->do(q{INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('1PageOrderPDFText', 'Order number must appear on all related correspondence, shipping papers and invoices. Notify us immediately if \n you are unable to supply item(s).', NULL, 'Text to be used above the order table in the 1-page order PDF file', 'textarea') }); + + say $out "Added system preference '1PageOrderPDFText'"; + }, +}; diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql index 98eced6bc0a..25bd78a10b6 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -1,4 +1,5 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES +('1PageOrderPDFText', 'Order number must appear on all related correspondence, shipping papers and invoices. Notify us immediately if \n you are unable to supply item(s).', NULL, 'Text to be used above the order table in the 1-page order PDF file', 'textarea'), ('AccessControlAllowOrigin', '', NULL, 'Set the Access-Control-Allow-Origin header to the specified value', 'Free'), ('AccountAutoReconcile','0',NULL,'If enabled, patron balances will get reconciled automatically on each transaction.','YesNo'), ('AcqCreateItem','ordering','ordering|receiving|cataloguing','Define when the item is created : when ordering, when receiving, or in cataloguing module','Choice'), diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/acquisitions.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/acquisitions.pref index 3f0560aac56..270d56ca91c 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/acquisitions.pref +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/acquisitions.pref @@ -125,6 +125,10 @@ Acquisitions: "pdfformat::layout3pagesfr": French 3-page "pdfformat::layout2pagesde": German 2-page - layout when printing basket groups. + - + - "Text to be used above the order table in the 1-page order PDF file. Note: Press enter to add line breaks to your sentence" + - pref: 1PageOrderPDFText + type: textarea EDIFACT: - - pref: EDIFACT -- 2.20.1