using HH.WCS.JingyuNongfu.device;
using HH.WCS.JingyuNongfu.wms;
using HH.WCS.JingyuNongfu.process;
using HH.WCS.JingyuNongfu.util;
using Newtonsoft.Json;
using System.Collections.Generic;
using System.Linq;
using System.Threading;
using static HH.WCS.JingyuNongfu.api.ApiModel;
using static HH.WCS.JingyuNongfu.util.Settings;
using System;

namespace HH.WCS.JingyuNongfu.api
{
    /// <summary>
    /// api接口辅助类
    /// </summary>
    public class ApiHelper
    {
        static ApiHelper()
        {

        }

        /// <summary>
        /// 绑定托盘物料
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        internal static ReturnResult BindArea(BindArea model)
        {
            ReturnResult result = new ReturnResult { ResultCode = 0, ResultMsg = "绑定成功" };
            var db = new SqlHelper<object>().GetInstance();

            try
            {

                var locList = db.Queryable<Location>().Where(a => a.S_AREA_CODE == model.AreaCode).ToList();
                if (locList.Count > 0)
                {
                    var IsLoct = locList.Find(a => a.S_LOCK_STATE.Trim() != "无");
                    if (IsLoct != null)
                    {
                        result.ResultCode = -1;
                        result.ResultMsg = "库区存在货位有锁，不允许绑定托盘物料";
                        return result;
                    }
                    locList.ForEach(a =>
                    {
                        if (a.N_CURRENT_NUM == 0)
                        {
                            LogHelper.Info($"货位{a.S_LOC_CODE}库区绑定，绑定物料{model.ItemCode}");
                            var traylist = ContainerHelper.GenerateCntrNo();
                            ContainerHelper.CreateCntrItem(a.S_LOC_CODE, traylist, model.ItemCode);
                        }

                    });

                }
                else
                {
                    result.ResultCode = -1;
                    result.ResultMsg = "根据库区找不到货位";
                    return result;
                }
                return result;
            }
            catch (Exception ex)
            {
                result.ResultCode = -1;
                result.ResultMsg = ex.ToString();
                return result;
            }

        }

        /// <summary>
        /// 解绑库区
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        internal static ReturnResult UntieArea(UntieArea model)
        {
            ReturnResult result = new ReturnResult { ResultCode = 0, ResultMsg = "解绑成功" };
            var db = new SqlHelper<object>().GetInstance();
            try
            {

                var locList = db.Queryable<Location>().Where(a => a.S_AREA_CODE == model.AreaCode).ToList();
                if (locList.Count > 0)
                {
                    var IsLoct = locList.Find(a => a.S_LOCK_STATE.Trim() != "无");
                    if (IsLoct != null)
                    {
                        result.ResultCode = -1;
                        result.ResultMsg = "库区存在货位有锁，不允许解绑托盘";
                        return result;
                    }
                    locList.ForEach(a =>
                    {
                        if (a.N_CURRENT_NUM > 0)
                        {
                            var cntr = db.Queryable<LocCntrRel>().Where(b => b.S_LOC_CODE == a.S_LOC_CODE).First();
                            if (cntr != null)
                            {
                                //起点终点解绑 删除托盘表托盘
                                LogHelper.Info($"货位{a.S_LOC_CODE}库区解绑，删除容器{cntr.S_CNTR_CODE}");
                                LocationHelper.UnBindingLoc(a.S_LOC_CODE, cntr.S_CNTR_CODE.Split(',').ToList());
                                var tpid = cntr.S_CNTR_CODE.Split(',');
                                foreach (var item in tpid)
                                {
                                    ContainerHelper.delCntrAndItem(item);
                                }
                            }

                        }

                    });

                }
                else
                {
                    result.ResultCode = -1;
                    result.ResultMsg = "根据库区找不到货位";
                    return result;
                }
                return result;
            }
            catch (Exception ex)
            {
                result.ResultCode = -1;
                result.ResultMsg = ex.ToString();
                return result;
            }


        }
        internal static Location FindEndcolByLocList(List<Location> locations)
        {
            try
            {
                Location end = null;
                var db = new SqlHelper<object>().GetInstance();
                //根据终点货位找空闲货位
                var rows = locations.Select(a => a.N_ROW).Distinct().ToList();
                for (int i = 0; i < rows.Count; i++)
                {
                    var rowList = locations.Where(r => r.N_ROW == rows[i]).ToList();
                    if (rowList.Count(a => a.S_LOCK_STATE != "无") == 0 && rowList.Count(a => a.N_CURRENT_NUM == 0) > 0)
                    {
                        Location other = null;
                        //当前排没有锁并且有空位置
                        //先找满位，然后后面一位要么是空，要么不存在
                        var full = rowList.OrderByDescending(a => a.N_COL).Where(a => a.N_CURRENT_NUM == 1).FirstOrDefault();
                        if (full == null)
                        {

                            //没有满位，那就找最小的空位
                            other = rowList.OrderBy(a => a.N_COL).FirstOrDefault();
                        }
                        else
                        {
                            other = rowList.OrderBy(a => a.N_COL).Where(a => a.N_COL > full.N_COL).FirstOrDefault();
                        }
                        if (other != null && (!string.IsNullOrEmpty(other.C_ENABLE) && other.C_ENABLE == "禁用"))
                        {
                            //禁用了选择后面一个货位
                            other = db.Queryable<Location>().OrderBy(a => a.N_COL).Where(a => (string.IsNullOrEmpty(a.C_ENABLE) || a.C_ENABLE.Trim() != "禁用") && a.S_AREA_CODE == other.S_AREA_CODE && a.N_ROW == other.N_ROW && a.N_COL > other.N_COL).First();

                            //LogHelper.Info($"禁用选择后一个货位{result}", "成品");
                        }
                        if (other != null)
                        {
                            end = other;
                            break;

                        }

                    }
                }
                return end;
            }
            catch (Exception)
            {

                throw;
            }

        }
        /// <summary>
        /// 清洁空框位
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        internal static SimpleResult CleanReport(LocationModel model)
        {
            var result = new SimpleResult() { resultMsg = $"货位{model.location}清洁报工成功" };
            //1\3\4 可清洁
            var cntr = LocationHelper.GetLocCntr(model.location);
            if (cntr.Count > 0)
            {
                ContainerHelper.UpdateCntrState(new List<string> { cntr[0].S_CNTR_CODE.Trim() }, "已清洁");
            }
            else
            {
                result.resultCode = 1;
                result.resultMsg = $"货位{model.location}不存在，或者没有容器";
            }
            JingyuNongfu.LogHelper.Debug("CleanReport Response：" + JsonConvert.SerializeObject(result));
            return result;
        }


