TTrainingbccRegularController.java 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449
  1. package com.ruoyi.project.training.controller;
  2. import java.time.LocalDate;
  3. import java.util.*;
  4. import com.ruoyi.framework.interceptor.annotation.RepeatSubmit;
  5. import com.ruoyi.project.plant.domain.TStaffmgr;
  6. import com.ruoyi.project.plant.service.ITStaffmgrService;
  7. import com.ruoyi.project.system.domain.SysDictData;
  8. import com.ruoyi.project.system.service.ISysDictTypeService;
  9. import com.ruoyi.project.training.domain.*;
  10. import com.ruoyi.project.training.mapper.TTrainingbccRegularMapper;
  11. import com.ruoyi.project.training.service.*;
  12. import org.apache.commons.lang.StringUtils;
  13. import org.springframework.security.access.prepost.PreAuthorize;
  14. import org.springframework.beans.factory.annotation.Autowired;
  15. import org.springframework.web.bind.annotation.GetMapping;
  16. import org.springframework.web.bind.annotation.PostMapping;
  17. import org.springframework.web.bind.annotation.PutMapping;
  18. import org.springframework.web.bind.annotation.DeleteMapping;
  19. import org.springframework.web.bind.annotation.PathVariable;
  20. import org.springframework.web.bind.annotation.RequestBody;
  21. import org.springframework.web.bind.annotation.RequestMapping;
  22. import org.springframework.web.bind.annotation.RestController;
  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. import javax.annotation.Resource;
  30. /**
  31. * 装置培训计划Controller
  32. *
  33. * @author ssy
  34. * @date 2024-06-24
  35. */
  36. @RestController
  37. @RequestMapping("/training/bccregular")
  38. public class TTrainingbccRegularController extends BaseController
  39. {
  40. @Autowired
  41. private ITTrainingbccRegularService tTrainingbccRegularService;
  42. @Autowired
  43. private ISysDictTypeService iSysDictTypeService;
  44. @Autowired
  45. private ITTrainingbccService trainingbccService;
  46. @Autowired
  47. private ITTrainingbccDeviceService trainingbccDeviceService;
  48. @Autowired
  49. private ITTrainingMatrixService tTrainingMatrixService;
  50. @Autowired
  51. private ITStaffmgrService tStaffmgrService;
  52. @Resource
  53. private TTrainingbccRegularMapper tTrainingbccRegularMapper;
  54. /**
  55. * 查询装置培训计划列表
  56. */
  57. @PreAuthorize("@ss.hasPermi('training:bccregular:list')")
  58. @GetMapping("/list")
  59. public TableDataInfo list(TTrainingbccRegular tTrainingRegular)
  60. {
  61. startPage();
  62. List<TTrainingbccRegular> list = tTrainingbccRegularService.selectTTrainingbccRegularList(tTrainingRegular);
  63. List<SysDictData> actualpost = iSysDictTypeService.selectDictDataByType("ACTUALPOST");
  64. for (TTrainingbccRegular t : list) {
  65. String[] actualpostId = new String[0];
  66. if (t.getActualpostId() != null) {
  67. actualpostId = t.getActualpostId().split(",");
  68. }
  69. List<String> postStatu = new ArrayList<>();
  70. for (SysDictData p : actualpost) {
  71. int i = 0;
  72. for (String a : actualpostId) {
  73. if (p.getDictValue().equals(a)) {
  74. i = 1;
  75. }
  76. }
  77. if (t.getDesignatedPosition() != null) {
  78. String[] designatedPosition = t.getDesignatedPosition().split(",");
  79. for (String d : designatedPosition) {
  80. if (p.getDictValue().equals(d)) {
  81. i = 2;
  82. }
  83. }
  84. }
  85. if (i == 1) {
  86. postStatu.add("M");
  87. }else if (i == 2) {
  88. postStatu.add("|");
  89. }else {
  90. postStatu.add("-");
  91. }
  92. }
  93. if (t.getInvolvedMoc().equals("true")) {
  94. if (t.getDesignatedOther() != null) {
  95. String[] designatedOther = t.getDesignatedOther().split(",");
  96. for (String d : designatedOther) {
  97. if (d.equals("28")) {
  98. postStatu.set(postStatu.size() - 5, "(M)");
  99. }
  100. if (d.equals("30")) {
  101. postStatu.set(postStatu.size() - 4, "(M)");
  102. }
  103. if (d.equals("32")) {
  104. postStatu.set(postStatu.size() - 3, "(M)");
  105. }
  106. }
  107. }
  108. }
  109. t.setActualpost(postStatu);
  110. }
  111. return getDataTable(list);
  112. }
  113. @PreAuthorize("@ss.hasPermi('training:bccregular:list')")
  114. @GetMapping("/listNew")
  115. public TableDataInfo listNew(TTrainingbccRegular tTrainingRegular)
  116. {
  117. startPage();
  118. List<TTrainingbccRegular> list = tTrainingbccRegularMapper.selectTTrainingbccRegularListNew(tTrainingRegular);
  119. for (TTrainingbccRegular t : list) {
  120. TStaffmgr staffmgr = tStaffmgrService.selectTStaffmgrByStaffId(t.getNewStaff());
  121. t.setNewStaffName(staffmgr.getName());
  122. }
  123. return getDataTable(list);
  124. }
  125. /**
  126. * 导出装置培训计划列表
  127. */
  128. @PreAuthorize("@ss.hasPermi('training:bccregular:export')")
  129. @Log(title = "装置培训计划", businessType = BusinessType.EXPORT)
  130. @GetMapping("/export")
  131. public AjaxResult export(TTrainingbccRegular tTrainingbccRegular)
  132. {
  133. List<TTrainingbccRegular> list = tTrainingbccRegularService.selectTTrainingbccRegularList(tTrainingbccRegular);
  134. ExcelUtil<TTrainingbccRegular> util = new ExcelUtil<TTrainingbccRegular>(TTrainingbccRegular.class);
  135. return util.exportExcel(list, "bccregular");
  136. }
  137. /**
  138. * 获取装置培训计划详细信息
  139. */
  140. @PreAuthorize("@ss.hasPermi('training:bccregular:query')")
  141. @GetMapping(value = "/{id}")
  142. public AjaxResult getInfo(@PathVariable("id") Long id)
  143. {
  144. return AjaxResult.success(tTrainingbccRegularService.selectTTrainingbccRegularById(id));
  145. }
  146. /**
  147. * 新增装置培训计划
  148. */
  149. @PreAuthorize("@ss.hasPermi('training:bccregular:add')")
  150. @Log(title = "装置培训计划", businessType = BusinessType.INSERT)
  151. @PostMapping
  152. public AjaxResult add(@RequestBody TTrainingbccRegular tTrainingRegular)
  153. {
  154. int doInsert = tTrainingbccRegularService.insertTTrainingbccRegular(tTrainingRegular);
  155. logger.info("regular:" + tTrainingRegular);
  156. tTrainingRegular.setDeptId(103l); //bcc专用
  157. //如果确定计划日期新增关联内容
  158. if (tTrainingRegular.getNotPlan().equals("true")) {
  159. //新增培训计划定期类
  160. TTrainingbcc tTraining = new TTrainingbcc();
  161. tTraining.setTrainingType("10");
  162. tTraining.setYears(tTrainingRegular.getYear());
  163. tTraining.setCourse(tTrainingRegular.getItem());
  164. tTraining.setCourseid(tTrainingRegular.getCourseCode());
  165. tTraining.setDuration(tTrainingRegular.getHour());
  166. tTraining.setTrainer(tTrainingRegular.getLecturer());
  167. tTraining.setPosition(tTrainingRegular.getActualpostId());
  168. tTraining.setIsfinish(Long.parseLong("0"));
  169. tTraining.setDeptId(tTrainingRegular.getDeptId());
  170. tTraining.setRegularId(tTrainingRegular.getId());
  171. trainingbccService.insertTTrainingbcc(tTraining);
  172. Long trainingId = tTraining.getId();
  173. //新增人员-装置级关系
  174. // 参培岗位人员
  175. if (tTrainingRegular.getActualpostId() != null) {
  176. logger.info("参培岗位人员");
  177. TStaffmgr staffmgr = new TStaffmgr();
  178. staffmgr.setActualposts(tTrainingRegular.getActualpostId());
  179. staffmgr.setDeptId(tTrainingRegular.getDeptId());
  180. List<TStaffmgr> staffmgrs = tStaffmgrService.selectAllTStaffmgrList(staffmgr);
  181. try {
  182. //判断离职
  183. if (!StringUtils.isEmpty(tTrainingRegular.getYear())) {
  184. Iterator<TStaffmgr> iterator = staffmgrs.iterator();
  185. while (iterator.hasNext()) {
  186. TStaffmgr t = iterator.next();
  187. if (t.getLeftDate() != null && t.getDelFlag() == 9){
  188. if (t.getLeftDate().getTime() - tTrainingRegular.getPlanTrainingdate().getTime() < 0l ) {
  189. logger.debug(t.getName() + "离职时间小于培训时间");
  190. iterator.remove();
  191. }
  192. }
  193. }
  194. }
  195. }catch (Exception e) {
  196. logger.error(e.toString());
  197. }
  198. for (TStaffmgr s : staffmgrs) {
  199. TTrainingbccDevice tTrainingDevice = new TTrainingbccDevice();
  200. tTrainingDevice.setStaffId(s.getStaffid());
  201. tTrainingDevice.setRegularId(trainingId);
  202. tTrainingDevice.setStartDate(tTrainingRegular.getPlanTrainingdate());
  203. tTrainingDevice.setSupplementary("0");
  204. trainingbccDeviceService.insertTTrainingbccDevice(tTrainingDevice);
  205. }
  206. }
  207. //指定岗位人员
  208. if (tTrainingRegular.getDesignatedStaff() != null) {
  209. logger.info("指定岗位人员");
  210. String[] designatedStaffs = tTrainingRegular.getDesignatedStaff().split(",");
  211. for (String staffId : designatedStaffs) {
  212. TTrainingbccDevice tTrainingDevice = new TTrainingbccDevice();
  213. tTrainingDevice.setStaffId(staffId);
  214. tTrainingDevice.setRegularId(trainingId);
  215. tTrainingDevice.setStartDate(tTrainingRegular.getPlanTrainingdate());
  216. tTrainingDevice.setSupplementary("0");
  217. trainingbccDeviceService.insertTTrainingbccDevice(tTrainingDevice);
  218. }
  219. }
  220. //涉及其他部门
  221. if (tTrainingRegular.getInvolvedMoc().equals("true")){
  222. logger.info("涉及MOC人员");
  223. TStaffmgr staffmgrMoc = new TStaffmgr();
  224. staffmgrMoc.setActualposts(tTrainingRegular.getDesignatedOther());
  225. List<TStaffmgr> staffmgrsMoc = tStaffmgrService.selectAllTStaffmgrList(staffmgrMoc);
  226. try {
  227. //判断离职
  228. if (!StringUtils.isEmpty(tTrainingRegular.getYear())) {
  229. Iterator<TStaffmgr> iterator = staffmgrsMoc.iterator();
  230. while (iterator.hasNext()) {
  231. TStaffmgr t = iterator.next();
  232. if (t.getLeftDate() != null && t.getDelFlag() == 9){
  233. if (t.getLeftDate().getTime() - tTrainingRegular.getPlanTrainingdate().getTime() > 0l ) {
  234. logger.debug(t.getName() + "离职时间小于培训时间");
  235. iterator.remove();
  236. }
  237. }
  238. }
  239. }
  240. }catch (Exception e) {
  241. logger.error(e.toString());
  242. }
  243. for (TStaffmgr s : staffmgrsMoc) {
  244. TTrainingbccDevice tTrainingDevice = new TTrainingbccDevice();
  245. tTrainingDevice.setStaffId(s.getStaffid());
  246. tTrainingDevice.setRegularId(trainingId);
  247. tTrainingDevice.setStartDate(tTrainingRegular.getPlanTrainingdate());
  248. tTrainingDevice.setSupplementary("0");
  249. trainingbccDeviceService.insertTTrainingbccDevice(tTrainingDevice);
  250. }
  251. }
  252. }
  253. return toAjax(doInsert);
  254. }
  255. /**
  256. * 新增装置培训计划
  257. */
  258. @PreAuthorize("@ss.hasPermi('training:bccregular:add')")
  259. @Log(title = "装置培训计划", businessType = BusinessType.INSERT)
  260. @GetMapping("batchAddTraining")
  261. @RepeatSubmit
  262. public AjaxResult addBatch() {
  263. TTrainingbccRegular tr =new TTrainingbccRegular();
  264. TTrainingMatrix tTrainingMatrix = new TTrainingMatrix();
  265. tTrainingMatrix.setDeptId(103l);
  266. tTrainingMatrix.setTrainingLevel("14");
  267. List<TTrainingMatrix> list = tTrainingMatrixService.selectTTrainingMatrixList(tTrainingMatrix);
  268. logger.info("===========" + list.size() + "");
  269. int currentYear = LocalDate.now().getYear();
  270. int resNum = 0;
  271. for (TTrainingMatrix matrix: list
  272. ) {
  273. int addFlag = 0;
  274. if ("每年一次".equals(matrix.getFrequency()) || "每年至少一次".equals(matrix.getFrequency())) {
  275. tr.setYear(String.valueOf(currentYear));
  276. tr.setItem(matrix.getItem());
  277. List<TTrainingbccRegular> regulars = tTrainingbccRegularService.selectTTrainingbccRegularList(tr);
  278. if (regulars.size() == 0) {
  279. addFlag = 1;
  280. }
  281. }
  282. if ("每年两次".equals(matrix.getFrequency()) || "每年2次".equals(matrix.getFrequency())) {
  283. tr.setYear(String.valueOf(currentYear));
  284. tr.setItem(matrix.getItem());
  285. List<TTrainingbccRegular> regulars = tTrainingbccRegularService.selectTTrainingbccRegularList(tr);
  286. if (regulars.size() < 2) {
  287. addFlag = 1;
  288. }
  289. }
  290. if ("每月一次".equals(matrix.getFrequency()) ) {
  291. tr.setYear(String.valueOf(currentYear));
  292. tr.setItem(matrix.getItem());
  293. List<TTrainingbccRegular> regulars0 = tTrainingbccRegularService.selectTTrainingbccRegularList(tr);
  294. tr.setPlanTrainingdate(new Date());
  295. List<TTrainingbccRegular> regulars = tTrainingbccRegularService.selectTTrainingbccRegularList(tr);
  296. if (regulars.size() == 0) {
  297. addFlag = 1;
  298. }
  299. if (regulars0.size() >= LocalDate.now().getMonthValue()) { //数量够了不需要增加了
  300. addFlag = 0;
  301. }
  302. }
  303. if (addFlag == 1) {
  304. TTrainingbccRegular tTrainingRegular = new TTrainingbccRegular();
  305. tTrainingRegular.setDeptId(matrix.getDeptId());
  306. tTrainingRegular.setActualpostId(matrix.getActualpostId());
  307. tTrainingRegular.setCourseCode(matrix.getCourseCode());
  308. tTrainingRegular.setItem(matrix.getItem());
  309. tTrainingRegular.setHour(matrix.getHour());
  310. tTrainingRegular.setInvolvedMoc("false");
  311. tTrainingRegular.setNotPlan("false");
  312. tTrainingRegular.setYear(String.valueOf(currentYear));
  313. int doInsert = tTrainingbccRegularService.insertTTrainingbccRegular(tTrainingRegular);
  314. logger.info("regular:" + tTrainingRegular);
  315. tTrainingRegular.setDeptId(103l); //bcc专用
  316. //新增培训计划定期类
  317. TTrainingbcc tTraining = new TTrainingbcc();
  318. tTraining.setTrainingType("10");
  319. tTraining.setYears(tTrainingRegular.getYear());
  320. tTraining.setCourse(tTrainingRegular.getItem());
  321. tTraining.setCourseid(tTrainingRegular.getCourseCode());
  322. tTraining.setDuration(tTrainingRegular.getHour());
  323. tTraining.setTrainer(tTrainingRegular.getLecturer());
  324. tTraining.setPosition(tTrainingRegular.getActualpostId());
  325. tTraining.setIsfinish(Long.parseLong("0"));
  326. tTraining.setDeptId(tTrainingRegular.getDeptId());
  327. tTraining.setRegularId(tTrainingRegular.getId());
  328. trainingbccService.insertTTrainingbcc(tTraining);
  329. Long trainingId = tTraining.getId();
  330. //新增人员-装置级关系
  331. // 参培岗位人员
  332. if (tTrainingRegular.getActualpostId() != null) {
  333. logger.info("参培岗位人员");
  334. TStaffmgr staffmgr = new TStaffmgr();
  335. staffmgr.setActualposts(tTrainingRegular.getActualpostId());
  336. staffmgr.setDeptId(tTrainingRegular.getDeptId());
  337. List<TStaffmgr> staffmgrs = tStaffmgrService.selectAllTStaffmgrList(staffmgr);
  338. try {
  339. //判断离职
  340. if (!StringUtils.isEmpty(tTrainingRegular.getYear())) {
  341. Iterator<TStaffmgr> iterator = staffmgrs.iterator();
  342. while (iterator.hasNext()) {
  343. TStaffmgr t = iterator.next();
  344. if (t.getLeftDate() != null && t.getDelFlag() == 9){
  345. if (t.getLeftDate().getTime() - tTrainingRegular.getPlanTrainingdate().getTime() < 0l ) {
  346. logger.debug(t.getName() + "离职时间小于培训时间");
  347. iterator.remove();
  348. }
  349. }
  350. }
  351. }
  352. }catch (Exception e) {
  353. logger.error(e.toString());
  354. }
  355. for (TStaffmgr s : staffmgrs) {
  356. TTrainingbccDevice tTrainingDevice = new TTrainingbccDevice();
  357. tTrainingDevice.setStaffId(s.getStaffid());
  358. tTrainingDevice.setRegularId(trainingId);
  359. tTrainingDevice.setStartDate(tTrainingRegular.getPlanTrainingdate());
  360. tTrainingDevice.setSupplementary("0");
  361. trainingbccDeviceService.insertTTrainingbccDevice(tTrainingDevice);
  362. }
  363. }
  364. //指定岗位人员
  365. if (tTrainingRegular.getDesignatedStaff() != null) {
  366. logger.info("指定岗位人员");
  367. String[] designatedStaffs = tTrainingRegular.getDesignatedStaff().split(",");
  368. for (String staffId : designatedStaffs) {
  369. TTrainingbccDevice tTrainingDevice = new TTrainingbccDevice();
  370. tTrainingDevice.setStaffId(staffId);
  371. tTrainingDevice.setRegularId(trainingId);
  372. tTrainingDevice.setStartDate(tTrainingRegular.getPlanTrainingdate());
  373. tTrainingDevice.setSupplementary("0");
  374. trainingbccDeviceService.insertTTrainingbccDevice(tTrainingDevice);
  375. }
  376. }
  377. //涉及其他部门
  378. if (tTrainingRegular.getInvolvedMoc().equals("true")){
  379. logger.info("涉及MOC人员");
  380. TStaffmgr staffmgrMoc = new TStaffmgr();
  381. staffmgrMoc.setActualposts(tTrainingRegular.getDesignatedOther());
  382. List<TStaffmgr> staffmgrsMoc = tStaffmgrService.selectAllTStaffmgrList(staffmgrMoc);
  383. try {
  384. //判断离职
  385. if (!StringUtils.isEmpty(tTrainingRegular.getYear())) {
  386. Iterator<TStaffmgr> iterator = staffmgrsMoc.iterator();
  387. while (iterator.hasNext()) {
  388. TStaffmgr t = iterator.next();
  389. if (t.getLeftDate() != null && t.getDelFlag() == 9){
  390. if (t.getLeftDate().getTime() - tTrainingRegular.getPlanTrainingdate().getTime() > 0l ) {
  391. logger.debug(t.getName() + "离职时间小于培训时间");
  392. iterator.remove();
  393. }
  394. }
  395. }
  396. }
  397. }catch (Exception e) {
  398. logger.error(e.toString());
  399. }
  400. for (TStaffmgr s : staffmgrsMoc) {
  401. TTrainingbccDevice tTrainingDevice = new TTrainingbccDevice();
  402. tTrainingDevice.setStaffId(s.getStaffid());
  403. tTrainingDevice.setRegularId(trainingId);
  404. tTrainingDevice.setStartDate(tTrainingRegular.getPlanTrainingdate());
  405. tTrainingDevice.setSupplementary("0");
  406. trainingbccDeviceService.insertTTrainingbccDevice(tTrainingDevice);
  407. }
  408. }
  409. resNum ++;
  410. }
  411. }
  412. return AjaxResult.success("成功添加" + resNum + "条培训");
  413. }
  414. /**
  415. * 修改装置培训计划
  416. */
  417. @PreAuthorize("@ss.hasPermi('training:bccregular:edit')")
  418. @Log(title = "装置培训计划", businessType = BusinessType.UPDATE)
  419. @PutMapping
  420. public AjaxResult edit(@RequestBody TTrainingbccRegular tTrainingbccRegular)
  421. {
  422. return toAjax(tTrainingbccRegularService.updateTTrainingbccRegular(tTrainingbccRegular));
  423. }
  424. /**
  425. * 删除装置培训计划
  426. */
  427. @PreAuthorize("@ss.hasPermi('training:bccregular:remove')")
  428. @Log(title = "装置培训计划", businessType = BusinessType.DELETE)
  429. @DeleteMapping("/{ids}")
  430. public AjaxResult remove(@PathVariable Long[] ids)
  431. {
  432. return toAjax(tTrainingbccRegularService.deleteTTrainingbccRegularByIds(ids));
  433. }
  434. }