using System;
using System.Collections.Generic;
using System.Linq;

using HH.WCS.Mobox3.DSZSH.Dispatch;
using HH.WCS.Mobox3.DSZSH.Helpers;
using HH.WCS.Mobox3.DSZSH.Models;
using HH.WCS.Mobox3.DSZSH.Helper;

using Newtonsoft.Json;

using SqlSugar;

using static HH.WCS.Mobox3.DSZSH.Dtos.Response.MoboxResponse;
using static HH.WCS.Mobox3.DSZSH.Helpers.ResultHelper;

namespace HH.WCS.Mobox3.DSZSH.Helpers.Model {
    /// <summary>
    /// 任务帮助类
    /// </summary>
    public class TaskHelper {
        /// <summary>
        /// 生成任务号
        /// </summary>
        /// <returns></returns>
        private static string GenerateTaskNo() {
            var id = SysHelper.GetSerialNumber("任务号", "TN");
            var date = DateTime.Now.ToString("yyMMdd");
            return $"TN{date}{id.ToString().PadLeft(4, '0')}";
        }

        /// <summary>
        /// 创建搬运任务，返回任务是否创建成功
        /// </summary>
        /// <remarks>
        /// 不会检查参数合法性，使用前请确保货位号和容器号存在
        /// </remarks>
        /// <param name="from">起点货位号</param>
        /// <param name="cnt">容器号</param>
        /// <param name="to">终点货位号</param>
        /// <param name="type">任务类型/名称</param>
        /// <param name="pri">优先级</param>
        /// <returns></returns>
        public static bool CreateTask(string from, string cnt, string to, string type, int pri = 3) {
            var startLoc = LocationHelper.GetLocation(from);
            var endLoc = LocationHelper.GetLocation(to);

            TN_Task TN_Task = new TN_Task() {
                S_CODE = GenerateTaskNo(),
                S_START_AREA = startLoc?.S_AREA_CODE ?? "", // 如果为null返回空字符串
                S_END_AREA = endLoc?.S_AREA_CODE ?? "", // 如果为null返回空字符串
                S_START_LOC = from,
                S_END_LOC = to,
                S_TYPE = type,
                N_PRIORITY = pri,
                N_SCHEDULE_TYPE = 1,
                N_B_STATE = 0,
                S_CNTR_CODE = cnt,
                T_START_TIME = DateTime.Now,
            };

            var db = DbHelper.GetDbClient();
            var log = JsonConvert.SerializeObject(TN_Task);
            try {
                // 内部不使用事务（只涉及单个插入操作），由外部声明事务
                var res = db.Insertable(TN_Task).ExecuteCommand() > 0;
                if (res) {
                    LogHelper.Info($"插入任务成功：{log}");
                }
                else {
                    LogHelper.Info($"插入任务失败：{log}");
                }
                return res;
            }
            catch (Exception ex) {
                LogHelper.InfoEx(ex);
                return false;
            }
        }

        /// <summary>
        /// 创建任务，并将 是否创建成功 的信息通过 <see cref="LogHelper.Info(string, string)"/> 打印日志
        /// </summary>
        /// <param name="from">起点货位号</param>
        /// <param name="cnt">容器号</param>
        /// <param name="to">终点货位号</param>
        /// <param name="type">任务类型/名称</param>
        /// <param name="pri">优先级</param>
        /// <returns>创建任务是否成功</returns>
        public static bool LogCreateTask(string from, string cnt, string to, string type, int pri = 3) {
            var db = DbHelper.GetDbClient();
            using (var tran = db.Ado.UseTran()) {
                if (TaskHelper.CreateTask(from, cnt, to, type, pri)) {
                    LocationHelper.LockLoc(from, 2); // 起点出库锁，
                    LocationHelper.LockLoc(to, 1); // 终点入库锁
                    tran.CommitTran();
                    LogHelper.Info($"生成 '{type}' 成功，容器号 '{cnt}'，起点 '{from}'，终点 '{to}'");
                    return true;
                }
                else {
                    tran.RollbackTran();
                    LogHelper.Info($"生成 '{type}' 失败，容器号 '{cnt}'，起点 '{from}'，终点 '{to}'");
                    return false;
                }
            }
        }

