using Elastic.Clients.Elasticsearch.Tasks;
using Furion.Logging;
using Microsoft.AspNetCore.SignalR;
using OfficeOpenXml.FormulaParsing.Excel.Functions.Logical;
using RazorEngine.Compilation.ImpromptuInterface.Dynamic;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WCS.Application.Entity;
using WCS.Application.Util;

namespace WCS.Application;
public static class PLCCommon
{
    private static readonly ISqlSugarClient _db = SqlSugarSetup.ITenant.GetConnectionScope(SqlSugarConst.MainConfigId);

    /// <summary>
    /// 获取任务相关信息
    /// </summary>
    /// <param name="endLocat">目标位置</param>
    /// <param name="taskType">1:出库任务 2:移库任务</param>
    /// <param name="roadWay">起始巷道</param>
    /// <param name="endRoadWay">目标巷道</param>
    /// <returns></returns>
    public static PlcTaskInfo GetCTaskInfo(string endLocat,string taskType,string roadWay,string endRoadWay) 
    {
        // 各层输送线跺机放货工位集合
        var conveyList1 = new List<string>() { "033", "039", "044", "051", "059" };
        var conveyList2 = new List<string>() { "205", "234" };
        var conveyList3 = new List<string>() { "440", "443" };

        PlcTaskInfo taskInfo = new PlcTaskInfo();
        taskInfo.EndCeng = "3";
        taskInfo.EndLie = "65";
        taskInfo.EndPai = int.Parse(roadWay.Substring(1,2)).ToString();
        

        // 移库任务
        if (taskType == "2") 
        {
            if (roadWay == endRoadWay)                                              // 同巷道移库,获取目标地址
            {
                taskInfo = GetEndPai(endRoadWay.Substring(1, 2),endLocat.Substring(2, 2), endLocat.Substring(0, 2), endLocat.Substring(4, 2), endLocat.Substring(6, 2));
            }
            else                                                                    // 跨巷道移库，获取三楼出库口
            {
                taskInfo.Ip = "10.18.51.130";
                switch (roadWay)
                {
                    case "R01":
                        taskInfo.EndStation = "402";
                        break;
                    case "R02":
                        taskInfo.EndStation = "406";
                        break;
                    case "R03":
                        taskInfo.EndStation = "410";
                        break;
                    case "R04":
                        taskInfo.EndStation = "414";
                        break;
                    case "R05":
                        taskInfo.EndStation = "418";
                        break;
                    case "R06":
                        taskInfo.EndStation = "422";
                        break;
                    case "R07":
                        taskInfo.EndStation = "426";
                        break;
                    case "R08":
                        taskInfo.EndStation = "430";
                        break;
                    case "R09":
                        taskInfo.EndStation = "434";
                        break;
                    case "R10":
                        taskInfo.EndStation = "438";
                        break;
                }
            }
        }

        // 出库任务
        if (taskType == "1") 
        {
            if (conveyList1.Contains(endLocat))
            {
                taskInfo.Ip = "10.18.51.110";
                taskInfo.EndCeng = "1";
                #region 一层输送线
                switch (roadWay)
                {
                    case "R01":
                        taskInfo.EndStation = "147";
                        break;
                    case "R02":
                        taskInfo.EndStation = "139";
                        break;
                    case "R03":
                        taskInfo.EndStation = "129";
                        break;
                    case "R04":
                        taskInfo.EndStation = "121";
                        break;
                    case "R05":
                        taskInfo.EndStation = "111";
                        break;
                    case "R06":
                        taskInfo.EndStation = "103";
                        break;
                    case "R07":
                        taskInfo.EndStation = "093";
                        break;
                    case "R08":
                        taskInfo.EndStation = "85";
                        break;
                    case "R09":
                        taskInfo.EndStation = "75";
                        break;
                    case "R10":
                        taskInfo.EndStation = "67";
                        break;
                }
                #endregion
            }
            else if (conveyList2.Contains(endLocat))
            {
                #region 二层输送线
                taskInfo.Ip = "10.18.51.120";
                taskInfo.EndCeng = "2";
                switch (roadWay)
                {
                    case "R01":
                        taskInfo.EndStation = "254";
                        break;
                    case "R02":
                        taskInfo.EndStation = "262";
                        break;
                    case "R03":
                        taskInfo.EndStation = "272";
                        break;
                    case "R04":
                        taskInfo.EndStation = "280";
                        break;
                    case "R05":
                        taskInfo.EndStation = "290";
                        break;
                    case "R06":
                        taskInfo.EndStation = "294";
                        break;
                    case "R07":
                        taskInfo.EndStation = "309";
                        break;
                    case "R08":
                        taskInfo.EndStation = "317";
                        break;
                    case "R09":
                        taskInfo.EndStation = "327";
                        break;
                    case "R10":
                        taskInfo.EndStation = "331";
                        break;
                }
                #endregion
            }
            else if (conveyList3.Contains(endLocat))
            {
                #region 三层输送线
                taskInfo.Ip = "10.18.51.130";
                taskInfo.EndCeng = "3";
                switch (roadWay)
                {
                    case "R01":
                        taskInfo.EndStation = "402";
                        break;
                    case "R02":
                        taskInfo.EndStation = "406";
                        break;
                    case "R03":
                        taskInfo.EndStation = "410";
                        break;
                    case "R04":
                        taskInfo.EndStation = "414";
                        break;
                    case "R05":
                        taskInfo.EndStation = "418";
                        break;
                    case "R06":
                        taskInfo.EndStation = "422";
                        break;
                    case "R07":
                        taskInfo.EndStation = "426";
                        break;
                    case "R08":
                        taskInfo.EndStation = "430";
                        break;
                    case "R09":
                        taskInfo.EndStation = "434";
                        break;
                    case "R10":
                        taskInfo.EndStation = "438";
                        break;
                }
                #endregion
            }
            else
            {
                throw new Exception("出库口工位未查询到");
            }

        }
        //根据巷道口和层数确认出库工位排


        switch (roadWay)
        {
            case "R01":

                if (taskInfo.EndCeng == "1")
                {
                    taskInfo.EndPai = "2";
                }
                if (taskInfo.EndCeng == "2" || taskInfo.EndCeng == "3")
                {
                    taskInfo.EndPai = "3";
                }
                break;
            case "R02":

                if (taskInfo.EndCeng == "1")
                {
                    taskInfo.EndPai = "2";
                }
                if (taskInfo.EndCeng == "2" || taskInfo.EndCeng == "3")
                {
                    taskInfo.EndPai = "3";
                }
                break;
            case "R03":
                if (taskInfo.EndCeng == "1")
                {
                    taskInfo.EndPai = "2";
                }
                if (taskInfo.EndCeng == "2" || taskInfo.EndCeng == "3")
                {
                    taskInfo.EndPai = "3";
                }
                break;
            case "R04":
                if (taskInfo.EndCeng == "1")
                {
                    taskInfo.EndPai = "2";
                }
                if (taskInfo.EndCeng == "2" || taskInfo.EndCeng == "3")
                {
                    taskInfo.EndPai = "3";
                }
                break;
            case "R05":
                if (taskInfo.EndCeng == "1")
                {
                    taskInfo.EndPai = "2";
                }
                if (taskInfo.EndCeng == "2" || taskInfo.EndCeng == "3")
                {
                    taskInfo.EndPai = "3";
                }
                break;
            case "R06":
                if (taskInfo.EndCeng == "1" || taskInfo.EndCeng == "2" )
                {
                    taskInfo.EndPai = "2";
                }
                if ( taskInfo.EndCeng == "3")
                {
                    taskInfo.EndPai = "3";
                }
                break;
            case "R07":
                if (taskInfo.EndCeng == "1" )
                {
                    taskInfo.EndPai = "2";
                }
                if ( taskInfo.EndCeng == "2" || taskInfo.EndCeng == "3")
                {
                    taskInfo.EndPai = "3";
                }
                break;
            case "R08":
                if (taskInfo.EndCeng == "1")
                {
                    taskInfo.EndPai = "2";
                }
                if (taskInfo.EndCeng == "2" || taskInfo.EndCeng == "3")
                {
                    taskInfo.EndPai = "3";
                }
                break;
            case "R09":
                if (taskInfo.EndCeng == "1")
                {
                    taskInfo.EndPai = "2";
                }
                if (taskInfo.EndCeng == "2" || taskInfo.EndCeng == "3")
                {
                    taskInfo.EndPai = "3";
                }
                break;
            case "R10":
                if (taskInfo.EndCeng == "1" || taskInfo.EndCeng == "2")
                {
                    taskInfo.EndPai = "2";
                }
                if (taskInfo.EndCeng == "3")
                {
                    taskInfo.EndPai = "3";
                }
                break;
        }

        return taskInfo;
    }

