Attachment 69880 Details for Bug 19532 – Bug 19532: Overdue recalls report

[patch] Bug 19532: Overdue recalls report

Bug-19532-Overdue-recalls-report.patch (text/plain), 12.45 KB, created by Aleisha Amohia on 2017-12-19 01:44:46 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Aleisha Amohia

Created: 2017-12-19 01:44:46 UTC

Size: 12.45 KB

patch

obsolete

>From 40f31677e90043554ea070e24109d13f3f02c71e Mon Sep 17 00:00:00 2001
>From: Aleisha Amohia <aleishaamohia@hotmail.com>
>Date: Thu, 16 Nov 2017 00:40:14 +0000
>Subject: [PATCH] Bug 19532: Overdue recalls report
>
>---
> Koha/Recall.pm                                     |  23 +++-
> circ/recalls_overdue.pl                            |  59 +++++++++++
> circ/recalls_queue.pl                              |   2 -
> .../prog/en/includes/recalls-reports.inc           |   2 +-
> .../prog/en/modules/circ/recalls_overdue.tt        | 118 +++++++++++++++++++++
> .../prog/en/modules/circ/recalls_queue.tt          |   2 +-
> 6 files changed, 198 insertions(+), 8 deletions(-)
> create mode 100755 circ/recalls_overdue.pl
> create mode 100644 koha-tmpl/intranet-tmpl/prog/en/modules/circ/recalls_overdue.tt
>
>diff --git a/Koha/Recall.pm b/Koha/Recall.pm
>index 3df902d..6e2280b 100644
>--- a/Koha/Recall.pm
>+++ b/Koha/Recall.pm
>@@ -43,7 +43,7 @@ sub _type {
> 
> =head3 biblio
> 
>-Returns the related Koha::Biblio object for this hold
>+Returns the related Koha::Biblio object for this recall
> 
> =cut
> 
>@@ -57,7 +57,7 @@ sub biblio {
> 
> =head3 item
> 
>-Returns the related Koha::Item object for this Hold
>+Returns the related Koha::Item object for this recall
> 
> =cut
> 
>@@ -72,7 +72,7 @@ sub item {
> 
> =head3 borrower
> 
>-Returns the related Koha::Patron object for this Hold
>+Returns the related Koha::Patron object for this recall
> 
> =cut
> 
>@@ -84,9 +84,10 @@ sub borrower {
> 
>     return $self->{_borrower};
> }
>+
> =head3 branch
> 
>-Returns the related Koha::Library object for this Hold
>+Returns the related Koha::Library object for this recall
> 
> =cut
> 
>@@ -98,6 +99,20 @@ sub branch {
>     return $self->{_branch};
> }
> 
>+=head3 checkout
>+
>+Returns the related Koha::Checkout object for this recall
>+
>+=cut
>+
>+sub checkout {
>+    my ($self) = @_;
>+
>+    $self->{_checkout} ||= Koha::Checkouts->find({ itemnumber => $self->itemnumber() });
>+
>+    return $self->{_checkout};
>+}
>+
> =head3 is_waiting
> 
> Returns true if recall is awaiting pickup
>diff --git a/circ/recalls_overdue.pl b/circ/recalls_overdue.pl
>new file mode 100755
>index 0000000..4ea5b85
>--- /dev/null
>+++ b/circ/recalls_overdue.pl
>@@ -0,0 +1,59 @@
>+#!/usr/bin/perl
>+
>+# Copyright 2017 Aleisha Amohia <aleisha@catalyst.net.nz>
>+#
>+# This file is part of Koha.
>+#
>+# Koha is free software; you can redistribute it and/or modify it
>+# under the terms of the GNU General Public License as published by
>+# the Free Software Foundation; either version 3 of the License, or
>+# (at your option) any later version.
>+#
>+# Koha is distributed in the hope that it will be useful, but
>+# WITHOUT ANY WARRANTY; without even the implied warranty of
>+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
>+# GNU General Public License for more details.
>+#
>+# You should have received a copy of the GNU General Public License
>+# along with Koha; if not, see <http://www.gnu.org/licenses>.
>+
>+use Modern::Perl;
>+use CGI qw ( -utf8 );
>+use C4::Auth;
>+use C4::Output;
>+use Koha::Recalls;
>+use Koha::BiblioFrameworks;
>+use Koha::DateUtils;
>+
>+my $query = new CGI;
>+my ( $template, $loggedinuser, $cookie, $flags ) = get_template_and_user(
>+    {
>+        template_name   => "circ/recalls_overdue.tt",
>+        query           => $query,
>+        type            => "intranet",
>+        authnotrequired => 0,
>+        flagsrequired   => { circulate => "circulate_remaining_permissions" },
>+        debug           => 1,
>+    }
>+);
>+
>+my $op = $query->param('op') || 'list';
>+my @recall_ids = $query->multi_param('recall_ids');
>+
>+if ($op eq 'cancel_multiple_recalls') {
>+    foreach my $id (@recall_ids) {
>+        Koha::Recalls->find($id)->update({ cancellationdate => dt_from_string(), status => 'C' });
>+        $op = 'list'
>+    }
>+}
>+
>+if ($op eq 'list') {
>+    my $recalls = Koha::Recalls->search({ status => 'O' });
>+    $template->param( recalls => $recalls );
>+}
>+
>+# Checking if there is a Fast Cataloging Framework
>+$template->param( fast_cataloging => 1 ) if Koha::BiblioFrameworks->find( 'FA' );
>+
>+# writing the template
>+output_html_with_http_headers $query, $cookie, $template->output;
>diff --git a/circ/recalls_queue.pl b/circ/recalls_queue.pl
>index 06c7c66..223dfe0 100755
>--- a/circ/recalls_queue.pl
>+++ b/circ/recalls_queue.pl
>@@ -39,11 +39,9 @@ my ( $template, $loggedinuser, $cookie, $flags ) = get_template_and_user(
> 
> my $op = $query->param('op') || 'list';
> my @recall_ids = $query->multi_param('recall_ids');
>-warn($op);
> 
> if ($op eq 'cancel_multiple_recalls') {
>     foreach my $id (@recall_ids) {
>-        warn($id);
>         Koha::Recalls->find($id)->update({ cancellationdate => dt_from_string(), status => 'C' });
>         $op = 'list'
>     }
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/includes/recalls-reports.inc b/koha-tmpl/intranet-tmpl/prog/en/includes/recalls-reports.inc
>index 1685b7b..825f98c 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/includes/recalls-reports.inc
>+++ b/koha-tmpl/intranet-tmpl/prog/en/includes/recalls-reports.inc
>@@ -4,7 +4,7 @@
>         <thead>
>             <tr>
>                 <th class="nosort">&nbsp;</th>
>-                <th class="recall-borrower anti-the">Borrower</th>
>+                <th class="recall-borrower anti-the">Requested by</th>
>                 <th class="recall-title anti-the">Title</th>
>                 <th class="recall-date psort title-string">Placed on</th>
>                 <th class="recall-expiry title-string">Expires on</th>
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/recalls_overdue.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/recalls_overdue.tt
>new file mode 100644
>index 0000000..494cfdc
>--- /dev/null
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/recalls_overdue.tt
>@@ -0,0 +1,118 @@
>+[% USE Koha %]
>+[% USE KohaDates %]
>+[% INCLUDE 'doc-head-open.inc' %]
>+<title>Koha &rsaquo; Circulation &rsaquo; Overdue recalls</title>
>+[% INCLUDE 'doc-head-close.inc' %]
>+<style type="text/css"> p { margin-top: 0; }</style>
>+<link rel="stylesheet" type="text/css" href="[% interface %]/[% theme %]/css/datatables.css" />
>+<script type="text/javascript" src="[% interface %]/[% theme %]/js/recalls.js"></script>
>+[% INCLUDE 'datatables.inc' %]
>+[% INCLUDE 'columns_settings.inc' %]
>+</head>
>+<body id="circ_recalls_overdue" class="circ">
>+[% INCLUDE 'header.inc' %]
>+[% INCLUDE 'cat-search.inc' %]
>+
>+<div id="breadcrumbs">
>+    <a href="/cgi-bin/koha/mainpage.pl">Home</a>
>+    &rsaquo; <a href="/cgi-bin/koha/circ/circulation-home.pl">Circulation</a>
>+    &rsaquo; <a href="/cgi-bin/koha/circ/recalls_overdue.pl">Overdue recalls</a>
>+</div>
>+
>+[% IF Koha.Preference('CircSidebar') %]<div id="doc3" class="yui-t2">[% ELSE %]<div id="doc2" class="yui-t7">[% END %]
>+
>+<div id="bd">
>+    <div id="yui-main">
>+        [% IF Koha.Preference('CircSidebar') %]<div class="yui-b">[% END %]
>+            <div class="yui-g">
>+
>+                <h1>Overdue recalls</h1>
>+
>+                [% IF recalls.count %]
>+
>+                    <form method="post" action="/cgi-bin/koha/circ/recalls_queue.pl">
>+                        <input type="hidden" name="op" value="cancel_multiple_recalls">
>+
>+                        <input type="checkbox" id="select_all"> <span id="select_all_text">Select all</span>
>+
>+                        <div id="recalls">
>+                            <table id="recalls-table">
>+                                <thead>
>+                                    <tr>
>+                                        <th class="nosort">&nbsp;</th>
>+                                        <th class="recall-borrower anti-the">Requested by</th>
>+                                        <th class="recall-title anti-the">Title</th>
>+                                        <th class="recall-date psort title-string">Placed on</th>
>+                                        <th class="recall-due title-string">Due date</th>
>+                                        <th class="recall-current-borrower">Currently checked out to</th>
>+                                        <th class="recall-branch">Pickup location</th>
>+                                        <th class="recall-cance nosort">Cancel</th>
>+                                    </tr>
>+                                </thead>
>+                                <tbody>
>+                                    [% FOREACH recall IN recalls %]
>+                                        <tr>
>+                                            <td>
>+                                                <input type="checkbox" value="[% recall.recall_id %]" name="recall_ids">
>+                                            </td>
>+                                            <td class="recall-borrower">
>+                                                <a class="recall-borrower" href="/cgi-bin/koha/members/moremember.pl?borrowernumber=[% recall.borrowernumber %]">
>+                                                    [% recall.borrower.firstname %] [% recall.borrower.surname %] ([% recall.borrowernumber %])
>+                                                </a>
>+                                            </td>
>+                                            <td class="recall-title">
>+                                                <a class="recall-title" href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% recall.biblionumber %]">
>+                                                    [% recall.biblio.title %]
>+                                                    [% FOREACH s IN recall.biblio.subtitles %]
>+                                                        [% s %]
>+                                                    [% END %]
>+                                                    [% recall.item.enumchron %]
>+                                                </a>
>+                                                [% recall.biblio.author %]
>+                                            </td>
>+                                            <td class="recall-date">
>+                                                [% recall.recalldate | $KohaDates %]
>+                                            </td>
>+                                            <td class="recall-due">
>+                                                [% recall.checkout.date_due %]
>+                                            </td>
>+                                            <td class="recall-current-borrower">
>+                                                <a class="recall-current-borrower" href="/cgi-bin/koha/members/moremember.pl?borrowernumber=[% recall.checkout.borrowernumber %]">
>+                                                    [% recall.checkout.patron.firstname %] [% recall.checkout.patron.surname %] ([% recall.checkout.borrowernumber %])
>+                                                </a>
>+                                            </td>
>+                                            <td class="recall-branch">
>+                                                [% recall.branch.branchname %]
>+                                            </td>
>+                                            <td class="recall-cancel">
>+                                                <a class="btn btn-xs btn-default" id="cancel_recall" data-id="[% recall.recall_id %]"><i class="fa fa-times"></i> Cancel</a>
>+                                            </td>
>+                                        </tr>
>+                                    [% END %]
>+                                </tbody>
>+                            </table>
>+                        </div>
>+                        <fieldset class="action">
>+                            <button type="submit" id="cancel_selected" class="btn btn-default btn-sm">Cancel selected recalls</button>
>+                        </fieldset>
>+                    </form>
>+
>+                [% ELSE %]
>+
>+                    <div class="dialog message">There are no overdue recalls.</div>
>+
>+                [% END %]
>+
>+            </div>
>+        </div>
>+
>+    </div>
>+
>+    [% IF Koha.Preference('CircSidebar') %]
>+        <div class="yui-b noprint">
>+            [% INCLUDE 'circ-nav.inc' %]
>+        </div>
>+    [% END %]
>+</div>
>+
>+[% INCLUDE 'intranet-bottom.inc' %]
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/recalls_queue.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/recalls_queue.tt
>index 274f1d9..5d28ac1 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/recalls_queue.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/recalls_queue.tt
>@@ -9,7 +9,7 @@
> [% INCLUDE 'datatables.inc' %]
> [% INCLUDE 'columns_settings.inc' %]
> </head>
>-<body id="circ_view_holdsqueue" class="circ">
>+<body id="circ_recalls_queue" class="circ">
> [% INCLUDE 'header.inc' %]
> [% INCLUDE 'cat-search.inc' %]
> 
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 19532: 68569 | 68570 | 68571 | 68572 | 68642 | 68643 | 68644 | 68645 | 68653 | 69100 | 69102 | 69147 | 69148 | 69149 | 69170 | 69172 | 69221 | 69222 | 69223 | 69322 | 69353 | 69354 | 69405 | 69409 | 69410 | 69411 | 69841 | 69872 | 69873 | 69874 | 69875 | 69876 | 69877 | 69878 | 69879 | 69880 | 69881 | 69882 | 69883 | 69884 | 69885 | 69886 | 69887 | 69888 | 69889 | 69890 | 69986 | 70093 | 71409 | 71574 | 71575 | 71576 | 71577 | 71578 | 71579 | 71580 | 71581 | 71582 | 71583 | 71584 | 71585 | 71586 | 71587 | 71588 | 71589 | 71590 | 71591 | 71592 | 72244 | 72311 | 72312 | 72313 | 72314 | 72315 | 72316 | 72317 | 72318 | 72319 | 72320 | 72321 | 72322 | 72323 | 72324 | 72325 | 72326 | 72327 | 72328 | 72329 | 72330 | 72331 | 72332 | 72333 | 72334 | 72335 | 72336 | 72337 | 72338 | 72527 | 76817 | 76818 | 76819 | 76820 | 76821 | 76822 | 76823 | 76824 | 76825 | 76826 | 76827 | 76828 | 76829 | 76830 | 76831 | 76832 | 76833 | 76834 | 76835 | 76836 | 76837 | 76838 | 76839 | 76840 | 76841 | 76842 | 76843 | 76844 | 76845 | 76846 | 76847 | 77177 | 77178 | 77179 | 78755 | 78757 | 78759 | 78761 | 78763 | 78765 | 78766 | 78768 | 78770 | 78772 | 78773 | 78774 | 78775 | 78776 | 78777 | 78778 | 78780 | 78782 | 78785 | 78787 | 78789 | 78790 | 78792 | 78794 | 78797 | 78800 | 78801 | 78802 | 78803 | 78804 | 78805 | 78806 | 78807 | 78808 | 80763 | 80764 | 80765 | 80766 | 80767 | 80768 | 80769 | 80770 | 80771 | 80772 | 80773 | 80774 | 80775 | 80776 | 80777 | 80778 | 80779 | 80780 | 80781 | 80782 | 80783 | 80784 | 80785 | 80786 | 80787 | 80788 | 80789 | 80793 | 80878 | 81204 | 81205 | 81206 | 81207 | 81208 | 81209 | 81210 | 81211 | 81212 | 81213 | 81214 | 81215 | 81216 | 81217 | 81218 | 81219 | 81220 | 81221 | 81222 | 81223 | 81224 | 81225 | 81226 | 81227 | 81228 | 81229 | 81230 | 81231 | 81232 | 81233 | 81234 | 81235 | 81236 | 81237 | 81238 | 81239 | 81240 | 81241 | 81242 | 81243 | 81244 | 81245 | 81246 | 81247 | 81547 | 81548 | 81549 | 81550 | 81551 | 81552 | 81553 | 81554 | 81555 | 81556 | 81557 | 81558 | 81559 | 81560 | 81561 | 81562 | 81563 | 81564 | 81565 | 81566 | 81567 | 81568 | 81569 | 81583 | 81584 | 81585 | 81586 | 81587 | 81588 | 81595 | 81618 | 81652 | 81653 | 81654 | 81655 | 81656 | 81657 | 81658 | 81659 | 81660 | 81661 | 81662 | 81663 | 81664 | 81665 | 81666 | 81667 | 81668 | 81669 | 81670 | 81671 | 81672 | 81673 | 81674 | 81675 | 81676 | 81677 | 81678 | 81679 | 81680 | 81681 | 81682 | 81683 | 103887 | 103888 | 103890 | 103899 | 103900 | 103901 | 103999 | 104000 | 104001 | 104002 | 104005 | 104006 | 104007 | 104066 | 104067 | 104068 | 104069 | 104070 | 104071 | 104246 | 104247 | 104248 | 104249 | 104250 | 104322 | 104323 | 104324 | 104325 | 104326 | 104327 | 104328 | 104329 | 104330 | 104331 | 104332 | 104333 | 104334 | 104335 | 104336 | 104391 | 104392 | 104393 | 104394 | 104395 | 104396 | 104397 | 104398 | 104474 | 104475 | 104476 | 104477 | 104478 | 104479 | 104480 | 104481 | 104545 | 104546 | 104547 | 104548 | 104549 | 104550 | 104551 | 104552 | 104646 | 104647 | 104648 | 104649 | 104650 | 104651 | 104652 | 104653 | 104722 | 104723 | 104724 | 104725 | 104726 | 104727 | 104728 | 104729 | 104806 | 104807 | 104808 | 104809 | 104810 | 104811 | 104812 | 104813 | 104814 | 104815 | 104816 | 104817 | 104818 | 104819 | 104820 | 104821 | 104863 | 104864 | 104865 | 104866 | 104867 | 104868 | 104869 | 104870 | 104902 | 104903 | 104904 | 104905 | 104906 | 104907 | 104908 | 104909 | 104910 | 104913 | 104914 | 104915 | 104916 | 104917 | 104918 | 104919 | 104920 | 104988 | 104989 | 104990 | 104991 | 104992 | 106268 | 106269 | 106371 | 106372 | 106373 | 106374 | 106375 | 106376 | 106377 | 106378 | 106810 | 106811 | 106812 | 106813 | 106814 | 106815 | 106816 | 106817 | 106857 | 107198 | 107199 | 107200 | 107201 | 107202 | 107203 | 107204 | 107205 | 107807 | 107808 | 107809 | 107810 | 107811 | 107812 | 107813 | 107814 | 107918 | 107919 | 107920 | 107921 | 107922 | 107923 | 107924 | 107925 | 108222 | 108223 | 108224 | 108225 | 108226 | 108227 | 108228 | 108229 | 108980 | 108981 | 108982 | 109306 | 109307 | 109308 | 109309 | 109310 | 109311 | 109312 | 109313 | 109314 | 109315 | 109316 | 109317 | 109318 | 109463 | 109464 | 109465 | 109466 | 109467 | 109468 | 109469 | 109775 | 109776 | 109777 | 109778 | 109779 | 109780 | 109781 | 109782 | 109783 | 109784 | 109785 | 111199 | 111200 | 111201 | 111202 | 111203 | 111204 | 111205 | 111206 | 112316 | 112317 | 112321 | 112322 | 112323 | 112324 | 112325 | 112326 | 112346 | 112472 | 112491 | 112540 | 112612 | 112613 | 112614 | 112615 | 112616 | 112617 | 112618 | 112619 | 112620 | 112621 | 112622 | 113195 | 113196 | 113197 | 113198 | 113199 | 113200 | 113201 | 113202 | 113203 | 113204 | 113205 | 113286 | 113287 | 113288 | 113289 | 113290 | 113291 | 113292 | 113293 | 113294 | 113295 | 113296 | 113297 | 113298 | 113335 | 113351 | 113352 | 113353 | 113354 | 113355 | 113356 | 113357 | 113358 | 113359 | 113361 | 113362 | 113363 | 113364 | 113365 | 113430 | 113431 | 113432 | 113433 | 113434 | 113435 | 113436 | 113437 | 113438 | 113439 | 113440 | 113441 | 113442 | 113443 | 113444 | 113445 | 116121 | 116122 | 116123 | 116124 | 116125 | 116126 | 116127 | 116128 | 116129 | 116130 | 116131 | 116132 | 116133 | 116134 | 118267 | 118268 | 118269 | 118270 | 118271 | 118272 | 118273 | 118274 | 118275 | 118276 | 118277 | 118278 | 118279 | 118280 | 122993 | 122994 | 122995 | 122996 | 122997 | 122998 | 122999 | 123000 | 123001 | 123002 | 123003 | 123004 | 123005 | 126244 | 126245 | 126246 | 126247 | 126248 | 126249 | 126250 | 126251 | 126252 | 126253 | 126254 | 126255 | 126256 | 126257 | 126453 | 126454 | 126455 | 126456 | 126457 | 126458 | 126459 | 126460 | 126469 | 126470 | 126565 | 126566 | 126568 | 126569 | 126570 | 126571 | 126572 | 126573 | 126574 | 126575 | 126576 | 126577 | 126578 | 126579 | 126580 | 129305 | 129306 | 129307 | 129308 | 129309 | 129310 | 129311 | 129312 | 129313 | 129314 | 129315 | 129316 | 129317 | 129318 | 129319 | 130641 | 130642 | 130643 | 130644 | 130645 | 130646 | 130647 | 130648 | 130649 | 130650 | 130651 | 130652 | 130653 | 130654 | 130655 | 130656 | 131108 | 131156 | 131157 | 131158 | 131159 | 131160 | 131193 | 131213 | 131257 | 131260 | 131261 | 131262 | 131263 | 131264 | 131265 | 131266 | 131267 | 131268 | 131269 | 131270 | 131271 | 131272 | 131273 | 131274 | 131275 | 131276 | 131277 | 131278 | 131279 | 131280 | 131281 | 131282 | 131330 | 131629 | 131630 | 131631 | 131664 | 131665 | 131666 | 131701 | 132332