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"`       // 生产车间编号
	FBatchNo   string  `gorm:"column:FBatchNo" json:"FBatchNo"`     // 批号
	FStockNo   string  `gorm:"column:FStockNo" json:"FStockNo"`     // 仓库代码
	FStockName string  `gorm:"column:FStockName" json:"FStockName"` // 仓库名称
	FUnit      string  `gorm:"column:FUnit" json:"FUnit"`           // 基本计量单位
	FUnitQty   float64 `gorm:"column:FUnitQty" json:"FUnitQty"`     // 基本计量单位数量
	FSec       string  `gorm:"column:FSec" json:"FSec"`             // 常用计量单位
	FQty       float64 `gorm:"column:FQty" json:"FQty"`             // 常用计量单位数量
}

func ICInventory() []Inventory {
	sql := `
	SELECT
		TOP (100) PERCENT item.FNumber AS FNumber,
		item.FName AS FName,
		item.FModel AS FModel,
		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
	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)
	ORDER BY
		item.FNumber
	`
	var result []Inventory

	db.Raw(sql).Scan(&result)
	//db.Raw(sql).Debug().Scan(&result)

	// 打印列名称测试
	//rows, _ := db.Raw(sql).Debug().Rows()
	//fmt.Println(rows.Columns())

	return result
}