    /// <summary>
    /// 根据工位号获取对应的输送线Ip
    /// </summary>
    /// <param name="startStation"></param>
    /// <returns></returns>
    public static PLCUtil GetPlcIp(string startStation) 
    {
        startStation = startStation.PadLeft(3, '0');
        string strIp = "";
        var conveyList1 = new List<string>() { "147", "145", "139", "137", "129", "127", "121", "119", "111", "109", "103", "101", "093", "091", "085", "083", "075", "073", "067", "065","033","039","044" ,"051","059"};
        var conveyList2 = new List<string>() { "205", "234", "252", "254", "260", "262", "270", "272", "278", "280", "288", "290", "294", "301", "307", "309", "315", "317", "325", "327", "331", "337" };
        var conveyList3 = new List<string>() { "401", "402", "405", "406", "409", "410", "413", "414", "417", "418", "421", "422", "425", "426", "429", "430", "433", "434", "437", "438" };
        if (conveyList1.Contains(startStation))
        {
            strIp = "10.18.51.110";
        }
        else if (conveyList2.Contains(startStation))
        {

            strIp = "10.18.51.120";
        }
        else if (conveyList3.Contains(startStation))
        {

            strIp = "10.18.51.130";
        }
        else
        {
            throw Oops.Bah("工位未查询到");
        }
        var plcConveyorConn = PLCTaskAction.listPlcConn.First(m => m.PlcIP == strIp);
        return plcConveyorConn;
    }

