From 1ae2ab7b60ef374c77eebc08d63759a98f625066 Mon Sep 17 00:00:00 2001
From: liujiandao <274878379@qq.com>
Date: 星期五, 15 三月 2024 10:10:43 +0800
Subject: [PATCH] crm查询采购信息
---
service/test/product.go | 10 +++++++---
1 files changed, 7 insertions(+), 3 deletions(-)
diff --git a/service/test/product.go b/service/test/product.go
index 8ad82b5..57ad6d9 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,
})
}
@@ -90,7 +91,7 @@
return
}
- err = db.Limit(limit).Offset(offset).Preload("Supplier").Find(&ps).Error
+ err = db.Limit(limit).Offset(offset).Order("id desc").Preload("Supplier").Find(&ps).Error
return ps, total, err
}
@@ -115,10 +116,13 @@
db := global.GVA_DB.Model(&test.Material{})
var ps []test.Material
if info.Keyword != "" {
- db = db.Where("name LIKE ? or number LIKE ?", "%"+info.Name+"%", "%"+info.Number+"%")
+ 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