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