123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191 |
- package org.jeecg.modules.demo.hzz.axgh.axghgnq.controller;
- import java.util.Arrays;
- import java.util.List;
- import java.util.Map;
- 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 com.alibaba.fastjson.JSONObject;
- 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.axgh.axghgnq.entity.Lskzx;
- import org.jeecg.modules.demo.hzz.axgh.axghgnq.service.ILskzxService;
- 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.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: lskzx
- * @Author: jeecg-boot
- * @Date: 2021-10-23
- * @Version: V1.0
- */
- @Api(tags="lskzx")
- @RestController
- @RequestMapping("/hzz.axgh.axghgnq/lskzx")
- @Slf4j
- public class LskzxController extends JeecgController<Lskzx, ILskzxService> {
- @Autowired
- private ILskzxService lskzxService;
- /**
- * 分页列表查询
- *
- * @param lskzx
- * @param pageNo
- * @param pageSize
- * @param req
- * @return
- */
- @AutoLog(value = "lskzx-分页列表查询")
- @ApiOperation(value="lskzx-分页列表查询", notes="lskzx-分页列表查询")
- @GetMapping(value = "/list_ls")
- @PermissionData(pageComponent="hzz/axgh/axghgnq/LskzxList_ls")
- public Result<?> queryPageList_ls(Lskzx lskzx,
- @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
- @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
- HttpServletRequest req) {
- QueryWrapper<Lskzx> queryWrapper = QueryGenerator.initQueryWrapper(lskzx, req.getParameterMap());
- Page<Lskzx> page = new Page<Lskzx>(pageNo, pageSize);
- IPage<Lskzx> pageList = lskzxService.page(page, queryWrapper);
- return Result.OK(pageList);
- }
- /**
- * 添加
- *
- * @param lskzx
- * @return
- */
- @AutoLog(value = "lskzx-添加")
- @ApiOperation(value="lskzx-添加", notes="lskzx-添加")
- @PostMapping(value = "/add")
- public Result<?> add(@RequestBody Lskzx lskzx) {
- lskzxService.save(lskzx);
- return Result.OK("添加成功!");
- }
- /**
- * 编辑
- *
- * @param lskzx
- * @return
- */
- @AutoLog(value = "lskzx-编辑")
- @ApiOperation(value="lskzx-编辑", notes="lskzx-编辑")
- @PostMapping(value = "/edit")
- public Result<?> edit(@RequestBody Lskzx lskzx) {
- lskzxService.updateById(lskzx);
- return Result.OK("编辑成功!");
- }
- /**
- * 通过id删除
- *
- * @param id
- * @return
- */
- @AutoLog(value = "lskzx-通过id删除")
- @ApiOperation(value="lskzx-通过id删除", notes="lskzx-通过id删除")
- @PostMapping(value = "/delete")
- public Result<?> delete(@RequestParam(name="id",required=true) String id) {
- lskzxService.removeById(id);
- return Result.OK("删除成功!");
- }
- /**
- * 批量删除
- *
- * @param ids
- * @return
- */
- @AutoLog(value = "lskzx-批量删除")
- @ApiOperation(value="lskzx-批量删除", notes="lskzx-批量删除")
- @PostMapping(value = "/deleteBatch")
- public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
- this.lskzxService.removeByIds(Arrays.asList(ids.split(",")));
- return Result.OK("批量删除成功!");
- }
- /**
- * 通过id查询
- *
- * @param id
- * @return
- */
- @AutoLog(value = "lskzx-通过id查询")
- @ApiOperation(value="lskzx-通过id查询", notes="lskzx-通过id查询")
- @GetMapping(value = "/queryById")
- public Result<?> queryById(@RequestParam(name="id",required=true) String id) {
- Lskzx lskzx = lskzxService.getById(id);
- if(lskzx==null) {
- return Result.error("未找到对应数据");
- }
- return Result.OK(lskzx);
- }
- /**
- * 通过id查询Geometry
- *
- * @param id
- * @return
- */
- @AutoLog(value = "lskzx-通过id查询Geometry")
- @ApiOperation(value="lskzx-通过id查询Geometry", notes="lskzx-通过id查询Geometry")
- @GetMapping(value = "/getGeojsonById")
- public Result<?> getGeojsonById(@RequestParam(name = "id",required = true) String id){
- String geom = lskzxService.getGeojson(id);
- JSONObject geoJson = JSONObject.parseObject(geom);
- return Result.OK(geoJson);
- }
- /**
- * 导出excel
- *
- * @param request
- * @param lskzx
- */
- @RequestMapping(value = "/exportXls")
- public ModelAndView exportXls(HttpServletRequest request, Lskzx lskzx) {
- return super.exportXls(request, lskzx, Lskzx.class, "lskzx");
- }
- /**
- * 通过excel导入数据
- *
- * @param request
- * @param response
- * @return
- */
- @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
- public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
- return super.importExcel(request, response, Lskzx.class);
- }
- }
|