From ab843c5631c7d94633f7598a17eee7d1ffc94449 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 23 Apr 2013 15:30:11 +0200 Subject: [PATCH] Bug 5336: Late orders search: don't display deleted order. Test plan: Check that deleted orders are not listed in the late orders search results. --- C4/Acquisition.pm | 1 + 1 file changed, 1 insertion(+) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index c334afd..9ad941a 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -2006,6 +2006,7 @@ sub GetLateOrders { $from .= ' AND borrowers.branchcode LIKE ? '; push @query_params, C4::Context->userenv->{branch}; } + $from .= " AND orderstatus <> 4 "; my $query = "$select $from $having\nORDER BY latesince, basketno, borrowers.branchcode, supplier"; $debug and print STDERR "GetLateOrders query: $query\nGetLateOrders args: " . join(" ",@query_params); my $sth = $dbh->prepare($query); -- 1.7.10.4