KnowledgeController.cs 25 KB

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