using OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Core;
using WIDESEA_Core.BaseRepository;
using WIDESEA_Core.BaseServices;
using WIDESEA_Core.Enums;
using WIDESEA_Core.Helper;
using WIDESEA_DTO.Stock;
using WIDESEA_IBasicRepository;
using WIDESEA_IBasicService;
using WIDESEA_IOutboundRepository;
using WIDESEA_IOutboundService;
using WIDESEA_IRecordService;
using WIDESEA_IStockRepository;
using WIDESEA_IStockService;
using WIDESEA_Model.Models;
using WIDESEA_StockRepository;

namespace WIDESEA_OutboundService
{
    public partial class OutboundOrderDetailService : ServiceBase<Dt_OutboundOrderDetail, IOutboundOrderDetailRepository>, IOutboundOrderDetailService
    {
        private readonly IUnitOfWorkManage _unitOfWorkManage;

        private readonly IStockService _stockService;
        private readonly IBasicService _basicService;
        private readonly IRecordService _recordService;
        private readonly IOutboundRepository _outboundRepository;
        private readonly IOutStockLockInfoService _outStockLockInfoService;

        public IOutboundOrderDetailRepository Repository => BaseDal;

        public OutboundOrderDetailService(IOutboundOrderDetailRepository BaseDal, IUnitOfWorkManage unitOfWorkManage, IStockService stockService, IBasicService basicService, IRecordService recordService, IOutboundRepository outboundRepository, IOutStockLockInfoService outStockLockInfoService) : base(BaseDal)
        {
            _unitOfWorkManage = unitOfWorkManage;
            _stockService = stockService;
            _basicService = basicService;
            _recordService = recordService;
            _outboundRepository = outboundRepository;
            _outStockLockInfoService = outStockLockInfoService;
        }

        public (List<Dt_StockInfo>, List<Dt_OutStockLockInfo>, List<Dt_LocationInfo>, Dt_OutboundOrder) AssignStockOutbound(Dt_OutboundOrderDetail outboundOrderDetail)
        {
            Dt_OutboundOrder outboundOrder = _outboundRepository.OutboundOrderRepository.QueryFirst(x => x.Id == outboundOrderDetail.OrderId);
            List<Dt_StockInfo> outStocks = new List<Dt_StockInfo>();
            List<string> LocationCodes = new List<string>();
            List<Dt_OutStockLockInfo> outStockLockInfos = new List<Dt_OutStockLockInfo>();
            List<Dt_LocationInfo> locationInfos = new List<Dt_LocationInfo>();
            return (outStocks, outStockLockInfos, locationInfos, outboundOrder);
        }

