From e41b9d0714708e767248cd1b0682767499c15f9a Mon Sep 17 00:00:00 2001
From: Marina Zozirova <marina.zozirova@erp-flowers.ru>
Date: Sat, 27 Apr 2024 12:41:32 +0000
Subject: [PATCH] =?utf8?q?insert=20ignore=20c=20mysql=20=D0=BF=D0=B5=D1=80?=
 =?utf8?q?=D0=B5=D0=B2=D0=B5=D0=B4=D0=B5=D0=BD=20postgresql?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 erp24/modul/shipment/shipment.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/erp24/modul/shipment/shipment.php b/erp24/modul/shipment/shipment.php
index 83c1078..f3ddcef 100644
--- a/erp24/modul/shipment/shipment.php
+++ b/erp24/modul/shipment/shipment.php
@@ -20,7 +20,7 @@ if(!empty($_REQUEST["id"])) { $orderId=(int)$_REQUEST["id"]; } else exit("Ука
 // измененеи статуса заказа
 if(!empty($_POST["edit_status"]) and !empty($_REQUEST["id"])) {
 $db::sql("UPDATE store_orders SET status=? WHERE id=?",[(int)$_POST["status_new"],$orderId]);
-$db::sql("INSERT IGNORE INTO  store_order_status_log (status, order_id, date, admin_id) VALUES (?,?,NOW(),?)",[(int)$_POST["status_new"],$orderId, $_SESSION["admin_id"]]);
+$db::sql('INSERT INTO store_order_status_log (status, order_id, date, admin_id) VALUES (' . (int)$_POST["status_new"] . ', ' . (int)$orderId . ', NOW(), ' . $_SESSION["admin_id"] . ') ON CONFLICT (id) DO UPDATE SET status = ' . (int)$_POST["status_new"] . ', order_id = ' . (int)$orderId . ', date = NOW(), admin_id = ' . $_SESSION["admin_id"]);
 
 mess("Статус изменен");    
 }
-- 
2.39.5