From 5fc3aab046809ec03d59bd494a0cc91debeec251 Mon Sep 17 00:00:00 2001
From: wl <173@qq.com>
Date: 星期二, 27 九月 2022 18:24:12 +0800
Subject: [PATCH] 违规事项设置 列表和删除 违建事项设置 列表和删除

---
 ycl-platform/src/main/java/com/ycl/entity/store/StoreInfo.java                           |    4 
 ycl-platform/src/main/java/com/ycl/controller/caseHandler/IllegalBuildingController.java |   49 ++++++++-
 ycl-platform/src/main/java/com/ycl/entity/store/StoreScoreRule.java                      |    3 
 ycl-platform/src/main/java/com/ycl/service/dict/IDataDictionaryService.java              |    5 +
 ycl-platform/src/main/java/com/ycl/service/dict/impl/DataDictionaryServiceImpl.java      |   13 ++
 ycl-platform/src/main/java/com/ycl/vo/ViolationSettingVO.java                            |   47 +++++++++
 ycl-platform/src/main/java/com/ycl/controller/caseHandler/ViolationsController.java      |   41 +++++++
 ycl-platform/src/main/java/com/ycl/mapper/dict/DataDictionaryMapper.java                 |    4 
 ycl-platform/src/main/java/com/ycl/vo/IllegalBuildingSettingVO.java                      |   36 +++++++
 ycl-platform/src/main/resources/mapper/dict/DataDictionaryMapper.xml                     |   49 +++++++++
 10 files changed, 239 insertions(+), 12 deletions(-)

diff --git a/ycl-platform/src/main/java/com/ycl/controller/caseHandler/IllegalBuildingController.java b/ycl-platform/src/main/java/com/ycl/controller/caseHandler/IllegalBuildingController.java
index 55cfe2a..3c0e5c5 100644
--- a/ycl-platform/src/main/java/com/ycl/controller/caseHandler/IllegalBuildingController.java
+++ b/ycl-platform/src/main/java/com/ycl/controller/caseHandler/IllegalBuildingController.java
@@ -1,10 +1,18 @@
 package com.ycl.controller.caseHandler;
 
 
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+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 org.springframework.web.bind.annotation.RequestMapping;
-
-import org.springframework.web.bind.annotation.RestController;
+import com.ycl.entity.dict.DataDictionary;
+import com.ycl.service.caseHandler.IIllegalBuildingService;
+import com.ycl.service.dict.IDataDictionaryService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
 
 
 /**
@@ -16,7 +24,38 @@
  * @since 2022-09-24
  */
 @RestController
-@RequestMapping("/illegal-building")
+@RequestMapping("/illegal_building")
+@Api(tags = "杩濆缓浜嬩欢绫诲瀷璁剧疆")
 public class IllegalBuildingController extends BaseController {
 
-}
+    @Autowired
+    IDataDictionaryService iDataDictionaryService;
+
+    /**
+     * @Description 鏌ヨ杩濆缓绫诲瀷
+     * @Param [size, current, keyWord]
+     * @return com.ycl.api.CommonResult
+     **/
+    @ApiOperation(value = "鏌ヨ杩濆缓绫诲瀷")
+    @GetMapping("/query")
+    public CommonResult searchIllegalBuilding(@RequestParam Integer size,
+                                              @RequestParam Integer current,
+                                              @RequestParam(required = false) String keyWord) {
+        Page<DataDictionary> dataDictionaryPage = new Page<>();
+        dataDictionaryPage.setSize(size);
+        dataDictionaryPage.setCurrent(current);
+        return CommonResult.success(iDataDictionaryService.listIllegalBuildingSettings(dataDictionaryPage,keyWord));
+    }
+
+    /**
+     * @Description  delete illegal building by id
+     * @Param [id]
+     * @return com.ycl.api.CommonResult
+     **/
+    @ApiOperation(value = "鍒犻櫎杩濆缓绫诲瀷")
+    @DeleteMapping("/delete")
+    public CommonResult removeIllegalBuilding(@RequestParam Integer id){
+        return CommonResult.success(iDataDictionaryService.removeById(id));
+    }
+
+}
\ No newline at end of file
diff --git a/ycl-platform/src/main/java/com/ycl/controller/caseHandler/ViolationsController.java b/ycl-platform/src/main/java/com/ycl/controller/caseHandler/ViolationsController.java
index c4a975b..81f1d9f 100644
--- a/ycl-platform/src/main/java/com/ycl/controller/caseHandler/ViolationsController.java
+++ b/ycl-platform/src/main/java/com/ycl/controller/caseHandler/ViolationsController.java
@@ -1,10 +1,15 @@
 package com.ycl.controller.caseHandler;
 
 
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ycl.api.CommonResult;
 import com.ycl.controller.BaseController;
