From f1a2e51c34ad708c3859f1f3b7f375b8bd14a949 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 24 Jul 2017 17:46:27 -0300 Subject: [PATCH] Bug 18931: Add items/deleteditems tables --- about.pl | 5 +++++ koha-tmpl/intranet-tmpl/prog/en/modules/about.tt | 5 +++++ 2 files changed, 10 insertions(+) diff --git a/about.pl b/about.pl index fed0092fc7..486768dfaa 100755 --- a/about.pl +++ b/about.pl @@ -296,6 +296,10 @@ if ( C4::Context->preference('WebBasedSelfCheck') q|select b.biblionumber from biblio b join deletedbiblio db on b.biblionumber=db.biblionumber|, { Slice => {} } ); + my $items = $dbh->selectall_arrayref( + q|select i.itemnumber from items b join deleteditems di on i.itemnumber=di.itemnumber|, + { Slice => {} } + ); my $checkouts = $dbh->selectall_arrayref( q|select i.issue_id from issues i join old_issues oi on i.issue_id=oi.issue_id|, { Slice => {} } @@ -309,6 +313,7 @@ if ( C4::Context->preference('WebBasedSelfCheck') has_ai_issues => 1, ai_patrons => $patrons, ai_biblios => $biblios, + ai_items => $items, ai_checkouts => $checkouts, ai_holds => $holds, ); diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/about.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/about.tt index 6d10c48f01..134a53f70c 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/about.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/about.tt @@ -157,6 +157,11 @@ The following ids exist in both the biblio and deletedbiblio table: [% FOR b IN ai_biblios %][% b.biblionumber %][% UNLESS loop.last %], [% END %][% END %] [% END %] + [% IF ai_items %] +

Items

+ The following ids exist in both the items and deleteditems table: + [% FOR i IN ai_items %][% i.itemnumber %][% UNLESS loop.last %], [% END %][% END %] + [% END %] [% IF ai_checkouts %]

Checkouts

The following ids exist in both the issues and old_issues table: -- 2.11.0