From 82c058c91daed212fd9b3807dca9ca80217ce738 Mon Sep 17 00:00:00 2001
From: wangpengfei <274878379@qq.com>
Date: 星期三, 30 八月 2023 20:25:01 +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..f98b2ed 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.SupplierNumber != "" {
+ db = db.Joins("Supplier").Where("Supplier.number LIKE ?", "%"+info.SupplierNumber+"%")
+ }
+
err = db.Count(&total).Error
if err != nil {
return
--
Gitblit v1.8.0