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

(-)a/installer/data/mysql/atomicupdate/bug_37967.pl (+22 lines)
Line 0 Link Here
1
use Modern::Perl;
2
use Koha::Installer::Output qw(say_warning say_failure say_success say_info);
3
4
return {
5
    bug_number  => "BUG_NUMBER",
6
    description => "A single line description",
7
    up          => sub {
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
11
        try {
12
            $dbh->do(q{
13
                INSERT IGNORE INTO message_transports (`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`) VALUES
14
                (9, 'phone', 1, 'circulation', 'AUTO_RENEWALS_DGST'),
15
                (9, 'phone',  0, 'circulation', 'AUTO_RENEWALS');
16
            });
17
            say_success( $out, "Added phone messaging transports for auto-renewals" );
18
        } catch {
19
            say_failure( $out, "Error adding phone messaging transports for auto-renewals: $_" );
20
        };
21
    },
22
};
(-)a/installer/data/mysql/mandatory/sample_notices_message_transports.sql (-1 / +2 lines)
Lines 36-43 values Link Here
36
(8, 'phone', 0, 'ill', 'ILL_REQUEST_UNAVAIL'),
36
(8, 'phone', 0, 'ill', 'ILL_REQUEST_UNAVAIL'),
37
(9, 'email', 0, 'circulation', 'AUTO_RENEWALS'),
37
(9, 'email', 0, 'circulation', 'AUTO_RENEWALS'),
38
(9, 'sms',   0, 'circulation', 'AUTO_RENEWALS'),
38
(9, 'sms',   0, 'circulation', 'AUTO_RENEWALS'),
39
(9, 'phone', 0, 'circulation', 'AUTO_RENEWALS'),
39
(9, 'email', 1, 'circulation', 'AUTO_RENEWALS_DGST'),
40
(9, 'email', 1, 'circulation', 'AUTO_RENEWALS_DGST'),
40
(9, 'sms',   1, 'circulation', 'AUTO_RENEWALS_DGST'),
41
(9, 'sms',   1, 'circulation', 'AUTO_RENEWALS_DGST'),
42
(9, 'phone', 1, 'circulation', 'AUTO_RENEWALS_DGST'),
41
(10, 'email', 0, 'circulation', 'HOLD_REMINDER'),
43
(10, 'email', 0, 'circulation', 'HOLD_REMINDER'),
42
(10, 'sms',   0, 'circulation', 'HOLD_REMINDER'),
44
(10, 'sms',   0, 'circulation', 'HOLD_REMINDER'),
43
(10, 'phone', 0, 'circulation', 'HOLD_REMINDER'),
45
(10, 'phone', 0, 'circulation', 'HOLD_REMINDER'),
44
- 

Return to bug 37967