//// Admin.NET 项目的版权、商标、专利和其他相关权利均受相应法律法规的保护。使用本项目应遵守相关法律法规和许可证的要求。
////
//// 本项目主要遵循 MIT 许可证和 Apache 许可证（版本 2.0）进行分发和使用。许可证位于源代码树根目录中的 LICENSE-MIT 和 LICENSE-APACHE 文件。
////
//// 不得利用本项目从事危害国家安全、扰乱社会秩序、侵犯他人合法权益等法律法规禁止的活动！任何基于本项目二次开发而产生的一切法律纠纷和责任，我们不承担任何责任！

//using Admin.NET.Application.Entity;
//using Admin.NET.Application.Service.ReportCenter.WmsOtherReport.Dto;
//using System;
//using System.Collections.Generic;
//using System.Linq;
//using System.Text;
//using System.Threading.Tasks;
//using static SKIT.FlurlHttpClient.Wechat.Api.Models.SemanticSemproxySearchResponse.Types;

//namespace Admin.NET.Application;
///// <summary>
///// 工作台服务
///// </summary>
//[ApiDescriptionSettings(ApplicationConst.HomePageName, Order = 100)]

//public class WmsHomePageService : IDynamicApiController, ITransient
//{
//    private readonly SqlSugarRepository<WmsOrderMovement> _rep;
//    private readonly SqlSugarRepository<WmsStockQuan> _WmsStockQuanRep;
//    private readonly SqlSugarRepository<WmsOrderMovementDetails> _WmsOrderMovementDetailsRep;
//    private readonly SqlSugarRepository<V_WmsOrderMovementDetails> _v_wmsOrderMovementDetailsRep;
//    private readonly SqlSugarRepository<WmsBaseCustomer> _BaseCustomerRep;
//    private readonly SqlSugarRepository<WmsBaseMaterial> _wmsMaterialRep;
//    private readonly SqlSugarRepository<WmsConfigNoRule> _WmsNoCreateRuleRep;
//    private readonly SqlSugarRepository<WmsConfigSerialSN> _repSNRep;
//    private readonly SqlSugarRepository<WmsConfigSerialRule> _repRuleDetailRep;
//    private readonly SqlSugarRepository<WmsOrderDeliverDetails> _WmsOrderDeliverDetailsRep;
//    private readonly SqlSugarRepository<WmsLogAction> _wareActionLogRep;
//    private readonly WmsStockQuanService _wmsStockQuanService;
//    private readonly SqlSugarRepository<WmsBaseBusinessType> _WmsBaseBusinessTypeRep;
//    private readonly SqlSugarRepository<WmsBasePlace> _wmsPlaceRep;
//    private readonly SqlSugarRepository<WmsBaseContainer> _wmsContainerRep;
//    private readonly SqlSugarRepository<WmsContainerPlace> _wmsContainerPlace;
//    private readonly SqlSugarRepository<v_wms_stock_quan> _v_wms_stock_quanRep;
//    private readonly SqlSugarRepository<WmsOrderAsn> _wmsOrderAsnRep;
//    private readonly SqlSugarRepository<WmsRecordReceivingDelivery> _wmsRecordReceivingDeliveryRep;

//    public WmsHomePageService(
//        SqlSugarRepository<WmsRecordReceivingDelivery> wmsRecordReceivingDeliveryRep,
//        SqlSugarRepository<WmsOrderMovement> rep,
//        SqlSugarRepository<WmsStockQuan> wmsStockQuanRep,
//        SqlSugarRepository<WmsOrderMovementDetails> wmsOrderMovementDetailsRep,
//        SqlSugarRepository<WmsBaseCustomer> baseCustomerRep,
//        SqlSugarRepository<WmsBaseBusinessType> WmsBaseBusinessTypeRep,
//        SqlSugarRepository<WmsConfigNoRule> wmsNoCreateRuleRep,
//        SqlSugarRepository<WmsConfigSerialSN> repSNRep,
//        SqlSugarRepository<WmsConfigSerialRule> repRuleDetailRep,
//        SqlSugarRepository<WmsOrderDeliverDetails> WmsOrderDeliverDetailsRep
//        , SqlSugarRepository<WmsLogAction> wareActionLogRep
//,
//WmsStockQuanService wmsStockQuanService,
//SqlSugarRepository<V_WmsOrderMovementDetails> v_wmsOrderMovementDetailsRep
//        ,
// SqlSugarRepository<WmsBaseMaterial> WmsMaterial,
// SqlSugarRepository<WmsBaseBusinessType> WmsBaseBusinessType,
// SqlSugarRepository<WmsBasePlace> wmsPlaceRep,
// SqlSugarRepository<WmsBaseContainer> wmsContainerRep,
// SqlSugarRepository<WmsContainerPlace> wmsContainerPlace,
// SqlSugarRepository<v_wms_stock_quan> v_wms_stock_quanRep,
//  SqlSugarRepository<WmsOrderAsn> wmsOrderAsnRep

