using HslCommunication.WebSocket;
using OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup;
using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Common.CommonEnum;
using WIDESEA_Common.LocationEnum;
using WIDESEA_Common.StockEnum;
using WIDESEA_Core;
using WIDESEA_Core.BaseRepository;
using WIDESEA_Core.BaseServices;
using WIDESEA_Core.Const;
using WIDESEA_Core.DB;
using WIDESEA_Core.Enums;
using WIDESEA_Core.Helper;
using WIDESEA_Core.Seed;
using WIDESEA_Core.Utilities;
using WIDESEA_DTO.Basic;
using WIDESEA_DTO.Location;
using WIDESEA_IBasicService;
using WIDESEA_Model.Models;
using WIDESEA_Model.Models.Stock;

namespace WIDESEA_BasicService
{
    public partial class LocationInfoService : ServiceBase<Dt_LocationInfo, IRepository<Dt_LocationInfo>>, ILocationInfoService
    {
        private readonly IRepository<Sys_User> _userRepository;
        private readonly IUnitOfWorkManage _unitOfWorkManage;
        public IRepository<Dt_LocationInfo> Repository => BaseDal;

        public LocationInfoService(IRepository<Dt_LocationInfo> BaseDal, IUnitOfWorkManage unitOfWorkManage, IRepository<Sys_User> userRepository) : base(BaseDal)
        {
            _unitOfWorkManage = unitOfWorkManage;
            _userRepository = userRepository;
        }

        /// <summary>
        /// 获取用户列表（注入使用示例）
        /// </summary>
        /// <returns></returns>
        public List<Sys_User> GetUsers()
        {
            return _userRepository.QueryData();
        }

        /// <summary>
        /// 初始化货位
        /// </summary>
        /// <param name="initializationLocationDTO"></param>
        /// <returns></returns>
        public WebResponseContent InitializationLocation(InitializationLocationDTO initializationLocationDTO)
        {
            try
            {
                (bool, string, object?) result = ModelValidate.ValidateModelData(initializationLocationDTO);
                if (!result.Item1) return WebResponseContent.Instance.Error(result.Item2);

                List<Dt_LocationInfo> locationInfos = new List<Dt_LocationInfo>();
                for (int i = 0; i < initializationLocationDTO.MaxRow; i++)
                {
                    for (int j = 0; j < initializationLocationDTO.MaxColumn; j++)
                    {
                        for (int k = 0; k < initializationLocationDTO.MaxLayer; k++)
                        {
                            Dt_LocationInfo locationInfo = new Dt_LocationInfo()
                            {
                                Column = j + 1,
                                EnableStatus = EnableStatusEnum.Normal.ObjToInt(),
                                Layer = k + 1,
                                LocationStatus = LocationStatusEnum.Free.ObjToInt(),
                                RoadwayNo = $"{initializationLocationDTO.Roadway.ToString()}",
                                Row = i + 1,
                            };
                            locationInfo.LocationCode = $"{locationInfo.RoadwayNo}-{locationInfo.Row.ToString().PadLeft(3, '0')}-{locationInfo.Column.ToString().PadLeft(3, '0')}-{locationInfo.Layer.ToString().PadLeft(3, '0')}";
                            locationInfo.LocationName = $"{locationInfo.RoadwayNo}巷道{locationInfo.Row.ToString().PadLeft(3, '0')}行{locationInfo.Column.ToString().PadLeft(3, '0')}列{locationInfo.Layer.ToString().PadLeft(3, '0')}层";
                            locationInfos.Add(locationInfo);
                        }
                    }
                }
                BaseDal.AddData(locationInfos);
                return WebResponseContent.Instance.OK();
            }
            catch (Exception ex)
            {
                return WebResponseContent.Instance.Error(ex.Message);
            }
        }

