Attachment 4170 Details for Bug 6366 – Corrects GetSuppliersWithLateIssues

[patch] Corrects GetSuppliersWithLateIssues

0001-Corrects-GetSuppliersWithLateIssues.patch (text/plain), 1.16 KB, created by Frédérick Capovilla on 2011-05-18 17:34:07 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Frédérick Capovilla

Created: 2011-05-18 17:34:07 UTC

Size: 1.16 KB

patch

obsolete

>From 5fa093e3317da94cf47411f6310d7b14c1a182fd Mon Sep 17 00:00:00 2001
>From: =?utf-8?q?Fr=C3=A9d=C3=A9rick=20Capovilla?= <frederick.capovilla@sys-tech.net>
>Date: Wed, 18 May 2011 11:25:03 -0400
>Subject: [PATCH] Corrects GetSuppliersWithLateIssues
>
>GetSuppliersWithLateIssues returned every supplier with an order with a
>planneddate in the past, even if the order was received.
>I modified the query so it doesn't see a received order as "late".
>---
> C4/Serials.pm |    2 +-
> 1 files changed, 1 insertions(+), 1 deletions(-)
>
>diff --git a/C4/Serials.pm b/C4/Serials.pm
>index bf4a2e6..0d3e614 100644
>--- a/C4/Serials.pm
>+++ b/C4/Serials.pm
>@@ -96,7 +96,7 @@ sub GetSuppliersWithLateIssues {
>     FROM            subscription
>     LEFT JOIN       serial ON serial.subscriptionid=subscription.subscriptionid
>     LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
>-    WHERE id > 0 AND (planneddate < now() OR serial.STATUS = 3 OR serial.STATUS = 4) ORDER BY name|;
>+    WHERE id > 0 AND ((planneddate < now() AND serial.STATUS =1) OR serial.STATUS = 3 OR serial.STATUS = 4) ORDER BY name|;
>     return $dbh->selectall_arrayref($query, { Slice => {} });
> }
> 
>-- 
>1.5.6.5
>

Actions: View | Diff | Splinter Review

Attachments on bug 6366: 4170