7cc67b4d30988d07168acef03be41e1712d74941.svn-base 7.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177
  1. package cn.com.goldenwater.dcproj.controller.fsc;
  2. import cn.com.goldenwater.dcproj.dto.BisInspFscPblmDto;
  3. import cn.com.goldenwater.dcproj.model.BisInspAllRlationPers;
  4. import cn.com.goldenwater.dcproj.model.BisInspFscPblm;
  5. import cn.com.goldenwater.dcproj.model.GwComFile;
  6. import cn.com.goldenwater.dcproj.param.BisInspFscPblmParam;
  7. import cn.com.goldenwater.dcproj.param.FileParam;
  8. import cn.com.goldenwater.dcproj.service.BisInspAllRlationPersService;
  9. import cn.com.goldenwater.dcproj.service.BisInspFscPblmService;
  10. import cn.com.goldenwater.core.web.BaseController;
  11. import cn.com.goldenwater.core.web.BaseResponse;
  12. import cn.com.goldenwater.dcproj.service.GwComFileService;
  13. import cn.com.goldenwater.dcproj.utils.impexcel.ExpAndImpUtil;
  14. import cn.com.goldenwater.id.util.UuidUtil;
  15. import io.swagger.annotations.Api;
  16. import io.swagger.annotations.ApiOperation;
  17. import io.swagger.annotations.ApiParam;
  18. import org.apache.commons.lang3.StringUtils;
  19. import com.github.pagehelper.PageInfo;
  20. import org.slf4j.Logger;
  21. import org.slf4j.LoggerFactory;
  22. import org.springframework.beans.factory.annotation.Autowired;
  23. import org.springframework.beans.factory.annotation.Value;
  24. import org.springframework.data.redis.core.RedisTemplate;
  25. import org.springframework.web.bind.annotation.PathVariable;
  26. import org.springframework.web.bind.annotation.RequestBody;
  27. import org.springframework.web.bind.annotation.RequestMapping;
  28. import org.springframework.web.bind.annotation.RequestMethod;
  29. import org.springframework.web.bind.annotation.RestController;
  30. import org.springframework.web.multipart.MultipartFile;
  31. import javax.servlet.http.HttpServletResponse;
  32. import java.io.File;
  33. import java.io.IOException;
  34. import java.util.LinkedHashMap;
  35. import java.util.List;
  36. import java.util.Map;
  37. import static cn.com.goldenwater.dcproj.utils.impexcel.ImpUtil.getDateFormatPath;
  38. /**
  39. * @author lune
  40. * @date 2019-7-19
  41. */
  42. @Api(value = "BIS 特定飞检问题信息表管理", tags = "BIS 特定飞检问题信息表管理")
  43. @RestController
  44. @RequestMapping("/bis/insp/fsc/pblm")
  45. public class BisInspFscPblmController extends BaseController {
  46. private Logger logger = LoggerFactory.getLogger(getClass());
  47. @Value("${export.templatePath}")
  48. private String templatePath;
  49. @Value("${impExcel.basePath}")
  50. private String impExcelPath;
  51. @Autowired
  52. private BisInspFscPblmService bisInspFscPblmService;
  53. @Autowired
  54. private BisInspAllRlationPersService persService;
  55. @Autowired
  56. private RedisTemplate redisTemplate;
  57. @Autowired
  58. private GwComFileService gwComFileService;
  59. @ApiOperation(value = "添加/修改特定飞检问题信息表")
  60. @RequestMapping(value = "", method = RequestMethod.POST)
  61. public BaseResponse<BisInspFscPblm> insert(@ApiParam(name = "bisInspFscPblm", value = "BisInspFscPblm", required = true) @RequestBody BisInspFscPblm bisInspFscPblm) {
  62. if (StringUtils.isBlank(bisInspFscPblm.getId())) {
  63. String uuid = UuidUtil.uuid(); // 生成uuid
  64. bisInspFscPblm.setId(uuid);
  65. bisInspFscPblmService.insert(bisInspFscPblm);
  66. } else {
  67. bisInspFscPblmService.updatePblm(bisInspFscPblm);
  68. }
  69. return buildSuccessResponse(bisInspFscPblm);
  70. }
  71. @ApiOperation(value = "根据ID删除特定飞检问题信息表")
  72. @RequestMapping(value = "/del/{id}", method = RequestMethod.GET)
  73. public BaseResponse delete(@ApiParam(name = "id", value = "id", required = true) @PathVariable String id) {
  74. int ret = bisInspFscPblmService.delete(id);
  75. return buildSuccessResponse();
  76. }
  77. @ApiOperation(value = "根据ID获取特定飞检问题信息表(单表)")
  78. @RequestMapping(value = "/{id}", method = RequestMethod.GET)
  79. public BaseResponse<BisInspFscPblm> get(@ApiParam(name = "id", value = "id", required = true) @PathVariable String id) {
  80. BisInspFscPblm bisInspFscPblm = bisInspFscPblmService.get(id);
  81. if (StringUtils.isNotBlank(bisInspFscPblm.getPersId())) {
  82. BisInspAllRlationPers pers = persService.get(bisInspFscPblm.getPersId());
  83. if (pers != null) {
  84. bisInspFscPblm.setPersName(pers.getPersName());
  85. }
  86. }
  87. List<GwComFile> gwComFiles = gwComFileService.findFileByBiz(bisInspFscPblm.getId());
  88. bisInspFscPblm.setGwComFiles(gwComFiles);
  89. return buildSuccessResponse(bisInspFscPblm);
  90. }
  91. @ApiOperation(value = "获取特定飞检问题信息表(列表所有)")
  92. @RequestMapping(value = "/list", method = RequestMethod.POST)
  93. public BaseResponse<List<BisInspFscPblm>> list(@ApiParam(name = "bisInspFscPblmParam", value = "bisInspFscPblmParam", required = true) @RequestBody BisInspFscPblmParam bisInspFscPblmParam) {
  94. List<BisInspFscPblm> bisInspFscPblmList = bisInspFscPblmService.findList(bisInspFscPblmParam);
  95. return buildSuccessResponse(bisInspFscPblmList);
  96. }
  97. @ApiOperation(value = "获取特定飞检问题信息表(列表--分页)")
  98. @RequestMapping(value = "/page", method = RequestMethod.POST)
  99. public BaseResponse<PageInfo<BisInspFscPblm>> page(@ApiParam(name = "bisInspFscPblmParam", value = "bisInspFscPblmParam", required = true) @RequestBody BisInspFscPblmParam bisInspFscPblmParam) {
  100. PageInfo<BisInspFscPblm> bisInspFscPblmList = bisInspFscPblmService.findPageInfo(bisInspFscPblmParam);
  101. return buildSuccessResponse(bisInspFscPblmList);
  102. }
  103. @ApiOperation(value = "下载飞检模板")
  104. @RequestMapping(value = "/downTemplate", method = {RequestMethod.GET, RequestMethod.POST})
  105. public BaseResponse downTemplate(HttpServletResponse response, FileParam param) {
  106. try {
  107. List<Map<String, Object>> pblmList = bisInspFscPblmService.findPblmList(param);
  108. ExpAndImpUtil.download(response, pblmList, templatePath + File.separator + param.getFileName(), param.getStartRow(), param.getSheetName());
  109. } catch (Exception e) {
  110. return buildFailResponse(e);
  111. }
  112. return buildSuccessResponse();
  113. }
  114. @ApiOperation(value = "上传飞检模板")
  115. @RequestMapping(value = "/uploadTemplate", method = RequestMethod.POST)
  116. public BaseResponse uploadTemplate(MultipartFile file, FileParam param) {
  117. String filaPath = "";
  118. try {
  119. filaPath = ExpAndImpUtil.upload(file, getDateFormatPath(impExcelPath));
  120. } catch (Exception e) {
  121. return buildFailResponse(e);
  122. }
  123. return buildSuccessResponse(filaPath);
  124. }
  125. @ApiOperation(value = "解析文件上传数据")
  126. @RequestMapping(value = "/parseUpload", method = RequestMethod.POST)
  127. public BaseResponse<Map<String, Object>> parseUpload(FileParam param) {
  128. Map<String, Object> map = new LinkedHashMap<>();
  129. try {
  130. List<LinkedHashMap<String, Object>> list = ExpAndImpUtil.parseData(param.getPath(), param.getStartRow(), BisInspFscPblmDto.class);
  131. if (list.size() > 0) {
  132. String uuid = UuidUtil.uuid();
  133. redisTemplate.opsForList().rightPushAll(uuid, list);
  134. map.put("dataId", uuid);
  135. }
  136. map.put("list", list);
  137. } catch (IOException e) {
  138. buildFailResponse(e.getMessage());
  139. }
  140. return buildSuccessResponse(map);
  141. }
  142. @ApiOperation(value = "文件数据入库")
  143. @RequestMapping(value = "/insertIntoData", method = RequestMethod.POST)
  144. public BaseResponse insertIntoData(FileParam param) {
  145. if (StringUtils.isBlank(param.getDataId())) {
  146. return buildFailResponse();
  147. }
  148. List<LinkedHashMap<String, Object>> list = redisTemplate.opsForList().range(param.getDataId(), 0, -1);
  149. redisTemplate.delete(param.getDataId());
  150. if (bisInspFscPblmService.insertIntoData(list) == 0) {
  151. return buildFailResponse();
  152. }
  153. return buildSuccessResponse();
  154. }
  155. }