From ff3cadba4a63cd1b63cd0e36358f49ccedb88bef Mon Sep 17 00:00:00 2001
From: gigibox <gigibox@163.com>
Date: 星期四, 15 六月 2023 10:02:20 +0800
Subject: [PATCH] 完成基本功能
---
kingdee/seOrder.go | 16 +++++++++++++---
1 files changed, 13 insertions(+), 3 deletions(-)
diff --git a/models/seOrder.go b/kingdee/seOrder.go
similarity index 86%
rename from models/seOrder.go
rename to kingdee/seOrder.go
index a1c2f27..297555d 100644
--- a/models/seOrder.go
+++ b/kingdee/seOrder.go
@@ -1,4 +1,4 @@
-package models
+package kingdee
// 閿�鍞鍗曡〃
type SEOrder struct {
@@ -16,6 +16,7 @@
FCess float64 `gorm:"column:FCess" json:"FCess"` // 绋庣巼
FNote string `gorm:"column:FNote" json:"FNote"` // 澶囨敞
FAdviceConsignDate string `gorm:"column:FAdviceConsignDate" json:"FAdviceConsignDate"` // 浜よ揣鏃ユ湡
+ Fdate string `gorm:"column:Fdate" json:"Fdate"` // 璁㈠崟鏃ユ湡
FCustID string `gorm:"column:FCustID" json:"FCustID"` // 璐揣鍗曚綅
FInventory float64 `gorm:"column:FInventory" json:"FInventory"` // 鍗虫椂搴撳瓨
// 鍚◣鍗曚环
@@ -40,11 +41,15 @@
i.FCess,
i.FNote,
i.FAdviceConsignDate,
+ i.Fdate,
i.FCustID,
SUM(ICInventory.FQty) AS FInventory
- FROM vwICBill_32 AS i
+ FROM
+ vwICBill_32 AS i
JOIN t_ICitem ON i.FShortNumber = t_ICitem.FShortNumber
JOIN ICInventory ON ICInventory.FItemID = t_ICitem.FItemID
+ WHERE
+ DateDiff(dd,fDate,getdate())=0
GROUP BY
i.FBillNo,
i.FNumber,
@@ -60,11 +65,16 @@
i.FCess,
i.FNote,
i.FAdviceConsignDate,
+ i.Fdate,
i.FCustID;
`
+
+ //鏌ヨ褰撳ぉ鏃ユ湡
+ //select * from vwICBill_32 where DateDiff(dd,fDate,getdate())=0
var result []SEOrder
- db.Raw(sql).Debug().Scan(&result)
+ db.Raw(sql).Scan(&result)
+ //db.Raw(sql).Debug().Scan(&result)
return result
}
--
Gitblit v1.8.0