        //入库分配货位
        public Dt_LocationInfo AllotLocationInfo(int k)
        {
            Dt_LocationInfo locationInfo = new Dt_LocationInfo();
            //空桶分配
            if (k == 1)
            {
                locationInfo = BaseDal.QueryData(x => x.EnableStatus == (int)EnableStatusEnum.Normal && x.LocationStatus == (int)LocationStatusEnum.Free).OrderBy(x => x.Column).OrderBy(x => x.Layer).First();
            }
            //食品区分配
            else if(k == 2)
            {
                locationInfo = BaseDal.QueryData(x => x.EnableStatus == (int)EnableStatusEnum.Normal && x.LocationStatus == (int)LocationStatusEnum.Free && x.LocationType == (int)LocationTypeEnum.Food).OrderBy(x=>x.Column).OrderBy(x => x.Layer).First();
            }
            //工业区分配
            else if(k == 3){
                locationInfo = BaseDal.QueryData(x => x.EnableStatus == (int)EnableStatusEnum.Normal && x.LocationStatus == (int)LocationStatusEnum.Free && x.LocationType == (int)LocationTypeEnum.Industry).OrderBy(x=>x.Column).OrderBy(x => x.Layer).First();
            }
            return locationInfo;
        }

        //出库分配物料
        //1:空桶，2：满桶
        public Dt_LocationInfo AllotStock(int k)
        {
            Dt_LocationInfo locationInfo = new Dt_LocationInfo();
            if (k == 1)
            {
                locationInfo = BaseDal.QueryFirst(x => x.EnableStatus == (int)EnableStatusEnum.Normal && x.LocationStatus == (int)LocationStatusEnum.EmptyBarrel);
            }
            else if(k == 2) 
            {

            }
            return locationInfo;
        }

        //根据多条物料查询对应的货位并修改为锁定
        public List<Dt_LocationInfo> StockLockLocation(List<Dt_StockInfo> StockInfo)
        {
            List<Dt_LocationInfo> locationInfos = new List<Dt_LocationInfo>();
            int k = StockInfo.Count() - 1;
            for(int i = 0; i <= k; i++)
            {
                Dt_LocationInfo locationInfo = BaseDal.QueryFirst(x => x.LocationCode == StockInfo[i].LocationCode);
                locationInfo.LocationStatus = (int)LocationStatusEnum.Lock;
                locationInfos.Add(locationInfo);
            }
            return locationInfos;
        }

        //前端页面图片显示
        public List<Dt_LocationInfo> getLocation()
        {
            List<Dt_LocationInfo> LocationInfo = BaseDal.QueryData(x => true);
            return LocationInfo;
        }

        //修改库位类型
        public WebResponseContent UpdateLocationType(int k)
        {
            WebResponseContent content = new WebResponseContent();
            List<Dt_LocationInfo> location = BaseDal.QueryData(x => x.Column == k);
            int s = 0;
            if (location[0].LocationType == (int)LocationTypeEnum.Food)
            {
                s = (int)LocationTypeEnum.Industry;
            }
            else if(location[0].LocationType == (int)LocationTypeEnum.Industry)
            {
                s = (int)LocationTypeEnum.Food;
            }

            location.ForEach(x => x.LocationType = s);
            content.OK(s.ToString());
            BaseDal.UpdateData(location);
            return content;
        }

        public Location LocationNum()
        {
            Location location = new Location();

            List<Dt_LocationInfo> LocationInfo1 = BaseDal.QueryData(x => x.LocationStatus == (int)LocationStatusEnum.Free);
            List<Dt_LocationInfo> LocationInfo2 = BaseDal.QueryData(x => x.LocationStatus == (int)LocationStatusEnum.InStock);
            List<Dt_LocationInfo> LocationInfo3 = BaseDal.QueryData(x => x.LocationStatus == (int)LocationStatusEnum.EmptyBarrel);

            location.Vacancy = LocationInfo1.Count();
            location.Available = LocationInfo2.Count();
            location.Empty = LocationInfo3.Count();
            return location;
        }
    }
}