From 1873461012c99801f364bd07fae2c218d245048e Mon Sep 17 00:00:00 2001
From: zhangzengfei <zhangzengfei@smartai.com>
Date: 星期一, 11 九月 2023 19:42:39 +0800
Subject: [PATCH] 修复bom第一启动时的全量上报
---
kingdee/icInventory.go | 15 +++++++++++----
1 files changed, 11 insertions(+), 4 deletions(-)
diff --git a/kingdee/icInventory.go b/kingdee/icInventory.go
index bd824a5..9defbdb 100644
--- a/kingdee/icInventory.go
+++ b/kingdee/icInventory.go
@@ -1,9 +1,13 @@
package kingdee
+// 搴撳瓨鏌ヨ
+
type Inventory struct {
FNumber string `gorm:"column:FNumber" json:"FNumber"` // 鐗╂枡浠ｇ爜
FName string `gorm:"column:FName" json:"FName"` // 鐗╂枡鍚嶇О
FModel string `gorm:"column:FModel" json:"FModel"` // 瑙勬牸鍨嬪彿
+ FSource string `gorm:"column:FSource" json:"FSource"` // 鐢熶骇杞﹂棿缂栧彿
+ FErpCls string `gorm:"column:FErpCls" json:"FErpCls"` // 鐗╂枡灞炴��
FBatchNo string `gorm:"column:FBatchNo" json:"FBatchNo"` // 鎵瑰彿
FStockNo string `gorm:"column:FStockNo" json:"FStockNo"` // 浠撳簱浠ｇ爜
FStockName string `gorm:"column:FStockName" json:"FStockName"` // 浠撳簱鍚嶇О
@@ -19,25 +23,28 @@
TOP (100) PERCENT item.FNumber AS FNumber,
item.FName AS FName,
item.FModel AS FModel,
+ (SELECT FName FROM t_SubMessage WHERE item.FErpClsID=FInterID) as FErpCls,
+ ti1.FNumber AS FSource,
i.FBatchNo AS FBatchNo,
s.FNumber AS FStockNo,
s.FName AS FStockName,
ti.FName AS FUnit,
CONVERT (FLOAT, i.FQty) AS FUnitQty,
ti2.FName AS FSec,
- i.FQty AS FQty
+ i.FQty AS FQty
FROM
ICInventory AS i
LEFT OUTER JOIN t_ICItem AS item ON i.FItemID = item.FItemID
LEFT OUTER JOIN t_Stock AS s ON i.FStockID = s.FItemID
LEFT OUTER JOIN t_Item AS ti ON item.FUnitID = ti.FItemID
+ LEFT OUTER JOIN t_Item AS ti1 ON item.FSource = ti1.FItemID
LEFT OUTER JOIN t_Item AS ti2 ON item.FStoreUnitID = ti2.FItemID
LEFT OUTER JOIN t_Item AS ti3 ON LEFT (item.FNumber, 5) = ti3.FNumber
AND ti3.FItemClassID = 4
- WHERE
- (i.FQty <> 0)
+ --WHERE
+ -- (i.FQty <> 0)
ORDER BY
- item.FNumber
+ item.FNumber
`
var result []Inventory
--
Gitblit v1.8.0