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

(-)a/about.pl (+5 lines)
Lines 267-272 if ( C4::Context->preference('WebBasedSelfCheck') Link Here
267
        q|select b.biblionumber from biblio b join deletedbiblio db on b.biblionumber=db.biblionumber|,
267
        q|select b.biblionumber from biblio b join deletedbiblio db on b.biblionumber=db.biblionumber|,
268
        { Slice => {} }
268
        { Slice => {} }
269
    );
269
    );
270
    my $items = $dbh->selectall_arrayref(
271
        q|select i.itemnumber from items b join deleteditems di on i.itemnumber=di.itemnumber|,
272
        { Slice => {} }
273
    );
270
    my $checkouts = $dbh->selectall_arrayref(
274
    my $checkouts = $dbh->selectall_arrayref(
271
        q|select i.issue_id from issues i join old_issues oi on i.issue_id=oi.issue_id|,
275
        q|select i.issue_id from issues i join old_issues oi on i.issue_id=oi.issue_id|,
272
        { Slice => {} }
276
        { Slice => {} }
Lines 280-285 if ( C4::Context->preference('WebBasedSelfCheck') Link Here
280
            has_ai_issues => 1,
284
            has_ai_issues => 1,
281
            ai_patrons    => $patrons,
285
            ai_patrons    => $patrons,
282
            ai_biblios    => $biblios,
286
            ai_biblios    => $biblios,
287
            ai_items      => $items,
283
            ai_checkouts  => $checkouts,
288
            ai_checkouts  => $checkouts,
284
            ai_holds      => $holds,
289
            ai_holds      => $holds,
285
        );
290
        );
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/about.tt (-1 / +5 lines)
Lines 131-136 Link Here
131
                The following ids exist in both the biblio and deletedbiblio table:
131
                The following ids exist in both the biblio and deletedbiblio table:
132
                [% FOR b IN ai_biblios %][% b.biblionumber %][% UNLESS loop.last %], [% END %][% END %]
132
                [% FOR b IN ai_biblios %][% b.biblionumber %][% UNLESS loop.last %], [% END %][% END %]
133
            [% END %]
133
            [% END %]
134
            [% IF ai_items %]
135
                <h3>Items</h3>
136
                The following ids exist in both the items and deleteditems table:
137
                [% FOR i IN ai_items %][% i.itemnumber %][% UNLESS loop.last %], [% END %][% END %]
138
            [% END %]
134
            [% IF ai_checkouts %]
139
            [% IF ai_checkouts %]
135
                <h3>Checkouts</h3>
140
                <h3>Checkouts</h3>
136
                The following ids exist in both the issues and old_issues table:
141
                The following ids exist in both the issues and old_issues table:
137
- 

Return to bug 18931