| Line 0
          
      
      
        Link Here | 
            
              |  |  | 1 | $DBversion = 'XXX';    # will be replaced by the RM | 
            
              | 2 | if ( CheckVersion($DBversion) ) { | 
            
              | 3 |  | 
            
              | 4 |     # you can use $dbh here like: | 
            
              | 5 |     $dbh->do( | 
            
              | 6 | "ALTER TABLE `article_requests` MODIFY `status` enum('REQUESTED', 'PENDING','PROCESSING','COMPLETED','CANCELED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'REQUESTED'" | 
            
              | 7 |     ); | 
            
              | 8 |  | 
            
              | 9 |     $dbh->do( | 
            
              | 10 |         q{ | 
            
              | 11 |         UPDATE  `letter` | 
            
              | 12 |         SET     `code` = 'AR_REQUESTED', | 
            
              | 13 |                 `name` = 'Article requested' | 
            
              | 14 |         WHERE   `module` = 'circulation' | 
            
              | 15 |                 AND `code` = 'AR_PENDING' | 
            
              | 16 |     } | 
            
              | 17 |     ); | 
            
              | 18 |  | 
            
              | 19 |     $dbh->do( | 
            
              | 20 |         q{ | 
            
              | 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') | 
            
              | 23 |     } | 
            
              | 24 |     ); | 
            
              | 25 |  | 
            
              | 26 |     # Always end with this (adjust the bug info) | 
            
              | 27 |     NewVersion( $DBversion, 27944, | 
            
              | 28 | "Add REQUESTED as enum element for status column, move AR_PENDING letter to AR_REQUESTED, and add new AR_PENDING letter" | 
            
              | 29 |     ); | 
            
              | 30 | } |