-import org.springframework.web.bind.annotation.RequestMapping;
-
-import org.springframework.web.bind.annotation.RestController;
+import com.ycl.entity.dict.DataDictionary;
+import com.ycl.service.dict.IDataDictionaryService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
 
 
 /**
@@ -17,6 +22,36 @@
  */
 @RestController
 @RequestMapping("/violations")
+@Api(tags = "杩濊浜嬮」璁剧疆")
 public class ViolationsController extends BaseController {
+    @Autowired
+    IDataDictionaryService iDataDictionaryService;
+
+    /**
+     * @Description 鏌ヨ杩濆缓绫诲瀷
+     * @Param [size, current, keyWord]
+     * @return com.ycl.api.CommonResult
+     **/
+    @ApiOperation(value = "鏌ヨ杩濊绫诲瀷")
+    @GetMapping("/query")
+    public CommonResult searchIllegalBuilding(@RequestParam Integer size,
+                                              @RequestParam Integer current,
+                                              @RequestParam(required = false) String keyWord) {
+        Page<DataDictionary> dataDictionaryPage = new Page<>();
+        dataDictionaryPage.setSize(size);
+        dataDictionaryPage.setCurrent(current);
+        return CommonResult.success(iDataDictionaryService.listViolations(dataDictionaryPage,keyWord));
+    }
+
+    /**
+     * @Description  delete illegal building by id
+     * @Param [id]
+     * @return com.ycl.api.CommonResult
+     **/
+    @ApiOperation(value = "鍒犻櫎杩濊绫诲瀷")
+    @DeleteMapping("/delete")
+    public CommonResult removeIllegalBuilding(@RequestParam Integer id){
+        return CommonResult.success(iDataDictionaryService.removeById(id));
+    }
 
 }
diff --git a/ycl-platform/src/main/java/com/ycl/entity/store/StoreInfo.java b/ycl-platform/src/main/java/com/ycl/entity/store/StoreInfo.java
index 89cb0e4..360c80a 100644
--- a/ycl-platform/src/main/java/com/ycl/entity/store/StoreInfo.java
+++ b/ycl-platform/src/main/java/com/ycl/entity/store/StoreInfo.java
@@ -8,7 +8,7 @@
 import io.swagger.annotations.ApiModelProperty;
 import lombok.*;
 
-import java.io.Serial;
+
 import java.io.Serializable;
 import java.math.BigDecimal;
 
