| | |
| | | import com.alibaba.excel.EasyExcel; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.toolkit.StringUtils; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.ycl.api.CommonResult; |
| | | import com.ycl.controller.BaseController; |
| | | import com.ycl.entity.platform.zf.EnforcelawReport; |
| | | import com.ycl.service.platform.zf.IEnforcelawReportService; |
| | | import com.ycl.entity.zf.EnforceLawReport; |
| | | import com.ycl.service.zf.IEnforcelawReportService; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import lombok.SneakyThrows; |
| | |
| | | import java.net.URLEncoder; |
| | | import java.time.LocalDateTime; |
| | | import java.time.format.DateTimeFormatter; |
| | | import java.util.stream.Collectors; |
| | | |
| | | /** |
| | | * <p> |
| | | * 违规事项处置管理:包含违法(违建)情况上报、立案、派遣、处置、核查、结案 前端控制器 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @author wl |
| | | * @since 2022-09-14 |
| | | */ |
| | | @RestController |
| | |
| | | @RequestParam(required = false) Integer current, |
| | | @RequestParam(required = false) Integer size |
| | | ) { |
| | | QueryWrapper<EnforcelawReport> enforcelawReportQueryWrapper = new QueryWrapper<>(); |
| | | if (StringUtils.isNotBlank(startTime) && StringUtils.isNotBlank(endTime)) { |
| | | enforcelawReportQueryWrapper.between("cTime", startTime, endTime); |
| | | } |
| | | if (StringUtils.isNotBlank(community)) { |
| | | enforcelawReportQueryWrapper.eq("community", community); |
| | | } |
| | | if (StringUtils.isNotBlank(status)) { |
| | | enforcelawReportQueryWrapper.eq("status", status); |
| | | } |
| | | if (StringUtils.isNotBlank(partiesName)) { |
| | | enforcelawReportQueryWrapper.eq("partiesName", partiesName); |
| | | } |
| | | if (StringUtils.isNotBlank(partiesID)) { |
| | | enforcelawReportQueryWrapper.eq("partiesID", partiesID); |
| | | } |
| | | return CommonResult.success(enforcelawReportService.list(enforcelawReportQueryWrapper).stream().skip((current-1)*size).limit(size).collect(Collectors.toList())); |
| | | Page<EnforceLawReport> enforcelawReportPage = new Page<>(); |
| | | enforcelawReportPage.setCurrent(current); |
| | | enforcelawReportPage.setSize(size); |
| | | return CommonResult.success(enforcelawReportService.selectPageVo(enforcelawReportPage,startTime,endTime,community,status,partiesName,partiesID)); |
| | | } |
| | | @GetMapping("/search/one") |
| | | @ApiOperation("查询城市违建详情") |
| | | public CommonResult getOne(@RequestParam Integer id) { |
| | | return CommonResult.success(enforcelawReportService.getOne(new QueryWrapper<EnforcelawReport>().eq("id", id))); |
| | | return CommonResult.success(enforcelawReportService.getOne(new QueryWrapper<EnforceLawReport>().eq("id", id))); |
| | | } |
| | | |
| | | @PostMapping("/add") |
| | | @ApiOperation("添加城市违建详情") |
| | | public CommonResult add(@RequestBody EnforcelawReport enforcelawReport) { |
| | | public CommonResult add(@RequestBody EnforceLawReport enforcelawReport) { |
| | | return CommonResult.success(enforcelawReportService.save(enforcelawReport)); |
| | | } |
| | | |
| | |
| | | |
| | | @PutMapping("/update") |
| | | @ApiOperation("修改城市违建详情") |
| | | public CommonResult modify(@RequestBody EnforcelawReport enforcelawReport) { |
| | | public CommonResult modify(@RequestBody EnforceLawReport enforcelawReport) { |
| | | return CommonResult.success(enforcelawReportService.updateById(enforcelawReport)); |
| | | } |
| | | |
| | | @GetMapping("/download") |
| | | @PostMapping("/download") |
| | | @ApiOperation("导出") |
| | | @SneakyThrows |
| | | public void downloadExcel(@RequestParam(required = false) String startTime, |
| | |
| | | @RequestParam(required = false) String partiesName, |
| | | @RequestParam(required = false) String partiesID, |
| | | HttpServletResponse response) { |
| | | QueryWrapper<EnforcelawReport> enforcelawReportQueryWrapper = new QueryWrapper<>(); |
| | | QueryWrapper<EnforceLawReport> enforcelawReportQueryWrapper = new QueryWrapper<>(); |
| | | if (StringUtils.isNotBlank(startTime) && StringUtils.isNotBlank(endTime)) { |
| | | enforcelawReportQueryWrapper.between("cTime", startTime, endTime); |
| | | } |
| | |
| | | response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); |
| | | response.setCharacterEncoding("utf-8"); |
| | | response.setHeader("Content-disposition", "attachment;filename=" + LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")) + URLEncoder.encode("城市违建" + ".xlsx", "utf-8")); |
| | | EasyExcel.write(response.getOutputStream(), EnforcelawReport.class).sheet("列表").doWrite(enforcelawReportService.list(enforcelawReportQueryWrapper)); |
| | | EasyExcel.write(response.getOutputStream(), EnforceLawReport.class).sheet("列表").doWrite(enforcelawReportService.list(enforcelawReportQueryWrapper)); |
| | | } |
| | | } |