        /// <summary>
        /// 创建任务，使用 <see cref="SimpleResult"/> 返回结果
        /// </summary>
        /// <param name="from">起点货位号</param>
        /// <param name="cnt">容器号</param>
        /// <param name="to">终点货位号</param>
        /// <param name="type">任务类型/名称</param>
        /// <param name="pri">优先级（默认为 3）</param>
        /// <param name="failCode">创建失败时返回的 result code</param>
        /// <returns></returns>
        public static SimpleResult SimpleCreateTask(string from, string cnt, string to, string type, int pri = 3, int failCode = 5) {
            var db = DbHelper.GetDbClient();
            using (var tran = db.Ado.UseTran()) {
                if (TaskHelper.CreateTask(from, cnt, to, type, pri)) {
                    LocationHelper.LockLoc(from, 2); // 起点出库锁，
                    LocationHelper.LockLoc(to, 1); // 终点入库锁
                    return BuildSimpleResult(0, $"生成 '{type}' 成功，容器号 '{cnt}'，起点 '{from}'，终点 '{to}'");
                }
                else {
                    return BuildSimpleResult(failCode, $"生成 '{type}' 失败，容器号 '{cnt}'，起点 '{from}'，终点 '{to}'");
                } 
            }
        }

        //public static SimpleResult SimpleService(string taskName) {
        //    var db = DbHelper.GetDbClient();

        //    try {
                
                
        //    }
        //    catch (Exception) {

        //        throw;
        //    }
        //}

        /// <summary>
        /// 取货卸货完成，缓存位状态更新
        /// </summary>
        /// <param name="mst"></param>
        /// <param name="load"></param>
        internal static void CacheBitUpdate(TN_Task mst, bool load) {
            var trayCarryCount = mst.N_CNTR_COUNT > 0 ? mst.N_CNTR_COUNT : 1;
            if (load) {
                Console.WriteLine($"任务{mst.S_CODE} 货位{mst.S_START_LOC}取货完成，起点解绑容器{mst.S_CNTR_CODE}");
                LogHelper.Info($"任务{mst.S_CODE} 货位{mst.S_START_LOC}取货完成，起点解绑容器{mst.S_CNTR_CODE}");
                LocationHelper.UnBindingLoc(mst.S_START_LOC, mst.S_CNTR_CODE.Split(',').ToList());
            }
            else {
                Console.WriteLine($"任务{mst.S_CODE} 货位{mst.S_END_LOC}卸货完成，终点绑定容器{mst.S_CNTR_CODE}");
                LogHelper.Info($"任务{mst.S_CODE} 货位{mst.S_END_LOC}卸货完成，终点绑定容器{mst.S_CNTR_CODE}");
                LocationHelper.BindingLoc(mst.S_END_LOC, mst.S_CNTR_CODE.Split(',').ToList());
            }
        }

        /// <summary>
        /// 任务取消，缓存位状态更新
        /// </summary>
        /// <param name="mst"></param>
        internal static void CacheBitCancelUpdate(TN_Task mst) {
            //任务取消，取货完成前的，起点的loadingCount和终点unLoadingCount都清除，取货完成的只处理终点
            if (CheckActionRecordExist(mst.S_CODE, 4)) {
                //根据客户现场要求，如果取货完成任务失败人工拉到终点，我们就当卸货完成处理；如果是人工拉走到其它区域，我们就解锁终点，删除托盘。
                //终点绑定
                CacheBitUpdate(mst, false);
                LocationHelper.UnLockLoc(mst.S_END_LOC);
            }
            else {

                //起点终点解锁
                LocationHelper.UnLockLoc(mst.S_START_LOC);
                LocationHelper.UnLockLoc(mst.S_END_LOC);

            }

        }

        

        /// <summary>
        /// 任务状态更新处理
        /// </summary>
        /// <param name="mst"></param>
        /// <param name="state"></param>
        internal static void OperateStatus(TN_Task mst, int state) {
            if (state == 4) 
            {
                CacheBitUpdate(mst, true);
            }
            if (state == 6)//卸货完成
            {
                CacheBitUpdate(mst, false);
            }
            if (state == 7) {
                CacheBitCancelUpdate(mst);
            }
        }

        /// <summary>
        /// 安全请求
        /// </summary>
        /// <param name="no"></param>
        /// <param name="state"></param>
        /// <param name="forkliftNo"></param>
        /// <param name="extData"></param>
        internal static void OperateReq(string no, int state, string forkliftNo, string extData = "")
        {
            if (state == 1101)
            {
                //请求取货，

            }
            if (state == 1102)
            {
                //请求卸货，
                //根据终点判断，是cb02的入口，判断内存中状态（要状态时间），允许卸货，通知agv改参数
                var dic = new Dictionary<string, string>();
                //< Req >< Order No = 'TN2302020002' ParamNo = '18' Param1 = '12' /></ Req >
                dic.Add("No", no);
                dic.Add("ParamNo", "8");
                dic.Add("Param1", "1");
                NDC.ChangeOrder(dic);
                //改完参数车子就会自己卸货
            }
            if (state == 1103)
            {
                //大铁框叉走以后通知，我们要通知输送线
            }
        }

        private static object locLocker = new object();


        


        internal static bool UpdateStatus(TN_Task task, string status) {
            var res = false;
            var db = DbHelper.GetDbClient();
            task.S_B_STATE = status;
            res = db.Updateable(task).UpdateColumns(it => new { it.S_B_STATE }).ExecuteCommand() > 0;
            return res;
        }


