From 306e11f51aa0272f7c6803a593b488f597cd2f69 Mon Sep 17 00:00:00 2001
From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Date: Fri, 20 Mar 2020 10:13:04 +0000
Subject: [PATCH] Bug 22569: Refine GetTransfersFromTo to filter out unsent
 transfers

GetTransfersFromTo is used solely by the transferstorecieve page which
assumes items have already been sent. With the introduction of
daterequested we allow for a state where a transfer has been scheduled
but not yet sent (See stockrotation for such a case) and so we need to
filter these transfers out from the transferstorecieve report.
---
 C4/Circulation.pm | 1 +
 1 file changed, 1 insertion(+)

diff --git a/C4/Circulation.pm b/C4/Circulation.pm
index 8c10fd8e02..1889f8b35b 100644
--- a/C4/Circulation.pm
+++ b/C4/Circulation.pm
@@ -3475,6 +3475,7 @@ sub GetTransfersFromTo {
         FROM   branchtransfers
         WHERE  frombranch=?
           AND  tobranch=?
+          AND datesent IS NOT NULL
           AND datearrived IS NULL
     ";
     my $sth = $dbh->prepare($query);
-- 
2.20.1