From ff09936bddc6bd2672e51552b1fd02fa5d37665f 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. Signed-off-by: Cedric Vita --- C4/Acquisition.pm | 1 + 1 file changed, 1 insertion(+) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index b9f6a50..76d9986 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -1924,6 +1924,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