        public (List<Dt_StockInfo>, List<Dt_OutboundOrderDetail>, List<Dt_OutStockLockInfo>, List<Dt_LocationInfo>, Dt_OutboundOrder) AssignStockOutbound(List<Dt_OutboundOrderDetail> outboundOrderDetails)
        {
            if (outboundOrderDetails.GroupBy(x => x.OrderId).Count() > 1)
            {
                throw new Exception($"请勿同时操作多个单据明细");
            }
            Dt_OutboundOrder outboundOrder = _outboundRepository.OutboundOrderRepository.QueryFirst(x => x.Id == outboundOrderDetails.FirstOrDefault().OrderId);
            List<Dt_StockInfo> outStocks = new List<Dt_StockInfo>();
            List<string> LocationCodes = new List<string>();
            List<Dt_OutStockLockInfo> outStockLockInfos = new List<Dt_OutStockLockInfo>();
            List<Dt_LocationInfo> locationInfos = new List<Dt_LocationInfo>();
            List<int> keys = new List<int>();
            foreach (var item in outboundOrderDetails)
            {
                var StockSelectViews = _stockService.StockInfoService.GetStockSelectViews(item.MaterielCode);
                if (StockSelectViews.Count < 1) throw new Exception($"未找到可分配库存");
                StockSelectViews = StockSelectViews.Where(x => !keys.Contains(x.Id)).OrderBy(x => x.InDate).ToList();
                if (StockSelectViews.Count < 1) throw new Exception($"可分配库存不足");
                foreach (var StockSelectView in StockSelectViews.GroupBy(x => x.LocationCode))
                {
                    if (item.OrderQuantity - item.LockQuantity <= 0) break;
                    decimal StockQuantity = StockSelectView.Sum(x => x.UseableQuantity);
                    if (StockQuantity <= item.OrderQuantity - item.LockQuantity)
                    {
                        foreach (var Stock in StockSelectView.OrderByDescending(x => x.InDate))
                        {
                            keys.Add(Stock.Id);
                            item.LockQuantity += Stock.UseableQuantity;
                            item.OrderDetailStatus = OrderDetailStatusEnum.Outbound.ObjToInt();
                            List<Dt_StockInfo> dt_StockInfos = _stockService.StockInfoService.Repository.QueryData(x => Stock.PalletCode.Contains(x.PalletCode));
                            dt_StockInfos.ForEach(x =>
                            {
                                x.StockStatus = StockStatusEmun.出库中.ObjToInt();
                            });
                            outboundOrder.OrderStatus = OutboundStatusEnum.出库中.ObjToInt();
                            outStockLockInfos.AddRange(_outStockLockInfoService.GetOutStockLockInfo(outboundOrder, item, dt_StockInfos, BatchNo: Stock.BatchNo));
                            outStocks.AddRange(dt_StockInfos);
                        }
                        LocationCodes.Add(StockSelectView.Key);
                    }
                    else
                    {
                        foreach (var Stock in StockSelectView.OrderByDescending(x => x.InDate))
                        {
                            if (item.OrderQuantity - item.LockQuantity - Stock.UseableQuantity >= 0)
                            {
                                keys.Add(Stock.Id);
                                item.LockQuantity += Stock.UseableQuantity;
                                item.OrderDetailStatus = OrderDetailStatusEnum.Outbound.ObjToInt();
                                List<Dt_StockInfo> StockInfos = _stockService.StockInfoService.Repository.QueryData(x => Stock.PalletCode.Contains(x.PalletCode));
                                StockInfos.ForEach(x =>
                                {
                                    x.StockStatus = StockStatusEmun.出库中.ObjToInt();
                                });
                                outboundOrder.OrderStatus = OutboundStatusEnum.出库中.ObjToInt();
                                outStockLockInfos.AddRange(_outStockLockInfoService.GetOutStockLockInfo(outboundOrder, item, StockInfos, BatchNo: Stock.BatchNo));
                                outStocks.AddRange(StockInfos);
                                LocationCodes.Add(Stock.LocationCode);
                            }
                        }
                    }
                }
                #region MyRegion
                //StockSelectViewDTO? stockSelectView = StockSelectViews.Where(x => x.UseableQuantity == item.OrderQuantity).FirstOrDefault();
                //if (stockSelectView == null)
                //{
                //    foreach (var StockSelectView in StockSelectViews)
                //    {
                //        if (item.OrderQuantity - item.LockQuantity - StockSelectView.UseableQuantity >= 0)
                //        {
                //            keys.Add(StockSelectView.Id);
                //            item.LockQuantity += StockSelectView.UseableQuantity;
                //            item.OrderDetailStatus = OrderDetailStatusEnum.Outbound.ObjToInt();
                //            List<Dt_StockInfo> StockInfos = _stockService.StockInfoService.Repository.QueryData(x => StockSelectView.PalletCode.Contains(x.PalletCode));
                //            StockInfos.ForEach(x =>
                //            {
                //                x.StockStatus = StockStatusEmun.出库中.ObjToInt();
                //            });
                //            outboundOrder.OrderStatus = OutboundStatusEnum.出库中.ObjToInt();
                //            outStockLockInfos.AddRange(_outStockLockInfoService.GetOutStockLockInfo(outboundOrder, item, StockInfos, BatchNo: StockSelectView.BatchNo));
                //            outStocks.AddRange(StockInfos);
                //            LocationCodes.Add(StockSelectView.LocationCode);
                //        }
                //    }
                //    if (keys.Count < 1) throw new Exception($"未找到匹配出库单数量库存");
                //}
                //else
                //{
                //    keys.Add(stockSelectView.Id);
                //    item.LockQuantity = stockSelectView.UseableQuantity;
                //    item.OrderDetailStatus = OrderDetailStatusEnum.Outbound.ObjToInt();
                //    List<Dt_StockInfo> dt_StockInfos = _stockService.StockInfoService.Repository.QueryData(x => stockSelectView.PalletCode.Contains(x.PalletCode));
                //    dt_StockInfos.ForEach(x =>
                //    {
                //        x.StockStatus = StockStatusEmun.出库中.ObjToInt();
                //    });
                //    outboundOrder.OrderStatus = OutboundStatusEnum.出库中.ObjToInt();
                //    outStockLockInfos.AddRange(_outStockLockInfoService.GetOutStockLockInfo(outboundOrder, item, dt_StockInfos, BatchNo: stockSelectView.BatchNo));
                //    outStocks.AddRange(dt_StockInfos);
                //    LocationCodes.Add(stockSelectView.LocationCode);
                //} 
                #endregion
            }
            locationInfos.AddRange(_basicService.LocationInfoService.Repository.GetLocationInfos(LocationCodes));
            locationInfos.ForEach(x =>
            {
                x.LocationStatus = LocationStatusEnum.Outbounding.ObjToInt();
            });
            return (outStocks, outboundOrderDetails, outStockLockInfos, locationInfos, outboundOrder);
        }
    }
}