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

(-)a/installer/data/mysql/atomicupdate/bug_27944.perl (-2 / +2 lines)
Lines 10-16 if ( CheckVersion($DBversion) ) { Link Here
10
        q{
10
        q{
11
        UPDATE  `letter`
11
        UPDATE  `letter`
12
        SET     `code` = 'AR_REQUESTED',
12
        SET     `code` = 'AR_REQUESTED',
13
                `name` = 'Article requested'
13
                `name` = REPLACE(name, '- open', '- new')
14
        WHERE   `module` = 'circulation'
14
        WHERE   `module` = 'circulation'
15
                AND `code` = 'AR_PENDING'
15
                AND `code` = 'AR_PENDING'
16
    }
16
    }
Lines 19-25 if ( CheckVersion($DBversion) ) { Link Here
19
    $dbh->do(
19
    $dbh->do(
20
        q{
20
        q{
21
        INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
21
        INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
22
        ('circulation', 'AR_PENDING', '', 'Article request - open', 0, 'Pending article request', 'Dear <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>)\r\n\r\nYour request for an article from <<biblio.title>> (<<items.barcode>>) is now in pending state.\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\n\r\n\r\nThank you!', 'email')
22
        ('circulation', 'AR_PENDING', '', 'Article request - pending', 0, 'Pending article request', 'Dear <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>)\r\n\r\nYour request for an article from <<biblio.title>> (<<items.barcode>>) is now in pending state.\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\n\r\n\r\nThank you!', 'email')
23
    }
23
    }
24
    );
24
    );
25
25
(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (-3 / +2 lines)
Lines 278-284 tables: Link Here
278
        - module: circulation
278
        - module: circulation
279
          code: AR_PENDING
279
          code: AR_PENDING
280
          branchcode: ""
280
          branchcode: ""
281
          name: "Article request - open"
281
          name: "Article request - pending"
282
          is_html: 0
282
          is_html: 0
283
          title: "Pending article request"
283
          title: "Pending article request"
284
          message_transport_type: email
284
          message_transport_type: email
Lines 304-310 tables: Link Here
304
        - module: circulation
304
        - module: circulation
305
          code: AR_REQUESTED
305
          code: AR_REQUESTED
306
          branchcode: ""
306
          branchcode: ""
307
          name: "Article requested"
307
          name: "Article request - new"
308
          is_html: 0
308
          is_html: 0
309
          title: "Article request received"
309
          title: "Article request received"
310
          message_transport_type: email
310
          message_transport_type: email
311
- 

Return to bug 27944