using System;
using System.Collections.Generic;
using yunneiPda.EnumDefine;
using yunneiPda.orm;
using System.Linq;
using Newtonsoft.Json.Linq;

namespace yunneiPda
{
    /// <summary>
    /// 增补创建的扩展方法 【EditBy shaocx,2022-02-05】
    /// </summary>
    public class MyExtend
    {
        /// <summary>
        /// 获取非法站点号字符串
        /// </summary>
        /// <param name="station"></param>
        /// <returns></returns>
        public static string GetFFZDHStr(string station)
        {
            return "非法站点号:" + station;
        }

        /// <summary>
        /// 组盘，保存入库表单,验证托盘号是否在新建的表单中
        /// </summary>
        /// <param name="mod"></param>
        /// <param name="value"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public static bool ValidateContainerCodeIsExistInInStockOrderWithNewCreateStatus(dbmodel mod, string containerCode, ref string errMsg
            )
        {
            var queryStatus = (int)InStockOrderStatus.新建;
            inStockOrder _inStockOrder = mod.inStockOrder.FirstOrDefault(x => x.containerCode == containerCode && x.status == queryStatus);
            if (_inStockOrder != null)
            {
                errMsg = "托盘号" + containerCode + "已经在新建的组盘记录中，入库表单:" + _inStockOrder.orderCode;
                return false;
            }
            return true;
        }