    /// <summary>
    /// 根据wms目标地址转换为Plc目标地址	03010301
    /// </summary>
    /// <param name="road">巷道02</param>
    /// <param name="lie">列01</param>
    /// <param name="pai">排03</param>
    /// <param name="ceng">层</param>
    /// <param name="dept">深度01</param>
    /// <returns></returns>
    public static PlcTaskInfo GetEndPai(string road,string lie, string pai,string ceng, string dept) 
    {
        var roadNum = int.Parse(road);
        var lieNum = int.Parse(lie);
        var paiNum = int.Parse(pai);
        var cengNum = int.Parse(ceng);
        var deptNum = int.Parse(dept);

        var paiVal = 0;
        // 判断巷道奇偶数
        //if (roadNum % 2 == 0)// 偶数
        //{
        //    // 判断排奇偶数
        //    if (paiNum % 2 == 0)
        //    {
        //        if (deptNum == 1)
        //        {
        //            paiVal = 3;
        //        }
        //        else
        //        {
        //            paiVal = 4;
        //        }
        //    }
        //    else
        //    {
        //        if (deptNum == 1)
        //        {
        //            paiVal = 2;
        //        }
        //        else
        //        {
        //            paiVal = 1;
        //        }
        //    }

        //}
        //else   // 奇数
        //{
            // 判断排奇偶数
            if (paiNum % 2 == 0)
            {
                if (deptNum == 1)
                {
                    paiVal = 3;
                }
                else
                {
                    paiVal = 4;
                }
            }
            else
            {
                if (deptNum == 1)
                {
                    paiVal = 2;

                }
                else
                {
                    paiVal = 1;

                }
            }
        //}

        PlcTaskInfo taskInfo = new PlcTaskInfo();
        taskInfo.EndPai = paiVal.ToString();
        taskInfo.EndCeng = cengNum.ToString();
        taskInfo.EndLie = lieNum.ToString() ;
        if (taskInfo.EndPai == "0" || taskInfo.EndCeng == "0" || taskInfo.EndLie == "0")
        {
            throw new Exception("排列层转换失败");
        }
        return taskInfo;
    }
    
