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

(-)a/installer/data/mysql/atomicupdate/bug_31028.pl (-4 / +4 lines)
Lines 89-95 return { Link Here
89
        $dbh->do(
89
        $dbh->do(
90
            q{
90
            q{
91
                INSERT IGNORE INTO letter(module,code,branchcode,name,is_html,title,content,message_transport_type)
91
                INSERT IGNORE INTO letter(module,code,branchcode,name,is_html,title,content,message_transport_type)
92
                VALUES ( 'catalogue', 'TICKET_ACKNOWLEDGE', '', 'Concern acknowledgement', '1', 'Catalog concern acknowledgement', "Dear [% INCLUDE 'patron-title.inc' patron => ticket.reporter %],\r\n\r\nThankyou for your report concerning [% INCLUDE 'biblio-title.inc' biblio=ticket.biblio link = 0 %].\r\n\r\nYou reported: \r\n[% ticket.body %]\r\n\r\nThankyou", 'email' );
92
                VALUES ( 'catalogue', 'TICKET_ACKNOWLEDGE', '', 'Concern acknowledgement', '0', 'Catalog concern acknowledgement', "Dear [% INCLUDE 'patron-title.inc' patron => ticket.reporter %],\r\n\r\nThankyou for your report concerning [% INCLUDE 'biblio-title.inc' biblio=ticket.biblio link = 0 %].\r\n\r\nYou reported: \r\n[% ticket.body %]\r\n\r\nThankyou", 'email' );
93
            }
93
            }
94
        );
94
        );
95
        say $out "Added new notice 'TICKET_ACKNOWLEDGE'";
95
        say $out "Added new notice 'TICKET_ACKNOWLEDGE'";
Lines 97-103 return { Link Here
97
        $dbh->do(
97
        $dbh->do(
98
            q{
98
            q{
99
                INSERT IGNORE INTO letter(module,code,branchcode,name,is_html,title,content,message_transport_type)
99
                INSERT IGNORE INTO letter(module,code,branchcode,name,is_html,title,content,message_transport_type)
100
                VALUES ( 'catalogue', 'TICKET_UPDATE', '', 'Concern updated', '1', 'Catalog concern updated', "Dear [% INCLUDE 'patron-title.inc' patron => ticket_update.ticket.reporter %],\r\n\r\nThe library has added an update to the concern you reported against [% INCLUDE 'biblio-title.inc' biblio=ticket_update.ticket.biblio link = 0 %].\r\n\r\nThe following comment was left: \r\n[% ticket_update.message %]\r\n\r\nThankyou", 'email' );
100
                VALUES ( 'catalogue', 'TICKET_UPDATE', '', 'Concern updated', '0', 'Catalog concern updated', "Dear [% INCLUDE 'patron-title.inc' patron => ticket_update.ticket.reporter %],\r\n\r\nThe library has added an update to the concern you reported against [% INCLUDE 'biblio-title.inc' biblio=ticket_update.ticket.biblio link = 0 %].\r\n\r\nThe following comment was left: \r\n[% ticket_update.message %]\r\n\r\nThankyou", 'email' );
101
            }
101
            }
102
        );
102
        );
103
        say $out "Added new notice 'TICKET_UPDATE'";
103
        say $out "Added new notice 'TICKET_UPDATE'";
Lines 105-111 return { Link Here
105
        $dbh->do(
105
        $dbh->do(
106
            q{
106
            q{
107
                INSERT IGNORE INTO letter(module,code,branchcode,name,is_html,title,content,message_transport_type)
107
                INSERT IGNORE INTO letter(module,code,branchcode,name,is_html,title,content,message_transport_type)
108
                VALUES ( 'catalogue', 'TICKET_RESOLVE', '', 'Concern resolved', '1', 'Catalog concern resolved', "Dear [% INCLUDE 'patron-title.inc' patron => ticket_update.ticket.reporter %],\r\n\r\nThe library has now marked your concern with [% INCLUDE 'biblio-title.inc' biblio=ticket_update.ticket.biblio link = 0 %] as resolved.\r\n\r\nThe following comment was left:   \r\n[% ticket_update.message %]\r\n\r\nThankyou", 'email' );
108
                VALUES ( 'catalogue', 'TICKET_RESOLVE', '', 'Concern resolved', '0', 'Catalog concern resolved', "Dear [% INCLUDE 'patron-title.inc' patron => ticket_update.ticket.reporter %],\r\n\r\nThe library has now marked your concern with [% INCLUDE 'biblio-title.inc' biblio=ticket_update.ticket.biblio link = 0 %] as resolved.\r\n\r\nThe following comment was left:   \r\n[% ticket_update.message %]\r\n\r\nThankyou", 'email' );
109
            }
109
            }
110
        );
110
        );
111
        say $out "Added new notice 'TICKET_RESOLVE'";
111
        say $out "Added new notice 'TICKET_RESOLVE'";
Lines 121-127 return { Link Here
121
        $dbh->do(
121
        $dbh->do(
122
            q{
122
            q{
123
                INSERT IGNORE INTO letter(module,code,branchcode,name,is_html,title,content,message_transport_type)
123
                INSERT IGNORE INTO letter(module,code,branchcode,name,is_html,title,content,message_transport_type)
124
                VALUES ( 'catalogue', 'TICKET_NOTIFY', '', 'Catalog concern notification', '1', 'Catalog concern reported', "Dear cataloger,\r\n\r\n[% INCLUDE 'patron-title.inc' patron => ticket.reporter %] reported the following concern with [% INCLUDE 'biblio-title.inc' biblio=ticket.biblio link = 1 %]\r\n\r\n\r\n\r\n[% ticket.body %]\r\n\r\n\r\n\r\nYou can mark this concern as resolved from the concern management <a href='[% Koha.Preference('IntranetBaseURL') %]/cgi-bin/koha/cataloguing/concerns.pl'>page</a>.", 'email' );
124
                VALUES ( 'catalogue', 'TICKET_NOTIFY', '', 'Catalog concern notification', '0', 'Catalog concern reported', "Dear cataloger,\r\n\r\n[% INCLUDE 'patron-title.inc' patron => ticket.reporter %] reported the following concern with [% INCLUDE 'biblio-title.inc' biblio=ticket.biblio link = 1 %]\r\n\r\n\r\n\r\n[% ticket.body %]\r\n\r\n\r\n\r\nYou can mark this concern as resolved from the concern management <a href='[% Koha.Preference('IntranetBaseURL') %]/cgi-bin/koha/cataloguing/concerns.pl'>page</a>.", 'email' );
125
            }
125
            }
126
        );
126
        );
127
        say $out "Added new notice 'TICKET_NOTIFY'";
127
        say $out "Added new notice 'TICKET_NOTIFY'";
(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (-5 / +4 lines)
Lines 47-53 tables: Link Here
47
          code: TICKET_ACKNOWLEDGE
47
          code: TICKET_ACKNOWLEDGE
48
          branchcode: ""
48
          branchcode: ""
49
          name: "Concern acknowledgement"
49
          name: "Concern acknowledgement"
50
          is_html: 1
50
          is_html: 0
51
          title: "Catalog concern acknowledgment"
51
          title: "Catalog concern acknowledgment"
52
          message_transport_type: email
52
          message_transport_type: email
53
          lang: default
53
          lang: default
Lines 65-71 tables: Link Here
65
          code: TICKET_RESOLVE
65
          code: TICKET_RESOLVE
66
          branchcode: ""
66
          branchcode: ""
67
          name: "Concern resolved"
67
          name: "Concern resolved"
68
          is_html: 1
68
          is_html: 0
69
          title: "Catalog concern resolved"
69
          title: "Catalog concern resolved"
70
          message_transport_type: email
70
          message_transport_type: email
71
          lang: default
71
          lang: default
Lines 83-89 tables: Link Here
83
          code: TICKET_UPDATE
83
          code: TICKET_UPDATE
84
          branchcode: ""
84
          branchcode: ""
85
          name: "Concern updated"
85
          name: "Concern updated"
86
          is_html: 1
86
          is_html: 0
87
          title: "Catalog concern updated"
87
          title: "Catalog concern updated"
88
          message_transport_type: email
88
          message_transport_type: email
89
          lang: default
89
          lang: default
Lines 101-107 tables: Link Here
101
          code: TICKET_NOTIFY
101
          code: TICKET_NOTIFY
102
          branchcode: ""
102
          branchcode: ""
103
          name: "Concern notification"
103
          name: "Concern notification"
104
          is_html: 1
104
          is_html: 0
105
          title: "Catalog concern reported"
105
          title: "Catalog concern reported"
106
          message_transport_type: email
106
          message_transport_type: email
107
          lang: default
107
          lang: default
108
- 

Return to bug 31028