using CMS.Plugin.HIAWms.Application.Contracts.Dtos.WmsContainerPlace;
using CMS.Plugin.HIAWms.Application.Contracts.Services;
using CMS.Plugin.HIAWms.Domain.Shared;
using CmsQueryExtensions;
using CMS.Plugin.HIAWms.Domain.WmsContainerPlace;
using CmsQueryExtensions.Extension;
using System.Linq.Expressions;
using Volo.Abp;
using Volo.Abp.Application.Dtos;
using Volo.Abp.Data;
using Volo.Abp.ObjectExtending;
using Volo.Abp.ObjectMapping;

namespace CMS.Plugin.HIAWms.Application.Implements;

/// <summary> 
/// 库位容器关系应用服务 
/// </summary> 
public class WmsContainerPlaceAppService : CMSPluginAppService, IWmsContainerPlaceAppService
{
    private readonly IWmsContainerPlaceRepository wmsContainerPlaceRepository;

    /// <summary> 
    /// Initializes a new instance of the <see cref="WmsContainerPlaceAppService"/> class. 
    /// </summary> 
    /// <param name="WmsContainerPlaceRepository">The task job repository.</param> 
    public WmsContainerPlaceAppService(IWmsContainerPlaceRepository _WmsContainerPlaceRepository)
    {
        wmsContainerPlaceRepository = _WmsContainerPlaceRepository;
    }

    /// <summary> 
    /// 获取指定库位容器关系 
    /// </summary> 
    /// <param name="id"></param> 
    /// <returns></returns> 
    public virtual async Task<WmsContainerPlaceDto> GetAsync(Guid id)
    {
        return ObjectMapper.Map<WmsContainerPlace, WmsContainerPlaceDto>(await wmsContainerPlaceRepository.GetAsync(id));
    }

    /// <summary> 
    /// 分页获取库位容器关系 
    /// </summary> 
    /// <param name="input"></param> 
    /// <returns></returns> 
    public virtual async Task<PagedResultDto<WmsContainerPlaceDto>> GetListAsync(GetWmsContainerPlaceInput input)
    {
        Check.NotNull(input, nameof(input));

        if (input.Sorting.IsNullOrWhiteSpace())
        {
            input.Sorting = nameof(WmsContainerPlace.Sort);
        }

        #region 动态构造查询条件  

        //动态构造查询条件  
        var whereConditions = DynamicGetQueryParams(input);

        #endregion

        var count = await wmsContainerPlaceRepository.GetCountAsync(whereConditions);
        var list = await wmsContainerPlaceRepository.GetListAsync(whereConditions, input.Sorting, input.MaxResultCount, input.SkipCount);

        return new PagedResultDto<WmsContainerPlaceDto>(count, ObjectMapper.Map<List<WmsContainerPlace>, List<WmsContainerPlaceDto>>(list));
    }

    /// <summary>  
    /// 动态构造查询条件  
    /// </summary>  
    /// <param name="input">输入参数</param>  
    /// <returns></returns>  
    private FunReturnResultModel<Expression<Func<WmsContainerPlace, bool>>> DynamicGetQueryParams(GetWmsContainerPlaceInput input)
    {
        //动态构造查询条件  
        var whereConditions = WhereConditionsExtensions.GetWhereConditions<WmsContainerPlace, GetWmsContainerPlaceInput>(input);
        if (!whereConditions.IsSuccess)
        {
            throw new Exception("动态构造查询条件失败:" + whereConditions.ErrMsg);
        }

        //也可再次自定义构建查询条件  
        Expression<Func<WmsContainerPlace, bool>> extendExpression = a => a.IsDeleted == false;
        // 使用 System.Linq.PredicateBuilder 的 And 
        var pres = (System.Linq.Expressions.Expression<Func<WmsContainerPlace, bool>>)(whereConditions.data);
        whereConditions.data = System.Linq.PredicateBuilder.And(pres, extendExpression);

        return whereConditions;
    }

