// 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; }
    }

}