using Admin.NET.Core.Helper.ExcelHelper;
using Furion;
using Furion.DatabaseAccessor;
using Furion.DatabaseAccessor.Extensions;
using Furion.DependencyInjection;
using Furion.DynamicApiController;
using Furion.FriendlyException;
using iWare.Wms.Application.Service.WmsBase.WmsPart.Dto;
using iWare.Wms.Core;
using iWare.Wms.Core.Enum;
using Mapster;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using Spire.Pdf.Graphics;
using System.Linq.Dynamic.Core;

namespace iWare.Wms.Application
{
    /// <summary>
    /// 零件信息服务
    /// </summary>
    [ApiDescriptionSettings("基础信息", Name = "WmsPart", Order = 100)]
    [Route("api/[Controller]")]
    public class WmsPartService : ControllerBase, IWmsPartService, IDynamicApiController, ITransient
    {
        private readonly IRepository<WmsPart,MasterDbContextLocator> _wmsPartRep;
        private readonly IRepository<WmsMaterial, MasterDbContextLocator> _wmsMaterialRep;
        private readonly IRepository<SysUser, MasterDbContextLocator> _sysUser;

        public WmsPartService(
            IRepository<WmsPart,MasterDbContextLocator> wmsPartRep,
            IRepository<WmsMaterial, MasterDbContextLocator> wmsMaterialRep,
            IRepository<SysUser, MasterDbContextLocator> sysUser
        )
        {
            _wmsPartRep = wmsPartRep;
            _wmsMaterialRep = wmsMaterialRep;
            _sysUser = sysUser;
        }

        /// <summary>
        /// 分页查询零件信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("page")]
        public async Task<PageResult<WmsPartOutput>> Page([FromQuery] WmsPartSearch input)
        {
            //获取登录用户
            var contextUser = App.User;
            var userName = contextUser.Claims.Single(x => x.Type == "Account").Value;
            //获取登录用户所属线别
            var lineType = await _sysUser.DetachedEntities.Where(u => u.Account == userName).Select(u => u.LineType).FirstOrDefaultAsync();


            var wmsParts = await _wmsPartRep.DetachedEntities
                                     .Where(!string.IsNullOrEmpty(input.PartCode), u => u.PartCode == input.PartCode)
                                     .Where(!string.IsNullOrEmpty(input.PartName), u => u.PartName == input.PartName)
                                     .Where(!string.IsNullOrEmpty(input.MaterialCode), u => u.MaterialCode == input.MaterialCode)
                                     .Where(lineType != null && lineType != LineTypeEnum.通用, u => u.LineType == lineType)
                                     //.Where(input.Status != null, u => u.Status == input.Status)
                                     .OrderBy(PageInputOrder.OrderBuilder<WmsPartSearch>(input))
                                     .ProjectToType<WmsPartOutput>()
                                     .ToADPagedListAsync(input.PageNo, input.PageSize);
            return wmsParts;
        }

        /// <summary>
        /// 增加零件信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("add")]
        public async Task Add([FromBody] AddWmsPartInput input)
        {

            var isExist = await _wmsPartRep.DetachedEntities.AnyAsync(u => u.PartCode == input.PartCode && u.LineType == input.LineType);
            if (isExist)
            {
                throw Oops.Oh("零件编号已存在");
            }

            var wmsPart = input.Adapt<WmsPart>();
            await _wmsPartRep.InsertAsync(wmsPart);
        }

        /// <summary>
        /// 删除零件信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("delete")]
        public async Task Delete([FromBody] DeleteWmsPartInput input)
        {
            var wmsPart = await _wmsPartRep.FirstOrDefaultAsync(u => u.Id == input.Id);
            await _wmsPartRep.DeleteAsync(wmsPart);
        }

        /// <summary>
        /// 更新零件信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("edit")]
        public async Task Update([FromBody] UpdateWmsPartInput input)
        {
            var isExist = await _wmsPartRep.AnyAsync(u => u.Id == input.Id, false);
            if (!isExist) throw Oops.Oh(ErrorCode.D3000);

            isExist = await _wmsPartRep.DetachedEntities.AnyAsync(u => u.PartCode == input.PartCode && u.LineType == input.LineType && u.Id != input.Id);
            if (isExist)
            {
                throw Oops.Oh("零件编号已存在");
            }

            var wmsPart = input.Adapt<WmsPart>();
            await _wmsPartRep.UpdateAsync(wmsPart,ignoreNullValues:true);
        }

        /// <summary>
        /// 获取零件信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("detail")]
        public async Task<WmsPartOutput> Get([FromQuery] QueryeWmsPartInput input)
        {
            return (await _wmsPartRep.DetachedEntities.FirstOrDefaultAsync(u => u.Id == input.Id)).Adapt<WmsPartOutput>();
        }

        /// <summary>
        /// 获取零件信息列表
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("list")]
        public async Task<dynamic> List([FromQuery] WmsPartInput input)
        {
            //获取登录用户
            var contextUser = App.User;
            var userName = contextUser.Claims.Single(x => x.Type == "Account").Value;
            //获取登录用户所属线别
            var lineType = await _sysUser.DetachedEntities.Where(u => u.Account == userName).Select(u => u.LineType).FirstOrDefaultAsync();

            //return await _wmsPartRep.DetachedEntities.ProjectToType<WmsPartOutput>().ToListAsync();
            var list = await _wmsPartRep.DetachedEntities.Where(!string.IsNullOrEmpty(input.PartCode),u => u.PartCode.Contains(input.PartCode.Trim()))
                                                         .Where(lineType != null && lineType != LineTypeEnum.通用, u => u.LineType == lineType).ToListAsync();
            return list.Select(e => new WarePartOutputDto { Code = e.PartCode, Name = e.PartName,LineType = e.LineType?.ToString() });
        }

        /// <summary>
        ///获取物料信息列表
        /// </summary>
        /// <returns></returns>
        [HttpGet("fkWmsMaterial")]
        public async Task<dynamic> FkWmsMaterialList()
        {

            var list = await _wmsMaterialRep.DetachedEntities.ToListAsync();
            return list.Select(e => new { Code = e.MaterialNo, Name = e.MaterialName });
        }

        /// <summary>
        /// 导出Excel
        /// </summary>
        /// <param name="input">筛选条件</param>
        /// <returns></returns>
        [HttpPost("download")]
        [AllowAnonymous]
        public async Task<ActionResult> Download([FromBody] WmsPartSearch input)
        {
            var dataRecords = await _wmsPartRep.DetachedEntities
                                     .Where(!string.IsNullOrEmpty(input.PartCode), u => u.PartCode == input.PartCode)
                                     .Where(!string.IsNullOrEmpty(input.PartName), u => u.PartName == input.PartName)
                                     .Where(!string.IsNullOrEmpty(input.MaterialCode), u => u.MaterialCode == input.MaterialCode)
                                     //.Where(input.Status != null, u => u.Status == input.Status)
                                     .OrderBy(PageInputOrder.OrderBuilder<WmsPartSearch>(input))
                                     .ProjectToType<WmsPartExcel>().ToListAsync();

            var excelBaseResult = new Excel2003Result<WmsPartExcel>(dataRecords, "小车信息" + DateTime.Now.ToString("yyyyMMdd"), false, "生产记录");
            return File(excelBaseResult.GetExcelStream(), "application/vnd.ms-excel");
        }
    }
}