From 84edd3900fa42b74f96402e19b19be28ba31584c Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Mon, 24 Jul 2017 17:46:27 -0300
Subject: [PATCH] Bug 18931: Add items/deleteditems tables

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
(cherry picked from commit 193ecb0a2bb397bf67488f6342f02adda0328031)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
---
 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 %]
+                <h3>Items</h3>
+                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 %]
                 <h3>Checkouts</h3>
                 The following ids exist in both the issues and old_issues table:
-- 
2.39.5