using Admin.NET.Application.Entity;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Admin.NET.Application;
/// <summary>
/// 下架策略帮助类
/// </summary>
public class ConfigUnshelveStrategyHelper
{
    /// <summary>
    /// 根据下架策略范围获取下架策略选项
    /// </summary>
    /// <param name="_wmsConfigUnshelveStrategyChooseRep"></param>
    /// <param name="allUnshelveStrategyRangeList"></param>
    /// <returns></returns>
    public static async Task<List<WmsConfigUnshelveStrategyChoose>> GetUnshelveStrategyChooseListByRange(SqlSugarRepository<WmsConfigUnshelveStrategyChoose> _wmsConfigUnshelveStrategyChooseRep, List<v_wms_config_unshelve_strategy_range> allUnshelveStrategyRangeList)
    {
        var allStrategyCodeList = allUnshelveStrategyRangeList.Select(s => s.StrategyCode).Distinct().ToList();
        //下架策略选项
        var allUnshelveStrategyChooseList = await _wmsConfigUnshelveStrategyChooseRep.AsQueryable().Where(p => allStrategyCodeList.Contains(p.StrategyCode) && p.IsDelete == false).ToListAsync();
        return allUnshelveStrategyChooseList;
    }

    /// <summary>
    /// 获取生效的下架策略范围
    /// </summary>
    /// <param name="_v_wms_config_unshelve_strategy_rangeRep"></param>
    /// <param name="materialCodeList"></param>
    /// <returns></returns>

    public static async Task<List<v_wms_config_unshelve_strategy_range>> GetUseUnshelveStrategyRangeList(SqlSugarRepository<v_wms_config_unshelve_strategy_range> _v_wms_config_unshelve_strategy_rangeRep, List<string> materialCodeList)
    {
        var queryData = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 00:00:00"));
        return await _v_wms_config_unshelve_strategy_rangeRep.AsQueryable().Where(p =>
         (p.StartTime == null || Convert.ToDateTime(Convert.ToDateTime(p.StartTime).ToString("yyyy-MM-dd 00:00:00")) <= queryData)
         && (p.EndTime == null || queryData <= Convert.ToDateTime(Convert.ToDateTime(p.EndTime).ToString("yyyy-MM-dd 00:00:00"))
         )
        &&
        materialCodeList.Contains(p.MaterialCode)).ToListAsync();
    }



}