using Furion.DatabaseAccessor;
using Furion.DependencyInjection;
using Furion.DynamicApiController;
using Mapster;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using Admin.NET.Core;

namespace Admin.NET.Application
{
    /// <summary>
    /// 库位试图服务
    /// </summary>
    [ApiDescriptionSettings("仓库作业", Name = "LocationView", Order = 104)]
    [Route("api/[Controller]")]
    public class LocationViewService : IDynamicApiController, ITransient
    {
        private readonly IRepository<WmsArea, MasterDbContextLocator> _wmsAreaRep;
        private readonly IRepository<WmsPlace, MasterDbContextLocator> _wmsPlaceRep;
        private readonly IRepository<WmsMaterialStock, MasterDbContextLocator> _wmsMaterialStockRep;
        private readonly IRepository<WmsContainerPlace, MasterDbContextLocator> _wmsContainerPlaceRep; 
        private readonly IRepository<WmsContainer, MasterDbContextLocator> _wmsContainerRep;
        private readonly IRepository<WmsMaterialContainer, MasterDbContextLocator> _wmsMaterialContainerRep;

        /// <summary>
        /// 构造函数
        /// </summary>
        public LocationViewService(
            IRepository<WmsArea, MasterDbContextLocator> wmsAreaRep,
            IRepository<WmsPlace, MasterDbContextLocator> wmsPlaceRep,
            IRepository<WmsMaterialStock, MasterDbContextLocator> wmsMaterialStockRep,
            IRepository<WmsContainerPlace, MasterDbContextLocator> wmsContainerPlaceRe,
            IRepository<WmsContainer, MasterDbContextLocator> wmsContainerRep,
            IRepository<WmsMaterialContainer, MasterDbContextLocator> wmsMaterialContainer
        )
        {
            _wmsAreaRep = wmsAreaRep;
            _wmsPlaceRep = wmsPlaceRep;
            _wmsMaterialStockRep = wmsMaterialStockRep;
            _wmsContainerPlaceRep = wmsContainerPlaceRe;
            _wmsContainerRep = wmsContainerRep;
            _wmsMaterialContainerRep = wmsMaterialContainer;
        }

        /// <summary>
        /// 获取库区信息
        /// </summary>
        /// <returns></returns>
        [HttpGet("GetArea")]
        public async Task<List<WmsArea>> GetArea()
        {
            var areaList = await _wmsAreaRep.Where(n => n.AreaStatus == CommonStatus.ENABLE && n.WorkShopType == LesWorkShopType.FAPAOCHEJIAN).ToListAsync();
            return areaList;
        }

        /// <summary>
        /// 根据库区获取巷道
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("GetAisle")]
        public async Task<object> GetPalceAisle([FromQuery] GetPalceAisleInput input)
        {
            
            var objList=await _wmsPlaceRep.Where(n => n.AreaId == input.Areaid).OrderBy(n=>n.Aisle).Select(n => n.Aisle).Distinct().ToArrayAsync();
            for (int i = 0; i < objList.Length-1; i++)
            {
                for (int j = 0; j < objList.Length-1; j++)
                {
                    int k = j + 1;
                    if (objList[j] >objList[k])
                    {
                        var temp = objList[k];
                        objList[k] = objList[j];
                        objList[j] = temp;
                    }
                }
            }
            return objList;
        }

