fix

liyanqi

2022-09-16 1ee68249b31daf1e662275666ffa54df73bffc5f

 ycl-platform/src/main/java/com/ycl/controller/zfreport/EnforcelawReportController.java

@@ -1,10 +1,23 @@
package com.ycl.controller.zfreport;


import com.alibaba.excel.EasyExcel;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
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 io.swagger.annotations.Api;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import io.swagger.annotations.ApiOperation;
import lombok.SneakyThrows;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;
import java.net.URLEncoder;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;

/**
 * <p>
@@ -19,4 +32,90 @@
@Api(tags = "执法管理：违规事项处置管理")
public class EnforcelawReportController extends BaseController {

}
    @Autowired
    IEnforcelawReportService enforcelawReportService;

    @GetMapping("/search")
    @ApiOperation("查询全部城市违建详情")
    public CommonResult getAll(@RequestParam(required = false) String startTime,
                               @RequestParam(required = false) String endTime,
                               @RequestParam(required = false) String community,
                               @RequestParam(required = false) String status,
                               @RequestParam(required = false) String partiesName,
                               @RequestParam(required = false) String partiesID
    ) {
        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));
    }

    @GetMapping("/search/one")
    @ApiOperation("查询城市违建详情")
    public CommonResult getOne(@RequestParam Integer id) {
        return CommonResult.success(enforcelawReportService.getOne(new QueryWrapper<EnforcelawReport>().eq("id", id)));
    }

    @PostMapping("/add")
    @ApiOperation("添加城市违建详情")
    public CommonResult add(@RequestBody EnforcelawReport enforcelawReport) {
        return CommonResult.success(enforcelawReportService.save(enforcelawReport));
    }

    @DeleteMapping("/delete")
    @ApiOperation("删除城市违建详情")
    public CommonResult remove(@RequestParam Integer id) {
        return CommonResult.success(enforcelawReportService.removeById(id));
    }

    @PutMapping("/update")
    @ApiOperation("修改城市违建详情")
    public CommonResult modify(@RequestBody EnforcelawReport enforcelawReport) {
        return CommonResult.success(enforcelawReportService.updateById(enforcelawReport));
    }

    @GetMapping("/download")
    @ApiOperation("查询城市违建详情")
    @SneakyThrows
    public void downloadExcel(@RequestParam(required = false) String startTime,
                              @RequestParam(required = false) String endTime,
                              @RequestParam(required = false) String community,
                              @RequestParam(required = false) String status,
                              @RequestParam(required = false) String partiesName,
                              @RequestParam(required = false) String partiesID,
                              HttpServletResponse response) {
        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);
        }
        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));
    }
}