From 84edd3900fa42b74f96402e19b19be28ba31584c 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 Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi Signed-off-by: Jonathan Druart (cherry picked from commit 193ecb0a2bb397bf67488f6342f02adda0328031) Signed-off-by: Fridolin Somers --- 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.39.5