From cc29e51892a29449cb28398ca961378d2100d6cc 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 Signed-off-by: Pierre Angot --- C4/Acquisition.pm | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index a30f89c..115dfe5 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -1992,6 +1992,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.2.5