using HH.WCS.DaYang.util;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using static HH.WCS.DaYang.wms.WMSHelper.AddChangeModel;

namespace HH.WCS.DaYang.wms
{
    internal class LocationHelper
    {
        public class LocationExt
        {
            public string S_PICKUP_POINT { get; internal set; }
            public string S_LOC_CODE { get; internal set; }
            public string S_AGV_SITE { get; internal set; }
        }
        private static Dictionary<string, Location> Locations = null;
        private static Dictionary<string, LocationExt> LocationExts = null;

        static LocationHelper()
        {
            try
            {
                //初始化Location加入到字典缓存
                Locations = new Dictionary<string, Location>();
                var list = GetAllLocList();
                if (list.Count > 0)
                {
                    list.ForEach(a =>
                    {
                        if (!Locations.ContainsKey(a.S_CODE))
                        {
                            Locations.Add(a.S_CODE, a);
                        }
                    });
                }
                //初始化LocationExt加入到集合缓存
                //LocationExts = new Dictionary<string, LocationExt>();
                //var exts = GetAllLocExtList();
                //if (exts.Count > 0) {
                //    exts.ForEach(a => {
                //        LocationExts.Add($"{a.S_LOC_CODE.Trim()}_{a.S_PICKUP_POINT.Trim()}", a);
                //    });
                //}
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }


        #region 洛阳大洋出入库算法
        /// <summary>
        /// 入库算法
        /// </summary>
        /// <param name="itemCode">物料编码</param>
        /// <returns></returns>
        public static Location InStorage(string itemCode)
        {
            var db = new SqlHelper<object>().GetInstance();
            Location location = null;
            List<Location> list = Locations.Values.ToList();

            string areaCode = "YCLLKQ";
            try
            {
                ////根据起点获取托盘和托盘物料绑定关系
                /// //string itemCode = "";
                //var cntrLoc = LocationHelper.GetLocCntr(loc.S_CODE).FirstOrDefault();
                //if (cntrLoc != null)
                //{
                //    //获取托盘物料绑定关系
                //    var cntrItem = db.Queryable<CntrItemDetail>().Where(a => a.S_CNTR_CODE == cntrLoc.S_CNTR_CODE).First();
                //    if (cntrItem != null)
                //    {
                //        itemCode = cntrItem.S_ITEM_CODE;
                //    }
                //}

                //托盘入库，相同物料内测排的货位
                var Locs = GetLocByItemCode(areaCode, itemCode, 1).OrderByDescending(b => b.N_COL).ToList();


                if (Locs.Count > 0)
                {
                    //内测排有货位，判断外侧排是否有货位
                    for (int i = Locs.Count - 1; i >= 0; i--)
                    {
                        int row = 0;
                        //判断外侧排
                        switch (list[i].N_ROW)
                        {
                            case 1:
                                row = 2;
                                break;
                            case 4:
                                row = 3;
                                break;
                            case 5:
                                row = 6;
                                break;
                            case 8:
                                row = 7;
                                break;
                        }
                        //寻找外侧货位
                        var OutLoc = db.Queryable<Location>().Where(a => a.S_AREA_CODE == Locs[i].S_AREA_CODE && a.N_LAYER == Locs[i].N_LAYER && a.N_ROW == row && a.N_CURRENT_NUM == 0 && a.N_LOCK_STATE == 0 && a.N_ROADWAY == Locs[i].N_ROADWAY).First();
                        if (OutLoc != null)
                        {
                            location = OutLoc;
                            break;
                        }
                    }

                }
                else
                {
                    LogHelper.Info($"InStorage: 库区{"areaCode"}无相同物料的内侧货位");
                }
                //如果没有找到相同物料的外侧货位，找一个内测空货位
                if (location == null)
                {
                    location = GetEmptyLocByItemCode(areaCode, new List<int> { 1, 4 });
                }
                return location;
            }
            catch (Exception ex)
            {
                LogHelper.Info($"InStorage Error:{ex}");
                throw;
            }

        }

        #endregion

        /// <summary>
        /// 根据物料和排号获得对应的未锁定托盘货位
        /// </summary>
        /// <param name="areaCode">库区编码</param>
        /// <param name="row">货位排</param>
        /// <param name="ItemCode">物料编码</param>
        /// <returns></returns>
        internal static Location GetLocByItemCodeOrderyTime(string areaCode, string ItemCode, string soure = "1")
        {
            Location loc = null;
            var db = new SqlHelper<object>().GetInstance();

            try
            {
                var loc1 = db.Queryable<Location>()
                    .LeftJoin<LocCntrRel>((a, b) => a.S_CODE == b.S_LOC_CODE)
                    .LeftJoin<CntrItemDetail>((a, b, c) => b.S_CNTR_CODE == c.S_CNTR_CODE)
                    .LeftJoin<Container>((a, b, c, d) => d.S_CODE == c.S_CNTR_CODE)
                    .Where((a, b, c, d) => a.N_CURRENT_NUM > 0 && a.N_LOCK_STATE == 0 && a.S_AREA_CODE == areaCode
                     && c.S_ITEM_CODE == ItemCode && d.S_SOURCE == soure)
                    .GroupBy((a, b, c) => new { a.S_CODE, c.T_INBOUND_TIME, a.N_POS, a.N_COL })
                    .OrderBy((a, b, c) => c.T_INBOUND_TIME)
                    .OrderByDescending((a, b, c) => a.N_POS)
                    .OrderBy((a, b, c) => a.N_COL)
                    .Select((a, b, c) => new
                    {
                        S_CODE = a.S_CODE,
                        T_INBOUND_TIME = c.T_INBOUND_TIME,
                        N_POS = a.N_POS
                    })
                    .ToList();
                // var LocCodes = loc1.Select(a => a.S_CODE).First();
                if (loc1.Count > 0)
                {
                    loc = db.Queryable<Location>().Where(a => a.S_CODE == loc1.First().S_CODE).First();
                }


                return loc;
            }
            catch (Exception ex)
            {
                LogHelper.Info($"GetLocByItemCode Error:{ex}");
                throw;
            }

        }

        /// <summary>
        /// 根据物料和排号获得对应的未锁定托盘货位,并按托盘物料表时间分组
        /// </summary>
        /// <param name="areaCode">库区编码</param>
        /// <param name="row">货位排</param>
        /// <param name="ItemCode">物料编码</param>
        /// <returns></returns>
        internal static List<Location> GetLocByItemCode(string areaCode, string ItemCode, int pos)
        {
            List<Location> locs;
            var db = new SqlHelper<object>().GetInstance();
            try
            {
                var queryable = db.Queryable<Location>()
                   .LeftJoin<LocCntrRel>((a, b) => a.S_CODE == b.S_LOC_CODE)
                   .LeftJoin<CntrItemDetail>((a, b, c) => b.S_CNTR_CODE == c.S_CNTR_CODE)
                   .Where((a, b, c) => a.N_CURRENT_NUM > 0 && a.N_LOCK_STATE == 0 && a.S_AREA_CODE == areaCode && a.N_POS == pos && c.S_ITEM_CODE == ItemCode && a.N_LOCK_STATE == 0);

                locs = queryable.ToList();

                return locs;
            }
            catch (Exception ex)
            {
                LogHelper.Info($"GetLocByItemCode Error:{ex}");
                throw;
            }

        }

        /// <summary>
        ///找一个内测空货位
        /// </summary>
        /// <param name="areaCode">库区编码</param>
        /// <param name="row">货位排</param>
        /// <returns></returns>
        internal static Location GetEmptyLocByItemCode(string areaCode, List<int> row)
        {
            var db = new SqlHelper<object>().GetInstance();
            Location location = null;

            try
            {
                //判断当前排可用货位小于2 如果小于2则不允许入
                for (int i = row.Count(); i < 0; i--)
                {
                    var locationNum = db.Queryable<Location>().Where(a => a.N_CURRENT_NUM == 0 && a.N_LOCK_STATE == 0 && a.S_AREA_CODE == areaCode && a.N_ROW == row[i]).ToList().Count;
                    if (locationNum <= 2)
                    {
                        row.RemoveAt(i);
                    }
                }

                location = db.Queryable<Location>().Where(a => a.N_CURRENT_NUM == 0 && a.N_LOCK_STATE == 0 && a.S_AREA_CODE == areaCode && row.Contains(a.N_ROW)).First();

                return location;
            }
            catch (Exception ex)
            {
                LogHelper.Info($"GetEmptyLocByItemCode Error:{ex}");
                throw;
            }



        }
        internal static bool CheckExist(string loc)
        {
            return Locations.Keys.Contains(loc);
        }
        internal static Location GetLocation(string loc)
        {
            if (CheckExist(loc.Trim()))
            {
                return Locations[loc.Trim()];
            }
            return null;
        }
        internal static List<FunctionArea> GetFunctionAreas(string masterCls, string msterCode)
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<FunctionArea>().Where(a => a.S_MASTER_CLS == masterCls && a.S_MASTER_CODE == msterCode).ToList();
        }
        internal static List<FunctionArea> GetFunctionAreas(string masterCls, string msterCode, int nType)
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<FunctionArea>().Where(a => a.S_MASTER_CLS == masterCls && a.S_MASTER_CODE == msterCode && a.N_TYPE == nType).ToList();
        }
        internal static FunctionArea GetFunctionAreaByCode(string faCode, int faType, int nType)
        {
            var db = new SqlHelper<object>().GetInstance();
            // && a.N_FA_TYPE == faType 
            return db.Queryable<FunctionArea>().Where(a => a.S_FA_CODE == faCode && a.N_TYPE == nType).First();
        }
        /// <summary>
        /// 获取货位站点信息
        /// </summary>
        /// <param name="loc"></param>
        /// <returns></returns>
        internal static string GetAgvSite(string loc)
        {
            var site = "0";
            if (Locations.Keys.Contains(loc.Trim()))
            {
                var Location = Locations[loc.Trim()];
                site = Location.S_AGV_SITE;
            }
            else
            {
                var Location = GetLoc(loc.Trim());
                if (Location != null)
                {
                    Locations.Add(loc.Trim(), Location);
                    site = Location.S_AGV_SITE;
                }
            }
            return site;
        }