    /// <summary>
    /// 根据目标组获取位置最优的四项车取货工位
    /// </summary>
    /// <param name="endRoadway">目标组</param>
    /// <param name="ceng">申请工位</param>
    /// <returns></returns>
    public static string RoadwayToStationNum(string endRoadway, string ceng)
    {
        string stationNum = "";

        string[] lists = endRoadway.Split("MR");
        var model = _db.Queryable<WcsStorageLocat>().First(m => m.RoadwayNo == endRoadway && m.IsDelete == false);
        string stat = model.AisleOne;

        if (model.Layer == 1)
        {   // 一层
            switch (ceng)       // 申请的入库口
            {
                case "009":
                    
                    var path13 = Math.Abs(19 - int.Parse(stat.Substring(0,2))) + Math.Abs(6 - int.Parse(stat.Substring(2,2)));
                    var path14 = Math.Abs(19 - int.Parse(stat.Substring(0,2))) + Math.Abs(12 - int.Parse(stat.Substring(2,2)));

                    if (path13 <= path14)
                    {
                        stationNum = "013";
                    }
                    else 
                    {
                        stationNum = "014";
                    }

                    ; break;
                case "017":
                    stationNum = "002"
                    ; break;
                case "018":
                    var path03 = Math.Abs(03 - int.Parse(stat.Substring(0, 2))) + Math.Abs(06 - int.Parse(stat.Substring(2, 2)));
                    var path05 = Math.Abs(03 - int.Parse(stat.Substring(0, 2))) + Math.Abs(12 - int.Parse(stat.Substring(2, 2)));

                    if (path03 <= path05)
                    {
                        stationNum = "003";
                    }
                    else
                    {
                        stationNum = "005";
                    }

                    ; break;
                default: break;
            }
        }
        else 
        {  // 二层
            switch (ceng)       // 申请的入库口
            {
                case "009":

                    var path15 = Math.Abs(19 - int.Parse(stat.Substring(0, 2))) + Math.Abs(6 - int.Parse(stat.Substring(2, 2)));
                    var path16 = Math.Abs(19 - int.Parse(stat.Substring(0, 2))) + Math.Abs(12 - int.Parse(stat.Substring(2, 2)));

                    if (path15 <= path16)
                    {
                        stationNum = "015";
                    }
                    else
                    {
                        stationNum = "016";
                    }

          ; break;
                case "017":
                    stationNum = "006"
                    ; break;
                case "018":
                    var path03 = Math.Abs(03 - int.Parse(stat.Substring(0, 2))) + Math.Abs(06 - int.Parse(stat.Substring(2, 2)));
                    var path05 = Math.Abs(03 - int.Parse(stat.Substring(0, 2))) + Math.Abs(12 - int.Parse(stat.Substring(2, 2)));

                    if (path03 <= path05)
                    {
                        stationNum = "007";
                    }
                    else
                    {
                        stationNum = "008";
                    }

          ; break;
                default: break;
            }
        }

        return stationNum;
    }


