using Rhea.Common;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using Tiger.Model;
using Tiger.IBusiness;
using Tiger.Model.MES.Yada;
using Tiger.Model.Entitys.MES.U9C;
using System.Security.Policy;
using Tiger.Model.Entitys.MES.Position;
using MailKit.Search;
using IronPython.Runtime.Operations;
using static IronPython.Modules._ast;
using System.Diagnostics;
using Tiger.Model.Minsun;
using static IronPython.Runtime.Profiler;
using static Microsoft.CodeAnalysis.CSharp.SyntaxTokenParser;

namespace Tiger.Business.WMS.Transaction
{
    /// <summary>
    /// (U9)来料打印清点事务
    /// </summary>
    public class Print_BIZ_U9_ASN : WmsTask, IPrint_BIZ_U9_ASN
    {
        public IPrint_BIZ_U9_ASN Init(string id, string userCode, string apiHost, string orgCode)
        {
            base.Init(id, userCode, apiHost, orgCode);
            Logger.Console.Info($"Start {this.GetType().Name} Transaction[ID: {TransID}]");
            return this;
        }

        #region Propertys & Variables
        //private List<WmsOrder<BIZ_U9_ASN>> _OrderList { get; set; } = new();
        private List<string> OrderList = new();
        private BIZ_U9_ASN order = new();
        private List<BIZ_U9_ASN_SN> CurSn = new();
        List<string> SnList = new();
        private List<BIZ_U9_ASN_SN> ScanList = new();
        #endregion

        #region Functions
        /// <summary>
        /// 扫描入口
        /// </summary>
        public async Task<ApiAction<ScanOutput>> Scan(BaseInput input)
        {
            var action = new ApiAction<ScanOutput>(new ScanOutput());
            try
            {
                if (input.SN.IsNullOrEmpty())
                {
                    action.IsSuccessed = false;
                    //action.LocaleMsg = Biz.L("条码不能为空");
                    action.LocaleMsg = Biz.L("WMS.Default.ScanItem.SnEmptyFailure");
                    return SetOutPutMqttMsg(action, input.Locale);
                }
                //如果是未上门户
                else if (input.Data == "0")
                {
                    action = await GetAsnInfoForPrint(input);
                }
                //如果是随单赠品或者样品
                else if (input.Data == "1")
                {

                }
                else if (input.Data == "Submit")
                {
                    action = await Submit(input);
                }
            }
            catch (Exception ex)
            {
                //取消当前操作
                ResetScan();
                //action.CatchExceptionWithLog(ex, $"扫描[{input.SN}]异常");
                action.CatchExceptionWithLog(ex, Biz.L("WMS.Default.Scan.ScanException", input.SN));
            }
            return SetOutPutMqttMsg(action, input.Locale);
        }

        /// <summary>
        /// 获取用于打印的 asn 信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public async Task<ApiAction<ScanOutput>> GetAsnInfoForPrint(BaseInput input)
        {
            var action = new ApiAction<ScanOutput>($"成功获取ASN单[{input.SN}]信息", new ScanOutput());
            try
            {
                order = await MainDB.Queryable<BIZ_U9_ASN>().Where(q => q.ORDER_NO == input.SN).Includes(q => q.Details, d => d._ItemInfos).IncludesAllFirstLayer().FirstAsync();
                if (order == null)
                {
                    action.IsSuccessed = false;
                    action.LocaleMsg = Biz.L($"查不到ASN单[{input.SN}]的数据");
                    return action;
                }
                action.Data.Data = order;
            }
            catch (Exception ex)
            {
                //取消当前操作
                ResetScan();
                action.CatchExceptionWithLog(ex, Biz.L("WMS.Default.Scan.ScanException", input.SN));
            }
            return SetOutPutMqttMsg(action, input.Locale);
        }

