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