    /// <summary> 
    /// 新建库位容器关系 
    /// </summary> 
    /// <param name="input"></param> 
    /// <returns></returns> 
    /// <exception cref="UserFriendlyException"></exception> 
    public virtual async Task<WmsContainerPlaceDto> CreateAsync(WmsContainerPlaceCreateDto input)
    {
        await CheckCreateOrUpdateDtoAsync(input);

        var exist = await wmsContainerPlaceRepository.NameExistAsync(input.PlaceNo);
        if (exist)
        {
            throw new UserFriendlyException(L[CMSPluginDomainErrorCodes.NameAlreadyExists, input.PlaceNo]);
        }

        var maxSort = await wmsContainerPlaceRepository.GetMaxSortAsync();
        var sort = input.Sort ?? maxSort;

        var insertObj = ObjectMapper.Map<WmsContainerPlaceCreateDto, WmsContainerPlace>(input);
        insertObj.Sort = sort;
        input.MapExtraPropertiesTo(insertObj, MappingPropertyDefinitionChecks.None);

        await wmsContainerPlaceRepository.InsertAsync(insertObj);

        //if (input.Sort.HasValue && insertObj.Sort != maxSort) 
        //{ 
        //    await AdjustSortAsync(insertObj.Id, insertObj.Sort); 
        //} 

        return ObjectMapper.Map<WmsContainerPlace, WmsContainerPlaceDto>(insertObj);
    }

    /// <summary> 
    /// 更新库位容器关系 
    /// </summary> 
    /// <param name="id"></param> 
    /// <param name="input"></param> 
    /// <returns></returns> 
    /// <exception cref="UserFriendlyException"></exception> 
    public virtual async Task<WmsContainerPlaceDto> UpdateAsync(Guid id, WmsContainerPlaceUpdateDto input)
    {
        await CheckCreateOrUpdateDtoAsync(input);

        var updateObj = await wmsContainerPlaceRepository.GetAsync(id);
        var exist = await wmsContainerPlaceRepository.NameExistAsync(input.PlaceNo, updateObj.Id);
        if (exist)
        {
            throw new UserFriendlyException(L[CMSPluginDomainErrorCodes.NameAlreadyExists, input.PlaceNo]);
        }

        updateObj.SetConcurrencyStampIfNotNull(input.ConcurrencyStamp);
        input.MapExtraPropertiesTo(updateObj, MappingPropertyDefinitionChecks.None);

        updateObj.PlaceNo = input.PlaceNo;
        updateObj.ContainerNo = input.ContainerNo;
        updateObj.IsDisabled = input.IsDisabled;
        updateObj.Remark = input.Remark;
        updateObj.CreatorName = input.CreatorName;
        updateObj.DeleteRemark = input.DeleteRemark;
        updateObj.ExtraField1 = input.ExtraField1;
        updateObj.ExtraField2 = input.ExtraField2;
        updateObj.ExtraField3 = input.ExtraField3;
        updateObj.LastModifierName = input.LastModifierName;
        updateObj.OperationRemark = input.OperationRemark;


        await wmsContainerPlaceRepository.UpdateAsync(updateObj);

        return ObjectMapper.Map<WmsContainerPlace, WmsContainerPlaceDto>(updateObj);
    }

    /// <summary> 
    /// 克隆库位容器关系 
    /// </summary> 
    /// <param name="ids"></param> 
    /// <returns></returns> 
    public async Task<List<WmsContainerPlaceDto>> CloneAsync(IEnumerable<Guid> ids)
    {
        //var wmsContainerPlaces = new List<WmsContainerPlace>(); 
        //if (ids != null) 
        //{ 
        //    var sort = await wmsContainerPlaceRepository.GetMaxSortAsync(); 
        //    foreach (var id in ids) 
        //    { 
        //        var WmsContainerPlace = await wmsContainerPlaceRepository.FindAsync(id); 
        //        if (WmsContainerPlace != null) 
        //        { 
        //            var name = WmsContainerPlace.Name + WmsContainerPlaceConsts.CloneTag; 
        //            var notExist = false; 
        //            while (!notExist) 
        //            { 
        //                var exist = await wmsContainerPlaceRepository.NameExistAsync(name); 
        //                if (exist || wmsContainerPlaces.Any(x => x.Name == name)) 
        //                { 
        //                    name += WmsContainerPlaceConsts.CloneTag; 
        //                    continue; 
        //                } 

        //                notExist = true; 
        //            } 

        //            //WmsContainerPlace = await wmsContainerPlaceRepository.InsertAsync(WmsContainerPlace.Clone(GuidGenerator.Create(), name, sort++)); 
        //            wmsContainerPlaces.Add(WmsContainerPlace); 
        //        } 
        //    } 
        //} 

        //return ObjectMapper.Map<List<WmsContainerPlace>, List<WmsContainerPlaceDto>>(wmsContainerPlaces); 
        return new List<WmsContainerPlaceDto>();
    }

