From 7b27ff2fdeafa0acfb34257dbe4080bacacb4147 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Mon, 5 Feb 2018 15:36:27 -0300
Subject: [PATCH] Bug 20144: [sql_modes] Set default value for
 aqbasket.is_standing

Fix for:
Column 'is_standing' cannot be null

t/db_dependent/Koha/Acquisition/Booksellers.t

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
---
 C4/Acquisition.pm | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm
index 15a51dd81b..d7f0e25e56 100644
--- a/C4/Acquisition.pm
+++ b/C4/Acquisition.pm
@@ -607,6 +607,8 @@ case the AcqCreateItem syspref takes precedence).
 
 sub ModBasketHeader {
     my ($basketno, $basketname, $note, $booksellernote, $contractnumber, $booksellerid, $deliveryplace, $billingplace, $is_standing, $create_items) = @_;
+
+    $is_standing ||= 0;
     my $query = qq{
         UPDATE aqbasket
         SET basketname=?, note=?, booksellernote=?, booksellerid=?, deliveryplace=?, billingplace=?, is_standing=?, create_items=?
-- 
2.39.5