using Microsoft.AspNetCore.Mvc; using Microsoft.Extensions.Localization; using Microsoft.Extensions.Options; using MiniExcelLibs; using ZR.Infrastructure.IPTools; using ZR.Model.Dto; using ZR.Model.System; using ZR.ServiceCore.Resources; namespace ZR.Admin.WebApi.Controllers { /// /// 公共模块 /// [Route("[controller]/[action]")] [ApiExplorerSettings(GroupName = "sys")] public class CommonController : BaseController { private OptionsSetting OptionsSetting; private NLog.Logger logger = NLog.LogManager.GetCurrentClassLogger(); private IWebHostEnvironment WebHostEnvironment; private ISysFileService SysFileService; private readonly IStringLocalizer _localizer; /// /// /// /// /// /// /// public CommonController( IStringLocalizer stringLocalizer, IOptions options, IWebHostEnvironment webHostEnvironment, ISysFileService fileService) { WebHostEnvironment = webHostEnvironment; SysFileService = fileService; OptionsSetting = options.Value; _localizer = stringLocalizer; } /// /// home /// /// [Route("/")] [HttpGet] [AllowAnonymous] public IActionResult Index() { var hello = _localizer["hello"].Value; return Ok($"{hello}看到这里页面说明你已经成功启动了本项目:)\n\n" + "如果觉得项目有用,打赏作者喝杯咖啡作为奖励\n☛☛http://www.izhaorui.cn/vip\n"); } /// /// 查询IP信息 /// /// [Route("/ip")] [HttpGet] [AllowAnonymous] public IActionResult IPInfo(string ip) { if (ip.IsEmpty()) return ToResponse(ResultCode.CUSTOM_ERROR, "IP异常"); var region = IpTool.GetRegion(ip); return SUCCESS(region); } /// /// 企业消息测试 /// /// 要发送的消息 /// 要发送的人@all所有,xxx单独发送对个人 /// [Route("/sendMsg")] [HttpGet] [Log(Title = "企业消息测试")] public IActionResult SendMsg(string msg, string toUser = "") { WxNoticeHelper.SendMsg("消息测试", msg, toUser, WxNoticeHelper.MsgType.markdown); return SUCCESS(msg); } #region 上传 /// /// 存储文件 /// /// 自定义文件名 /// /// 上传类型1、保存到本地 2、保存到阿里云 /// [HttpPost] [ActionPermissionFilter(Permission = "common")] public async Task UploadFile([FromForm] UploadDto uploadDto, IFormFile file, StoreType storeType = StoreType.LOCAL) { if (file == null) throw new CustomException(ResultCode.PARAM_ERROR, "上传文件不能为空"); SysFile sysfile = new(); IFormFile formFile = file; string fileExt = Path.GetExtension(formFile.FileName);//文件后缀 double fileSize = Math.Round(formFile.Length / 1024.0, 2);//文件大小KB if (OptionsSetting.Upload.NotAllowedExt.Contains(fileExt)) { return ToResponse(ResultCode.CUSTOM_ERROR, "上传失败,未经允许上传类型"); } if (uploadDto.FileNameType == 1) { uploadDto.FileName = Path.GetFileNameWithoutExtension(formFile.FileName); } else if (uploadDto.FileNameType == 3) { uploadDto.FileName = SysFileService.HashFileName(); } switch (storeType) { case StoreType.LOCAL: string savePath = Path.Combine(WebHostEnvironment.WebRootPath); if (uploadDto.FileDir.IsEmpty()) { uploadDto.FileDir = OptionsSetting.Upload.LocalSavePath; } sysfile = await SysFileService.SaveFileToLocal(savePath, uploadDto, HttpContext.GetName(), formFile); break; case StoreType.REMOTE: break; case StoreType.ALIYUN: int AlimaxContentLength = OptionsSetting.ALIYUN_OSS.MaxSize; if (OptionsSetting.ALIYUN_OSS.REGIONID.IsEmpty()) { return ToResponse(ResultCode.CUSTOM_ERROR, "配置文件缺失"); } if ((fileSize / 1024) > AlimaxContentLength) { return ToResponse(ResultCode.CUSTOM_ERROR, "上传文件过大,不能超过 " + AlimaxContentLength + " MB"); } sysfile = new(formFile.FileName, uploadDto.FileName, fileExt, fileSize + "kb", uploadDto.FileDir, HttpContext.GetName()) { StoreType = (int)StoreType.ALIYUN, FileType = formFile.ContentType, ClassifyType = uploadDto.ClassifyType, CategoryId = uploadDto.CategoryId, }; sysfile = await SysFileService.SaveFileToAliyun(sysfile, uploadDto, formFile); if (sysfile.Id <= 0) { return ToResponse(ApiResult.Error("阿里云连接失败")); } break; case StoreType.TENCENT: break; case StoreType.QINIU: break; default: break; } return SUCCESS(new { url = sysfile.AccessUrl, fileName = sysfile.FileName, fileId = sysfile.Id.ToString() }); } #endregion /// /// 下载文件 /// /// /// /// [HttpGet] [ActionPermissionFilter(Permission = "common")] [Log(Title = "下载文件", IsSaveResponseData = false)] public IActionResult DownloadFile(string? path, long fileId = 0) { var tempPath = path; if (fileId > 0) { var fileInfo = SysFileService.GetById(fileId); if (fileInfo != null) { tempPath = fileInfo.FileUrl; } } string fullPath = tempPath; //if (tempPath.StartsWith("/")) //{ // fullPath = Path.Combine(WebHostEnvironment.WebRootPath, tempPath.ReplaceFirst("/", "")); //} string fileName = Path.GetFileName(fullPath); return DownFile(fullPath, fileName); } /// /// 初始化种子数据 /// /// 是否清空数据 /// [HttpGet] [AllowAnonymous] [ActionPermissionFilter(Permission = "common")] [Log(BusinessType = BusinessType.INSERT, Title = "初始化数据")] public IActionResult InitSeedData(bool clean = false) { if (!WebHostEnvironment.IsDevelopment()) { return ToResponse(ResultCode.CUSTOM_ERROR, "导入数据失败,请在开发模式下初始化"); } var path = Path.Combine(WebHostEnvironment.WebRootPath, "data.xlsx"); SeedDataService seedDataService = new(); var result = seedDataService.InitSeedData(path, clean); Console.ForegroundColor = ConsoleColor.Red; foreach (var item in result) { Console.WriteLine(item); } Console.ForegroundColor = ConsoleColor.White; return SUCCESS(new { result }); } /// /// /// /// [HttpGet] [AllowAnonymous] [ActionPermissionFilter(Permission = "common")] [Log(BusinessType = BusinessType.INSERT, Title = "初始化数据")] public IActionResult UpdateSeedData() { if (!WebHostEnvironment.IsDevelopment()) { return ToResponse(ResultCode.CUSTOM_ERROR, "导入数据失败,请在开发模式下初始化"); } var path = Path.Combine(WebHostEnvironment.WebRootPath, "data.xlsx"); SeedDataService seedDataService = new(); var sysNotice = MiniExcel.Query(path, sheetName: "notice").ToList(); var result = seedDataService.InitNoticeData(sysNotice); var sysMenu = MiniExcel.Query(path, sheetName: "menu").Where(f => f.MenuId >= 1104).ToList(); var result5 = seedDataService.InitMenuData(sysMenu); return SUCCESS(new { result, result5 }); } } }