@@ -29,7 +29,7 @@
 @Builder
 public class StoreInfo implements Serializable {
 
-    @Serial
+
     private static final long serialVersionUID = 1L;
 
     @ApiModelProperty("涓婚敭")
diff --git a/ycl-platform/src/main/java/com/ycl/entity/store/StoreScoreRule.java b/ycl-platform/src/main/java/com/ycl/entity/store/StoreScoreRule.java
index 2517486..a42497d 100644
--- a/ycl-platform/src/main/java/com/ycl/entity/store/StoreScoreRule.java
+++ b/ycl-platform/src/main/java/com/ycl/entity/store/StoreScoreRule.java
@@ -7,7 +7,6 @@
 import io.swagger.annotations.ApiModelProperty;
 import lombok.*;
 
-import java.io.Serial;
 import java.io.Serializable;
 import java.math.BigDecimal;
 
@@ -28,7 +27,7 @@
 @Builder
 public class StoreScoreRule implements Serializable {
 
-    @Serial
+
     private static final long serialVersionUID = 1L;
 
     @ApiModelProperty("涓婚敭")
diff --git a/ycl-platform/src/main/java/com/ycl/mapper/dict/DataDictionaryMapper.java b/ycl-platform/src/main/java/com/ycl/mapper/dict/DataDictionaryMapper.java
index d3a5bdd..dc16764 100644
--- a/ycl-platform/src/main/java/com/ycl/mapper/dict/DataDictionaryMapper.java
+++ b/ycl-platform/src/main/java/com/ycl/mapper/dict/DataDictionaryMapper.java
@@ -1,6 +1,7 @@
 package com.ycl.mapper.dict;
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.ycl.entity.dict.DataDictionary;
 
 /**
@@ -13,4 +14,7 @@
  */
 public interface DataDictionaryMapper extends BaseMapper<DataDictionary> {
 
+    Page<DataDictionary> listDataDictionaryPage(Page<DataDictionary> dataDictionaryPage, String keyWord);
+
+    Page<DataDictionary> listViolationPage(Page<DataDictionary> dataDictionaryPage, String keyWord);
 }
diff --git a/ycl-platform/src/main/java/com/ycl/service/dict/IDataDictionaryService.java b/ycl-platform/src/main/java/com/ycl/service/dict/IDataDictionaryService.java
index 0066cb1..78fb676 100644
--- a/ycl-platform/src/main/java/com/ycl/service/dict/IDataDictionaryService.java
+++ b/ycl-platform/src/main/java/com/ycl/service/dict/IDataDictionaryService.java
@@ -1,5 +1,6 @@
 package com.ycl.service.dict;
 
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.IService;
 import com.ycl.entity.dict.DataDictionary;
 
@@ -26,4 +27,8 @@
      * @return
      */
     DataDictionary queryByCode(String code);
+
+    Page listIllegalBuildingSettings(Page<DataDictionary> dataDictionaryPage, String keyWork);
+
+    Page listViolations(Page<DataDictionary> dataDictionaryPage, String keyWord);
 }
diff --git a/ycl-platform/src/main/java/com/ycl/service/dict/impl/DataDictionaryServiceImpl.java b/ycl-platform/src/main/java/com/ycl/service/dict/impl/DataDictionaryServiceImpl.java
index 16a4554..0586ddf 100644
--- a/ycl-platform/src/main/java/com/ycl/service/dict/impl/DataDictionaryServiceImpl.java
+++ b/ycl-platform/src/main/java/com/ycl/service/dict/impl/DataDictionaryServiceImpl.java
@@ -3,6 +3,7 @@
 import com.alibaba.fastjson.JSON;
 import com.alibaba.fastjson.JSONArray;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.ycl.entity.dict.DataDictionary;
 import com.ycl.mapper.dict.DataDictionaryMapper;
@@ -52,4 +53,16 @@
         DataDictionary dataDictionary = dataDictionaryMapper.selectOne(queryWrapper);
         return dataDictionary;
     }
+
+    @Override
+    public Page listIllegalBuildingSettings(Page<DataDictionary> dataDictionaryPage, String keyWord) {
+        Page<DataDictionary> dataDictionaryPageList = dataDictionaryMapper.listDataDictionaryPage(dataDictionaryPage,keyWord);
+        return dataDictionaryPageList;
+    }
+
+    @Override
+    public Page listViolations(Page<DataDictionary> dataDictionaryPage, String keyWord) {
+        Page<DataDictionary> dataDictionaryPageList = dataDictionaryMapper.listViolationPage(dataDictionaryPage,keyWord);
+        return dataDictionaryPageList;
+    }
 }
