From 86530fe51ee65aea39e07e8fa131bf6e3310c4b0 Mon Sep 17 00:00:00 2001
From: lishihai <dslsh@dscom>
Date: 星期五, 14 六月 2024 17:04:13 +0800
Subject: [PATCH] 属性值和对象-AttributeValue-wms_attribute_value-的ID查询和LIST分页查询
---
controllers/product_controller.go | 6 +++++-
1 files changed, 5 insertions(+), 1 deletions(-)
diff --git a/controllers/product_controller.go b/controllers/product_controller.go
index a99ac83..606e381 100644
--- a/controllers/product_controller.go
+++ b/controllers/product_controller.go
@@ -480,6 +480,7 @@
OperationDate: time.Now().Format("2006-01-02 15:04:05"),
Details: []*models.OperationDetails{detail},
BaseOperationType: constvar.BaseOperationTypeDisuse,
+ OperationTypeName: "搴撳瓨鎶ュ簾",
}
if err := models.NewOperationSearch().Create(&operation); err != nil {
logx.Errorf("Operation create err: %v", err)
@@ -509,7 +510,10 @@
db := models.NewOperationSearch().Orm.
Table("wms_operation").
- Select("wms_operation.id,wms_operation.number,wms_operation.source_number,wms_operation.status,wms_operation_details.from_location_id,wms_operation_details.to_location_id,wms_operation.operation_date,wms_operation.contacter_id,wms_operation.contacter_name,wms_operation.company_id,wms_operation.company_name,wms_operation.comment,wms_operation_details.product_id,material.name as product_name,material.unit,wms_operation_details.amount,wms_operation.base_operation_type").
+ Select("wms_operation.id,wms_operation.number,wms_operation.source_number,wms_operation.status,wms_operation_details.from_location_id,"+
+ "wms_operation_details.to_location_id,wms_operation.operation_date,wms_operation.contacter_id,wms_operation.contacter_name,"+
+ "wms_operation.company_id,wms_operation.company_name,wms_operation.comment,wms_operation_details.product_id,"+
+ "material.name as product_name,material.unit,wms_operation_details.amount,wms_operation.base_operation_type").
InnerJoins("inner join wms_operation_details on wms_operation_details.operation_id=wms_operation.id").
InnerJoins("inner join material on material.id=wms_operation_details.product_id").
Where("wms_operation.base_operation_type=?", constvar.BaseOperationTypeDisuse)
--
Gitblit v1.8.0