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 ++++++++++++++
 model/test/product.go         |    6 +-
 docs/swagger.yaml             |    6 +++
 api/v1/test/product.go        |    6 +-
 docs/docs.go                  |   10 +++++
 model/test/request/product.go |    1 
 docs/swagger.json             |   10 +++++
 7 files changed, 61 insertions(+), 6 deletions(-)

diff --git a/api/v1/test/product.go b/api/v1/test/product.go
index 937a65c..0cab86a 100644
--- a/api/v1/test/product.go
+++ b/api/v1/test/product.go
@@ -219,11 +219,11 @@
 		productList[k].Number = v.Number
 		productList[k].Name = v.Name
 		productList[k].Unit = v.Unit
-		productList[k].PurchasePrice = &v.SalePrice
+		productList[k].PurchasePrice = v.SalePrice
 		min := int(v.MinInventory)
-		productList[k].MinimumStock = &min
+		productList[k].MinimumStock = min
 		max := int(v.MaxInventory)
-		productList[k].MaximumStock = &max
+		productList[k].MaximumStock = max
 		productList[k].Remark = v.Node
 		productList[k].ProductType = v.MaterialMode
 	}
diff --git a/docs/docs.go b/docs/docs.go
index 74a8c5c..af5297e 100644
--- a/docs/docs.go
+++ b/docs/docs.go
@@ -4419,6 +4419,11 @@
                     },
                     {
                         "type": "string",
+                        "name": "supplierName",
+                        "in": "query"
+                    },
+                    {
+                        "type": "string",
                         "name": "unit",
                         "in": "query"
                     },
@@ -4557,6 +4562,11 @@
                     },
                     {
                         "type": "string",
+                        "name": "supplierName",
+                        "in": "query"
+                    },
+                    {
+                        "type": "string",
                         "name": "unit",
                         "in": "query"
                     },
diff --git a/docs/swagger.json b/docs/swagger.json
index bc3e92b..e3f9579 100644
--- a/docs/swagger.json
+++ b/docs/swagger.json
@@ -4410,6 +4410,11 @@
                     },
                     {
                         "type": "string",
+                        "name": "supplierName",
+                        "in": "query"
+                    },
+                    {
+                        "type": "string",
                         "name": "unit",
                         "in": "query"
                     },
@@ -4548,6 +4553,11 @@
                     },
                     {
                         "type": "string",
+                        "name": "supplierName",
+                        "in": "query"
+                    },
+                    {
+                        "type": "string",
                         "name": "unit",
                         "in": "query"
                     },
diff --git a/docs/swagger.yaml b/docs/swagger.yaml
index bb151bb..3743f11 100644
--- a/docs/swagger.yaml
+++ b/docs/swagger.yaml
@@ -4566,6 +4566,9 @@
         name: supplierId
         type: integer
       - in: query
+        name: supplierName
+        type: string
+      - in: query
         name: unit
         type: string
       - in: query
@@ -4650,6 +4653,9 @@
         name: supplierId
         type: integer
       - in: query
+        name: supplierName
+        type: string
+      - in: query
         name: unit
         type: string
       - in: query
diff --git a/model/test/product.go b/model/test/product.go
index 3b2a757..eba6bcc 100644
--- a/model/test/product.go
+++ b/model/test/product.go
@@ -12,14 +12,14 @@
 	SupplierId       uint     `json:"supplierId" form:"supplierId" gorm:"column:supplier_id;comment:渚涘簲鍟唅d;size:255;"`
 	Supplier         Supplier `json:"supplier" form:"supplier" gorm:"foreignKey:SupplierId;references:ID;comment:渚涘簲鍟�"`
 	Unit             string   `json:"unit" form:"unit" gorm:"column:unit;comment:璁¢噺鍗曚綅;size:255;"`
-	PurchasePrice    *float64 `json:"purchasePrice" form:"purchasePrice" gorm:"column:purchase_price;comment:閲囪喘浠锋牸;"`
+	PurchasePrice    float64  `json:"purchasePrice" form:"purchasePrice" gorm:"column:purchase_price;comment:閲囪喘浠锋牸;"`
 	DeliveryTime     *int     `json:"deliveryTime" form:"deliveryTime" gorm:"column:delivery_time;comment:;size:11;"`
 	ShippingDuration *int     `json:"shippingDuration" form:"shippingDuration" gorm:"column:shipping_duration;comment:鐗╂祦鏃堕暱;size:11;"`
 	Specifications   string   `json:"specifications" form:"specifications" gorm:"column:specifications;comment:瑙勬牸;size:255;"`
 	ModelNumber      string   `json:"modelNumber" form:"modelNumber" gorm:"column:model_number;comment:鍨嬪彿;size:255;"`
 	ProductType      string   `json:"productType" form:"productType" gorm:"column:product_type;comment:浜у搧绫诲埆;size:255;"`
-	MinimumStock     *int     `json:"minimumStock" form:"minimumStock" gorm:"column:minimum_stock;comment:鏈�浣庡簱瀛�;"`
-	MaximumStock     *int     `json:"maximumStock" form:"maximumStock" gorm:"column:maximum_stock;comment:鏈�楂樺簱瀛�;"`
+	MinimumStock     int      `json:"minimumStock" form:"minimumStock" gorm:"column:minimum_stock;comment:鏈�浣庡簱瀛�;"`
+	MaximumStock     int      `json:"maximumStock" form:"maximumStock" gorm:"column:maximum_stock;comment:鏈�楂樺簱瀛�;"`
 	Remark           string   `json:"remark" form:"remark" gorm:"column:remark;comment:澶囨敞;size:255;"`
 }
 
diff --git a/model/test/request/product.go b/model/test/request/product.go
index 2d7e150..9c9389b 100644
--- a/model/test/request/product.go
+++ b/model/test/request/product.go
@@ -8,6 +8,7 @@
 
 type ProductSearch struct {
 	test.Product
+	SupplierName   string     `json:"supplierName" form:"supplierName"`
 	StartCreatedAt *time.Time `json:"startCreatedAt" form:"startCreatedAt"`
 	EndCreatedAt   *time.Time `json:"endCreatedAt" form:"endCreatedAt"`
 	request.PageInfo
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