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 1478-1480 tables: Link Here
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 %]"
(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (+18 lines)
Lines 316-318 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here
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');
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (+18 lines)
Lines 429-431 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here
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');
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (+18 lines)
Lines 447-449 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here
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');
(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (-3 / +3 lines)
Lines 430-444 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here
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 %]
(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql (+18 lines)
Lines 428-430 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here
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');
(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (+18 lines)
Lines 519-521 INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, conten Link Here
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');
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref (-3 / +2 lines)
Lines 192-203 Patrons: Link Here
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
- 

Return to bug 18532