        internal static int GetAgvSite(string loc, string actionType)
        {
            var site = 0;
            var key = $"{loc.Trim()}_{actionType.Trim()}";
            if (LocationExts.Keys.Contains(loc.Trim()))
            {
                var Location = LocationExts[loc.Trim()];
                site = int.Parse(Location.S_AGV_SITE);
            }
            return site;
        }

        /// <summary>
        /// 获取所有货位信息
        /// </summary>
        /// <returns></returns>
        internal static List<Location> GetAllLocList()
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<Location>().ToList();
        }
        internal static Location GetLoc(string code)
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<Location>().Where(a => a.S_CODE.Trim() == code).First();
        }

        /// <summary>
        ///获取所有货位扩展信息 
        /// </summary>
        /// <returns></returns>
        internal static List<LocationExt> GetAllLocExtList()
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<LocationExt>().ToList();
        }

        /// <summary>
        /// 判断没有入库锁和出库锁
        /// </summary>
        /// <param name="code"></param>
        /// <returns></returns>
        internal static bool CheckLocFree(string code)
        {
            var result = false;
            var loc = GetLoc(code);
            if (loc != null)
            {
                result = loc.S_LOCK_STATE.Trim() == "无";
            }
            return result;
        }

        internal static List<LocCntrRel> GetLocCntr(string loc)
        {
            var result = new List<LocCntrRel>();
            //1.0 查货位容器表
            var db = new SqlHelper<object>().GetInstance();
            var list = db.Queryable<LocCntrRel>().Where(a => a.S_LOC_CODE == loc.Trim()).OrderBy(a => a.T_CREATE).ToList();
            if (list.Count > 0)
            {
                list.ForEach(a =>
                {
                    //获取容器信息
                    var cntr = db.Queryable<Container>().Where(b => b.S_CODE == a.S_CNTR_CODE).First();
                    if (cntr != null)
                    {
                        a.Container = cntr;
                        result.Add(a);
                    }
                });
            }
            return result;

        }
        internal static List<LocCntrRel> GetLocCntrRel(string loc)
        {
            //1.0 查货位容器表
            var db = new SqlHelper<object>().GetInstance();
            var result = db.Queryable<LocCntrRel>().Where(a => a.S_LOC_CODE == loc.Trim()).ToList();
            return result;

        }

        /// <summary>
        /// 根据货位集合获取有容器的货位
        /// </summary>
        /// <param name="loc"></param>
        /// <returns></returns>
        internal static List<Location> GetLocList(List<string> loc)
        {
            //1.0 查货位容器表
            var db = new SqlHelper<object>().GetInstance();
            var list = db.Queryable<Location>().Where(a => loc.Contains(a.S_CODE) && a.N_CURRENT_NUM > 0).ToList();
            return list;

        }
        /// <summary>
        /// 根据货位编码获取货位信息，不管有没有容器
        /// </summary>
        /// <param name="loc"></param>
        /// <returns></returns>
        internal static List<Location> GetLocListbyloc(string loc)
        {
            //1.0 查货位容器表
            var db = new SqlHelper<object>().GetInstance();
            var list = db.Queryable<Location>().Where(a => a.S_CODE == loc).ToList();
            return list;

        }
        /// <summary>
        /// 根据货位编码获取货位信息，不管有没有容器
        /// </summary>
        /// <param name="loc"></param>
        /// <returns></returns>
        internal static List<Location> GetLocListAny(List<string> loc)
        {
            //1.0 查货位容器表
            var db = new SqlHelper<object>().GetInstance();
            var list = db.Queryable<Location>().Where(a => loc.Contains(a.S_CODE)).ToList();
            return list;

        }
        /// <summary>
        /// 根据库区编码获取货位集合
        /// </summary>
        /// <param name="area"></param>
        /// <returns></returns>
        internal static List<Location> GetLocListAny(string area)
        {
            try
            {
                var db = new SqlHelper<object>().GetInstance();
                var list = db.Queryable<Location>().Where(a => a.S_AREA_CODE.Trim() == area).ToList();
                return list;
            }
            catch (Exception ex)
            {
                //Console.WriteLine(ex.Message);
                throw ex;
            }

        }


        /// <summary>
        /// 根据货位集合获取有容器 没有锁的货位
        /// </summary>
        /// <param name="loc"></param>
        /// <returns></returns>
        internal static List<Location> GetLocListFree(List<string> loc)
        {
            //1.0 查货位容器表
            var db = new SqlHelper<object>().GetInstance();
            var list = db.Queryable<Location>().Where(a => loc.Contains(a.S_CODE) && a.N_CURRENT_NUM > 0 && a.S_LOCK_STATE.Trim() == "无").ToList();
            return list;

        }

        /// <summary>
        /// 获取固定数量容器 没有锁的货位
        /// </summary>
        /// <param name="loc"></param>
        /// <param name="current"></param>
        /// <returns></returns>
        internal static List<Location> GetLocListFree(List<string> loc, int current)
        {
            //1.0 查货位容器表
            var db = new SqlHelper<object>().GetInstance();
            var list = db.Queryable<Location>().Where(a => loc.Contains(a.S_CODE) && a.N_CURRENT_NUM == current && a.S_LOCK_STATE.Trim() == "无").ToList();
            return list;

        }

        /// <summary>
        /// 获取数量大于等于固定数量容器 没有锁的货位
        /// </summary>
        /// <param name="loc"></param>
        /// <param name="current"></param>
        /// <returns></returns>
        internal static List<Location> GetLocList(List<string> loc, int current)
        {
            //1.0 查货位容器表
            var db = new SqlHelper<object>().GetInstance();
            var list = db.Queryable<Location>().Where(a => loc.Contains(a.S_CODE) && a.N_CURRENT_NUM >= current && a.S_LOCK_STATE.Trim() == "无").ToList();
            return list;

        }

        /// <summary>
        /// 根据货位集合获取 没有容器 没有锁的货位
        /// </summary>
        /// <param name="loc"></param>
        /// <returns></returns>
        internal static List<Location> GetLocListEmptyFree(List<string> loc)
        {
            //1.0 查货位容器表
            var db = new SqlHelper<object>().GetInstance();
            var list = db.Queryable<Location>().Where(a => loc.Contains(a.S_CODE) && a.N_CURRENT_NUM == 0 && a.S_LOCK_STATE.Trim() == "无").ToList();
            return list;

        }

        /// <summary>
        /// 入库锁定终点，出库锁定起点
        /// </summary>
        /// <param name="loc"></param>
        /// <param name="lockState">1:入库锁、2:出库锁、2:其它锁</param>
        /// <returns></returns>
        public static bool LockLoc(string loc, int lockState)
        {
            var res = false;
            var db = new SqlHelper<object>().GetInstance();

            var model = db.Queryable<Location>().Where(a => a.S_CODE.Trim() == loc).First();
            if (model != null && model.S_LOCK_STATE.Trim() == "无")
            {
                model.N_LOCK_STATE = lockState;
                model.S_LOCK_STATE = Location.GetLockStateStr(lockState);
                res = db.Updateable(model).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE }).ExecuteCommand() > 0;
            }

            return res;
        }

        /// <summary>
        /// 托盘锁
        /// </summary>
        /// <param name="cntrcode">容器编码</param>
        /// <param name="lockState">1:入库锁、2:出库锁、2:其它锁</param>
        /// <returns></returns>
        public static bool LockCntr(string cntrcode, int lockState)
        {
            var res = false;
            var db = new SqlHelper<object>().GetInstance();
            try
            {

                var model = db.Queryable<Container>().Where(a => a.S_CODE == cntrcode).First();
                if (model != null && string.IsNullOrEmpty(model.S_LOCK_STATE) || model.S_LOCK_STATE.Trim() == "无")
                {
                    model.N_LOCK_STATE = lockState;
                    model.S_LOCK_STATE = Location.GetLockStateStr(lockState);
                    res = db.Updateable(model).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE }).ExecuteCommand() > 0;
                }
                return res;
            }
            catch (Exception ex)
            {

                LogHelper.Info($"LockCntr Error:{ex}");
                return res;
            }

        }

        /// <summary>
        /// 取货完解锁起点，卸货完解锁终点，可检验锁的来源，也可以不校验
        /// </summary>
        /// <param name="loc"></param>
        /// <returns></returns>
        public static bool UnLockLoc(string loc)
        {
            LogHelper.Info("UnLockLoc:" + loc);
            var res = false;
            var db = new SqlHelper<object>().GetInstance();
            var model = db.Queryable<Location>().Where(a => a.S_CODE == loc).First();
            if (model != null)
            {
                model.S_LOCK_STATE = "无";
                model.N_LOCK_STATE = 0;
                res = db.Updateable(model).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE }).ExecuteCommand() > 0;
                LogHelper.Info("UnLockLoc:解锁结果" + res);
            }
            else
            {
                LogHelper.Info("UnLockLoc 失败");
            }
            return res;
        }

        /// <summary>
        /// 删除货位容器表记录,修改货位容器数量
        /// </summary>
        /// <param name="loc"></param>
        /// <param name="cntrs"></param>
        /// <returns></returns>
        public static bool UnBindingLoc(string loc, List<string> cntrs)
        {
            var res = false;
            var db = new SqlHelper<object>().GetInstance();
            var location = db.Queryable<Location>().Where(a => a.S_CODE == loc).First();
            try
            {
                db.BeginTran();
                var lcrList = db.Queryable<LocCntrRel>().Where(a => a.S_LOC_CODE == loc).ToList();
                var count = db.Deleteable<LocCntrRel>().Where(it => cntrs.Contains(it.S_CNTR_CODE) && it.S_LOC_CODE == loc).ExecuteCommand();

                location.N_CURRENT_NUM = lcrList.Count - count;
                location.S_LOCK_STATE = "无";
                location.N_LOCK_STATE = 0;
                db.Updateable(location).UpdateColumns(it => new { it.N_CURRENT_NUM, it.S_LOCK_STATE, it.N_LOCK_STATE }).ExecuteCommand();
                db.CommitTran();
                res = true;
            }
            catch (Exception ex)
            {
                db.RollbackTran();
            }
            return res;
        }
        /// <summary>
        /// 货位绑定容器
        /// </summary>
        /// <param name="loc"></param>
        /// <param name="cntrs"></param>
        /// <returns></returns>
        public static bool BindingLoc(string loc, List<string> cntrs)
        {
            var res = false;
            var db = new SqlHelper<object>().GetInstance();
            var location = db.Queryable<Location>().Where(a => a.S_CODE == loc).First();
            try
            {
                var lcrList = db.Queryable<LocCntrRel>().Includes(a => a.Container).Where(a => a.S_LOC_CODE == loc).ToList();
                db.BeginTran();
                int count = 0;
                cntrs.ForEach(a =>
                {
                    if (lcrList.Count(b => b.S_CNTR_CODE.Trim() == a) == 0)
                    {
                        db.Insertable<LocCntrRel>(new LocCntrRel { S_LOC_CODE = loc, S_CNTR_CODE = a }).ExecuteCommand();
                        count++;
                    }
                });

                location.N_CURRENT_NUM = lcrList.Count + count;
                location.N_LOCK_STATE = 0;
                location.S_LOCK_STATE = "无";

                db.Updateable(location).UpdateColumns(it => new { it.N_CURRENT_NUM, it.S_LOCK_STATE, it.N_LOCK_STATE }).ExecuteCommand();

                db.CommitTran();
                res = true;
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                db.RollbackTran();
            }
            return res;
        }

        /// <summary>
        /// 判断逻辑库区是否有可用货位
        /// </summary>
        /// <param name="zone"></param>
        /// <exception cref="NotImplementedException"></exception>
        internal static bool CheckZoneFree(string zone)
        {
            var db = new SqlHelper<object>().GetInstance();
            var count = db.Queryable<ZoneLoc>().Includes(a => a.Loc).Where(a => a.S_ZONE_CODE == zone && a.Loc.N_LOCK_STATE == 0).Count();
            return count > 0;
        }
        internal static ZoneLoc GetZoneLoc(string zone)
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<ZoneLoc>().Includes(a => a.Loc).Where(a => a.S_ZONE_CODE == zone && a.Loc.N_LOCK_STATE == 0 && a.Loc.N_CURRENT_NUM == 0).First();

        }
        internal static List<ZoneLoc> GetZoneByLoc(string loc)
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<ZoneLoc>().Where(a => a.S_LOC_CODE == loc).ToList();

        }

        internal static object GetFunctionCodeByArea(string v1, int v2, int v3)
        {
            throw new NotImplementedException();
        }
        internal static void Test()
        {
            //多查询一次也是可以的，先查出可用的货位组，然后选择货位组中列比较大的，或者列比较小的
            var availableRowGroups = new List<Location>().GroupBy(l => l.N_ROW_GROUP).Where(g => !g.Any(l => l.N_LOCK_STATE != 0)).Select(g => g.Key);

            var db = new SqlHelper<object>().GetInstance();
            //db.Queryable<Location>().Where(a => a.S_AREA_CODE == "11").Where(a => SqlFunc.Subqueryable<Location>().Where(b => b.)).GroupBy(z => z.N_ROW_GROUP).ToList();
        }
    }
}