KnowledgeController.cs 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601
  1. using Hotline.Application.FlowEngine;
  2. using Hotline.Application.Knowledge;
  3. using Hotline.KnowledgeBase;
  4. using Hotline.KnowledgeBase.Notifies;
  5. using Hotline.Permissions;
  6. using Hotline.Repository.SqlSugar.Extensions;
  7. using Hotline.Settings;
  8. using Hotline.Settings.Hotspots;
  9. using Hotline.Share.Dtos;
  10. using Hotline.Share.Dtos.FlowEngine;
  11. using Hotline.Share.Dtos.Knowledge;
  12. using Hotline.Share.Enums.KnowledgeBase;
  13. using Hotline.Users;
  14. using MapsterMapper;
  15. using MediatR;
  16. using Microsoft.AspNetCore.Mvc;
  17. using SqlSugar;
  18. using XF.Domain.Authentications;
  19. using XF.Domain.Exceptions;
  20. using XF.Utility.EnumExtensions;
  21. namespace Hotline.Api.Controllers
  22. {
  23. /// <summary>
  24. ///
  25. /// </summary>
  26. public class KnowledgeController : BaseController
  27. {
  28. #region 注入
  29. private readonly IKnowledgeRepository _knowledgeRepository;
  30. private readonly ISessionContext _sessionContext;
  31. private readonly IKnowledgeDomainService _knowledgeDomainService;
  32. private readonly IMapper _mapper;
  33. private readonly IKnowApplication _knowApplication;
  34. private readonly IMediator _mediator;
  35. private readonly IWorkflowApplication _workflowApplication;
  36. private readonly IKnowledgeWorkFlowRepository _knowledgeWorkFlowRepository;
  37. private readonly IUserRepository _userRepository;
  38. private readonly IKnowledgeTypeRepository _knowledgeTypeRepository;
  39. private readonly IHotspotTypeRepository _hotspotTypeRepository;
  40. /// <summary>
  41. ///
  42. /// </summary>
  43. /// <param name="knowledgeRepository"></param>
  44. /// <param name="sessionContext"></param>
  45. /// <param name="knowledgeDomainService"></param>
  46. /// <param name="mapper"></param>
  47. /// <param name="knowApplication"></param>
  48. /// <param name="mediator"></param>
  49. /// <param name="workflowApplication"></param>
  50. /// <param name="knowledgeWorkFlowRepository"></param>
  51. /// <param name="userRepository"></param>
  52. /// <param name="knowledgeTypeRepository"></param>
  53. /// <param name="hotspotTypeRepository"></param>
  54. public KnowledgeController(IKnowledgeRepository knowledgeRepository, ISessionContext sessionContext, IKnowledgeDomainService knowledgeDomainService, IMapper mapper, IKnowApplication knowApplication,
  55. IMediator mediator, IWorkflowApplication workflowApplication, IKnowledgeWorkFlowRepository knowledgeWorkFlowRepository
  56. , IUserRepository userRepository, IKnowledgeTypeRepository knowledgeTypeRepository, IHotspotTypeRepository hotspotTypeRepository)
  57. {
  58. _knowledgeRepository = knowledgeRepository;
  59. _sessionContext = sessionContext;
  60. _knowledgeDomainService = knowledgeDomainService;
  61. _mapper = mapper;
  62. _knowApplication = knowApplication;
  63. _mediator = mediator;
  64. _workflowApplication = workflowApplication;
  65. _knowledgeWorkFlowRepository = knowledgeWorkFlowRepository;
  66. _userRepository = userRepository;
  67. _knowledgeTypeRepository = knowledgeTypeRepository;
  68. _hotspotTypeRepository = hotspotTypeRepository;
  69. }
  70. #endregion
  71. #region 知识管理
  72. /// <summary>
  73. /// 知识库-知识修改-查询详情
  74. /// </summary>
  75. /// <param name="Id"></param>
  76. /// <returns></returns>
  77. [HttpGet("updateinfo/{Id}")]
  78. public async Task<KnowledgeInfoDto> KnowledgeUpdateInfo(string Id)
  79. {
  80. var know = await _knowledgeRepository.GetAsync(Id, HttpContext.RequestAborted);
  81. if (know is null)
  82. throw UserFriendlyException.SameMessage("知识查询失败!");
  83. var knowledgeInfoDto = _mapper.Map<KnowledgeInfoDto>(know);
  84. //分类
  85. var type = await _knowledgeTypeRepository.GetAsync(know.KnowledgeTypeId, HttpContext.RequestAborted);
  86. if (type != null)
  87. knowledgeInfoDto.KnowledgeTypeName = type.SpliceName;
  88. //热点
  89. var hot = await _hotspotTypeRepository.GetAsync(know.HotspotId, HttpContext.RequestAborted);
  90. if (hot != null)
  91. knowledgeInfoDto.HotspotName = hot.HotSpotFullName;
  92. return knowledgeInfoDto;
  93. }
  94. /// <summary>
  95. /// 知识库-查询详情-增加浏览量
  96. /// </summary>
  97. /// <param name="Id">知识Id</param>
  98. /// <param name="IsAddPv">默认不增加,false不增加,true增加浏览量</param>
  99. /// <returns></returns>
  100. [HttpGet("info/{Id}")]
  101. public async Task<KnowledgeShowInfoDto> KnowledgeInfo(string Id, bool? IsAddPv)
  102. {
  103. var knowledge = await _knowledgeDomainService.KnowledgeInfo(Id, HttpContext.RequestAborted);
  104. if (knowledge is null)
  105. throw UserFriendlyException.SameMessage("知识查询失败!");
  106. //转化
  107. var knowledgeShowInfoDto = _mapper.Map<KnowledgeShowInfoDto>(knowledge);
  108. //查询其他
  109. var user = await _userRepository.GetAsync(knowledge.CreatorId, HttpContext.RequestAborted);
  110. if (user != null)
  111. knowledgeShowInfoDto.CreatorName = user.Name;
  112. var type = await _knowledgeTypeRepository.GetAsync(knowledge.KnowledgeTypeId, HttpContext.RequestAborted);
  113. if (type != null)
  114. knowledgeShowInfoDto.KnowledgeTypeName = type.SpliceName;
  115. var hot = await _hotspotTypeRepository.GetAsync(knowledge.HotspotId, HttpContext.RequestAborted);
  116. if (hot != null)
  117. knowledgeShowInfoDto.HotspotName = hot.HotSpotFullName;
  118. if (IsAddPv == true)
  119. _mediator.Publish(new GetKnowledgeInfoNotify(knowledge));
  120. return knowledgeShowInfoDto;
  121. }
  122. /// <summary>
  123. /// 知识库-新增
  124. /// </summary>
  125. /// <param name="dto"></param>
  126. /// <returns></returns>
  127. [Permission(EPermission.AddKnowledge)]
  128. [HttpPost("add")]
  129. public async Task<string> AddKnowledge([FromBody] AddKnowledgeDto dto)
  130. {
  131. var kn = _mapper.Map<Knowledge>(dto);
  132. //Code为空,从新生成Code
  133. if (string.IsNullOrEmpty(kn.Code))
  134. kn.Code = Convert.ToInt64((DateTime.Now - new DateTime(1970, 1, 1, 0, 0, 0, 0)).TotalSeconds).ToString();
  135. kn.Status = EKnowledgeStatus.Drafts;
  136. return await _knowledgeRepository.AddAsync(kn, HttpContext.RequestAborted);
  137. }
  138. /// <summary>
  139. /// 知识库-知识下架
  140. /// </summary>
  141. /// <param name="Id"></param>
  142. /// <returns></returns>
  143. [Permission(EPermission.KnowledgeOffShelf)]
  144. [HttpPut("offshelf")]
  145. public async Task KnowledgeOffShelf(string Id)
  146. {
  147. var know = await _knowledgeRepository.GetAsync(Id, HttpContext.RequestAborted);
  148. if (know != null && know.Status == EKnowledgeStatus.OnShelf)
  149. {
  150. know.Status = EKnowledgeStatus.OffShelf;
  151. know.OnShelfTime = null;
  152. know.OffShelfTime = DateTime.Now;
  153. await _knowledgeRepository.UpdateAsync(know, HttpContext.RequestAborted);
  154. }
  155. else
  156. throw UserFriendlyException.SameMessage("知识下架失败");
  157. }
  158. /// <summary>
  159. /// 知识库-知识上架
  160. /// </summary>
  161. /// <param name="Id"></param>
  162. /// <returns></returns>
  163. [Permission(EPermission.KnowledgeOnTheShelf)]
  164. [HttpPut("ontheshelf")]
  165. public async Task KnowledgeOnTheShelf(string Id)
  166. {
  167. var know = await _knowledgeRepository.GetAsync(Id, HttpContext.RequestAborted);
  168. if (know != null && know.Status == EKnowledgeStatus.OffShelf)
  169. {
  170. know.Status = EKnowledgeStatus.OnShelf;
  171. know.OnShelfTime = DateTime.Now;
  172. know.OffShelfTime = null;
  173. await _knowledgeRepository.UpdateAsync(know, HttpContext.RequestAborted);
  174. }
  175. else
  176. throw UserFriendlyException.SameMessage("知识上架失败");
  177. }
  178. /// <summary>
  179. /// 知识申请-关联知识-获取知识列表
  180. /// </summary>
  181. /// <returns></returns>
  182. [HttpGet("getknowledge")]
  183. public async Task<IReadOnlyList<KnowledgeCreateBMDataDto>> GetKnowledge()
  184. {
  185. var temp = await _knowledgeRepository
  186. .Queryable()
  187. .LeftJoin<SystemOrganize>((o, sys) => o.CreatorOrgId == sys.Id)
  188. //重新构建数据
  189. .Select((o, sys) => new
  190. {
  191. index = SqlFunc.RowNumber($"{o.Version} desc ", $"{o.Code}"),
  192. DepartmentId = sys.Id,
  193. Department = sys.OrgName,
  194. o.Id,
  195. o.Title,
  196. o.Status,
  197. o.Code
  198. })
  199. //将结果合并成一个表
  200. .MergeTable()
  201. //取第一条数据
  202. .Where(d => d.index == 1 && d.Status == EKnowledgeStatus.OnShelf)
  203. .ToListAsync();
  204. //返回数据
  205. return _mapper.Map<IReadOnlyList<KnowledgeCreateBMDataDto>>(temp);
  206. }
  207. #endregion
  208. #region 我的草稿箱
  209. /// <summary>
  210. /// 我的草稿箱
  211. /// </summary>
  212. /// <param name="pagedDto"></param>
  213. /// <returns></returns>
  214. [Permission(EPermission.KnowledgeMyDraftsList)]
  215. [HttpGet("mydraftslist")]
  216. public async Task<PagedDto<KnowledgeDataDto>> MyDraftsList([FromQuery] MyDraftsListPagedDto pagedDto)
  217. {
  218. var (total, items) = await _knowledgeRepository
  219. .Queryable()
  220. .Includes(it => it.User)
  221. .Includes(it => it.KnowledgeType)
  222. .Where(p => p.CreatorId == _sessionContext.RequiredUserId && p.Status == EKnowledgeStatus.Drafts)
  223. .WhereIF(!string.IsNullOrEmpty(pagedDto.Keyword), d => d.Title.Contains(pagedDto.Keyword!))
  224. .WhereIF(!string.IsNullOrEmpty(pagedDto.KnowledgeTypeId), d => d.KnowledgeTypeId == pagedDto.KnowledgeTypeId)
  225. .WhereIF(pagedDto.StartTime != null, d => d.CreationTime >= pagedDto.StartTime)
  226. .WhereIF(pagedDto.EndTime != null, d => d.CreationTime <= pagedDto.EndTime)
  227. .OrderByDescending(p => p.CreationTime)
  228. .ToPagedListAsync(pagedDto.PageIndex, pagedDto.PageSize, HttpContext.RequestAborted);
  229. return new PagedDto<KnowledgeDataDto>(total, _mapper.Map<IReadOnlyList<KnowledgeDataDto>>(items));
  230. }
  231. /// <summary>
  232. /// 知识库-修改知识草稿
  233. /// </summary>
  234. /// <param name="dto"></param>
  235. /// <returns></returns>
  236. [Permission(EPermission.KnowledgeDraftsUpdate)]
  237. [HttpPut("update")]
  238. public async Task UpdateKnowledge([FromBody] UpdateKnowledgeDto dto)
  239. {
  240. if (dto.Status != EKnowledgeStatus.Drafts)
  241. throw UserFriendlyException.SameMessage("非草稿数据不可修改");
  242. var kn = _mapper.Map<Knowledge>(dto);
  243. await _knowledgeRepository.UpdateAsync(kn, HttpContext.RequestAborted);
  244. }
  245. /// <summary>
  246. /// 删除知识草稿
  247. /// </summary>
  248. /// <param name="id"></param>
  249. /// <returns></returns>
  250. [Permission(EPermission.KnowledgeDraftsDelete)]
  251. [HttpDelete("{id}")]
  252. public async Task Remove(string id)
  253. {
  254. var knowledge = await _knowledgeRepository.GetAsync(id, HttpContext.RequestAborted);
  255. if (knowledge == null) return;
  256. if (knowledge.Status != EKnowledgeStatus.Drafts)
  257. throw UserFriendlyException.SameMessage("非草稿数据不可删除");
  258. await _knowledgeRepository.RemoveAsync(knowledge, false, HttpContext.RequestAborted);
  259. }
  260. #endregion
  261. #region 知识列表
  262. /// <summary>
  263. /// 知识库列表页面枚举值
  264. /// </summary>
  265. /// <returns></returns>
  266. [HttpGet("knowledge-status-data")]
  267. public async Task<object> KnowledgeStatus()
  268. {
  269. return new List<KeyValuePair<int, string>>
  270. {
  271. new KeyValuePair<int, string>(1, "审核中"),
  272. new KeyValuePair<int, string>(3, "已上架"),
  273. new KeyValuePair<int, string>(4, "已下架")
  274. };
  275. }
  276. /// <summary>
  277. /// 知识查询
  278. /// </summary>
  279. /// <param name="pagedDto"></param>
  280. /// <returns></returns>
  281. [Permission(EPermission.KnowledgeAllList)]
  282. [HttpGet()]
  283. public async Task<PagedDto<KnowledgeDataDto>> GetKnowList([FromQuery] KnowPagedListDto pagedDto)
  284. {
  285. return await _knowApplication.GetKnowList(pagedDto);
  286. }
  287. #endregion
  288. #region 知识检索
  289. /// <summary>
  290. /// 知识检索
  291. /// </summary>
  292. /// <param name="pagedDto"></param>
  293. /// <returns></returns>
  294. [Permission(EPermission.KnowledgeRetrieval)]
  295. [HttpGet("knowretrieval")]
  296. public async Task<PagedDto<KnowledgeRetrievalDataDto>> KnowRetrieval([FromQuery] KnowledgeRetrievalPagedListDto pagedDto)
  297. {
  298. //if (string.IsNullOrEmpty(pagedDto.Keyword))
  299. // throw UserFriendlyException.SameMessage("请输入关键字");
  300. RefAsync<int> total = 0;
  301. var Keyword = pagedDto.Keyword?.Trim();
  302. var temp = await _knowledgeRepository
  303. .Queryable()
  304. .Select(o => new
  305. {
  306. index = SqlFunc.RowNumber($"{o.Version} desc ", $"{o.Code}"),
  307. o.Id,
  308. o.Code,
  309. o.Title,
  310. o.Summary,
  311. o.Content,
  312. o.PageView,
  313. o.Additions,
  314. o.Status
  315. })
  316. //将结果合并成一个表
  317. .MergeTable()
  318. //取第一条数据
  319. .Where(d => d.index == 1 && d.Status == EKnowledgeStatus.OnShelf)
  320. .WhereIF((pagedDto.RetrievalType == null || pagedDto.RetrievalType == EKnowledgeRetrievalType.All) && !string.IsNullOrEmpty(Keyword), d => d.Title.Contains(Keyword) || d.Content.Contains(Keyword))// || d.Additions.Contains(pagedDto.Keyword)
  321. .WhereIF(pagedDto.RetrievalType == EKnowledgeRetrievalType.Title && !string.IsNullOrEmpty(Keyword), d => d.Title.Contains(Keyword))
  322. .WhereIF(pagedDto.RetrievalType == EKnowledgeRetrievalType.Content && !string.IsNullOrEmpty(Keyword), d => d.Content.Contains(Keyword))
  323. // .WhereIF(pagedDto.RetrievalType == EKnowledgeRetrievalType.Enclosure, d => d.Additions.Contains(pagedDto.Keyword))
  324. .OrderByDescending(p => p.PageView)
  325. .ToPageListAsync(pagedDto.PageIndex, pagedDto.PageSize, total);
  326. return new PagedDto<KnowledgeRetrievalDataDto>(total, _mapper.Map<IReadOnlyList<KnowledgeRetrievalDataDto>>(temp));
  327. }
  328. #endregion
  329. #region 我的知识删除列表
  330. /// <summary>
  331. /// 我的知识删除列表页面枚举值
  332. /// </summary>
  333. /// <returns></returns>
  334. [HttpGet("delete-status-data")]
  335. public async Task<object> DeleteApplyStatus()
  336. {
  337. return EnumExts.GetDescriptions<EKnowledgeWorkFlowStatus>();
  338. }
  339. /// <summary>
  340. /// 我的知识删除列表
  341. /// </summary>
  342. /// <param name="pagedDto"></param>
  343. /// <returns></returns>
  344. [HttpGet("deletelist")]
  345. [Permission(EPermission.KnowledgeDeleteApply)]
  346. public async Task<PagedDto<KnowledgeDeleteApplyDataDto>> GetDeleteApplyList([FromQuery] KnowledgeDeletelPagedListDto pagedDto)
  347. {
  348. var (total, items) = await _knowledgeWorkFlowRepository
  349. .Queryable(includeDeleted: true)
  350. .Includes(it => it.Knowledge)
  351. .Includes(it => it.User)
  352. .Includes(it => it.SystemOrganize)
  353. .Includes(it => it.Knowledge, it => it.KnowledgeType)
  354. .Includes(it => it.Knowledge, it => it.HotspotType)
  355. .Includes(it => it.Workflow)
  356. .Where(d => d.CreatorId == _sessionContext.RequiredUserId && d.WorkflowModuleStatus == EKnowledgeApplyType.Delete && d.WorkflowId != null)
  357. .WhereIF(pagedDto.EKnowledgeWorkFlowStatus.HasValue, d => d.WorkFlowApplyStatus == pagedDto.EKnowledgeWorkFlowStatus)
  358. .WhereIF(pagedDto.StartApplyTime.HasValue, d => d.CreationTime >= pagedDto.StartApplyTime)
  359. .WhereIF(pagedDto.EndApplyTime.HasValue, d => d.CreationTime <= pagedDto.EndApplyTime)
  360. .WhereIF(!string.IsNullOrEmpty(pagedDto.Keyword), d => d.Knowledge.User.Name.Contains(pagedDto.Keyword!)
  361. || d.Knowledge.SystemOrganize.OrgName.Contains(pagedDto.Keyword!)
  362. || d.Knowledge.Title.Contains(pagedDto.Keyword!))
  363. .OrderByDescending(p => p.CreationTime)
  364. .ToPagedListAsync(pagedDto.PageIndex, pagedDto.PageSize, HttpContext.RequestAborted);
  365. return new PagedDto<KnowledgeDeleteApplyDataDto>(total, _mapper.Map<IReadOnlyList<KnowledgeDeleteApplyDataDto>>(items));
  366. }
  367. #endregion
  368. #region 审核管理
  369. /// <summary>
  370. /// 审核管理页面枚举值
  371. /// </summary>
  372. /// <returns></returns>
  373. [HttpGet("approval-base-data")]
  374. public async Task<object> ApprovalBaseData()
  375. {
  376. return new
  377. {
  378. EKnowledgeWorkFlowStatus = EnumExts.GetDescriptions<EKnowledgeWorkFlowStatus>(),
  379. EKnowledgeApplyType = EnumExts.GetDescriptions<EKnowledgeApplyType>()
  380. };
  381. }
  382. /// <summary>
  383. /// 审核管理
  384. /// </summary>
  385. /// <param name="pagedDto"></param>
  386. /// <returns></returns>
  387. [Permission(EPermission.KnowledgeApprovedAllList)]
  388. [HttpGet("approvedlist")]
  389. public async Task<PagedDto<KnowledgeApprovalDataDto>> ApprovedList([FromQuery] KnowledgeApprovalPagedListDto pagedDto)
  390. {
  391. var (total, items) = await _knowledgeWorkFlowRepository
  392. .Queryable(includeDeleted: true)
  393. .Includes(it => it.Knowledge)
  394. .Includes(it => it.User)
  395. .Includes(it => it.SystemOrganize)
  396. .Includes(it => it.Knowledge, it => it.KnowledgeType)
  397. .Includes(it => it.Workflow)
  398. .Where(it => it.WorkflowId != null)
  399. .WhereIF(pagedDto.EKnowledgeApplyType.HasValue, d => d.WorkflowModuleStatus == pagedDto.EKnowledgeApplyType)
  400. .WhereIF(pagedDto.EKnowledgeWorkFlowStatus.HasValue, d => d.WorkFlowApplyStatus == pagedDto.EKnowledgeWorkFlowStatus)
  401. .WhereIF(!string.IsNullOrEmpty(pagedDto.Keyword), d => d.Knowledge.User.Name.Contains(pagedDto.Keyword!)
  402. || d.Knowledge.SystemOrganize.OrgName.Contains(pagedDto.Keyword!)
  403. || d.Knowledge.Title.Contains(pagedDto.Keyword!))
  404. .OrderByDescending(p => p.CreationTime)
  405. .ToPagedListAsync(pagedDto.PageIndex, pagedDto.PageSize, HttpContext.RequestAborted);
  406. foreach (var item in items)
  407. {
  408. if (item.Workflow != null)
  409. item.CanHandle = item.Workflow.CanHandle(_sessionContext.RequiredUserId, _sessionContext.RequiredOrgCode);
  410. }
  411. //处理是否可以办理
  412. //items.ForEach(d => d.CanHandle = d.Workflow.CanHandle(_sessionContext.RequiredUserId, _sessionContext.RequiredOrgCode));
  413. return new PagedDto<KnowledgeApprovalDataDto>(total, _mapper.Map<IReadOnlyList<KnowledgeApprovalDataDto>>(items));
  414. }
  415. #endregion
  416. #region 工单受理,知识库检索
  417. /// <summary>
  418. /// 获取知识热点词
  419. /// </summary>
  420. /// <returns></returns>
  421. [HttpGet("getkeyword")]
  422. public async Task<List<string>> GetKeyWord()
  423. {
  424. return await _knowledgeDomainService.GetKeyWord();
  425. }
  426. /// <summary>
  427. /// 工单受理知识检索
  428. /// </summary>
  429. /// <param name="pagedDto"></param>
  430. /// <returns></returns>
  431. [HttpGet("knowpopscreen")]
  432. public async Task<PagedDto<KnowledgeRetrievalDataDto>> KnowPopScreen([FromQuery] KnowledgePopScreenPagedListDto pagedDto)
  433. {
  434. RefAsync<int> total = 0;
  435. var temp = await _knowledgeRepository
  436. .Queryable()
  437. .Select(o => new
  438. {
  439. index = SqlFunc.RowNumber($"{o.Version} desc ", $"{o.Code}"),
  440. o.Id,
  441. o.Code,
  442. o.Title,
  443. o.Summary,
  444. o.Content,
  445. o.PageView,
  446. o.Keywords,
  447. o.HotspotId,
  448. o.Status
  449. })
  450. //将结果合并成一个表
  451. .MergeTable()
  452. //取第一条数据
  453. .Where(d => d.index == 1 && d.Status == EKnowledgeStatus.OnShelf)
  454. .WhereIF(!string.IsNullOrEmpty(pagedDto.Keyword), p => p.Title.Contains(pagedDto.Keyword) || p.Keywords.Contains(pagedDto.Keyword))
  455. .WhereIF(!string.IsNullOrEmpty(pagedDto.HotspotId), p => p.HotspotId == pagedDto.HotspotId)
  456. .OrderByDescending(p => p.PageView)
  457. .ToPageListAsync(pagedDto.PageIndex, pagedDto.PageSize, total);
  458. return new PagedDto<KnowledgeRetrievalDataDto>(total, _mapper.Map<IReadOnlyList<KnowledgeRetrievalDataDto>>(temp));
  459. }
  460. #endregion
  461. #region 流程相关
  462. /// <summary>
  463. /// 新增-开始流程
  464. /// </summary>
  465. /// <param name="id">知识id</param>
  466. /// <param name="dto">流程开启参数</param>
  467. /// <returns></returns>
  468. [Permission(EPermission.AddKnowledge)]
  469. [HttpPost("{id}/add-startflow")]
  470. public async Task AddStartFlow(string id, [FromBody] StartWorkflowDto dto)
  471. {
  472. await StartFlow(id, WorkflowModuleConsts.KnowledgeAdd, EKnowledgeApplyType.Add, dto);
  473. }
  474. /// <summary>
  475. /// 删除-开始流程
  476. /// </summary>
  477. /// <param name="id">知识id</param>
  478. /// <param name="dto">流程开启参数</param>
  479. /// <returns></returns>
  480. [Permission(EPermission.KnowledgeDelete)]
  481. [HttpPost("{id}/remove-startflow")]
  482. public async Task RemoveStartFlow(string id, [FromBody] StartWorkflowDto dto)
  483. {
  484. await StartFlow(id, WorkflowModuleConsts.KnowledgeDelete, EKnowledgeApplyType.Delete, dto);
  485. }
  486. /// <summary>
  487. /// 查询知识库办理流程开启参数-新增
  488. /// </summary>
  489. /// <returns></returns>
  490. [Permission(EPermission.AddKnowledge)]
  491. [HttpGet("add-flow-start")]
  492. public async Task<IReadOnlyList<KeyValuePair<string, string>>> GetAddFlowStartOptionsAsync()
  493. {
  494. return await _workflowApplication.GetStartOptionsAsync(WorkflowModuleConsts.KnowledgeAdd, HttpContext.RequestAborted);
  495. }
  496. /// <summary>
  497. /// 查询知识库办理流程开启参数-删除
  498. /// </summary>
  499. /// <returns></returns>
  500. [Permission(EPermission.KnowledgeDelete)]
  501. [HttpGet("remove-flow-start")]
  502. public async Task<IReadOnlyList<KeyValuePair<string, string>>> GetRemoveFlowStartOptionsAsync()
  503. {
  504. return await _workflowApplication.GetStartOptionsAsync(WorkflowModuleConsts.KnowledgeDelete, HttpContext.RequestAborted);
  505. }
  506. #endregion
  507. #region 私有方法-开始流程
  508. /// <summary>
  509. /// 开始流程
  510. /// </summary>
  511. /// <param name="id">知识ID</param>
  512. /// <param name="moduleCode">知识模板编号</param>
  513. /// <param name="eKnowledgeApplyType">申请类型</param>
  514. /// <param name="dto">流程开启参数</param>
  515. /// <returns></returns>
  516. private async Task StartFlow(string id, string moduleCode, EKnowledgeApplyType eKnowledgeApplyType, StartWorkflowDto dto)
  517. {
  518. var knowledge = await _knowledgeRepository.GetAsync(id, HttpContext.RequestAborted);
  519. if (knowledge == null)
  520. throw UserFriendlyException.SameMessage("无效知识编号");
  521. if (eKnowledgeApplyType == EKnowledgeApplyType.Delete)
  522. {
  523. if (knowledge.IsDeleted == true)
  524. throw UserFriendlyException.SameMessage("知识删除失败");
  525. //验证是否已经发起过知识删除流程
  526. var exists = await _knowledgeWorkFlowRepository.GetAsync(p => p.KnowledgeId == knowledge.Id && p.WorkflowModuleStatus == EKnowledgeApplyType.Delete
  527. && (p.WorkFlowApplyStatus == EKnowledgeWorkFlowStatus.Success || p.WorkFlowApplyStatus == EKnowledgeWorkFlowStatus.Auditing) && p.WorkflowId != null);
  528. if (exists != null)
  529. throw UserFriendlyException.SameMessage($"该知识已发起过{WorkflowModule.Modules[WorkflowModuleConsts.KnowledgeDelete]}流程");
  530. }
  531. if (!string.IsNullOrEmpty(knowledge.WorkflowId) && eKnowledgeApplyType != EKnowledgeApplyType.Delete)
  532. throw UserFriendlyException.SameMessage("知识已发起流程");
  533. //知识审批主表
  534. var flowId = await _knowledgeDomainService.AddWorkFlowAsync(id, eKnowledgeApplyType, HttpContext.RequestAborted);
  535. dto.DefinitionModuleCode = moduleCode;
  536. dto.Title = knowledge.Title;
  537. await _workflowApplication.StartWorkflowAsync(dto, flowId, HttpContext.RequestAborted);
  538. }
  539. #endregion
  540. }
  541. }