package kingdee

import (
	"fmt"
	"strings"
)

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

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, ICBom.FAudDate, getdate())=1"
	}

	var result []ICBom

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

	return result
}

type ICBomChild struct {
	FInterID          int     `gorm:"column:FInterID" json:"FInterID"`                   // 所属BOM内码
	FBOMNumber        string  `gorm:"column:FBOMNumber" json:"FBOMNumber"`               // 所属BOM单编号
	FEntryID          int     `gorm:"column:FEntryID" json:"FEntryID"`                   // 顺序号
	FItemIDNumber     string  `gorm:"column:FItemIDNumber" json:"FItemIDNumber"`         // 物料代码
	FItemIDName       string  `gorm:"column:FItemIDName" json:"FItemIDName"`             // 物料名称
	FModel            string  `gorm:"column:FModel" json:"FModel"`                       // 规格型号
	FErpClsID         string  `gorm:"column:FErpClsID" json:"FErpClsID"`                 // 物料属性
	FMaterielTypeName string  `gorm:"column:FMaterielTypeName" json:"FMaterielTypeName"` // 子项类型
	FMarshalTypeName  string  `gorm:"column:FMarshalTypeName" json:"FMarshalTypeName"`   // 配置属性
	FQty              float64 `gorm:"column:FQty" json:"FQty"`                           // 数量
	FUnitName         string  `gorm:"column:FUnitName" json:"FUnitName"`                 // 单位
	FPercent          float64 `gorm:"column:FPercent" json:"FPercent"`                   // 计划百分比
	FBackFlushNumber  string  `gorm:"column:FBackFlushNumber" json:"FBackFlushNumber"`   // 是否倒冲代码
	FBackFlushName    string  `gorm:"column:FBackFlushName" json:"FBackFlushName"`       // 是否倒
	FUseState         string  `gorm:"column:FUseState" json:"FUseState"`                 // 使用状态
	FStockIDNumber    string  `gorm:"column:FStockIDNumber" json:"FStockIDNumber"`       // 仓库代码
	FStockIDName      string  `gorm:"column:FStockIDName" json:"FStockIDName"`           // 仓库名称
	FPDMImportDate    string  `gorm:"column:FPDMImportDate" json:"FPDMImportDate"`       // 导入时间
}

func BomChild(bomNumber []string) []ICBomChild {
	sql := `
	SELECT ICBomChild.FInterID,
		ICBOM.FBOMNumber,
		ICBomChild.FEntryID,
		t_ICItem.FNumber as  FItemIDNumber,
		t_ICItem.FName as FItemName,
		t_ICItem.FModel as FModel,
		(SELECT FName FROM t_SubMessage WHERE t_ICItem.FErpClsID=FInterID) as FErpCls,
		t010.FName as FMaterielTypeName,
		t011.FName as FMarshalTypeName,
		ICBomChild.FQty,
		t_MeasureUnit.FName as FUnitName,
		ICBomChild.FPercent,
		t012.FID as FBackFlushNumber,
		t012.FName as FBackFlushName,
		(SELECT FName FROM t_SubMessage WHERE t_ICItem.FUseState=FInterID) as FUseState,
		t_Stock.FNumber as FStockIDNumber,
		t_Stock.FName as FStockIDName,
		ICBomChild.FPDMImportDate
	FROM ICBomChild 
		join t_ICItem on t_ICItem.FItemID = ICBomChild.FItemID AND t_ICItem.FItemID <>0
		left join ICBOM on ICBOM.FInterID = ICBomChild.FInterID  AND ICBOM.FInterID<>0
		left join t_MeasureUnit on t_MeasureUnit.FItemID = t_ICItem.FUnitID  AND t_MeasureUnit.FItemID<>0
		left join t_SubMessage  t010 on t010.FInterID = ICBomChild.FMaterielType AND t010.FInterID <>0
		left join t_SubMessage  t011 on t011.FInterID = ICBomChild.FMarshalType AND t011.FInterID <>0
		left join t_SubMessage  t012 on t012.FInterID = ICBomChild.FBackFlush AND t012.FInterID <>0
		left join t_Stock on t_Stock.FItemID = ICBomChild.FStockID AND t_Stock.FItemID <>0
	`

	// 按bom查询
	if bomNumber != nil {
		sql = fmt.Sprintf("%s WHERE ICBOM.FBOMNumber in('%s')", sql, strings.Join(bomNumber, "','"))
	}

	var result []ICBomChild

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

	return result
}