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

(-)a/installer/data/mysql/atomicupdate/bug_30290.pl (-1 / +1 lines)
Lines 8-14 return { Link Here
8
        my ($dbh, $out) = @$args{qw(dbh out)};
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        my $sql = q|
9
        my $sql = q|
10
UPDATE letter
10
UPDATE letter
11
SET content=REPLACE(content, '\nPages:', '\nTOC: [% IF article_request.toc_request %]Include TOC[% ELSE %]No[% END %]\nPages:')
11
SET content=REPLACE(content, '\nPages:', '\nTOC: [% IF article_request.toc_request %]Yes[% ELSE %]No[% END %]\nPages:')
12
WHERE code RLIKE '^AR_'  AND module='circulation' AND content NOT RLIKE '\nTOC:';
12
WHERE code RLIKE '^AR_'  AND module='circulation' AND content NOT RLIKE '\nTOC:';
13
        |;
13
        |;
14
        $dbh->do( $sql );
14
        $dbh->do( $sql );
(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (-7 / +6 lines)
Lines 240-246 tables: Link Here
240
            - "Volume: <<article_requests.volume>>"
240
            - "Volume: <<article_requests.volume>>"
241
            - "Issue: <<article_requests.issue>>"
241
            - "Issue: <<article_requests.issue>>"
242
            - "Date: <<article_requests.date>>"
242
            - "Date: <<article_requests.date>>"
243
            - "TOC: [% IF article_request.toc_request %]Include TOC[% ELSE %]No[% END %]"
243
            - "TOC: [% IF article_request.toc_request %]Yes[% ELSE %]No[% END %]"
244
            - "Pages: <<article_requests.pages>>"
244
            - "Pages: <<article_requests.pages>>"
245
            - "Chapters: <<article_requests.chapters>>"
245
            - "Chapters: <<article_requests.chapters>>"
246
            - "Notes: <<article_requests.patron_notes>>"
246
            - "Notes: <<article_requests.patron_notes>>"
Lines 267-273 tables: Link Here
267
            - "Volume: <<article_requests.volume>>"
267
            - "Volume: <<article_requests.volume>>"
268
            - "Issue: <<article_requests.issue>>"
268
            - "Issue: <<article_requests.issue>>"
269
            - "Date: <<article_requests.date>>"
269
            - "Date: <<article_requests.date>>"
270
            - "TOC: [% IF article_request.toc_request %]Include TOC[% ELSE %]No[% END %]"
270
            - "TOC: [% IF article_request.toc_request %]Yes[% ELSE %]No[% END %]"
271
            - "Pages: <<article_requests.pages>>"
271
            - "Pages: <<article_requests.pages>>"
272
            - "Chapters: <<article_requests.chapters>>"
272
            - "Chapters: <<article_requests.chapters>>"
273
            - "Notes: <<article_requests.patron_notes>>"
273
            - "Notes: <<article_requests.patron_notes>>"
Lines 296-302 tables: Link Here
296
            - "Volume: <<article_requests.volume>>"
296
            - "Volume: <<article_requests.volume>>"
297
            - "Issue: <<article_requests.issue>>"
297
            - "Issue: <<article_requests.issue>>"
298
            - "Date: <<article_requests.date>>"
298
            - "Date: <<article_requests.date>>"
299
            - "TOC: [% IF article_request.toc_request %]Include TOC[% ELSE %]No[% END %]"
299
            - "TOC: [% IF article_request.toc_request %]Yes[% ELSE %]No[% END %]"
300
            - "Pages: <<article_requests.pages>>"
300
            - "Pages: <<article_requests.pages>>"
301
            - "Chapters: <<article_requests.chapters>>"
301
            - "Chapters: <<article_requests.chapters>>"
302
            - "Notes: <<article_requests.patron_notes>>"
302
            - "Notes: <<article_requests.patron_notes>>"
Lines 323-329 tables: Link Here
323
            - "Volume: <<article_requests.volume>>"
323
            - "Volume: <<article_requests.volume>>"
324
            - "Issue: <<article_requests.issue>>"
324
            - "Issue: <<article_requests.issue>>"
325
            - "Date: <<article_requests.date>>"
325
            - "Date: <<article_requests.date>>"
326
            - "TOC: [% IF article_request.toc_request %]Include TOC[% ELSE %]No[% END %]"
326
            - "TOC: [% IF article_request.toc_request %]Yes[% ELSE %]No[% END %]"
327
            - "Pages: <<article_requests.pages>>"
327
            - "Pages: <<article_requests.pages>>"
328
            - "Chapters: <<article_requests.chapters>>"
328
            - "Chapters: <<article_requests.chapters>>"
329
            - "Notes: <<article_requests.patron_notes>>"
329
            - "Notes: <<article_requests.patron_notes>>"
Lines 350-356 tables: Link Here
350
            - "Volume: <<article_requests.volume>>"
350
            - "Volume: <<article_requests.volume>>"
351
            - "Issue: <<article_requests.issue>>"
351
            - "Issue: <<article_requests.issue>>"
352
            - "Date: <<article_requests.date>>"
352
            - "Date: <<article_requests.date>>"
353
            - "TOC: [% IF article_request.toc_request %]Include TOC[% ELSE %]No[% END %]"
353
            - "TOC: [% IF article_request.toc_request %]Yes[% ELSE %]No[% END %]"
354
            - "Pages: <<article_requests.pages>>"
354
            - "Pages: <<article_requests.pages>>"
355
            - "Chapters: <<article_requests.chapters>>"
355
            - "Chapters: <<article_requests.chapters>>"
356
            - "Notes: <<article_requests.patron_notes>>"
356
            - "Notes: <<article_requests.patron_notes>>"
Lines 380-386 tables: Link Here
380
            - "Volume: <<article_requests.volume>>"
380
            - "Volume: <<article_requests.volume>>"
381
            - "Issue: <<article_requests.issue>>"
381
            - "Issue: <<article_requests.issue>>"
382
            - "Date: <<article_requests.date>>"
382
            - "Date: <<article_requests.date>>"
383
            - "TOC: [% IF article_request.toc_request %]Include TOC[% ELSE %]No[% END %]"
383
            - "TOC: [% IF article_request.toc_request %]Yes[% ELSE %]No[% END %]"
384
            - "Pages: <<article_requests.pages>>"
384
            - "Pages: <<article_requests.pages>>"
385
            - "Chapters: <<article_requests.chapters>>"
385
            - "Chapters: <<article_requests.chapters>>"
386
            - "Notes: <<article_requests.patron_notes>>"
386
            - "Notes: <<article_requests.patron_notes>>"
387
- 

Return to bug 30290