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 System.Linq;
using System.Linq.Dynamic.Core;

namespace iWare.Wms.Application
{
    /// <summary>
    /// 设备刀具操作日志表服务
    /// </summary>
    [ApiDescriptionSettings("刀具相关", Name = "KnifeToolEquipmentUpdateLog", Order = 103)]
    [Route("api/[Controller]")]
    public class KnifeToolEquipmentUpdateLogService : IKnifeToolEquipmentUpdateLogService, IDynamicApiController, ITransient
    {
        private readonly IRepository<KnifeToolEquipmentUpdateLog,MasterDbContextLocator> _knifeToolEquipmentUpdateLogRep;
        private readonly IRepository<KnifeToolBaseInfo, MasterDbContextLocator> _knifeToolBaseInfoRep;


        public KnifeToolEquipmentUpdateLogService(
            IRepository<KnifeToolEquipmentUpdateLog,MasterDbContextLocator> knifeToolEquipmentUpdateLogRep
            , IRepository<KnifeToolBaseInfo, MasterDbContextLocator> knifeToolBaseInfoRep)
        {
            _knifeToolEquipmentUpdateLogRep = knifeToolEquipmentUpdateLogRep;
            _knifeToolBaseInfoRep = knifeToolBaseInfoRep;
        }

        /// <summary>
        /// 分页查询设备刀具操作日志表
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("page")]
        public async Task<PageResult<KnifeToolEquipmentUpdateLogOutput>> Page([FromQuery] KnifeToolEquipmentUpdateLogSearch input)
        {
            var knifeToolEquipmentUpdateLogs = await (from log in _knifeToolEquipmentUpdateLogRep.DetachedEntities
                     join baseinfo in _knifeToolBaseInfoRep.DetachedEntities on log.KnifeToolID equals baseinfo.KnifeToolID into baseinfo2
                     from baseinfo3 in baseinfo2.DefaultIfEmpty()
                     select new KnifeToolEquipmentUpdateLogOutput
                     {
                         EquipmentID = log.EquipmentID,
                         WorkingProcedure = log.WorkingProcedure,
                         Station = log.Station,
                         KnifeToolID = log.KnifeToolID,
                         KnifeToolName = log.KnifeToolName,
                         KnifeToolLife = (baseinfo3 == null ? 0 : baseinfo3.KnifeToolLife),
                         KnifeToolChangeAlertThreshold= (baseinfo3 == null ? 0 : baseinfo3.KnifeToolChangeAlertThreshold),
                         StartLife = log.StartLife.Value,
                         CurrentLife = log.CurrentLife.Value,
                         ResidueLife = log.ResidueLife.Value,
                         ChangeStartTime = log.ChangeStartTime,
                         ChangeEndTime = log.ChangeEndTime,
                         OperateDesc = log.OperateDesc,
                         OperateType = log.OperateType,
                         Remarks1 = log.Remarks1,
                         Remarks2 = log.Remarks2,
                         Remarks3 = log.Remarks3,
                         Id = log.Id

                     })
                   .ProjectToType<KnifeToolEquipmentUpdateLogOutput>()
                   .Where(!string.IsNullOrEmpty(input.EquipmentID), u => u.EquipmentID == input.EquipmentID)
                                     .ToADPagedListAsync(input.PageNo, input.PageSize);
            //var knifeToolEquipmentUpdateLogs = await _knifeToolEquipmentUpdateLogRep.DetachedEntities
            //    .GroupJoin(_knifeToolBaseInfoRep.DetachedEntities, a => a.KnifeToolID, b => b.KnifeToolID, (a, b) => new { a,b})
            //     .SelectMany(ab => ab.b.DefaultIfEmpty(), (ab, b) => new { ab.a, b.KnifeToolLife })
            //    .Where(!string.IsNullOrEmpty(input.EquipmentID), u => u.a.EquipmentID == input.EquipmentID)
            //                         //.Where(!string.IsNullOrEmpty(input.WorkingProcedure), u => u.WorkingProcedure == input.WorkingProcedure)
            //                         //.Where(!string.IsNullOrEmpty(input.Station), u => u.Station == input.Station)
            //                         .Where(!string.IsNullOrEmpty(input.KnifeToolID), u => u.a.KnifeToolID == input.KnifeToolID)
            //                         .Where(!string.IsNullOrEmpty(input.OperateType), u => u.a.OperateType == input.OperateType)
            //                         .Where(!string.IsNullOrEmpty(input.KnifeToolName), u => u.a.KnifeToolName == input.KnifeToolName)
            //                         ////.Where(input.StartLife != null, u => u.StartLife == input.StartLife)
            //                         ////.Where(input.CurrentLife != null, u => u.CurrentLife == input.CurrentLife)
            //                         ////.Where(input.ResidueLife, u => u.ResidueLife == input.ResidueLife)
            //                         .Where(input.ChangeStartTimeStart != null, u => u.a.ChangeStartTime >= input.ChangeStartTimeStart)
            //                         .Where(input.ChangeStartTimeEnd != null, u => u.a.ChangeStartTime < input.ChangeStartTimeEnd.Value.AddDays(1))//用日期查询
            //                                                                                                                                       //.Where(input.ChangeEndTime != null, u => u.ChangeEndTime == input.ChangeEndTime)
            //                                                                                                                                       //.Where(!string.IsNullOrEmpty(input.OperateDesc), u => u.OperateDesc == input.OperateDesc)
            //                                                                                                                                       //.Where(!string.IsNullOrEmpty(input.OperateType), u => u.OperateType == input.OperateType)
            //                                                                                                                                       //.Where(!string.IsNullOrEmpty(input.Remarks1), u => u.Remarks1 == input.Remarks1)
            //                                                                                                                                       //.Where(!string.IsNullOrEmpty(input.Remarks2), u => u.Remarks2 == input.Remarks2)
            //                                                                                                                                       //.Where(!string.IsNullOrEmpty(input.Remarks3), u => u.Remarks3 == input.Remarks3)
            //                         .OrderBy(PageInputOrder.OrderBuilder<KnifeToolEquipmentUpdateLogSearch>(input))
            //                         //.ProjectToType<KnifeToolEquipmentUpdateLogOutput>()
            //                         .ToADPagedListAsync(input.PageNo, input.PageSize);
            ////return knifeToolEquipmentUpdateLogs;
            return knifeToolEquipmentUpdateLogs;
        }

