From c965651da313fa6b41d0f07d7910824c57582cae Mon Sep 17 00:00:00 2001
From: lishihai <dslsh@dscom>
Date: 星期三, 26 六月 2024 11:55:18 +0800
Subject: [PATCH] 库存盘点应用按钮记录创建人,创建时间,应用时间、应用人员等信息;根据条形码查询产品详情;新增编辑产品增加条形码字段->添加条形码被使用验证

---
 models/month_stats.go |   12 +++++++++++-
 1 files changed, 11 insertions(+), 1 deletions(-)

diff --git a/models/month_stats.go b/models/month_stats.go
index 7d73f36..64e1111 100644
--- a/models/month_stats.go
+++ b/models/month_stats.go
@@ -177,7 +177,8 @@
 	}
 
 	if slf.Keyword != "" {
-		db = db.Where("product_name like ?", fmt.Sprintf("%%%v%%", slf.Keyword))
+		kw := fmt.Sprintf("%%%v%%", slf.Keyword)
+		db = db.Where("product_id like ? or product_name like ?", kw, kw)
 	}
 
 	if slf.Date != "" {
@@ -346,3 +347,12 @@
 	}
 	return m
 }
+
+func (slf *MonthStatsSearch) Count() (int64, error) {
+	var (
+		total int64
+		db    = slf.build()
+	)
+	err := db.Count(&total).Error
+	return total, err
+}

--
Gitblit v1.8.0