From 2c637b8a127f34e0883c154d763b6ffe0d60657d Mon Sep 17 00:00:00 2001
From: Julian Maurice <julian.maurice@biblibre.com>
Date: Wed, 18 Apr 2012 15:06:46 +0200
Subject: [PATCH] Bug 7162: Fix booksellers.pl display

Basket infos don't take cancelled orders into account anymore.
---
 C4/Acquisition.pm |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm
index e3da1f4..8d3d8af 100644
--- a/C4/Acquisition.pm
+++ b/C4/Acquisition.pm
@@ -592,7 +592,7 @@ sub GetBasketsInfosByBookseller {
           ) AS expected_items
         FROM aqbasket
           LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno
-        WHERE booksellerid = ?
+        WHERE booksellerid = ? AND aqorders.datecancellationprinted IS NULL
         GROUP BY aqbasket.basketno
     };
     my $sth = $dbh->prepare($query);
-- 
1.7.10.4