SysController.cs 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683
  1. using EasyCaching.Core;
  2. using Hotline.Application.Systems;
  3. using Hotline.Caching.Interfaces;
  4. using Hotline.CallCenter.Ivrs;
  5. using Hotline.CallCenter.Tels;
  6. using Hotline.Configurations;
  7. using Hotline.FlowEngine.WorkflowModules;
  8. using Hotline.Orders;
  9. using Hotline.Permissions;
  10. using Hotline.Realtimes;
  11. using Hotline.Repository.SqlSugar.Extensions;
  12. using Hotline.Settings;
  13. using Hotline.Settings.CommonOpinions;
  14. using Hotline.Share.Dtos;
  15. using Hotline.Share.Dtos.Dic;
  16. using Hotline.Share.Dtos.Menu;
  17. using Hotline.Share.Dtos.Settings;
  18. using Hotline.Share.Enums.Settings;
  19. using Hotline.Share.Requests;
  20. using Hotline.Share.Tools;
  21. using Hotline.Users;
  22. using Hotline.YbEnterprise.Sdk;
  23. using MapsterMapper;
  24. using Microsoft.AspNetCore.Authorization;
  25. using Microsoft.AspNetCore.Mvc;
  26. using Microsoft.Extensions.Options;
  27. using NPOI.SS.Formula.Functions;
  28. using SqlSugar;
  29. using StackExchange.Redis;
  30. using Wex.Sdk;
  31. using XF.Domain.Authentications;
  32. using XF.Domain.Cache;
  33. using XF.Domain.Exceptions;
  34. using XF.Domain.Repository;
  35. using XF.Utility.EnumExtensions;
  36. namespace Hotline.Api.Controllers
  37. {
  38. /// <summary>
  39. /// 系统管理相关接口
  40. /// </summary>
  41. public class SysController : BaseController
  42. {
  43. private readonly IMapper _mapper;
  44. private readonly IRepository<SystemSetting> _systemSettingsRepository;
  45. private readonly ISystemMenuRepository _systemMenuRepository;
  46. private readonly IRepository<SystemDicType> _sysDicTypeRepository;
  47. private readonly IRepository<SystemDicData> _sysDicDataRepository;
  48. private readonly ISystemAreaDomainService _systemAreaDomainService;
  49. private readonly IRepository<SystemArea> _systemAreaRepository;
  50. private readonly ISystemCommonOpinionDomainService _commonOpinionDomainService;
  51. private readonly IRepository<SystemCommonOpinion> _commonOpinionRepository;
  52. private readonly ISessionContext _sessionContext;
  53. private readonly ISystemDicDataCacheManager _systemDicDataCacheManager;
  54. private readonly IRepository<SystemLog> _systemLogRepository;
  55. private readonly ISystemMobilAreaApplication _systemMobilAreaApplication;
  56. private readonly IServiceScopeFactory _serviceScopeFactory;
  57. private readonly IRedisCachingProvider _redisCaching;
  58. private readonly IEasyCachingProvider _easyCaching;
  59. private readonly IOptionsSnapshot<AppConfiguration> _appOptions;
  60. /// <summary>
  61. /// 系统管理相关接口
  62. /// </summary>
  63. /// <param name="mapper"></param>
  64. /// <param name="systemSettingsRepository"></param>
  65. /// <param name="systemMenuRepository"></param>
  66. /// <param name="sysDicTypeRepository"></param>
  67. /// <param name="sysDicDataRepository"></param>
  68. /// <param name="systemAreaDomainService"></param>
  69. /// <param name="systemAreaRepository"></param>
  70. /// <param name="commonOpinionDomainService"></param>
  71. /// <param name="commonOpinionRepository"></param>
  72. /// <param name="sessionContext"></param>
  73. /// <param name="systemDicDataCacheManager"></param>
  74. /// <param name="systemLogRepository"></param>
  75. /// <param name="systemMobilAreaApplication"></param>
  76. public SysController(
  77. IMapper mapper,
  78. IRepository<SystemSetting> systemSettingsRepository,
  79. ISystemMenuRepository systemMenuRepository,
  80. IRepository<SystemDicType> sysDicTypeRepository,
  81. IRepository<SystemDicData> sysDicDataRepository,
  82. ISystemAreaDomainService systemAreaDomainService,
  83. IRepository<SystemArea> systemAreaRepository,
  84. ISystemCommonOpinionDomainService commonOpinionDomainService,
  85. IRepository<SystemCommonOpinion> commonOpinionRepository,
  86. ISessionContext sessionContext,
  87. ISystemDicDataCacheManager systemDicDataCacheManager,
  88. IRepository<SystemLog> systemLogRepository,
  89. ISystemMobilAreaApplication systemMobilAreaApplication,
  90. IServiceScopeFactory serviceScopeFactory,
  91. IRedisCachingProvider redisCaching,
  92. IEasyCachingProvider easyCaching
  93. ,
  94. IOptionsSnapshot<AppConfiguration> appOptions)
  95. {
  96. _mapper = mapper;
  97. _systemSettingsRepository = systemSettingsRepository;
  98. _systemMenuRepository = systemMenuRepository;
  99. _sysDicTypeRepository = sysDicTypeRepository;
  100. _sysDicDataRepository = sysDicDataRepository;
  101. _systemAreaDomainService = systemAreaDomainService;
  102. _systemAreaRepository = systemAreaRepository;
  103. _commonOpinionDomainService = commonOpinionDomainService;
  104. _commonOpinionRepository = commonOpinionRepository;
  105. _sessionContext = sessionContext;
  106. _systemDicDataCacheManager = systemDicDataCacheManager;
  107. _systemLogRepository = systemLogRepository;
  108. _systemMobilAreaApplication = systemMobilAreaApplication;
  109. _serviceScopeFactory = serviceScopeFactory;
  110. _redisCaching = redisCaching;
  111. _easyCaching = easyCaching;
  112. _appOptions = appOptions;
  113. }
  114. #region 菜单管理
  115. /// <summary>
  116. /// 获取菜单
  117. /// </summary>
  118. /// <returns></returns>
  119. //[Permission(EPermission.GetMenuJson)]
  120. [AllowAnonymous]
  121. [HttpGet("getmenujson")]
  122. public async Task<IReadOnlyList<SystemMenu>> GetMenuJson()
  123. {
  124. //获取菜单树形
  125. return await _systemMenuRepository.GetSystemMenus();
  126. }
  127. /// <summary>
  128. /// 新增菜单
  129. /// </summary>
  130. /// <param name="dto"></param>
  131. /// <returns></returns>
  132. [Permission(EPermission.AddMenu)]
  133. [HttpPost("add-menu")]
  134. public async Task AddMenu([FromBody] AddMenuDto dto)
  135. {
  136. var menu = _mapper.Map<SystemMenu>(dto);
  137. await _systemMenuRepository.AddAsync(menu, HttpContext.RequestAborted);
  138. }
  139. /// <summary>
  140. /// 修改菜单
  141. /// </summary>
  142. /// <param name="dto"></param>
  143. /// <returns></returns>
  144. [Permission(EPermission.UpdateMenu)]
  145. [HttpPost("update-menu")]
  146. public async Task UpdateMenu([FromBody] UpdateMenuDto dto)
  147. {
  148. var menu = await _systemMenuRepository.GetAsync(dto.Id, HttpContext.RequestAborted);
  149. if (menu is null)
  150. throw UserFriendlyException.SameMessage("无效菜单");
  151. _mapper.Map(dto, menu);
  152. await _systemMenuRepository.UpdateAsync(menu, HttpContext.RequestAborted);
  153. }
  154. /// <summary>
  155. /// 删除菜单
  156. /// </summary>
  157. /// <param name="id"></param>
  158. /// <returns></returns>
  159. [Permission(EPermission.RemoveMenu)]
  160. [HttpDelete("removemenu/{id}")]
  161. public async Task RemoveMenu(string id)
  162. {
  163. var menu = await _systemMenuRepository.GetAsync(id, HttpContext.RequestAborted);
  164. if (menu is null)
  165. throw UserFriendlyException.SameMessage("无效菜单");
  166. //检查是否存在下级菜单
  167. var ishavemenu = await _systemMenuRepository.AnyAsync(x => x.ParentId == id);
  168. if (ishavemenu)
  169. throw UserFriendlyException.SameMessage("存在下级菜单,暂时不能删除");
  170. //检查是否存在按钮
  171. //var ishavebutton = await _systemButtonRepository.AnyAsync(x => x.MenuId == id);
  172. //if (ishavebutton)
  173. // throw UserFriendlyException.SameMessage("存在按钮权限,暂时不能删除");
  174. await _systemMenuRepository.RemoveAsync(id, false, HttpContext.RequestAborted);
  175. }
  176. /// <summary>
  177. /// 获取菜单对象
  178. /// </summary>
  179. /// <param name="id"></param>
  180. /// <returns></returns>
  181. [HttpGet("menu/{id}")]
  182. public async Task<SystemMenu> GetMenu(string id)
  183. {
  184. var menu = await _systemMenuRepository.GetAsync(id, HttpContext.RequestAborted);
  185. if (menu is null)
  186. throw UserFriendlyException.SameMessage("无效菜单");
  187. return menu;
  188. }
  189. #region 按钮管理
  190. ///// <summary>
  191. ///// 通过菜单ID获取按钮列表
  192. ///// </summary>
  193. ///// <param name="menuid"></param>
  194. ///// <returns></returns>
  195. //[Permission(EPermission.GetButtonByMenu)]
  196. //[HttpGet("getbuttonmenu")]
  197. //public async Task<IReadOnlyList<SystemButton>> GetButtonByMenu(string menuid)
  198. //{
  199. // return await _systemButtonRepository.QueryAsync(x => x.MenuId == menuid);
  200. //}
  201. ///// <summary>
  202. ///// 新增按钮
  203. ///// </summary>
  204. ///// <param name="dto"></param>
  205. ///// <returns></returns>
  206. //[Permission(EPermission.AddButton)]
  207. //[HttpPost("add-button")]
  208. //public async Task AddButton([FromBody] AddButtonDto dto)
  209. //{
  210. // var button = _mapper.Map<SystemButton>(dto);
  211. // await _systemButtonRepository.AddAsync(button);
  212. //}
  213. ///// <summary>
  214. ///// 编辑按钮
  215. ///// </summary>
  216. ///// <param name="dto"></param>
  217. ///// <returns></returns>
  218. //[Permission(EPermission.UpdateButton)]
  219. //[HttpPost("update-button")]
  220. //public async Task UpdateButton([FromBody] UpdateButtonDto dto)
  221. //{
  222. // var button = await _systemButtonRepository.GetAsync(dto.Id, HttpContext.RequestAborted);
  223. // if (button is null)
  224. // throw UserFriendlyException.SameMessage("无效按钮");
  225. // _mapper.Map(dto, button);
  226. // await _systemButtonRepository.UpdateAsync(button);
  227. //}
  228. ///// <summary>
  229. ///// 删除按钮
  230. ///// </summary>
  231. ///// <param name="id"></param>
  232. ///// <returns></returns>
  233. //[Permission(EPermission.RemoveButton)]
  234. //[HttpDelete("removebutton/{id}")]
  235. //public async Task RemoveButton(string id)
  236. //{
  237. // var button = await _systemButtonRepository.GetAsync(id, HttpContext.RequestAborted);
  238. // if (button is null)
  239. // throw UserFriendlyException.SameMessage("无效按钮");
  240. // await _systemButtonRepository.RemoveAsync(id, false, HttpContext.RequestAborted);
  241. //}
  242. ///// <summary>
  243. ///// 获取按钮对象
  244. ///// </summary>
  245. ///// <param name="id"></param>
  246. ///// <returns></returns>
  247. //[Permission(EPermission.GetButton)]
  248. //[HttpGet("button/{id}")]
  249. //public async Task<SystemButton> GetButton(string id)
  250. //{
  251. // var button = await _systemButtonRepository.GetAsync(id, HttpContext.RequestAborted);
  252. // if (button is null)
  253. // throw UserFriendlyException.SameMessage("无效按钮");
  254. // return button;
  255. //}
  256. #endregion
  257. #endregion
  258. #region 字典管理
  259. /// <summary>
  260. /// 获取字典类型列表
  261. /// </summary>
  262. /// <returns></returns>
  263. [Permission(EPermission.GetSysDicType)]
  264. [HttpPost("dictype-list")]
  265. public async Task<List<SystemDicType>> GetSysDicType()
  266. {
  267. return await _sysDicTypeRepository.Queryable().ToListAsync();
  268. }
  269. /// <summary>
  270. /// 根据字典类型ID获取字典列表
  271. /// </summary>
  272. /// <param name="dto"></param>
  273. /// <returns></returns>
  274. [Permission(EPermission.GetSysDicData)]
  275. [HttpGet("dictdata-type")]
  276. public async Task<List<SystemDicData>> GetSysDicData([FromQuery] GetSysDicDataDto dto)
  277. {
  278. return await _sysDicDataRepository.Queryable().Where(x => x.DicTypeId == dto.typeid).OrderBy(x => x.Sort)/*.WhereIF(!string.IsNullOrEmpty(dto.datavalue),x=>x.DicDataValue.Contains(dto.datavalue))*/.ToTreeAsync(x => x.Children, x => x.ParentId, "");
  279. //return await _sysDicDataRepository.Queryable().Where(x => x.DicTypeId == dto.typeid).WhereIF(!string.IsNullOrEmpty(dto.datavalue), x => x.DicDataValue.Contains(dto.datavalue)).WhereIF(!string.IsNullOrEmpty(dto.ParentId), x => x.ParentId == dto.ParentId).ToListAsync();
  280. }
  281. /// <summary>
  282. /// 根据字典类型Code获取字典列表
  283. /// </summary>
  284. /// <param name="code"></param>
  285. /// <returns></returns>
  286. [HttpGet("dictdata-code/{code}")]
  287. public async Task<List<SystemDicData>> GetSysDicDataByCode(string code)
  288. {
  289. return await _sysDicDataRepository.Queryable().Where(x => x.DicTypeCode == code).OrderBy(x => x.Sort).ToListAsync();
  290. }
  291. /// <summary>
  292. /// 获取字典对象
  293. /// </summary>
  294. /// <param name="id"></param>
  295. /// <returns></returns>
  296. [Permission(EPermission.SysDicDataModel)]
  297. [HttpGet("dicdata/{id}")]
  298. public async Task<SystemDicData> SysDicDataModel(string id)
  299. {
  300. var dicData = await _sysDicDataRepository.GetAsync(id, HttpContext.RequestAborted);
  301. if (dicData is null)
  302. throw UserFriendlyException.SameMessage("无效数据");
  303. return dicData;
  304. }
  305. /// <summary>
  306. /// 新增字典数据
  307. /// </summary>
  308. /// <param name="dto"></param>
  309. /// <returns></returns>
  310. [Permission(EPermission.AddDicData)]
  311. [HttpPost("add-dicdata")]
  312. public async Task AddDicData([FromBody] AddDicDataDto dto)
  313. {
  314. var dicType = await _sysDicTypeRepository.GetAsync(dto.DicTypeId, HttpContext.RequestAborted);
  315. if (dicType is null)
  316. throw UserFriendlyException.SameMessage("无效字典类型");
  317. var dicData = _mapper.Map<SystemDicData>(dto);
  318. dicData.DicTypeCode = dicType.DicTypeCode;
  319. dicData.IsShow = true;
  320. _systemDicDataCacheManager.RemoveSysDicDataCache(dicType.DicTypeCode);
  321. await _sysDicDataRepository.AddAsync(dicData);
  322. }
  323. /// <summary>
  324. /// 修改字典数据
  325. /// </summary>
  326. /// <param name="dto"></param>
  327. /// <returns></returns>
  328. [Permission(EPermission.UpdateDicData)]
  329. [HttpPost("update-dicdata")]
  330. public async Task UpdateDicData([FromBody] UpdateDicDataDto dto)
  331. {
  332. var dicData = await _sysDicDataRepository.GetAsync(dto.Id, HttpContext.RequestAborted);
  333. if (dicData is null)
  334. throw UserFriendlyException.SameMessage("无效字典数据");
  335. var dicType = await _sysDicTypeRepository.GetAsync(dto.DicTypeId, HttpContext.RequestAborted);
  336. if (dicType is null)
  337. throw UserFriendlyException.SameMessage("无效字典类型");
  338. _mapper.Map(dto, dicData);
  339. dicData.DicTypeCode = dicType.DicTypeCode;
  340. _systemDicDataCacheManager.RemoveSysDicDataCache(dicType.DicTypeCode);
  341. await _sysDicDataRepository.UpdateAsync(dicData, HttpContext.RequestAborted);
  342. }
  343. #endregion
  344. #region 行政区划
  345. /// <summary>
  346. /// 获取省市区树形
  347. /// </summary>
  348. /// <returns></returns>
  349. [HttpGet("area/tree")]
  350. public async Task<List<SystemArea>> GetAreaTree()
  351. {
  352. return await _systemAreaDomainService.GetAreaTree(_appOptions.Value.IsZiGong ? 6 : 0);
  353. }
  354. /// <summary>
  355. /// 新增省市区
  356. /// </summary>
  357. /// <param name="dto"></param>
  358. /// <returns></returns>
  359. [Permission(EPermission.AddArea)]
  360. [HttpPost("area")]
  361. public async Task AddArea([FromBody] AddAreaDto dto)
  362. {
  363. var model = _mapper.Map<SystemArea>(dto);
  364. if (string.IsNullOrEmpty(model.ParentId) || model.ParentId.Length > 8)
  365. {
  366. throw UserFriendlyException.SameMessage("只允许添加乡镇、街道数据,请选择区县");
  367. }
  368. if (model.ParentId.Substring(6, 2) == "00")
  369. {
  370. throw UserFriendlyException.SameMessage("只允许添加乡镇、街道数据,请选择区县");
  371. }
  372. //验证重复
  373. var area = await _systemAreaRepository.Queryable(includeDeleted: true).FirstAsync(x => x.ParentId == dto.ParentId && x.AreaName == dto.AreaName);
  374. if (area != null)
  375. {
  376. if (area.IsDeleted)
  377. {
  378. area.IsDeleted = false;
  379. await _systemAreaRepository.UpdateAsync(area, HttpContext.RequestAborted);
  380. throw UserFriendlyException.SameMessage("同目录下已存在被删除的相同数据,已重新启用");
  381. }
  382. else
  383. {
  384. throw UserFriendlyException.SameMessage("同目录下已存在相同数据,不能重复添加");
  385. }
  386. }
  387. //生成新Code
  388. model.Id = await _systemAreaDomainService.GenerateNewAreaCodeAsync(dto.ParentId, HttpContext.RequestAborted);
  389. model.IsCanModify = true;
  390. await _systemAreaDomainService.AddArea(model, HttpContext.RequestAborted);
  391. }
  392. /// <summary>
  393. /// 修改省市区
  394. /// </summary>
  395. /// <param name="dto"></param>
  396. /// <returns></returns>
  397. [Permission(EPermission.ModifyArea)]
  398. [HttpPut("area")]
  399. public async Task ModifyArea([FromBody] ModifyAreaDto dto)
  400. {
  401. var model = await _systemAreaDomainService.GetArea(dto.Id, HttpContext.RequestAborted);
  402. if (model is null)
  403. throw UserFriendlyException.SameMessage("未知数据,请刷新页面");
  404. if (!model.IsCanModify)
  405. throw UserFriendlyException.SameMessage("系统数据,不能修改");
  406. _mapper.Map(dto, model); //_mapper.Map<SystemArea>(dto);
  407. //验证重复
  408. var area = await _systemAreaRepository.Queryable(includeDeleted: true).Where(x => x.ParentId == dto.ParentId && x.AreaName == dto.AreaName).ToListAsync();
  409. if (area.Count > 1)
  410. {
  411. throw UserFriendlyException.SameMessage("同目录下已存在相同数据,不能修改");
  412. }
  413. await _systemAreaDomainService.ModifyArea(model, HttpContext.RequestAborted);
  414. }
  415. /// <summary>
  416. /// 删除省市区(逻辑)
  417. /// </summary>
  418. /// <param name="id"></param>
  419. /// <returns></returns>
  420. [Permission(EPermission.DelArea)]
  421. [HttpDelete("area/{id}")]
  422. public async Task DelArea(string id)
  423. {
  424. var model = await _systemAreaDomainService.GetArea(id, HttpContext.RequestAborted);
  425. if (model is null)
  426. throw UserFriendlyException.SameMessage("未知数据,请刷新页面");
  427. if (!model.IsCanModify)
  428. throw UserFriendlyException.SameMessage("系统数据不能删除");
  429. await _systemAreaDomainService.DelArea(id, HttpContext.RequestAborted);
  430. }
  431. /// <summary>
  432. /// 获取区域
  433. /// </summary>
  434. /// <param name="id"></param>
  435. /// <returns></returns>
  436. [Permission(EPermission.GetArea)]
  437. [HttpGet("area/{id}")]
  438. public async Task<SystemArea?> GetArea(string id)
  439. {
  440. var model = await _systemAreaDomainService.GetArea(id, HttpContext.RequestAborted);
  441. if (model is null)
  442. throw UserFriendlyException.SameMessage("未知数据,请刷新页面");
  443. return model;
  444. }
  445. #endregion
  446. #region 常用意见
  447. #region 个人
  448. /// <summary>
  449. /// 获取常用意见
  450. /// </summary>
  451. /// <returns></returns>
  452. [HttpGet("common-list")]
  453. public async Task<IReadOnlyList<SystemCommonOpinion>> GetCommon([FromQuery] ECommonType commonType, bool isOpen)
  454. {
  455. return await _commonOpinionRepository.Queryable().Where(x => x.CommonType == commonType && x.IsOpen == isOpen)
  456. .WhereIF(isOpen == false, x => x.CreatorId == _sessionContext.RequiredUserId).ToListAsync();
  457. }
  458. /// <summary>
  459. /// 新增常用意见
  460. /// </summary>
  461. /// <param name="dto"></param>
  462. /// <returns></returns>
  463. [HttpPost("add-common")]
  464. public async Task AddCommon([FromBody] AddCommonDto dto)
  465. {
  466. var entity = _mapper.Map<SystemCommonOpinion>(dto);
  467. await _commonOpinionDomainService.AddCommonOpinion(entity, HttpContext.RequestAborted);
  468. }
  469. /// <summary>
  470. /// 批量删除常用意见
  471. /// </summary>
  472. /// <param name="dto"></param>
  473. /// <returns></returns>
  474. [HttpPost("del-common")]
  475. public async Task DelCommon([FromBody] DelCommonDto dto)
  476. {
  477. await _commonOpinionDomainService.DelCommonOpinion(dto.Ids, HttpContext.RequestAborted);
  478. }
  479. /// <summary>
  480. /// 常用意见页面基础信息
  481. /// </summary>
  482. /// <returns></returns>
  483. [HttpGet("common-basepage")]
  484. public async Task<object> CommonBasePage()
  485. {
  486. var rsp = new
  487. {
  488. CommonType = EnumExts.GetDescriptions<ECommonType>(),
  489. };
  490. return rsp;
  491. }
  492. #endregion
  493. #region 公开
  494. /// <summary>
  495. /// 查询公开常用意见
  496. /// </summary>
  497. /// <returns></returns>
  498. [Permission(EPermission.QueryOpenCommonOpinionList)]
  499. [HttpGet("open-common")]
  500. public async Task<PagedDto<SystemCommonOpinion>> QueryOpenCommonOpinionList([FromQuery] QueryCommonDto dto)
  501. {
  502. var (total, items) = await _commonOpinionRepository.Queryable()
  503. .WhereIF(dto.IsOpen != null, x => x.IsOpen == dto.IsOpen)
  504. .WhereIF(!string.IsNullOrEmpty(dto.UserName), x => x.CreatorName.Contains(dto.UserName))
  505. .WhereIF(dto.CommonType != null, x => x.CommonType == dto.CommonType)
  506. .ToPagedListAsync(dto.PageIndex, dto.PageSize, HttpContext.RequestAborted);
  507. return new PagedDto<SystemCommonOpinion>(total, items);
  508. }
  509. /// <summary>
  510. /// 修改公开常用意见
  511. /// </summary>
  512. /// <param name="dto"></param>
  513. /// <returns></returns>
  514. [Permission(EPermission.CommonModify)]
  515. [HttpPost("common-modify")]
  516. public async Task CommonModify([FromBody] CommonModifyDto dto)
  517. {
  518. var model = await _commonOpinionRepository.GetAsync(dto.Id, HttpContext.RequestAborted);
  519. if (model is null)
  520. throw UserFriendlyException.SameMessage("无效数据");
  521. _mapper.Map(dto, model);
  522. await _commonOpinionRepository.UpdateAsync(model, HttpContext.RequestAborted);
  523. }
  524. #endregion
  525. #endregion
  526. #region 日志
  527. /// <summary>
  528. /// 获取日志列表
  529. /// </summary>
  530. /// <param name="dto"></param>
  531. /// <returns></returns>
  532. [HttpGet("log_list")]
  533. public async Task<PagedDto<SystemLogDto>> List([FromQuery] SysLogPagedKeywordRequest dto)
  534. {
  535. var (total, items) = await _systemLogRepository.Queryable()
  536. .WhereIF(dto.IsAll.HasValue && !dto.IsAll.Value, x => !string.IsNullOrEmpty(x.Name))
  537. .WhereIF(!string.IsNullOrEmpty(dto.Name), x => x.Name.Contains(dto.Name))
  538. .WhereIF(!string.IsNullOrEmpty(dto.CreatorName), x => x.CreatorName.Contains(dto.CreatorName))
  539. .WhereIF(!string.IsNullOrEmpty(dto.ExecuteUrl), x => x.ExecuteUrl.Contains(dto.ExecuteUrl))
  540. .WhereIF(!string.IsNullOrEmpty(dto.ExecuteParam),
  541. x => SqlFunc.JsonLike(x.ExecuteParam, dto.ExecuteParam))
  542. .WhereIF(dto.StartTime.HasValue && dto.EndTime.HasValue,
  543. x => x.CreationTime >= dto.StartTime && x.CreationTime <= dto.EndTime)
  544. //.WhereIF(!string.IsNullOrEmpty(dto.Keyword), x => x.Name.Contains(dto.Keyword!) || x.CreatorName.Contains(dto.Keyword!))
  545. .OrderByDescending(x => x.CreationTime)
  546. .ToPagedListAsync(dto.PageIndex, dto.PageSize, HttpContext.RequestAborted);
  547. return new PagedDto<SystemLogDto>(total, _mapper.Map<IReadOnlyList<SystemLogDto>>(items));
  548. }
  549. /// <summary>
  550. /// 获取日志实体
  551. /// </summary>
  552. /// <param name="id"></param>
  553. /// <returns></returns>
  554. [HttpGet("log/{id}")]
  555. public async Task<SystemLogDto> ItemEntity(string id)
  556. {
  557. var log = await _systemLogRepository.Queryable()
  558. .FirstAsync(x => x.Id == id);
  559. return _mapper.Map<SystemLogDto>(log);
  560. }
  561. [HttpPost("log")]
  562. public async Task<string> LogAdd([FromBody] SystemLogDto dto)
  563. {
  564. var log = _mapper.Map<SystemLog>(dto);
  565. return await _systemLogRepository.AddAsync(log, HttpContext.RequestAborted);
  566. }
  567. #endregion
  568. /// <summary>
  569. /// 验证电话外呼是否需要加0
  570. /// </summary>
  571. /// <param name="mobile"></param>
  572. /// <returns></returns>
  573. [HttpGet("vaild_mobile/{mobile}")]
  574. public async Task<string> VaildMobile(string mobile)
  575. {
  576. return await _systemMobilAreaApplication.VaildMobile(mobile);
  577. }
  578. /// <summary>
  579. /// 删除缓存
  580. /// </summary>
  581. /// <param name="dto"></param>
  582. /// <returns></returns>
  583. [HttpPut("cache/remove")]
  584. public async Task<IActionResult> ClearCache([FromBody] CleanCacheInDto dto)
  585. {
  586. foreach (var key in dto.Keys)
  587. {
  588. await _easyCaching.RemoveAsync(key, HttpContext.RequestAborted);
  589. await _redisCaching.KeyDelAsync(key);
  590. }
  591. return Ok();
  592. }
  593. /// <summary>
  594. /// 获取所有缓存的Key
  595. /// </summary>
  596. /// <param name="cacheKey">不传默认: Hotline:*</param>
  597. /// <returns></returns>
  598. [HttpGet("cache")]
  599. public async Task<List<string>> GetCache(string cacheKey = "Hotline:*")
  600. {
  601. return await _redisCaching.SearchKeysAsync(cacheKey);
  602. }
  603. /// <summary>
  604. /// 获取缓存
  605. /// </summary>
  606. /// <param name="key"></param>
  607. /// <returns></returns>
  608. [HttpGet("cache/{key}")]
  609. public async Task<List<string>> GetCacheByKey(string key)
  610. {
  611. var cacheResult = new List<string>();
  612. var result = await _easyCaching.GetAsync<object>(key,cancellationToken: HttpContext.RequestAborted);
  613. if (result != null)
  614. {
  615. cacheResult.Add(result.ToJson());
  616. }
  617. var stringResult = await _redisCaching.StringGetAsync(key);
  618. if (stringResult != null)
  619. {
  620. cacheResult.Add(stringResult);
  621. }
  622. return cacheResult;
  623. }
  624. }
  625. }