From 4cc228eac8f84a628f796a1e0bb3a32b3556d324 Mon Sep 17 00:00:00 2001 From: Mark Tompsett Date: Fri, 1 Sep 2017 21:23:20 -0400 Subject: [PATCH] Bug 19120: Leave cancelled ordered items alone when reopening basket TEST PLAN --------- 1) Apply first patch 2) prove t/db_dependent/Acquisition/close_reopen_basket.t -- FAILS 3) Apply this patch 4) prove t/db_dependent/Acquisition/close_reopen_basket.t -- SUCCESS! 5) run koha qa test tools Followed test plan, patch worked as described Signed-off-by: Alex Buckley Signed-off-by: Julian Maurice --- C4/Acquisition.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index 7639fef9dc..950498e83a 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -264,7 +264,7 @@ sub ReopenBasket { UPDATE aqorders SET orderstatus = 'new' WHERE basketno = ? - AND orderstatus != 'complete' + AND orderstatus NOT IN ( 'complete', 'cancelled' ) }, {}, $basketno); return; } -- 2.11.0