    /// <summary>
    /// 根据工位号获取对应巷道 
    /// </summary>
    /// <param name="StationNum">入出工位号</param>
    /// <returns>跺机联机</returns>
    public static string GetRoadwayByStation(string StationNum)
    {
        StationNum = StationNum.PadLeft(3, '0');

        string value = "";
        var conveyList1 = new List<string>() { "147", "145", "252", "254", "401", "402", };
        var conveyList2 = new List<string>() { "139", "137", "260", "262", "405", "406", };
        var conveyList3 = new List<string>() { "129", "127", "272", "270", "409", "410", };
        var conveyList4 = new List<string>() { "121", "119", "278", "280", "413", "414", };
        var conveyList5 = new List<string>() { "111", "109", "288", "290", "417", "418", };
        var conveyList6 = new List<string>() { "103", "101", "294", "301", "421", "422", };
        var conveyList7 = new List<string>() { "093", "091", "307", "309", "425", "426", };
        var conveyList8 = new List<string>() { "085", "083", "315", "317", "429", "430", };
        var conveyList9 = new List<string>() { "075", "073", "325", "327", "433", "434", };
        var conveyList10 = new List<string>() { "067", "065", "331", "337", "437", "438", };

        if (conveyList1.Contains(StationNum))
        {
            value = "R01";
        }
        else if (conveyList2.Contains(StationNum))
        {
            value = "R02";
        }
        else if (conveyList3.Contains(StationNum))
        {
            value = "R03";
        }
        else if (conveyList4.Contains(StationNum))
        {
            value = "R04";
        }
        else if (conveyList5.Contains(StationNum))
        {
            value = "R05";
        }
        else if (conveyList6.Contains(StationNum))
        {
            value = "R06";
        }
        else if (conveyList7.Contains(StationNum))
        {
            value = "R07";
        }
        else if (conveyList8.Contains(StationNum))
        {
            value = "R08";
        }
        else if (conveyList9.Contains(StationNum))
        {
            value = "R09";
        }
        else if (conveyList10.Contains(StationNum))
        {
            value = "R10";
        }

        return value;
    }

    /// <summary>
    /// 根据巷道口出入库工位号获取对应楼层 
    /// </summary>
    /// <param name="StationNum">入出工位号</param>
    /// <returns>跺机联机</returns>
    public static string GetRoadwayByStationNew(string StationNum)
    {
        string value = "";
        //var conveyList1 = new List<string>() { "147", "145", "139", "137", "129", "127", "121", "119", "111", "109", "103", "101", "093", "091", "085", "083", "075", "073", "067", "065" };
        //var conveyList2 = new List<string>() { "252", "254", "260", "262", "272", "270", "278", "280", "288", "290", "294", "301", "307", "309", "315", "317", "325", "327", "331", "337" };
        //var conveyList3 = new List<string>() { "401", "402", "405", "406", "409", "410", "413", "414", "417", "418", "421", "422", "425", "426", "429", "430", "433", "434", "437", "438" };

       var ipInfo = _db.Queryable<WcsPlc>().Where(s =>  s.Type == PLCTypeEnum.ConveyorLine && s.IsDelete == false).ToList();  //s.Type == PLCTypeEnum.StackingMachine ||
        var ip1 = ipInfo.First(m => m.Text == "1层托盘输送线");
        var ip2 = ipInfo.First(m => m.Text == "2层托盘输送线");
        var ip3 = ipInfo.First(m => m.Text == "3层托盘输送线");

        if (ip1 != null) 
        {
            var dev1 = PLCTaskAction.plcDevices.Where(m => m.IsDelete == false && m.PlcId == ip1.Id).Select(m => m.StationNum).ToList();
            if (dev1.Contains(StationNum))
            {
                value = "1";
                return value;
            }
        }

        if (ip2 != null)
        {
            var dev2 = PLCTaskAction.plcDevices.Where(m => m.IsDelete == false && m.PlcId == ip2.Id).Select(m => m.StationNum).ToList();
            if (dev2.Contains(StationNum))
            {
                value = "2";
                return value;
            }
        }

        if (ip3 != null)
        {
            var dev3 = PLCTaskAction.plcDevices.Where(m => m.IsDelete == false && m.PlcId == ip3.Id).Select(m => m.StationNum).ToList();
            if (dev3.Contains(StationNum))
            {
                value = "3";
                return value;
            }
        }

        return "";
    }

