From cab6eea89a0d82710369604ecb51f1cdb122e433 Mon Sep 17 00:00:00 2001
From: zhangqian <zhangqian@123.com>
Date: 星期四, 19 十月 2023 17:26:34 +0800
Subject: [PATCH] fix

---
 model/procedures.go |   45 ++++++++++++++++++++-------------------------
 1 files changed, 20 insertions(+), 25 deletions(-)

diff --git a/model/procedures.go b/model/procedures.go
index c4229a3..4c93059 100644
--- a/model/procedures.go
+++ b/model/procedures.go
@@ -6,24 +6,23 @@
 	"apsClient/pkg/sqlitex"
 	"encoding/json"
 	"fmt"
-	"gorm.io/gorm"
-	"gorm.io/gorm/clause"
+	"github.com/jinzhu/gorm"
 )
 
 type (
 	Procedures struct {
-		gorm.Model     `json:"-"`
-		ID             int    `gorm:"primarykey"`
-		WorkOrderID    string `gorm:"index;type:varchar(191);not null;comment:宸ュ崟ID" json:"-"`
-		OrderID        string `gorm:"index;type:varchar(191);not null;comment:璁㈠崟ID" json:"-"`
-		DeviceID       string `gorm:"index;type:varchar(191);comment:璁惧ID" json:"deviceId"`
-		ProcedureID    string `gorm:"index;type:varchar(191);comment:宸ュ簭ID" json:"procedureId"`
-		Channel        int32  `gorm:"index;comment:閫氶亾" json:"channel"` //閫氶亾
-		StartTime      int64  `gorm:"comment:璁″垝寮�濮嬫椂闂�" json:"startTime"`
-		EndTime        int64  `gorm:"comment:璁″垝缁撴潫鏃堕棿" json:"endTime"`
-		Status         ProcedureStatus
-		ProcedureData  string                  `json:"-"`                  //common.ProductProcedure  json涓�
-		ProceduresInfo common.ProductProcedure `json:"procedure" gorm:"-"` //common.ProductProcedure  瀵硅薄
+		gorm.Model
+		WorkOrderID        string `gorm:"index;type:varchar(191);not null" json:"-"`
+		OrderID            string `gorm:"index;type:varchar(191);not null" json:"-"`
+		DeviceID           string `gorm:"index;type:varchar(191)" json:"deviceId"`
+		ProcedureID        string `gorm:"index;type:varchar(191)" json:"procedureId"`
+		Channel            int32  `gorm:"index;" json:"channel"`            //閫氶亾
+		ProcessModelNumber string `gorm:"index;" json:"processModelNumber"` //宸ヨ壓妯″瀷缂栧彿
+		StartTime          int64  `json:"startTime"`
+		EndTime            int64  `json:"endTime"`
+		Status             ProcedureStatus
+		ProcedureData      string                  `json:"-"`                  //common.ProductProcedure  json涓�
+		ProceduresInfo     common.ProductProcedure `json:"procedure" gorm:"-"` //common.ProductProcedure  瀵硅薄
 	}
 
 	ProceduresSearch struct {
@@ -105,7 +104,7 @@
 	return slf
 }
 
-func (slf *ProceduresSearch) SetId(id int) *ProceduresSearch {
+func (slf *ProceduresSearch) SetId(id uint) *ProceduresSearch {
 	slf.ID = id
 	return slf
 }
@@ -137,11 +136,6 @@
 
 func (slf *ProceduresSearch) SetChannels(channels []int32) *ProceduresSearch {
 	slf.Channels = channels
-	return slf
-}
-
-func (slf *ProceduresSearch) SetChannel(channel int32) *ProceduresSearch {
-	slf.Channel = channel
 	return slf
 }
 
@@ -185,7 +179,7 @@
 	}
 
 	if len(slf.ProcedureIds) > 0 {
-		db = db.Where("procedure_id in ?", slf.ProcedureIds)
+		db = db.Where("procedure_id IN (?)", slf.ProcedureIds)
 	}
 
 	if slf.ProcedureID != "" {
@@ -193,7 +187,7 @@
 	}
 
 	if len(slf.Channels) > 0 {
-		db = db.Where("channel in ?", slf.Channels)
+		db = db.Where("channel IN (?)", slf.Channels)
 	}
 
 	return db
@@ -226,10 +220,11 @@
 	old, err := slf.First()
 	if err != gorm.ErrRecordNotFound && old.ID != 0 {
 		record.ID = old.ID
+		err = db.Save(&record).Error
+	} else {
+		err = db.Create(&record).Error
 	}
-	if err := db.Clauses(clause.OnConflict{
-		UpdateAll: true,
-	}).Create(&record).Error; err != nil {
+	if err != nil {
 		return fmt.Errorf("save err: %v, record: %+v", err, record)
 	}
 

--
Gitblit v1.8.0