From c17cf5ee62f36b929eb14e4ca8bee60617a9c1f9 Mon Sep 17 00:00:00 2001
From: wl <173@qq.com>
Date: 星期四, 15 九月 2022 18:12:47 +0800
Subject: [PATCH] 城市违建相关接口
---
ycl-generator/pom.xml | 6 +++
ycl-common/src/main/java/com/ycl/service/platform/zfreport/impl/EnforcelawReportServiceImpl.java | 4 +-
ycl-platform/src/main/java/com/ycl/controller/zfreport/EnforcelawReportController.java | 106 +++++++++++++++++++++++++++++++++++++++++++++++++++--
ycl-common/src/main/java/com/ycl/entity/platform/zfreport/EnforcelawReport.java | 4 ++
4 files changed, 114 insertions(+), 6 deletions(-)
diff --git a/ycl-common/src/main/java/com/ycl/entity/platform/zfreport/EnforcelawReport.java b/ycl-common/src/main/java/com/ycl/entity/platform/zfreport/EnforcelawReport.java
index 40fb338..7a466da 100644
--- a/ycl-common/src/main/java/com/ycl/entity/platform/zfreport/EnforcelawReport.java
+++ b/ycl-common/src/main/java/com/ycl/entity/platform/zfreport/EnforcelawReport.java
@@ -1,5 +1,6 @@
package com.ycl.entity.platform.zfreport;
+import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
@@ -108,18 +109,21 @@
* 褰撲簨浜哄鍚�
*/
@TableField("partiesName")
+ @ExcelProperty(value = "褰撲簨浜哄鍚�",index = 0)
private String partiesName;
/**
* 褰撲簨浜鸿韩浠借瘉鍙风爜
*/
@TableField("partiesID")
+ @ExcelProperty(value = "褰撲簨浜鸿韩浠借瘉鍙风爜",index = 1)
private String partiesID;
/**
* 褰撲簨浜鸿仈绯荤數璇�
*/
@TableField("partiesPhone")
+ @ExcelProperty(value = "褰撲簨浜鸿仈绯荤數璇�",index = 2)
private String partiesPhone;
/**
diff --git a/ycl-common/src/main/java/com/ycl/service/platform/zfreport/impl/EnforcelawReportServiceImpl.java b/ycl-common/src/main/java/com/ycl/service/platform/zfreport/impl/EnforcelawReportServiceImpl.java
index fcee2e8..2d06c87 100644
--- a/ycl-common/src/main/java/com/ycl/service/platform/zfreport/impl/EnforcelawReportServiceImpl.java
+++ b/ycl-common/src/main/java/com/ycl/service/platform/zfreport/impl/EnforcelawReportServiceImpl.java
@@ -3,7 +3,7 @@
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.entity.platform.zfreport.EnforcelawReport;
import com.ycl.mapper.platform.zfreport.EnforcelawReportMapper;
-import com.ycl.service.platform.zfreport.IEnforcelawReportService;
+import com.ycl.service.platform.zfreport.EnforcelawReportService;
import org.springframework.stereotype.Service;
/**
@@ -15,6 +15,6 @@
* @since 2022-09-14
*/
@Service
-public class EnforcelawReportServiceImpl extends ServiceImpl<EnforcelawReportMapper, EnforcelawReport> implements IEnforcelawReportService {
+public class EnforcelawReportServiceImpl extends ServiceImpl<EnforcelawReportMapper, EnforcelawReport> implements EnforcelawReportService {
}
diff --git a/ycl-generator/pom.xml b/ycl-generator/pom.xml
index 88b5a24..8d92dbd 100644
--- a/ycl-generator/pom.xml
+++ b/ycl-generator/pom.xml
@@ -73,6 +73,12 @@
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
+ <dependency>
+ <groupId>io.swagger</groupId>
+ <artifactId>swagger-annotations</artifactId>
+ <version>1.5.22</version>
+ <scope>compile</scope>
+ </dependency>
</dependencies>
<build>
diff --git a/ycl-platform/src/main/java/com/ycl/controller/zfreport/EnforcelawReportController.java b/ycl-platform/src/main/java/com/ycl/controller/zfreport/EnforcelawReportController.java
index da122be..0ea839a 100644
--- a/ycl-platform/src/main/java/com/ycl/controller/zfreport/EnforcelawReportController.java
+++ b/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.zfreport.EnforcelawReport;
+import com.ycl.service.platform.zfreport.EnforcelawReportService;
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,5 +32,90 @@
@Api(tags = "鎵ф硶绠＄悊锛氳繚瑙勪簨椤瑰缃鐞�")
public class EnforcelawReportController extends BaseController {
-
-}
+ @Autowired
+ EnforcelawReportService 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));
+ }
+}
\ No newline at end of file
--
Gitblit v1.8.0