        /// <summary>
        /// 验证托盘号是否有库存
        /// </summary>
        /// <param name="mod"></param>
        /// <param name="value"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public static bool ValidateContainerCodeIsExistStockForSalverCode(dbmodel mod, string containerCode, ref string errMsg
            )
        {
            productStock stock = mod.productStock.FirstOrDefault(x => x.containerCode == containerCode);
            if (stock != null)
            {
                var place = mod.position.FirstOrDefault(x => x.positionId == stock.positionId);
                errMsg = "托盘号" + containerCode + "已经在库存中，库位号:" + place.positionName;
                return false;
            }

            return true;
        }

        /// <summary>
        /// 组盘，保存入库表单,验证流水号是在在新建的表单中
        /// </summary>
        /// <param name="mod"></param>
        /// <param name="value"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public static bool ValidateSerialNumbersIsExistInInStockOrderWithNewCreateStatus(dbmodel mod, inStockEntity<serialNumbers> value, ref string errMsg
            )
        {
            foreach (var item in value.dataList)
            {
                var result = ValidateSingleSerialNumbersIsExistInInStockOrderWithNewCreateStatus(mod, 0, item.serialNumber, value.productCode, ref errMsg);
                if (result == false)
                {
                    return false;
                }
            }

            return true;
        }
        /// <summary>
        /// 组盘，保存入库表单,验证流水号是在在新建的表单中
        /// </summary>
        /// <param name="mod"></param>
        /// <param name="value"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public static bool ValidateSingleSerialNumbersIsExistInInStockOrderWithNewCreateStatus(dbmodel mod, int orderCodeId, string serialNumber, string productCode, ref string errMsg
            )
        {
            var queryStatus = (int)InStockOrderStatus.新建;

            var _inStockOrderList = mod.inStockOrderList.AsNoTracking().Where(x => x.serialNumber == serialNumber && x.productCode == productCode).ToList();
            if (_inStockOrderList != null && _inStockOrderList.Count > 0)
            {
                if (orderCodeId > 0)
                {//说明是编辑情况下,把当前正在编辑的过滤掉
                    //_inStockOrderList = mod.inStockOrderList.AsNoTracking().Where(x => x.orderCodeId != orderCodeId).ToList();
                    //修复查询bug,提示流水号跟工单不符的问题 【Editby shaocx,2025-04-02】
                    _inStockOrderList = _inStockOrderList.Where(x => x.orderCodeId != orderCodeId).ToList();
                }
                //优化太慢的情况，pda要求5秒内必须返回请求。所以以后pda也得优化！ 【Editby shaocx,2023-09-20】
                List<int?> query_orderCodeIdList = _inStockOrderList.Select(x => x.orderCodeId).ToList();
                var _inStockOrder = mod.inStockOrder.AsNoTracking().FirstOrDefault(x => query_orderCodeIdList.Contains(x.orderCodeId) && x.status == queryStatus);
                if (_inStockOrder != null)
                {
                    errMsg = "流水号" + serialNumber + "已经在新建的组盘记录中，入库表单:" + _inStockOrder.orderCode;
                    return false;
                }

                //foreach (var myInStock in _inStockOrderList)
                //{
                //    var _inStockOrder = mod.inStockOrder.AsNoTracking().FirstOrDefault(x => x.orderCodeId == myInStock.orderCodeId && x.status == queryStatus);
                //    if (_inStockOrder != null)
                //    {
                //        errMsg = "流水号" + serialNumber + "已经在新建的组盘记录中，入库表单:" + _inStockOrder.orderCode;
                //        return false;
                //    }
                //}
            }
            return true;
        }

        /// <summary>
        /// 组盘，保存入库表单,验证流水号是在库存中
        /// </summary>
        /// <param name="mod"></param>
        /// <param name="value"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public static bool ValidateSerialNumbersIsExistStockForSalverCode(dbmodel mod, inStockEntity<serialNumbers> value, ref string errMsg
            )
        {
            foreach (var item in value.dataList)
            {
                var result = ValidateSingleSerialNumbersIsExistStockForSalverCode(mod, item.serialNumber, value.productCode, ref errMsg);
                if (result == false)
                {
                    return false;
                }
            }
            return true;
        }

        /// <summary>
        /// 组盘，保存入库表单,验证流水号是在库存中
        /// </summary>
        /// <param name="mod"></param>
        /// <param name="value"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public static bool ValidateSingleSerialNumbersIsExistStockForSalverCode(dbmodel mod, string serialNumber, string productCode, ref string errMsg
            )
        {
            var myStock = mod.productStockList.FirstOrDefault(x => x.serialNumber == serialNumber && x.productCode == productCode);
            if (myStock != null)
            {
                productStock stock2 = mod.productStock.FirstOrDefault(x => x.positionId == myStock.stockId);
                if (stock2 != null)
                {
                    var place2 = mod.position.FirstOrDefault(x => x.positionId == stock2.positionId);
                    if (place2 != null)
                    {
                        errMsg = "流水号" + serialNumber + "已经在库存中，库位号:" + place2.positionName;
                        return false;
                    }
                }
            }

            return true;
        }


        /// <summary>
        /// 组盘，保存入库表单,验证目标站点是否有库存
        /// </summary>
        /// <param name="mod"></param>
        /// <param name="value"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public static bool ValidateIsExistStockWhenSaveInCode(dbmodel mod, inStockEntity<serialNumbers> value, ref string errMsg
            )
        {
            if (string.IsNullOrEmpty(value.toStieCode)) return true;
            var stock = MyExtendHelper.GetProductStockByName(mod, value.toStieCode);
            if (stock != null)
            {
                errMsg = "站点" + value.toStieCode + "已经有库存";
                return false;
            }
            return true;
        }

        /// <summary>
        /// 组盘，保存入库表单,验证目标站点是否允许创建任务
        /// </summary>
        /// <param name="mod"></param>
        /// <param name="value"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public static bool ValidateIsAllowCreateTaskWhenSaveInCode(dbmodel mod, inStockEntity<serialNumbers> value, ref string errMsg
            )
        {
            if (string.IsNullOrEmpty(value.toStieCode)) return true;
            task _task = null;
            var isExist = MyExtendHelper.IsExistNoFinishedTask(mod, value.toStieCode, ref _task);
            if (isExist)
            {
                errMsg = "站点" + value.toStieCode + "有未完成的任务，任务号:" + _task.createListCode + "，起点:" + _task.sourcePlace + "，目标点:" + _task.toPlace;
                return false;
            }
            return true;
        }

        /// <summary>
        /// 校验站点是否有任务被占用
        /// </summary>
        /// <param name="mod"></param>
        /// <param name="positionName"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public static bool CommonIsExistNoFinishedTask(dbmodel mod, string positionName, ref string errMsg
            )
        {
            task _task = null;
            var isExist = MyExtendHelper.IsExistNoFinishedTask(mod, positionName, ref _task);
            if (isExist)
            {
                errMsg = "站点" + positionName + "有未完成的任务，任务号:" + _task.createListCode + "，起点:" + _task.sourcePlace + "，目标点:" + _task.toPlace;
                return false;
            }
            return true;
        }
    }
}