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

(-)a/installer/data/mysql/atomicupdate/bug_30484-add-ill-update-notice.pl (-2 / +2 lines)
Lines 6-13 return { Link Here
6
    up => sub {
6
    up => sub {
7
        my ($args) = @_;
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        $dbh->do(q{INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_UPDATE', '', 'ILL request update', 0, "Interlibrary loan request update", "Dear [% borrower.firstname %] [% borrower.surname %],\n\nThe Interlibrary loans request number [% illrequest.illrequest_id %] you placed for\n\n- [% ill_bib_title %] - [% ill_bib_author %]\n\nhas been updated\n\nDetails of the update are below:\n\n[% additional_text %]\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 %]", 'email', 'default');});
9
        $dbh->do(q{INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_UPDATE', '', 'ILL request update', 0, "Interlibrary loan request update", "Dear [% borrower.firstname %] [% borrower.surname %],\n\nThe Interlibrary loans request number [% illrequest.illrequest_id %] you placed for\n\n- [% ill_bib_title %] - [% ill_bib_author %]\n\nhas been updated\n\nDetails of the update are below:\n\n[% additional_text %]\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 %]", 'email', 'default');});
10
        $dbh->do(q{INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_UPDATE', '', 'ILL request update', 0, "Interlibrary loan request update", "Dear [% borrower.firstname %] [% borrower.surname %],\n\nThe Interlibrary loans request number [% illrequest.illrequest_id %] you placed for\n\n- [% ill_bib_title %] - [% ill_bib_author %]\n\nhas been updated\n\nDetails of the update are below:\n\n[% additional_text %]\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');});
10
        $dbh->do(q{INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('ill', 'ILL_REQUEST_UPDATE', '', 'ILL request update', 0, "Interlibrary loan request update", "Dear [% borrower.firstname %] [% borrower.surname %],\n\nThe Interlibrary loans request number [% illrequest.illrequest_id %] you placed for\n\n- [% ill_bib_title %] - [% ill_bib_author %]\n\nhas been updated\n\nDetails of the update are below:\n\n[% additional_text %]\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');});
11
        $dbh->do(q{INSERT IGNORE INTO message_attributes (message_name, takes_days) VALUES ('Ill_update', 0);});
11
        $dbh->do(q{INSERT IGNORE INTO message_attributes (message_name, takes_days) VALUES ('Ill_update', 0);});
12
        my $ready_id = $dbh->last_insert_id(undef, undef, 'message_attributes', undef);
12
        my $ready_id = $dbh->last_insert_id(undef, undef, 'message_attributes', undef);
13
        if (defined $ready_id) {
13
        if (defined $ready_id) {
(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (-9 / +8 lines)
Lines 739-745 tables: Link Here
739
            - ""
739
            - ""
740
            - "is ready for pick up from [% branch.branchname %]."
740
            - "is ready for pick up from [% branch.branchname %]."
741
            - ""
741
            - ""
742
            - "Kind Regards"
742
            - "Kind regards"
743
            - ""
743
            - ""
744
            - "[% branch.branchname %]"
744
            - "[% branch.branchname %]"
745
            - "[% branch.branchaddress1 %]"
745
            - "[% branch.branchaddress1 %]"
Lines 769-775 tables: Link Here
769
            - ""
769
            - ""
770
            - "is unfortunately unavailable."
770
            - "is unfortunately unavailable."
771
            - ""
771
            - ""
772
            - "Kind Regards"
772
            - "Kind regards"
773
            - ""
773
            - ""
774
            - "[% branch.branchname %]"
774
            - "[% branch.branchname %]"
775
            - "[% branch.branchaddress1 %]"
775
            - "[% branch.branchaddress1 %]"
Lines 825-831 tables: Link Here
825
            - ""
825
            - ""
826
            - "Please let us know if you are able to supply this to us."
826
            - "Please let us know if you are able to supply this to us."
827
            - ""
827
            - ""
828
            - "Kind Regards"
828
            - "Kind regards"
829
            - ""
829
            - ""
830
            - "[% branch.branchname %]"
830
            - "[% branch.branchname %]"
831
            - "[% branch.branchaddress1 %]"
831
            - "[% branch.branchaddress1 %]"
Lines 859-865 tables: Link Here
859
            - ""
859
            - ""
860
            - "[% additional_text %]"
860
            - "[% additional_text %]"
861
            - ""
861
            - ""
862
            - "Kind Regards"
862
            - "Kind regards"
863
            - ""
863
            - ""
864
            - "[% branch.branchname %]"
864
            - "[% branch.branchname %]"
865
            - "[% branch.branchaddress1 %]"
865
            - "[% branch.branchaddress1 %]"
Lines 889-895 tables: Link Here
889
            - ""
889
            - ""
890
            - "is ready for pick up from [% branch.branchname %]."
890
            - "is ready for pick up from [% branch.branchname %]."
891
            - ""
891
            - ""
892
            - "Kind Regards"
892
            - "Kind regards"
893
            - ""
893
            - ""
894
            - "[% branch.branchname %]"
894
            - "[% branch.branchname %]"
895
            - "[% branch.branchaddress1 %]"
895
            - "[% branch.branchaddress1 %]"
Lines 919-925 tables: Link Here
919
            - ""
919
            - ""
920
            - "is unfortunately unavailable."
920
            - "is unfortunately unavailable."
921
            - ""
921
            - ""
922
            - "Kind Regards"
922
            - "Kind regards"
923
            - ""
923
            - ""
924
            - "[% branch.branchname %]"
924
            - "[% branch.branchname %]"
925
            - "[% branch.branchaddress1 %]"
925
            - "[% branch.branchaddress1 %]"
Lines 975-981 tables: Link Here
975
            - ""
975
            - ""
976
            - "Please let us know if you are able to supply this to us."
976
            - "Please let us know if you are able to supply this to us."
977
            - ""
977
            - ""
978
            - "Kind Regards"
978
            - "Kind regards"
979
            - ""
979
            - ""
980
            - "[% branch.branchname %]"
980
            - "[% branch.branchname %]"
981
            - "[% branch.branchaddress1 %]"
981
            - "[% branch.branchaddress1 %]"
Lines 1009-1015 tables: Link Here
1009
            - ""
1009
            - ""
1010
            - "[% additional_text %]"
1010
            - "[% additional_text %]"
1011
            - ""
1011
            - ""
1012
            - "Kind Regards"
1012
            - "Kind regards"
1013
            - ""
1013
            - ""
1014
            - "[% branch.branchname %]"
1014
            - "[% branch.branchname %]"
1015
            - "[% branch.branchaddress1 %]"
1015
            - "[% branch.branchaddress1 %]"
1016
- 

Return to bug 30484