        /// <summary>
        /// 根据库区和巷道获取排
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("GetPalceRowno")]
        public async Task<object> GetPalceRowno([FromQuery] GetPalceAisleRownoInput input)
        {
            var objList=await _wmsPlaceRep.Where(n => n.AreaId == input.Areaid && n.Aisle==input.Aisleid && n.WmsArea.WorkShopType == LesWorkShopType.FAPAOCHEJIAN).OrderBy(n => n.RowNo).Select(n => n.RowNo).Distinct().ToArrayAsync();

            for (int i = 0; i < objList.Length - 1; i++)
            {
                for (int j = 0; j < objList.Length - 1; j++)
                {
                    int k = j + 1;
                    if (objList[j] > objList[k])
                    {
                        var temp = objList[k];
                        objList[k] = objList[j];
                        objList[j] = temp;
                    }
                }
            }
            return objList;
        }

        /// <summary>
        /// 根据库区 排获取库位信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("GetPalceList")]
        public async Task<PalceInfoOtput> GetPalceList([FromQuery] GetPalceListInput input)
        {
            var palceList = await _wmsPlaceRep.DetachedEntities
                .Where(p => p.AreaId == input.Areaid)
                .Where(input.Aisleid != 0, p => p.Aisle == input.Aisleid)
                .Where(input.Rowno != 0, p => p.RowNo == input.Rowno)
                .ToListAsync();

            //获取有多少巷,排,列,层
            var Aisles = palceList.OrderBy(n => n.Aisle).Select(n => n.Aisle).Distinct().ToList();
        
            var locationDataList = new List<WareLocationAisleData>();
            //巷道
            foreach (var aisle in Aisles)
            {
                var aisleData = new WareLocationAisleData();
                aisleData.Aisle = aisle;
                aisleData.wareLocationRownoData = new List<WareLocationRownoData>();
                //排
                var RowNos = palceList.Where(p=>p.Aisle==aisle).OrderBy(n => n.RowNo).Select(n => n.RowNo).Distinct().ToList();
                foreach (var row in RowNos)
                {
                    var rownoData = new WareLocationRownoData();
                    rownoData.Rowno = row;
                    rownoData.wareLocationLayerData = new List<WareLocationLayerData>();
                    //层
                    var LayerNo = palceList.Where(p=>p.Aisle==aisle && p.RowNo==row).OrderByDescending(n => n.LayerNo).Select(n => n.LayerNo).Distinct();
                    foreach (var lay in LayerNo)
                    {
                        var layerData = new WareLocationLayerData();
                        layerData.Layer = lay;
                        layerData.wareLocationColumnNoData = new List<PalceDetail>();
                        //列
                        var ColumnNos = palceList.Where(p=>p.Aisle==aisle && p.RowNo==row).OrderByDescending(n => n.ColumnNo).Select(n => n.ColumnNo).Distinct();
                        foreach (var col in ColumnNos)
                        {
                            var wareLocationMdoel = palceList.Where(p =>p.Aisle==aisle && p.RowNo == row && p.LayerNo == lay && p.ColumnNo == col).FirstOrDefault();
                            if (wareLocationMdoel != null)
                            {
                                var locationDetail = new PalceDetail()
                                {
                                    Id = wareLocationMdoel.Id,
                                    RowNo = wareLocationMdoel.RowNo,
                                    ColumnNo = wareLocationMdoel.ColumnNo,
                                    LayerNo = wareLocationMdoel.LayerNo,
                                    PlaceCode = wareLocationMdoel.PlaceCode,
                                    Islock = wareLocationMdoel.Islock,
                                    EmptyContainer = wareLocationMdoel.EmptyContainer,
                                    PlaceStatus = wareLocationMdoel.PlaceStatus,
                                };
                                layerData.wareLocationColumnNoData.Add(locationDetail);
                            }
                            else
                            {
                                layerData.wareLocationColumnNoData.Add(null);
                            }
                        }
                        rownoData.wareLocationLayerData.Add(layerData);
                    }
                    aisleData.wareLocationRownoData.Add(rownoData);
                }
                locationDataList.Add(aisleData);
            }

            return new PalceInfoOtput()
            {
                countNum = palceList.Count,
                cunhuoNum = palceList.Where(n => n.PlaceStatus == PlaceStatus.CUNHUO).Count(),
                emptyNum = palceList.Where(n => n.PlaceStatus == PlaceStatus.KONGXIAN).Count(),
                DaiRuNum = palceList.Where(n => n.PlaceStatus == PlaceStatus.DAIRU).Count(),
                DaichuNum = palceList.Where(n => n.PlaceStatus == PlaceStatus.DAICHU).Count(),
                emptyContainerNum = palceList.Where(p => p.EmptyContainer == YesOrNot.Y && p.PlaceStatus == PlaceStatus.CUNHUO).Count(),
                materialNum = palceList.Where(p => p.EmptyContainer == YesOrNot.N && p.PlaceStatus == PlaceStatus.CUNHUO).Count(),
                lockNum = palceList.Where(p => p.Islock == YesOrNot.Y).Count(),
                PalceDetails = locationDataList,
            };
        }

        /// <summary>
        /// 根据库位获取对应信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("GetMaterialDetail")]
        [UnifyResult(typeof(MaterialDetailsOutput))]
        public async Task<object> GetMaterialDetail([FromQuery] GetMaterialDetailInput input)
        {
            var palceModel = await _wmsPlaceRep.FirstOrDefaultAsync(p => p.Id == input.Id);
            if (palceModel == null) return XnRestfulResultProvider.RESTfulMesaage("库位信息不存在!");
            var MaterialStockList = await _wmsMaterialStockRep.Where(p => p.PlaceCode == palceModel.PlaceCode).ToListAsync();
            var model = new MaterialDetailsOutput()
            {
                PalceDetails = palceModel.Adapt<PalceDetail>()
            };
            if (MaterialStockList.Count > 0)
            {
                model.Containercode = MaterialStockList.FirstOrDefault().ContainerCode;
                model.WmsMaterialStocks = MaterialStockList;
            }
            return XnRestfulResultProvider.RESTfulResult(model);
        }

        /// <summary>
        /// 修改库位锁定信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("UpdatePalceIslock")]
        [UnifyResult(typeof(object))]
        public async Task<object> UpdatePalceIslock([FromQuery] GetMaterialDetailInput input)
        {
            var palceModel = await _wmsPlaceRep.FirstOrDefaultAsync(p => p.Id == input.Id);
            if (palceModel == null) return XnRestfulResultProvider.RESTfulMesaage("库位信息不存在!");
            if (palceModel.Islock == YesOrNot.Y)
            {
                palceModel.Islock = YesOrNot.N;
            }
            else
            {
                palceModel.Islock = YesOrNot.Y;
            }
            await _wmsPlaceRep.UpdateAsync(palceModel);
            return XnRestfulResultProvider.RESTfulResult();
        }

        /// <summary>
        /// 将库位置为空闲
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("UpdatePalceKongXian")]
        [UnifyResult(typeof(object))]
        [UnitOfWork]
        public async Task<object> UpdatePalceKongXian([FromQuery] GetMaterialDetailInput input)
        {
            var palceModel = await _wmsPlaceRep.FirstOrDefaultAsync(p => p.Id == input.Id);
            if (palceModel == null) return XnRestfulResultProvider.RESTfulMesaage("库位信息不存在!");
            palceModel.PlaceStatus = PlaceStatus.KONGXIAN;
            await _wmsPlaceRep.UpdateAsync(palceModel);

            var materialStockModel = await _wmsMaterialStockRep.Where(p => p.PlaceCode == palceModel.PlaceCode).FirstOrDefaultAsync();
            if (materialStockModel != null)
            {
                await _wmsMaterialStockRep.DeleteAsync(materialStockModel);
            }
            var containerPlaceModel = await _wmsContainerPlaceRep.Where(p => p.PlaceCode == palceModel.PlaceCode && p.ContainerPlaceStatus == CommonStatus.ENABLE).FirstOrDefaultAsync();
            if (containerPlaceModel != null)
            {
                containerPlaceModel.ContainerPlaceStatus = CommonStatus.DISABLE;
                await _wmsContainerPlaceRep.UpdateAsync(containerPlaceModel);

                var wmsMaterialContainerModal = await _wmsMaterialContainerRep.FirstOrDefaultAsync(p => p.ContainerCode == containerPlaceModel.ContainerCode && p.BindStatus == CommonStatus.ENABLE);
                if (containerPlaceModel != null) return XnRestfulResultProvider.RESTfulMesaage("物料托盘信息不存在!");
                containerPlaceModel.ContainerPlaceStatus = CommonStatus.DISABLE;
                await _wmsMaterialContainerRep.UpdateAsync(wmsMaterialContainerModal);

                var containerModel = await _wmsContainerRep.FirstOrDefaultAsync(p => p.ContainerCode == containerPlaceModel.ContainerCode);
                if (containerModel != null)
                {
                    containerModel.ContainerStatus = ContainerStatus.KOUXIAN;
                    await _wmsContainerRep.UpdateAsync(containerModel);
                }
            }
            return XnRestfulResultProvider.RESTfulResult();
        }
    }
}