88cbac26cdbb81bfc7cc25372eb57a19ee0df30f.svn-base 8.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272
  1. package org.jeecg.modules.demo.hzz.shjsgc.xcjgjl.controller;
  2. import java.util.*;
  3. import java.util.stream.Collectors;
  4. import java.io.IOException;
  5. import java.io.UnsupportedEncodingException;
  6. import java.net.URLDecoder;
  7. import javax.servlet.http.HttpServletRequest;
  8. import javax.servlet.http.HttpServletResponse;
  9. import org.apache.commons.lang.StringUtils;
  10. import org.apache.ibatis.annotations.Param;
  11. import org.jeecg.common.api.vo.Result;
  12. import org.jeecg.common.aspect.annotation.PermissionData;
  13. import org.jeecg.common.system.query.QueryGenerator;
  14. import org.jeecg.common.util.oConvertUtils;
  15. import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.entity.RmJgjlb;
  16. import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.entity.RmShxmxxb;
  17. import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.service.IRmJgjlbService;
  18. import org.jeecg.modules.demo.hzz.shjsgc.xcjgjl.entity.RmXcjgjl;
  19. import org.jeecg.modules.demo.hzz.shjsgc.xcjgjl.service.IRmXcjgjlService;
  20. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  21. import com.baomidou.mybatisplus.core.metadata.IPage;
  22. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  23. import lombok.extern.slf4j.Slf4j;
  24. import org.jeecg.modules.demo.untils.geoinfo;
  25. import org.jeecgframework.poi.excel.ExcelImportUtil;
  26. import org.jeecgframework.poi.excel.def.NormalExcelConstants;
  27. import org.jeecgframework.poi.excel.entity.ExportParams;
  28. import org.jeecgframework.poi.excel.entity.ImportParams;
  29. import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;
  30. import org.jeecg.common.system.base.controller.JeecgController;
  31. import org.springframework.beans.factory.annotation.Autowired;
  32. import org.springframework.web.bind.annotation.*;
  33. import org.springframework.web.multipart.MultipartFile;
  34. import org.springframework.web.multipart.MultipartHttpServletRequest;
  35. import org.springframework.web.servlet.ModelAndView;
  36. import com.alibaba.fastjson.JSON;
  37. import io.swagger.annotations.Api;
  38. import io.swagger.annotations.ApiOperation;
  39. import org.jeecg.common.aspect.annotation.AutoLog;
  40. /**
  41. * @Description: 现场监管记录
  42. * @Author: jeecg-boot
  43. * @Date: 2022-01-08
  44. * @Version: V1.0
  45. */
  46. @Api(tags="现场监管记录")
  47. @RestController
  48. @RequestMapping("/hzz.shjsgc.xcjgjl/rmXcjgjl")
  49. @Slf4j
  50. public class RmXcjgjlController extends JeecgController<RmXcjgjl, IRmXcjgjlService> {
  51. @Autowired
  52. private geoinfo geoinfo;
  53. @Autowired
  54. private IRmXcjgjlService rmXcjgjlService;
  55. @Autowired
  56. private IRmJgjlbService rmJgjlbService;
  57. /**
  58. * 分页列表查询
  59. *
  60. * @param rmXcjgjl
  61. * @param pageNo
  62. * @param pageSize
  63. * @param req
  64. * @return
  65. */
  66. @AutoLog(value = "现场监管记录-分页列表查询")
  67. @ApiOperation(value="现场监管记录-分页列表查询", notes="现场监管记录-分页列表查询")
  68. @GetMapping(value = "/list")
  69. @PermissionData(pageComponent = "hzz/shjsgc/xcjgjl/RmXcjgjlList")
  70. public Result<?> queryPageList(RmXcjgjl rmXcjgjl,
  71. @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
  72. @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
  73. HttpServletRequest req) {
  74. QueryWrapper<RmXcjgjl> queryWrapper = QueryGenerator.initQueryWrapper(rmXcjgjl, req.getParameterMap());
  75. Page<RmXcjgjl> page = new Page<RmXcjgjl>(pageNo, pageSize);
  76. IPage<RmXcjgjl> pageList = rmXcjgjlService.page(page, queryWrapper);
  77. return Result.OK(pageList);
  78. }
  79. /**
  80. * 添加
  81. *
  82. * @param rmXcjgjl
  83. * @return
  84. */
  85. @AutoLog(value = "现场监管记录-添加")
  86. @ApiOperation(value="现场监管记录-添加", notes="现场监管记录-添加")
  87. @PostMapping(value = "/add")
  88. public Result<?> add(@RequestBody RmXcjgjl rmXcjgjl) {
  89. rmXcjgjlService.save(rmXcjgjl);
  90. String hzb = rmXcjgjl.getHzb();
  91. String zzb = rmXcjgjl.getZzb();
  92. if(hzb!=null && zzb!=null) {
  93. String geoinfo = this.geoinfo.geoinfo(hzb,zzb);
  94. rmXcjgjl.setGeoinfo(geoinfo);
  95. }
  96. String id = rmXcjgjl.getId();
  97. String jsxmid = rmXcjgjl.getJsxmid();
  98. String jgdw = rmXcjgjl.getJgdw();
  99. Date jcsj = rmXcjgjl.getJcsj();
  100. String jcmc = rmXcjgjl.getJcmc();
  101. String jgfzr = rmXcjgjl.getJgfzr();
  102. String selectid = rmXcjgjlService.selectid(jsxmid);
  103. String xmxxid = rmXcjgjlService.selectXmxxid(jsxmid);
  104. HashMap<Object,Object> map=new HashMap<>();
  105. map.put("id",UUID.randomUUID().toString().replace("-", ""));
  106. map.put("main_id",xmxxid);
  107. map.put("jcmc",jcmc);
  108. map.put("jcsj",jcsj);
  109. map.put("jgdw",jgdw);
  110. map.put("jgfzr",jgfzr);
  111. map.put("czwtjclqk",rmXcjgjl.getCzwtjclqk());
  112. map.put("out_key",id);
  113. HashMap<Object,Object> map1=new HashMap<>();
  114. map1.put("id",UUID.randomUUID().toString().replace("-", ""));
  115. map1.put("main_id",selectid);
  116. map1.put("jcmc",jcmc);
  117. map1.put("jcsj",jcsj);
  118. map1.put("jgdw",jgdw);
  119. map1.put("jgfzr",jgfzr);
  120. map1.put("czwtjclqk",rmXcjgjl.getCzwtjclqk());
  121. map1.put("out_key",id);
  122. try{
  123. if(xmxxid.equals(jsxmid)){
  124. rmXcjgjlService.insertjgjl(map);
  125. }}catch (Exception e){
  126. if(selectid.equals(jsxmid)){
  127. rmXcjgjlService.insertjgjl(map1);
  128. }
  129. }
  130. rmXcjgjlService.saveOrUpdate(rmXcjgjl);
  131. return Result.OK("添加成功!");
  132. }
  133. /**
  134. * 编辑
  135. *
  136. * @param rmXcjgjl
  137. * @return
  138. */
  139. @AutoLog(value = "现场监管记录-编辑")
  140. @ApiOperation(value="现场监管记录-编辑", notes="现场监管记录-编辑")
  141. @PostMapping(value = "/edit")
  142. public Result<?> edit(@RequestBody RmXcjgjl rmXcjgjl) {
  143. rmXcjgjlService.updateById(rmXcjgjl);
  144. String geoinfo=null;
  145. try {
  146. String zzb = rmXcjgjl.getZzb();
  147. String hzb = rmXcjgjl.getHzb();
  148. if(zzb!=null&&hzb!=null){
  149. geoinfo = this.geoinfo.geoinfo(hzb, zzb);
  150. }
  151. rmXcjgjl.setGeoinfo(geoinfo);
  152. }catch (Exception E){
  153. E.printStackTrace();
  154. }
  155. HashMap<Object,Object> map=new HashMap<>();
  156. map.put("jcmc",rmXcjgjl.getJcmc());
  157. map.put("jcsj",rmXcjgjl.getJcsj());
  158. map.put("jgdw",rmXcjgjl.getJgdw());
  159. map.put("jgfzr",rmXcjgjl.getJgfzr());
  160. map.put("czwtjclqk",rmXcjgjl.getCzwtjclqk());
  161. map.put("id",rmXcjgjl.getId());
  162. System.out.println(map);
  163. rmXcjgjlService.saveOrUpdate(rmXcjgjl);
  164. rmXcjgjlService.updatejgjl(map);
  165. return Result.OK("编辑成功!");
  166. }
  167. /**
  168. * 通过id删除
  169. *
  170. * @param id
  171. * @return
  172. */
  173. @AutoLog(value = "现场监管记录-通过id删除")
  174. @ApiOperation(value="现场监管记录-通过id删除", notes="现场监管记录-通过id删除")
  175. @PostMapping(value = "/delete")
  176. public Result<?> delete(@RequestParam(name="id",required=true) String id) {
  177. // String jsxmid = rmXcjgjlService.selectjsxmid(id);
  178. // System.out.println(jsxmid);
  179. rmXcjgjlService.delejgjl(id);
  180. rmXcjgjlService.delejgjlb(id);
  181. rmXcjgjlService.removeById(id);
  182. return Result.OK("删除成功!");
  183. }
  184. /**
  185. * 批量删除
  186. *
  187. * @param ids
  188. * @return
  189. */
  190. @AutoLog(value = "现场监管记录-批量删除")
  191. @ApiOperation(value="现场监管记录-批量删除", notes="现场监管记录-批量删除")
  192. @PostMapping(value = "/deleteBatch")
  193. public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
  194. this.rmXcjgjlService.removeByIds(Arrays.asList(ids.split(",")));
  195. List<String> gspIds = Arrays.asList(ids.split(","));
  196. for(int i=0;i<gspIds.size();i++) {
  197. rmXcjgjlService.delejgjl(gspIds.get(i));
  198. }
  199. return Result.OK("批量删除成功!");
  200. }
  201. /**
  202. * 通过id查询
  203. *
  204. * @param id
  205. * @return
  206. */
  207. @AutoLog(value = "现场监管记录-通过id查询")
  208. @ApiOperation(value="现场监管记录-通过id查询", notes="现场监管记录-通过id查询")
  209. @GetMapping(value = "/queryById")
  210. public Result<?> queryById(@RequestParam(name="id",required=true) String id) {
  211. RmXcjgjl rmXcjgjl = rmXcjgjlService.getById(id);
  212. if(rmXcjgjl==null) {
  213. return Result.error("未找到对应数据");
  214. }
  215. return Result.OK(rmXcjgjl);
  216. }
  217. /**
  218. * 查询监管记录
  219. *
  220. *
  221. * @return
  222. */
  223. @AutoLog(value = "查询监管记录")
  224. @ApiOperation(value="查询监管记录", notes="查询监管记录")
  225. @GetMapping(value = "/cxjgjl")
  226. public Result<?> cxjgjl() {
  227. List<HashMap<String, String>> selectjgjl = rmXcjgjlService.selectjgjl();
  228. return Result.OK(selectjgjl);
  229. }
  230. /**
  231. * 导出excel
  232. *
  233. * @param request
  234. * @param rmXcjgjl
  235. */
  236. @RequestMapping(value = "/exportXls")
  237. public ModelAndView exportXls(HttpServletRequest request, RmXcjgjl rmXcjgjl) {
  238. return super.exportXls(request, rmXcjgjl, RmXcjgjl.class, "现场监管记录");
  239. }
  240. /**
  241. * 通过excel导入数据
  242. *
  243. * @param request
  244. * @param response
  245. * @return
  246. */
  247. @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
  248. public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
  249. return super.importExcel(request, response, RmXcjgjl.class);
  250. }
  251. }