违规情况接口和修改城市违建

wl

2022-09-16 77afcd3428e1b766e14a668bc2684542bbf194ba

违规情况接口和修改城市违建

 ycl-common/src/main/java/com/ycl/entity/platform/zf/VideowarmEventsreport.java

New file
@@ -0,0 +1,95 @@
package com.ycl.entity.platform.zf;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serializable;
import java.time.LocalDate;
import java.time.LocalDateTime;

/**
 * <p>
 * 
 * </p>
 *
 * @author wl
 * @since 2022-09-16
 */
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("ums_videowarm_eventsreport")
public class VideowarmEventsreport implements Serializable {

    private static final long serialVersionUID = 1L;

    /**
     * 主键
     */
    @TableId(value = "id", type = IdType.AUTO)
    @ExcelIgnore
    private Integer id;

    /**
     * 事件名称
     */
    @TableField("eventName")
    @ExcelProperty(value = "事件名称",index = 0)
    private String eventName;

    /**
     * 所属类型
     */
    @TableField("eventType")
    @ExcelProperty(value = "所属类型",index = 1)
    private String eventType;

    /**
     * 是否关联商铺
     */
    @TableField("associatedShops")
    private String associatedShops;

    /**
     * 所属位置(地图上定位)
     */
    @TableField("eventLocation")
    private String eventLocation;

    /**
     * 所属区域
     */
    @TableField("eventRegion")
    private String eventRegion;

    /**
     * 上传视频/图片(截图)
     */
    @TableField("videoOrImage")
    private String videoOrImage;

    /**
     * 内容描述(违法违章描述)
     */
    @TableField("contentDesc")
    private String contentDesc;

    /**
     * 时间信息
     */
    @TableField("eventTime")
    private LocalDate eventTime;

    /**
     * 创建时间
     */
    @TableField("cTime")
    private LocalDateTime cTime;


}

 ycl-common/src/main/java/com/ycl/mapper/platform/zf/VideowarmEventsreportMapper.java

New file
@@ -0,0 +1,16 @@
package com.ycl.mapper.platform.zf;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ycl.entity.platform.zf.VideowarmEventsreport;

/**
 * <p>
 * Mapper 接口
 * </p>
 *
 * @author wl
 * @since 2022-09-16
 */
public interface VideowarmEventsreportMapper extends BaseMapper<VideowarmEventsreport> {

}

 ycl-common/src/main/java/com/ycl/service/platform/zf/IVideowarmEventsreportService.java

New file
@@ -0,0 +1,16 @@
package com.ycl.service.platform.zf;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ycl.entity.platform.zf.VideowarmEventsreport;

/**
 * <p>
 * 服务类
 * </p>
 *
 * @author lyq
 * @since 2022-09-16
 */
public interface IVideowarmEventsreportService extends IService<VideowarmEventsreport> {

}

 ycl-common/src/main/java/com/ycl/service/platform/zf/impl/VideowarmEventsreportServiceImpl.java

New file
@@ -0,0 +1,20 @@
package com.ycl.service.platform.zf.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.entity.platform.zf.VideowarmEventsreport;
import com.ycl.mapper.platform.zf.VideowarmEventsreportMapper;
import com.ycl.service.platform.zf.IVideowarmEventsreportService;
import org.springframework.stereotype.Service;

/**
 * <p>
 * 服务实现类
 * </p>
 *
 * @author wl
 * @since 2022-09-16
 */
@Service
public class VideowarmEventsreportServiceImpl extends ServiceImpl<VideowarmEventsreportMapper, VideowarmEventsreport> implements IVideowarmEventsreportService {

}

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

@@ -18,6 +18,7 @@
import java.net.URLEncoder;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.stream.Collectors;

/**
 * <p>
@@ -29,7 +30,7 @@
 */
@RestController
@RequestMapping("/enforcelaw-report")
@Api(tags = "执法管理：违规事项处置管理")
@Api(tags = "城市违建")
public class EnforcelawReportController extends BaseController {

