From 12fd8bc06a50e327892c2ae400b80a3e181c2fa0 Mon Sep 17 00:00:00 2001
From: marina <m.zozirova@gmail.com>
Date: Sat, 27 Apr 2024 16:16:44 +0300
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=20=D0=BF=D1=80?=
 =?utf8?q?=D0=B0=D0=B2=D0=BA=D0=B8?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 erp24/modul/shipment/Functions.php | 11 +++++++++--
 erp24/modul/shipment/clone.php     | 11 +++++++++--
 2 files changed, 18 insertions(+), 4 deletions(-)

diff --git a/erp24/modul/shipment/Functions.php b/erp24/modul/shipment/Functions.php
index 404ae378..663d2d6a 100644
--- a/erp24/modul/shipment/Functions.php
+++ b/erp24/modul/shipment/Functions.php
@@ -166,8 +166,15 @@ $new_id=99999;
 //store_order_status статусы по магазинам - оставляем статусы по магазинам (возможно надо не все статусы оставлять а только статус - уточняем!!!)
 $data=$db::getRows("SELECT * FROM store_order_status WHERE order_id=?",[$OrderId]);
 foreach($data as $row) {
-$insert="INSERT INTO store_order_status (order_id, store_id,  status_id, status, date, admin_id) 
-VALUES ('$new_id', '".$row["store_id"]."', '".$row["status_id"]."', '".$row["status"]."', '".$row["date"]."', '".$row["admin_id"]."')";   
+    $insert = "INSERT INTO store_order_status (order_id, store_id, status_id, status, date, admin_id) 
+    VALUES ('$new_id', '" . $row["store_id"] . "', '" . $row["status_id"] . "', '" . $row["status"] . "', '" . $row["date"] . "', '" . $row["admin_id"] . "')
+    ON CONFLICT (id) DO UPDATE SET 
+        order_id = '$new_id',
+        store_id = " . $row["store_id"] . ",  
+        status_id = " . $row["status_id"] . ", 
+        status = '" . $row["status"] . "', 
+        date = '" . $row["date"] . "',
+        admin_id = " . $row["admin_id"] . ";";
 //echo"<br>+ $insert"; 
 // $db::sql($insert);
 }
diff --git a/erp24/modul/shipment/clone.php b/erp24/modul/shipment/clone.php
index 6afb36ec..5c176a43 100644
--- a/erp24/modul/shipment/clone.php
+++ b/erp24/modul/shipment/clone.php
@@ -141,8 +141,15 @@ echo"<b>$where</b>";
 
 $data=$db::getRows("SELECT * FROM store_order_status WHERE order_id=? $where ",[$OrderId]);
 foreach($data as $row) {
-$insert="INSERT INTO store_order_status (order_id, store_id,  status_id, status, date, admin_id) 
-VALUES ('$new_id', '".$row["store_id"]."', '".$row["status_id"]."', '".$row["status"]."', '".$row["date"]."', '".$row["admin_id"]."')";   
+    $insert = "INSERT INTO store_order_status (order_id, store_id, status_id, status, date, admin_id) 
+    VALUES ('$new_id', '" . $row["store_id"] . "', '" . $row["status_id"] . "', '" . $row["status"] . "', '" . $row["date"] . "', '" . $row["admin_id"] . "')
+    ON CONFLICT (id) DO UPDATE SET 
+        order_id = '$new_id',
+        store_id = " . $row["store_id"] . ",  
+        status_id = " . $row["status_id"] . ", 
+        status = '" . $row["status"] . "', 
+        date = '" . $row["date"] . "',
+        admin_id = " . $row["admin_id"] . ";";
 //echo"<br>+ $insert"; 
  $db::sql($insert);
 }
-- 
2.39.5