//        )
//    {
//        _wmsRecordReceivingDeliveryRep = wmsRecordReceivingDeliveryRep;
//        _rep = rep;
//        _WmsStockQuanRep = wmsStockQuanRep;
//        _WmsOrderMovementDetailsRep = wmsOrderMovementDetailsRep;
//        _BaseCustomerRep = baseCustomerRep;
//        _WmsBaseBusinessTypeRep = WmsBaseBusinessTypeRep;
//        _WmsNoCreateRuleRep = wmsNoCreateRuleRep;
//        _repSNRep = repSNRep;
//        _repRuleDetailRep = repRuleDetailRep;
//        _WmsOrderDeliverDetailsRep = WmsOrderDeliverDetailsRep;
//        _wareActionLogRep = wareActionLogRep;
//        _wmsStockQuanService = wmsStockQuanService;
//        _wmsMaterialRep = WmsMaterial;
//        _WmsBaseBusinessTypeRep = WmsBaseBusinessType;
//        _wmsPlaceRep = wmsPlaceRep;
//        _wmsContainerRep = wmsContainerRep;
//        _wmsContainerPlace = wmsContainerPlace;
//        _v_wms_stock_quanRep = v_wms_stock_quanRep;
//        _wmsOrderAsnRep = wmsOrderAsnRep;
//    }

//    /// <summary>
//    /// 首页出入库数据查询
//    /// </summary>
//    /// <returns></returns>
//    [HttpPost]
//    [ApiDescriptionSettings(Name = "WmsHomePageQuery")]
//    [Description("WmsHomePageService/WmsHomePageQuery")]
//    public async Task<WmsHomePageOutput> WmsHomePageQuery()
//    {
//        var returnData = new WmsHomePageOutput();
//        // 获取今天的日期
//        DateTime today = DateTime.Today;
//        var MovementOrderList = await _rep.AsQueryable().Where(u => u.CreateTime >= today && u.CreateTime < today.AddDays(1)).ToListAsync();

//        returnData.OuttingPlaceNumber = MovementOrderList.Where(u => u.OrderType == OrderTypeEnum.下架单 && u.OrderStatus == OrderStatusEnum.已完成).ToList().Count();
//        returnData.WarehousingNumber = MovementOrderList.Where(u => u.OrderType == OrderTypeEnum.上架单 && u.OrderStatus == OrderStatusEnum.已完成).ToList().Count();
//        returnData.AllOuttingNumber = MovementOrderList.Where(u => u.OrderType == OrderTypeEnum.下架单 && u.OrderStatus != OrderStatusEnum.已关闭 && u.OrderStatus != OrderStatusEnum.已取消).ToList().Count();
//        returnData.AllWarehousingNumber = MovementOrderList.Where(u => u.OrderType == OrderTypeEnum.上架单 && u.OrderStatus != OrderStatusEnum.已关闭 && u.OrderStatus != OrderStatusEnum.已取消).ToList().Count();
//        returnData.AllOrderNumber = returnData.AllOuttingNumber + returnData.AllWarehousingNumber;
//        return returnData;
//    }
//    /// <summary>
//    /// 首页库位数据查询
//    /// </summary>
//    /// <returns></returns>
//    [HttpPost]
//    [ApiDescriptionSettings(Name = "WmsHomePlaceQuery")]
//    [Description("WmsHomePageService/WmsHomePlaceQuery")]
//    public async Task<WmsHomePagePlaceInfoOutput> WmsHomePlaceQuery()
//    {
//        var returnData = new WmsHomePagePlaceInfoOutput();
//        var PlaceList = await _wmsPlaceRep.AsQueryable().Where(x => x.IsDelete == false && (x.IsVirtually == false || x.IsVirtually == null)).ToListAsync();
//        var StockQueryList = await _v_wms_stock_quanRep.AsQueryable().ToListAsync();
//        StockQueryList = StockQueryList.GroupBy(u => u.PlaceCode).Select(g => g.First()).ToList();//用库位号分组，去重
//        returnData.ContainerPlaceNumber = StockQueryList.Where(p => p.MaterialTypeCode == ApplicationConst.DefaultContinerMaterialCode).ToList().Count();
//        returnData.StockPlaceNumber = StockQueryList.Where(p => p.MaterialTypeCode != ApplicationConst.DefaultContinerMaterialCode).ToList().Count();
//        returnData.EmptyPlaceNumber = PlaceList.Count - returnData.ContainerPlaceNumber - returnData.StockPlaceNumber;
//        returnData.AllPlaceNumber = PlaceList.Count();

//        returnData.EmptyPlacePercentage = $"{Math.Round((returnData.EmptyPlaceNumber / returnData.AllPlaceNumber), 4):P}";
//        returnData.StockPlacePercentage = $"{Math.Round((returnData.StockPlaceNumber / returnData.AllPlaceNumber), 4):P}";
//        returnData.ContainerPlacePercentage = $"{Math.Round((returnData.ContainerPlaceNumber / returnData.AllPlaceNumber), 4):P}";

//        return returnData;

//    }

