using Ao.Lang; 
using CMS.Extensions.Abp.AspNetCore.Mvc.Filters; 
using CMS.Plugin.HIAWms.Application.Contracts.Dtos.WmsContainerPlace; 
using CMS.Plugin.HIAWms.Application.Contracts.Services; 
using Microsoft.AspNetCore.Authorization; 
using Microsoft.AspNetCore.Http; 
using Microsoft.AspNetCore.Mvc; 
using MiniExcelLibs; 
using System.Reflection; 
using Volo.Abp; 
using Volo.Abp.Application.Dtos; 
 
namespace CMS.Plugin.HIAWms.Controller 
{ 
    /// <summary> 
    /// 库位容器关系服务 
    /// </summary> 
    [ApiController] 
    [TypeFilter(typeof(CMSLanguageFilter))] 
    [TypeFilter(typeof(CMSUowActionFilter))] 
    [TypeFilter(typeof(CMSAuditActionFilter))] 
    [TypeFilter(typeof(CMSExceptionFilter))] 
    [Route("api/v{version:apiVersion}/HIAWms/[controller]")] 
    public class WmsContainerPlaceController : ControllerBase 
    { 
        private readonly IWmsContainerPlaceAppService _wmsContainerPlaceAppService; 
 
        /// <summary> 
        /// Initializes a new instance of the <see cref="WmsContainerPlaceController"/> class. 
        /// </summary> 
        /// <param name="wmsContainerPlaceAppService">The wmsContainerPlace application service.</param> 
        public WmsContainerPlaceController(IWmsContainerPlaceAppService wmsContainerPlaceAppService) 
        { 
            _wmsContainerPlaceAppService = wmsContainerPlaceAppService; 
        } 
 
        /// <summary> 
        /// 获取库位容器关系 
        /// </summary> 
        /// <param name="id">标识符.</param> 
        /// <returns></returns> 
        [HttpGet] 
        [Route("{id}")] 
        public virtual Task<WmsContainerPlaceDto> GetAsync(Guid id) 
        { 
            return _wmsContainerPlaceAppService.GetAsync(id); 
        } 
 
        /// <summary> 
        /// 分页获取库位容器关系的列表. 
        /// </summary> 
        /// <param name="input">输入.</param> 
        /// <returns></returns> 
        [HttpGet] 
        [Route("Page")] 
        public virtual Task<PagedResultDto<WmsContainerPlaceDto>> GetListAsync([FromQuery] GetWmsContainerPlaceInput input) 
        { 
            return _wmsContainerPlaceAppService.GetListAsync(input); 
        } 
 
        /// <summary> 
        /// 创建库位容器关系 
        /// </summary> 
        /// <param name="input">输入.</param> 
        /// <returns></returns> 
        [Authorize] 
        [HttpPost] 
        public virtual Task<WmsContainerPlaceDto> CreateAsync(WmsContainerPlaceCreateDto input) 
        { 
            return _wmsContainerPlaceAppService.CreateAsync(input); 
        } 
 
        /// <summary> 
        /// 更新库位容器关系 
        /// </summary> 
        /// <param name="id">标识符.</param> 
        /// <param name="input">输入.</param> 
        /// <returns></returns> 
        [Authorize] 
        [HttpPut] 
        [Route("{id}")] 
        public virtual Task<WmsContainerPlaceDto> UpdateAsync(Guid id, WmsContainerPlaceUpdateDto input) 
        { 
            return _wmsContainerPlaceAppService.UpdateAsync(id, input); 
        } 
 
        /// <summary> 
        /// 克隆库位容器关系 
        /// </summary> 
        /// <param name="ids">Id集合.</param> 
        /// <returns></returns> 
        [Authorize] 
        [HttpPost] 
        [Route("Clone")] 
        public virtual Task<List<WmsContainerPlaceDto>> CloneAsync([FromBody] IEnumerable<Guid> ids) 
        { 
            return _wmsContainerPlaceAppService.CloneAsync(ids); 
        } 
 
        /// <summary> 
        /// 删除库位容器关系 
        /// </summary> 
        /// <param name="id">标识符.</param> 
        /// <returns></returns> 
        [Authorize] 
        [HttpDelete] 
        [Route("{id}")] 
        public virtual Task DeleteAsync(Guid id) 
        { 
            return _wmsContainerPlaceAppService.DeleteAsync(id); 
        } 
 
        /// <summary> 
        /// 批量删除库位容器关系 
        /// </summary> 
        /// <param name="ids">The ids.</param> 
        /// <returns></returns> 
        [Authorize] 
        [HttpDelete] 
        public virtual Task DeleteAsync([FromBody] IEnumerable<Guid> ids) 
        { 
            return _wmsContainerPlaceAppService.DeleteManyAsync(ids); 
        } 
 
        /// <summary> 
        /// 调整排序库位容器关系 
        /// </summary> 
        /// <param name="id">标识符.</param> 
        /// <returns></returns> 
        [HttpPut] 
        [Route("{id}/AdjustSort/{sort}")] 
        public virtual Task AdjustSortAsync(Guid id, int sort) 
        { 
            return _wmsContainerPlaceAppService.AdjustSortAsync(id, sort); 
        } 
 
        /// <summary> 
        /// 导入库位容器关系 
        /// </summary> 
        /// <returns></returns> 
        [Authorize] 
        [HttpPost] 
        [Route("Import")] 
        public virtual async Task<IActionResult> ImportAsync(IFormFile file) 
        { 
            using var stream = new MemoryStream(); 
            await file.CopyToAsync(stream); 
            stream.Seek(0L, SeekOrigin.Begin); 
 
            var sheetNames = stream.GetSheetNames(); 
            var wmsContainerPlaceRows = sheetNames.Contains("配置") ? MiniExcel.Query<WmsContainerPlacesImportModel.WmsContainerPlaceImportModel>(stream, sheetName: "配置").ToList() : new(); 
 
            if (!wmsContainerPlaceRows.Any()) 
            { 
                throw new UserFriendlyException("请检查导入的表格"); 
            } 
 
            await _wmsContainerPlaceAppService.ImportAsync(new WmsContainerPlacesImportModel 
            { 
                WmsContainerPlaces = wmsContainerPlaceRows, 
            }); 
 
            return Ok(); 
        } 
 
        /// <summary> 
        /// 导出库位容器关系 
        /// </summary> 
        /// <returns></returns> 
        [HttpGet] 
        [Route("Export")] 
        public virtual async Task<IActionResult> ExportAsync([FromQuery] GetWmsContainerPlaceInput input) 
        { 
            input.MaxResultCount = int.MaxValue; 
            var exportData = await _wmsContainerPlaceAppService.ExportAsync(input); 
            var templatePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, $"Resources/Templates/WmsContainerPlace导出模板.xlsx"); 
            if (!System.IO.File.Exists(templatePath)) 
            { 
                templatePath = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) ?? string.Empty, $"Resources/Templates/WmsContainerPlace导出模板.xlsx"); 
            } 
 
            var memoryStream = new MemoryStream(); 
            await memoryStream.SaveAsByTemplateAsync(templatePath, exportData.Sheets); 
            memoryStream.Seek(0L, SeekOrigin.Begin); 
            return new FileStreamResult(memoryStream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") { FileDownloadName = $"{exportData.FileName}_{DateTime.Now:yyyyMMddhhmmss}.xlsx" }; 
        } 
    } 
}