WorkflowController.cs 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665
  1. using Hotline.Application.FlowEngine;
  2. using Hotline.FlowEngine.Definitions;
  3. using Hotline.FlowEngine.Workflows;
  4. using Hotline.Identity.Roles;
  5. using Hotline.Permissions;
  6. using Hotline.Repository.SqlSugar.Extensions;
  7. using Hotline.Settings;
  8. using Hotline.Share.Dtos;
  9. using Hotline.Share.Dtos.FlowEngine;
  10. using Hotline.Share.Enums.FlowEngine;
  11. using Hotline.Users;
  12. using MapsterMapper;
  13. using Microsoft.AspNetCore.Mvc;
  14. using SqlSugar;
  15. using Hotline.FlowEngine.WorkflowModules;
  16. using XF.Domain.Authentications;
  17. using XF.Domain.Exceptions;
  18. using XF.Domain.Extensions;
  19. using XF.Utility.EnumExtensions;
  20. using XF.Domain.Repository;
  21. using Hotline.Share.Dtos.FlowEngine.Workflow;
  22. using Hotline.Caching.Interfaces;
  23. using Hotline.File;
  24. using Hotline.Orders;
  25. using Hotline.Share.Dtos.Order;
  26. using Hotline.Share.Dtos.FlowEngine.Definition;
  27. using Hotline.Settings.TimeLimits;
  28. using Hotline.SeedData;
  29. using Hotline.Tools;
  30. using Hotline.Share.Enums.Order;
  31. using Hotline.Api.Filter;
  32. namespace Hotline.Api.Controllers;
  33. /// <summary>
  34. /// 工作流管理
  35. /// </summary>
  36. public class WorkflowController : BaseController
  37. {
  38. private readonly IDefinitionDomainService _definitionDomainService;
  39. private readonly IRepository<WorkflowDefinition> _definitionRepository;
  40. private readonly IWorkflowApplication _workflowApplication;
  41. private readonly IWorkflowDomainService _workflowDomainService;
  42. private readonly IWorkflowRepository _workflowRepository;
  43. private readonly IRepository<User> _userRepository;
  44. private readonly ISystemOrganizeRepository _organizeRepository;
  45. private readonly IRepository<Role> _roleRepository;
  46. private readonly ISystemDomainService _systemDomainService;
  47. private readonly IWfModuleDomainService _wfModuleDomainService;
  48. private readonly IRepository<WorkflowStep> _workflowStepRepository;
  49. private readonly IRepository<WorkflowModule> _wfModuleRepository;
  50. private readonly IRepository<WorkflowTrace> _workflowTraceRepository;
  51. private readonly IRepository<WorkflowCountersign> _workflowCountersignRepository;
  52. private readonly IRepository<WorkflowCountersignMember> _workflowCountersignMemberRepository;
  53. private readonly ISessionContext _sessionContext;
  54. private readonly IMapper _mapper;
  55. private readonly ISystemDicDataCacheManager _systemDicDataCacheManager;
  56. private readonly IFileRepository _fileRepository;
  57. private readonly ISystemDicDataCacheManager _sysDicDataCacheManager;
  58. private readonly ISystemSettingCacheManager _systemSettingCacheManager;
  59. public WorkflowController(
  60. IDefinitionDomainService definitionDomainService,
  61. IRepository<WorkflowDefinition> definitionRepository,
  62. IWorkflowApplication workflowApplication,
  63. IWorkflowDomainService workflowDomainService,
  64. IWorkflowRepository workflowRepository,
  65. IRepository<User> userRepository,
  66. ISystemOrganizeRepository organizeRepository,
  67. IRepository<Role> roleRepository,
  68. ISystemDomainService systemDomainService,
  69. IWfModuleDomainService wfModuleDomainService,
  70. IRepository<WorkflowStep> workflowStepRepository,
  71. IRepository<WorkflowModule> wfModuleRepository,
  72. IRepository<WorkflowTrace> workflowTraceRepository,
  73. IRepository<WorkflowCountersign> workflowCountersignRepository,
  74. ISessionContext sessionContext,
  75. IMapper mapper,
  76. ISystemDicDataCacheManager systemDicDataCacheManager,
  77. IFileRepository fileRepository,
  78. IRepository<WorkflowCountersignMember> workflowCountersignMemberRepository,
  79. ISystemDicDataCacheManager sysDicDataCacheManager,
  80. ISystemSettingCacheManager systemSettingCacheManager
  81. )
  82. {
  83. _definitionDomainService = definitionDomainService;
  84. _definitionRepository = definitionRepository;
  85. _workflowApplication = workflowApplication;
  86. _workflowDomainService = workflowDomainService;
  87. _workflowRepository = workflowRepository;
  88. _userRepository = userRepository;
  89. _organizeRepository = organizeRepository;
  90. _roleRepository = roleRepository;
  91. _systemDomainService = systemDomainService;
  92. _wfModuleDomainService = wfModuleDomainService;
  93. _workflowStepRepository = workflowStepRepository;
  94. _wfModuleRepository = wfModuleRepository;
  95. _sessionContext = sessionContext;
  96. _mapper = mapper;
  97. _workflowTraceRepository = workflowTraceRepository;
  98. _workflowCountersignRepository = workflowCountersignRepository;
  99. _systemDicDataCacheManager = systemDicDataCacheManager;
  100. _fileRepository = fileRepository;
  101. _workflowCountersignMemberRepository = workflowCountersignMemberRepository;
  102. _sysDicDataCacheManager = sysDicDataCacheManager;
  103. _systemSettingCacheManager = systemSettingCacheManager;
  104. }
  105. #region definition
  106. /// <summary>
  107. /// 分页查询最新版本号的模板
  108. /// </summary>
  109. /// <param name="dto"></param>
  110. /// <returns></returns>
  111. [HttpGet("definition/latest")]
  112. public async Task<PagedDto<DefinitionDto>> QueryDefinitionLatest([FromQuery] QueryDefinitionDto dto)
  113. {
  114. var query2 = await _definitionRepository.Queryable()
  115. .WhereIF(dto.Status.HasValue, d => d.Status == dto.Status)
  116. .WhereIF(!string.IsNullOrEmpty(dto.Keyword),
  117. d => d.Code.Contains(dto.Keyword) || d.Name.Contains(dto.Keyword))
  118. .Select(d => new { i = SqlFunc.RowNumber($"{d.Version} desc", d.Code), d })
  119. .MergeTable()
  120. .Where(d => d.i == 1)
  121. .ToListAsync();
  122. var items = query2.Select(d => d.d).ToList();
  123. return new PagedDto<DefinitionDto>(query2.Count, _mapper.Map<IReadOnlyList<DefinitionDto>>(items));
  124. }
  125. /// <summary>
  126. /// 分页查询流程模板
  127. /// </summary>
  128. /// <param name="dto"></param>
  129. /// <returns></returns>
  130. [HttpGet("definition")]
  131. public async Task<PagedDto<DefinitionDto>> QueryDefinitions([FromQuery] QueryDefinitionDto dto)
  132. {
  133. #region old version:只查询草稿、禁用以及已启用模板的最新版本
  134. ////todo 数据量大需重构
  135. //var query1 = await _definitionRepository.Queryable()
  136. // .Where(d => d.Status == EDefinitionStatus.Temporary)
  137. // .ToListAsync();
  138. //var query2 = await _definitionRepository.Queryable()
  139. // .Where(d => d.Status != EDefinitionStatus.Temporary)
  140. // .Select(d => new { i = SqlFunc.RowNumber($"{d.Version} desc", d.Code), d })
  141. // .MergeTable()
  142. // .Where(d => d.i == 1)
  143. // .ToListAsync();
  144. //var query = query1.Union(query2.Select(d => d.d));
  145. //var total = query.Count();
  146. //var items = query
  147. // .OrderBy(d => d.Status)
  148. // .ThenByDescending(d => d.CreationTime)
  149. // .Skip(dto.Skip())
  150. // .Take(dto.PageSize)
  151. // .ToList();
  152. #endregion
  153. var (total, items) = await _definitionRepository.Queryable()
  154. .WhereIF(dto.Status.HasValue, d => d.Status == dto.Status)
  155. .WhereIF(!string.IsNullOrEmpty(dto.Keyword),
  156. d => d.Code.Contains(dto.Keyword!) || d.Name.Contains(dto.Keyword!))
  157. .OrderBy(d => d.Status)
  158. .OrderBy(d => d.Code)
  159. .OrderByDescending(d => d.Version)
  160. .ToPagedListAsync(dto, HttpContext.RequestAborted);
  161. return new PagedDto<DefinitionDto>(total, _mapper.Map<IReadOnlyList<DefinitionDto>>(items));
  162. }
  163. /// <summary>
  164. /// 查询流程模板
  165. /// </summary>
  166. /// <param name="id"></param>
  167. /// <returns></returns>
  168. [HttpGet("definition/{id}")]
  169. public async Task<DefinitionDto> GetDefinition(string id)
  170. {
  171. var definition = await _definitionRepository.GetAsync(id, HttpContext.RequestAborted);
  172. if (definition == null) return new();
  173. return _mapper.Map<DefinitionDto>(definition);
  174. }
  175. /// <summary>
  176. /// 新增流程模板草稿
  177. /// </summary>
  178. /// <param name="dto"></param>
  179. /// <returns></returns>
  180. [HttpPost("definition")]
  181. public async Task<string> AddDefinition([FromBody] AddDefinitionDto dto)
  182. {
  183. return await _definitionDomainService.AddAsync(dto, HttpContext.RequestAborted);
  184. }
  185. /// <summary>
  186. /// 更新流程模板草稿
  187. /// </summary>
  188. /// <param name="dto"></param>
  189. /// <returns></returns>
  190. [HttpPut("definition")]
  191. public async Task UpdateDefinition([FromBody] UpdateDefinitionDto dto)
  192. {
  193. var definition = await _definitionRepository.GetAsync(dto.Id, HttpContext.RequestAborted);
  194. if (definition == null)
  195. throw UserFriendlyException.SameMessage("无效模板编号");
  196. if (definition.Status == EDefinitionStatus.Temporary)
  197. {
  198. _mapper.Map(dto, definition);
  199. await _definitionRepository.UpdateAsync(definition, HttpContext.RequestAborted);
  200. }
  201. else
  202. {
  203. var newDefinition = _mapper.Map<WorkflowDefinition>(dto);
  204. await _definitionRepository.AddAsync(newDefinition, HttpContext.RequestAborted);
  205. }
  206. }
  207. /// <summary>
  208. /// 删除草稿
  209. /// </summary>
  210. /// <param name="id"></param>
  211. /// <returns></returns>
  212. /// <exception cref="UserFriendlyException"></exception>
  213. [HttpDelete("definition/{id}")]
  214. public async Task RemoveDefinition(string id)
  215. {
  216. var definition = await _definitionRepository.GetAsync(id, HttpContext.RequestAborted);
  217. if (definition == null) return;
  218. if (definition.Status != EDefinitionStatus.Temporary)
  219. throw new UserFriendlyException("已发布模板不能删除");
  220. await _definitionRepository.RemoveAsync(id, false, HttpContext.RequestAborted);
  221. }
  222. /// <summary>
  223. /// 发布(列表操作)
  224. /// </summary>
  225. /// <returns></returns>
  226. [HttpPost("definition/{id}/publish")]
  227. public async Task Publish(string id)
  228. {
  229. await _definitionDomainService.PublishAsync(id, HttpContext.RequestAborted);
  230. }
  231. /// <summary>
  232. /// 发布(保存并发布)
  233. /// </summary>
  234. /// <returns></returns>
  235. [Obsolete]
  236. [HttpPost("definition/publish")]
  237. public async Task Publish([FromBody] AddDefinitionDto dto)
  238. {
  239. await _definitionDomainService.PublishAsync(dto, HttpContext.RequestAborted);
  240. }
  241. #endregion
  242. #region WorkflowModule
  243. /// <summary>
  244. /// 持久化新增工作流业务
  245. /// </summary>
  246. /// <returns></returns>
  247. [HttpGet("wfmodule/persistence")]
  248. public async Task PersistenceWfModule()
  249. {
  250. await _wfModuleDomainService.PersistenceModulesAsync(HttpContext.RequestAborted);
  251. }
  252. /// <summary>
  253. /// 查询所有工作流模块
  254. /// </summary>
  255. /// <returns></returns>
  256. [HttpGet("wfmodules")]
  257. public async Task<IReadOnlyList<WorkflowModule>> QueryWfModules()
  258. {
  259. return await _wfModuleRepository.Queryable()
  260. .Includes(d => d.Definition)
  261. .ToListAsync();
  262. }
  263. /// <summary>
  264. /// 为工作流业务匹配或取消流程模板
  265. /// </summary>
  266. /// <param name="dto"></param>
  267. /// <returns></returns>
  268. [HttpPut("wfmodule/match")]
  269. public async Task MatchDefinition([FromBody] MatchDefinitionDto dto)
  270. {
  271. if (string.IsNullOrEmpty(dto.DefinitionId))
  272. {
  273. //取消当前已配置模板
  274. await _wfModuleDomainService.MatchDefinitionAsync(dto, HttpContext.RequestAborted);
  275. }
  276. else
  277. {
  278. var definition = await _definitionRepository.GetAsync(dto.DefinitionId);
  279. if (definition == null)
  280. throw UserFriendlyException.SameMessage("无效模板编号");
  281. if (definition.Status != EDefinitionStatus.Enable)
  282. throw UserFriendlyException.SameMessage("该模板未发布");
  283. await _wfModuleDomainService.MatchDefinitionAsync(dto, HttpContext.RequestAborted);
  284. }
  285. }
  286. #endregion
  287. #region workflow
  288. /// <summary>
  289. /// 分页查询流程
  290. /// </summary>
  291. /// <param name="dto"></param>
  292. /// <returns></returns>
  293. [HttpGet]
  294. public async Task<PagedDto<WorkflowDto>> QueryPaged([FromQuery] QueryWorkflowPagedDto dto)
  295. {
  296. var (total, items) = await _workflowRepository.Queryable()
  297. .WhereIF(!string.IsNullOrEmpty(dto.ModuleCode), d => d.ModuleCode == dto.ModuleCode)
  298. .WhereIF(!string.IsNullOrEmpty(dto.Keyword),
  299. d => d.Id.Contains(dto.Keyword!) || d.Title.Contains(dto.Keyword!))
  300. .OrderByDescending(d => d.CreationTime)
  301. .ToPagedListAsync(dto, HttpContext.RequestAborted);
  302. return new PagedDto<WorkflowDto>(total, _mapper.Map<IReadOnlyList<WorkflowDto>>(items));
  303. }
  304. /// <summary>
  305. /// 查询流程办理下一步可选节点
  306. /// </summary>
  307. [HttpGet("{workflowId}/nextsteps")]
  308. public async Task<NextStepsDto> GetNextStepDefine(string workflowId)
  309. {
  310. return await _workflowApplication.GetNextStepsAsync(workflowId, HttpContext.RequestAborted);
  311. }
  312. /// <summary>
  313. /// 办理节点
  314. /// </summary>
  315. [HttpPost("next")]
  316. [Obsolete("即将弃用")]
  317. [LogFilterAlpha("审核开始")]
  318. public async Task Next([FromBody] NextWorkflowDto dto)
  319. {
  320. await _workflowDomainService.NextAsync(dto, cancellationToken: HttpContext.RequestAborted);
  321. }
  322. /// <summary>
  323. /// 退回(返回前一节点)
  324. /// </summary>
  325. [HttpPost("previous")]
  326. [Obsolete("即将弃用")]
  327. [LogFilterAlpha("审核退回")]
  328. public async Task Previous([FromBody] PreviousWorkflowDto dto)
  329. {
  330. await _workflowDomainService.PreviousAsync(dto, cancellationToken: HttpContext.RequestAborted);
  331. }
  332. /// <summary>
  333. /// 获取撤回可选节点
  334. /// </summary>
  335. /// <param name="workflowId"></param>
  336. /// <returns></returns>
  337. [HttpGet("{workflowId}/recall")]
  338. public async Task<NextStepsDto<RecallStepOption>> GetRecallSteps(string workflowId)
  339. {
  340. return await _workflowApplication.GetRecallStepsAsync(workflowId, HttpContext.RequestAborted);
  341. }
  342. /// <summary>
  343. /// 终止流程
  344. /// </summary>
  345. [HttpPost("terminate")]
  346. public async Task Terminate([FromBody] TerminateDto dto)
  347. {
  348. await _workflowDomainService.TerminateAsync(dto, HttpContext.RequestAborted);
  349. }
  350. ///// <summary>
  351. ///// 撤销流程
  352. ///// </summary>
  353. //[HttpPost("cancel")]
  354. //public async Task Cancel([FromBody] CancelDto dto)
  355. //{
  356. // await _workflowDomainService.CancelAsync(dto, DateTime.Now, _sessionContext, HttpContext.RequestAborted);
  357. //}
  358. /// <summary>
  359. /// 否决
  360. /// </summary>
  361. [HttpPost("reject")]
  362. public async Task Reject([FromBody] RejectDto dto)
  363. {
  364. await _workflowApplication.RejectAsync(dto, HttpContext.RequestAborted);
  365. }
  366. // /// <summary>
  367. // /// 补充
  368. // /// </summary>
  369. // /// <param name="dto"></param>
  370. // /// <returns></returns>
  371. // [HttpPost("supplement")]
  372. // public async Task Supplement([FromBody] SupplementDto dto)
  373. // {
  374. // var workflow = await _workflowDomainService.GetWorkflowAsync(dto.WorkflowId);
  375. // await _workflowDomainService.SupplementAsync(workflow, dto, HttpContext.RequestAborted);
  376. // }
  377. /// <summary>
  378. /// 查询办理类型参数
  379. /// </summary>
  380. [HttpGet("handlerclassify/{handlerType}")]
  381. public async Task<List<KeyValuePair<string, string>>> GetHandlerClassifies(EHandlerType handlerType)
  382. {
  383. switch (handlerType)
  384. {
  385. case EHandlerType.Role:
  386. var roles = await _roleRepository.QueryAsync();
  387. return roles.Select(d => new KeyValuePair<string, string>(d.Name, d.DisplayName)).ToList();
  388. case EHandlerType.OrgLevel:
  389. var orgs1 = await _systemDomainService.QueryOrgLevelStringOptionsAsync(HttpContext.RequestAborted);
  390. return orgs1.ToList();
  391. case EHandlerType.OrgType:
  392. return EnumExts.GetDescriptions<EOrgType>()
  393. .Select(d => new KeyValuePair<string, string>(d.Key.ToString(), d.Value)).ToList();
  394. case EHandlerType.AssignedOrg:
  395. var orgs = await _organizeRepository.GetOrgJson();
  396. return orgs.Select(d => new KeyValuePair<string, string>(d.Id, d.Name)).ToList();
  397. case EHandlerType.AssignedUser:
  398. default:
  399. throw new ArgumentOutOfRangeException(nameof(handlerType), handlerType, null);
  400. }
  401. }
  402. /// <summary>
  403. /// 查询流程流转记录
  404. /// </summary>
  405. /// <param name="workflowId"></param>
  406. /// <returns></returns>
  407. [HttpGet("{workflowId}/traces")]
  408. public async Task<WorkflowDto> GetWorkflowTraces(string workflowId)
  409. {
  410. var workflow = await _workflowDomainService.GetWorkflowAsync(workflowId, withTracesTree: true,
  411. cancellationToken: HttpContext.RequestAborted);
  412. workflow.Traces = workflow.Traces.Where(d => d.TraceStyle == ETraceStyle.Flow).Where(d => d.HandleMode != EHandleMode.PreviousNoDisplay).ToList();
  413. var workflowDto = _mapper.Map<WorkflowDto>(workflow);
  414. if (workflowDto.Traces.Any())
  415. {
  416. workflowDto.Traces = await _fileRepository.WorkflowTraceRecursion(workflowDto.Traces, HttpContext.RequestAborted);
  417. }
  418. return workflowDto;
  419. }
  420. /// <summary>
  421. /// 查询被督办/催办部门
  422. /// </summary>
  423. /// <param name="workflowId"></param>
  424. /// <returns></returns>
  425. [HttpGet("{workflowId}/urge")]
  426. public async Task<IReadOnlyList<Kv>> GetUrgeOrgs(string workflowId)
  427. {
  428. /*
  429. * 非会签:当前部门上至一级部门(过期)
  430. * 中心会签:一级部门下至所有当前办理部门(遍历所有会签分支)(过期)
  431. */
  432. var workflow = await _workflowDomainService.GetWorkflowAsync(workflowId, withSteps: true,
  433. cancellationToken: HttpContext.RequestAborted);
  434. //所有节点的待办对象
  435. return workflow.Steps
  436. .Where(d => d.StepType != EStepType.Start && d.StepType != EStepType.End)
  437. .SelectMany(d => d.Handlers)
  438. .DistinctBy(d => d.Key)
  439. .ToList();
  440. }
  441. [HttpGet("base-data")]
  442. public async Task<dynamic> BaseData()
  443. {
  444. var levels = new List<int> { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };
  445. var orgs = levels.Select(d => new KeyValuePair<string, string>(d.ToString(), $"{d.ToChinese()}级部门办理")).ToList();
  446. var center = new KeyValuePair<string, string>("0", "中心办理");
  447. var centerIsTop = new List<KeyValuePair<string, string>> { center };
  448. centerIsTop.AddRange(orgs);
  449. return new
  450. {
  451. ModuleOptions = WorkflowModuleConsts.AllModules.Select(d => new KeyValuePair<string, string>(d.Code, d.Name)),
  452. HandlerTypeOptions = EnumExts.GetDescriptions<EHandlerType>(),
  453. BusinessTypeOptions = EnumExts.GetDescriptions<EBusinessType>(),
  454. StepPropertiesOptions = _systemDicDataCacheManager.GetSysDicDataCache(SysDicTypeConsts.WorkflowStepComponent),
  455. //PathPolicyOptions = EnumExts.GetDescriptions<EPathPolicy>(),
  456. ExecuteModeOptions = EnumExts.GetDescriptions<EExecuteMode>(),
  457. InstanceModeOptions = EnumExts.GetDescriptions<EInstanceMode>(),
  458. StepTypeOptions = EnumExts.GetDescriptions<EStepType>().Where(d => d.Key != 1 && d.Key != 2),
  459. DynamicPolicyOptions = EnumExts.GetDescriptions<EDynamicPolicy>()
  460. .Select(d => new
  461. {
  462. Key = d.Key,
  463. Value = d.Value,
  464. Items = d.Key is 0 or 2 or 4 or 6 ? centerIsTop : orgs
  465. }),
  466. CountersignPolicyOptions = EnumExts.GetDescriptions<ECountersignPolicy>()
  467. .Select(d => new
  468. {
  469. Key = d.Key,
  470. Value = d.Value,
  471. Items = d.Key is 0 or 2 ? centerIsTop : orgs
  472. }),
  473. FlowTypeOptions = EnumExts.GetDescriptions<EFlowType>()
  474. };
  475. }
  476. /// <summary>
  477. /// 查询会签信息
  478. /// </summary>
  479. /// <param name="dto"></param>
  480. /// <returns></returns>
  481. [HttpGet("countersign")]
  482. public async Task<PagedDto<WorkflowCountersignDto>> QueryWorkflowCountersigns([FromQuery] QueryWorkflowCountersignDto dto)
  483. {
  484. RefAsync<int> total = 0;
  485. var query = _workflowCountersignRepository.Queryable()
  486. .Includes(x => x.Members)
  487. .LeftJoin<Workflow>((c, w) => c.WorkflowId == w.Id)
  488. .InnerJoin<Order>((c, w, o) => w.ExternalId == o.Id)
  489. .WhereIF(!_sessionContext.OrgIsCenter, (c, w, o) => c.Members.Any(m => m.Key == _sessionContext.OrgId))
  490. .WhereIF(dto.IsProvince.HasValue, (c, w, o) => o.IsProvince == dto.IsProvince.Value)
  491. .WhereIF(!string.IsNullOrEmpty(dto.Keyword),
  492. (c, w, o) => o.No.Contains(dto.Keyword) || o.Title.Contains(dto.Keyword));
  493. //if (dto.IsOnlyStarter)
  494. // query = query.Where((c, w, o) => c.StarterId == _sessionContext.RequiredUserId);
  495. var items = await query
  496. .OrderByDescending((c, w, o) => o.ExpiredTime)
  497. .Select((c, w, o) => new { c, o })
  498. .ToPageListAsync(dto.PageIndex, dto.PageSize, total, HttpContext.RequestAborted);
  499. var dtos = items.Select(d =>
  500. {
  501. var dto = _mapper.Map<WorkflowCountersignDto>(d.c);
  502. dto.Order = _mapper.Map<OrderDto>(d.o);
  503. return dto;
  504. }).ToList();
  505. return new PagedDto<WorkflowCountersignDto>(total, dtos);
  506. }
  507. /// <summary>
  508. /// 查询会签信息
  509. /// </summary>
  510. /// <param name="dto"></param>
  511. /// <returns></returns>
  512. [HttpGet("order-countersign")]
  513. public async Task<PagedDto<WorkflowCountersignDto>> QueryOrderCountersigns([FromQuery] QueryOrderCountersignDto dto)
  514. {
  515. RefAsync<int> total = 0;
  516. var items = await _workflowApplication.QueryOrderCountersigns(dto, _sessionContext)
  517. .Select((c, w, o) => new { c, o })
  518. .ToPageListAsync(dto.PageIndex, dto.PageSize, total, HttpContext.RequestAborted);
  519. var dtos = items.Select(d =>
  520. {
  521. var dto = _mapper.Map<WorkflowCountersignDto>(d.c);
  522. dto.Order = _mapper.Map<OrderDto>(d.o);
  523. dto.CounterSignCount = _workflowCountersignRepository.Queryable().Where(p => p.WorkflowId == d.c.WorkflowId).CountAsync().GetAwaiter().GetResult();
  524. return dto;
  525. })
  526. .WhereIF(dto.CounterSignCount > 0, d => d.CounterSignCount == dto.CounterSignCount)
  527. .ToList();
  528. return new PagedDto<WorkflowCountersignDto>(total, dtos);
  529. }
  530. /// <summary>
  531. /// 会签信息导出
  532. /// </summary>
  533. /// <returns></returns>
  534. [HttpPost("order-countersign/_export")]
  535. public async Task<FileStreamResult> ScreenListExport([FromBody] ExportExcelDto<QueryOrderCountersignDto> dto)
  536. {
  537. var query = _workflowApplication.QueryOrderCountersigns(dto.QueryDto, _sessionContext)
  538. .Select((c, w, o) => new WorkflowCountersign()
  539. {
  540. Id = c.Id.SelectAll(),
  541. Order = o,
  542. });
  543. List<WorkflowCountersign> data;
  544. if (dto.IsExportAll)
  545. {
  546. data = await query.ToListAsync(HttpContext.RequestAborted);
  547. }
  548. else
  549. {
  550. var (_, items) = await query.ToPagedListAsync(dto.QueryDto, HttpContext.RequestAborted);
  551. data = items;
  552. }
  553. var dataDtos = _mapper.Map<ICollection<WorkflowCountersignDto>>(data);
  554. dynamic? dynamicClass = DynamicClassHelper.CreateDynamicClass<WorkflowCountersignDto>(dto.ColumnInfos);
  555. var dtos = dataDtos
  556. .Select(stu => _mapper.Map(stu, typeof(WorkflowCountersignDto), dynamicClass))
  557. .Cast<object>()
  558. .ToList();
  559. var stream = ExcelHelper.CreateStream(dtos);
  560. return ExcelStreamResult(stream, "会签信息数据");
  561. }
  562. /// <summary>
  563. ///
  564. /// </summary>
  565. /// <returns></returns>
  566. [HttpGet("order-countersign-base-data")]
  567. public async Task<object> QueryOrderCountersignsBaseData()
  568. {
  569. return new
  570. {
  571. CounterSignType = EnumExts.GetDescriptions<ECounterSignType>(),
  572. ChannelOptions = _sysDicDataCacheManager.GetSysDicDataCache(TimeLimitBaseDataConsts.SourceChannel),
  573. AcceptTypeOptions = _sysDicDataCacheManager.GetSysDicDataCache(SysDicTypeConsts.AcceptType),
  574. OrderStatus = EnumExts.GetDescriptions<EOrderStatus>(),
  575. };
  576. }
  577. /// <summary>
  578. /// 改变某节点办理人
  579. /// </summary>
  580. [HttpPost("change-handler")]
  581. public async Task ChangeHandler([FromBody] ChangeHandlerDto dto)
  582. {
  583. var step = await _workflowStepRepository.Queryable()
  584. .Includes(d => d.WorkflowTrace)
  585. .FirstAsync(d => d.Id == dto.StepId, HttpContext.RequestAborted);
  586. //.GetAsync(dto.StepId, HttpContext.RequestAborted);
  587. if (step is null)
  588. throw new UserFriendlyException("无效节点编号");
  589. await _workflowDomainService.ChangeHandlerBatchAsync(new List<(string userId, string username, string orgId, string orgName, string? roleId, string? roleName, ICollection<WorkflowStep> steps)>
  590. {
  591. new(dto.Handler.UserId,dto.Handler.Username,dto.Handler.OrgId,dto.Handler.OrgName,step.RoleId,step.RoleName, new List<WorkflowStep>{step})
  592. }, HttpContext.RequestAborted);
  593. }
  594. #endregion
  595. }