From 4854f5e5a08236e197a883705e946bf474c394eb Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期二, 12 三月 2024 15:49:19 +0800
Subject: [PATCH] 地域管理
---
ycl-server/src/main/java/com/ycl/platform/controller/RegionController.java | 81 +++++++
ycl-pojo/src/main/java/com/ycl/platform/domain/form/RegionForm.java | 60 +++++
ycl-pojo/src/main/java/com/ycl/platform/domain/query/RegionQuery.java | 43 +++
ycl-pojo/src/main/java/com/ycl/platform/domain/entity/Region.java | 51 ++++
ycl-pojo/src/main/java/com/ycl/platform/domain/vo/RegionVO.java | 52 ++++
ycl-server/src/main/java/com/ycl/platform/service/RegionService.java | 71 ++++++
ycl-server/src/main/resources/mapper/zgyw/RegionMapper.xml | 18 +
ycl-server/src/main/java/com/ycl/platform/mapper/RegionMapper.java | 19 +
ycl-common/src/main/java/enumeration/general/RegionLevelEnum.java | 33 +++
ycl-server/src/main/java/com/ycl/platform/service/impl/RegionServiceImpl.java | 174 +++++++++++++++
10 files changed, 602 insertions(+), 0 deletions(-)
diff --git a/ycl-common/src/main/java/enumeration/general/RegionLevelEnum.java b/ycl-common/src/main/java/enumeration/general/RegionLevelEnum.java
new file mode 100644
index 0000000..f9b7475
--- /dev/null
+++ b/ycl-common/src/main/java/enumeration/general/RegionLevelEnum.java
@@ -0,0 +1,33 @@
+package enumeration.general;
+
+import com.baomidou.mybatisplus.annotation.EnumValue;
+import com.fasterxml.jackson.annotation.JsonValue;
+import lombok.Getter;
+
+/**
+ * 鍦板尯绾у埆
+ *
+ * @author锛歺p
+ * @date锛�2024/3/12 14:32
+ */
+@Getter
+public enum RegionLevelEnum {
+
+ CITY("city", "甯�"),
+ COUNTY("county", "鍖哄幙"),
+ STREET("street", "琛楅亾"),
+ ;
+
+
+ @EnumValue
+ private String code;
+
+ @JsonValue
+ private String value;
+
+
+ RegionLevelEnum(String code, String value) {
+ this.code = code;
+ this.value = value;
+ }
+}
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/Region.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/Region.java
new file mode 100644
index 0000000..658d884
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/Region.java
@@ -0,0 +1,51 @@
+package com.ycl.platform.domain.entity;
+
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.ycl.platform.base.AbsEntity;
+import enumeration.general.RegionLevelEnum;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import lombok.experimental.Accessors;
+
+/**
+ * 鍦板煙
+ *
+ * @author xp
+ * @since 2024-03-12
+ */
+@Data
+@Accessors(chain = true)
+@TableName("t_region")
+@ApiModel(value = "Region瀵硅薄", description = "鍦板煙")
+public class Region extends AbsEntity {
+
+ private static final long serialVersionUID = 1L;
+
+ @ApiModelProperty("鍖哄煙鍏ㄧО")
+ @TableField("full_name")
+ private String fullName;
+
+ @ApiModelProperty("鍖哄煙绠�绉�")
+ @TableField("simple_name")
+ private String simpleName;
+
+ @ApiModelProperty("鍦板煙绾у埆")
+ @TableField("region_level")
+ private RegionLevelEnum regionLevel;
+
+ @ApiModelProperty("甯�")
+ @TableField("city")
+ private String city;
+
+ @ApiModelProperty("鍖哄幙")
+ @TableField("county")
+ private String county;
+
+ @ApiModelProperty("鐖剁骇id")
+ @TableField("parent_id")
+ private Integer parentId;
+
+
+}
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/form/RegionForm.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/form/RegionForm.java
new file mode 100644
index 0000000..747af70
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/form/RegionForm.java
@@ -0,0 +1,60 @@
+package com.ycl.platform.domain.form;
+
+import com.ycl.system.domain.group.Update;
+import com.ycl.system.domain.group.Add;
+import com.ycl.platform.base.AbsForm;
+import com.ycl.platform.domain.entity.Region;
+import java.time.LocalDateTime;
+
+import enumeration.general.RegionLevelEnum;
+import org.springframework.beans.BeanUtils;
+import jakarta.validation.constraints.NotBlank;
+import jakarta.validation.constraints.NotNull;
+import org.springframework.lang.NonNull;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import lombok.experimental.Accessors;
+
+/**
+ * 鍦板煙琛ㄥ崟
+ *
+ * @author xp
+ * @since 2024-03-12
+ */
+@Data
+@Accessors(chain = true)
+@ApiModel(value = "Region琛ㄥ崟", description = "鍦板煙琛ㄥ崟")
+public class RegionForm extends AbsForm {
+
+ @NotBlank(message = "鍖哄煙鍏ㄧО涓嶈兘涓虹┖", groups = {Add.class, Update.class})
+ @ApiModelProperty("鍖哄煙鍏ㄧО")
+ private String fullName;
+
+ @NotBlank(message = "鍖哄煙绠�绉颁笉鑳戒负绌�", groups = {Add.class, Update.class})
+ @ApiModelProperty("鍖哄煙绠�绉�")
+ private String simpleName;
+
+ @ApiModelProperty("鍦板煙绾у埆")
+ private RegionLevelEnum regionLevel;
+
+ @NotBlank(message = "甯備笉鑳戒负绌�", groups = {Add.class, Update.class})
+ @ApiModelProperty("甯�")
+ private String city;
+
+ @NotBlank(message = "鍖哄幙涓嶈兘涓虹┖", groups = {Add.class, Update.class})
+ @ApiModelProperty("鍖哄幙")
+ private String county;
+
+ @ApiModelProperty("鐖剁骇id")
+ private Integer parentId;
+
+ public static Region getEntityByForm(@NonNull RegionForm form, Region entity) {
+ if(entity == null) {
+ entity = new Region();
+ }
+ BeanUtils.copyProperties(form, entity);
+ return entity;
+ }
+
+}
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/query/RegionQuery.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/query/RegionQuery.java
new file mode 100644
index 0000000..0db5840
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/query/RegionQuery.java
@@ -0,0 +1,43 @@
+package com.ycl.platform.domain.query;
+
+import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ycl.platform.base.AbsQuery;
+
+import java.util.Date;
+import java.util.List;
+
+import enumeration.general.RegionLevelEnum;
+import org.springframework.lang.NonNull;
+import jakarta.validation.constraints.NotBlank;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import lombok.experimental.Accessors;
+
+/**
+ * 鍦板煙鏌ヨ
+ *
+ * @author xp
+ * @since 2024-03-12
+ */
+@Data
+@Accessors(chain = true)
+@ApiModel(value = "Region鏌ヨ", description = "鍦板煙鏌ヨ")
+public class RegionQuery extends AbsQuery {
+
+ private String fullName;
+
+ private String simpleName;
+
+ private Integer parentId;
+
+ private String regionLevel;
+
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ private Date start;
+
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ private Date end;
+
+}
+
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/RegionVO.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/RegionVO.java
new file mode 100644
index 0000000..16d1da7
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/RegionVO.java
@@ -0,0 +1,52 @@
+package com.ycl.platform.domain.vo;
+
+import com.ycl.platform.base.AbsVo;
+import com.ycl.platform.domain.entity.Region;
+import java.util.List;
+import java.time.LocalDateTime;
+
+import enumeration.general.RegionLevelEnum;
+import org.springframework.lang.NonNull;
+import org.springframework.beans.BeanUtils;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import lombok.experimental.Accessors;
+
+/**
+ * 鍦板煙灞曠ず
+ *
+ * @author xp
+ * @since 2024-03-12
+ */
+@Data
+@Accessors(chain = true)
+public class RegionVO extends AbsVo {
+
+ /** 鍖哄煙鍏ㄧО */
+ private String fullName;
+
+ /** 鍖哄煙绠�绉� */
+ private String simpleName;
+
+ /** 鍦板煙绾у埆 */
+ private RegionLevelEnum regionLevel;
+
+ /** 甯� */
+ private String city;
+
+ /** 鍖哄幙 */
+ private String county;
+
+ /** 鐖剁骇id */
+ private Integer parentId;
+
+ public static RegionVO getVoByEntity(@NonNull Region entity, RegionVO vo) {
+ if(vo == null) {
+ vo = new RegionVO();
+ }
+ BeanUtils.copyProperties(entity, vo);
+ return vo;
+ }
+
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/controller/RegionController.java b/ycl-server/src/main/java/com/ycl/platform/controller/RegionController.java
new file mode 100644
index 0000000..d00f065
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/controller/RegionController.java
@@ -0,0 +1,81 @@
+package com.ycl.platform.controller;
+
+import com.ycl.system.domain.group.Update;
+import com.ycl.system.domain.group.Add;
+import org.springframework.validation.annotation.Validated;
+import lombok.RequiredArgsConstructor;
+import java.util.List;
+import org.springframework.validation.annotation.Validated;
+import jakarta.validation.constraints.NotEmpty;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import com.ycl.platform.service.RegionService;
+import com.ycl.system.Result;
+import com.ycl.platform.domain.form.RegionForm;
+import com.ycl.platform.domain.query.RegionQuery;
+import lombok.RequiredArgsConstructor;
+import org.springframework.web.bind.annotation.*;
+
+/**
+ * 鍦板煙 鍓嶇鎺у埗鍣�
+ *
+ * @author xp
+ * @since 2024-03-12
+ */
+@Validated
+@RequiredArgsConstructor
+@Api(value = "鍦板煙", tags = "鍦板煙绠＄悊")
+@RestController
+@RequestMapping("/region")
+public class RegionController {
+
+ private final RegionService regionService;
+
+ @PostMapping
+ @ApiOperation(value = "娣诲姞", notes = "娣诲姞")
+ public Result add(@RequestBody @Validated(Add.class) RegionForm form) {
+ return regionService.add(form);
+ }
+
+ @PutMapping
+ @ApiOperation(value = "淇敼", notes = "淇敼")
+ public Result update(@RequestBody @Validated(Update.class) RegionForm form) {
+ return regionService.update(form);
+ }
+
+ @DeleteMapping("/{id}")
+ @ApiOperation(value = "ID鍒犻櫎", notes = "ID鍒犻櫎")
+ public Result removeById(@PathVariable("id") String id) {
+ return regionService.removeById(id);
+ }
+
+ @DeleteMapping("/batch")
+ @ApiOperation(value = "鎵归噺鍒犻櫎", notes = "鎵归噺鍒犻櫎")
+ public Result remove(@RequestBody @NotEmpty(message = "璇烽�夋嫨鏁版嵁") List<String> ids) {
+ return regionService.remove(ids);
+ }
+
+ @PostMapping("/page")
+ @ApiOperation(value = "鍒嗛〉", notes = "鍒嗛〉")
+ public Result page(@RequestBody RegionQuery query) {
+ return regionService.page(query);
+ }
+
+ @GetMapping("/{id}")
+ @ApiOperation(value = "璇︽儏", notes = "璇︽儏")
+ public Result detail(@PathVariable("id") String id) {
+ return regionService.detail(id);
+ }
+
+ @GetMapping("/list")
+ @ApiOperation(value = "鍒楄〃", notes = "鍒楄〃")
+ public Result list() {
+ return regionService.all();
+ }
+
+ @GetMapping("/counties")
+ @ApiOperation(value = "鍖哄幙鍒楄〃", notes = "鍖哄幙鍒楄〃")
+ public Result counties() {
+ return regionService.counties();
+ }
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/mapper/RegionMapper.java b/ycl-server/src/main/java/com/ycl/platform/mapper/RegionMapper.java
new file mode 100644
index 0000000..405a7f2
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/mapper/RegionMapper.java
@@ -0,0 +1,19 @@
+package com.ycl.platform.mapper;
+
+import com.ycl.platform.domain.entity.Region;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ycl.platform.domain.vo.RegionVO;
+import com.ycl.platform.domain.form.RegionForm;
+import java.util.List;
+import org.apache.ibatis.annotations.Mapper;
+
+/**
+ * 鍦板煙 Mapper 鎺ュ彛
+ *
+ * @author xp
+ * @since 2024-03-12
+ */
+@Mapper
+public interface RegionMapper extends BaseMapper<Region> {
+
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/service/RegionService.java b/ycl-server/src/main/java/com/ycl/platform/service/RegionService.java
new file mode 100644
index 0000000..ea891e4
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/service/RegionService.java
@@ -0,0 +1,71 @@
+package com.ycl.platform.service;
+
+import com.ycl.platform.domain.entity.Region;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ycl.system.Result;
+import com.ycl.platform.domain.form.RegionForm;
+import com.ycl.platform.domain.query.RegionQuery;
+import java.util.List;
+
+/**
+ * 鍦板煙 鏈嶅姟绫�
+ *
+ * @author xp
+ * @since 2024-03-12
+ */
+public interface RegionService extends IService<Region> {
+
+ /**
+ * 娣诲姞
+ * @param form
+ * @return
+ */
+ Result add(RegionForm form);
+
+ /**
+ * 淇敼
+ * @param form
+ * @return
+ */
+ Result update(RegionForm form);
+
+ /**
+ * 鎵归噺鍒犻櫎
+ * @param ids
+ * @return
+ */
+ Result remove(List<String> ids);
+
+ /**
+ * id鍒犻櫎
+ * @param id
+ * @return
+ */
+ Result removeById(String id);
+
+ /**
+ * 鍒嗛〉鏌ヨ
+ * @param query
+ * @return
+ */
+ Result page(RegionQuery query);
+
+ /**
+ * 鏍规嵁id鏌ユ壘
+ * @param id
+ * @return
+ */
+ Result detail(String id);
+
+ /**
+ * 鍒楄〃
+ * @return
+ */
+ Result all();
+
+ /**
+ * 鍖哄幙鍒楄〃
+ * @return
+ */
+ Result counties();
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/RegionServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/RegionServiceImpl.java
new file mode 100644
index 0000000..713130a
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/RegionServiceImpl.java
@@ -0,0 +1,174 @@
+package com.ycl.platform.service.impl;
+
+import com.ycl.platform.base.BaseSelect;
+import com.ycl.platform.domain.entity.Region;
+import com.ycl.platform.domain.entity.YwUnit;
+import com.ycl.platform.mapper.RegionMapper;
+import com.ycl.platform.service.RegionService;
+import com.ycl.system.Result;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ycl.platform.domain.form.RegionForm;
+import com.ycl.platform.domain.vo.RegionVO;
+import com.ycl.platform.domain.query.RegionQuery;
+import java.util.List;
+
+import com.ycl.utils.DateUtils;
+import enumeration.general.RegionLevelEnum;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.ycl.system.page.PageUtil;
+import org.springframework.stereotype.Service;
+import org.springframework.security.core.context.SecurityContextHolder;
+import org.springframework.beans.BeanUtils;
+import org.springframework.transaction.annotation.Transactional;
+import org.springframework.util.Assert;
+import java.util.ArrayList;
+import java.util.Objects;
+import java.util.stream.Collectors;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
+import lombok.RequiredArgsConstructor;
+import org.springframework.util.StringUtils;
+
+/**
+ * 鍦板煙 鏈嶅姟瀹炵幇绫�
+ *
+ * @author xp
+ * @since 2024-03-12
+ */
+@Service
+@RequiredArgsConstructor
+public class RegionServiceImpl extends ServiceImpl<RegionMapper, Region> implements RegionService {
+
+ private final RegionMapper regionMapper;
+
+ /**
+ * 娣诲姞
+ * @param form
+ * @return
+ */
+ @Override
+ public Result add(RegionForm form) {
+ Region entity = RegionForm.getEntityByForm(form, null);
+ entity.setRegionLevel(RegionLevelEnum.STREET);
+ if(baseMapper.insert(entity) > 0) {
+ return Result.ok("娣诲姞鎴愬姛");
+ }
+ return Result.error("娣诲姞澶辫触");
+ }
+
+ /**
+ * 淇敼
+ * @param form
+ * @return
+ */
+ @Override
+ public Result update(RegionForm form) {
+
+ Region entity = baseMapper.selectById(form.getId());
+
+ // 涓虹┖鎶汭llegalArgumentException锛屽仛鍏ㄥ眬寮傚父澶勭悊
+ Assert.notNull(entity, "璁板綍涓嶅瓨鍦�");
+ BeanUtils.copyProperties(form, entity);
+ if (baseMapper.updateById(entity) > 0) {
+ return Result.ok("淇敼鎴愬姛");
+ }
+ return Result.error("淇敼澶辫触");
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎
+ * @param ids
+ * @return
+ */
+ @Override
+ public Result remove(List<String> ids) {
+ if(baseMapper.deleteBatchIds(ids) > 0) {
+ return Result.ok("鍒犻櫎鎴愬姛");
+ }
+ return Result.error("鍒犻櫎澶辫触");
+ }
+
+ /**
+ * id鍒犻櫎
+ * @param id
+ * @return
+ */
+ @Override
+ public Result removeById(String id) {
+ if(baseMapper.deleteById(id) > 0) {
+ return Result.ok("鍒犻櫎鎴愬姛");
+ }
+ return Result.error("鍒犻櫎澶辫触");
+ }
+
+ /**
+ * 鍒嗛〉鏌ヨ
+ * @param query
+ * @return
+ */
+ @Override
+ public Result page(RegionQuery query) {
+
+ IPage<Region> page = new LambdaQueryChainWrapper<>(baseMapper)
+ .like(StringUtils.hasText(query.getFullName()), Region::getFullName, query.getFullName())
+ .like(StringUtils.hasText(query.getSimpleName()), Region::getSimpleName, query.getSimpleName())
+ .eq(Objects.nonNull(query.getParentId()), Region::getParentId, query.getParentId())
+ .eq(StringUtils.hasText(query.getRegionLevel()), Region::getRegionLevel, query.getRegionLevel())
+ .between(Objects.nonNull(query.getStart()) && Objects.nonNull(query.getEnd()),
+ Region::getCreateTime,
+ DateUtils.getDayStart(query.getStart()),
+ DateUtils.getDayEnd(query.getEnd()))
+ .orderByDesc(Region::getCreateTime)
+ .page(PageUtil.getPage(query, Region.class));
+
+ List<RegionVO> vos = page.getRecords().stream()
+ .map(
+ entity -> RegionVO.getVoByEntity(entity, null)
+ )
+ .collect(Collectors.toList());
+ return Result.ok().data(vos).total(page.getTotal());
+ }
+
+ /**
+ * 鏍规嵁id鏌ユ壘
+ * @param id
+ * @return
+ */
+ @Override
+ public Result detail(String id) {
+ Region entity = baseMapper.selectById(id);
+ Assert.notNull(entity, "璁板綍涓嶅瓨鍦�");
+ RegionVO vo = RegionVO.getVoByEntity(entity, null);
+ return Result.ok().data(vo);
+ }
+
+ /**
+ * 鍒楄〃
+ * @return
+ */
+ @Override
+ public Result all() {
+ List<Region> entities = baseMapper.selectList(null);
+ List<RegionVO> vos = entities.stream()
+ .map(
+ entity -> RegionVO.getVoByEntity(entity, null)
+ )
+ .collect(Collectors.toList());
+ return Result.ok().data(vos);
+ }
+
+ @Override
+ public Result counties() {
+ List<Region> entityList = new LambdaQueryChainWrapper<>(baseMapper)
+ .eq(Region::getRegionLevel, RegionLevelEnum.COUNTY)
+ .orderByDesc(Region::getCreateTime)
+ .list();
+ List<BaseSelect> vos = entityList.stream().map(entity -> {
+ BaseSelect vo = new BaseSelect();
+ vo.setId(entity.getId());
+ vo.setValue(entity.getFullName());
+ return vo;
+ }).collect(Collectors.toList());
+ return Result.ok().data(vos);
+ }
+}
diff --git a/ycl-server/src/main/resources/mapper/zgyw/RegionMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/RegionMapper.xml
new file mode 100644
index 0000000..22e7c6d
--- /dev/null
+++ b/ycl-server/src/main/resources/mapper/zgyw/RegionMapper.xml
@@ -0,0 +1,18 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.ycl.platform.mapper.RegionMapper">
+
+ <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 -->
+ <resultMap id="BaseResultMap" type="com.ycl.platform.domain.vo.RegionVO">
+ <result column="id" property="id" />
+ <result column="create_time" property="createTime" />
+ <result column="update_time" property="updateTime" />
+ <result column="full_name" property="fullName" />
+ <result column="simple_name" property="simpleName" />
+ <result column="region_level" property="regionLevel" />
+ <result column="city" property="city" />
+ <result column="county" property="county" />
+ <result column="parent_id" property="parentId" />
+ </resultMap>
+
+</mapper>
--
Gitblit v1.8.0