From 77afcd3428e1b766e14a668bc2684542bbf194ba Mon Sep 17 00:00:00 2001
From: wl <173@qq.com>
Date: 星期五, 16 九月 2022 21:00:09 +0800
Subject: [PATCH] 违规情况接口和修改城市违建
---
ycl-common/src/main/java/com/ycl/entity/platform/zf/VideowarmEventsreport.java | 95 +++++++++++++++++++
ycl-common/src/main/java/com/ycl/service/platform/zf/impl/VideowarmEventsreportServiceImpl.java | 20 ++++
ycl-common/src/main/java/com/ycl/mapper/platform/zf/VideowarmEventsreportMapper.java | 16 +++
ycl-platform/src/main/java/com/ycl/controller/zf/VideowarmEventsreportController.java | 123 ++++++++++++++++++++++++
ycl-platform/src/main/java/com/ycl/controller/zf/EnforcelawReportController.java | 11 +
ycl-common/src/main/java/com/ycl/service/platform/zf/IVideowarmEventsreportService.java | 16 +++
6 files changed, 277 insertions(+), 4 deletions(-)
diff --git a/ycl-common/src/main/java/com/ycl/entity/platform/zf/VideowarmEventsreport.java b/ycl-common/src/main/java/com/ycl/entity/platform/zf/VideowarmEventsreport.java
new file mode 100644
index 0000000..31eae74
--- /dev/null
+++ b/ycl-common/src/main/java/com/ycl/entity/platform/zf/VideowarmEventsreport.java
@@ -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;
+
+
+}
diff --git a/ycl-common/src/main/java/com/ycl/mapper/platform/zf/VideowarmEventsreportMapper.java b/ycl-common/src/main/java/com/ycl/mapper/platform/zf/VideowarmEventsreportMapper.java
new file mode 100644
index 0000000..f9aa4e1
--- /dev/null
+++ b/ycl-common/src/main/java/com/ycl/mapper/platform/zf/VideowarmEventsreportMapper.java
@@ -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> {
+
+}
diff --git a/ycl-common/src/main/java/com/ycl/service/platform/zf/IVideowarmEventsreportService.java b/ycl-common/src/main/java/com/ycl/service/platform/zf/IVideowarmEventsreportService.java
new file mode 100644
index 0000000..a439a1d
--- /dev/null
+++ b/ycl-common/src/main/java/com/ycl/service/platform/zf/IVideowarmEventsreportService.java
@@ -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> {
+
+}
diff --git a/ycl-common/src/main/java/com/ycl/service/platform/zf/impl/VideowarmEventsreportServiceImpl.java b/ycl-common/src/main/java/com/ycl/service/platform/zf/impl/VideowarmEventsreportServiceImpl.java
new file mode 100644
index 0000000..659eafd
--- /dev/null
+++ b/ycl-common/src/main/java/com/ycl/service/platform/zf/impl/VideowarmEventsreportServiceImpl.java
@@ -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 {
+
+}
diff --git a/ycl-platform/src/main/java/com/ycl/controller/zf/EnforcelawReportController.java b/ycl-platform/src/main/java/com/ycl/controller/zf/EnforcelawReportController.java
index c4ede37..c09fa5b 100644
--- a/ycl-platform/src/main/java/com/ycl/controller/zf/EnforcelawReportController.java
+++ b/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,
diff --git a/ycl-platform/src/main/java/com/ycl/controller/zf/VideowarmEventsreportController.java b/ycl-platform/src/main/java/com/ycl/controller/zf/VideowarmEventsreportController.java
new file mode 100644
index 0000000..2c8763c
--- /dev/null
+++ b/ycl-platform/src/main/java/com/ycl/controller/zf/VideowarmEventsreportController.java
@@ -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));
+ }
+}
\ No newline at end of file
--
Gitblit v1.8.0