    /// <summary> 
    /// 删除单个库位容器关系 
    /// </summary> 
    /// <param name="id"></param> 
    /// <returns></returns> 
    public virtual Task DeleteAsync(Guid id)
    {
        return wmsContainerPlaceRepository.DeleteAsync(id);
    }

    /// <summary> 
    /// 删除多个库位容器关系 
    /// </summary> 
    /// <param name="ids"></param> 
    /// <returns></returns> 
    public async Task DeleteManyAsync(IEnumerable<Guid> ids)
    {
        foreach (var id in ids)
        {
            await DeleteAsync(id);
        }
    }

    /// <summary> 
    /// 调整排序库位容器关系 
    /// </summary> 
    /// <param name="id"></param> 
    /// <param name="sort"></param> 
    /// <returns></returns> 
    public virtual async Task AdjustSortAsync(Guid id, int sort)
    {
        var list = await wmsContainerPlaceRepository.GetListAsync(null, nameof(WmsContainerPlace.Sort));
        if (list != null && list.Any())
        {
            var initSort = 1;
            list.ForEach(x => x.AdjustSort(initSort++));
            var entity = list.FirstOrDefault(x => x.Id == id);
            if (entity != null)
            {
                if (sort == 1)
                {
                    list.Where(x => x.Id != id).ToList()?.ForEach(x => x.AdjustSort(x.Sort + 1));
                }
                else if (entity.Sort > sort)
                {
                    list.Where(x => x.Id != id && x.Sort >= sort).ToList()?.ForEach(x => x.AdjustSort(x.Sort + 1));
                    list.Where(x => x.Id != id && x.Sort < sort).ToList()?.ForEach(x => x.AdjustSort(x.Sort - 1));
                }
                else if (entity.Sort < sort)
                {
                    list.Where(x => x.Id != id && x.Sort > sort).ToList()?.ForEach(x => x.AdjustSort(x.Sort + 1));
                    list.Where(x => x.Id != id && x.Sort <= sort).ToList()?.ForEach(x => x.AdjustSort(x.Sort - 1));
                }

                entity.AdjustSort(sort);
            }
        }

        await wmsContainerPlaceRepository.UpdateManyAsync(list);
    }

