Attachment 12309 Details for Bug 8112 – Bug 8112 - Overdues with Fines dup Followup 2 - Add items.itemnumber to GROUP BY when using $location

[patch] Bug 8112 - Overdues with Fines dup Followup 2 - Add items.itemnumber to GROUP BY when using $location

Bug-8112---Overdues-with-Fines-dup-Followup-2---Ad.patch (text/plain), 1.11 KB, created by Kyle M Hall (khall) on 2012-09-18 13:32:25 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2012-09-18 13:32:25 UTC

Size: 1.11 KB

patch

obsolete

>From 2e90d296d34c3ece4bea703955ef0468555b55e5 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Tue, 18 Sep 2012 09:31:30 -0400
>Subject: [PATCH] Bug 8112 - Overdues with Fines dup Followup 2 - Add items.itemnumber to GROUP BY when using $location
>Content-Type: text/plain; charset="utf-8"
>
>---
> C4/Overdues.pm |    2 +-
> 1 files changed, 1 insertions(+), 1 deletions(-)
>
>diff --git a/C4/Overdues.pm b/C4/Overdues.pm
>index d44f8b9..26ea8bd 100644
>--- a/C4/Overdues.pm
>+++ b/C4/Overdues.pm
>@@ -1261,7 +1261,7 @@ sub GetOverduesForBranch {
>     my $i = 0;
>     my $sth;
>     if ($location) {
>-        $sth = $dbh->prepare("$select AND items.location = ? GROUP BY borrowers.borrowernumber ORDER BY borrowers.surname, borrowers.firstname");
>+        $sth = $dbh->prepare("$select AND items.location = ? GROUP BY borrowers.borrowernumber, items.itemnumber ORDER BY borrowers.surname, borrowers.firstname");
>         $sth->execute($branch, $location);
>     } else {
>         $sth = $dbh->prepare("$select GROUP BY borrowers.borrowernumber, items.itemnumber ORDER BY borrowers.surname, borrowers.firstname");
>-- 
>1.7.2.5

Actions: View | Diff | Splinter Review

Attachments on bug 8112: 9628 | 11578 | 11813 | 11814 | 11815 | 11816 | 11817 | 11818 | 12309 | 15582