HxpSmartTerminalController.java 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218
  1. package com.zd.chemical.controller;
  2. import com.zd.chemical.domain.HxpSmartTerminal;
  3. import com.zd.chemical.domain.HxpSmartTerminalConfig;
  4. import com.zd.chemical.domain.vo.HxpSmartTerminalByExcel;
  5. import com.zd.chemical.domain.vo.HxpSmartTerminalSearch;
  6. import com.zd.chemical.domain.vo.HxpSmartTerminalVo;
  7. import com.zd.chemical.service.IHxpSmartTerminalConfigService;
  8. import com.zd.chemical.service.IHxpSmartTerminalService;
  9. import com.zd.common.core.annotation.Log;
  10. import com.zd.common.core.annotation.PreAuthorize;
  11. import com.zd.common.core.log.BusinessType;
  12. import com.zd.common.core.redis.RedisService;
  13. import com.zd.common.core.utils.ExcelUtil;
  14. import com.zd.common.core.utils.SecurityUtils;
  15. import com.zd.common.core.utils.StringUtils;
  16. import com.zd.common.core.web.controller.BaseController;
  17. import com.zd.model.domain.AjaxResult;
  18. import com.zd.model.domain.R;
  19. import com.zd.model.domain.ResultData;
  20. import com.zd.model.domain.per.PerFun;
  21. import com.zd.model.domain.per.PerPrefix;
  22. import com.zd.model.page.TableDataInfo;
  23. import io.swagger.annotations.Api;
  24. import io.swagger.annotations.ApiImplicitParam;
  25. import io.swagger.annotations.ApiImplicitParams;
  26. import io.swagger.annotations.ApiOperation;
  27. import org.apache.commons.collections4.CollectionUtils;
  28. import org.springframework.beans.factory.annotation.Autowired;
  29. import org.springframework.web.bind.annotation.*;
  30. import org.springframework.web.multipart.MultipartFile;
  31. import javax.servlet.http.HttpServletResponse;
  32. import java.io.IOException;
  33. import java.util.HashMap;
  34. import java.util.List;
  35. import java.util.Map;
  36. import java.util.concurrent.TimeUnit;
  37. /**
  38. * 化学品设备管理Controller
  39. *
  40. * @author liubo
  41. * @date 2022-06-16
  42. */
  43. @RestController
  44. @Api(tags = "【 化学品设备管理】")
  45. @RequestMapping("/hxpSmartTerminal")
  46. public class HxpSmartTerminalController extends BaseController {
  47. @Autowired
  48. private IHxpSmartTerminalService hxpSmartTerminalService;
  49. @Autowired
  50. private IHxpSmartTerminalConfigService hxpSmartTerminalConfigService;
  51. @Autowired
  52. RedisService redisService;
  53. /**
  54. * 查询 化学品设备管理列表
  55. */
  56. @PreAuthorize(hasPermi = PerPrefix.HXP_SMARTTERMINAL + PerFun.LIST)
  57. @GetMapping("/list")
  58. @ApiOperation(value = "查询 化学品设备管理列表")
  59. public TableDataInfo<HxpSmartTerminalVo> list(HxpSmartTerminalSearch hxpSmartTerminalSearch) {
  60. startPage();
  61. if (StringUtils.isNotNull(hxpSmartTerminalSearch.getTerminalStatus()) && hxpSmartTerminalSearch.getTerminalStatus() == 3) {
  62. hxpSmartTerminalSearch.setStatus(0);
  63. hxpSmartTerminalSearch.setTerminalStatus(null);
  64. }
  65. List<HxpSmartTerminalVo> list = hxpSmartTerminalService.selectHxpSmartTerminalList(hxpSmartTerminalSearch);
  66. return getDataTable(list);
  67. }
  68. /**
  69. * 导出 化学品设备管理列表
  70. */
  71. @ApiOperation(value = "导出 化学品设备管理列表")
  72. @PreAuthorize(hasPermi = PerPrefix.HXP_SMARTTERMINAL + PerFun.EXPORT)
  73. @Log(title = " 化学品设备管理", businessType = BusinessType.EXPORT)
  74. @PostMapping("/export")
  75. public void export(HttpServletResponse response, HxpSmartTerminalSearch hxpSmartTerminalSearch) throws IOException {
  76. List<HxpSmartTerminalVo> list = hxpSmartTerminalService.selectHxpSmartTerminalList(hxpSmartTerminalSearch);
  77. ExcelUtil<HxpSmartTerminalVo> util = new ExcelUtil<>(HxpSmartTerminalVo.class);
  78. util.exportExcel(response, list, " 化学品设备管理数据");
  79. }
  80. @PostMapping("/importTemplate")
  81. public void importTemplate(HttpServletResponse response) throws IOException {
  82. String tips = "导入注意事项:(未按如下要求填写,会导致数据不能正常导入)\n" +
  83. "1、请不要修改此表格的格式,包括插入删除行和列、合并拆分单元格等。请在表格里面逐行录入数据。一次最多导入5000条数据信息。\n" +
  84. "2、需要填写的单元格字段规则校验,请按照提示输入。\n" +
  85. "3、请不要随意复制单元格,这样会破坏字段规则校验。\n" +
  86. "4、带有星号(*)的红色字段为必填项。\n" +
  87. "5、请注意:设备编号是唯一的,不能重复,不可多条;编号要求最大20个字符,包含大小写字母、数字。\n" +
  88. "6、请注意:实验室,需填写系统中已录入的对应数据名称,否则无法正常导入。\n";
  89. ExcelUtil<HxpSmartTerminalByExcel> util = new ExcelUtil<>(HxpSmartTerminalByExcel.class);
  90. util.exportExcel(response, null, "化学品智能终端", tips, "化学品智能终端-批量导入模板");
  91. }
  92. @Log(title = "化学品导入", businessType = BusinessType.IMPORT)
  93. @PreAuthorize(hasPermi = PerPrefix.HXP_SMARTTERMINAL + PerFun.IMPORT)
  94. @PostMapping("/importData")
  95. public AjaxResult importData(MultipartFile file, HxpSmartTerminalByExcel hxpChemicalByExcel) throws Exception {
  96. ExcelUtil<HxpSmartTerminalByExcel> util = new ExcelUtil<>(HxpSmartTerminalByExcel.class);
  97. List<HxpSmartTerminalByExcel> smartTerminalList = util.importExcel(file.getInputStream(), true);
  98. String operName = SecurityUtils.getUsername();
  99. List<HxpSmartTerminalByExcel> hxpSmartTerminalByExcels = hxpSmartTerminalService.importSmartTerminal(smartTerminalList, operName, hxpChemicalByExcel);
  100. Map<String, Object> resultMap = new HashMap<>();
  101. resultMap.put("totalNum", smartTerminalList.size());
  102. resultMap.put("successNum", smartTerminalList.size() - hxpSmartTerminalByExcels.size());
  103. resultMap.put("failureNum", hxpSmartTerminalByExcels.size());
  104. resultMap.put("downFile", hxpSmartTerminalByExcels.size() > 0);
  105. if (hxpSmartTerminalByExcels.size() > 0) {
  106. redisService.setCacheObject("exportBySmartTerminal" + SecurityUtils.getUserId(), hxpSmartTerminalByExcels, 1L, TimeUnit.HOURS);
  107. }
  108. return AjaxResult.success(resultMap);
  109. }
  110. @Log(title = "化学品导入出错误数据", businessType = BusinessType.IMPORT)
  111. @PostMapping("/importErrorData")
  112. public void importErrorData(HttpServletResponse response) throws Exception {
  113. String tips = "导入注意事项:(未按如下要求填写,会导致数据不能正常导入)\n" +
  114. "1、请不要修改此表格的格式,包括插入删除行和列、合并拆分单元格等。请在表格里面逐行录入数据。一次最多导入5000条数据信息。\n" +
  115. "2、需要填写的单元格字段规则校验,请按照提示输入。\n" +
  116. "3、请不要随意复制单元格,这样会破坏字段规则校验。\n" +
  117. "4、带有星号(*)的红色字段为必填项。\n" +
  118. "5、请注意:设备编号是唯一的,不能重复,不可多条;编号要求最大20个字符,包含大小写字母、数字。\n" +
  119. "6、请注意:实验室,需填写系统中已录入的对应数据名称,否则无法正常导入。\n";
  120. ExcelUtil<HxpSmartTerminalByExcel> util = new ExcelUtil<>(HxpSmartTerminalByExcel.class);
  121. List<HxpSmartTerminalByExcel> smartTerminalByExcels = redisService.getCacheObject("exportBySmartTerminal" + SecurityUtils.getUserId());
  122. if (smartTerminalByExcels.size() > 0) {
  123. util.exportExcel(response, smartTerminalByExcels, "未导入的智能终端数据数据", tips, "智能终端批量导入模板");
  124. }
  125. }
  126. /**
  127. * 获取 化学品设备管理详细信息
  128. */
  129. @ApiOperation(value = "获取 化学品设备管理详细信息")
  130. @PreAuthorize(hasPermi = PerPrefix.HXP_SMARTTERMINAL + PerFun.QUERY)
  131. @GetMapping(value = "/{id}")
  132. public ResultData<HxpSmartTerminal> getInfo(@PathVariable("id") Long id) {
  133. return ResultData.success(hxpSmartTerminalService.selectHxpSmartTerminalById(id));
  134. }
  135. /**
  136. * 新增 化学品设备管理
  137. */
  138. @ApiOperation(value = "新增 化学品设备管理")
  139. @PreAuthorize(hasPermi = PerPrefix.HXP_SMARTTERMINAL + PerFun.ADD)
  140. @Log(title = " 化学品设备管理", businessType = BusinessType.INSERT)
  141. @PostMapping
  142. public ResultData<Boolean> add(@RequestBody HxpSmartTerminal hxpSmartTerminal) {
  143. return ResultData.result(hxpSmartTerminalService.insertHxpSmartTerminal(hxpSmartTerminal));
  144. }
  145. /**
  146. * 修改 化学品设备管理
  147. */
  148. @ApiOperation(value = "修改 化学品设备管理")
  149. @PreAuthorize(hasPermi = PerPrefix.HXP_SMARTTERMINAL + PerFun.EDIT)
  150. @Log(title = " 化学品设备管理", businessType = BusinessType.UPDATE)
  151. @PutMapping
  152. public ResultData<Boolean> edit(@RequestBody HxpSmartTerminal hxpSmartTerminal) {
  153. return ResultData.result(hxpSmartTerminalService.updateHxpSmartTerminal(hxpSmartTerminal));
  154. }
  155. /**
  156. * 修改 化学品设备管理状态
  157. */
  158. @ApiOperation(value = "修改 化学品设备管理状态")
  159. @PreAuthorize(hasPermi = PerPrefix.HXP_SMARTTERMINAL + PerFun.EDIT)
  160. @Log(title = " 化学品设备管理", businessType = BusinessType.UPDATE)
  161. @ApiImplicitParams({
  162. @ApiImplicitParam(name = "ipAddress", value = "设备IP地址"),
  163. @ApiImplicitParam(name = "terminalStatus", value = "设备状态")
  164. })
  165. @PutMapping("update/status")
  166. public ResultData<Boolean> updateStatus(@RequestParam("ipAddress") String ipAddress, @RequestParam("terminalStatus") Integer terminalStatus) {
  167. return ResultData.result(hxpSmartTerminalService.updateStatus(ipAddress, terminalStatus));
  168. }
  169. @ApiOperation(value = "化学品设备开启关闭")
  170. @PreAuthorize(hasPermi = PerPrefix.HXP_SMARTTERMINAL + PerFun.EDIT)
  171. @Log(title = " 化学品设备开启关闭", businessType = BusinessType.UPDATE)
  172. @GetMapping("/updateStatus")
  173. public ResultData<Integer> updateStatus(@RequestParam("id") Long id, @RequestParam("status") Integer status) {
  174. HxpSmartTerminal hxpSmartTerminal = new HxpSmartTerminal();
  175. hxpSmartTerminal.setId(id);
  176. hxpSmartTerminal.setStatus(status);
  177. return ResultData.result(hxpSmartTerminalService.updateHxpSmartTerminal(hxpSmartTerminal));
  178. }
  179. @ApiOperation(value = "报警器报警设置")
  180. @PreAuthorize(hasPermi = PerPrefix.HXP_SMARTTERMINALCONFIG + PerFun.EDIT)
  181. @Log(title = " 化学品设备开启关闭", businessType = BusinessType.UPDATE)
  182. @PostMapping("/alarmSettings")
  183. public R<Integer> alarmSettings(@RequestBody HxpSmartTerminalConfig smartTerminalConfig) {
  184. if (CollectionUtils.isEmpty(smartTerminalConfig.getIds())) {
  185. return R.fail("修改失败,参数异常!");
  186. }
  187. return R.ok(hxpSmartTerminalConfigService.updateHxpSmartTerminalConfig(smartTerminalConfig),"操作成功");
  188. }
  189. /**
  190. * 删除 化学品设备管理
  191. */
  192. @ApiOperation(value = "删除 化学品设备管理")
  193. @PreAuthorize(hasPermi = PerPrefix.HXP_SMARTTERMINAL + PerFun.REMOVE)
  194. @Log(title = " 化学品设备管理", businessType = BusinessType.DELETE)
  195. @DeleteMapping("/{ids}")
  196. public ResultData<Boolean> remove(@PathVariable Long[] ids) {
  197. return ResultData.result(hxpSmartTerminalService.deleteHxpSmartTerminalByIds(ids));
  198. }
  199. }