View | Details | Raw Unified | Return to bug 38087
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_38087.pl (-1 / +1 lines)
Lines 11-17 return { Link Here
11
        $dbh->do(
11
        $dbh->do(
12
            q{
12
            q{
13
            INSERT IGNORE INTO letter (module, code, branchcode, name, is_html, title, message_transport_type, lang, content)
13
            INSERT IGNORE INTO letter (module, code, branchcode, name, is_html, title, message_transport_type, lang, content)
14
            VALUES ('members', 'WELCOME', '', 'Welcome notice', 1, '[% USE Koha %][% IF Koha.Preference("LibraryName") %]Welcome to [% Koha.Preference("LibraryName") %][% ELSE %]Welcome to the library[% END %]', 'print', 'default', '[% USE Koha %]\r\n<div class=\"container mt-5\">\r\n<div class=\"row\">\r\n  <div class=\"col-6\">\r\n    <p>\r\n      <strong>[% borrower.firstname %] [% borrower.surname %]</strong><br>\r\n      [% borrower.address %]<br>\r\n      [% borrower.city %] [% borrower.zipcode %]<br>\r\n      [% borrower.country %]<br>\r\n    </p>\r\n  </div>\r\n  <div class=\"col-6 text-end\">\r\n    <p>\r\n      <strong>[% branch.branchname %]</strong><br>\r\n      [% branch.branchaddress1 %]<br>\r\n      [% branch.branchaddress2 %]<br>\r\n    </p>\r\n  </div>\r\n  <div class=\"row mb-4\">\r\n    <div class=\"col-12\">\r\n      <p class=\"text-end\">\r\n      <strong>[% today %]</strong>\r\n      </p>\r\n  </div>\r\n  <div class=\"row mb-4\">\r\n    <div class=\"col-12\">\r\n      <p>Hello [% borrower.title %] [% borrower.firstname %] [% borrower.surname %]</p>\r\n    </div>\r\n  </div>\r\n  <div class=\"row mb-4\">\r\n    <div class=\"col-12\">\r\n      <p>\r\n        Thank you for joining [% IF Koha.Preference("LibraryName") %][% Koha.Preference("LibraryName") %][% ELSE %]the library[% END %]<br>\r\n      </p>\r\n      <p>\r\n        You can search for all our materials in our <a href="[% Koha.Preference("OPACBaseURL") %]">catalog</a>.<br>\r\n      </p>\r\n      <p>\r\n        Your library card number is [% borrower.cardnumber %]<br>\r\n      </p>\r\n      <p>\r\n        If you have any problems or questions regarding your account, please contact the library.<br>\r\n      </p>\r\n    </div>\r\n  </div>\r\n</div>')
14
            VALUES ('members', 'WELCOME', '', 'Welcome notice', 1, '[% USE Koha %][% IF Koha.Preference("LibraryName") %]Welcome to [% Koha.Preference("LibraryName") %][% ELSE %]Welcome to the library[% END %]', 'print', 'default', '[% USE Koha %]\r\n<div class=\"container mt-5\">\r\n<div class=\"row\">\r\n  <div class=\"col-6\">\r\n    <p>\r\n      <strong>[% borrower.firstname %] [% borrower.surname %]</strong><br>\r\n      [% borrower.address %]<br>\r\n      [% borrower.city %] [% borrower.zipcode %]<br>\r\n      [% borrower.country %]<br>\r\n    </p>\r\n  </div>\r\n  <div class=\"col-6 text-end\">\r\n    <p>\r\n      <strong>[% branch.branchname %]</strong><br>\r\n      [% branch.branchaddress1 %]<br>\r\n      [% branch.branchaddress2 %]<br>\r\n    </p>\r\n</div>\r\n  </div>\r\n  <div class=\"row mb-4\">\r\n    <div class=\"col-12\">\r\n      <p class=\"text-end\">\r\n      <strong>[% today %]</strong>\r\n      </p>\r\n  </div>\r\n  <div class=\"row mb-4\">\r\n    <div class=\"col-12\">\r\n      <p>Hello [% borrower.title %] [% borrower.firstname %] [% borrower.surname %]</p>\r\n    </div>\r\n  </div>\r\n  <div class=\"row mb-4\">\r\n    <div class=\"col-12\">\r\n      <p>\r\n        Thank you for joining [% IF Koha.Preference("LibraryName") %][% Koha.Preference("LibraryName") %][% ELSE %]the library[% END %]<br>\r\n      </p>\r\n      <p>\r\n        You can search for all our materials in our <a href="[% Koha.Preference("OPACBaseURL") %]">catalog</a>.<br>\r\n      </p>\r\n      <p>\r\n        Your library card number is [% borrower.cardnumber %]<br>\r\n      </p>\r\n      <p>\r\n        If you have any problems or questions regarding your account, please contact the library.<br>\r\n      </p>\r\n    </div>\r\n  </div>\r\n</div>')
15
            }
15
            }
16
        );
16
        );
17
17
(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (-17 / +17 lines)
Lines 1599-1619 tables: Link Here
1599
          content:
1599
          content:
1600
            - "[% USE Koha %]"
1600
            - "[% USE Koha %]"
1601
            - "<div class=\"container mt-5\">"
1601
            - "<div class=\"container mt-5\">"
1602
            - "<div class=\"row\">"
1602
            - "  <div class=\"row\">"
1603
            - "  <div class=\"col-6\">"
1603
            - "    <div class=\"col-6\">"
1604
            - "    <p>"
1604
            - "      <p>"
1605
            - "      <strong>[% borrower.firstname %] [% borrower.surname %]</strong><br>"
1605
            - "        <strong>[% borrower.firstname %] [% borrower.surname %]</strong><br>"
1606
            - "      [% borrower.address %]<br>"
1606
            - "        [% borrower.address %]<br>"
1607
            - "      [% borrower.city %] [% borrower.zipcode %]<br>"
1607
            - "        [% borrower.city %] [% borrower.zipcode %]<br>"
1608
            - "      [% borrower.country %]<br>"
1608
            - "        [% borrower.country %]<br>"
1609
            - "    </p>"
1609
            - "      </p>"
1610
            - "  </div>"
1610
            - "    </div>"
1611
            - "  <div class=\"col-6 text-end\">"
1611
            - "    <div class=\"col-6 text-end\">"
1612
            - "    <p>"
1612
            - "      <p>"
1613
            - "      <strong>[% branch.branchname %]</strong><br>"
1613
            - "        <strong>[% branch.branchname %]</strong><br>"
1614
            - "      [% branch.branchaddress1 %]<br>"
1614
            - "        [% branch.branchaddress1 %]<br>"
1615
            - "      [% branch.branchaddress2 %]<br>"
1615
            - "        [% branch.branchaddress2 %]<br>"
1616
            - "    </p>"
1616
            - "      </p>"
1617
            - "    </div>"
1617
            - "  </div>"
1618
            - "  </div>"
1618
            - "  <div class=\"row mb-4\">"
1619
            - "  <div class=\"row mb-4\">"
1619
            - "    <div class=\"col-12\">"
1620
            - "    <div class=\"col-12\">"
Lines 2711-2714 tables: Link Here
2711
            - "[% deleted %] records deleted"
2712
            - "[% deleted %] records deleted"
2712
            - "[% skipped %] records skipped"
2713
            - "[% skipped %] records skipped"
2713
            - "[% in_error %] records in error"
2714
            - "[% in_error %] records in error"
2714
            - "[% total %] total"
2715
            - "[% total %] total"
2715
- 

Return to bug 38087