Attachment 12727 Details for Bug 8236 – Block renewal for overdue documents

[patch] Block renewal for overdue documents

0001-Block-renewal-for-overdue-documents.patch (text/plain), 18.19 KB, created by Koha Team University Lyon 3 on 2012-10-08 08:07:48 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Koha Team University Lyon 3

Created: 2012-10-08 08:07:48 UTC

Size: 18.19 KB

patch

obsolete

>From 3c862d0dc5a1258b25517f17bab263df41f78520 Mon Sep 17 00:00:00 2001
>From: Lyon3 Team <koha@univ-lyon3.fr>
>Date: Mon, 8 Oct 2012 09:44:26 +0200
>Subject: [PATCH] Block renewal for overdue documents
>
>If any of patron's document is late, renewal can be allowed, blocked on every checked
>out items or only on overdue ones.
>The renewal remains nevertheless possible for the librarian checking the Override renewal limit
>---
> C4/Circulation.pm                                  |    5 +++--
> C4/ILSDI/Services.pm                               |   12 +++++++++++-
> circ/circulation.pl                                |   12 +++++++++---
> installer/data/mysql/sysprefs.sql                  |    1 +
> installer/data/mysql/updatedatabase.pl             |    7 +++++++
> .../en/modules/admin/preferences/circulation.pref  |    8 ++++++++
> .../prog/en/modules/circ/circulation.tt            |   12 ++++++++++--
> .../prog/en/modules/members/moremember.tt          |    7 ++++++-
> koha-tmpl/opac-tmpl/prog/en/modules/opac-user.tt   |    6 +++++-
> members/moremember.pl                              |   10 ++++++++--
> opac/opac-user.pl                                  |   11 +++++++++--
> 11 files changed, 77 insertions(+), 14 deletions(-)
>
>diff --git a/C4/Circulation.pm b/C4/Circulation.pm
>index 7485de5..bbf62c0 100644
>--- a/C4/Circulation.pm
>+++ b/C4/Circulation.pm
>@@ -2417,7 +2417,7 @@ already renewed the loan. $error will contain the reason the renewal can not pro
> sub CanBookBeRenewed {
> 
>     # check renewal status
>-    my ( $borrowernumber, $itemnumber, $override_limit ) = @_;
>+    my ( $borrowernumber, $itemnumber, $override_limit, $overdue, $overduesblockrenew ) = @_;
>     my $dbh       = C4::Context->dbh;
>     my $renews    = 1;
>     my $renewokay = 0;
>@@ -2466,7 +2466,8 @@ sub CanBookBeRenewed {
>     if ( my $data1 = $sthcount->fetchrow_hashref ) {
>         
>         if ( ( $data1->{renewalsallowed} && $data1->{renewalsallowed} > $data1->{renewals} ) || $override_limit ) {
>-            $renewokay = 1;
>+            $renewokay =  ($overduesblockrenew eq 'blockitem' and $overdue and !$override_limit)? 0 : 1;
>+            $error = 'overdue' unless $renewokay;
>         }
>         else {
> 			$error="too_many";
>diff --git a/C4/ILSDI/Services.pm b/C4/ILSDI/Services.pm
>index d685e6c..a013cd2 100644
>--- a/C4/ILSDI/Services.pm
>+++ b/C4/ILSDI/Services.pm
>@@ -555,7 +555,17 @@ sub RenewLoan {
>     return { code => 'RecordNotFound' } unless $$item{itemnumber};
> 
>     # Add renewal if possible
>-    my @renewal = CanBookBeRenewed( $borrowernumber, $itemnumber );
>+    my $issue = GetItemIssue($itemnumber);
>+    # Check for overdue on this document
>+    my $dt_due = $issue->{'date_due'}->truncate( to => 'day' );
>+    my $dt_today = DateTime->now( time_zone => C4::Context->tz() );
>+    my $overdue = 1 if DateTime->compare( $dt_today,$dt_due  ) == 1;
>+    # Check if any of patron's documents is late
>+    my ($memberblocked) = C4::Members::IsMemberBlocked($borrowernumber);
>+    # Is renewal allowed on overdue documents ?
>+    my $overduesblockrenew = C4::Context->preference('OverduesBlockRenew');
>+    my $norenewal = 1 if ( $overduesblockrenew eq 'blockall' and $memberblocked == -1 ) or ( $overduesblockrenew eq 'blockitem' and $overdue ) or $memberblocked == 1;# last to check if patron is restricted
>+    my @renewal = $norenewal ? (0,'overdue') : CanBookBeRenewed( $borrowernumber, $itemnumber );
>     if ( $renewal[0] ) { AddRenewal( $borrowernumber, $itemnumber ); }
> 
>     my $issue = GetItemIssue($itemnumber);
>diff --git a/circ/circulation.pl b/circ/circulation.pl
>index f15d4ce..e7dc19d 100755
>--- a/circ/circulation.pl
>+++ b/circ/circulation.pl
>@@ -429,6 +429,13 @@ my $displayrelissues;
> 
> our $totalprice = 0;
> 
>+# Check if any of patron's documents is late
>+my ($memberblocked) = C4::Members::IsMemberBlocked($borrowernumber);
>+# and if renewal is allowed in that case
>+my $overduesblockrenew = C4::Context->preference('OverduesBlockRenew');
>+my $norenewal = 1 if $overduesblockrenew eq 'blockall' and $memberblocked == -1;
>+$template->param( norenewal => 1 ) if $overduesblockrenew ne 'allow';
>+
> sub build_issue_data {
>     my $issueslist = shift;
>     my $relatives = shift;
>@@ -444,9 +451,8 @@ sub build_issue_data {
>             $it->{'itemnumber'}, $it->{'borrowernumber'}
>         );
>         $it->{'charge'} = sprintf("%.2f", $it->{'charge'});
>-        my ($can_renew, $can_renew_error) = CanBookBeRenewed( 
>-            $it->{'borrowernumber'},$it->{'itemnumber'}
>-        );
>+        my ($can_renew, $can_renew_error) = $norenewal ? (0, 'overdue') : CanBookBeRenewed(
>+        $it->{'borrowernumber'},$it->{'itemnumber'}, undef, $it->{'overdue'}, $overduesblockrenew);
>         $it->{"renew_error_${can_renew_error}"} = 1 if defined $can_renew_error;
>         my ( $restype, $reserves, undef ) = CheckReserves( $it->{'itemnumber'} );
>         $it->{'can_renew'} = $can_renew;
>diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql
>index 178ff40..4b127a5 100644
>--- a/installer/data/mysql/sysprefs.sql
>+++ b/installer/data/mysql/sysprefs.sql
>@@ -386,3 +386,4 @@ INSERT INTO systempreferences (variable,value,explanation,type) VALUES('OPACdidy
> INSERT INTO systempreferences (variable,value,explanation,type) VALUES('INTRAdidyoumean',NULL,'Did you mean? configuration for the Intranet. Do not change, as this is controlled by /cgi-bin/koha/admin/didyoumean.pl.','Free');
> INSERT INTO systempreferences (variable, value, options, explanation, type) VALUES ('BlockReturnOfWithdrawnItems', '1', '0', 'If enabled, items that are marked as withdrawn cannot be returned.', 'YesNo');
> INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('HoldsToPullStartDate','2','Set the default start date for the Holds to pull list to this many days ago',NULL,'Integer');
>+INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('OverduesBlockRenew','allow','If any of patron\'s checked out documents is late, should renewal be allowed, blocked only on overdue items or blocked on whatever checked out document','allow|blockitem|blockall','Choice');
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index fb389da..59b0814 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -6002,6 +6002,13 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
>     SetVersion($DBversion);
> }
> 
>+$DBversion = "3.09.00.061";
>+if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
>+    $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('OverduesBlockRenew','allow','If any of a patron\'s checked out documents is late, should renewal be allowed, blocked only on overdue items or blocked on whatever checked out document','allow|blockitem|blockall','Choice')");
>+    print "Upgrade to $DBversion done (Add system preference BlockRenewal ))\n";
>+    SetVersion($DBversion);
>+}
>+
> =head1 FUNCTIONS
> 
> =head2 TableExists($table)
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref
>index 91eb1ac..d674676 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref
>@@ -276,6 +276,14 @@ Circulation:
>                   confirmation: Ask for confirmation
>             - when checking out to a borrower that has overdues outstanding	    
>         -
>+            - If any of a patron's checked out documents is late, the renewal is
>+            - pref: OverduesBlockRenew
>+              type: choice
>+              choices:
>+                  allow: allowed
>+                  blockall: blocked on whatever of his checked out documents
>+                  blockitem: blocked only on the overdue items
>+        -
>             - On checkin route the returned item to
>             - pref: HomeOrHoldingBranchReturn
>               type: choice
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/circulation.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/circulation.tt
>index 652cbf8..0fc0ac8 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/circulation.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/circulation.tt
>@@ -805,7 +805,7 @@ No patron matched <span class="ex">[% message %]</span>
>         <td><span style="padding: 0 1em;">[% IF ( todayissue.renewals ) %][% todayissue.renewals %][% ELSE %]0[% END %]</span>
>         [% IF ( todayissue.can_renew ) %]
>         <input type="checkbox" name="all_items[]" value="[% todayissue.itemnumber %]" checked="checked" style="display: none;" />
>-        [% IF ( todayissue.od ) %]
>+        [% IF ( todayissue.od and !previssue.renew_error_overdue ) %]
>             <input type="checkbox" class="radio" name="items[]" value="[% todayissue.itemnumber %]" checked="checked" />
>         [% ELSE %]
>             <input type="checkbox" class="radio" name="items[]" value="[% todayissue.itemnumber %]" />
>@@ -827,6 +827,9 @@ No patron matched <span class="ex">[% message %]</span>
>                 [% IF ( todayissue.renew_error_too_many ) %]
>             Not renewable
>                 [% END %]
>+                [% IF ( todayissue.renew_error_overdue ) %]
>+                        Renewal not allowed (overdue)
>+                [% END %]
>             [% IF ( todayissue.can_confirm ) %]
>                 </span>
>             [% END %]
>@@ -886,7 +889,7 @@ No patron matched <span class="ex">[% message %]</span>
>         <td><span style="padding: 0 1em;">[% IF ( previssue.renewals ) %][% previssue.renewals %][% ELSE %]0[% END %]</span>
>         [% IF ( previssue.can_renew ) %]
>         <input type="checkbox" name="all_items[]" value="[% previssue.itemnumber %]" checked="checked" style="display: none;" />
>-        [% IF ( previssue.od ) %]
>+        [% IF ( previssue.od and !previssue.renew_error_overdue ) %]
>             <input type="checkbox" class="radio" name="items[]" value="[% previssue.itemnumber %]" checked="checked" />
>         [% ELSE %]
>             <input type="checkbox" class="radio" name="items[]" value="[% previssue.itemnumber %]" />
>@@ -908,6 +911,9 @@ No patron matched <span class="ex">[% message %]</span>
>                 [% IF ( previssue.renew_error_too_many ) %]
>             Not renewable
>                 [% END %]
>+                [% IF ( previssue.renew_error_overdue ) %]
>+                        Renewal not allowed (overdue)
>+                [% END %]
>             [% IF ( previssue.can_confirm ) %]
>                 </span>
>             [% END %]
>@@ -947,7 +953,9 @@ No patron matched <span class="ex">[% message %]</span>
>         [% END %]
>         [% END %]
>         <input type="submit" name="renew_checked" value="Renew or Return checked items" />
>+        [% UNLESS ( norenewal ) %]
>         <input type="submit" id="renew_all" name="renew_all" value="Renew all" />
>+        [% END %]
>         [% IF export_remove_fields OR export_with_csv_profile %]
>             <br/><br/>
>             Don't export fields : <input type="text" id="export_remove_fields" name="export_remove_fields" value="[% export_remove_fields %]" title="Use for iso2709 exports" />
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/members/moremember.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/members/moremember.tt
>index abbf26f..6aea391 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/members/moremember.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/members/moremember.tt
>@@ -470,7 +470,7 @@ function validate1(date) {
>             [% IF ( issueloo.norenew ) %]
>                 [% IF ( issueloo.can_confirm ) %]<span class="renewals-allowed" style="display: none">
>                     <input type="checkbox" name="all_items[]" value="[% issueloo.itemnumber %]" checked="checked" style="display: none;" />
>-                    [% IF ( issueloo.od ) %]
>+                    [% IF ( issueloo.od  and !issueloo.norenew_reason_overdue ) %]
>                         <input type="checkbox" name="items[]" value="[% issueloo.itemnumber %]" checked="checked" />
>                     [% ELSE %]
>                         <input type="checkbox" name="items[]" value="[% issueloo.itemnumber %]" />
>@@ -478,6 +478,9 @@ function validate1(date) {
>                     </span>
>                     <span class="renewals-disabled">
>                 [% END %]
>+                [% IF ( issueloo.norenew_reason_overdue ) %]
>+                    Renewal not allowed (overdue)
>+                [% END %]
>                 [% IF ( issueloo.norenew_reason_on_reserve ) %]
>                 <a href="/cgi-bin/koha/reserve/request.pl?biblionumber=[% issueloo.biblionumber %]">On Hold</a>
>                 [% END %]
>@@ -520,7 +523,9 @@ function validate1(date) {
>         [% END %]
>         [% END %]
>         <input type="submit" name="renew_checked" value="Renew or return checked items" />
>+        [% UNLESS ( norenewal ) %]
>         <input type="submit" id="renew_all" name="renew_all" value="Renew all" />
>+        [% END %]
>         </fieldset>
>     [% ELSE %]<p>Patron has nothing checked out.</p>
> [% END %]
>diff --git a/koha-tmpl/opac-tmpl/prog/en/modules/opac-user.tt b/koha-tmpl/opac-tmpl/prog/en/modules/opac-user.tt
>index 43b8329..b10651a 100644
>--- a/koha-tmpl/opac-tmpl/prog/en/modules/opac-user.tt
>+++ b/koha-tmpl/opac-tmpl/prog/en/modules/opac-user.tt
>@@ -185,8 +185,11 @@ $.tablesorter.addParser({
>                 [% IF ( OpacRenewalAllowed ) %]
>                     <td class="renew">[% IF ( ISSUE.status ) %][% IF ( canrenew ) %]<input type="checkbox" name="item" value="[% ISSUE.itemnumber %]"/> <a href="/cgi-bin/koha/opac-renew.pl?from=opac_user&amp;item=[% ISSUE.itemnumber %]&amp;borrowernumber=[% ISSUE.borrowernumber %]">Renew</a>[% END %] <span class="renewals">([% ISSUE.renewsleft %] of [% ISSUE.renewsallowed %] renewals remaining)</span>
>                         [% ELSE %]
>+                        [% IF ( ISSUE.norenew_overdue ) %]
>+                           Renewal not allowed <span class="renewals">(overdue on a document)</span>
>+                        [% ELSE %]
>                         Not renewable[% IF ( ISSUE.too_many ) %] <span class="renewals">([% ISSUE.renewsleft %] of [% ISSUE.renewsallowed %] renewals remaining)</span>[% ELSE %][% IF ( ISSUE.on_reserve ) %] <span class="renewals">(On hold)</span>[% END %][% END %] 
>-                        [% END %]</td>
>+                        [% END %][% END %]</td>
>                 [% END %]
> [% IF ( OPACFinesTab ) %]
>                 <td class="fines">[% IF ( ISSUE.charges ) %]Yes[% ELSE %]No[% END %]</td>
>@@ -329,6 +332,7 @@ $.tablesorter.addParser({
> [% ELSIF ( OVERDUE.status ) %]
> [% IF ( canrenew ) %]<a href="/cgi-bin/koha/opac-renew.pl?from=opac_user&amp;item=[% OVERDUE.itemnumber %]&amp;bornum=[% OVERDUE.borrowernumber %]">Renew</a>[% END %] <span class="renewals">([% OVERDUE.renewsleft %] of [% OVERDUE.renewsallowed %] renewals remaining)</span>
> [% ELSIF ( OVERDUE.onreserve ) %]On hold
>+[% ELSIF ( OVERDUE.norenew_overdue ) %]Renewal not allowed<span class="renewals">(overdue on a document)</span>
> [% ELSE %]No renewals left
> [% END %]
> </td>[% END %]
>diff --git a/members/moremember.pl b/members/moremember.pl
>index 0524ecb..b7d6b39 100755
>--- a/members/moremember.pl
>+++ b/members/moremember.pl
>@@ -256,6 +256,13 @@ my @borrowers_with_issues;
> my $overdues_exist = 0;
> my $totalprice = 0;
> 
>+# Check if any of patron's documents is late
>+my ($memberblocked)=C4::Members::IsMemberBlocked($borrowernumber);
>+# and if renewal is allowed in that case
>+my $overduesblockrenew = C4::Context->preference('OverduesBlockRenew');
>+my $norenewal = 1 if $overduesblockrenew eq 'blockall' and $memberblocked == -1;
>+$template->param( norenewal => 1 ) if $overduesblockrenew ne 'allow';
>+
> my @issuedata = build_issue_data($issue);
> my @relissuedata = build_issue_data($relissue);
> 
>@@ -512,8 +519,7 @@ sub build_issue_data {
>         $row{'charge'} = sprintf( "%.2f", $charge );
> 
>         my ( $renewokay, $renewerror ) =
>-          CanBookBeRenewed( $borrowernumber, $issue->{itemnumber},
>-            $override_limit );
>+        my ( $renewokay, $renewerror ) = $norenewal ? (0, 'overdue') : CanBookBeRenewed( $borrowernumber, $issue->{itemnumber}, $override_limit, $issue->{overdue}, $overduesblockrenew );
>         $row{'norenew'} = !$renewokay;
>         $row{'can_confirm'} = ( !$renewokay && $renewerror ne 'on_reserve' );
>         $row{"norenew_reason_$renewerror"} = 1 if $renewerror;
>diff --git a/opac/opac-user.pl b/opac/opac-user.pl
>index eee3d38..15d364b 100755
>--- a/opac/opac-user.pl
>+++ b/opac/opac-user.pl
>@@ -153,6 +153,13 @@ my @overdues;
> my @issuedat;
> my $itemtypes = GetItemTypes();
> my $issues = GetPendingIssues($borrowernumber);
>+
>+# Check if any of patron's documents is late
>+my ($memberblocked) = C4::Members::IsMemberBlocked($borrowernumber);
>+# and if renewal is allowed in that case
>+my $overduesblockrenew = C4::Context->preference('OverduesBlockRenew');
>+my $norenewal = 1 if $overduesblockrenew eq 'blockall' and $memberblocked == -1;
>+
> if ($issues){
> 	foreach my $issue ( sort { $b->{date_due}->datetime() cmp $a->{date_due}->datetime() } @{$issues} ) {
> 		# check for reserves
>@@ -179,14 +186,14 @@ if ($issues){
> 		$issue->{$publictype} = 1;
> 
> 		# check if item is renewable
>-		my ($status,$renewerror) = CanBookBeRenewed( $borrowernumber, $issue->{'itemnumber'} );
>+		my ($status,$renewerror) = $norenewal ? (0, 'overdue') : CanBookBeRenewed( $borrowernumber, $issue->{'itemnumber'}, undef, $issue->{'overdue'}, $overduesblockrenew);
> 		($issue->{'renewcount'},$issue->{'renewsallowed'},$issue->{'renewsleft'}) = GetRenewCount($borrowernumber, $issue->{'itemnumber'});
>         if($status && C4::Context->preference("OpacRenewalAllowed")){
>             $issue->{'status'} = $status;
>         }
> 		$issue->{'too_many'} = 1 if $renewerror and $renewerror eq 'too_many';
> 		$issue->{'on_reserve'} = 1 if $renewerror and $renewerror eq 'on_reserve';
>-
>+    $issue->{'norenew_overdue'} = 1 if $renewerror and $renewerror eq 'overdue';
> 		if ( $issue->{'overdue'} ) {
> 			push @overdues, $issue;
> 			$overdues_count++;
>-- 
>1.7.2.5
>

Actions: View | Diff | Splinter Review

Attachments on bug 8236: 10230 | 11958 | 12362 | 12619 | 12727 | 12790 | 12791 | 13510 | 14433 | 17926 | 18071 | 18073 | 18507 | 18729 | 20716 | 20719 | 21163 | 21223 | 22264 | 22275 | 22280 | 34234 | 34322 | 35372 | 36674 | 36743 | 37407 | 37418 | 37457 | 37458 | 37459 | 41992 | 41993 | 41994 | 42007 | 43628