Attachment 65256 Details for Bug 18931 – Bug 18931: Add items/deleteditems tables

[patch] Bug 18931: Add items/deleteditems tables

Bug-18931-Add-itemsdeleteditems-tables.patch (text/plain), 2.32 KB, created by Tomás Cohen Arazi (tcohen) on 2017-07-25 17:40:58 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tomás Cohen Arazi (tcohen)

Created: 2017-07-25 17:40:58 UTC

Size: 2.32 KB

patch

obsolete

>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

Actions: View | Diff | Splinter Review

Attachments on bug 18931: 65010 | 65157 | 65188 | 65189 | 65209 | 65210 | 65211 | 65212 | 65255 | 65256 | 65257 | 65258 | 65259 | 65260 | 65266 | 65267 | 65299