123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282 |
- package org.jeecg.modules.demo.hzz.shjsgc.xcjgjl.controller;
- import java.util.*;
- import java.util.stream.Collectors;
- import java.io.IOException;
- import java.io.UnsupportedEncodingException;
- import java.net.URLDecoder;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import org.apache.commons.lang.StringUtils;
- import org.apache.ibatis.annotations.Param;
- import org.apache.shiro.SecurityUtils;
- import org.jeecg.common.api.vo.Result;
- import org.jeecg.common.aspect.annotation.PermissionData;
- import org.jeecg.common.system.query.QueryGenerator;
- import org.jeecg.common.system.vo.LoginUser;
- import org.jeecg.common.util.oConvertUtils;
- import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.entity.RmJgjlb;
- import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.entity.RmShxmxxb;
- import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.service.IRmJgjlbService;
- import org.jeecg.modules.demo.hzz.shjsgc.xcjgjl.entity.RmXcjgjl;
- import org.jeecg.modules.demo.hzz.shjsgc.xcjgjl.service.IRmXcjgjlService;
- import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
- import com.baomidou.mybatisplus.core.metadata.IPage;
- import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
- import lombok.extern.slf4j.Slf4j;
- import org.jeecg.modules.demo.untils.geoinfo;
- import org.jeecgframework.poi.excel.ExcelImportUtil;
- import org.jeecgframework.poi.excel.def.NormalExcelConstants;
- import org.jeecgframework.poi.excel.entity.ExportParams;
- import org.jeecgframework.poi.excel.entity.ImportParams;
- import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;
- import org.jeecg.common.system.base.controller.JeecgController;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.web.bind.annotation.*;
- import org.springframework.web.multipart.MultipartFile;
- import org.springframework.web.multipart.MultipartHttpServletRequest;
- import org.springframework.web.servlet.ModelAndView;
- import com.alibaba.fastjson.JSON;
- import io.swagger.annotations.Api;
- import io.swagger.annotations.ApiOperation;
- import org.jeecg.common.aspect.annotation.AutoLog;
- /**
- * @Description: 现场监管记录
- * @Author: jeecg-boot
- * @Date: 2022-01-08
- * @Version: V1.0
- */
- @Api(tags = "现场监管记录")
- @RestController
- @RequestMapping("/hzz.shjsgc.xcjgjl/rmXcjgjl")
- @Slf4j
- public class RmXcjgjlController extends JeecgController<RmXcjgjl, IRmXcjgjlService> {
- @Autowired
- private geoinfo geoinfo;
- @Autowired
- private IRmXcjgjlService rmXcjgjlService;
- @Autowired
- private IRmJgjlbService rmJgjlbService;
- /**
- * 分页列表查询
- *
- * @param rmXcjgjl
- * @param pageNo
- * @param pageSize
- * @param req
- * @return
- */
- @AutoLog(value = "现场监管记录-分页列表查询")
- @ApiOperation(value = "现场监管记录-分页列表查询", notes = "现场监管记录-分页列表查询")
- @GetMapping(value = "/list")
- @PermissionData(pageComponent = "hzz/shjsgc/xcjgjl/RmXcjgjlList")
- public Result<?> queryPageList(RmXcjgjl rmXcjgjl,
- @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
- @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize,
- HttpServletRequest req) {
- QueryWrapper<RmXcjgjl> queryWrapper = QueryGenerator.initQueryWrapper(rmXcjgjl, req.getParameterMap());
- Page<RmXcjgjl> page = new Page<RmXcjgjl>(pageNo, pageSize);
- LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
- if (StringUtils.isNotBlank(user.getXzqh())) {
- queryWrapper.eq("xzqh", user.getXzqh());
- }
- IPage<RmXcjgjl> pageList = rmXcjgjlService.page(page, queryWrapper);
- return Result.OK(pageList);
- }
- /**
- * 添加
- *
- * @param rmXcjgjl
- * @return
- */
- @AutoLog(value = "现场监管记录-添加")
- @ApiOperation(value = "现场监管记录-添加", notes = "现场监管记录-添加")
- @PostMapping(value = "/add")
- public Result<?> add(@RequestBody RmXcjgjl rmXcjgjl) {
- rmXcjgjlService.saveBylogin(rmXcjgjl);
- String hzb = rmXcjgjl.getHzb();
- String zzb = rmXcjgjl.getZzb();
- if (hzb != null && zzb != null) {
- String geoinfo = this.geoinfo.geoinfo(hzb, zzb);
- rmXcjgjl.setGeoinfo(geoinfo);
- }
- /* String id = rmXcjgjl.getId();
- String jsxmid = rmXcjgjl.getJsxmid();
- String jgdw = rmXcjgjl.getJgdw();
- Date jcsj = rmXcjgjl.getJcsj();
- String jcmc = rmXcjgjl.getJcmc();
- String jgfzr = rmXcjgjl.getJgfzr();
- String selectid = rmXcjgjlService.selectid(jsxmid);
- String xmxxid = rmXcjgjlService.selectXmxxid(jsxmid);
- HashMap<Object, Object> map = new HashMap<>();
- map.put("id", UUID.randomUUID().toString().replace("-", ""));
- map.put("main_id", xmxxid);
- map.put("jcmc", jcmc);
- map.put("jcsj", jcsj);
- map.put("jgdw", jgdw);
- map.put("jgfzr", jgfzr);
- map.put("czwtjclqk", rmXcjgjl.getCzwtjclqk());
- map.put("out_key", id);
- HashMap<Object, Object> map1 = new HashMap<>();
- map1.put("id", UUID.randomUUID().toString().replace("-", ""));
- map1.put("main_id", selectid);
- map1.put("jcmc", jcmc);
- map1.put("jcsj", jcsj);
- map1.put("jgdw", jgdw);
- map1.put("jgfzr", jgfzr);
- map1.put("czwtjclqk", rmXcjgjl.getCzwtjclqk());
- map1.put("out_key", id);
- if (xmxxid != null && jsxmid != null && xmxxid.equals(jsxmid)){
- rmXcjgjlService.insertjgjl(map);
- }else if( selectid != null && jsxmid != null&&selectid.equals(jsxmid)){
- rmXcjgjlService.insertjgjl(map1);
- }*/
- /*try{
- if(xmxxid.equals(jsxmid)){
- rmXcjgjlService.insertjgjl(map);
- }}catch (Exception e){
- if(selectid.equals(jsxmid)){
- rmXcjgjlService.insertjgjl(map1);
- }
- }*/
- rmXcjgjlService.saveOrUpdate(rmXcjgjl);
- return Result.OK("添加成功!");
- }
- /**
- * 编辑
- *
- * @param rmXcjgjl
- * @return
- */
- @AutoLog(value = "现场监管记录-编辑")
- @ApiOperation(value = "现场监管记录-编辑", notes = "现场监管记录-编辑")
- @PostMapping(value = "/edit")
- public Result<?> edit(@RequestBody RmXcjgjl rmXcjgjl) {
- rmXcjgjlService.updateById(rmXcjgjl);
- String geoinfo = null;
- try {
- String zzb = rmXcjgjl.getZzb();
- String hzb = rmXcjgjl.getHzb();
- if (zzb != null && hzb != null) {
- geoinfo = this.geoinfo.geoinfo(hzb, zzb);
- }
- rmXcjgjl.setGeoinfo(geoinfo);
- } catch (Exception E) {
- E.printStackTrace();
- }
- HashMap<Object, Object> map = new HashMap<>();
- map.put("jcmc", rmXcjgjl.getJcmc());
- map.put("jcsj", rmXcjgjl.getJcsj());
- map.put("jgdw", rmXcjgjl.getJgdw());
- map.put("jgfzr", rmXcjgjl.getJgfzr());
- map.put("czwtjclqk", rmXcjgjl.getCzwtjclqk());
- map.put("id", rmXcjgjl.getId());
- System.out.println(map);
- rmXcjgjlService.saveOrUpdate(rmXcjgjl);
- rmXcjgjlService.updatejgjl(map);
- return Result.OK("编辑成功!");
- }
- /**
- * 通过id删除
- *
- * @param id
- * @return
- */
- @AutoLog(value = "现场监管记录-通过id删除")
- @ApiOperation(value = "现场监管记录-通过id删除", notes = "现场监管记录-通过id删除")
- @PostMapping(value = "/delete")
- public Result<?> delete(@RequestParam(name = "id", required = true) String id) {
- // String jsxmid = rmXcjgjlService.selectjsxmid(id);
- // System.out.println(jsxmid);
- rmXcjgjlService.delejgjl(id);
- rmXcjgjlService.delejgjlb(id);
- rmXcjgjlService.removeById(id);
- return Result.OK("删除成功!");
- }
- /**
- * 批量删除
- *
- * @param ids
- * @return
- */
- @AutoLog(value = "现场监管记录-批量删除")
- @ApiOperation(value = "现场监管记录-批量删除", notes = "现场监管记录-批量删除")
- @PostMapping(value = "/deleteBatch")
- public Result<?> deleteBatch(@RequestParam(name = "ids", required = true) String ids) {
- this.rmXcjgjlService.removeByIds(Arrays.asList(ids.split(",")));
- List<String> gspIds = Arrays.asList(ids.split(","));
- for (int i = 0; i < gspIds.size(); i++) {
- rmXcjgjlService.delejgjl(gspIds.get(i));
- }
- return Result.OK("批量删除成功!");
- }
- /**
- * 通过id查询
- *
- * @param id
- * @return
- */
- @AutoLog(value = "现场监管记录-通过id查询")
- @ApiOperation(value = "现场监管记录-通过id查询", notes = "现场监管记录-通过id查询")
- @GetMapping(value = "/queryById")
- public Result<?> queryById(@RequestParam(name = "id", required = true) String id) {
- RmXcjgjl rmXcjgjl = rmXcjgjlService.getById(id);
- if (rmXcjgjl == null) {
- return Result.error("未找到对应数据");
- }
- return Result.OK(rmXcjgjl);
- }
- /**
- * 查询监管记录
- *
- * @return
- */
- @AutoLog(value = "查询监管记录")
- @ApiOperation(value = "查询监管记录", notes = "查询监管记录")
- @GetMapping(value = "/cxjgjl")
- public Result<?> cxjgjl() {
- List<HashMap<String, String>> selectjgjl = rmXcjgjlService.selectjgjl();
- return Result.OK(selectjgjl);
- }
- /**
- * 导出excel
- *
- * @param request
- * @param rmXcjgjl
- */
- @RequestMapping(value = "/exportXls")
- public ModelAndView exportXls(HttpServletRequest request, RmXcjgjl rmXcjgjl) {
- return super.exportXls(request, rmXcjgjl, RmXcjgjl.class, "现场监管记录");
- }
- /**
- * 通过excel导入数据
- *
- * @param request
- * @param response
- * @return
- */
- @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
- public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
- return super.importExcel(request, response, RmXcjgjl.class);
- }
- }
|