using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Common.LocationEnum;
using WIDESEA_Common.TaskEnum;
using WIDESEA_Core;
using WIDESEA_Core.BaseRepository;
using WIDESEA_Core.BaseServices;
using WIDESEA_IHomeService;
using WIDESEA_Model.Models;

namespace WIDESEA_HomeService
{
    public partial class HomeService : ServiceBase<Dt_Task_Hty, IRepository<Dt_Task_Hty>>, IHomeService
    {
        public HomeService(IRepository<Dt_Task_Hty> BaseDal) : base(BaseDal)
        {
        }

        public IRepository<Dt_Task_Hty> Repository => BaseDal;
        /// <summary>
        /// 获取历史任务信息出入库存数据
        /// </summary>
        /// <returns></returns>
        public WebResponseContent GetDt_TaskHty()
        {
            var response = new WebResponseContent();
            try
            {
                // 获取当前日期时间
                var now = DateTime.Now;

                // 获取今日日期范围
                var todayStart = now.Date;
                var todayEnd = now.Date.AddDays(1);

                // 获取本周日期范围
                // 计算本周一的日期：如果今天是周日(0)，减去6天；否则减去当前星期几减1天
                var daysToSubtract = (int)now.DayOfWeek == 0 ? 6 : (int)now.DayOfWeek - 1;
                var weekStart = now.Date.AddDays(-daysToSubtract);
                var weekEnd = weekStart.AddDays(7);

                // 获取本月日期范围
                var monthStart = new DateTime(now.Year, now.Month, 1);
                var monthEnd = monthStart.AddMonths(1);

                // 获取所有库存数据，用于后续统计
                var allStockData = Repository.Db.Queryable<Dt_StockInfo>().ToList();
                var allTask_HtyData = Repository.Db.Queryable<Dt_Task_Hty>().ToList();
                // 调试信息：打印日期范围和库存数据总数
                var debugInfo = new
                {
                    CurrentDateTime = now,
                    TodayRange = $"{todayStart:yyyy-MM-dd HH:mm:ss} ~ {todayEnd:yyyy-MM-dd HH:mm:ss}",
                    WeekRange = $"{weekStart:yyyy-MM-dd HH:mm:ss} ~ {weekEnd:yyyy-MM-dd HH:mm:ss}",
                    MonthRange = $"{monthStart:yyyy-MM-dd HH:mm:ss} ~ {monthEnd:yyyy-MM-dd HH:mm:ss}",
                    TotalStockCount = allTask_HtyData.Count,
                    //AllStockStatus = allStockData.Select(it => new { it.Id, it.StockStatus, it.CreateDate }).ToList()
                    AllTask_HtyStatus = allTask_HtyData.Select(it => new { it.TaskId, it.TaskStatus, it.InsertTime }).ToList()
                };

                
                var toDt_task_hty_in = allTask_HtyData.Count(it => it.TaskStatus == (int)TaskInStatusEnum.InFinish);//获取出入库存历史任务记录
                var toDt_task_hty_on = allTask_HtyData.Count(it => it.TaskStatus == (int)TaskOutStatusEnum.OutFinish);
                // 今日入库数量：今天创建且库存状态为入库完成的记录数量
                var todayInbound = allTask_HtyData.Count(it =>
                    it.CreateDate >= todayStart && it.CreateDate < todayEnd &&
                    it.TaskStatus == (int)TaskInStatusEnum.InFinish);

                // 今日出库数量：今天创建且库存状态为出库完成的记录数量
                var todayOutbound = allTask_HtyData.Count(it =>
                    it.CreateDate >= todayStart && it.CreateDate < todayEnd &&
                    it.TaskStatus == (int)TaskOutStatusEnum.OutFinish);

                // 本周入库数量：本周创建且库存状态为入库完成的记录数量
                var weekInbound = allTask_HtyData.Count(it =>
                    it.CreateDate >= weekStart && it.CreateDate < weekEnd &&
                    it.TaskStatus == (int)TaskInStatusEnum.InFinish);

                // 本周出库数量：本周创建且任务状态为出库完成的记录数量
                var weekOutbound = allTask_HtyData.Count(it =>
                    it.CreateDate >= weekStart && it.CreateDate < weekEnd &&
                    it.TaskStatus == (int)TaskOutStatusEnum.OutFinish);

                // 本月入库数量：本月创建且库存状态为入库完成的记录数量
                var monthInbound = allTask_HtyData.Count(it =>
                    it.CreateDate >= monthStart && it.CreateDate < monthEnd &&
                    it.TaskStatus == (int)TaskInStatusEnum.InFinish);

                // 本月出库数量：本月创建且任务状态为出库完成的记录数量
                var monthOutbound = allTask_HtyData.Count(it =>
                    it.CreateDate >= monthStart && it.CreateDate < monthEnd &&
                    it.TaskStatus == (int)TaskOutStatusEnum.OutFinish);

                // 待处理订单数量：由于只有Dt_StockInfo表，暂时返回0
                var pendingOrders = 0;

                // 库存状态分布：统计不同库存状态的数量
                var stockStatusDistribution = allTask_HtyData
                    .GroupBy(it => it.TaskStatus)
                    .Select(g => new { Status = g.Key, Count = g.Count() })
                    .ToList();

                // 货位分布：统计不同货位的库存数量
                var locationDistribution = allTask_HtyData
                    .Where(it => !string.IsNullOrEmpty(it.TargetAddress))
                    .GroupBy(it => it.TargetAddress)
                    .Select(g => new { Location = g.Key, Count = g.Count() })
                    .OrderByDescending(g => g.Count)
                    .Take(10) // 只取前10个货位
                    .ToList();

                // 货位利用率：从数据库获取货位信息
                // 获取所有货位
                var allLocations = Repository.Db.Queryable<Dt_LocationInfo>().ToList();
                var totalLocations = allLocations.Count;

                // 统计不同状态的货位数
                var freeLocations = allLocations.Count(it => it.LocationStatus == (int)LocationStatusEnum.Free);
                var inStockLocations = allLocations.Count(it => it.LocationStatus == (int)LocationStatusEnum.InStock);
                var inStockLockLocations = allLocations.Count(it => it.LocationStatus == (int)LocationStatusEnum.InStockLock);
                var lockLocations = allLocations.Count(it => it.LocationStatus == (int)LocationStatusEnum.Lock);
                var freeLockLocations = allLocations.Count(it => it.LocationStatus == (int)LocationStatusEnum.FreeLock);
                var palletLockLocations = allLocations.Count(it => it.LocationStatus == (int)LocationStatusEnum.PalletLock);

                // 计算已使用和未使用的货位数
                // 已使用：有货、有货锁定
                var usedLocations = inStockLocations + inStockLockLocations;
                // 未使用：空闲、空闲锁定
                var unusedLocations = freeLocations + freeLockLocations;

                // 库存变化趋势：模拟最近7天的数据
                // 实际应根据数据库中的历史记录生成
                var stockTrend = Enumerable.Range(0, 7)
                    .Select(i => {
                        var date = now.AddDays(-6 + i).Date;
                        var count = allTask_HtyData.Count(it =>
                            it.CreateDate.Date <= date &&
                            it.TaskStatus == (int)TaskInStatusEnum.InFinish &&
                            (it.TaskStatus != (int)TaskOutStatusEnum.OutFinish || it.CreateDate.Date > date));
                        return new { Date = date.ToString("MM-dd"), Count = count };
                    })
                    .ToList();

                // 日出入库明细：按小时统计
                var dailyInout = new
                {
                    inbound = Enumerable.Range(8, 10).Select(hour =>
                        allTask_HtyData.Count(it =>
                            it.CreateDate >= todayStart.AddHours(hour) &&
                            it.CreateDate < todayStart.AddHours(hour + 1) &&
                            it.TaskStatus == (int)TaskInStatusEnum.InFinish))
                        .ToList(),
                    outbound = Enumerable.Range(8, 10).Select(hour =>
                        allTask_HtyData.Count(it =>
                            it.CreateDate >= todayStart.AddHours(hour) &&
                            it.CreateDate < todayStart.AddHours(hour + 1) &&
                            it.TaskStatus == (int)TaskOutStatusEnum.OutFinish))
                        .ToList()
                };

                // 周出入库统计：按天统计
                var weekInout = new
                {
                    inbound = Enumerable.Range(0, 7).Select(day =>
                        allTask_HtyData.Count(it =>
                            it.CreateDate >= weekStart.AddDays(day) &&
                            it.CreateDate < weekStart.AddDays(day + 1) &&
                            it.TaskStatus == (int)TaskInStatusEnum.InFinish))
                        .ToList(),
                    outbound = Enumerable.Range(0, 7).Select(day =>
                        allTask_HtyData.Count(it =>
                            it.CreateDate >= weekStart.AddDays(day) &&
                            it.CreateDate < weekStart.AddDays(day + 1) &&
                            it.TaskStatus == (int)TaskOutStatusEnum.OutFinish))
                        .ToList()
                };

                // 月出入库趋势：按5天统计
                var monthInout = new
                {
                    inbound = Enumerable.Range(0, 7).Select(i =>
                        allTask_HtyData.Count(it =>
                            it.CreateDate >= monthStart.AddDays(i * 5) &&
                            it.CreateDate < monthStart.AddDays((i + 1) * 5) &&
                            it.TaskStatus == (int)TaskInStatusEnum.InFinish))
                        .ToList(),
                    outbound = Enumerable.Range(0, 7).Select(i =>
                        allTask_HtyData.Count(it =>
                            it.CreateDate >= monthStart.AddDays(i * 5) &&
                            it.CreateDate < monthStart.AddDays((i + 1) * 5) &&
                            it.TaskStatus == (int)TaskOutStatusEnum.OutFinish))
                        .ToList()
                };

                // 组装返回数据，包含调试信息和图表数据
                var data = new
                {
                    totalLocations,
                    todayInbound,
                    todayOutbound,
                    weekInbound,
                    weekOutbound,
                    monthInbound,
                    monthOutbound,
                    pendingOrders,

                    // 图表数据
                    stockStatus = stockStatusDistribution.Select(item => new { name = $"状态{item.Status}", value = item.Count }).ToList(),
                    locationDistribution = locationDistribution.Select(item => new { name = item.Location, value = item.Count }).ToList(),
                    // 货位利用率：包含不同状态的货位数量
                    warehouseUtilization = new
                    {
                        total = totalLocations,
                        free = freeLocations,
                        inStock = inStockLocations,
                        inStockLock = inStockLockLocations,
                        lockLocations = lockLocations,
                        freeLock = freeLockLocations,
                        palletLock = palletLockLocations,
                        used = usedLocations,
                        unused = unusedLocations
                    },
                    stockTrend = stockTrend.Select(item => item.Count).ToList(),
                    dailyInout,
                    weekInout,
                    monthInout,

                    debugInfo
                };

                response.Status = true;
                response.Data = data;
                response.Message = "获取成功";
            }
            catch (Exception ex)
            {
                response.Status = false;
                response.Message = ex.Message;
                response.Data = new
                {
                    Exception = ex.ToString(),
                    StackTrace = ex.StackTrace
                };
            }
            return response;
        }
    }
}