using Furion.DatabaseAccessor;
using Furion.DatabaseAccessor.Extensions;
using Furion.DependencyInjection;
using Furion.DynamicApiController;
using Furion.FriendlyException;
using iWare.Wms.Core;
using Mapster;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Internal;
using System.Linq.Dynamic.Core;

namespace iWare.Wms.Application
{
    /// <summary>
    /// 刀具基本信息服务
    /// </summary>
    [ApiDescriptionSettings("基础数据管理", Name = "KnifeToolBaseInfo", Order = 100)]
    [Route("api/[Controller]")]
    public class KnifeToolBaseInfoService : IKnifeToolBaseInfoService, IDynamicApiController, ITransient
    {
        private readonly IRepository<KnifeToolBaseInfo,MasterDbContextLocator> _knifeToolBaseInfoRep;
        private readonly IRepository<EquipmentBaseInfo, MasterDbContextLocator> _equipmentBaseInfoRep;

        /// <summary>
        /// 刀具基本信息构造函数
        /// </summary>
        /// <param name="knifeToolBaseInfoRep"></param>
        /// <param name="equipmentBaseInfoRep"></param>
        public KnifeToolBaseInfoService(
            IRepository<KnifeToolBaseInfo,MasterDbContextLocator> knifeToolBaseInfoRep,
            IRepository<EquipmentBaseInfo, MasterDbContextLocator> equipmentBaseInfoRep
        )
        {
            _knifeToolBaseInfoRep = knifeToolBaseInfoRep;
            _equipmentBaseInfoRep = equipmentBaseInfoRep;
        }

        /// <summary>
        /// 分页查询刀具基本信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("page")]
        public async Task<PageResult<KnifeToolBaseInfoOutput>> Page([FromQuery] KnifeToolBaseInfoSearch input)
        {
            //var knifeToolBaseInfos = await _knifeToolBaseInfoRep.DetachedEntities
            //                         .GroupJoin(_equipmentBaseInfoRep.DetachedEntities, a => a.EquipmentID, b => b.EquipmentId, (a, b) => new { a = a, b = b.DefaultIfEmpty().FirstOrDefault() })
            //                         .Where(!string.IsNullOrEmpty(input.KnifeToolModel), u => u.KnifeToolModel.Contains(input.KnifeToolModel))
            //                         .Where(!string.IsNullOrEmpty(input.EquipmentID), u => u.EquipmentID == input.EquipmentID)
            //                         .Select(s => new KnifeToolBaseInfoOutput
            //                         {
            //                             Id = s.Id,
            //                             KnifeToolID = s.KnifeToolID,
            //                             KnifeToolModel = s.KnifeToolModel,
            //                             KnifeEdgeNumber = s.KnifeEdgeNumber,
            //                             KnifeToolLife = s.KnifeToolLife,
            //                             KnifeLength = s.KnifeLength,
            //                             EquipmentID = s.EquipmentID,
            //                             //EquipmentName=s.b.EquipmentName,
            //                             CreatedTime = s.CreatedTime,
            //                             Remarks = s.Remarks,
            //                         })
            //                         .OrderBy(PageInputOrder.OrderBuilder<KnifeToolBaseInfoSearch>(input))
            //                         .ProjectToType<KnifeToolBaseInfoOutput>()
            //                         .ToADPagedListAsync(input.PageNo, input.PageSize;
            var knifeToolBaseInfos = await (from knife in _knifeToolBaseInfoRep.DetachedEntities
                                            join baseinfo in _equipmentBaseInfoRep.DetachedEntities on knife.EquipmentID equals baseinfo.EquipmentId into joinEmpty
                                            from baseinfo2 in joinEmpty.DefaultIfEmpty()
                                            where knife.KnifeToolModel == (input.KnifeToolModel?? knife.KnifeToolModel)
                                            where knife.EquipmentID == (input.EquipmentID?? knife.EquipmentID)
                                            select new KnifeToolBaseInfoOutput
                                            {
                                                Id = knife.Id,
                                                KnifeToolID = knife.KnifeToolID,
                                                KnifeToolModel = knife.KnifeToolModel,
                                                KnifeEdgeNumber = knife.KnifeEdgeNumber,
                                                KnifeToolLife = knife.KnifeToolLife,
                                                KnifeLength = knife.KnifeLength,
                                                EquipmentID = knife.EquipmentID,
                                                EquipmentName= baseinfo2.EquipmentName,
                                                KnifeToolChangeAlertThreshold= knife.KnifeToolChangeAlertThreshold,
                                                CreatedTime = knife.CreatedTime,
                                                Remarks = knife.Remarks,
                                            })
                                     .ProjectToType<KnifeToolBaseInfoOutput>()
                                     .OrderBy(PageInputOrder.OrderBuilder<KnifeToolBaseInfoSearch>(input))
                                     .ToADPagedListAsync(input.PageNo, input.PageSize);

            return knifeToolBaseInfos;
        }

