| 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")@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);        LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();        if (StringUtils.isNotBlank(user.getXzqh()) && !user.getXzqh().equals("371401") ) {            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);    }}
 |