        /// <summary>
        /// 提交数据生成SN并清点
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public async Task<ApiAction<ScanOutput>> Submit(BaseInput input)
        {
            var action = new ApiAction<ScanOutput>(new ScanOutput());
            try
            {
                var snlist = input.Options["Snlist"].ToString().JsonToObject<List<BIZ_U9_ASN_SN>>();
                var reqType = input.Options["reqType"].ToString();
                var dtl = input.Options["record"].ToString().JsonToObject<BIZ_U9_ASN_DTL>();
                action.LocaleMsg = Biz.L($"成功提交ASN单[{dtl.ORDER_NO}]行数据，并完成清点，请点击打印按钮打印标签");

                if (MainDB.Queryable<BIZ_U9_ASN_SN>().Where(q => q.ORDER_NO == dtl.ORDER_NO && q.LINE_NO == dtl.LINE_NO && (q.STATUS == WMS_ITEM.STATUSs.Counted.GetValue() || q.STATUS == WMS_ITEM.STATUSs.Rejected.GetValue())).Sum(q => q.QTY) == dtl.QTY)
                {
                    action.IsSuccessed = false;
                    action.LocaleMsg = Biz.L($"ASN单[{dtl.ORDER_NO}]行[{dtl.LINE_NO}]数据已全部清点完成，如果未打印标签请点击打印按钮打印标签");
                    return action;
                }
                List<BIZ_U9_ASN_SN> sns = new();
                List<WMS_ITEM> items = new();
                List<WMS_ITEM_HIS> hiss = new();
                List<WMS_ITEM_EXT> itemExts = new();
                List<WMS_ITEM_PKG> pkgs = new();
                foreach (var sn in snlist)
                {
                    var _sn = DI.Resolve<ICodeRuleCache>()["NoSourceBarcode"]?.Generate($"/NoSourceBarcode/").Data.ToString() ?? "";
                    var metaSn = _sn.replace("/NoSourceBarcode/", sn.SN);
                    SnList.Add(metaSn);
                    var barcode = new Barcode(metaSn);
                    BIZ_U9_ASN_SN info = new()
                    {
                        AUTH_ORG = dtl.AUTH_ORG,
                        CREATE_TIME = DateTime.Now,
                        CREATE_USER = UserCode,
                        UPDATE_TIME = DateTime.Now,
                        UPDATE_USER = UserCode,
                        STATUS = WMS_ITEM.STATUSs.Counted.GetValue(),
                        ORDER_NO = dtl.ORDER_NO,
                        LINE_NO = dtl.LINE_NO,
                        SN = barcode.SN,
                        META_SN = metaSn,
                        ITEM_CODE = barcode.ItemCode,
                        QTY = sn.QTY,
                        LOTNO = barcode.LotNo,
                        CARTON_NO = barcode.SN,
                        RECEIVER = UserCode,
                        RECEIVE_DATE = DateTime.Now,
                    };
                    sns.Add(info);
                    var item = new WMS_ITEM()
                    {
                        SN = barcode.SN,
                        ITEM_CODE = barcode.ItemCode,
                        AUTH_ORG = dtl.AUTH_ORG,
                        STATUS = WMS_ITEM.STATUSs.Counted.GetValue(),
                        QTY = sn.QTY,
                        PROD_DATE = barcode.ProdDate ?? BarcodeAnalysis.GetDateTime(dtl.SUPP_LOTNO) ?? DateTime.Now,
                        UNIT = barcode.Unit,
                        TRANS_CODE = nameof(BIZ_U9_ASN),
                        TRANS_NO = info.ORDER_NO,
                        TRANS_LINE = info.LINE_NO,
                        SUPP_CODE = dtl.SUPP_CODE,
                        SUPP_LOTNO = dtl.SUPP_LOTNO,
                    };
                    items.Add(item);
                    hiss.Add(new WMS_ITEM_HIS(item, $"条码[{barcode.SN}]导入，操作单据[{item.TRANS_NO}]"));
                    var ext = new WMS_ITEM_EXT()
                    {
                        SN = barcode.SN,
                        META_SN = metaSn,
                        QR_CODE = metaSn,
                    };
                    itemExts.Add(ext);
                    var pkg = new WMS_ITEM_PKG()
                    {
                        SN = barcode.SN,
                        ITEM_CODE = barcode.ItemCode,
                        AUTH_ORG = dtl.AUTH_ORG,
                        QTY = sn.QTY,
                        UNIT = barcode.Unit,
                        TRANS_CODE = nameof(BIZ_U9_ASN),
                        TRANS_NO = info.ORDER_NO,
                        TRANS_LINE = info.LINE_NO,
                        SUPP_CODE = dtl.SUPP_CODE,
                        SUPP_LOTNO = dtl.SUPP_LOTNO,
                    };
                    pkgs.Add(pkg);
                }

                AddCommitAction("CountedAndPrint", () =>
                {
                    //使用统一的事务DB对象
                    var db = GetCommitDB();
                    //数据保存逻辑
                    db.Updateable<BIZ_U9_ASN>(UserCode).SetColumns(q => q.STATUS == BIZ_U9_ASN.STATUSs.Counting.GetValue()).Where(q => q.ORDER_NO == dtl.ORDER_NO).ExecuteCommand();
                    db.Storageable(sns, UserCode).ExecuteCommand();
                    var s = db.Storageable(items, UserCode).WhereColumns(t => new { t.SN, t.GHOST_ROW }).ToStorage();
                    s.AsInsertable.ExecuteCommand();
                    s.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.ITEM_CODE, q.AUTH_ORG, q.STATUS, q.QTY, q.PROD_DATE, q.UNIT, q.TRANS_CODE, q.TRANS_NO, q.TRANS_LINE, q.SUPP_CODE, q.SUPP_LOTNO, q.UPDATE_TIME, q.UPDATE_USER, }).ExecuteCommand();
                    db.Insertable(hiss, UserCode).ExecuteCommand();
                    var o = db.Storageable(itemExts, UserCode).WhereColumns(t => new { t.SN, t.GHOST_ROW }).ToStorage();
                    o.AsInsertable.ExecuteCommand();
                    o.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.META_SN, q.QR_CODE, q.UPDATE_TIME, q.UPDATE_USER, }).ExecuteCommand();
                    var y = db.Storageable(pkgs, UserCode).WhereColumns(t => new { t.SN, t.GHOST_ROW }).ToStorage();
                    y.AsInsertable.ExecuteCommand();
                    y.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.ITEM_CODE, q.AUTH_ORG, q.QTY, q.UNIT, q.TRANS_CODE, q.TRANS_NO, q.TRANS_LINE, q.SUPP_CODE, q.SUPP_LOTNO, q.UPDATE_TIME, q.UPDATE_USER, }).ExecuteCommand();
                });
                //清点完成调用接口生成无来源收货单
                Action generatedAction = () =>
                {
                    ApiAction<List<U9CReturnData2>> result = new ApiAction<List<U9CReturnData2>>();
                    //如果是随单赠品或者样品
                    if (reqType == "1")
                    {
                        var iInput = new CreateReceivementInput
                        {
                            userId = UserCode,
                            IsLogin = true,
                            Supplier = "",
                            RcvDocType = "",
                            RcvLines = new()
                            {
                                new(){
                                    ItemInfo = new(){m_itemCode="" },
                                    Wh= new(){ m_code=""},
                                    RcvLineLocations = new(){
                                        new(){
                                            Location = new(){ m_code="" },
                                            LocationQtyTU = 0,
                                        }
                                    },
                                    ArriveQtyTU = 0,
                                    ArriveQtyPU = 0,
                                    RcvQtyTU= 0,
                                    RcvQtyPU= 0,
                                    EyeballingQtyTU = 0,
                                    RcvProcedure = 0,
                                    StorageType = 0,
                                    RcvLotCode = "",
                                    InvLotCode  = "",
                                },
                            }
                        };
                        result = DI.Resolve<IWMS_U9C>().CreateReceivement(iInput).Result;
                        if (!result.IsSuccessed)
                        {
                            throw new Exception(Biz.T(result.LocaleMsg, input.Locale));
                        }
                    }
                    //如果是未上门户
                    else if (reqType == "0")
                    {
                        var iInput = new CreateRcvBySrcASNInput
                        {
                            userId = UserCode,
                            IsLogin = true,
                            CreateRcvBySrcASNParam = new()
                            {
                                aSNToRcvTransDTOs = order.Details.Select(q => new ASNToRcvTransDTO { ASNLineKey = q.ID, TransQty = new() { m_amount1 = q.QTY } }).ToList(),
                            }
                        };
                        result = DI.Resolve<IWMS_U9C>().CreateRcvBySrcASN(iInput).Result;
                        if (!result.IsSuccessed)
                        {
                            throw new Exception(Biz.T(result.LocaleMsg, input.Locale));
                        }
                    }

                    //根据接口返回收货单单号查询单据明细，并创建条码明细
                    var receipt = new BIZ_U9_RECEIPT();
                    receipt.Details = new();
                    receipt.SnList = new();
                    DbClient U9Cdb = Biz.DataSource["YadaU9C"].Client;
                    var list = U9Cdb.Queryable<mes_ReturnedDocInfo>().Where(x => x.RcvId == result.Data[0].ID.ToDouble() && x.DocNo == result.Data[0].Code).ToList();

                    if (list != null && list.Count > 0)
                    {
                        receipt.ID = list.First().RcvId.ToString();
                        receipt.AUTH_ORG = order.AUTH_ORG;
                        receipt.STATUS = BIZ_U9_RECEIPT.STATUSs.InQC.GetValue();
                        receipt.ORDER_NO = list.First().DocNo;
                        receipt.SUPP_CODE = list.First().SupplierCode;
                        receipt.SUPP_NAME = list.First().SupplierName;
                        receipt.RECEIVER = UserCode;
                        receipt.RECEIVE_DATE = DateTime.Now;
                        receipt.ASN_ID = order.ID;
                        receipt.ASN_NO = order.ORDER_NO;
                        receipt.ORDER_DATE = list.First().ModifiedOn;
                        receipt.HANDLED = 0;
                        receipt.HANDLED_DATE = DateTime.Now;

                        foreach (var item in list)
                        {
                            var asnDtl = order.Details.First(q => q.ID == item.SrcASNDocLineId.ToString());
                            BIZ_U9_RECEIPT_DTL receiptDt = new()
                            {
                                ID = item.RcvLineId.ToString(),
                                AUTH_ORG = receipt.AUTH_ORG,
                                STATUS = BIZ_U9_RECEIPT.STATUSs.InQC.GetValue(),
                                ORDER_NO = item.DocNo,
                                LINE_NO = item.DocLineNo.ToString(),
                                ITEM_CODE = item.ItemCode,
                                QTY = item.EyeballingQtyTU.ToDouble(), // mes单据数量 --U9退补数量
                                QTY_GIFT = asnDtl.QTY_GIFT,
                                ASN_ID = item.SrcASNDocId.ToString(),
                                ASN_NO = asnDtl.ORDER_NO,
                                ASN_LINE_ID = item.SrcASNDocLineId.ToString(),
                                ASN_LINE = asnDtl.LINE_NO,
                                ERP_CODE = item.ItemCode1,
                            };
                            receipt.Details.Add(receiptDt);
                        }

                        foreach (var sn in order.SnList)
                        {
                            var dtl = receipt.Details.First(q => q.ASN_LINE == sn.LINE_NO);
                            BIZ_U9_RECEIPT_SN receiptSn = new()
                            {
                                AUTH_ORG = dtl.AUTH_ORG,
                                ORDER_NO = dtl.ORDER_NO,
                                LINE_NO = dtl.LINE_NO,
                                SN = sn.SN,
                                META_SN = sn.META_SN,
                                ITEM_CODE = sn.ITEM_CODE,
                                STATUS = WMS_ITEM.STATUSs.WaitIn.GetValue(),
                                QTY = sn.QTY,
                                UNIT = sn.UNIT,
                                IS_OK = sn.IS_OK,
                                IS_IN = sn.IS_IN,
                                LOTNO = sn.LOTNO,
                                CARTON_NO = sn.CARTON_NO,
                                PALLET_NO = sn.PALLET_NO,
                            };
                            receipt.SnList.Add(receiptSn);
                        }
                    }

                    //更新库存表信息
                    var items = MainDB.Queryable<WMS_ITEM>().Where(q => SqlFunc.Subqueryable<BIZ_U9_ASN_SN>().Where(s => s.SN == q.SN && s.ORDER_NO == order.ORDER_NO).Any()).ToList();
                    var historys = new List<WMS_ITEM_HIS>();
                    foreach (var item in items)
                    {
                        item.AUTH_ORG = receipt.AUTH_ORG;
                        item.STATUS = WMS_ITEM.STATUSs.WaitIn.GetValue();
                        item.SOURCE_CODE = item.TRANS_CODE;
                        item.SOURCE_ORDER = item.TRANS_NO;
                        item.SOURCE_LINE = item.TRANS_LINE;
                        item.TRANS_CODE = nameof(BIZ_U9_RECEIPT);
                        item.TRANS_NO = receipt.ORDER_NO;
                        item.TRANS_LINE = receipt.SnList.First(q => q.SN == item.SN).LINE_NO;
                        historys.Add(new WMS_ITEM_HIS(item, $"送货单[{order.ORDER_NO}]的条码[{item.SN}]生成收货单[{receipt.ORDER_NO}]，待检验完成后可入库"));
                    }
                    var pkgs = MainDB.Queryable<WMS_ITEM_PKG>().Where(q => SqlFunc.Subqueryable<BIZ_U9_ASN_SN>().Where(s => s.SN == q.SN && s.ORDER_NO == order.ORDER_NO).Any()).ToList();
                    foreach (var item in pkgs)
                    {
                        item.AUTH_ORG = receipt.AUTH_ORG;
                        item.SOURCE_CODE = item.TRANS_CODE;
                        item.SOURCE_ORDER = item.TRANS_NO;
                        item.SOURCE_LINE = item.TRANS_LINE;
                        item.TRANS_CODE = nameof(BIZ_U9_RECEIPT);
                        item.TRANS_NO = receipt.ORDER_NO;
                        item.TRANS_LINE = receipt.SnList.First(q => q.SN == item.SN).LINE_NO;
                    }
                    order.STATUS = BIZ_U9_ASN.STATUSs.Finished.GetValue();
                    order.RECEIVER_ID = receipt.ID;
                    order.RECEIVER_NO = receipt.ORDER_NO;
                    order.RECEIVER = UserCode;
                    order.RECEIVE_DATE = DateTime.Now;

                    //使用统一的事务DB对象
                    var db = GetCommitDB();
                    var dbTran = db.UseTran(() =>
                    {
                        db.Updateable(items, UserCode).UpdateColumns(q => new { q.UPDATE_TIME, q.UPDATE_USER, q.AUTH_ORG, q.STATUS, q.TRANS_CODE, q.TRANS_NO, q.TRANS_LINE, q.SOURCE_CODE, q.SOURCE_ORDER, q.SOURCE_LINE }).ExecuteCommand();
                        db.Updateable(pkgs, UserCode).UpdateColumns(q => new { q.UPDATE_TIME, q.UPDATE_USER, q.AUTH_ORG, q.TRANS_CODE, q.TRANS_NO, q.TRANS_LINE, q.SOURCE_CODE, q.SOURCE_ORDER, q.SOURCE_LINE }).ExecuteCommand();
                        db.Insertable(historys, UserCode).ExecuteCommand();
                        db.Updateable(order, UserCode).UpdateColumns(q => new { q.UPDATE_TIME, q.UPDATE_USER, q.STATUS, q.RECEIVER, q.RECEIVE_DATE, q.RECEIVER_ID, q.RECEIVER_NO }).ExecuteCommand();
                        db.Insertable(receipt, UserCode).ExecuteCommand();
                        db.Insertable(receipt.Details, UserCode).ExecuteCommand();
                        db.Insertable(receipt.SnList, UserCode).ExecuteCommand();
                    });
                    if (dbTran.IsSuccess)
                    {
                        //action.LocaleMsg = Biz.L($"送货单[{0}]生成收货单[{1}]成功");
                        action.LocaleMsg = Biz.L("WMS.Print_BIZ_U9_ASN.GenerateReceipt.Success", order.ORDER_NO, receipt.ORDER_NO);
                    }
                    else
                    {
                        Logger.Default.Fatal(dbTran.ErrorException, "Database transaction save exception");
                        //抛出异常
                        throw dbTran.ErrorException;
                    }
                };

                //完成所有处理后使用事务保存数据
                action = DoIfFinish(action, input.Locale, generatedAction);
            }
            catch (Exception ex)
            {
                //取消当前操作
                ResetScan();
                action.CatchExceptionWithLog(ex, Biz.L("WMS.Default.Scan.ScanException", input.SN));
            }
            return SetOutPutMqttMsg(action, input.Locale);
        }

        /// <summary>
        /// 完成所有处理后使用事务保存数据
        /// </summary>
        /// <param name="action"></param>
        /// <param name="locale"></param>
        /// <param name="doAfterSave"></param>
        /// <returns></returns>
        public ApiAction<ScanOutput> DoIfFinish(ApiAction<ScanOutput> action, string locale, Action doAfterSave = null)
        {
            //保存数据库
            SaveCommitListToDB();

            //保存数据成功后执行
            doAfterSave?.Invoke();

            // 返回数据
            action.Data.Data = SnList;

            //action.LocaleMsg = Biz.L($"条码[{0}]清点成功！");
            action.LocaleMsg = Biz.L("WMS.Print_BIZ_U9_ASN.CountSuccess", string.Join(",", SnList));

            //重置工序
            ResetScan();
            return SetOutPutMqttMsg(action, locale); ;
        }

        #endregion

        /// <summary>
        /// 重置当前操作，有需要则重写此方法
        /// </summary>
        public override void ResetScan()
        {
            base.ResetScan();
            Command = null;
            CurInvItem = null;
            CurScanShelf = null;
            CurSn = null;
        }

        public override bool Close(bool needSaveHistoryLog = false)
        {
            this.IsFinished = true;
            return IsFinished ? base.Close(needSaveHistoryLog) : IsFinished;
        }

    }//endClass
}