using Kingdee.BOS;
using Kingdee.BOS.App.Data;
using Kingdee.BOS.Contracts;
using Kingdee.BOS.Contracts.Report;
using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
using Kingdee.BOS.Core.List;
using Kingdee.BOS.Core.Report;
using Kingdee.BOS.Orm.DataEntity;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Kingdee.BOS.ServiceHelper;
using Kingdee.BOS.Util;
using Newtonsoft.Json;
using ZD.Cloud.Logger;

namespace Demo.Report
{
    /// <summary>
    /// 及时率报表
    /// </summary>
    [Description("及时率报表")]
    [HotUpdate]
    public class prd_TimelinessRateReport : SysReportBaseService
    {

        public override void Initialize()
        {
            base.Initialize();
            // 简单账表类型：普通、树形、分页
            this.ReportProperty.ReportType = ReportType.REPORTTYPE_NORMAL;
            this.IsCreateTempTableByPlugin = true;
            //取代码中配置的列
            this.ReportProperty.IsUIDesignerColumns = false;
            //是否分组汇总
            this.ReportProperty.IsGroupSummary = true;
            this.ReportProperty.PrimaryKeyFieldName = "FIDENTITYID";
        }

        public override ReportHeader GetReportHeaders(IRptParams filter)
        {
            ReportHeader header = new ReportHeader();
            header.AddChild("FIDENTITYID", new LocaleValue("序号"), SqlStorageType.SqlInt).ColIndex = 1;
            header.AddChild("FHDATE", new LocaleValue("提料计划日期", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar).ColIndex = 1;
            header.AddChild("FHSOURCEBILLNO", new LocaleValue("生产订单编号", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar).ColIndex = 2;
            header.AddChild("FSOURCENAME", new LocaleValue("生产线"), SqlStorageType.Sqlvarchar).ColIndex = 3;
            header.AddChild("FSUPPLIERNUMBER", new LocaleValue("供应商编码", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar).ColIndex = 4;
            header.AddChild("FSUPPLIERNAME", new LocaleValue("供应商名称", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar).ColIndex = 5;
            header.AddChild("FMATERIALNUMBER2", new LocaleValue("产品编码"), SqlStorageType.Sqlvarchar).ColIndex = 6;
            header.AddChild("FMATERIALNAME2", new LocaleValue("产品名称"), SqlStorageType.Sqlvarchar).ColIndex = 7;
            header.AddChild("FSPECIFICATION2", new LocaleValue("产品规格"), SqlStorageType.Sqlvarchar).ColIndex = 8;
            header.AddChild("FMATERIALNUMBER", new LocaleValue("原材料编码", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar).ColIndex = 9;
            header.AddChild("FMATERIALNAME", new LocaleValue("原材料名称", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar).ColIndex = 10;
            header.AddChild("FSPECIFICATION", new LocaleValue("原材料规格", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar).ColIndex = 11;
            header.AddChild("FHQTY", new LocaleValue("订单数量", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal).ColIndex = 11;
            header.AddChild("FREALQTY", new LocaleValue("实际到货数量", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal).ColIndex = 11;
            header.AddChild("FRKDATE", new LocaleValue("实际到货时间", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar).ColIndex = 12;
            header.AddChild("FTYPE", new LocaleValue("类型", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar).ColIndex = 12;
            header.AddChild("FJSRATE", new LocaleValue("到货及时率", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal).ColIndex = 12;
            header.AddChild("FTQCOUNT", new LocaleValue("拖期数量", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal).ColIndex = 13;
            return header;
        }

        public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)
        {
            base.BuilderReportSqlAndTempTable(filter, tableName);
            DynamicObject customFil = filter.FilterParameter.CustomFilter;
            string FProductLine = ""; //生产线
            string FMaterialID = ""; //物料
            string FSupplyID = ""; //供应商

            string FBeginDATE = customFil["FBeginDATE"]?.ToString();
            string FEndDATE = customFil["FEndDATE"]?.ToString();
            string FMoBillNo = customFil["FMoBillNo"]?.ToString();

            if (((DynamicObject)customFil["FMaterialID"]) != null)
            {
                FMaterialID = ((DynamicObject)customFil["FMaterialID"])["Id"].ToString();
            }
            if (((DynamicObject)customFil["FProductLine"]) != null)
            {
                FProductLine = ((DynamicObject)customFil["FProductLine"])["Id"].ToString();
            }
            if (((DynamicObject)customFil["FSupplyID"]) != null)
            {
                FSupplyID = ((DynamicObject)customFil["FSupplyID"])["Id"].ToString();
            }
            string sql = string.Format($"/*dialect*/ EXEC pr_TimelinessRateReport '{tableName}','{FBeginDATE}','{FEndDATE}','{FMoBillNo}','{FProductLine}','{FSupplyID}','{FMaterialID}'");
            LogHelper.Info(sql);
            DBUtils.Execute(this.Context, sql);
        }
        public override ReportTitles GetReportTitles(IRptParams filter)
        {
            var result = base.GetReportTitles(filter);
            DynamicObject dyFilter = filter.FilterParameter.CustomFilter;
            if (dyFilter != null)
            {
                if (result == null)
                {
                    result = new ReportTitles();
                }
            }
            var begindate = dyFilter["FBeginDATE"]?.ToString() ?? "1990-01-01 00:00:00";
            var enddate = dyFilter["FEndDATE"]?.ToString() ?? "9999 - 01 - 01 00:00:00";
            var FMoBillNo = dyFilter["FMoBillNo"]?.ToString() ?? "";
            var FProductLine = (dyFilter["FProductLine"] as DynamicObject)?["Name"].ToString() ?? "";
            var FSupplyID = (dyFilter["FSupplyID"] as DynamicObject)?["Name"].ToString() ?? "";
            var FMaterialID = (dyFilter["FMaterialID"] as DynamicObject)?["Name"].ToString() ?? "";
            result.AddTitle("FBeginDATE", begindate);
            result.AddTitle("FEndDATE", enddate);
            result.AddTitle("FMoBillNo", FMoBillNo);
            result.AddTitle("FProductLine", FProductLine);
            result.AddTitle("FSupplyID", FSupplyID);
            result.AddTitle("FMaterialID", FMaterialID);
            return result;

        }
    }
}