Attachment #118198 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




            - "Barcode: [% item.barcode %] <br />"
            - "</p>"
            - "[% 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');




               0: 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 1478-1480 tables: Link Here

(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (+25 lines)
1478	- "Barcode: [% item.barcode %] <br />"	1478	- "Barcode: [% item.barcode %] <br />"
1479	- "</p>"	1479	- "</p>"
1480	- "[% END %]"	1480	- "[% END %]"
		1481
		1482	- module: circulation
		1483	code: AUTO_RENEWALS_DGST
		1484	branchcode: ""
		1485	name: "Notification on auto renewals"
		1486	is_html: 0
		1487	title: "Auto renewals (Digest)"
		1488	message_transport_type: email
		1489	lang: default
		1490	content:
		1491	- "Dear [% borrower.firstname %] [% borrower.surname %],"
		1492	- "[% IF error %]"
		1493	- "There were [% error %] items that were not renewed."
		1494	- "[% END %]"
		1495	- "[% IF success %]"
		1496	- "There were [% success %] items that where renewed."
		1497	- "[% END %]"
		1498	- "[% FOREACH checkout IN checkouts %]"
		1499	- "[% checkout.item.biblio.title %] : [% checkout.item.barcode %]"
		1500	- "[% IF !checkout.auto_renew_error %]"
		1501	- "was renewed until [% checkout.date_due \| $KohaDates as_due_date => 1%]"
		1502	- "[% ELSE %]"
		1503	- "was not renewed with error: [% checkout.auto_renew_error %]"
		1504	- "[% END %]"
		1505	- "[% END %]"

Lines 316-318 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)
316	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');	316	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');
317	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');	317	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');
318	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');	318	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');
		319
		320	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
		321	"Dear [% borrower.firstname %] [% borrower.surname %],
		322	[% IF error %]
		323	There were [% error %] items that were not renewed.
		324	[% END %]
		325	[% IF success %]
		326	There were [% success %] items that where renewed.
		327	[% END %]
		328	[% FOREACH checkout IN checkouts %]
		329	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]
		330	[% IF !checkout.auto_renew_error %]
		331	was renewed until [% checkout.date_due \| $KohaDates as_due_date => 1%]
		332	[% ELSE %]
		333	was not renewed with error: [% checkout.auto_renew_error %]
		334	[% END %]
		335	[% END %]
		336	", 'email');

Lines 429-431 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)
429	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');	429	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');
430	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');	430	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');
431	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');	431	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');
		432
		433	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
		434	"Dear [% borrower.firstname %] [% borrower.surname %],
		435	[% IF error %]
		436	There were [% error %] items that were not renewed.
		437	[% END %]
		438	[% IF success %]
		439	There were [% success %] items that where renewed.
		440	[% END %]
		441	[% FOREACH checkout IN checkouts %]
		442	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]
		443	[% IF !checkout.auto_renew_error %]
		444	was renewed until [% checkout.date_due \| $KohaDates as_due_date => 1%]
		445	[% ELSE %]
		446	was not renewed with error: [% checkout.auto_renew_error %]
		447	[% END %]
		448	[% END %]
		449	", 'email');

Lines 447-449 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)
447	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');	447	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');
448	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');	448	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');
449	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');	449	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');
		450
		451	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
		452	"Dear [% borrower.firstname %] [% borrower.surname %],
		453	[% IF error %]
		454	There were [% error %] items that were not renewed.
		455	[% END %]
		456	[% IF success %]
		457	There were [% success %] items that where renewed.
		458	[% END %]
		459	[% FOREACH checkout IN checkouts %]
		460	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]
		461	[% IF !checkout.auto_renew_error %]
		462	was renewed until [% checkout.date_due \| $KohaDates as_due_date => 1%]
		463	[% ELSE %]
		464	was not renewed with error: [% checkout.auto_renew_error %]
		465	[% END %]
		466	[% END %]
		467	", 'email');

Lines 430-444 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)
430	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewing', 'Auto renewals (Digest)',	430	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewing', 'Auto renewals (Digest)',
431	"Dear [% borrower.firstname %] [% borrower.surname %],	431	"Dear [% borrower.firstname %] [% borrower.surname %],
432	[% IF error %]	432	[% IF error %]
433	There were [% error %] items that were not correctly renewed.	433	There were [% error %] items that were not renewed.
434	[% END %]	434	[% END %]
435	[% IF success %]	435	[% IF success %]
436	There were [% success %] items that where correctly renewed.	436	There were [% success %] items that where renewed.
437	[% END %]	437	[% END %]
438	[% FOREACH checkout IN checkouts %]	438	[% FOREACH checkout IN checkouts %]
439	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]	439	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]
440	[% IF !checkout.auto_renew_error %]	440	[% IF !checkout.auto_renew_error %]
441	was renewed until [% checkout.date_due \| $KohaDates %]	441	was renewed until [% checkout.date_due \| $KohaDates as_due_date => 1%]
442	[% ELSE %]	442	[% ELSE %]
443	was not renewed with error: [% checkout.auto_renew_error %]	443	was not renewed with error: [% checkout.auto_renew_error %]
444	[% END %]	444	[% 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 428-430 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)
428	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');	428	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');
429	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');	429	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');
430	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');	430	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');
		431
		432	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
		433	"Dear [% borrower.firstname %] [% borrower.surname %],
		434	[% IF error %]
		435	There were [% error %] items that were not renewed.
		436	[% END %]
		437	[% IF success %]
		438	There were [% success %] items that where renewed.
		439	[% END %]
		440	[% FOREACH checkout IN checkouts %]
		441	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]
		442	[% IF !checkout.auto_renew_error %]
		443	was renewed until [% checkout.date_due \| $KohaDates as_due_date => 1%]
		444	[% ELSE %]
		445	was not renewed with error: [% checkout.auto_renew_error %]
		446	[% END %]
		447	[% END %]
		448	", 'email');

Lines 519-521 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)
519	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');	519	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');
520	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');	520	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');
521	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');	521	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');
		522
		523	INSERT IGNORE INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS_DGST', 'Notification on auto renewals', 'Auto renewals (Digest)',
		524	"Dear [% borrower.firstname %] [% borrower.surname %],
		525	[% IF error %]
		526	There were [% error %] items that were not renewed.
		527	[% END %]
		528	[% IF success %]
		529	There were [% success %] items that where renewed.
		530	[% END %]
		531	[% FOREACH checkout IN checkouts %]
		532	[% checkout.item.biblio.title %] : [% checkout.item.barcode %]
		533	[% IF !checkout.auto_renew_error %]
		534	was renewed until [% checkout.date_due \| $KohaDates as_due_date => 1%]
		535	[% ELSE %]
		536	was not renewed with error: [% checkout.auto_renew_error %]
		537	[% END %]
		538	[% END %]
		539	", 'email');

Lines 192-203 Patrons: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref (-3 / +2 lines)
192	0: Disable	192	0: Disable
193	- sending purchase suggestion messages by SMS if no patron email is defined.	193	- sending purchase suggestion messages by SMS if no patron email is defined.
194	-	194	-
195	- "Send automatic renewal notices "	195	- "Send automatic renewal notices: "
196	- pref: AutoRenewalNotices	196	- pref: AutoRenewalNotices
197	choices:	197	choices:
198	never: never	198	never: never
199	preferences: according to patron messaging preferences	199	preferences: according to patron messaging preferences
200	cron: (Deprecated) according to cron switch	200	cron: (Deprecated) according to --send-notices cron switch
201	Patron forms:	201	Patron forms:
202	-	202	-
203	- "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:"	203	- "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:"
204	-