From 895e19919f689bd00ac24a14c6cd764239cb892f Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 23 Apr 2013 15:30:11 +0200 Subject: [PATCH] Bug 5336: (follow-up) don't display deleted orders in late orders search result Test plan: Check that deleted orders are not listed in the late orders search results. Signed-off-by: Cedric Vita Signed-off-by: Pierre Angot Signed-off-by: Katrin Fischer Signed-off-by: Galen Charlton --- C4/Acquisition.pm | 1 + 1 file changed, 1 insertion(+) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index 0244675676..aa0f9ebc83 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -1944,6 +1944,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); -- 2.11.0