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

(-)a/installer/data/mysql/atomicupdate/cancellation_reason.perl (+4 lines)
Lines 1-5 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if ( CheckVersion( $DBversion ) ) {
2
if ( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{
4
INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
5
    });
6
3
    if ( !column_exists( 'reserves', 'cancellation_reason' ) ) {
7
    if ( !column_exists( 'reserves', 'cancellation_reason' ) ) {
4
        $dbh->do(q{
8
        $dbh->do(q{
5
            ALTER TABLE reserves ADD COLUMN `cancellation_reason` varchar(80) default NULL AFTER cancellationdate;
9
            ALTER TABLE reserves ADD COLUMN `cancellation_reason` varchar(80) default NULL AFTER cancellationdate;
(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (-1 / +13 lines)
Lines 1208-1210 tables: Link Here
1208
            - "[% ELSE %]"
1208
            - "[% ELSE %]"
1209
            - "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]"
1209
            - "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]"
1210
            - "[% END %]"
1210
            - "[% END %]"
1211
- 
1211
1212
        - module: reserves
1213
          code: HOLD_CANCELLATION
1214
          branchcode: ""
1215
          name: "Notification of hold cancellation"
1216
          is_html: 0
1217
          title: "Your hold was canceled."
1218
          message_transport_type: email
1219
          lang: default
1220
          content:
1221
              - "[%- USE AuthorisedValues -%]"
1222
              - "Dear [% borrower.firstname %] [% borrower.surname %],"
1223
              - "Your hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( 'HOLD_CANCELLATION', hold.cancellation_reason ) %]"

Return to bug 25534