    @Autowired
@@ -42,7 +43,9 @@
                               @RequestParam(required = false) String community,
                               @RequestParam(required = false) String status,
                               @RequestParam(required = false) String partiesName,
                               @RequestParam(required = false) String partiesID
                               @RequestParam(required = false) String partiesID,
                               @RequestParam(required = false) Integer current,
                               @RequestParam(required = false) Integer size
    ) {
        QueryWrapper<EnforcelawReport> enforcelawReportQueryWrapper = new QueryWrapper<>();
        if (StringUtils.isNotBlank(startTime) && StringUtils.isNotBlank(endTime)) {
@@ -60,7 +63,7 @@
        if (StringUtils.isNotBlank(partiesID)) {
            enforcelawReportQueryWrapper.eq("partiesID", partiesID);
        }
        return CommonResult.success(enforcelawReportService.list(enforcelawReportQueryWrapper));
        return CommonResult.success(enforcelawReportService.list(enforcelawReportQueryWrapper).stream().skip((current-1)*size).limit(size).collect(Collectors.toList()));
    }
    @GetMapping("/search/one")
    @ApiOperation("查询城市违建详情")
@@ -87,7 +90,7 @@
    }

    @GetMapping("/download")
    @ApiOperation("查询城市违建详情")
    @ApiOperation("导出")
    @SneakyThrows
    public void downloadExcel(@RequestParam(required = false) String startTime,
                              @RequestParam(required = false) String endTime,

 ycl-platform/src/main/java/com/ycl/controller/zf/VideowarmEventsreportController.java

New file
@@ -0,0 +1,123 @@
package com.ycl.controller.zf;


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.VideowarmEventsreport;
import com.ycl.service.platform.zf.IVideowarmEventsreportService;
import io.swagger.annotations.Api;
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;
import java.util.stream.Collectors;

/**
 * <p>
 * 前端控制器
 * </p>
 *
 * @author wl
 * @since 2022-09-16
 */
@RestController
@RequestMapping("/videowarm-eventsreport")
@Api(value = "VideowarmEventsreportController",tags = "违规情况")
public class VideowarmEventsreportController extends BaseController {

    @Autowired
    IVideowarmEventsreportService iVideowarmEventsreportService;

    @GetMapping("/search")
    @ApiOperation("查询全部违规情况详情")
    public CommonResult getAll(@RequestParam(required = false) String startTime,
                               @RequestParam(required = false) String endTime,
                               @RequestParam(required = false) String eventName,
                               @RequestParam(required = false) String eventType,
                               @RequestParam(required = false) String eventLocation,
                               @RequestParam(required = false) String eventRegion,
                               @RequestParam(required = false) Integer current,
                               @RequestParam(required = false) Integer size
    ) {
        QueryWrapper<VideowarmEventsreport> videowarmEventsreportQueryWrapper = new QueryWrapper<>();
        if (StringUtils.isNotBlank(startTime) && StringUtils.isNotBlank(endTime)) {
            videowarmEventsreportQueryWrapper.between("cTime", startTime, endTime);
        }
        if (StringUtils.isNotBlank(eventName)) {
            videowarmEventsreportQueryWrapper.eq("eventName", eventName);
        }
        if (StringUtils.isNotBlank(eventType)) {
            videowarmEventsreportQueryWrapper.eq("eventType", eventType);
        }
        if (StringUtils.isNotBlank(eventLocation)) {
            videowarmEventsreportQueryWrapper.eq("eventLocation", eventLocation);
        }
        if (StringUtils.isNotBlank(eventRegion)) {
            videowarmEventsreportQueryWrapper.eq("eventRegion", eventRegion);
        }
        return CommonResult.success(iVideowarmEventsreportService.list(videowarmEventsreportQueryWrapper).stream().skip((current-1)*size).limit(size).collect(Collectors.toList()));
    }
    @GetMapping("/search/one")
    @ApiOperation("查询违规情况详情")
    public CommonResult getOne(@RequestParam Integer id) {
        return CommonResult.success(iVideowarmEventsreportService.getOne(new QueryWrapper<VideowarmEventsreport>().eq("id", id)));
    }

    @PostMapping("/add")
    @ApiOperation("添加违规情况详情")
    public CommonResult add(@RequestBody VideowarmEventsreport videowarmEventsreport) {
        return CommonResult.success(iVideowarmEventsreportService.save(videowarmEventsreport));
    }

    @DeleteMapping("/delete")
    @ApiOperation("删除违规情况详情")
    public CommonResult remove(@RequestParam Integer id) {
        return CommonResult.success(iVideowarmEventsreportService.removeById(id));
    }

    @PutMapping("/update")
    @ApiOperation("修改违规情况详情")
    public CommonResult modify(@RequestBody VideowarmEventsreport videowarmEventsreport) {
        return CommonResult.success(iVideowarmEventsreportService.updateById(videowarmEventsreport));
    }

    @GetMapping("/download")
    @ApiOperation("导出")
    @SneakyThrows
    public void downloadExcel(@RequestParam(required = false) String startTime,
                              @RequestParam(required = false) String endTime,
                              @RequestParam(required = false) String eventName,
                              @RequestParam(required = false) String eventType,
                              @RequestParam(required = false) String eventLocation,
                              @RequestParam(required = false) String eventRegion,
                              HttpServletResponse response) {
        QueryWrapper<VideowarmEventsreport> VideowarmEventsreportQueryWrapper = new QueryWrapper<>();
        if (StringUtils.isNotBlank(startTime) && StringUtils.isNotBlank(endTime)) {
            VideowarmEventsreportQueryWrapper.between("cTime", startTime, endTime);
        }
        if (StringUtils.isNotBlank(eventName)) {
            VideowarmEventsreportQueryWrapper.eq("eventName", eventName);
        }
        if (StringUtils.isNotBlank(eventType)) {
            VideowarmEventsreportQueryWrapper.eq("eventType", eventType);
        }
        if (StringUtils.isNotBlank(eventLocation)) {
            VideowarmEventsreportQueryWrapper.eq("eventLocation", eventLocation);
        }
        if (StringUtils.isNotBlank(eventRegion)) {
            VideowarmEventsreportQueryWrapper.eq("eventRegion", eventRegion);
        }
        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(), VideowarmEventsreport.class).sheet("列表").doWrite(iVideowarmEventsreportService.list(VideowarmEventsreportQueryWrapper));
    }
}