package kingdee

type ICBom struct {
	FInterID         int     // 内码
	FBOMNumber       string  // BOM单编号
	FUseStatus       int     // 使用状态码
	FUseStatusName   string  // 使用状态
	FItemIDNumber    string  // 物料代码
	FItemIDName      string  // 物料名称
	FModel           string  // 规格型号
	FErpClsID        string  // 物料属性
	FQty             float64 // 数量
	FUnitName        string  // 单位
	FYield           float64 // 成品率
	FRoutingIDNumber string  // 工艺路线代码
	FRoutingIDName   string  // 工艺路线名称
	FNote            string  // 备注
	FBomType         int     // BOM类型
	FAudDate         string  // 更新时间
	FPDMImportDate   string  // 导入时间
	FStatus          int     // 状态
}

func BomList(fData bool) []ICBom {
	sql := `
	SELECT 
		ICBom.FInterID, 
		ICBom.FBOMNumber, 
		ICBom.FUseStatus, 
		t_SubMessage.FName as FUseStatusName, 
		t_ICItem.FNumber as FItemIDNumber, 
		t_ICItem.FName as FItemIDName, 
		t_ICItem.FModel as FModel,
		(SELECT FName FROM t_SubMessage WHERE t_ICItem.FErpClsID=FInterID) as FErpClsID, 
		ICBom.FQty,
		t_MeasureUnit.FName as FUnitName, 
		ICBom.FYield, 
		t_Routing.FBillNO as FRoutingIDNumber, 
		t_Routing.FRoutingName as FRoutingIDName, 		
		ICBom.FNote, 		
		ICBom.FBomType, 
		ICBom.FAudDate, 
		ICBom.FPDMImportDate, 
		ICBom.FStatus
	 FROM ICBom 
		left join t_SubMessage on ICBom.FUseStatus = t_SubMessage.FInterID AND t_SubMessage.FInterID <> 0  
		join t_ICItem on ICBom.FItemID= t_ICItem.FItemID  AND t_ICItem.FItemID <> 0  
		left join t_MeasureUnit on ICBom.FUnitID = t_MeasureUnit.FItemID AND t_MeasureUnit.FItemID <> 0  
		left join t_Routing on ICBom.FRoutingID = t_Routing.FInterID AND t_Routing.FInterID <> 0
	`

	// 如果不是请求全部数据, 仅查询当天更新的, 默认查当天
	if !fData {
		sql = sql + " Where DateDiff(dd,FAudDate,getdate())=1"
	}

	var result []ICBom

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

	return result
}