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

(-)a/installer/data/mysql/atomicupdate/bug_32967_-_fix_recalls_notices.pl (+20 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "32967",
5
    description => "Recalls notices are using the wrong database columns",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
10
        $dbh->do(q{ UPDATE letter SET content=REPLACE(content,'recalls.branchcode','recalls.pickup_library_id') WHERE code='PICKUP_RECALLED_ITEM' });
11
        $dbh->do(q{ UPDATE letter SET content=REPLACE(content,'recalls.expirationdate','recalls.expiration_date') WHERE code='PICKUP_RECALLED_ITEM' });
12
13
        say $out "Fix column names in PICKUP_RECALLED_ITEM notice";
14
15
        $dbh->do(q{ UPDATE letter SET content=REPLACE(content,'recalls.waitingdate','recalls.waiting_date') WHERE code='RECALL_REQUESTER_DET' });
16
        $dbh->do(q{ UPDATE letter SET content=REPLACE(content,'recalls.recallnotes','recalls.notes') WHERE code='RECALL_REQUESTER_DET' });
17
18
        say $out "Fix column names in RECALL_REQUESTER_DET notice";
19
    },
20
};
(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (-4 / +3 lines)
Lines 2031-2037 tables: Link Here
2031
            - ""
2031
            - ""
2032
            - "<<borrowers.firstname>> <<borrowers.surname>>,"
2032
            - "<<borrowers.firstname>> <<borrowers.surname>>,"
2033
            - ""
2033
            - ""
2034
            - "A recall that you requested on the following item: <<biblio.title>> / <<biblio.author>> (<<items.barcode>>) is now ready for you to pick up at <<recalls.branchcode>>. Please pick up your item by <<recalls.expirationdate>>."
2034
            - "A recall that you requested on the following item: <<biblio.title>> / <<biblio.author>> (<<items.barcode>>) is now ready for you to pick up at <<recalls.pickup_library_id>>. Please pick up your item by <<recalls.expiration_date>>."
2035
            - ""
2035
            - ""
2036
            - "Thank you!"
2036
            - "Thank you!"
2037
2037
Lines 2056-2063 tables: Link Here
2056
            - "<<biblio.title>> by <<biblio.author>>"
2056
            - "<<biblio.title>> by <<biblio.author>>"
2057
            - "Barcode: <<items.barcode>>"
2057
            - "Barcode: <<items.barcode>>"
2058
            - "Callnumber: <<items.itemcallnumber>>"
2058
            - "Callnumber: <<items.itemcallnumber>>"
2059
            - "Waiting since: <<recalls.waitingdate>>"
2059
            - "Waiting since: <<recalls.waiting_date>>"
2060
            - "Notes: <<recalls.recallnotes>>"
2060
            - "Notes: <<recalls.notes>>"
2061
2061
2062
        - module: members
2062
        - module: members
2063
          code: 2FA_DISABLE
2063
          code: 2FA_DISABLE
2064
- 

Return to bug 32967