        /// <summary>
        /// 增加设备刀具操作日志表
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("add")]
        public async Task Add(AddKnifeToolEquipmentUpdateLogInput input)
        {
            var knifeToolEquipmentUpdateLog = input.Adapt<KnifeToolEquipmentUpdateLog>();
            await _knifeToolEquipmentUpdateLogRep.InsertAsync(knifeToolEquipmentUpdateLog);
        }

        /// <summary>
        /// 删除设备刀具操作日志表
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("delete")]
        public async Task Delete(DeleteKnifeToolEquipmentUpdateLogInput input)
        {
            var knifeToolEquipmentUpdateLog = await _knifeToolEquipmentUpdateLogRep.FirstOrDefaultAsync(u => u.Id == input.Id);
            await _knifeToolEquipmentUpdateLogRep.DeleteAsync(knifeToolEquipmentUpdateLog);
        }

        /// <summary>
        /// 更新设备刀具操作日志表
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("edit")]
        public async Task Update(UpdateKnifeToolEquipmentUpdateLogInput input)
        {
            var isExist = await _knifeToolEquipmentUpdateLogRep.AnyAsync(u => u.Id == input.Id, false);
            if (!isExist) throw Oops.Oh(ErrorCode.D3000);

            var knifeToolEquipmentUpdateLog = input.Adapt<KnifeToolEquipmentUpdateLog>();
            await _knifeToolEquipmentUpdateLogRep.UpdateAsync(knifeToolEquipmentUpdateLog,ignoreNullValues:true);
        }

        /// <summary>
        /// 获取设备刀具操作日志表
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("detail")]
        public async Task<KnifeToolEquipmentUpdateLogOutput> Get([FromQuery] QueryeKnifeToolEquipmentUpdateLogInput input)
        {
            return (await _knifeToolEquipmentUpdateLogRep.DetachedEntities.FirstOrDefaultAsync(u => u.Id == input.Id)).Adapt<KnifeToolEquipmentUpdateLogOutput>();
        }

        /// <summary>
        /// 获取设备刀具操作日志表列表
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("list")]
        public async Task<List<KnifeToolEquipmentUpdateLogOutput>> List([FromQuery] KnifeToolEquipmentUpdateLogInput input)
        {
            return await _knifeToolEquipmentUpdateLogRep.DetachedEntities.ProjectToType<KnifeToolEquipmentUpdateLogOutput>().ToListAsync();
        }    

    }
}