SysController.cs 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664
  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. [AllowAnonymous]
  120. [HttpGet("getmenujson")]
  121. public async Task<IReadOnlyList<SystemMenu>> GetMenuJson()
  122. {
  123. //获取菜单树形
  124. return await _systemMenuRepository.GetSystemMenus();
  125. }
  126. /// <summary>
  127. /// 新增菜单
  128. /// </summary>
  129. /// <param name="dto"></param>
  130. /// <returns></returns>
  131. [HttpPost("add-menu")]
  132. public async Task AddMenu([FromBody] AddMenuDto dto)
  133. {
  134. var menu = _mapper.Map<SystemMenu>(dto);
  135. await _systemMenuRepository.AddAsync(menu, HttpContext.RequestAborted);
  136. }
  137. /// <summary>
  138. /// 修改菜单
  139. /// </summary>
  140. /// <param name="dto"></param>
  141. /// <returns></returns>
  142. [HttpPost("update-menu")]
  143. public async Task UpdateMenu([FromBody] UpdateMenuDto dto)
  144. {
  145. var menu = await _systemMenuRepository.GetAsync(dto.Id, HttpContext.RequestAborted);
  146. if (menu is null)
  147. throw UserFriendlyException.SameMessage("无效菜单");
  148. _mapper.Map(dto, menu);
  149. await _systemMenuRepository.UpdateAsync(menu, HttpContext.RequestAborted);
  150. }
  151. /// <summary>
  152. /// 删除菜单
  153. /// </summary>
  154. /// <param name="id"></param>
  155. /// <returns></returns>
  156. [HttpDelete("removemenu/{id}")]
  157. public async Task RemoveMenu(string id)
  158. {
  159. var menu = await _systemMenuRepository.GetAsync(id, HttpContext.RequestAborted);
  160. if (menu is null)
  161. throw UserFriendlyException.SameMessage("无效菜单");
  162. //检查是否存在下级菜单
  163. var ishavemenu = await _systemMenuRepository.AnyAsync(x => x.ParentId == id);
  164. if (ishavemenu)
  165. throw UserFriendlyException.SameMessage("存在下级菜单,暂时不能删除");
  166. //检查是否存在按钮
  167. //var ishavebutton = await _systemButtonRepository.AnyAsync(x => x.MenuId == id);
  168. //if (ishavebutton)
  169. // throw UserFriendlyException.SameMessage("存在按钮权限,暂时不能删除");
  170. await _systemMenuRepository.RemoveAsync(id, false, HttpContext.RequestAborted);
  171. }
  172. /// <summary>
  173. /// 获取菜单对象
  174. /// </summary>
  175. /// <param name="id"></param>
  176. /// <returns></returns>
  177. [HttpGet("menu/{id}")]
  178. public async Task<SystemMenu> GetMenu(string id)
  179. {
  180. var menu = await _systemMenuRepository.GetAsync(id, HttpContext.RequestAborted);
  181. if (menu is null)
  182. throw UserFriendlyException.SameMessage("无效菜单");
  183. return menu;
  184. }
  185. #region 按钮管理
  186. ///// <summary>
  187. ///// 通过菜单ID获取按钮列表
  188. ///// </summary>
  189. ///// <param name="menuid"></param>
  190. ///// <returns></returns>
  191. //[HttpGet("getbuttonmenu")]
  192. //public async Task<IReadOnlyList<SystemButton>> GetButtonByMenu(string menuid)
  193. //{
  194. // return await _systemButtonRepository.QueryAsync(x => x.MenuId == menuid);
  195. //}
  196. ///// <summary>
  197. ///// 新增按钮
  198. ///// </summary>
  199. ///// <param name="dto"></param>
  200. ///// <returns></returns>
  201. //[HttpPost("add-button")]
  202. //public async Task AddButton([FromBody] AddButtonDto dto)
  203. //{
  204. // var button = _mapper.Map<SystemButton>(dto);
  205. // await _systemButtonRepository.AddAsync(button);
  206. //}
  207. ///// <summary>
  208. ///// 编辑按钮
  209. ///// </summary>
  210. ///// <param name="dto"></param>
  211. ///// <returns></returns>
  212. //[HttpPost("update-button")]
  213. //public async Task UpdateButton([FromBody] UpdateButtonDto dto)
  214. //{
  215. // var button = await _systemButtonRepository.GetAsync(dto.Id, HttpContext.RequestAborted);
  216. // if (button is null)
  217. // throw UserFriendlyException.SameMessage("无效按钮");
  218. // _mapper.Map(dto, button);
  219. // await _systemButtonRepository.UpdateAsync(button);
  220. //}
  221. ///// <summary>
  222. ///// 删除按钮
  223. ///// </summary>
  224. ///// <param name="id"></param>
  225. ///// <returns></returns>
  226. //[HttpDelete("removebutton/{id}")]
  227. //public async Task RemoveButton(string id)
  228. //{
  229. // var button = await _systemButtonRepository.GetAsync(id, HttpContext.RequestAborted);
  230. // if (button is null)
  231. // throw UserFriendlyException.SameMessage("无效按钮");
  232. // await _systemButtonRepository.RemoveAsync(id, false, HttpContext.RequestAborted);
  233. //}
  234. ///// <summary>
  235. ///// 获取按钮对象
  236. ///// </summary>
  237. ///// <param name="id"></param>
  238. ///// <returns></returns>
  239. //[HttpGet("button/{id}")]
  240. //public async Task<SystemButton> GetButton(string id)
  241. //{
  242. // var button = await _systemButtonRepository.GetAsync(id, HttpContext.RequestAborted);
  243. // if (button is null)
  244. // throw UserFriendlyException.SameMessage("无效按钮");
  245. // return button;
  246. //}
  247. #endregion
  248. #endregion
  249. #region 字典管理
  250. /// <summary>
  251. /// 获取字典类型列表
  252. /// </summary>
  253. /// <returns></returns>
  254. [HttpPost("dictype-list")]
  255. public async Task<List<SystemDicType>> GetSysDicType()
  256. {
  257. return await _sysDicTypeRepository.Queryable().ToListAsync();
  258. }
  259. /// <summary>
  260. /// 根据字典类型ID获取字典列表
  261. /// </summary>
  262. /// <param name="dto"></param>
  263. /// <returns></returns>
  264. [HttpGet("dictdata-type")]
  265. public async Task<List<SystemDicData>> GetSysDicData([FromQuery] GetSysDicDataDto dto)
  266. {
  267. 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, "");
  268. //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();
  269. }
  270. /// <summary>
  271. /// 根据字典类型Code获取字典列表
  272. /// </summary>
  273. /// <param name="code"></param>
  274. /// <returns></returns>
  275. [HttpGet("dictdata-code/{code}")]
  276. public async Task<List<SystemDicData>> GetSysDicDataByCode(string code)
  277. {
  278. return await _sysDicDataRepository.Queryable().Where(x => x.DicTypeCode == code).OrderBy(x => x.Sort).ToListAsync();
  279. }
  280. /// <summary>
  281. /// 获取字典对象
  282. /// </summary>
  283. /// <param name="id"></param>
  284. /// <returns></returns>
  285. [HttpGet("dicdata/{id}")]
  286. public async Task<SystemDicData> SysDicDataModel(string id)
  287. {
  288. var dicData = await _sysDicDataRepository.GetAsync(id, HttpContext.RequestAborted);
  289. if (dicData is null)
  290. throw UserFriendlyException.SameMessage("无效数据");
  291. return dicData;
  292. }
  293. /// <summary>
  294. /// 新增字典数据
  295. /// </summary>
  296. /// <param name="dto"></param>
  297. /// <returns></returns>
  298. [HttpPost("add-dicdata")]
  299. public async Task AddDicData([FromBody] AddDicDataDto dto)
  300. {
  301. var dicType = await _sysDicTypeRepository.GetAsync(dto.DicTypeId, HttpContext.RequestAborted);
  302. if (dicType is null)
  303. throw UserFriendlyException.SameMessage("无效字典类型");
  304. var dicData = _mapper.Map<SystemDicData>(dto);
  305. dicData.DicTypeCode = dicType.DicTypeCode;
  306. dicData.IsShow = true;
  307. _systemDicDataCacheManager.RemoveSysDicDataCache(dicType.DicTypeCode);
  308. await _sysDicDataRepository.AddAsync(dicData);
  309. }
  310. /// <summary>
  311. /// 修改字典数据
  312. /// </summary>
  313. /// <param name="dto"></param>
  314. /// <returns></returns>
  315. [HttpPost("update-dicdata")]
  316. public async Task UpdateDicData([FromBody] UpdateDicDataDto dto)
  317. {
  318. var dicData = await _sysDicDataRepository.GetAsync(dto.Id, HttpContext.RequestAborted);
  319. if (dicData is null)
  320. throw UserFriendlyException.SameMessage("无效字典数据");
  321. var dicType = await _sysDicTypeRepository.GetAsync(dto.DicTypeId, HttpContext.RequestAborted);
  322. if (dicType is null)
  323. throw UserFriendlyException.SameMessage("无效字典类型");
  324. _mapper.Map(dto, dicData);
  325. dicData.DicTypeCode = dicType.DicTypeCode;
  326. _systemDicDataCacheManager.RemoveSysDicDataCache(dicType.DicTypeCode);
  327. await _sysDicDataRepository.UpdateAsync(dicData, HttpContext.RequestAborted);
  328. }
  329. #endregion
  330. #region 行政区划
  331. /// <summary>
  332. /// 获取省市区树形
  333. /// </summary>
  334. /// <returns></returns>
  335. [HttpGet("area/tree")]
  336. public async Task<List<SystemArea>> GetAreaTree()
  337. {
  338. return await _systemAreaDomainService.GetAreaTree(_appOptions.Value.IsZiGong ? 6 : 0);
  339. }
  340. /// <summary>
  341. /// 新增省市区
  342. /// </summary>
  343. /// <param name="dto"></param>
  344. /// <returns></returns>
  345. [HttpPost("area")]
  346. public async Task AddArea([FromBody] AddAreaDto dto)
  347. {
  348. var model = _mapper.Map<SystemArea>(dto);
  349. if (string.IsNullOrEmpty(model.ParentId) || model.ParentId.Length > 8)
  350. {
  351. throw UserFriendlyException.SameMessage("只允许添加乡镇、街道数据,请选择区县");
  352. }
  353. if (model.ParentId.Substring(6, 2) == "00")
  354. {
  355. throw UserFriendlyException.SameMessage("只允许添加乡镇、街道数据,请选择区县");
  356. }
  357. //验证重复
  358. var area = await _systemAreaRepository.Queryable(includeDeleted: true).FirstAsync(x => x.ParentId == dto.ParentId && x.AreaName == dto.AreaName);
  359. if (area != null)
  360. {
  361. if (area.IsDeleted)
  362. {
  363. area.IsDeleted = false;
  364. await _systemAreaRepository.UpdateAsync(area, HttpContext.RequestAborted);
  365. throw UserFriendlyException.SameMessage("同目录下已存在被删除的相同数据,已重新启用");
  366. }
  367. else
  368. {
  369. throw UserFriendlyException.SameMessage("同目录下已存在相同数据,不能重复添加");
  370. }
  371. }
  372. //生成新Code
  373. model.Id = await _systemAreaDomainService.GenerateNewAreaCodeAsync(dto.ParentId, HttpContext.RequestAborted);
  374. model.IsCanModify = true;
  375. await _systemAreaDomainService.AddArea(model, HttpContext.RequestAborted);
  376. }
  377. /// <summary>
  378. /// 修改省市区
  379. /// </summary>
  380. /// <param name="dto"></param>
  381. /// <returns></returns>
  382. [HttpPut("area")]
  383. public async Task ModifyArea([FromBody] ModifyAreaDto dto)
  384. {
  385. var model = await _systemAreaDomainService.GetArea(dto.Id, HttpContext.RequestAborted);
  386. if (model is null)
  387. throw UserFriendlyException.SameMessage("未知数据,请刷新页面");
  388. if (!model.IsCanModify)
  389. throw UserFriendlyException.SameMessage("系统数据,不能修改");
  390. _mapper.Map(dto, model); //_mapper.Map<SystemArea>(dto);
  391. //验证重复
  392. var area = await _systemAreaRepository.Queryable(includeDeleted: true).Where(x => x.ParentId == dto.ParentId && x.AreaName == dto.AreaName).ToListAsync();
  393. if (area.Count > 1)
  394. {
  395. throw UserFriendlyException.SameMessage("同目录下已存在相同数据,不能修改");
  396. }
  397. await _systemAreaDomainService.ModifyArea(model, HttpContext.RequestAborted);
  398. }
  399. /// <summary>
  400. /// 删除省市区(逻辑)
  401. /// </summary>
  402. /// <param name="id"></param>
  403. /// <returns></returns>
  404. [HttpDelete("area/{id}")]
  405. public async Task DelArea(string id)
  406. {
  407. var model = await _systemAreaDomainService.GetArea(id, HttpContext.RequestAborted);
  408. if (model is null)
  409. throw UserFriendlyException.SameMessage("未知数据,请刷新页面");
  410. if (!model.IsCanModify)
  411. throw UserFriendlyException.SameMessage("系统数据不能删除");
  412. await _systemAreaDomainService.DelArea(id, HttpContext.RequestAborted);
  413. }
  414. /// <summary>
  415. /// 获取区域
  416. /// </summary>
  417. /// <param name="id"></param>
  418. /// <returns></returns>
  419. [HttpGet("area/{id}")]
  420. public async Task<SystemArea?> GetArea(string id)
  421. {
  422. var model = await _systemAreaDomainService.GetArea(id, HttpContext.RequestAborted);
  423. if (model is null)
  424. throw UserFriendlyException.SameMessage("未知数据,请刷新页面");
  425. return model;
  426. }
  427. #endregion
  428. #region 常用意见
  429. #region 个人
  430. /// <summary>
  431. /// 获取常用意见
  432. /// </summary>
  433. /// <returns></returns>
  434. [HttpGet("common-list")]
  435. public async Task<IReadOnlyList<SystemCommonOpinion>> GetCommon([FromQuery] ECommonType commonType, bool isOpen)
  436. {
  437. return await _commonOpinionRepository.Queryable().Where(x => x.CommonType == commonType )
  438. .WhereIF(isOpen == true, x =>(x.IsOpen == true || (x.CreatorOrgId == _sessionContext.RequiredOrgId && x.AttributionType == ECommonAttributionType.Org && x.IsOpen == false)))
  439. .WhereIF(isOpen == false, x => x.IsOpen == false && x.CreatorId == _sessionContext.RequiredUserId).ToListAsync();
  440. }
  441. /// <summary>
  442. /// 新增常用意见
  443. /// </summary>
  444. /// <param name="dto"></param>
  445. /// <returns></returns>
  446. [HttpPost("add-common")]
  447. public async Task AddCommon([FromBody] AddCommonDto dto)
  448. {
  449. var entity = _mapper.Map<SystemCommonOpinion>(dto);
  450. await _commonOpinionDomainService.AddCommonOpinion(entity, HttpContext.RequestAborted);
  451. }
  452. /// <summary>
  453. /// 批量删除常用意见
  454. /// </summary>
  455. /// <param name="dto"></param>
  456. /// <returns></returns>
  457. [HttpPost("del-common")]
  458. public async Task DelCommon([FromBody] DelCommonDto dto)
  459. {
  460. await _commonOpinionDomainService.DelCommonOpinion(dto.Ids, HttpContext.RequestAborted);
  461. }
  462. /// <summary>
  463. /// 常用意见页面基础信息
  464. /// </summary>
  465. /// <returns></returns>
  466. [HttpGet("common-basepage")]
  467. public async Task<object> CommonBasePage()
  468. {
  469. var rsp = new
  470. {
  471. CommonType = EnumExts.GetDescriptions<ECommonType>(),
  472. };
  473. return rsp;
  474. }
  475. #endregion
  476. #region 公开
  477. /// <summary>
  478. /// 查询公开常用意见
  479. /// </summary>
  480. /// <returns></returns>
  481. [HttpGet("open-common")]
  482. public async Task<PagedDto<SystemCommonOpinion>> QueryOpenCommonOpinionList([FromQuery] QueryCommonDto dto)
  483. {
  484. var (total, items) = await _commonOpinionRepository.Queryable()
  485. .WhereIF(dto.IsOpen != null, x => x.IsOpen == dto.IsOpen)
  486. .WhereIF(!string.IsNullOrEmpty(dto.UserName), x => x.CreatorName.Contains(dto.UserName))
  487. .WhereIF(dto.CommonType != null, x => x.CommonType == dto.CommonType)
  488. .ToPagedListAsync(dto.PageIndex, dto.PageSize, HttpContext.RequestAborted);
  489. return new PagedDto<SystemCommonOpinion>(total, items);
  490. }
  491. /// <summary>
  492. /// 修改公开常用意见
  493. /// </summary>
  494. /// <param name="dto"></param>
  495. /// <returns></returns>
  496. [HttpPost("common-modify")]
  497. public async Task CommonModify([FromBody] CommonModifyDto dto)
  498. {
  499. var model = await _commonOpinionRepository.GetAsync(dto.Id, HttpContext.RequestAborted);
  500. if (model is null)
  501. throw UserFriendlyException.SameMessage("无效数据");
  502. _mapper.Map(dto, model);
  503. await _commonOpinionRepository.UpdateAsync(model, HttpContext.RequestAborted);
  504. }
  505. #endregion
  506. #endregion
  507. #region 日志
  508. /// <summary>
  509. /// 获取日志列表
  510. /// </summary>
  511. /// <param name="dto"></param>
  512. /// <returns></returns>
  513. [HttpGet("log_list")]
  514. public async Task<PagedDto<SystemLogDto>> List([FromQuery] SysLogPagedKeywordRequest dto)
  515. {
  516. var (total, items) = await _systemLogRepository.Queryable()
  517. .WhereIF(dto.IsAll.HasValue && !dto.IsAll.Value, x => !string.IsNullOrEmpty(x.Name))
  518. .WhereIF(!string.IsNullOrEmpty(dto.Name), x => x.Name.Contains(dto.Name))
  519. .WhereIF(!string.IsNullOrEmpty(dto.CreatorName), x => x.CreatorName.Contains(dto.CreatorName))
  520. .WhereIF(!string.IsNullOrEmpty(dto.ExecuteUrl), x => x.ExecuteUrl.Contains(dto.ExecuteUrl))
  521. .WhereIF(!string.IsNullOrEmpty(dto.ExecuteParam),
  522. x => SqlFunc.JsonLike(x.ExecuteParam, dto.ExecuteParam))
  523. .WhereIF(dto.StartTime.HasValue && dto.EndTime.HasValue,
  524. x => x.CreationTime >= dto.StartTime && x.CreationTime <= dto.EndTime)
  525. //.WhereIF(!string.IsNullOrEmpty(dto.Keyword), x => x.Name.Contains(dto.Keyword!) || x.CreatorName.Contains(dto.Keyword!))
  526. .OrderByDescending(x => x.CreationTime)
  527. .ToPagedListAsync(dto.PageIndex, dto.PageSize, HttpContext.RequestAborted);
  528. return new PagedDto<SystemLogDto>(total, _mapper.Map<IReadOnlyList<SystemLogDto>>(items));
  529. }
  530. /// <summary>
  531. /// 获取日志实体
  532. /// </summary>
  533. /// <param name="id"></param>
  534. /// <returns></returns>
  535. [HttpGet("log/{id}")]
  536. public async Task<SystemLogDto> ItemEntity(string id)
  537. {
  538. var log = await _systemLogRepository.Queryable()
  539. .FirstAsync(x => x.Id == id);
  540. return _mapper.Map<SystemLogDto>(log);
  541. }
  542. [HttpPost("log")]
  543. public async Task<string> LogAdd([FromBody] SystemLogDto dto)
  544. {
  545. var log = _mapper.Map<SystemLog>(dto);
  546. return await _systemLogRepository.AddAsync(log, HttpContext.RequestAborted);
  547. }
  548. #endregion
  549. /// <summary>
  550. /// 验证电话外呼是否需要加0
  551. /// </summary>
  552. /// <param name="mobile"></param>
  553. /// <returns></returns>
  554. [HttpGet("vaild_mobile/{mobile}")]
  555. public async Task<string> VaildMobile(string mobile)
  556. {
  557. return await _systemMobilAreaApplication.VaildMobile(mobile);
  558. }
  559. /// <summary>
  560. /// 删除缓存
  561. /// </summary>
  562. /// <param name="dto"></param>
  563. /// <returns></returns>
  564. [HttpPut("cache/remove")]
  565. public async Task<IActionResult> ClearCache([FromBody] CleanCacheInDto dto)
  566. {
  567. foreach (var key in dto.Keys)
  568. {
  569. await _easyCaching.RemoveAsync(key, HttpContext.RequestAborted);
  570. await _redisCaching.KeyDelAsync(key);
  571. }
  572. return Ok();
  573. }
  574. /// <summary>
  575. /// 获取所有缓存的Key
  576. /// </summary>
  577. /// <param name="cacheKey">不传默认: Hotline:*</param>
  578. /// <returns></returns>
  579. [HttpGet("cache")]
  580. public async Task<List<string>> GetCache(string cacheKey = "Hotline:*")
  581. {
  582. return await _redisCaching.SearchKeysAsync(cacheKey);
  583. }
  584. /// <summary>
  585. /// 获取缓存
  586. /// </summary>
  587. /// <param name="key"></param>
  588. /// <returns></returns>
  589. [HttpGet("cache/{key}")]
  590. public async Task<List<string>> GetCacheByKey(string key)
  591. {
  592. var cacheResult = new List<string>();
  593. var result = await _easyCaching.GetAsync<object>(key,cancellationToken: HttpContext.RequestAborted);
  594. if (result != null)
  595. {
  596. cacheResult.Add(result.ToJson());
  597. }
  598. var stringResult = await _redisCaching.StringGetAsync(key);
  599. if (stringResult != null)
  600. {
  601. cacheResult.Add(stringResult);
  602. }
  603. return cacheResult;
  604. }
  605. }
  606. }