| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272 | 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.jeecg.common.api.vo.Result;import org.jeecg.common.aspect.annotation.PermissionData;import org.jeecg.common.system.query.QueryGenerator;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")@Slf4jpublic 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);		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.save(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);		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);    }}
 |