From c73cb186f8ea4811e4ab790dab0c3979be3547b7 Mon Sep 17 00:00:00 2001
From: btoumi <btoumi>
Date: Mon, 21 May 2007 07:45:45 +0000
Subject: [PATCH] bug fix : add sql condition to recover only the right record
 from issues table

---
 C4/Circulation/Fines.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/Circulation/Fines.pm b/C4/Circulation/Fines.pm
index 5c1bbf8f8f..1907c3dcb9 100644
--- a/C4/Circulation/Fines.pm
+++ b/C4/Circulation/Fines.pm
@@ -338,7 +338,7 @@ my $dbh = C4::Context->dbh;
 my $query = qq|SELECT *  
     FROM issues
     WHERE itemnumber=?
-|;
+    AND returndate IS NULL|;
 my $sth = $dbh->prepare($query);
 $sth->execute($itemnumber);
 my ($issuesinfo)=$sth->fetchrow_hashref;
-- 
2.39.5