From 028869d3c1e832cd5e760e76a5a729d1d0586374 Mon Sep 17 00:00:00 2001
From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Date: Wed, 24 Nov 2021 16:29:06 +0000
Subject: [PATCH] Bug 29566: Add sample notices

---
 .../data/mysql/atomicupdate/bug_29566.pl      | 19 ++++++++++++++
 .../mysql/en/mandatory/sample_notices.yml     | 26 +++++++++++++++++++
 2 files changed, 45 insertions(+)
 create mode 100644 installer/data/mysql/atomicupdate/bug_29566.pl

diff --git a/installer/data/mysql/atomicupdate/bug_29566.pl b/installer/data/mysql/atomicupdate/bug_29566.pl
new file mode 100644
index 0000000000..f237bd5d22
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_29566.pl
@@ -0,0 +1,19 @@
+use Modern::Perl;
+
+return {
+    bug_number => "29566",
+    description => "Add BUNDLE slip template",
+    up => sub {
+        my ($args) = @_;
+        my ($dbh, $out) = @$args{qw(dbh out)};
+
+    my $bundle_notice = q{
+\r\n    };
+
+        $dbh->do(q{
+            INSERT IGNORE INTO letter
+        (module,code,branchcode,name,is_html,title,content,message_transport_type,lang)
+        VALUES ('circulation','BUNDLE','','Bundle contents', 1, 'Bundle contents for [% item.barcode %]', '<table style="100%">\r\n  <thead>\r\n    <tr>\r\n        <th>Barcode</th>\r\n        <th>Title</th>\r\n    </tr>\r\n  </thead>\r\n  <tbody>\r\n    [% FOREACH bundle_item IN item.bundle_items %]\r\n      <tr>\r\n        <td>[% bundle_item.barcode | html %]</td>\r\n        <td>[% INCLUDE "biblio-title.inc" biblio=bundle_item.biblio %]</td>\r\n      </tr>\r\n    [% END %]\r\n  </tbody>\r\n</table>','print','default')
+        });
+    },
+}
diff --git a/installer/data/mysql/en/mandatory/sample_notices.yml b/installer/data/mysql/en/mandatory/sample_notices.yml
index 4da53c29b5..591fd166b8 100644
--- a/installer/data/mysql/en/mandatory/sample_notices.yml
+++ b/installer/data/mysql/en/mandatory/sample_notices.yml
@@ -387,6 +387,32 @@ tables:
             - "Format: [% IF article_request.format == 'PHOTOCOPY' %]Copy[% ELSIF article_request.format == 'SCAN' %]Scan[% END %]"
             - ""
 
+        - module: circulation
+          code: BUNDLE
+          branchcode: ""
+          name: "Bundle contents - print slip"
+          is_html: 1
+          title: "Bundle content for [% item.barcode %]"
+          message_transport_type: print
+          lang: default
+          content:
+            - "<table style='100%'>"
+            - "  <thead>"
+            - "    <tr>"
+            - "        <th>Barcode</th>"
+            - "        <th>Title</th>"
+            - "    </tr>"
+            - "  </thead>"
+            - "  <tbody>"
+            - "    [% FOREACH bundle_item IN item.bundle_items %]"
+            - "      <tr>"
+            - "        <td>[% bundle_item.barcode | html %]</td>"
+            - "        <td>[% INCLUDE 'biblio-title.inc' biblio=bundle_item.biblio %]</td>"
+            - "      </tr>"
+            - "    [% END %]"
+            - "  </tbody>"
+            - "</table>"
+
         - module: circulation
           code: CHECKIN
           branchcode: ""
-- 
2.20.1