|
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 |
} |