diff --git a/ycl-platform/src/main/java/com/ycl/vo/IllegalBuildingSettingVO.java b/ycl-platform/src/main/java/com/ycl/vo/IllegalBuildingSettingVO.java
new file mode 100644
index 0000000..6de1029
--- /dev/null
+++ b/ycl-platform/src/main/java/com/ycl/vo/IllegalBuildingSettingVO.java
@@ -0,0 +1,36 @@
+package com.ycl.vo;
+
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+/**
+ * <p>
+ *
+ * </p>
+ *
+ * @author wl
+ * @since 2022-09-27
+ */
+@Data
+@ApiModel("杩濆缓浜嬮」璁剧疆")
+public class IllegalBuildingSettingVO {
+    /**
+     * 杩濊浜嬮」缂栧彿
+     */
+    @ApiModelProperty(value ="杩濆缓浜嬮」缂栧彿" )
+    private Integer number;
+
+    /**
+     * 鎵�灞炵被鍨�
+     */
+    @ApiModelProperty(value = "鎵�灞炵被鍨�",dataType = "String")
+    private String type;
+
+    /**
+     * 鎵�灞炵被鍒�
+     */
+    @ApiModelProperty(value = "鎵�灞炵被鍒�",dataType = "String")
+    private String typeFirst;
+
+}
\ No newline at end of file
diff --git a/ycl-platform/src/main/java/com/ycl/vo/ViolationSettingVO.java b/ycl-platform/src/main/java/com/ycl/vo/ViolationSettingVO.java
new file mode 100644
index 0000000..5d966a4
--- /dev/null
+++ b/ycl-platform/src/main/java/com/ycl/vo/ViolationSettingVO.java
@@ -0,0 +1,47 @@
+package com.ycl.vo;
+
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+/**
+ * <p>
+ *
+ * </p>
+ *
+ * @author wl
+ * @since 2022-09-27
+ */
+@Data
+@ApiModel("杩濊浜嬮」璁剧疆")
+public class ViolationSettingVO {
+    /**
+     * 杩濊浜嬮」缂栧彿
+     */
+    @ApiModelProperty(value ="杩濊浜嬮」缂栧彿" )
+    private Integer number;
+
+    /**
+     * 鎵�灞炵被鍨�
+     */
+    @ApiModelProperty(value = "鎵�灞炵被鍨�",dataType = "String")
+    private String type;
+
+    /**
+     * 鎵�灞炲ぇ绫�
+     */
+    @ApiModelProperty(value = "鎵�灞炲ぇ绫�",dataType = "String")
+    private String typeFirst;
+
+    /**
+     * 鎵�灞炲皬绫�
+     */
+    @ApiModelProperty(value = "鎵�灞炲皬绫�",dataType = "String")
+    private String typeSecond;
+
+    /**
+     * 妗堢敱
+     */
+    @ApiModelProperty(value = "妗堢敱",dataType = "String")
+    private String typeThird;
+}
\ No newline at end of file
diff --git a/ycl-platform/src/main/resources/mapper/dict/DataDictionaryMapper.xml b/ycl-platform/src/main/resources/mapper/dict/DataDictionaryMapper.xml
index 355abb6..d21673b 100644
--- a/ycl-platform/src/main/resources/mapper/dict/DataDictionaryMapper.xml
+++ b/ycl-platform/src/main/resources/mapper/dict/DataDictionaryMapper.xml
@@ -19,4 +19,53 @@
         id, name, code, type_name,type_code,parent_id,level,remark
     </sql>
 
+    <resultMap id="settingsResultMap" type="com.ycl.vo.IllegalBuildingSettingVO">
+        <id column="number" property="number" />
+        <result column="type" property="type" />
+        <result column="typeFirst" property="typeFirst" />
+        <result column="typeSecond" property="typeSecond" />
+        <result column="typeThird" property="typeThird" />
+    </resultMap>
+
+
+    <select id="listDataDictionaryPage" resultType="com.ycl.vo.IllegalBuildingSettingVO">
+        SELECT
+        d1.id AS number,
+        d1.`name` AS type,
+        d2.`name` AS typeFirst
+        FROM
+        `ums_data_dictionary` AS d1
+        JOIN ums_data_dictionary AS d2 ON d1.parent_id = d2.id
+        <where>
+            d1.`level` = '2'
+            AND d1.type_code = '06'
+            <if test="keyWord !=null and keyWord !=''">
+                AND d1.`name` LIKE  '%${keyWord}%'
+            </if>
+
+        </where>
+    </select>
+
+    <select id="listViolationPage" resultType="com.ycl.vo.ViolationSettingVO">
+        SELECT
+        d1.id AS number,
+        d1.`name` AS type,
+        d2.`name` AS typeFirst,
+        d3.`name` AS typeSecond,
+        d4.`name` AS typeThird
+        FROM
+        `ums_data_dictionary` AS d1
+        JOIN ums_data_dictionary AS d2 ON d1.parent_id = d2.id
+        JOIN ums_data_dictionary AS d3 ON d2.parent_id = d3.id
+        JOIN ums_data_dictionary AS d4 ON d3.parent_id = d4.id
+        <where>
+            d1.`level` = '4'
+            AND d1.type_code = '01'
+            <if test="keyWord !=null and keyWord !=''">
+                AND d1.`name` LIKE  '%${keyWord}%'
+            </if>
+
+        </where>
+    </select>
+
 </mapper>

--
Gitblit v1.8.0