Attachment 58116 Details for Bug 17470 – Bug 17470 Make overdue notices according to branch item only

[patch] Bug 17470 Make overdue notices according to branch item only

Bug-17470-Make-overdue-notices-according-to-branch.patch (text/plain), 1.47 KB, created by Jonathan Druart on 2016-12-12 12:38:08 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2016-12-12 12:38:08 UTC

Size: 1.47 KB

patch

obsolete

>From 054a4ead7d391f07366bf13ed85eab7443564b45 Mon Sep 17 00:00:00 2001
>From: Olivier Crouzet <kohateam@univ-lyon3.fr>
>Date: Thu, 10 Nov 2016 17:25:09 +0100
>Subject: [PATCH] Bug 17470 Make overdue notices according to branch item only
>
>When a patron had overdues on items from different branches
>he received from each corresponding branch a notice claiming
>the complete list of these items.
>
>Signed-off-by: sbujam <sbujam@users.noreply.github.com>
>
>Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
>---
> misc/cronjobs/overdue_notices.pl | 3 ++-
> 1 file changed, 2 insertions(+), 1 deletion(-)
>
>diff --git a/misc/cronjobs/overdue_notices.pl b/misc/cronjobs/overdue_notices.pl
>index 7504c7a..0aaf22a 100755
>--- a/misc/cronjobs/overdue_notices.pl
>+++ b/misc/cronjobs/overdue_notices.pl
>@@ -465,6 +465,7 @@ SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, branchname
>     AND b.branchcode = items.homebranch
>     AND biblio.biblionumber   = biblioitems.biblionumber
>     AND issues.borrowernumber = ?
>+    AND issues.branchcode = ?
>     AND TO_DAYS($date)-TO_DAYS(issues.date_due) >= 0
> END_SQL
> 
>@@ -613,7 +614,7 @@ END_SQL
>                     ) unless $test_mode;
>                     $verbose and warn "debarring $borr\n";
>                 }
>-                my @params = ($borrowernumber);
>+                my @params = ($borrowernumber,$branchcode);
>                 $verbose and warn "STH2 PARAMS: borrowernumber = $borrowernumber";
> 
>                 $sth2->execute(@params);
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 17470: 57298 | 57429 | 57791 | 58116