TApproveMaintenanceController.java 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378
  1. package com.ruoyi.project.intact.controller;
  2. import java.text.SimpleDateFormat;
  3. import java.util.*;
  4. import com.alibaba.fastjson.JSON;
  5. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  6. import com.ruoyi.common.utils.StringUtils;
  7. import com.ruoyi.project.approve.damain.DevTask;
  8. import com.ruoyi.project.intact.domain.*;
  9. import com.ruoyi.project.intact.mapper.TApproveMaintenanceMapper;
  10. import com.ruoyi.project.intact.service.*;
  11. import com.ruoyi.project.sems.domain.*;
  12. import com.ruoyi.project.sems.his.domain.*;
  13. import com.ruoyi.project.system.domain.SysUser;
  14. import com.ruoyi.project.system.service.ISysUserService;
  15. import org.activiti.engine.*;
  16. import org.activiti.engine.impl.identity.Authentication;
  17. import org.activiti.engine.runtime.ProcessInstance;
  18. import org.activiti.engine.task.Task;
  19. import org.apache.poi.ss.formula.functions.T;
  20. import org.springframework.security.access.prepost.PreAuthorize;
  21. import org.springframework.beans.factory.annotation.Autowired;
  22. import org.springframework.web.bind.annotation.*;
  23. import com.ruoyi.framework.aspectj.lang.annotation.Log;
  24. import com.ruoyi.framework.aspectj.lang.enums.BusinessType;
  25. import com.ruoyi.framework.web.controller.BaseController;
  26. import com.ruoyi.framework.web.domain.AjaxResult;
  27. import com.ruoyi.common.utils.poi.ExcelUtil;
  28. import com.ruoyi.framework.web.page.TableDataInfo;
  29. /**
  30. * 设备完整性维修申请Controller
  31. *
  32. * @author ruoyi
  33. * @date 2022-06-27
  34. */
  35. @RestController
  36. @RequestMapping("/intact/maintenance")
  37. public class TApproveMaintenanceController extends BaseController
  38. {
  39. @Autowired
  40. private ITApproveMaintenanceService tApproveMaintenanceService;
  41. @Autowired
  42. private TApproveMaintenanceMapper maintenanceMapper;
  43. @Autowired
  44. private RuntimeService runtimeService;
  45. @Autowired
  46. private HistoryService historyService;
  47. @Autowired
  48. private TaskService taskService;
  49. @Autowired
  50. private ITIntactGylService gylService;
  51. @Autowired
  52. private ITIntactYsjService ysjService;
  53. @Autowired
  54. private ITIntactGjService gjService;
  55. @Autowired
  56. private ITIntactPumpService pumpService;
  57. @Autowired
  58. private ISysUserService sysUserService;
  59. @RequestMapping("/hisApprovelist")
  60. public AjaxResult hisApprovelist(@RequestParam Map<String, Object> params) {
  61. String sql = params.get("devId") + " in (SELECT REGEXP_SUBSTR (DEV_ID, '[^,]+', 1,rownum) from dual connect by rownum<=LENGTH (DEV_ID) - LENGTH (regexp_replace(DEV_ID, ',', ''))+1 ) ";
  62. if (StringUtils.isNotEmpty((String) params.get("devType"))){
  63. sql+=" and dev_type="+params.get("devType")+" ";
  64. }
  65. if (StringUtils.isNotEmpty((String) params.get("createyear"))){
  66. sql+=" and to_char(creattime,'yyyy')= "+params.get("createyear")+" ";
  67. }
  68. List<TApproveMaintenance> list = maintenanceMapper.selectList(new QueryWrapper<TApproveMaintenance>().apply(sql).orderByDesc("CREATTIME")
  69. );
  70. for (TApproveMaintenance t : list
  71. ) {
  72. SysUser userEntity = sysUserService.selectUserById(t.getUserId());
  73. t.setUserName(userEntity.getNickName());
  74. }
  75. return AjaxResult.success(list);
  76. }
  77. /**
  78. * 查询设备完整性维修申请列表
  79. */
  80. @PreAuthorize("@ss.hasPermi('intact:maintenance:list')")
  81. @GetMapping("/list")
  82. public TableDataInfo list(TApproveMaintenance tApproveMaintenance)
  83. {
  84. startPage();
  85. List<TApproveMaintenance> list = tApproveMaintenanceService.selectTApproveMaintenanceList(tApproveMaintenance);
  86. for (TApproveMaintenance tApprove : list) {
  87. String[] ids;
  88. ids = tApprove.getDevId().split(",");
  89. List<Object> devList = new ArrayList<>();
  90. switch (Integer.parseInt(tApprove.getDevType().toString())) {
  91. case 1:
  92. for (String i : ids
  93. ) {
  94. TIntactGyl gylEntity = gylService.getById(i);
  95. devList.add(gylEntity);
  96. }
  97. break;
  98. case 2:
  99. for (String i : ids
  100. ) {
  101. TIntactYsj ysjEntity = ysjService.getById(i);
  102. devList.add(ysjEntity);
  103. }
  104. break;
  105. case 3:
  106. for (String i : ids
  107. ) {
  108. TIntactGj gjEntity = gjService.getById(i);
  109. devList.add(gjEntity);
  110. }
  111. break;
  112. case 4:
  113. for (String i : ids
  114. ) {
  115. TIntactPump pumpEntity = pumpService.getById(i);
  116. devList.add(pumpEntity);
  117. }
  118. break;
  119. default:
  120. break;
  121. }
  122. tApprove.setDevList(devList);
  123. }
  124. return getDataTable(list);
  125. }
  126. /**
  127. * 导出设备完整性维修申请列表
  128. */
  129. @PreAuthorize("@ss.hasPermi('intact:maintenance:export')")
  130. @Log(title = "设备完整性维修申请", businessType = BusinessType.EXPORT)
  131. @GetMapping("/export")
  132. public AjaxResult export(TApproveMaintenance tApproveMaintenance)
  133. {
  134. List<TApproveMaintenance> list = tApproveMaintenanceService.selectTApproveMaintenanceList(tApproveMaintenance);
  135. ExcelUtil<TApproveMaintenance> util = new ExcelUtil<TApproveMaintenance>(TApproveMaintenance.class);
  136. return util.exportExcel(list, "maintenance");
  137. }
  138. /**
  139. * 获取设备完整性维修申请详细信息
  140. */
  141. @PreAuthorize("@ss.hasPermi('intact:maintenance:query')")
  142. @GetMapping(value = "/{id}")
  143. public AjaxResult getInfo(@PathVariable("id") Long id)
  144. {
  145. return AjaxResult.success(tApproveMaintenanceService.selectTApproveMaintenanceById(id));
  146. }
  147. /**
  148. * 获取特种设备变更申请详细信息
  149. */
  150. @GetMapping(value = "info/{id}")
  151. public AjaxResult info(@PathVariable("id") Long id)
  152. {
  153. TApproveMaintenance tApprove = tApproveMaintenanceService.selectTApproveMaintenanceById(id);
  154. String[] ids;
  155. ids = tApprove.getDevId().split(",");
  156. List<Object> devList = new ArrayList<>();
  157. switch (Integer.parseInt(tApprove.getDevType().toString())) {
  158. case 1:
  159. for (String i : ids
  160. ) {
  161. TIntactGyl gylEntity = gylService.getById(i);
  162. devList.add(gylEntity);
  163. }
  164. break;
  165. case 2:
  166. for (String i : ids
  167. ) {
  168. TIntactYsj ysjEntity = ysjService.getById(i);
  169. devList.add(ysjEntity);
  170. }
  171. break;
  172. case 3:
  173. for (String i : ids
  174. ) {
  175. TIntactGj gjEntity = gjService.getById(i);
  176. devList.add(gjEntity);
  177. }
  178. break;
  179. case 4:
  180. for (String i : ids
  181. ) {
  182. TIntactPump pumpEntity = pumpService.getById(i);
  183. devList.add(pumpEntity);
  184. }
  185. break;
  186. default:
  187. break;
  188. }
  189. tApprove.setDevList(devList);
  190. return AjaxResult.success(tApprove);
  191. }
  192. /**
  193. * 新增设备完整性维修申请
  194. */
  195. // @PreAuthorize("@ss.hasPermi('intact:maintenance:add')")
  196. @Log(title = "设备完整性维修申请", businessType = BusinessType.INSERT)
  197. @PostMapping
  198. public AjaxResult add(@RequestBody TApproveMaintenance tApproveMaintenance)
  199. {
  200. Long userid = getUserId();
  201. tApproveMaintenance.setUserId(userid);
  202. // tApproveSpecModify.setApNo(tApproveSpecModify.getHisId().toString());
  203. //审批编号
  204. Date dt = new Date();
  205. SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddhhmmss");
  206. String data = sdf.format(dt) + userid;
  207. tApproveMaintenance.setApNo(data);
  208. //
  209. Authentication.setAuthenticatedUserId(userid.toString());
  210. tApproveMaintenanceService.insertTApproveMaintenance(tApproveMaintenance);
  211. long bussniseeKey = tApproveMaintenance.getId();
  212. String[] ids;
  213. ids = tApproveMaintenance.getDevId().split(",");
  214. switch (Integer.parseInt(tApproveMaintenance.getDevType().toString())){
  215. case 1:
  216. for (String i : ids
  217. ) {
  218. TIntactGyl gylEntity = gylService.getById(i);
  219. // gylEntity.setApproveStatus(tApproveMaintenance.getApproveType()+ 19);
  220. gylEntity.setApproveTime(new Date());
  221. gylService.updateById(gylEntity);
  222. }
  223. break;
  224. case 2:
  225. for (String i : ids
  226. ) {
  227. TIntactYsj ysjEntity = ysjService.getById(i);
  228. // ylgdEntity.setApproveStatus(tApproveSpecModify.getApproveType() + 19);
  229. ysjEntity.setApproveTime(new Date());
  230. ysjService.updateById(ysjEntity);
  231. }
  232. break;
  233. case 3:
  234. for (String i : ids
  235. ) {
  236. TIntactGj gjEntity = gjService.getById(i);
  237. // gjEntity.setApproveStatus(tApproveMaintenance.getApproveType()+ 19);
  238. gjEntity.setApproveTime(new Date());
  239. gjService.updateById(gjEntity);
  240. }
  241. break;
  242. case 4:
  243. for (String i : ids
  244. ) {
  245. TIntactPump pumpEntity = pumpService.getById(i);
  246. // pumpEntity.setApproveStatus(t.getApproveType()+ 19);
  247. pumpEntity.setApproveTime(new Date());
  248. pumpService.updateById(pumpEntity);
  249. }
  250. break;
  251. default:
  252. break;
  253. }
  254. //开始工作流、监听
  255. Map<String, Object> variables = new HashMap<>();
  256. variables.put("applyUser", userid.toString());
  257. variables.put("wxjlusers", tApproveMaintenance.getWxjl());
  258. //采用key来启动流程定义并设置流程变量,返回流程实例
  259. ProcessInstance pi = runtimeService.startProcessInstanceByKey("maintenance", String.valueOf(bussniseeKey), variables);
  260. logger.info("流程部署id:" + pi.getDeploymentId());
  261. logger.info("流程定义id:" + pi.getProcessDefinitionId());
  262. logger.info("流程实例id:" + pi.getProcessInstanceId());
  263. tApproveMaintenance.setProcessId(pi.getProcessInstanceId());
  264. tApproveMaintenanceService.updateTApproveMaintenance(tApproveMaintenance);
  265. return AjaxResult.success();
  266. }
  267. @Log(title = "设备完整性维修审核处理", businessType = BusinessType.UPDATE)
  268. @PutMapping("/handle")
  269. public AjaxResult handle(@RequestBody DevTask devTask) {
  270. //流程审批意见
  271. String symbol= "";
  272. if (devTask.getComment() != "") {
  273. symbol = ",";
  274. }
  275. //使用任务服务完成任务(提交任务)
  276. String taskId = devTask.getTaskId();
  277. // 使用任务id,获取任务对象,获取流程实例id
  278. Task task = taskService.createTaskQuery().taskId(taskId).singleResult();
  279. //利用任务对象,获取流程实例id
  280. String processInstancesId = task.getProcessInstanceId();
  281. TApproveMaintenance tApproveMaintenance = tApproveMaintenanceService.selectTApproveMaintenanceById(Long.parseLong(devTask.getBusinessKey()));
  282. if (devTask.getCondition().equals("1")) {
  283. devTask.setComment("通过" + symbol + devTask.getComment());
  284. tApproveMaintenance.setStatus(1L);
  285. tApproveMaintenance.setEnddate(new Date());
  286. }else if (devTask.getCondition().equals("0")) {
  287. devTask.setComment("未通过" + symbol + devTask.getComment());
  288. tApproveMaintenance.setStatus(2L);
  289. tApproveMaintenance.setEnddate(new Date());
  290. }
  291. String[] ids;
  292. ids = tApproveMaintenance.getDevId().split(",");
  293. switch (Integer.parseInt(tApproveMaintenance.getDevType().toString())){
  294. case 1://修改工业炉台账
  295. for (String i : ids
  296. ) {
  297. TIntactGyl gylEntity = gylService.getById(i);
  298. gylEntity.setApproveStatus(0L);
  299. gylService.updateById(gylEntity);
  300. tApproveMaintenanceService.updateTApproveMaintenance(tApproveMaintenance);
  301. }
  302. break;
  303. case 2://修改压缩机台账
  304. for (String i : ids
  305. ) {
  306. TIntactYsj ysjEntity = ysjService.getById(i);
  307. ysjEntity.setApproveStatus(0L);
  308. ysjService.updateById(ysjEntity);
  309. tApproveMaintenanceService.updateTApproveMaintenance(tApproveMaintenance);
  310. }
  311. break;
  312. case 3:
  313. for (String i : ids
  314. ) {
  315. TIntactGj gjEntity = gjService.getById(i);
  316. gjEntity.setApproveStatus(0L);
  317. gjService.updateById(gjEntity);
  318. tApproveMaintenanceService.updateTApproveMaintenance(tApproveMaintenance);
  319. }
  320. break;
  321. case 4:
  322. for (String i : ids
  323. ) {
  324. TIntactPump pumpEntity = pumpService.getById(i);
  325. pumpEntity.setApproveStatus(0L);
  326. pumpService.updateById(pumpEntity);
  327. tApproveMaintenanceService.updateTApproveMaintenance(tApproveMaintenance);
  328. }
  329. break;
  330. default:
  331. break;
  332. }
  333. Map<String, Object> param = new HashMap<>();
  334. param.put("condition", devTask.getCondition());
  335. ProcessEngine processEngine = ProcessEngines.getDefaultProcessEngine();
  336. TaskService taskService = processEngine.getTaskService();
  337. //认领任务
  338. processEngine.getTaskService()
  339. .claim(taskId, getUserId().toString());
  340. taskService.addComment(taskId, processInstancesId, devTask.getComment());
  341. taskService.complete(taskId, param);
  342. return AjaxResult.success();
  343. }
  344. /**
  345. * 修改设备完整性维修申请
  346. */
  347. @PreAuthorize("@ss.hasPermi('intact:maintenance:edit')")
  348. @Log(title = "设备完整性维修申请", businessType = BusinessType.UPDATE)
  349. @PutMapping
  350. public AjaxResult edit(@RequestBody TApproveMaintenance tApproveMaintenance)
  351. {
  352. return toAjax(tApproveMaintenanceService.updateTApproveMaintenance(tApproveMaintenance));
  353. }
  354. /**
  355. * 删除设备完整性维修申请
  356. */
  357. @PreAuthorize("@ss.hasPermi('intact:maintenance:remove')")
  358. @Log(title = "设备完整性维修申请", businessType = BusinessType.DELETE)
  359. @DeleteMapping("/{ids}")
  360. public AjaxResult remove(@PathVariable Long[] ids)
  361. {
  362. return toAjax(tApproveMaintenanceService.deleteTApproveMaintenanceByIds(ids));
  363. }
  364. }