//    ///// <summary>
//    ///// 最近7天收发货推移图
//    ///// </summary>
//    ///// <returns></returns>
//    //[HttpPost]
//    //[ApiDescriptionSettings(Name = "WmsTransitionDiagramQuery")]
//    //[Description("WmsHomePageService/WmsTransitionDiagramQuery")]
//    //public async Task<List<WmsTransitionDiagram>> WmsTransitionDiagramQuery()
//    //{
//    //    // 获取当前时间
//    //    DateTime currentDate = DateTime.Now;

//    //    //DateTime lastWeekDay = currentDate.AddDays(-(int)currentDate.DayOfWeek - 3).Date; 
//    //    //DateTime thisWeekDay = currentDate.AddDays(7 - (int)currentDate.DayOfWeek - 3).Date; 
//    //    // 计算七天前的日期
//    //    DateTime lastWeekDay = currentDate.AddDays(-7).Date;

//    //    // 当前日期的前一天作为结束日期
//    //    DateTime thisWeekDay = currentDate.AddDays(+1).Date;
//    //    var WmsTransitionDiagramList = new List<WmsTransitionDiagram>();
//    //    var NewEmptyTransitionDiagramList = new List<WmsOrderAsn>();
//    //    var query = await _wmsOrderAsnRep.AsQueryable().Where(u => u.CreateTime >= lastWeekDay && u.CreateTime <= thisWeekDay).ToListAsync();
//    //    foreach (var item in query)
//    //    {
//    //        if (item.CreateTime == null) { NewEmptyTransitionDiagramList.Add(item); continue; }
//    //        item.CreateTime = new DateTime(item.CreateTime?.Year ?? 1999, item.CreateTime?.Month ?? 1, item.CreateTime?.Day ?? 1);
//    //    }

//    //    query.RemoveAll(n => NewEmptyTransitionDiagramList.Select(x => x.Id).Contains(n.Id));
//    //    // 使用 LINQ 的 GroupBy 方法，按照创建时间的日期分组
//    //    var groupedData = query.GroupBy(u => u.CreateTime)
//    //        .Select(group => new TransitionDiagramData
//    //        {
//    //            Date = (DateTime)group.Key,
//    //            DataListCount = group.Count()
//    //        }).ToList();
//    //    if (groupedData.Count(p => p.Date >= currentDate.Date) == 0)
//    //    {
//    //        var todayInfo = new TransitionDiagramData()
//    //        {
//    //            Date = currentDate.Date,
//    //            DataListCount = 0
//    //        };
//    //        groupedData.Add(todayInfo);
//    //    }

//    //    foreach (var item in groupedData)
//    //    {
//    //        var model = new WmsTransitionDiagram()
//    //        {
//    //            Day = item.Date.ToString("yyyy-MM-dd"),
//    //            ReceiptNumber = item.DataListCount
//    //        };
//    //        WmsTransitionDiagramList.Add(model);
//    //    }
//    //    return WmsTransitionDiagramList;
//    //}


//    /// <summary>
//    /// 最近7天收发货推移图
//    /// </summary>
//    /// <param name="input"></param>
//    /// <returns></returns>
//    [HttpPost]
//    [ApiDescriptionSettings(Name = "WmsTransitionDiagramQuery")]
//    [Description("WmsHomePageService/WmsTransitionDiagramQuery")]
//    public async Task<List<WmsTransitionDiagram>> WmsTransitionDiagramQuery()
//    {

//        List<WmsTransitionDiagram> outputlist = new List<WmsTransitionDiagram>();
//        DateTime currentDate = DateTime.Today.AddDays(1);
//        DateTime firstDate = DateTime.Today.AddDays(-6);
//        // 查询在这一天内的出入库记录
//        var recordsOfDay = await _wmsRecordReceivingDeliveryRep.AsQueryable().Where(r => r.CreateTime >= firstDate && r.CreateTime <= currentDate).ToListAsync();


//        for (int i = 1; i < 8; i++)
//        {
//            DateTime startDate = currentDate.AddDays(-i);
//            DateTime endDate = startDate.Date.AddDays(1).AddTicks(-1);

//            // 查询在这一天内的出入库记录
//            var items = recordsOfDay.Where(r => r.CreateTime >= startDate && r.CreateTime <= endDate).ToList();

//            // 汇总出入库记录（这里假设你有合适的逻辑来汇总数据）
//            var summary = new WmsTransitionDiagram
//            {
//                ReceiptNumber = items.Where(x => x.InOutFlag == InOutFlagEnum.入).ToList().Sum(x => x.Quantity),
//                DeliveryNumber = items.Where(x => x.InOutFlag == InOutFlagEnum.出).ToList().Sum(x => x.Quantity),
//                Day = startDate.Date.ToString("yyyy-MM-dd")
//            };

//            outputlist.Add(summary);
//        }


//        //排序
//        outputlist = outputlist.OrderBy(x => x.Day).ToList();

//        return outputlist;
//    }

//    public class TransitionDiagramData
//    {
//        public DateTime Date { get; set; }
//        public decimal DataListCount { get; set; }
//    }

//}