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

namespace iWare.Wms.Application
{
    /// <summary>
    /// 数据收集点对应字段服务
    /// </summary>
    [ApiDescriptionSettings("自己的业务", Name = "DataCaptureColumnConfig", Order = 100)]
    [Route("api/[Controller]")]
    public class DataCaptureColumnConfigService : IDataCaptureColumnConfigService, IDynamicApiController, ITransient
    {
        private readonly IRepository<DataCaptureColumnConfig,MasterDbContextLocator> _dataCaptureColumnConfigRep;


        public DataCaptureColumnConfigService(
            IRepository<DataCaptureColumnConfig,MasterDbContextLocator> dataCaptureColumnConfigRep
        )
        {
            _dataCaptureColumnConfigRep = dataCaptureColumnConfigRep;
        }

        /// <summary>
        /// 分页查询数据收集点对应字段
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("page")]
        public async Task<PageResult<DataCaptureColumnConfigOutput>> Page([FromQuery] DataCaptureColumnConfigSearch input)
        {
            var dataCaptureColumnConfigs = await _dataCaptureColumnConfigRep.DetachedEntities
                                     .Where(!string.IsNullOrEmpty(input.WorkingProcedure), u => u.WorkingProcedure == input.WorkingProcedure)
                                     .Where(!string.IsNullOrEmpty(input.DataCapturePointCode), u => u.DataCapturePointCode == input.DataCapturePointCode)
                                     .Where(!string.IsNullOrEmpty(input.DataCapturePointCname), u => u.DataCapturePointCname == input.DataCapturePointCname)
                                     .Where(input.DataCaptureType != null, u => u.DataCaptureType == input.DataCaptureType)
                                     .Where(!string.IsNullOrEmpty(input.DbNumber), u => u.DbNumber == input.DbNumber)
                                     .Where(!string.IsNullOrEmpty(input.Offset), u => u.Offset == input.Offset)
                                     .Where(input.DataCaptureColumnLength != null, u => u.DataCaptureColumnLength == input.DataCaptureColumnLength)
                                     .Where(!string.IsNullOrEmpty(input.DataCaptureColumnType), u => u.DataCaptureColumnType == input.DataCaptureColumnType)
                                     .Where(!string.IsNullOrEmpty(input.DataCaptureColumnTabelName), u => u.DataCaptureColumnTabelName == input.DataCaptureColumnTabelName)
                                     .Where(input.IsFeedback != null, u => u.IsFeedback == input.IsFeedback)
                                     .OrderBy(PageInputOrder.OrderBuilder<DataCaptureColumnConfigSearch>(input))
                                     .ProjectToType<DataCaptureColumnConfigOutput>()
                                     .ToADPagedListAsync(input.PageNo, input.PageSize);
            return dataCaptureColumnConfigs;
        }

        /// <summary>
        /// 增加数据收集点对应字段
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("add")]
        public async Task Add(AddDataCaptureColumnConfigInput input)
        {
            var dataCaptureColumnConfig = input.Adapt<DataCaptureColumnConfig>();
            await _dataCaptureColumnConfigRep.InsertAsync(dataCaptureColumnConfig);
        }

        /// <summary>
        /// 删除数据收集点对应字段
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("delete")]
        public async Task Delete(DeleteDataCaptureColumnConfigInput input)
        {
            var dataCaptureColumnConfig = await _dataCaptureColumnConfigRep.FirstOrDefaultAsync(u => u.Id == input.Id);
            await _dataCaptureColumnConfigRep.DeleteAsync(dataCaptureColumnConfig);
        }

        /// <summary>
        /// 更新数据收集点对应字段
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("edit")]
        public async Task Update(UpdateDataCaptureColumnConfigInput input)
        {
            var isExist = await _dataCaptureColumnConfigRep.AnyAsync(u => u.Id == input.Id, false);
            if (!isExist) throw Oops.Oh(ErrorCode.D3000);

            var dataCaptureColumnConfig = input.Adapt<DataCaptureColumnConfig>();
            await _dataCaptureColumnConfigRep.UpdateAsync(dataCaptureColumnConfig,ignoreNullValues:true);
        }

        /// <summary>
        /// 获取数据收集点对应字段
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("detail")]
        public async Task<DataCaptureColumnConfigOutput> Get([FromQuery] QueryeDataCaptureColumnConfigInput input)
        {
            return (await _dataCaptureColumnConfigRep.DetachedEntities.FirstOrDefaultAsync(u => u.Id == input.Id)).Adapt<DataCaptureColumnConfigOutput>();
        }

        /// <summary>
        /// 获取数据收集点对应字段列表
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("list")]
        public async Task<List<DataCaptureColumnConfigOutput>> List([FromQuery] DataCaptureColumnConfigInput input)
        {
            return await _dataCaptureColumnConfigRep.DetachedEntities.ProjectToType<DataCaptureColumnConfigOutput>().ToListAsync();
        }    

    }
}