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

(-)a/installer/data/mysql/atomicupdate/bug-18532.perl (-8 / +8 lines)
Lines 1-19 Link Here
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
(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (+25 lines)
Lines 1442-1444 tables: Link Here
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 %]"
(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (+18 lines)
Lines 302-304 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here
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');
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (+18 lines)
Lines 413-415 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here
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');
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (+18 lines)
Lines 431-433 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here
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');
(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (-5 / +5 lines)
Lines 411-430 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here
411
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');
411
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');
412
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');
412
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');
413
413
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 renewals', '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 %]
429
[% END %]
429
[% END %]
430
", 'email');
430
", 'email');
(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql (+18 lines)
Lines 412-414 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here
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');
(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (+18 lines)
Lines 503-505 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here
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');
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref (-3 / +2 lines)
Lines 186-197 Patrons: Link Here
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
195
196
    Patron forms:
196
    Patron forms:
197
     -
197
     -
198
- 

Return to bug 18532