From 86118efd40c42b4aa241cc2f0f36158184776c82 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>
---
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 4ed9c0e..f7f3ce3 100755
--- a/about.pl
+++ b/about.pl
@@ -267,6 +267,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 => {} }
@@ -280,6 +284,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 7412715..10f9124 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/about.tt
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/about.tt
@@ -131,6 +131,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.7.4