Attachment #115802 for bug #18532

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




$DBversion = 'XXX'; # will be replaced by the RM
if( CheckVersion( $DBversion ) ) {
    # you can use $dbh here like:
    $dbh->do( q{
        INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
        "Dear [% borrower.firstname %] [% borrower.surname %],
        [% IF error %]
            There were [% error %] items that were not renewed.
        [% END %]
        [% IF success %]
            There were [% success %] items that where renewed.
        [% END %]
        [% FOREACH checkout IN checkouts %]
            [% checkout.item.biblio.title %] : [% checkout.item.barcode %]
            [% IF !checkout.auto_renew_error %]
                was renewed until [% checkout.date_due | $KohaDates as_due_date => 1%]
            [% ELSE %]
                was not renewed with error: [% checkout.auto_renew_error %]
            [% END %]

        ", 'email');
    });

    $dbh->do( q{
        INSERT IGNORE INTO `message_attributes`
            (`message_attribute_id`, message_name, `takes_days`)
        VALUES (7, 'Auto_Renewals', 0)
    });

    $dbh->do( q{
        INSERT IGNORE INTO `message_transports`
            (`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
        VALUES  (7, 'email', 0, 'circulation', 'AUTO_RENEWALS'),

                (7, 'sms', 1, 'circulation', 'AUTO_RENEWALS_DGST')
    });

    $dbh->do( q{
        insert into borrower_message_transport_preferences (borrower_message_preference_id, message_transport_type)
        select  p.borrower_message_preference_id, 'email'
        from    borrower_message_preferences p




            - "[% ELSE %]"
            - "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]"
            - "[% END %]"

        - module: circulation
          code: AUTO_RENEWALS_DGST
          branchcode: ""
          name: "Notification on auto renewals"
          is_html: 0
          title: "Auto renewals (Digest)"
          message_transport_type: email
          lang: default
          content:
            - "Dear [% borrower.firstname %] [% borrower.surname %],"
            - "[% IF error %]"
            - "There were [% error %] items that were not renewed."
            - "[% END %]"
            - "[% IF success %]"
            - "There were [% success %] items that where renewed."
            - "[% END %]"
            - "[% FOREACH checkout IN checkouts %]"
            - "[% checkout.item.biblio.title %] : [% checkout.item.barcode %]"
            - "[% IF !checkout.auto_renew_error %]"
            - "was renewed until [% checkout.date_due | $KohaDates as_due_date => 1%]"
            - "[% ELSE %]"
            - "was not renewed with error: [% checkout.auto_renew_error %]"
            - "[% END %]"
            - "[% END %]"




INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');

INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
"Dear [% borrower.firstname %] [% borrower.surname %],
[% IF error %]
    There were [% error %] items that were not renewed.
[% END %]
[% IF success %]
    There were [% success %] items that where renewed.
[% END %]
[% FOREACH checkout IN checkouts %]
    [% checkout.item.biblio.title %] : [% checkout.item.barcode %]
    [% IF !checkout.auto_renew_error %]
        was renewed until [% checkout.date_due | $KohaDates as_due_date => 1%]
    [% ELSE %]
        was not renewed with error: [% checkout.auto_renew_error %]
    [% END %]
[% END %]
", 'email');




INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');

INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
"Dear [% borrower.firstname %] [% borrower.surname %],
[% IF error %]
    There were [% error %] items that were not renewed.
[% END %]
[% IF success %]
    There were [% success %] items that where renewed.
[% END %]
[% FOREACH checkout IN checkouts %]
    [% checkout.item.biblio.title %] : [% checkout.item.barcode %]
    [% IF !checkout.auto_renew_error %]
        was renewed until [% checkout.date_due | $KohaDates as_due_date => 1%]
    [% ELSE %]
        was not renewed with error: [% checkout.auto_renew_error %]
    [% END %]
[% END %]
", 'email');




INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');

INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
"Dear [% borrower.firstname %] [% borrower.surname %],
[% IF error %]
    There were [% error %] items that were not renewed.
[% END %]
[% IF success %]
    There were [% success %] items that where renewed.
[% END %]
[% FOREACH checkout IN checkouts %]
    [% checkout.item.biblio.title %] : [% checkout.item.barcode %]
    [% IF !checkout.auto_renew_error %]
        was renewed until [% checkout.date_due | $KohaDates as_due_date => 1%]
    [% ELSE %]
        was not renewed with error: [% checkout.auto_renew_error %]
    [% END %]
[% END %]
", 'email');




INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewing', 'Auto renewals (Digest)',
"Dear [% borrower.firstname %] [% borrower.surname %],
[% IF error %]
    There were [% error %] items that were not renewed.
[% END %]
[% IF success %]
    There were [% success %] items that where renewed.
[% END %]
[% FOREACH checkout IN checkouts %]
    [% checkout.item.biblio.title %] : [% checkout.item.barcode %]
    [% IF !checkout.auto_renew_error %]
        was renewed until [% checkout.date_due | $KohaDates as_due_date => 1%]
    [% ELSE %]
        was not renewed with error: [% checkout.auto_renew_error %]
    [% END %]




INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');

INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
"Dear [% borrower.firstname %] [% borrower.surname %],
[% IF error %]
    There were [% error %] items that were not renewed.
[% END %]
[% IF success %]
    There were [% success %] items that where renewed.
[% END %]
[% FOREACH checkout IN checkouts %]
    [% checkout.item.biblio.title %] : [% checkout.item.barcode %]
    [% IF !checkout.auto_renew_error %]
        was renewed until [% checkout.date_due | $KohaDates as_due_date => 1%]
    [% ELSE %]
        was not renewed with error: [% checkout.auto_renew_error %]
    [% END %]
[% END %]
", 'email');




INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');

INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
"Dear [% borrower.firstname %] [% borrower.surname %],
[% IF error %]
    There were [% error %] items that were not renewed.
[% END %]
[% IF success %]
    There were [% success %] items that where renewed.
[% END %]
[% FOREACH checkout IN checkouts %]
    [% checkout.item.biblio.title %] : [% checkout.item.barcode %]
    [% IF !checkout.auto_renew_error %]
        was renewed until [% checkout.date_due | $KohaDates as_due_date => 1%]
    [% ELSE %]
        was not renewed with error: [% checkout.auto_renew_error %]
    [% END %]
[% END %]
", 'email');




               no: Disable
         - sending purchase suggestion messages by SMS if no patron email is defined.
     -
         - "Send automatic renewal notices: "
         - pref: AutoRenewalNotices
           choices:
               never: never
               preferences: according to patron messaging preferences
               cron: (Deprecated) according to --send-notices cron switch
    Patron forms:
     -
         - "The following <a href='http://schema.koha-community.org/__VERSION__/tables/borrowers.html' target='blank'>database columns</a> must be filled in on the patron entry screen:"
- 

Return to bug 18532

Lines 1442-1444 tables: Link Here

(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (+25 lines)
1442	- "[% ELSE %]"	1442	- "[% ELSE %]"
1443	- "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due \| $KohaDates as_due_date => 1 %]"	1443	- "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due \| $KohaDates as_due_date => 1 %]"
1444	- "[% END %]"	1444	- "[% END %]"
		1445
		1446	- module: circulation
		1447	code: AUTO_RENEWALS_DGST
		1448	branchcode: ""
		1449	name: "Notification on auto renewals"
		1450	is_html: 0
		1451	title: "Auto renewals (Digest)"
		1452	message_transport_type: email
		1453	lang: default
		1454	content:
		1455	- "Dear [% borrower.firstname %] [% borrower.surname %],"
		1456	- "[% IF error %]"
		1457	- "There were [% error %] items that were not renewed."
		1458	- "[% END %]"
		1459	- "[% IF success %]"
		1460	- "There were [% success %] items that where renewed."
		1461	- "[% END %]"
		1462	- "[% FOREACH checkout IN checkouts %]"
		1463	- "[% checkout.item.biblio.title %] : [% checkout.item.barcode %]"
		1464	- "[% IF !checkout.auto_renew_error %]"
		1465	- "was renewed until [% checkout.date_due \| $KohaDates as_due_date => 1%]"
		1466	- "[% ELSE %]"
		1467	- "was not renewed with error: [% checkout.auto_renew_error %]"
		1468	- "[% END %]"
		1469	- "[% END %]"

Lines 302-304 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here

(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (+18 lines)
302	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');	302	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
303	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');	303	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
304	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');	304	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');
		305
		306	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
		307	"Dear [% borrower.firstname %] [% borrower.surname %],
		308	[% IF error %]
		309	There were [% error %] items that were not renewed.
		310	[% END %]
		311	[% IF success %]
		312	There were [% success %] items that where renewed.
		313	[% END %]
		314	[% FOREACH checkout IN checkouts %]
		315	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]
		316	[% IF !checkout.auto_renew_error %]
		317	was renewed until [% checkout.date_due \| $KohaDates as_due_date => 1%]
		318	[% ELSE %]
		319	was not renewed with error: [% checkout.auto_renew_error %]
		320	[% END %]
		321	[% END %]
		322	", 'email');

Lines 413-415 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here

(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (+18 lines)
413	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');	413	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
414	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');	414	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
415	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');	415	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');
		416
		417	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
		418	"Dear [% borrower.firstname %] [% borrower.surname %],
		419	[% IF error %]
		420	There were [% error %] items that were not renewed.
		421	[% END %]
		422	[% IF success %]
		423	There were [% success %] items that where renewed.
		424	[% END %]
		425	[% FOREACH checkout IN checkouts %]
		426	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]
		427	[% IF !checkout.auto_renew_error %]
		428	was renewed until [% checkout.date_due \| $KohaDates as_due_date => 1%]
		429	[% ELSE %]
		430	was not renewed with error: [% checkout.auto_renew_error %]
		431	[% END %]
		432	[% END %]
		433	", 'email');

Lines 431-433 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here

(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (+18 lines)
431	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');	431	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
432	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');	432	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
433	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');	433	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');
		434
		435	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
		436	"Dear [% borrower.firstname %] [% borrower.surname %],
		437	[% IF error %]
		438	There were [% error %] items that were not renewed.
		439	[% END %]
		440	[% IF success %]
		441	There were [% success %] items that where renewed.
		442	[% END %]
		443	[% FOREACH checkout IN checkouts %]
		444	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]
		445	[% IF !checkout.auto_renew_error %]
		446	was renewed until [% checkout.date_due \| $KohaDates as_due_date => 1%]
		447	[% ELSE %]
		448	was not renewed with error: [% checkout.auto_renew_error %]
		449	[% END %]
		450	[% END %]
		451	", 'email');

Lines 414-428 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here

(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (-3 / +3 lines)
414	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewing', 'Auto renewals (Digest)',	414	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewing', 'Auto renewals (Digest)',
415	"Dear [% borrower.firstname %] [% borrower.surname %],	415	"Dear [% borrower.firstname %] [% borrower.surname %],
416	[% IF error %]	416	[% IF error %]
417	There were [% error %] items that were not correctly renewed.	417	There were [% error %] items that were not renewed.
418	[% END %]	418	[% END %]
419	[% IF success %]	419	[% IF success %]
420	There were [% success %] items that where correctly renewed.	420	There were [% success %] items that where renewed.
421	[% END %]	421	[% END %]
422	[% FOREACH checkout IN checkouts %]	422	[% FOREACH checkout IN checkouts %]
423	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]	423	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]
424	[% IF !checkout.auto_renew_error %]	424	[% IF !checkout.auto_renew_error %]
425	was renewed until [% checkout.date_due \| $KohaDates %]	425	was renewed until [% checkout.date_due \| $KohaDates as_due_date => 1%]
426	[% ELSE %]	426	[% ELSE %]
427	was not renewed with error: [% checkout.auto_renew_error %]	427	was not renewed with error: [% checkout.auto_renew_error %]
428	[% END %]	428	[% END %]

Lines 1-19 Link Here

(-)a/installer/data/mysql/atomicupdate/bug-18532.perl (-8 / +8 lines)
1	$DBversion = 'XXX'; # will be replaced by the RM	1	$DBversion = 'XXX'; # will be replaced by the RM
2	if( CheckVersion( $DBversion ) ) {	2	if( CheckVersion( $DBversion ) ) {
3	# you can use $dbh here like:	3	# you can use $dbh here like:
4	$dbh->do( qq{	4	$dbh->do( q{
5	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'notification on auto renewing', 'Auto renewals (Digest)',	5	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
6	"Dear [% borrower.firstname %] [% borrower.surname %],	6	"Dear [% borrower.firstname %] [% borrower.surname %],
7	[% IF error %]	7	[% IF error %]
8	There were [% error %] items that were not correctly renewed.	8	There were [% error %] items that were not renewed.
9	[% END %]	9	[% END %]
10	[% IF success %]	10	[% IF success %]
11	There were [% success %] items that where correctly renewed.	11	There were [% success %] items that where renewed.
12	[% END %]	12	[% END %]
13	[% FOREACH checkout IN checkouts %]	13	[% FOREACH checkout IN checkouts %]
14	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]	14	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]
15	[% IF !checkout.auto_renew_error %]	15	[% IF !checkout.auto_renew_error %]
16	was renewed until [% checkout.date_due %]	16	was renewed until [% checkout.date_due \| $KohaDates as_due_date => 1%]
17	[% ELSE %]	17	[% ELSE %]
18	was not renewed with error: [% checkout.auto_renew_error %]	18	was not renewed with error: [% checkout.auto_renew_error %]
19	[% END %]	19	[% END %]
Lines 21-33 if( CheckVersion( $DBversion ) ) { Link Here
21	", 'email');	21	", 'email');
22	});	22	});
23		23
24	$dbh->do( qq{	24	$dbh->do( q{
25	INSERT IGNORE INTO `message_attributes`	25	INSERT IGNORE INTO `message_attributes`
26	(`message_attribute_id`, message_name, `takes_days`)	26	(`message_attribute_id`, message_name, `takes_days`)
27	VALUES (7, 'Auto_Renewals', 0)	27	VALUES (7, 'Auto_Renewals', 0)
28	});	28	});
29		29
30	$dbh->do( qq{	30	$dbh->do( q{
31	INSERT IGNORE INTO `message_transports`	31	INSERT IGNORE INTO `message_transports`
32	(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)	32	(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
33	VALUES (7, 'email', 0, 'circulation', 'AUTO_RENEWALS'),	33	VALUES (7, 'email', 0, 'circulation', 'AUTO_RENEWALS'),
Lines 36-42 if( CheckVersion( $DBversion ) ) { Link Here
36	(7, 'sms', 1, 'circulation', 'AUTO_RENEWALS_DGST')	36	(7, 'sms', 1, 'circulation', 'AUTO_RENEWALS_DGST')
37	});	37	});
38		38
39	$dbh->do( qq{	39	$dbh->do( q{
40	insert into borrower_message_transport_preferences (borrower_message_preference_id, message_transport_type)	40	insert into borrower_message_transport_preferences (borrower_message_preference_id, message_transport_type)
41	select p.borrower_message_preference_id, 'email'	41	select p.borrower_message_preference_id, 'email'
42	from borrower_message_preferences p	42	from borrower_message_preferences p

Lines 412-414 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here

(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql (+18 lines)
412	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');	412	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
413	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');	413	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
414	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');	414	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');
		415
		416	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
		417	"Dear [% borrower.firstname %] [% borrower.surname %],
		418	[% IF error %]
		419	There were [% error %] items that were not renewed.
		420	[% END %]
		421	[% IF success %]
		422	There were [% success %] items that where renewed.
		423	[% END %]
		424	[% FOREACH checkout IN checkouts %]
		425	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]
		426	[% IF !checkout.auto_renew_error %]
		427	was renewed until [% checkout.date_due \| $KohaDates as_due_date => 1%]
		428	[% ELSE %]
		429	was not renewed with error: [% checkout.auto_renew_error %]
		430	[% END %]
		431	[% END %]
		432	", 'email');

Lines 503-505 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here

(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (+18 lines)
503	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');	503	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_CANCEL', '', 'ILL request cancelled', 0, "Interlibrary loan request cancelled", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has requested cancellation of this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
504	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');	504	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_MODIFIED', '', 'ILL request modified', 0, "Interlibrary loan request modified", "The patron for interlibrary loans request [% illrequest.illrequest_id %], with the following details, has modified this ILL request:\n\n[% ill_full_metadata %]", 'sms', 'default');
505	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');	505	INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_PARTNER_REQ', '', 'ILL request to partners', 0, "Interlibrary loan request to partners", "Dear Sir/Madam,\n\nWe would like to request an interlibrary loan for a title matching the following description:\n\n[% ill_full_metadata %]\n\nPlease let us know if you are able to supply this to us.\n\nKind Regards\n\n[% branch.branchname %]\n[% branch.branchaddress1 %]\n[% branch.branchaddress2 %]\n[% branch.branchaddress3 %]\n[% branch.branchcity %]\n[% branch.branchstate %]\n[% branch.branchzip %]\n[% branch.branchphone %]\n[% branch.branchillemail %]\n[% branch.branchemail %]", 'sms', 'default');
		506
		507	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
		508	"Dear [% borrower.firstname %] [% borrower.surname %],
		509	[% IF error %]
		510	There were [% error %] items that were not renewed.
		511	[% END %]
		512	[% IF success %]
		513	There were [% success %] items that where renewed.
		514	[% END %]
		515	[% FOREACH checkout IN checkouts %]
		516	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]
		517	[% IF !checkout.auto_renew_error %]
		518	was renewed until [% checkout.date_due \| $KohaDates as_due_date => 1%]
		519	[% ELSE %]
		520	was not renewed with error: [% checkout.auto_renew_error %]
		521	[% END %]
		522	[% END %]
		523	", 'email');

Lines 186-197 Patrons: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref (-3 / +2 lines)
186	no: Disable	186	no: Disable
187	- sending purchase suggestion messages by SMS if no patron email is defined.	187	- sending purchase suggestion messages by SMS if no patron email is defined.
188	-	188	-
189	- "Send automatic renewal notices "	189	- "Send automatic renewal notices: "
190	- pref: AutoRenewalNotices	190	- pref: AutoRenewalNotices
191	choices:	191	choices:
192	never: never	192	never: never
193	preferences: according to patron messaging preferences	193	preferences: according to patron messaging preferences
194	cron: (Deprecated) according to cron switch	194	cron: (Deprecated) according to --send-notices cron switch
195	Patron forms:	195	Patron forms:
196	-	196	-
197	- "The following <a href='http://schema.koha-community.org/__VERSION__/tables/borrowers.html' target='blank'>database columns</a> must be filled in on the patron entry screen:"	197	- "The following <a href='http://schema.koha-community.org/__VERSION__/tables/borrowers.html' target='blank'>database columns</a> must be filled in on the patron entry screen:"
198	-