f6de13e353a035fbb4a65e2398486235ef161def.svn-base 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191
  1. package org.jeecg.modules.demo.hzz.axgh.axghgnq.controller;
  2. import java.util.Arrays;
  3. import java.util.List;
  4. import java.util.Map;
  5. import java.util.stream.Collectors;
  6. import java.io.IOException;
  7. import java.io.UnsupportedEncodingException;
  8. import java.net.URLDecoder;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;
  11. import com.alibaba.fastjson.JSONObject;
  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.util.oConvertUtils;
  16. import org.jeecg.modules.demo.hzz.axgh.axghgnq.entity.Lskzx;
  17. import org.jeecg.modules.demo.hzz.axgh.axghgnq.service.ILskzxService;
  18. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  19. import com.baomidou.mybatisplus.core.metadata.IPage;
  20. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  21. import lombok.extern.slf4j.Slf4j;
  22. import org.jeecgframework.poi.excel.ExcelImportUtil;
  23. import org.jeecgframework.poi.excel.def.NormalExcelConstants;
  24. import org.jeecgframework.poi.excel.entity.ExportParams;
  25. import org.jeecgframework.poi.excel.entity.ImportParams;
  26. import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;
  27. import org.jeecg.common.system.base.controller.JeecgController;
  28. import org.springframework.beans.factory.annotation.Autowired;
  29. import org.springframework.web.bind.annotation.*;
  30. import org.springframework.web.multipart.MultipartFile;
  31. import org.springframework.web.multipart.MultipartHttpServletRequest;
  32. import org.springframework.web.servlet.ModelAndView;
  33. import com.alibaba.fastjson.JSON;
  34. import io.swagger.annotations.Api;
  35. import io.swagger.annotations.ApiOperation;
  36. import org.jeecg.common.aspect.annotation.AutoLog;
  37. /**
  38. * @Description: lskzx
  39. * @Author: jeecg-boot
  40. * @Date: 2021-10-23
  41. * @Version: V1.0
  42. */
  43. @Api(tags="lskzx")
  44. @RestController
  45. @RequestMapping("/hzz.axgh.axghgnq/lskzx")
  46. @Slf4j
  47. public class LskzxController extends JeecgController<Lskzx, ILskzxService> {
  48. @Autowired
  49. private ILskzxService lskzxService;
  50. /**
  51. * 分页列表查询
  52. *
  53. * @param lskzx
  54. * @param pageNo
  55. * @param pageSize
  56. * @param req
  57. * @return
  58. */
  59. @AutoLog(value = "lskzx-分页列表查询")
  60. @ApiOperation(value="lskzx-分页列表查询", notes="lskzx-分页列表查询")
  61. @GetMapping(value = "/list_ls")
  62. @PermissionData(pageComponent="hzz/axgh/axghgnq/LskzxList_ls")
  63. public Result<?> queryPageList_ls(Lskzx lskzx,
  64. @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
  65. @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
  66. HttpServletRequest req) {
  67. QueryWrapper<Lskzx> queryWrapper = QueryGenerator.initQueryWrapper(lskzx, req.getParameterMap());
  68. Page<Lskzx> page = new Page<Lskzx>(pageNo, pageSize);
  69. IPage<Lskzx> pageList = lskzxService.page(page, queryWrapper);
  70. return Result.OK(pageList);
  71. }
  72. /**
  73. * 添加
  74. *
  75. * @param lskzx
  76. * @return
  77. */
  78. @AutoLog(value = "lskzx-添加")
  79. @ApiOperation(value="lskzx-添加", notes="lskzx-添加")
  80. @PostMapping(value = "/add")
  81. public Result<?> add(@RequestBody Lskzx lskzx) {
  82. lskzxService.save(lskzx);
  83. return Result.OK("添加成功!");
  84. }
  85. /**
  86. * 编辑
  87. *
  88. * @param lskzx
  89. * @return
  90. */
  91. @AutoLog(value = "lskzx-编辑")
  92. @ApiOperation(value="lskzx-编辑", notes="lskzx-编辑")
  93. @PostMapping(value = "/edit")
  94. public Result<?> edit(@RequestBody Lskzx lskzx) {
  95. lskzxService.updateById(lskzx);
  96. return Result.OK("编辑成功!");
  97. }
  98. /**
  99. * 通过id删除
  100. *
  101. * @param id
  102. * @return
  103. */
  104. @AutoLog(value = "lskzx-通过id删除")
  105. @ApiOperation(value="lskzx-通过id删除", notes="lskzx-通过id删除")
  106. @PostMapping(value = "/delete")
  107. public Result<?> delete(@RequestParam(name="id",required=true) String id) {
  108. lskzxService.removeById(id);
  109. return Result.OK("删除成功!");
  110. }
  111. /**
  112. * 批量删除
  113. *
  114. * @param ids
  115. * @return
  116. */
  117. @AutoLog(value = "lskzx-批量删除")
  118. @ApiOperation(value="lskzx-批量删除", notes="lskzx-批量删除")
  119. @PostMapping(value = "/deleteBatch")
  120. public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
  121. this.lskzxService.removeByIds(Arrays.asList(ids.split(",")));
  122. return Result.OK("批量删除成功!");
  123. }
  124. /**
  125. * 通过id查询
  126. *
  127. * @param id
  128. * @return
  129. */
  130. @AutoLog(value = "lskzx-通过id查询")
  131. @ApiOperation(value="lskzx-通过id查询", notes="lskzx-通过id查询")
  132. @GetMapping(value = "/queryById")
  133. public Result<?> queryById(@RequestParam(name="id",required=true) String id) {
  134. Lskzx lskzx = lskzxService.getById(id);
  135. if(lskzx==null) {
  136. return Result.error("未找到对应数据");
  137. }
  138. return Result.OK(lskzx);
  139. }
  140. /**
  141. * 通过id查询Geometry
  142. *
  143. * @param id
  144. * @return
  145. */
  146. @AutoLog(value = "lskzx-通过id查询Geometry")
  147. @ApiOperation(value="lskzx-通过id查询Geometry", notes="lskzx-通过id查询Geometry")
  148. @GetMapping(value = "/getGeojsonById")
  149. public Result<?> getGeojsonById(@RequestParam(name = "id",required = true) String id){
  150. String geom = lskzxService.getGeojson(id);
  151. JSONObject geoJson = JSONObject.parseObject(geom);
  152. return Result.OK(geoJson);
  153. }
  154. /**
  155. * 导出excel
  156. *
  157. * @param request
  158. * @param lskzx
  159. */
  160. @RequestMapping(value = "/exportXls")
  161. public ModelAndView exportXls(HttpServletRequest request, Lskzx lskzx) {
  162. return super.exportXls(request, lskzx, Lskzx.class, "lskzx");
  163. }
  164. /**
  165. * 通过excel导入数据
  166. *
  167. * @param request
  168. * @param response
  169. * @return
  170. */
  171. @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
  172. public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
  173. return super.importExcel(request, response, Lskzx.class);
  174. }
  175. }