From a7a842b30253d5e91f2a37ea8be4fa64cf4ac9ea Mon Sep 17 00:00:00 2001
From: wangpengfei <274878379@qq.com>
Date: 星期三, 30 八月 2023 20:13:47 +0800
Subject: [PATCH] fix
---
service/test/product.go | 28 ++++++++++++++++++++++++++++
1 files changed, 28 insertions(+), 0 deletions(-)
diff --git a/service/test/product.go b/service/test/product.go
index daabad4..0adb9f8 100644
--- a/service/test/product.go
+++ b/service/test/product.go
@@ -71,6 +71,34 @@
db = db.Where("supplier_id = ?", info.SupplierId)
}
+ if info.MaximumStock != 0 {
+ db = db.Where("maximum_stock = ?", info.MaximumStock)
+ }
+
+ if info.MinimumStock != 0 {
+ db = db.Where("minimum_stock = ?", info.MinimumStock)
+ }
+
+ if info.PurchasePrice != 0 {
+ db = db.Where("purchase_price = ?", info.PurchasePrice)
+ }
+
+ if info.Specifications != "" {
+ db = db.Where("specifications LIKE ?", "%"+info.Specifications+"%")
+ }
+
+ if info.ModelNumber != "" {
+ db = db.Where("model_number LIKE ?", "%"+info.ModelNumber+"%")
+ }
+
+ if info.ProductType != "" {
+ db = db.Where("product_type LIKE ?", "%"+info.ProductType+"%")
+ }
+
+ if info.SupplierName != "" {
+ db = db.Joins("Supplier").Where("Supplier.name LIKE ?", "%"+info.SupplierName+"%")
+ }
+
err = db.Count(&total).Error
if err != nil {
return
--
Gitblit v1.8.0