From 14d54d5cdad154895c12f458a57df9850a6bd442 Mon Sep 17 00:00:00 2001
From: liyj <15602261488@163.com>
Date: Fri, 27 Sep 2024 14:38:11 +0800
Subject: [PATCH] 1、网格地域信息表
---
dyh-service/dyh-cust/src/main/java/cn/huge/module/region/dao/mapper/SyRegionGridMapper.java | 64 ++++++++
dyh-service/dyh-cust/src/main/java/cn/huge/module/region/dao/mapper/xml/SyRegionGridMapper.xml | 157 +++++++++++++++++++
dyh-service/dyh-cust/src/main/java/cn/huge/module/region/service/SyRegionGridService.java | 113 ++++++++++++++
dyh-service/dyh-cust/src/main/java/cn/huge/module/region/domain/bo/SyRegionGridBO.java | 17 ++
dyh-service/dyh-cust/src/main/java/cn/huge/module/region/domain/po/SyRegionGrid.java | 83 ++++++++++
5 files changed, 434 insertions(+), 0 deletions(-)
diff --git a/dyh-service/dyh-cust/src/main/java/cn/huge/module/region/dao/mapper/SyRegionGridMapper.java b/dyh-service/dyh-cust/src/main/java/cn/huge/module/region/dao/mapper/SyRegionGridMapper.java
new file mode 100644
index 0000000..c1d423c
--- /dev/null
+++ b/dyh-service/dyh-cust/src/main/java/cn/huge/module/region/dao/mapper/SyRegionGridMapper.java
@@ -0,0 +1,64 @@
+package cn.huge.module.region.dao.mapper;
+
+import cn.huge.module.region.domain.po.SyRegionGrid;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Param;
+import org.springframework.data.domain.PageRequest;
+import org.springframework.stereotype.Repository;
+
+import java.util.List;
+import java.util.Map;
+
+/**
+* @title: 网格化平台地域字典映射表持久层业务处理
+* @Description 此处仅涉及复杂SQL操作，务必不要在此再次写单表的CRUD操作，因为mybatisPlus已经实现。
+* @company: hugeinfo
+* @author: liyj
+* @time: 2024-09-25 18:03:50
+* @version 1.0.0
+*/
+@Repository
+public interface SyRegionGridMapper extends BaseMapper<SyRegionGrid>{
+
+ /**
+ * 更新对象
+ * @param entity 对象
+ */
+ void updateSyRegionGrid(@Param("entity") SyRegionGrid entity);
+
+ /**
+ * 条件更新对象
+ * @param entity 对象
+ * @param terms 条件
+ */
+ void updateSyRegionGridTerms(@Param("entity") SyRegionGrid entity, @Param("terms") Map<String, Object> terms);
+
+ /**
+ * 根据编号物理删除
+ * @param id 查询条件集合
+ */
+ void deleteSyRegionGrid(@Param("id") String id);
+
+ /**
+ * 按条件查询结果集
+ * @param terms 查询条件集合
+ * @return List<SyRegionGrid>
+ */
+ List<SyRegionGrid> listTerms(@Param("terms") Map<String, Object> terms);
+
+ /**
+ * 按条件查询实体总数
+ * @param terms 查询条件集合
+ * @return long
+ */
+ long countTerms(@Param("terms") Map<String, Object> terms);
+
+ /**
+ * 按条件查询实体分页结果集
+ * @param page 分页对象
+ * @param terms 查询条件集合
+ * @return List<SyRegionGrid>
+ */
+ List<SyRegionGrid> pageTerms(@Param("page") PageRequest page, @Param("terms") Map<String, Object> terms);
+
+}
diff --git a/dyh-service/dyh-cust/src/main/java/cn/huge/module/region/dao/mapper/xml/SyRegionGridMapper.xml b/dyh-service/dyh-cust/src/main/java/cn/huge/module/region/dao/mapper/xml/SyRegionGridMapper.xml
new file mode 100644
index 0000000..d6a6c09
--- /dev/null
+++ b/dyh-service/dyh-cust/src/main/java/cn/huge/module/region/dao/mapper/xml/SyRegionGridMapper.xml
@@ -0,0 +1,157 @@
+<?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">
+<!--
+ * @title: 网格化平台地域字典映射表
+ * @description: 自定义sql，请自行实现业务逻辑
+ * @company: hugeinfo
+ * @author: liyj
+ * @time:2024-09-25 18:03:50
+ * @version 1.0.0
+-->
+<mapper namespace="cn.huge.module.region.dao.mapper.SyRegionGridMapper">
+ <!-- 结果集 -->
+ <resultMap id="dataResult" type="cn.huge.module.region.domain.po.SyRegionGrid">
+ <result property="id" column="id"/>
+ <result property="thirdSysId" column="third_sys_id"/>
+ <result property="thirdSysName" column="third_sys_name"/>
+ <result property="thirdCode" column="third_code"/>
+ <result property="thirdName" column="third_name"/>
+ <result property="thirdParentId" column="third_parent_id"/>
+ <result property="regionId" column="region_id"/>
+ <result property="level" column="level"/>
+ <result property="createTime" column="create_time"/>
+ <result property="updateTime" column="update_time"/>
+ </resultMap>
+ <!-- 表 -->
+ <sql id='table-name'>dyh_sy_region_grid</sql>
+ <!-- 字段 -->
+ <sql id="column-part">
+ id,
+ third_sys_id,
+ third_sys_name,
+ third_code,
+ third_name,
+ third_parent_id,
+ region_id,
+ level,
+ create_time,
+ update_time
+ </sql>
+ <!-- 更新实体字段 -->
+ <sql id="set-part">
+ <if test="entity.thirdSysId != null">third_sys_id = #{entity.thirdSysId},</if>
+ <if test="entity.thirdSysName != null">third_sys_name = #{entity.thirdSysName},</if>
+ <if test="entity.thirdCode != null">third_code = #{entity.thirdCode},</if>
+ <if test="entity.thirdName != null">third_name = #{entity.thirdName},</if>
+ <if test="entity.thirdParentId != null">third_parent_id = #{entity.thirdParentId},</if>
+ <if test="entity.regionId != null">region_id = #{entity.regionId},</if>
+ <if test="entity.level != null">level = #{entity.level},</if>
+ <if test="entity.createTime != null">create_time = #{entity.createTime},</if>
+ <if test="entity.updateTime != null">update_time = #{entity.updateTime}</if>
+ </sql>
+ <!-- 条件 -->
+ <sql id="where-part">
+ <if test="terms != null">
+ <where>
+ <if test="terms.id != null and terms.id !=''">
+ and id = #{terms.id}
+ </if>
+ <if test="terms.thirdSysId != null and terms.thirdSysId !=''">
+ and third_sys_id = #{terms.thirdSysId}
+ </if>
+ <if test="terms.thirdSysName != null and terms.thirdSysName !=''">
+ and third_sys_name = #{terms.thirdSysName}
+ </if>
+ <if test="terms.thirdCode != null and terms.thirdCode !=''">
+ and third_code = #{terms.thirdCode}
+ </if>
+ <if test="terms.thirdName != null and terms.thirdName !=''">
+ and third_name = #{terms.thirdName}
+ </if>
+ <if test="terms.thirdParentId != null and terms.thirdParentId !=''">
+ and third_parent_id = #{terms.thirdParentId}
+ </if>
+ <if test="terms.regionId != null and terms.regionId !=''">
+ and region_id = #{terms.regionId}
+ </if>
+ <if test="terms.level != null and terms.level !=''">
+ and level = #{terms.level}
+ </if>
+ <if test="terms.createTime != null and terms.createTime !=''">
+ and DATE_FORMAT(create_time,'%Y-%m-%d') = #{terms.createTime}
+ </if>
+ <if test="terms.createStart != null and terms.createStart !='' and terms.createEnd != null and terms.createEnd !=''">
+ and (DATE_FORMAT(create_time,'%Y-%m-%d') <![CDATA[ >= ]]> #{terms.createStart}
+ and DATE_FORMAT(create_time,'%Y-%m-%d') <![CDATA[ <= ]]> #{terms.createEnd})
+ </if>
+ <if test="terms.updateTime != null and terms.updateTime !=''">
+ and DATE_FORMAT(update_time,'%Y-%m-%d') = #{terms.updateTime}
+ </if>
+ <if test="terms.updateStart != null and terms.updateStart !='' and terms.updateEnd != null and terms.updateEnd !=''">
+ and (DATE_FORMAT(update_time,'%Y-%m-%d') <![CDATA[ >= ]]> #{terms.updateStart}
+ and DATE_FORMAT(update_time,'%Y-%m-%d') <![CDATA[ <= ]]> #{terms.updateEnd})
+ </if>
+ </where>
+ </if>
+ </sql>
+ <!-- 更新对象 -->
+ <update id="updateSyRegionGrid">
+ update
+ <include refid="table-name"/>
+ <set>
+ <include refid="set-part"/>
+ </set>
+ <where>
+ id = #{entity.id}
+ </where>
+ </update>
+ <!-- 条件更新对象 -->
+ <update id="updateSyRegionGridTerms">
+ update
+ <include refid="table-name"/>
+ <set>
+ <include refid="set-part"/>
+ </set>
+ <include refid="where-part"/>
+ </update>
+ <!-- 根据编号物理删除 -->
+ <delete id="deleteSyRegionGrid">
+ delete from
+ <include refid="table-name" />
+ where id = #{id}
+ </delete>
+ <!-- 根据条件查询 -->
+ <select id="listTerms" resultMap="dataResult">
+ select
+ <include refid="column-part"/>
+ from
+ <include refid="table-name" />
+ <include refid="where-part"/>
+ </select>
+ <!-- 根据条件统计 -->
+ <select id="countTerms" resultType="java.lang.Long">
+ select
+ COUNT(1)
+ from
+ <include refid="table-name" />
+ <include refid="where-part"/>
+ </select>
+ <!-- 根据条件分页查询 -->
+ <select id="pageTerms" resultMap="dataResult">
+ SELECT
+ <include refid="column-part"/>
+ FROM
+ <include refid="table-name" />
+ <include refid="where-part"/>
+ <if test="page.sort != null">
+ <foreach collection="page.sort" item="s" index="index" separator="," open="order by ">
+ isnull(${s.property}), ${s.property} ${s.direction}
+ </foreach>
+ </if>
+ <if test="page.sort == null">
+ order by isnull(create_time), create_time desc
+ </if>
+ limit #{page.offset}, #{page.size}
+ </select>
+
+</mapper>
\ No newline at end of file
diff --git a/dyh-service/dyh-cust/src/main/java/cn/huge/module/region/domain/bo/SyRegionGridBO.java b/dyh-service/dyh-cust/src/main/java/cn/huge/module/region/domain/bo/SyRegionGridBO.java
new file mode 100644
index 0000000..b7188d1
--- /dev/null
+++ b/dyh-service/dyh-cust/src/main/java/cn/huge/module/region/domain/bo/SyRegionGridBO.java
@@ -0,0 +1,17 @@
+package cn.huge.module.region.domain.bo;
+
+import cn.huge.module.region.domain.po.SyRegionGrid;
+
+/**
+ * @title: 网格化平台地域字典映射表业务扩展类
+ * @description: 网格化平台地域字典映射表业务扩展类
+ * @company: hugeinfo
+ * @author: liyj
+ * @time: 2024-09-25 18:03:50
+ * @version: 1.0.0
+ * @see cn.huge.module.region.domain.po.SyRegionGrid
+ */
+public class SyRegionGridBO extends SyRegionGrid {
+
+
+}
diff --git a/dyh-service/dyh-cust/src/main/java/cn/huge/module/region/domain/po/SyRegionGrid.java b/dyh-service/dyh-cust/src/main/java/cn/huge/module/region/domain/po/SyRegionGrid.java
new file mode 100644
index 0000000..01ef0ea
--- /dev/null
+++ b/dyh-service/dyh-cust/src/main/java/cn/huge/module/region/domain/po/SyRegionGrid.java
@@ -0,0 +1,83 @@
+package cn.huge.module.region.domain.po;
+
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableLogic;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.Data;
+
+import java.util.Date;
+
+/**
+ * @title: 网格化平台地域字典映射表数据库对应关系类
+ * @description: PO中的属性与数据表是一一对应关系，如需根据业务处理不同，请使用BO对象。
+ * @company:hugeinfo
+ * @author: liyj
+ * @time: 2024-09-25 18:03:50
+ * @version 1.0.0
+ */
+@TableName(value = "dyh_sy_region_grid")
+@Data
+public class SyRegionGrid {
+
+ /**
+ * 主键编号
+ */
+ @TableId(value = "id")
+ private Integer id;
+
+ /**
+ * 网格化平台编号
+ */
+ @TableField(value = "third_sys_id")
+ private String thirdSysId;
+
+ /**
+ * 网格化平台名称
+ */
+ @TableField(value = "third_sys_name")
+ private String thirdSysName;
+
+ /**
+ * 网格化地域编码
+ */
+ @TableField(value = "third_code")
+ private String thirdCode;
+
+ /**
+ * 网格化地域名称
+ */
+ @TableField(value = "third_name")
+ private String thirdName;
+
+ /**
+ * 网格化地域父级编码
+ */
+ @TableField(value = "third_parent_id")
+ private String thirdParentId;
+
+ /**
+ * 本平台地域编码
+ */
+ @TableField(value = "region_id")
+ private String regionId;
+
+ /**
+ * 层级
+ */
+ @TableField(value = "level")
+ private Integer level;
+
+ /**
+ * 创建时间
+ */
+ @TableField(value = "create_time")
+ private Date createTime;
+
+ /**
+ * 状态时间
+ */
+ @TableField(value = "update_time")
+ private Date updateTime;
+
+}
diff --git a/dyh-service/dyh-cust/src/main/java/cn/huge/module/region/service/SyRegionGridService.java b/dyh-service/dyh-cust/src/main/java/cn/huge/module/region/service/SyRegionGridService.java
new file mode 100644
index 0000000..7bd1fc5
--- /dev/null
+++ b/dyh-service/dyh-cust/src/main/java/cn/huge/module/region/service/SyRegionGridService.java
@@ -0,0 +1,113 @@
+package cn.huge.module.region.service;
+
+import cn.huge.base.common.exception.ServiceException;
+import cn.huge.base.common.utils.DateUtils;
+import cn.huge.base.common.utils.IdUtils;
+import cn.huge.module.client.api.impl.UtilsClientImpl;
+import cn.huge.module.region.dao.mapper.SyRegionGridMapper;
+import cn.huge.module.region.domain.po.SyRegionGrid;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.data.domain.Page;
+import org.springframework.data.domain.PageImpl;
+import org.springframework.data.domain.PageRequest;
+import org.springframework.transaction.annotation.Transactional;
+
+import javax.annotation.PostConstruct;
+import java.util.Date;
+import java.util.List;
+import java.util.Map;
+
+/**
+ * @title: 网格化平台地域字典映射表业务逻辑处理
+ * @Description 网格化平台地域字典映射表业务逻辑处理
+ * @company hugeinfo
+ * @author liyj
+ * @Time 2024-09-25 18:03:50
+ * @version 1.0.0
+ */
+@Slf4j
+@Service
+@Transactional(rollbackFor = Exception.class)
+public class SyRegionGridService extends ServiceImpl<SyRegionGridMapper, SyRegionGrid>{
+
+ @Autowired
+ private SyRegionGridMapper mapper;
+
+ @Autowired
+ private UtilsClientImpl utilsClient;
+
+ /**
+ * 更新对象
+ * @param entity 对象
+ */
+ public void updateSyRegionGrid(SyRegionGrid entity){
+ try{
+ mapper.updateSyRegionGrid(entity);
+ }catch (Exception e){
+ log.error("[SyRegionGridService.updateSyRegionGrid]调用失败，异常信息："+e, e);
+ throw new ServiceException("SyRegionGridService.updateSyRegionGrid", e);
+ }
+ }
+
+ /**
+ * 条件更新对象
+ * @param entity 对象
+ * @param terms 条件
+ */
+ public void updateSyRegionGridTerms(SyRegionGrid entity, Map<String, Object> terms){
+ try{
+ mapper.updateSyRegionGridTerms(entity, terms);
+ }catch (Exception e){
+ log.error("[SyRegionGridService.updateSyRegionGridTerms]调用失败，异常信息："+e, e);
+ throw new ServiceException("SyRegionGridService.updateSyRegionGridTerms", e);
+ }
+ }
+
+ /**
+ * 根据编号物理删除
+ * @param id 查询条件集合
+ */
+ public void deleteSyRegionGrid(String id){
+ try{
+ mapper.deleteSyRegionGrid(id);
+ }catch (Exception e){
+ log.error("[SyRegionGridService.deleteSyRegionGrid]调用失败，异常信息："+e, e);
+ throw new ServiceException("SyRegionGridService.deleteSyRegionGrid", e);
+ }
+ }
+
+ /**
+ * 按条件查询
+ * @param terms 条件
+ * @return List
+ */
+ public List<SyRegionGrid> listTerms(Map<String, Object> terms){
+ return mapper.listTerms(terms);
+ }
+
+ /**
+ * 按条件统计
+ * @param terms 条件
+ * @return long
+ */
+ public long countTerms(Map<String, Object> terms){
+ return mapper.countTerms(terms);
+ }
+
+ /**
+ * 按条件分页查询
+ * @param page 分页对象
+ * @param terms 条件
+ * @return Page
+ */
+ public Page<SyRegionGrid> pageQuery(PageRequest page, Map<String, Object> terms){
+ long total = mapper.countTerms(terms);
+ List<SyRegionGrid> content = mapper.pageTerms(page, terms);
+ return new PageImpl<SyRegionGrid>(content, page, total);
+ }
+
+}
--
Gitblit v1.8.0