        /// <summary>
        /// 重置信号
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        internal static SimpleResult ResetDevice(DeviceModel model)
        {
            var result = new SimpleResult();
            deviceInfo plc = null;
            if (string.IsNullOrEmpty(model.type))
            {
                plc = Settings.deviceInfos.Where(a => a.deviceName == model.deviceName).FirstOrDefault();
            }
            else
            {
                if (model.type == "下满复位")
                {
                    plc = Settings.deviceInfos.Where(a => a.deviceName == model.deviceName && a.deviceNo[0] == "1").FirstOrDefault();
                }
                else
                {
                    plc = Settings.deviceInfos.Where(a => a.deviceName == model.deviceName && a.deviceNo[0] == "2").FirstOrDefault();
                }
            }

            if (plc != null)
            {
                if (model.deviceName.Contains("无菌"))
                {
                    LogHelper.Info($"调用接口发送信号", "发送信号");
                    if (PlcHelper.SendHex(plc.address, "3F00100D0A"))
                    {
                        Thread.Sleep(300);
                        PlcHelper.SendHex(plc.address, "3F00200D0A");

                    }
                    else
                    {
                        result.resultCode = 2;
                        result.resultMsg = "满托重置信号发送失败";
                    }

                }
                else if (model.deviceName.Contains("翻斗机"))
                {
                    if (PlcHelper.SendHex(plc.address, "3F0010200D0A"))
                    {

                    }
                    else
                    {
                        result.resultCode = 2;
                        result.resultMsg = "重置信号发送失败";
                    }
                }
                else if (model.deviceName.Contains("成品"))
                {
                    if (model.type == "下满复位")
                    {
                        if (model.deviceName.Contains("靖宇成品仓E12输送线"))
                        {
                            PlcHelper.SendHex(plc.address, "3F00200D0A");
                        }
                        else
                        {
                            PlcHelper.SendHex(plc.address, "3F00100D0A");
                        }

                    }
                    else
                    {
                        PlcHelper.SendHex(plc.address, "3F00200D0A");
                    }
                }
                else
                {
                    if (PlcHelper.SendHex(plc.address, "3F00100D0A"))
                    {

                    }
                    else
                    {
                        result.resultCode = 2;
                        result.resultMsg = "重置信号发送失败";
                    }

                }

            }
            else
            {
                result.resultCode = 1;
                result.resultMsg = "设备不存在，请检查设备名称";
            }
            return result;
        }


        internal static void AddTask(AddTaskModel model)
        {
            if (!TaskHelper.CheckExist(model.No))
            {
                if (LocationHelper.CheckExist(model.From) && LocationHelper.CheckExist(model.To))
                {
                    TaskHelper.CreateTask(model.No, model.From, model.To, "搬运", 99, "");
                }

            }
        }

        public class AddTaskModel
        {
            public string From { get; set; }
            public string To { get; set; }
            public string No { get; set; }
        }
        public class LocationModel
        {
            public string location { get; set; }
        }
        public class DeviceModel
        {
            /// <summary>
            /// 瓶盖机名称
            /// </summary>
            public string deviceName { get; set; }
            /// <summary>
            /// 1 、2
            /// </summary>
            //public int order { get; set; }
            public string type { get; set; }
        }
        public class RowInfo
        {
            public string area { get; set; }
            public int row { get; set; }
        }

    }
}