feaafe35da4a9ad9f95557fc5d619634d83d1d48.svn-base 10.0 KB

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