| 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>') |