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

(-)a/installer/data/mysql/atomicupdate/bug-18532.perl (-20 / +20 lines)
Lines 8-21 if( CheckVersion( $DBversion ) ) { Link Here
8
            There were [% error %] items that were not 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 renewed.
11
            There were [% success %] items that were 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 | $KohaDates as_due_date => 1%]
16
                was renewed until [% checkout.date_due | $KohaDates as_due_date => 1%]
17
            [% ELSE %]
17
            [% ELSIF checkout.auto_renew_error == 'too_many' %]
18
                was not renewed with error: [% checkout.auto_renew_error %]
18
                You have reached the maximum number of checkouts possible.
19
            [% ELSIF checkout.auto_renew_error == 'on_reserve' %]
20
                This item is on hold for another patron.
21
            [% ELSIF checkout.auto_renew_error == 'restriction' %]
22
                You are currently restricted.
23
            [% ELSIF checkout.auto_renew_error == 'overdue' %]
24
                You have overdue items.
25
            [% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
26
                It's too late to renew this item.
27
            [% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
28
                Your total unpaid fines are too high.
29
            [% ELSIF checkout.auto_renew_error == 'too_unseen' %]
30
                This item must be renewed at the library.
19
            [% END %]
31
            [% END %]
20
        [% END %]
32
        [% END %]
21
        ", 'email');
33
        ", 'email');
Lines 24-50 if( CheckVersion( $DBversion ) ) { Link Here
24
    $dbh->do( q{
36
    $dbh->do( q{
25
        INSERT IGNORE INTO `message_attributes`
37
        INSERT IGNORE INTO `message_attributes`
26
            (`message_attribute_id`, message_name, `takes_days`)
38
            (`message_attribute_id`, message_name, `takes_days`)
27
        VALUES (7, 'Auto_Renewals', 0)
39
        VALUES (9, 'Auto_Renewals', 0)
28
    });
40
    });
29
41
30
    $dbh->do( q{
42
    $dbh->do( q{
31
        INSERT IGNORE INTO `message_transports`
43
        INSERT IGNORE INTO `message_transports`
32
            (`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
44
            (`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
33
        VALUES  (7, 'email', 0, 'circulation', 'AUTO_RENEWALS'),
45
        VALUES  (9, 'email', 0, 'circulation', 'AUTO_RENEWALS'),
34
                (7, 'sms', 0, 'circulation', 'AUTO_RENEWALS'),
46
                (9, 'sms', 0, 'circulation', 'AUTO_RENEWALS'),
35
                (7, 'email', 1, 'circulation', 'AUTO_RENEWALS_DGST'),
47
                (9, 'email', 1, 'circulation', 'AUTO_RENEWALS_DGST'),
36
                (7, 'sms', 1, 'circulation', 'AUTO_RENEWALS_DGST')
48
                (9, 'sms', 1, 'circulation', 'AUTO_RENEWALS_DGST')
37
    });
38
39
    $dbh->do( q{
40
        insert into borrower_message_transport_preferences (borrower_message_preference_id, message_transport_type)
41
        select  p.borrower_message_preference_id, 'email'
42
        from    borrower_message_preferences p
43
        left join
44
                borrower_message_transport_preferences t
45
        on      p.borrower_message_preference_id = t.borrower_message_preference_id
46
        where   p.message_attribute_id = 7
47
                and t.borrower_message_preference_id is null;
48
    });
49
    });
49
50
50
     $dbh->do(q{
51
     $dbh->do(q{
51
- 

Return to bug 18532