    /// <summary>
    /// 根据巷道号、层数 获取对应的跺机IP及入库工位排列层信息
    /// </summary>
    /// <param name="roadway">巷道号</param>
    /// <param name="ceng">连接集合</param>
    /// <returns></returns>
    public static StokInfo GetStokePlc(string roadway, string ceng)
    {

        StokInfo sInfo = new StokInfo();
        sInfo.Pai = "2";


        switch (roadway)
        {
            case "R01":
                sInfo.Ip = "10.18.51.10";
                if (ceng == "1")
                {
                    sInfo.Pai = "3";
                }
                break;
            case "R02":
                sInfo.Ip = "10.18.51.20";
                if (ceng == "1")
                {
                    sInfo.Pai = "3";
                }
                break;
            case "R03":
                sInfo.Ip = "10.18.51.30";
                if (ceng == "1")
                {
                    sInfo.Pai = "3";
                }
                break;
            case "R04":
                sInfo.Ip = "10.18.51.40";
                if (ceng == "1")
                {
                    sInfo.Pai = "3";
                }
                break;
            case "R05":
                sInfo.Ip = "10.18.51.50";
                if (ceng == "1")
                {
                    sInfo.Pai = "3";
                }
                break;
            case "R06":
                sInfo.Ip = "10.18.51.60";
                if (ceng == "2" || ceng == "1")
                {
                    sInfo.Pai = "3";
                }
                break;
            case "R07":
                sInfo.Ip = "10.18.51.70";
                if (ceng == "1")
                {
                    sInfo.Pai = "3";
                }
                break;
            case "R08":
                sInfo.Ip = "10.18.51.80";
                if (ceng == "1")
                {
                    sInfo.Pai = "3";
                }
                break;
            case "R09":
                sInfo.Ip = "10.18.51.90";
                if (ceng == "1")
                {
                    sInfo.Pai = "3";
                }
                break;
            case "R10":
                sInfo.Ip = "10.18.51.100";
                if (ceng == "2" || ceng == "1")
                {
                    sInfo.Pai = "3";
                }
                break;
        }

        sInfo.Lie = "65";
        sInfo.Ceng = "1";

        if (ceng == "2")
        {
            sInfo.Ceng = "2";
        }
        if (ceng == "3")
        {
            sInfo.Ceng = "3";
        }
        return sInfo;
    }


    /// <summary>
    /// 根据储位排获取跺机对应的地址排03010302
    /// </summary>
    /// <param name="road">排02</param>
    /// <param name="pai">排03</param>
    /// <param name="dept">深度02</param>
    /// <returns></returns>
    public static int GetDjAdress(string road, string pai, string dept)
    {
        var roadNum = int.Parse(road);
        var paiNum = int.Parse(pai);
        var deptNum = int.Parse(dept);

        var paiVal = 0;
        //// 判断巷道奇偶数
        //if (roadNum % 2 == 0)// 偶数
        //{
        //    // 判断排奇偶数
        //    if (paiNum % 2 == 0)
        //    {
        //        if (deptNum == 1)
        //        {
        //            paiVal = 3;
        //        }
        //        else
        //        {
        //            paiVal = 4;
        //        }
        //    }
        //    else
        //    {
        //        if (deptNum == 1)
        //        {
        //            paiVal = 2;
        //        }
        //        else
        //        {
        //            paiVal = 1;
        //        }
        //    }

        //}
        //else   // 奇数
        //{
            // 判断排奇偶数
            if (paiNum % 2 == 0)
            {
                if (deptNum == 1)
                {
                    paiVal = 3;
                }
                else
                {
                    paiVal = 4;
                }
            }
            else
            {
                if (deptNum == 1)
                {
                    paiVal = 2;

                }
                else
                {
                    paiVal = 1;

                }
            }
        //}
        if (paiVal == 0)
        {
            Log.Error("排转换失败!");
            throw new Exception("排转换失败");
        }
        return paiVal;

    }


}