using Rhea.Common;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Tiger.IBusiness;
using Tiger.IBusiness.MES.WorkAction;
using Tiger.Model;
using Tiger.Model.Entitys.MES.Position;

namespace Tiger.Business.MES.WorkAction
{
    public class InputQty : IInputQty
    {
        #region Propertys & Variables
        #region 固定写法，工序中的必要信息
        public DbClient MainDB { get; set; }
        public bool IsFinished { get; set; } = false;
        public IWorkStep CurStep { get; set; }
        public IPosition CurPosition { get; set; }
        public MES_WO_NODE_ACT NodeAct { get; set; }
        public MES_WO_ACTION Setting { get; set; }
        #endregion
        public double NewQty { get; set; }
        public double NewWoInputQty { get; set; }
        public double NewBatchInputQty { get; set; }
        #endregion Propertys & Variables

        #region Functions
        /// <summary>
        /// 初始化工序行为
        /// </summary>
        /// <returns></returns>
        public void Init(IWorkStep curStep, IPosition position, MES_WO_NODE_ACT nodeAct, MES_WO_ACTION setting)
        {
            #region 固定写法，给默认变量赋值
            MainDB = position.MainDB;
            CurStep = curStep;
            CurPosition = position;
            NodeAct = nodeAct;
            Setting = setting;
            #endregion

            CurStep.Message = Biz.L("等待输入条码数量");
            CurStep.Status = StepStatus.Normal;
        }

        /// <summary>
        /// 获取行为开始的提示信息
        /// </summary>
        /// <returns></returns>
        public Locale GetBeginMsg()
        {
            //var msg = new Locale($"请输入条码[{0}]的数量");
            var msg = new Locale("MES.WorkAction.InputQty.BeginMsg", CurPosition.CurSN);
            
            return msg;
        }

        /// <summary>
        /// 尝试开始执行工序行为
        /// </summary>
        /// <returns></returns>
        public ApiAction<SubmitOutput> TryBegin(SubmitInput input)
        {
            var action = new ApiAction<SubmitOutput>(new SubmitOutput());

            action.LocaleMsg = GetBeginMsg();

            //如果是包装条码则不允许修改数量
            if (MainDB.Queryable<MES_WIP_PKG>().Any(q => q.PARENT_SN == CurPosition.CurSN && q.AUTH_ORG == CurPosition.WorkBatch.WO.AUTH_ORG))
            {
                CurStep.Message = Biz.L("包装条码不允许修改数量");
                CurStep.Status = StepStatus.Error;
                action.IsSuccessed = false;
                action.Data.ShortMsg = new("包装条码不允许修改数量", ShortMessage.Types.Error);
                //action.LocaleMsg = new($"包装条码[{0}]不允许修改数量，请重新扫描正确的条码");
                action.LocaleMsg = new("MES.WorkAction.InputQty.NotAllowPackage", CurPosition.CurSN);
                CurPosition.ResetNode();
            }
            else
            {
                //如果返回成功则认为当前行为可以开始执行，否则返回失败
                CurStep.Message = Biz.L("请输入数量");
                CurStep.Status = StepStatus.Normal;
                action.IsSuccessed = true;
                action.Data.ShortMsg = new("请输入数量", ShortMessage.Types.Success);
            }
            return action;
        }

        /// <summary>
        /// 工序行为提交数据
        /// </summary>
        /// <returns></returns>
        public ApiAction<SubmitOutput> Submit(SubmitInput input)
        {
            var action = new ApiAction<SubmitOutput>(new SubmitOutput());

            action = SaveSnQty(input, action);
            //上料数据保存失败
            if (!action.IsSuccessed)
            {
                //如果行为设置为出错需要重置工序操作
                if (NodeAct.NEED_RESET == "Y")
                {
                    CurPosition.ResetNode();
                }
            }
            else
            {
                action = End(input);
            }
            return action;
        }