        internal static bool UpdateStatus(TN_Task task) {
            var res = false;
            var db = DbHelper.GetDbClient();
            task.S_B_STATE = TN_Task.GetStateStr(task.N_B_STATE);
            task.T_MODIFY = DateTime.Now;
            db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_MODIFY }).ExecuteCommand();
            return res;
        }

        internal static bool UpdateEqNo(TN_Task task) {
            var res = false;
            var db = DbHelper.GetDbClient();
            task.T_MODIFY = DateTime.Now;
            db.Updateable(task).UpdateColumns(it => new { it.S_EQ_TASK_CODE, it.T_MODIFY }).ExecuteCommand();
            return res;
        }

        internal static TN_Task GetTask(string no) {
            var db = DbHelper.GetDbClient();
            var task = db.Queryable<TN_Task>().Where(a => a.S_CODE == no).First();
            return task;
        }

        public static bool CreateTask(List<CreateTasks> modes) {
            if (modes != null && modes.Count > 0) {
                List<TN_Task> tN_Tasks = new List<TN_Task>();

                foreach (var item in modes) {

                    var fromLoc = LocationHelper.GetLocation(item.from);
                    var endLoc = LocationHelper.GetLocation(item.to);

                    tN_Tasks.Add(new TN_Task() {
                        S_CODE = GenerateTaskNo(),
                        S_START_AREA = fromLoc.S_AREA_CODE,
                        S_END_AREA = endLoc.S_AREA_CODE,
                        S_START_LOC = item.from,
                        S_END_LOC = item.to,
                        S_TYPE = item.taskType,
                        N_PRIORITY = item.pri,
                        N_SCHEDULE_TYPE = 1,
                        N_B_STATE = 0,
                        S_CNTR_CODE = item.cntrInfo,
                    });
                }
                var log = JsonConvert.SerializeObject(tN_Tasks);
                var db = DbHelper.GetDbClient();
                var res = db.Insertable<TN_Task>(tN_Tasks).ExecuteCommand() > 0;
                if (res) {
                    LogHelper.Info($"插入任务成功，{log}");
                }
                else {
                    LogHelper.Info($"插入任务失败，{log}");
                }
                return res;
            }

            return false;
        }


        internal static bool CheckActionRecordExist(string no, int code) {
            var db = DbHelper.GetDbClient();
            return db.Queryable<TN_Task_Action>().Count(a => a.S_TASK_CODE == no && a.N_ACTION_CODE == code) > 0;
        }

        internal static void Begin(TN_Task task, string forklift_no) {
            var db = DbHelper.GetDbClient();
            if (task != null) {
                if (task.N_B_STATE == 1) {
                    task.N_B_STATE = 2;
                    task.S_B_STATE = TN_Task.GetStateStr(task.N_B_STATE);
                    task.T_START_TIME = System.DateTime.Now;
                    task.S_EQ_NO = forklift_no;
                    db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_START_TIME, it.S_EQ_NO }).ExecuteCommand();
                }

            }
        }

        internal static void End(TN_Task task) {
            var db = DbHelper.GetDbClient();
            if (task != null) {
                task.N_B_STATE = 3;
                task.S_B_STATE = TN_Task.GetStateStr(task.N_B_STATE);
                task.T_END_TIME = DateTime.Now;
                db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_END_TIME }).ExecuteCommand();
            }
        }

        internal static void Fail(TN_Task task) {
            var db = DbHelper.GetDbClient();
            if (task != null) {
                //判断有没有取货完成，没有就变成失败。有取货完成默认完成了（跟据项目而定，有些项目人工拉走了也没有放到终点）。
                task.N_B_STATE = 4;
                task.S_B_STATE = TN_Task.GetStateStr(task.N_B_STATE);
                db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE }).ExecuteCommand();
            }
        }

        internal static bool AddActionRecord(string no, int state, string forkliftNo, string extData) {
            var db = DbHelper.GetDbClient();
            var action = new TN_Task_Action() {
                N_ACTION_CODE = state,
                S_TASK_CODE = no,
                S_EQ_CODE = forkliftNo,
                S_EQ_TYPE = "agv",
                S_DATA = extData
            };
            return db.Insertable(action).ExecuteCommand() > 0;
        }

        internal static List<TN_Task> GetWaitingTaskList() {
            var db = DbHelper.GetDbClient();
            return db.Queryable<TN_Task>().Where(a => a.N_B_STATE == 0 && (a.S_B_STATE == "等待" || a.S_B_STATE == "待推送")).ToList();
        }
    }

    public class CreateTasks {
        public string from { set; get; }
        public string to { set; get; }
        public string taskType { set; get; }
        public int pri { set; get; }
        public string cntrInfo { set; get; }
    }
}