using System.Collections.Generic;
using System.Linq;
using System.Web.Http;

using HH.WCS.Mobox3.AnGang.core;
using HH.WCS.Mobox3.AnGang.models;
using HH.WCS.Mobox3.AnGang.util;

using Newtonsoft.Json;

using SqlSugar;

using static HH.WCS.Mobox3.AnGang.api.ApiModel;
using static HH.WCS.Mobox3.AnGang.api.OtherModel;
using static HH.WCS.Mobox3.AnGang.dispatch.NDC;

namespace HH.WCS.Mobox3.AnGang.api {
    /// <summary>
    /// 第三方调用的接口
    /// </summary>
    [RoutePrefix("api")]
    public class WmsController : System.Web.Http.ApiController {
        [HttpGet]
        [Route("GetKanbanAgvState")]
        public KanbanAgvState GetKanbanAgvState() {
            LogHelper.Info("触发API：GetKanbanAgvState：看板获取AGV状态", "API");

            var res = WCSCore.AgvState;
            var resName = string.Empty;
            switch (res) {
                case "in_system": resName = "系统内"; break;
                case "out_system": resName = "系统外"; break;
                case "online": resName = "在线"; break;
                case "offline": resName = "离线"; break;
                case "ready": resName = "就绪"; break;
                case "not_ready": resName = "未就绪"; break;
                case "in_dispatc": resName = "调度中"; break;
                case "out_dispatch": resName = "调度外"; break;
                case "running": resName = "运行中"; break;
                case "not_running": resName = "未运行"; break;
                default: resName = "未知状态"; break;
            }
            return new KanbanAgvState { AgvState = resName };
        }

        [HttpGet]
        [Route("GetLocInfo")]
        public WmsModel.tbData GetLocInfo() {
            return WmsService.GetLocInfo();
        }

        [HttpGet]
        [Route("GetLocStateInfo")]
        public WmsModel.LocStateInfo GetLocStateInfo() {
            return WmsService.GetLocStateInfo();
        }

        [HttpGet]
        [Route("GetLocCountInfo")]
        public WmsModel.LocCountInfo GetLocCountInfo() {
            return WmsService.GetLocCountInfo();
        }
    }

    public class WmsService {
        public static WmsModel.tbData GetLocInfo() {
            var db = new SqlHelper<object>().GetInstance();
            try {
                var locs = db.Queryable<TN_Location>().ToList();
                var haveCgDetailCntrList = db.Queryable<TN_CG_Detail>().Select(d => d.S_CNTR_CODE).ToList();
                var emptyLocs = db.Queryable<TN_Location, TN_Loc_Container>((l, c) => l.S_CODE == c.S_LOC_CODE)
                    .Where((l, c) => !haveCgDetailCntrList.Contains(c.S_CNTR_CODE)).Select((l, c) => l.S_CODE).ToList();

                return new WmsModel.tbData {
                    data = locs.Select(l => new WmsModel.tbDataOne {
                        value = $"{l.N_ROW}-{l.N_COL}-{l.N_LAYER}",
                        state = l.N_LOCK_STATE == 3 ? "货位锁" :
                                l.N_CURRENT_NUM == 0 ? "空货位" :
                                emptyLocs.Contains(l.S_CODE) ? "空托盘" : "满托盘"
                    }).ToList()
                };
            }
            catch (System.Exception) {
                return new WmsModel.tbData();
            }
        }
        public static WmsModel.LocStateInfo GetLocStateInfo() {
            var db = new SqlHelper<object>().GetInstance();
            try {
                //var locs = db.Queryable<TN_Location>().ToList();
                var result = db.Queryable<TN_Location>()
                    .Select(l => new WmsModel.LocState {
                        Code = l.S_CODE,
                        Row = l.N_ROW,
                        Column = l.N_COL,
                        Layer = l.N_LAYER,
                        CurrentNum = l.N_CURRENT_NUM,
                        LockState = l.N_LOCK_STATE,
                    }).ToList();

                return new WmsModel.LocStateInfo {
                    //LocStates = locs.Select(l => new WmsModel.LocState {
                    //    Code = l.S_CODE,
                    //    Row = l.N_ROW,
                    //    Column = l.N_COL,
                    //    Layer = l.N_LAYER,
                    //    CurrentNum = l.N_CURRENT_NUM,
                    //    LockState= l.N_LOCK_STATE,
                    //}).ToList(),
                    LocStates = result
                };
            }
            catch (System.Exception) {
                return new WmsModel.LocStateInfo();
            }
        }

        public static WmsModel.LocCountInfo GetLocCountInfo() {
            var db = new SqlHelper<object>().GetInstance();
            try {
                var result = db.Queryable<TN_Location>()
                    .GroupBy(loc => new { loc.N_ROW, loc.N_LAYER }) // 按行和层分组
                    .Select(loc => new WmsModel.LocCount {
                        Row = loc.N_ROW,          // 行
                        Layer = loc.N_LAYER,      // 层
                        Count = SqlFunc.AggregateSum(loc.N_CURRENT_NUM) // 累计 N_CURRENT_NUM 数量
                    })
                    .ToList();
                return new WmsModel.LocCountInfo {
                    locCounts= result
                };
            }
            catch (System.Exception) {
                return new WmsModel.LocCountInfo();
            }
        }
    }

    public class WmsModel {
        public class LocStateInfo {
            public List<LocState> LocStates = new List<LocState>();
        }

        public class LocState {
            public string Code { get; set; }
            public int Row { get; set; }
            public int Column { get; set; }
            public int Layer { get; set; }
            public int LockState { get; set; }
            public int CurrentNum { get; set; }
        }

        public class LocCountInfo {
            public List<LocCount> locCounts= new List<LocCount>();
        }

        public class LocCount {
            public int Row { get; set; }
            public int Layer { get; set; }
            public int Count { get; set; }
        }

        public class tbData {
            public List<tbDataOne> data = new List<tbDataOne>();
        }

        public class tbDataOne {
            public string value { get; set; }
            public string state { get; set; }
        }
    }
    
}