        public ApiAction<SubmitOutput> SaveSnQty(SubmitInput input, ApiAction<SubmitOutput> action)
        {
            try
            {
                NewQty = input?.Data?.ToInt32() ?? 0;
                if (NewQty > 0)
                {
                    var newInput = CurPosition.CurWipSNs.Sum(q => NewQty);
                    var woInput = CurPosition.WorkBatch.WoSNs.Where(q => q.WORK_ORDER == CurPosition.WorkBatch.WO.ORDER_NO && BIZ_MES_WO_SN.STATUSs.NotInput.GetValue() < q.STATUS && q.STATUS <= BIZ_MES_WO_SN.STATUSs.Finished.GetValue())
                                                                                           .Where(q => !CurPosition.CurWipSNs.Any(sn => sn.ID == q.WIP_ID)).DistinctBy(q => q.WIP_ID).Sum(q => q.QTY);
                    var batchInput = CurPosition.WorkBatch.WoSNs.Where(q => q.BATCH_NO == CurPosition.WorkBatch.Batch.BATCH_NO && BIZ_MES_WO_SN.STATUSs.NotInput.GetValue() < q.STATUS && q.STATUS <= BIZ_MES_WO_SN.STATUSs.Finished.GetValue())
                                                                                               .Where(q => !CurPosition.CurWipSNs.Any(sn => sn.ID == q.WIP_ID)).DistinctBy(q => q.WIP_ID).Sum(q => q.QTY);

      
                    //工单批次投入数量减去报废数量如果大于等于计划数量，则不允许生产
                    if ((NewBatchInputQty = batchInput + newInput) > CurPosition.WorkBatch.Batch.PLAN_QTY)
                    {
                        CurStep.Message = Biz.L("重新输入数量");
                        CurStep.Status = StepStatus.Error;
                        action.IsSuccessed = false;
                        action.Data.ShortMsg = new("重新输入数量", ShortMessage.Types.Error);
                        //action.LocaleMsg = new($"条码更新数量[{0}]后，工单批次[{1}]投入数量[{2}]超出计划数量[{3}]，请重新输入正确的数量");
                        action.LocaleMsg = new("MES.WorkAction.InputQty.BatchInputEnough", input.Data, CurPosition.WorkBatch.Batch.BATCH_NO, batchInput + newInput, CurPosition.WorkBatch.Batch.PLAN_QTY);
                    }
                    //工单投入数量减去报废数量如果大于等于计划数量，则不允许生产
                    else if ((NewWoInputQty = woInput + newInput) > CurPosition.WorkBatch.WO.PLAN_QTY)
                    {
                        CurStep.Message = Biz.L("重新输入数量");
                        CurStep.Status = StepStatus.Error;
                        action.IsSuccessed = false;
                        action.Data.ShortMsg = new("重新输入数量", ShortMessage.Types.Error);
                        //action.LocaleMsg = new($"条码更新数量[{0}]后，工单[{1}]投入数量[{2}]超出计划数量[{3}]，请重新输入正确的数量");
                        action.LocaleMsg = new("MES.WorkAction.InputQty.WoInputEnough", input.Data, CurPosition.WorkBatch.WO.ORDER_NO, woInput + newInput, CurPosition.WorkBatch.WO.PLAN_QTY);
                    }
                    else
                    {
                        action = End(input);
                    }
                }
                else
                {
                    CurStep.Message = Biz.L("重新输入数量");
                    CurStep.Status = StepStatus.Error;
                    action.IsSuccessed = false;
                    action.Data.ShortMsg = new("重新输入数量", ShortMessage.Types.Error);
                    //action.LocaleMsg = new($"数量[{0}]必须是大于0的整数，请重新输入正确的数量");
                    action.LocaleMsg = new("MES.WorkAction.InputQty.QtyError", input.Data);

                }
            }
            catch (System.Exception ex)
            {
                CurStep.Message = Biz.L("更新数量异常");
                CurStep.Status = StepStatus.Error;
                action.Data.ShortMsg = new("更新数量异常", ShortMessage.Types.Error);
                //action.CatchExceptionWithLog(ex, $"更新数量行为：更新条码[{0}]数量[{1}]异常");
                action.LocaleMsg = new("MES.WorkAction.InputQty.SaveQtyException", CurPosition.CurSN, input?.Data.ToString());
            }
            return action;
        }