    /// <summary> 
    /// 导入库位容器关系 
    /// </summary> 
    /// <param name="input"></param> 
    /// <returns></returns> 
    /// <exception cref="UserFriendlyException"></exception> 
    public async Task ImportAsync(WmsContainerPlacesImportModel input)
    {
        Check.NotNull(input, nameof(input));

        var wmsContainerPlaceCreateDtos = new List<(int RowIndex, WmsContainerPlaceCreateDto Item)>();
        var wmsContainerPlaceUpdateDtos = new List<(int RowIndex, Guid Id, WmsContainerPlaceUpdateDto Item)>();
        var importItems = input.WmsContainerPlaces;

        if (importItems != null && importItems.Any())
        {
            #region 导入校验 

            // 判断名称是否重复，并输出第几行重复 
            var duplicateWmsContainerPlaces = importItems.GroupBy(x => x.PlaceNo).Where(x => x.Count() > 1).ToList();
            if (duplicateWmsContainerPlaces?.Any() == true)
            {
                var duplicateWmsContainerPlaceMsgs = duplicateWmsContainerPlaces.Select(x => $"第 {string.Join(",", x.Select(x => x.RowIndex))} 行：{x.Key}  名称重复");
                var errorMsg = $"导入失败！配置， {string.Join(",", duplicateWmsContainerPlaceMsgs)}，终止导入";
                throw new UserFriendlyException(errorMsg);
            }

            #endregion

            foreach (var impItem in importItems)
            {
                if (impItem.PlaceNo.IsNullOrWhiteSpace())
                {
                    continue;
                }

                if (impItem.PlaceNo.IsNullOrWhiteSpace())
                {
                    var errorMsg = $"导入失败！配置，第{impItem.RowIndex}行：WmsContainerPlace名称不能为空";
                    throw new UserFriendlyException(errorMsg);
                }

                var oldWmsContainerPlace = await wmsContainerPlaceRepository.FindByNameAsync(impItem.PlaceNo);
                if (oldWmsContainerPlace != null)
                {
                    var wmsContainerPlaceUpdateDto = new WmsContainerPlaceUpdateDto
                    {
                        PlaceNo = impItem.PlaceNo,
                        ContainerNo = impItem.ContainerNo,
                        BindTime = impItem.BindTime,
                        IsDisabled = impItem.IsDisabled,
                        Remark = impItem.Remark,
                        CreatorName = impItem.CreatorName,
                        DeleteRemark = impItem.DeleteRemark,
                        ExtraField1 = impItem.ExtraField1,
                        ExtraField2 = impItem.ExtraField2,
                        ExtraField3 = impItem.ExtraField3,
                        LastModifierName = impItem.LastModifierName,
                        OperationRemark = impItem.OperationRemark,

                    };

                    wmsContainerPlaceUpdateDtos.Add((impItem.RowIndex, oldWmsContainerPlace.Id, wmsContainerPlaceUpdateDto));
                }
                else
                {
                    var wmsContainerPlaceCreateDto = new WmsContainerPlaceCreateDto
                    {
                        PlaceNo = impItem.PlaceNo,
                        ContainerNo = impItem.ContainerNo,
                        BindTime = impItem.BindTime,
                        IsDisabled = impItem.IsDisabled,
                        Remark = impItem.Remark,
                        CreatorName = impItem.CreatorName,
                        DeleteRemark = impItem.DeleteRemark,
                        ExtraField1 = impItem.ExtraField1,
                        ExtraField2 = impItem.ExtraField2,
                        ExtraField3 = impItem.ExtraField3,
                        LastModifierName = impItem.LastModifierName,
                        OperationRemark = impItem.OperationRemark,

                    };

                    wmsContainerPlaceCreateDtos.Add((impItem.RowIndex, wmsContainerPlaceCreateDto));
                }
            }
        }

        // 新增 
        foreach (var wmsContainerPlaceDto in wmsContainerPlaceCreateDtos)
        {
            try
            {
                await CreateAsync(wmsContainerPlaceDto.Item);
            }
            catch (Exception e)
            {
                var errorMsg = $"导入失败！配置，第{wmsContainerPlaceDto.RowIndex}行：{e.Message}，终止导入";
                throw new UserFriendlyException(errorMsg);
            }
        }

        // 更新 
        foreach (var wmsContainerPlaceDto in wmsContainerPlaceUpdateDtos)
        {
            try
            {
                await UpdateAsync(wmsContainerPlaceDto.Id, wmsContainerPlaceDto.Item);
            }
            catch (Exception e)
            {
                var errorMsg = $"导入失败！配置，第{wmsContainerPlaceDto.RowIndex}行：{e.Message}，终止导入";
                throw new UserFriendlyException(errorMsg);
            }
        }
    }

    /// <summary> 
    /// 导出库位容器关系 
    /// </summary> 
    /// <param name="input"></param> 
    /// <returns></returns> 
    public async Task<(Dictionary<string, object> Sheets, string FileName)> ExportAsync(GetWmsContainerPlaceInput input)
    {
        Check.NotNull(input, nameof(input));

        if (input.Sorting.IsNullOrWhiteSpace())
        {
            input.Sorting = nameof(WmsContainerPlace.Sort);
        }

        #region 动态构造查询条件  

        //动态构造查询条件  
        var whereConditions = DynamicGetQueryParams(input);

        #endregion


        var list = await wmsContainerPlaceRepository.GetListAsync(whereConditions, input.Sorting, input.MaxResultCount, input.SkipCount, includeDetails: true);
        var result = ObjectMapper.Map<List<WmsContainerPlace>, List<WmsContainerPlaceDto>>(list);

        var sheets = new Dictionary<string, object>
        {
            ["配置"] = ExportHelper.ConvertListToExportData(result),
        };

        var fileName = result.Count > 1 ? "库位容器关系列表" : result.Count == 1 ? result[0]?.PlaceNo : "WmsContainerPlace模版";
        return (sheets, fileName);
    }

    /// <summary> 
    /// 校验库位容器关系，当新建或更新时 
    /// </summary> 
    /// <param name="input"></param> 
    /// <returns></returns> 
    protected Task CheckCreateOrUpdateDtoAsync(WmsContainerPlaceCreateOrUpdateDtoBase input)
    {
        Check.NotNull(input, nameof(input));
        Check.NotNullOrWhiteSpace(input.PlaceNo, "库位编码", 50);
        Check.NotNullOrWhiteSpace(input.ContainerNo, "编码", 64);
        Check.NotNull(input.BindTime, "名称");

        return Task.CompletedTask;
    }
}