From 0ddbf564f6e2a33c4f73141423ad0905da4278d0 Mon Sep 17 00:00:00 2001
From: zhangqian <zhangqian@123.com>
Date: 星期五, 19 四月 2024 16:36:33 +0800
Subject: [PATCH] 增加查询字段接口，保存字典接口
---
service/test/product.go | 18 +++++++++++++++---
1 files changed, 15 insertions(+), 3 deletions(-)
diff --git a/service/test/product.go b/service/test/product.go
index bb19684..f33fa33 100644
--- a/service/test/product.go
+++ b/service/test/product.go
@@ -27,6 +27,7 @@
ShippingDuration: p.ShippingDuration,
Specifications: p.Specifications,
CategoryName: p.CategoryName,
+ ModelNumber: p.ModelNumber,
})
}
@@ -72,7 +73,13 @@
var ps []test.SupplierMaterial
//鎼滅储妗嗗悎涓�娣诲姞鏌ヨ鏉′欢
if info.Keyword != "" {
- db = db.Where("`srm_supplier_material`.name LIKE ?", "%"+info.Keyword+"%").Joins("Supplier").Or("Supplier.name LIKE ?", "%"+info.Keyword+"%")
+ kw := "%" + info.Keyword + "%"
+ if info.SupplierId == 0 {
+ db = db.Where("`srm_supplier_material`.name LIKE ?", kw).Joins("Supplier").Or("Supplier.name LIKE ?", kw)
+ } else {
+ db = db.Where("name LIKE ? OR number LIKE ? OR specifications LIKE ?", kw, kw, kw)
+ }
+
}
if info.Name != "" {
db = db.Where("name LIKE ?", "%"+info.Name+"%")
@@ -81,9 +88,11 @@
db = db.Where("number LIKE ?", "%"+info.Number+"%")
}
+ supplierIds := []uint{0}
if info.SupplierId != 0 {
- db = db.Where("supplier_id = ?", info.SupplierId)
+ supplierIds = append(supplierIds, info.SupplierId)
}
+ db = db.Where("supplier_id in (?)", supplierIds)
err = db.Count(&total).Error
if err != nil {
@@ -118,7 +127,10 @@
db = db.Where("name LIKE ? or id LIKE ?", "%"+info.Keyword+"%", "%"+info.Keyword+"%")
}
- db = db.Where("purchase_type = ?", test.PurchaseTypeOutSource)
+ //绫诲瀷涓洪噰璐�
+ db = db.Where("purchase_types LIKE ?", "%1%")
+
+ db = db.Where("is_storage = ?", 1)
err = db.Count(&total).Error
if err != nil {
--
Gitblit v1.8.0