        /// <summary>
        /// 增加刀具基本信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("add")]
        public async Task Add(AddKnifeToolBaseInfoInput input)
        {
            var isExist = await _knifeToolBaseInfoRep.AnyAsync(u => u.KnifeToolID == input.KnifeToolID, false);
            if (isExist) throw Oops.Oh($"当前刀具编号已存在，新增失败！");

            var knifeToolBaseInfo = input.Adapt<KnifeToolBaseInfo>();
            await _knifeToolBaseInfoRep.InsertAsync(knifeToolBaseInfo);
        }

        /// <summary>
        /// 删除刀具基本信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("delete")]
        public async Task Delete(DeleteKnifeToolBaseInfoInput input)
        {
            var knifeToolBaseInfo = await _knifeToolBaseInfoRep.FirstOrDefaultAsync(u => u.Id == input.Id);
            knifeToolBaseInfo.IsDeleted = true;
            //await _knifeToolBaseInfoRep.DeleteAsync(knifeToolBaseInfo);
        }

        /// <summary>
        /// 批量删除刀具基础信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("selectDelete")]
        public async Task SelectDelete(List<KnifeToolBaseInfoInput> input)
        {
            foreach (var item in input)
            {
                var knifeToolBaseInfo = await _knifeToolBaseInfoRep.FirstOrDefaultAsync(u => u.Id == item.Id);
                knifeToolBaseInfo.IsDeleted = true;
                //await _knifeToolBaseInfoRep.DeleteAsync(knifeToolBaseInfo);
            }
        }

        /// <summary>
        /// 更新刀具基本信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("edit")]
        public async Task Update(UpdateKnifeToolBaseInfoInput input)
        {
            var isExist = await _knifeToolBaseInfoRep.AnyAsync(u => u.Id == input.Id && u.KnifeToolID == input.KnifeToolID, false);
            if (!isExist) throw Oops.Oh($"刀具编号不能进行变更，修改失败！");

            var knifeToolBaseInfo = input.Adapt<KnifeToolBaseInfo>();
            await _knifeToolBaseInfoRep.UpdateAsync(knifeToolBaseInfo,ignoreNullValues:true);
        }

        /// <summary>
        /// 获取刀具基本信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("detail")]
        public async Task<KnifeToolBaseInfoOutput> Get([FromQuery] QueryeKnifeToolBaseInfoInput input)
        {
            return (await _knifeToolBaseInfoRep.DetachedEntities.FirstOrDefaultAsync(u => u.Id == input.Id)).Adapt<KnifeToolBaseInfoOutput>();
        }

        /// <summary>
        /// 获取刀具基本信息列表
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("list")]
        public async Task<List<KnifeToolBaseInfoOutput>> List([FromQuery] KnifeToolBaseInfoInput input)
        {
            return await _knifeToolBaseInfoRep.DetachedEntities.ProjectToType<KnifeToolBaseInfoOutput>().ToListAsync();
        }    

    }
}