99b7d2398bbc447003e205b5564ef958659c03c3.svn-base 7.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159
  1. package cn.com.goldenwater.dcproj.controller.importex;
  2. import cn.com.goldenwater.core.web.BaseController;
  3. import cn.com.goldenwater.core.web.BaseResponse;
  4. import cn.com.goldenwater.dcproj.dao.AttAdXBaseDao;
  5. import cn.com.goldenwater.dcproj.dao.AttRsBaseDao;
  6. import cn.com.goldenwater.dcproj.dao.AttRsBaseFjDao;
  7. import cn.com.goldenwater.dcproj.dto.ExcelInspRsDto;
  8. import cn.com.goldenwater.dcproj.model.ImpRsInfo;
  9. import cn.com.goldenwater.dcproj.param.ImpRsInfoParam;
  10. import cn.com.goldenwater.dcproj.service.AttRsBaseService;
  11. import cn.com.goldenwater.dcproj.service.ImpRsInfoService;
  12. import cn.com.goldenwater.dcproj.utils.LoadExcel;
  13. import cn.com.goldenwater.dcproj.utils.impexcel.ImpRsExcel;
  14. import cn.com.goldenwater.id.util.UuidUtil;
  15. import com.github.pagehelper.PageInfo;
  16. import io.swagger.annotations.Api;
  17. import io.swagger.annotations.ApiOperation;
  18. import io.swagger.annotations.ApiParam;
  19. import org.apache.commons.lang3.StringUtils;
  20. import org.slf4j.Logger;
  21. import org.slf4j.LoggerFactory;
  22. import org.springframework.beans.factory.annotation.Autowired;
  23. import org.springframework.web.bind.annotation.*;
  24. import org.springframework.web.multipart.MultipartFile;
  25. import java.util.HashMap;
  26. import java.util.List;
  27. /**
  28. * @author lune
  29. * @date 2019-7-23
  30. */
  31. @Api(value = "IMP 检查小型水库名称及分布情况表管理", tags = "IMP 检查小型水库名称及分布情况表管理")
  32. @RestController
  33. @RequestMapping("/imp/rs/info")
  34. public class ImpRsInfoController extends BaseController {
  35. private Logger logger = LoggerFactory.getLogger(getClass());
  36. @Autowired
  37. private ImpRsInfoService impRsInfoService;
  38. @Autowired
  39. private AttRsBaseFjDao attRsBaseFjDao;
  40. @Autowired
  41. private AttAdXBaseDao attAdXBaseDao;
  42. @Autowired
  43. private AttRsBaseService attRsBaseService;
  44. @Autowired
  45. private AttRsBaseDao attRsBaseDao;
  46. @ApiOperation(value = "添加/修改检查小型水库名称及分布情况表")
  47. @RequestMapping(value = "", method = RequestMethod.POST)
  48. public BaseResponse<ImpRsInfo> insert(@ApiParam(name = "impRsInfo", value = "ImpRsInfo", required = true) @RequestBody ImpRsInfo impRsInfo) {
  49. if (StringUtils.isBlank(impRsInfo.getId())) {
  50. String uuid = UuidUtil.uuid(); // 生成uuid
  51. impRsInfo.setId(uuid);
  52. impRsInfoService.insert(impRsInfo);
  53. } else {
  54. impRsInfoService.update(impRsInfo);
  55. }
  56. return buildSuccessResponse(impRsInfo);
  57. }
  58. @ApiOperation(value = "根据ID删除检查小型水库名称及分布情况表")
  59. @RequestMapping(value = "/del/{id}", method = RequestMethod.GET)
  60. public BaseResponse delete(@ApiParam(name = "id", value = "id", required = true) @PathVariable String id) {
  61. int ret = impRsInfoService.delete(id);
  62. return buildSuccessResponse();
  63. }
  64. @ApiOperation(value = "根据ID获取检查小型水库名称及分布情况表(单表)")
  65. @RequestMapping(value = "/{id}", method = RequestMethod.GET)
  66. public BaseResponse<ImpRsInfo> get(@ApiParam(name = "id", value = "id", required = true) @PathVariable String id) {
  67. ImpRsInfo impRsInfo = impRsInfoService.get(id);
  68. return buildSuccessResponse(impRsInfo);
  69. }
  70. @ApiOperation(value = "获取检查小型水库名称及分布情况表(列表所有)")
  71. @RequestMapping(value = "/list", method = RequestMethod.POST)
  72. public BaseResponse<List<ImpRsInfo>> list(@ApiParam(name = "impRsInfoParam", value = "impRsInfoParam", required = true) @RequestBody ImpRsInfoParam impRsInfoParam) {
  73. List<ImpRsInfo> impRsInfoList = impRsInfoService.findList(impRsInfoParam);
  74. return buildSuccessResponse(impRsInfoList);
  75. }
  76. @ApiOperation(value = "获取检查小型水库名称及分布情况表(列表--分页)")
  77. @RequestMapping(value = "/page", method = RequestMethod.POST)
  78. public BaseResponse<PageInfo<ImpRsInfo>> page(@ApiParam(name = "impRsInfoParam", value = "impRsInfoParam", required = true) @RequestBody ImpRsInfoParam impRsInfoParam) {
  79. PageInfo<ImpRsInfo> impRsInfoList = impRsInfoService.findPageInfo(impRsInfoParam);
  80. return buildSuccessResponse(impRsInfoList);
  81. }
  82. @ApiOperation(value = "根据月份批量插入小型水库名称及分布情况信息")
  83. @RequestMapping(value = "insertList/{mnth}", method = RequestMethod.POST)
  84. public BaseResponse<String> insertList(@ApiParam(name = "mnth", value = "mnth", required = true) @PathVariable String mnth, @RequestParam("file") MultipartFile file) {
  85. try {
  86. List<ExcelInspRsDto> list = LoadExcel.getRsvrObjListByFile(file);
  87. impRsInfoService.insertList(list,mnth);
  88. }catch (Exception e){
  89. e.printStackTrace();
  90. }
  91. return buildSuccessResponse("执行结束!!!");
  92. }
  93. @ApiOperation(value = "根据月份批量处理小型水库名称及分布情况信息")
  94. @RequestMapping(value = "handleRsData", method = RequestMethod.POST)
  95. public BaseResponse<String> handleRsData(@ApiParam(name = "mnth", value = "月份", required = true) @RequestParam String mnth, @ApiParam(name = "orgId", value = "机构ID", required = true) @RequestParam String orgId) {
  96. try {
  97. impRsInfoService.handleRsData(mnth,orgId);
  98. }catch (Exception e){
  99. e.printStackTrace();
  100. }
  101. return buildSuccessResponse("执行结束!!!");
  102. }
  103. @ApiOperation(value = "插入福建省百日攻坚河湖四乱问题数据")
  104. @RequestMapping(value = "insertFlkdisList", method = RequestMethod.POST)
  105. public BaseResponse<String> insertFlkdisList(@RequestParam("file") MultipartFile file) {
  106. try {
  107. impRsInfoService.insertFlkdisList(file);
  108. }catch (Exception e){
  109. e.printStackTrace();
  110. }
  111. return buildSuccessResponse("执行结束!!!");
  112. }
  113. @ApiOperation(value = "插入福建省百日攻坚水政项目问题数据")
  114. @RequestMapping(value = "insertWaterList", method = RequestMethod.POST)
  115. public BaseResponse<String> insertWaterList(@RequestParam("file") MultipartFile file) {
  116. try {
  117. impRsInfoService.insertWaterList(file);
  118. }catch (Exception e){
  119. e.printStackTrace();
  120. }
  121. return buildSuccessResponse("执行结束!!!");
  122. }
  123. @ApiOperation(value = "插入福建省百日攻坚中央环保督查问题数据")
  124. @RequestMapping(value = "insertEcofrdList", method = RequestMethod.POST)
  125. public BaseResponse<String> insertEcofrdList(@RequestParam("file") MultipartFile file) {
  126. try {
  127. impRsInfoService.insertEcofrdList(file);
  128. }catch (Exception e){
  129. e.printStackTrace();
  130. }
  131. return buildSuccessResponse("执行结束!!!");
  132. }
  133. @ApiOperation(value = "批量处理福建水库名录")
  134. @RequestMapping(value = "importFjRsList", method = RequestMethod.POST)
  135. public BaseResponse<String> importFjRsList(@ApiParam(name = "filePath", value = "路径", required = true) @RequestParam String filePath) {
  136. try {
  137. ImpRsExcel impRsExcel = new ImpRsExcel();
  138. impRsExcel.doImportExcel(filePath,1,0,true, HashMap.class, "", "sk",attAdXBaseDao,attRsBaseFjDao,attRsBaseService,attRsBaseDao);
  139. }catch (Exception e){
  140. e.printStackTrace();
  141. }
  142. return buildSuccessResponse("执行结束!!!");
  143. }
  144. }