        /// <summary>
        /// 结束执行工序行为
        /// </summary>
        /// <returns></returns>
        public ApiAction<SubmitOutput> End(SubmitInput input)
        {
            var action = new ApiAction<SubmitOutput>(new SubmitOutput());
            //记录行为操作记录
            var wipActs = new List<MES_WIP_ACT>();
            var wipVars = new List<MES_WIP_ACT_VAR>();
            foreach (var wipSn in CurPosition.CurWipSNs)
            {
                wipSn.QTY = NewQty;
                foreach (var item in CurPosition.CurWipSNHiss.Where(q => q.WIP_ID == wipSn.ID))
                {
                    item.QTY = NewQty;
                }
                foreach (var item in CurPosition.WorkBatch.WoSNs.Where(q => q.WIP_ID == wipSn.ID))
                {
                    item.QTY = NewQty;
                }
                var wipAct = new MES_WIP_ACT()
                {
                    AUTH_ORG = CurPosition.WorkBatch.WO.AUTH_ORG,
                    AUTH_PROD = CurPosition.CurLine.LINE_CODE,
                    WIP_ID = wipSn.ID,
                    HIS_ID = CurPosition.CurWipSNHiss.First(q => q.SN == wipSn.SN).ID,
                    SN = wipSn.SN,
                    STATUS = wipSn.STATUS,
                    ITEM_CODE = wipSn.ITEM_CODE,
                    WORK_ORDER = wipSn.WORK_ORDER,
                    BATCH_NO = wipSn.BATCH_NO,
                    ROT_CODE = wipSn.ROT_CODE,
                    NODE_ID = wipSn.NODE_ID,
                    NODE_NAME = wipSn.NODE_NAME,
                    ACT_ID = NodeAct.ID,
                    ACT_NAME = NodeAct.ACT_NAME,
                    FTY_CODE = wipSn.FTY_CODE,
                    WS_CODE = wipSn.WS_CODE,
                    LINE_CODE = wipSn.LINE_CODE,
                    POST_CODE = wipSn.POST_CODE,
                    OPER_CODE = wipSn.OPER_CODE,
                    SEGMENT = wipSn.SEGMENT,
                    FLOW_SN = wipSn.FLOW_SN,
                    TRAY_SN = wipSn.TRAY_SN,
                    INNER_SN = wipSn.INNER_SN,
                    CARTON_SN = wipSn.CARTON_SN,
                    PALLET_SN = wipSn.PALLET_SN,
                    OPERATION_TIME = DateTime.Now,
                    SFTS_CODE = wipSn.SFTS_CODE,
                    SFT_CODE = wipSn.SFT_CODE,
                    PRD_CODE = wipSn.PRD_CODE,
                    ACT_TYPE = NodeAct.ACT_TYPE,
                    ACT_SN = wipSn.SN,
                    ACT_VAR_DIC = CurStep.ActionDic.ToJson(),
                    ACT_RESULT = "Y",
                    ELAPSED_TIME = CurStep.GetElapsedTime().TotalMilliseconds.ToInt64(),
                    TRACE_INFO = $"条码[{CurPosition.CurSN}]更新数量为[{NewQty}]保存成功",
                };
                wipActs.Add(wipAct);
                foreach (var item in NodeAct.Variables)
                {
                    var wipVar = new MES_WIP_ACT_VAR()
                    {
                        AUTH_ORG = CurPosition.WorkBatch.WO.AUTH_ORG,
                        AUTH_PROD = CurPosition.CurLine.LINE_CODE,
                        HIS_ID = CurPosition.CurWipSNHiss.First(q => q.SN == wipSn.SN).ID,
                        WIP_ID = wipSn.ID,
                        SN = wipSn.SN,
                        ITEM_CODE = wipSn.ITEM_CODE,
                        WORK_ORDER = wipSn.WORK_ORDER,
                        BATCH_NO = wipSn.BATCH_NO,
                        CUST_CODE = CurPosition.WorkBatch.WO.CUST_CODE,
                        ROT_CODE = wipSn.ROT_CODE,
                        NODE_ID = wipSn.NODE_ID,
                        NODE_NAME = wipSn.NODE_NAME,
                        ACT_ID = NodeAct.ID,
                        ACT_NAME = NodeAct.ACT_NAME,
                        FTY_CODE = wipSn.FTY_CODE,
                        WS_CODE = wipSn.WS_CODE,
                        LINE_CODE = wipSn.LINE_CODE,
                        POST_CODE = wipSn.POST_CODE,
                        OPER_CODE = wipSn.OPER_CODE,
                        SEGMENT = wipSn.SEGMENT,
                        FLOW_SN = wipSn.FLOW_SN,
                        TRAY_SN = wipSn.TRAY_SN,
                        INNER_SN = wipSn.INNER_SN,
                        CARTON_SN = wipSn.CARTON_SN,
                        PALLET_SN = wipSn.PALLET_SN,
                        OPERATION_TIME = DateTime.Now,
                        SFTS_CODE = wipSn.SFTS_CODE,
                        SFT_CODE = wipSn.SFT_CODE,
                        PRD_CODE = wipSn.PRD_CODE,
                        VAR_CODE = item.VAR_CODE,
                        VAR_NAME = item.VAR_NAME,
                        VAR_CONTROL = item.VAR_CONTROL,
                        VALUE_TYPE = item.VALUE_TYPE,
                        PROCESS_VAR = item.PROCESS_VAR,
                        INPUT_VALUE = CurStep.ActionDic.GetOrDefault(item.VAR_CODE),
                        TRACE_INFO = CurStep.ActionDic.ToJson(),
                    };
                    wipVars.Add(wipVar);
                }
            }

            //创建变量克隆对象用于传入DBSubmitAction中保存当前需要暂存的数据值
            var _wipActs = wipActs.Clone();
            var _wipVars = wipVars.Clone();
            var wo = CurPosition.WorkBatch.WO.ORDER_NO;
            var batch = CurPosition.WorkBatch.Batch.BATCH_NO;
            var nodeID = NodeAct.NODE_ID;
            var _wipIDs = CurPosition.CurWipSNs.Select(q => q.ID).ToList().Clone();
            //保存数据
            CurStep.DBSubmitAction = () =>
            {
                var db = CurPosition.GetCommitDB();
                //在制品信息表
                db.Updateable<MES_WIP_DATA>(CurPosition.UserCode)
                    .SetColumns(q => q.QTY == NewQty)
                    .Where(q => q.WORK_ORDER == wo && _wipIDs.Contains(q.ID))
                    .ExecuteCommand();
                //生产过程记录
                db.Updateable<MES_WIP_HIS>(CurPosition.UserCode)
                    .SetColumns(q => q.QTY == NewQty)
                    .Where(q => q.WORK_ORDER == wo && q.NODE_ID == nodeID && _wipIDs.Contains(q.WIP_ID))
                    .ExecuteCommand();
                //生产包装记录
                db.Updateable<MES_WIP_PKG>(CurPosition.UserCode)
                    .SetColumns(q => q.QTY == NewQty)
                    .Where(q => q.WORK_ORDER == wo && _wipIDs.Contains(q.ID))
                    .ExecuteCommand();
                //工单表
                db.Updateable<BIZ_MES_WO>(CurPosition.UserCode)
                    .SetColumns(q => q.INPUT_QTY == NewWoInputQty)
                    .Where(q => q.ORDER_NO == wo)
                    .ExecuteCommand();
                //工单批次表
                db.Updateable<BIZ_MES_WO_BATCH>(CurPosition.UserCode)
                    .SetColumns(q => q.INPUT_QTY == NewBatchInputQty)
                    .Where(q => q.BATCH_NO == batch)
                    .ExecuteCommand();
                //工单条码明细表
                db.Updateable<BIZ_MES_WO_SN>(CurPosition.UserCode)
                    .SetColumns(q => q.QTY == NewQty)
                    .Where(q => q.WORK_ORDER == wo && _wipIDs.Contains(q.WIP_ID))
                    .ExecuteCommand();
                db.Storageable(_wipActs, CurPosition.UserCode).ExecuteCommand();
                db.Storageable(_wipVars, CurPosition.UserCode).ExecuteCommand();
            };

            IsFinished = true;
            CurStep.Message = Biz.L("更新数量成功");
            CurStep.Status = StepStatus.Finished;
            action.Data.ShortMsg = new("更新数量成功", ShortMessage.Types.Success);
            //action.LocaleMsg = new($"条码[{0}]更新数量为[{1}]保存成功");
            action.LocaleMsg = new("MES.WorkAction.InputQty.SaveSuccess", CurPosition.CurSN, NewQty);
            return action;
        }

        #endregion Functions
    }
}