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

(-)a/installer/data/mysql/atomicupdate/bug_28153_add_holdreminder_notice_preference.perl (-16 lines)
Lines 1-16 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{
4
        INSERT IGNORE INTO `message_attributes`
5
            (`message_attribute_id`, message_name, `takes_days`)
6
        VALUES (10, 'Hold_Reminder', 0)
7
    });
8
    $dbh->do( q{
9
        INSERT IGNORE INTO `message_transports`
10
            (`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
11
        VALUES  (10, 'email', 0, 'circulation', 'HOLD_REMINDER'),
12
                (10, 'sms', 0, 'circulation', 'HOLD_REMINDER'),
13
                (10, 'phone', 0, 'circulation', 'HOLD_REMINDER')
14
    });
15
    NewVersion( $DBversion, 28153, "Add Hold reminder messaging preference");
16
}
(-)a/installer/data/mysql/atomicupdate/bug_28153_add_holdreminder_notice_preference.pl (+44 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "28153",
5
    description => "Add Hold Reminder messaging preference",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        $dbh->do(q{
10
            INSERT IGNORE INTO `message_attributes`
11
                (message_attribute_id, message_name, `takes_days`)
12
            VALUES (10, 'Hold_Reminder', 0)
13
        });
14
        say $out "Message attribute added";
15
        $dbh->do(q{
16
            INSERT IGNORE INTO `message_transports`
17
                (`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
18
            VALUES  (10, 'email', 0, 'circulation', 'HOLD_REMINDER'),
19
                    (10, 'sms', 0, 'circulation', 'HOLD_REMINDER'),
20
                    (10, 'phone', 0, 'circulation', 'HOLD_REMINDER'),
21
                    (10, 'itiva', 0, 'circulation', 'HOLD_REMINDER')
22
        });
23
        say $out "HOLD_REMINDER added to message_transports";
24
        $dbh->do(q{
25
                INSERT INTO borrower_message_preferences
26
                ( borrowernumber, categorycode, message_attribute_id, days_in_advance, wants_digest )
27
                SELECT borrowernumber, categorycode, 10, days_in_advance, wants_digest
28
                FROM borrower_message_preferences WHERE message_attribute_id = 4
29
        });
30
        say $out "Hold_Filled message preference copied to Hold_Reminder";
31
        $dbh->do(q{
32
                INSERT INTO borrower_message_transport_preferences
33
                ( borrower_message_preference_id, message_transport_type )
34
                SELECT b1.borrower_message_preference_id, message_transport_type
35
                FROM borrower_message_preferences b1
36
                JOIN borrower_message_preferences b2 ON
37
                  b1.message_attribute_id = 10 AND b2.message_attribute_id = 4 AND
38
                  b1.borrowernumber=b2.borrowernumber
39
                JOIN borrower_message_transport_preferences bt ON
40
                  b2.borrower_message_preference_id = bt.borrower_message_preference_id
41
        });
42
        say $out "Hold_Filled message transport preferences copied to Hold_Reminder";
43
    },
44
}
(-)a/installer/data/mysql/mandatory/sample_notices_message_attributes.sql (+1 lines)
Lines 9-12 values Link Here
9
(7, 'Ill_ready', 0),
9
(7, 'Ill_ready', 0),
10
(8, 'Ill_unavailable', 0),
10
(8, 'Ill_unavailable', 0),
11
(9, 'Auto_Renewals', 0);
11
(9, 'Auto_Renewals', 0);
12
(10, 'Hold_Reminder', 0);
12
13
(-)a/installer/data/mysql/mandatory/sample_notices_message_transports.sql (-1 / +4 lines)
Lines 35-37 values Link Here
35
(9, 'sms',   0, 'circulation', 'AUTO_RENEWALS'),
35
(9, 'sms',   0, 'circulation', 'AUTO_RENEWALS'),
36
(9, 'email', 1, 'circulation', 'AUTO_RENEWALS_DGST'),
36
(9, 'email', 1, 'circulation', 'AUTO_RENEWALS_DGST'),
37
(9, 'sms',   1, 'circulation', 'AUTO_RENEWALS_DGST');
37
(9, 'sms',   1, 'circulation', 'AUTO_RENEWALS_DGST');
38
- 
38
(10, 'email', 0, 'circulation', 'HOLD_REMINDER'),
39
(10, 'sms',   0, 'circulation', 'HOLD_REMINDER'),
40
(10, 'phone', 0, 'circulation', 'HOLD_REMINDER'),
41
(10, 'itiva', 0, 'circulation', 'HOLD_REMINDER'),

Return to bug 28153