From 1fd4c0489579ba9ea5adea489538e2b34e3bb7a3 Mon Sep 17 00:00:00 2001
From: zhangqian <zhangqian@123.com>
Date: 星期六, 21 十月 2023 11:10:37 +0800
Subject: [PATCH] add sql log

---
 serf/sqlite.go      |    2 ++
 model/work_order.go |    4 ++++
 2 files changed, 6 insertions(+), 0 deletions(-)

diff --git a/model/work_order.go b/model/work_order.go
index a6ed58a..6d32261 100644
--- a/model/work_order.go
+++ b/model/work_order.go
@@ -127,6 +127,10 @@
 		db = db.Where("work_order_id = ?", slf.WorkOrderID)
 	}
 
+	if len(slf.WorkOrderIDs) != 0 {
+		db = db.Where("work_order_id in (?)", slf.WorkOrderIDs)
+	}
+
 	if slf.Status != 0 {
 		db = db.Where("status = ?", slf.Status)
 	}
diff --git a/serf/sqlite.go b/serf/sqlite.go
index 79021d9..8c83904 100644
--- a/serf/sqlite.go
+++ b/serf/sqlite.go
@@ -1,6 +1,7 @@
 package serf
 
 import (
+	"apsClient/pkg/logx"
 	"errors"
 	"fmt"
 	"regexp"
@@ -93,6 +94,7 @@
 	if level == "sql" {
 		msgArr := gorm.LogFormatter(values...)
 		sql := msgArr[3].(string)
+		logx.Infof("sql: %v", sql)
 		sql = strings.TrimPrefix(sql, " ")
 		if !strings.HasPrefix(sql, "SELECT") && !strings.HasPrefix(sql, "select") && !strings.Contains(sql, "PRAGMA") && !strings.Contains(sql, "pragma") {
 			affected := values[5].(int64)

--
Gitblit v1.8.0