From b992b368da14ccd6b5f8c45496eaff7f3003ca8a Mon Sep 17 00:00:00 2001
From: feiyu02 <risaku@163.com>
Date: 星期一, 19 一月 2026 17:31:45 +0800
Subject: [PATCH] 2026.1.19 1. 新增用户业务配置表和用户业务配置结果记录表

---
 src/main/kotlin/cn/flightfeather/supervision/domain/mapper/UserSettingMapper.kt       |    8 
 src/main/kotlin/cn/flightfeather/supervision/domain/entity/UserSettingRecord.java     |   55 ++++++
 src/main/resources/mapper/UserSettingRecordMapper.xml                                 |   17 +
 src/main/kotlin/cn/flightfeather/supervision/domain/mapper/UserSettingRecordMapper.kt |    8 
 src/main/kotlin/cn/flightfeather/supervision/domain/entity/UserSetting.java           |  367 ++++++++++++++++++++++++++++++++++++++++
 src/main/resources/mapper/UserSettingMapper.xml                                       |   38 ++++
 6 files changed, 493 insertions(+), 0 deletions(-)

diff --git a/src/main/kotlin/cn/flightfeather/supervision/domain/entity/UserSetting.java b/src/main/kotlin/cn/flightfeather/supervision/domain/entity/UserSetting.java
new file mode 100644
index 0000000..bfb6eab
--- /dev/null
+++ b/src/main/kotlin/cn/flightfeather/supervision/domain/entity/UserSetting.java
@@ -0,0 +1,367 @@
+package cn.flightfeather.supervision.domain.entity;
+
+import javax.persistence.*;
+
+@Table(name = "sm_t_setting")
+public class UserSetting {
+    @Id
+    private Integer id;
+
+    @Column(name = "User_Type_Id")
+    private Integer userTypeId;
+
+    @Column(name = "User_Type")
+    private String userType;
+
+    @Column(name = "User_SubType_Id")
+    private Integer userSubtypeId;
+
+    @Column(name = "User_SubType")
+    private String userSubtype;
+
+    @Column(name = "Province_Code")
+    private String provinceCode;
+
+    @Column(name = "Province_Name")
+    private String provinceName;
+
+    @Column(name = "City_Code")
+    private String cityCode;
+
+    @Column(name = "City_Name")
+    private String cityName;
+
+    @Column(name = "District_Code")
+    private String districtCode;
+
+    @Column(name = "District_Name")
+    private String districtName;
+
+    @Column(name = "Town_Code")
+    private String townCode;
+
+    @Column(name = "Town_Name")
+    private String townName;
+
+    @Column(name = "Area_Code")
+    private String areaCode;
+
+    @Column(name = "Area")
+    private String area;
+
+    @Column(name = "Management_Company_Id")
+    private String managementCompanyId;
+
+    @Column(name = "Management_Company")
+    private String managementCompany;
+
+    /**
+     * 鍦烘櫙绫诲瀷
+     */
+    @Column(name = "scene_type_id")
+    private Integer sceneTypeId;
+
+    /**
+     * 鍙板笎鎻愪氦鏈熼檺锛堟湀搴︼級
+     */
+    @Column(name = "ledger_deadline")
+    private Integer ledgerDeadline;
+
+    /**
+     * 鏄惁寮�鍚嚜宸℃煡鎵胯
+     */
+    @Column(name = "self_patrol_promise")
+    private Boolean selfPatrolPromise;
+
+    /**
+     * @return id
+     */
+    public Integer getId() {
+        return id;
+    }
+
+    /**
+     * @param id
+     */
+    public void setId(Integer id) {
+        this.id = id;
+    }
+
+    /**
+     * @return User_Type_Id
+     */
+    public Integer getUserTypeId() {
+        return userTypeId;
+    }
+
+    /**
+     * @param userTypeId
+     */
+    public void setUserTypeId(Integer userTypeId) {
+        this.userTypeId = userTypeId;
+    }
+
+    /**
+     * @return User_Type
+     */
+    public String getUserType() {
+        return userType;
+    }
+
+    /**
+     * @param userType
+     */
+    public void setUserType(String userType) {
+        this.userType = userType == null ? null : userType.trim();
+    }
+
+    /**
+     * @return User_SubType_Id
+     */
+    public Integer getUserSubtypeId() {
+        return userSubtypeId;
+    }
+
+    /**
+     * @param userSubtypeId
+     */
+    public void setUserSubtypeId(Integer userSubtypeId) {
+        this.userSubtypeId = userSubtypeId;
+    }
+
+    /**
+     * @return User_SubType
+     */
+    public String getUserSubtype() {
+        return userSubtype;
+    }
+
+    /**
+     * @param userSubtype
+     */
+    public void setUserSubtype(String userSubtype) {
+        this.userSubtype = userSubtype == null ? null : userSubtype.trim();
+    }
+
+    /**
+     * @return Province_Code
+     */
+    public String getProvinceCode() {
+        return provinceCode;
+    }
+
+    /**
+     * @param provinceCode
+     */
+    public void setProvinceCode(String provinceCode) {
+        this.provinceCode = provinceCode == null ? null : provinceCode.trim();
+    }
+
+    /**
+     * @return Province_Name
+     */
+    public String getProvinceName() {
+        return provinceName;
+    }
+
+    /**
+     * @param provinceName
+     */
+    public void setProvinceName(String provinceName) {
+        this.provinceName = provinceName == null ? null : provinceName.trim();
+    }
+
+    /**
+     * @return City_Code
+     */
+    public String getCityCode() {
+        return cityCode;
+    }
+
+    /**
+     * @param cityCode
+     */
+    public void setCityCode(String cityCode) {
+        this.cityCode = cityCode == null ? null : cityCode.trim();
+    }
+
+    /**
+     * @return City_Name
+     */
+    public String getCityName() {
+        return cityName;
+    }
+
+    /**
+     * @param cityName
+     */
+    public void setCityName(String cityName) {
+        this.cityName = cityName == null ? null : cityName.trim();
+    }
+
+    /**
+     * @return District_Code
+     */
+    public String getDistrictCode() {
+        return districtCode;
+    }
+
+    /**
+     * @param districtCode
+     */
+    public void setDistrictCode(String districtCode) {
+        this.districtCode = districtCode == null ? null : districtCode.trim();
+    }
+
+    /**
+     * @return District_Name
+     */
+    public String getDistrictName() {
+        return districtName;
+    }
+
+    /**
+     * @param districtName
+     */
+    public void setDistrictName(String districtName) {
+        this.districtName = districtName == null ? null : districtName.trim();
+    }
+
+    /**
+     * @return Town_Code
+     */
+    public String getTownCode() {
+        return townCode;
+    }
+
+    /**
+     * @param townCode
+     */
+    public void setTownCode(String townCode) {
+        this.townCode = townCode == null ? null : townCode.trim();
+    }
+
+    /**
+     * @return Town_Name
+     */
+    public String getTownName() {
+        return townName;
+    }
+
+    /**
+     * @param townName
+     */
+    public void setTownName(String townName) {
+        this.townName = townName == null ? null : townName.trim();
+    }
+
+    /**
+     * @return Area_Code
+     */
+    public String getAreaCode() {
+        return areaCode;
+    }
+
+    /**
+     * @param areaCode
+     */
+    public void setAreaCode(String areaCode) {
+        this.areaCode = areaCode == null ? null : areaCode.trim();
+    }
+
+    /**
+     * @return Area
+     */
+    public String getArea() {
+        return area;
+    }
+
+    /**
+     * @param area
+     */
+    public void setArea(String area) {
+        this.area = area == null ? null : area.trim();
+    }
+
+    /**
+     * @return Management_Company_Id
+     */
+    public String getManagementCompanyId() {
+        return managementCompanyId;
+    }
+
+    /**
+     * @param managementCompanyId
+     */
+    public void setManagementCompanyId(String managementCompanyId) {
+        this.managementCompanyId = managementCompanyId == null ? null : managementCompanyId.trim();
+    }
+
+    /**
+     * @return Management_Company
+     */
+    public String getManagementCompany() {
+        return managementCompany;
+    }
+
+    /**
+     * @param managementCompany
+     */
+    public void setManagementCompany(String managementCompany) {
+        this.managementCompany = managementCompany == null ? null : managementCompany.trim();
+    }
+
+    /**
+     * 鑾峰彇鍦烘櫙绫诲瀷
+     *
+     * @return scene_type_id - 鍦烘櫙绫诲瀷
+     */
+    public Integer getSceneTypeId() {
+        return sceneTypeId;
+    }
+
+    /**
+     * 璁剧疆鍦烘櫙绫诲瀷
+     *
+     * @param sceneTypeId 鍦烘櫙绫诲瀷
+     */
+    public void setSceneTypeId(Integer sceneTypeId) {
+        this.sceneTypeId = sceneTypeId;
+    }
+
+    /**
+     * 鑾峰彇鍙板笎鎻愪氦鏈熼檺锛堟湀搴︼級
+     *
+     * @return ledger_deadline - 鍙板笎鎻愪氦鏈熼檺锛堟湀搴︼級
+     */
+    public Integer getLedgerDeadline() {
+        return ledgerDeadline;
+    }
+
+    /**
+     * 璁剧疆鍙板笎鎻愪氦鏈熼檺锛堟湀搴︼級
+     *
+     * @param ledgerDeadline 鍙板笎鎻愪氦鏈熼檺锛堟湀搴︼級
+     */
+    public void setLedgerDeadline(Integer ledgerDeadline) {
+        this.ledgerDeadline = ledgerDeadline;
+    }
+
+    /**
+     * 鑾峰彇鏄惁寮�鍚嚜宸℃煡鎵胯
+     *
+     * @return self_patrol_promise - 鏄惁寮�鍚嚜宸℃煡鎵胯
+     */
+    public Boolean getSelfPatrolPromise() {
+        return selfPatrolPromise;
+    }
+
+    /**
+     * 璁剧疆鏄惁寮�鍚嚜宸℃煡鎵胯
+     *
+     * @param selfPatrolPromise 鏄惁寮�鍚嚜宸℃煡鎵胯
+     */
+    public void setSelfPatrolPromise(Boolean selfPatrolPromise) {
+        this.selfPatrolPromise = selfPatrolPromise;
+    }
+}
\ No newline at end of file
diff --git a/src/main/kotlin/cn/flightfeather/supervision/domain/entity/UserSettingRecord.java b/src/main/kotlin/cn/flightfeather/supervision/domain/entity/UserSettingRecord.java
new file mode 100644
index 0000000..41db457
--- /dev/null
+++ b/src/main/kotlin/cn/flightfeather/supervision/domain/entity/UserSettingRecord.java
@@ -0,0 +1,55 @@
+package cn.flightfeather.supervision.domain.entity;
+
+import javax.persistence.*;
+
+@Table(name = "sm_t_setting_record")
+public class UserSettingRecord {
+    /**
+     * 鐢ㄦ埛id
+     */
+    @Id
+    @Column(name = "user_id")
+    private String userId;
+
+    /**
+     * 鏄惁鎵胯浜嗚嚜宸℃煡鏈夋晥鏈熷欢闀夸负涓�涓嚜鐒跺勾鍐呴兘鏈夋晥
+     */
+    @Column(name = "self_patrol_promised")
+    private Boolean selfPatrolPromised;
+
+    /**
+     * 鑾峰彇鐢ㄦ埛id
+     *
+     * @return user_id - 鐢ㄦ埛id
+     */
+    public String getUserId() {
+        return userId;
+    }
+
+    /**
+     * 璁剧疆鐢ㄦ埛id
+     *
+     * @param userId 鐢ㄦ埛id
+     */
+    public void setUserId(String userId) {
+        this.userId = userId == null ? null : userId.trim();
+    }
+
+    /**
+     * 鑾峰彇鏄惁鎵胯浜嗚嚜宸℃煡鏈夋晥鏈熷欢闀夸负涓�涓嚜鐒跺勾鍐呴兘鏈夋晥
+     *
+     * @return self_patrol_promised - 鏄惁鎵胯浜嗚嚜宸℃煡鏈夋晥鏈熷欢闀夸负涓�涓嚜鐒跺勾鍐呴兘鏈夋晥
+     */
+    public Boolean getSelfPatrolPromised() {
+        return selfPatrolPromised;
+    }
+
+    /**
+     * 璁剧疆鏄惁鎵胯浜嗚嚜宸℃煡鏈夋晥鏈熷欢闀夸负涓�涓嚜鐒跺勾鍐呴兘鏈夋晥
+     *
+     * @param selfPatrolPromised 鏄惁鎵胯浜嗚嚜宸℃煡鏈夋晥鏈熷欢闀夸负涓�涓嚜鐒跺勾鍐呴兘鏈夋晥
+     */
+    public void setSelfPatrolPromised(Boolean selfPatrolPromised) {
+        this.selfPatrolPromised = selfPatrolPromised;
+    }
+}
\ No newline at end of file
diff --git a/src/main/kotlin/cn/flightfeather/supervision/domain/mapper/UserSettingMapper.kt b/src/main/kotlin/cn/flightfeather/supervision/domain/mapper/UserSettingMapper.kt
new file mode 100644
index 0000000..9474f2a
--- /dev/null
+++ b/src/main/kotlin/cn/flightfeather/supervision/domain/mapper/UserSettingMapper.kt
@@ -0,0 +1,8 @@
+package cn.flightfeather.supervision.domain.mapper
+
+import cn.flightfeather.supervision.domain.entity.UserSetting
+import cn.flightfeather.supervision.domain.util.MyMapper
+import org.apache.ibatis.annotations.Mapper
+
+@Mapper
+interface UserSettingMapper : MyMapper<UserSetting?>
\ No newline at end of file
diff --git a/src/main/kotlin/cn/flightfeather/supervision/domain/mapper/UserSettingRecordMapper.kt b/src/main/kotlin/cn/flightfeather/supervision/domain/mapper/UserSettingRecordMapper.kt
new file mode 100644
index 0000000..b5be563
--- /dev/null
+++ b/src/main/kotlin/cn/flightfeather/supervision/domain/mapper/UserSettingRecordMapper.kt
@@ -0,0 +1,8 @@
+package cn.flightfeather.supervision.domain.mapper
+
+import cn.flightfeather.supervision.domain.entity.UserSettingRecord
+import cn.flightfeather.supervision.domain.util.MyMapper
+import org.apache.ibatis.annotations.Mapper
+
+@Mapper
+interface UserSettingRecordMapper : MyMapper<UserSettingRecord?>
\ No newline at end of file
diff --git a/src/main/resources/mapper/UserSettingMapper.xml b/src/main/resources/mapper/UserSettingMapper.xml
new file mode 100644
index 0000000..12f6d80
--- /dev/null
+++ b/src/main/resources/mapper/UserSettingMapper.xml
@@ -0,0 +1,38 @@
+<?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="cn.flightfeather.supervision.domain.mapper.UserSettingMapper" >
+  <resultMap id="BaseResultMap" type="cn.flightfeather.supervision.domain.entity.UserSetting" >
+    <!--
+      WARNING - @mbg.generated
+    -->
+    <id column="id" property="id" jdbcType="INTEGER" />
+    <result column="User_Type_Id" property="userTypeId" jdbcType="INTEGER" />
+    <result column="User_Type" property="userType" jdbcType="VARCHAR" />
+    <result column="User_SubType_Id" property="userSubtypeId" jdbcType="INTEGER" />
+    <result column="User_SubType" property="userSubtype" jdbcType="VARCHAR" />
+    <result column="Province_Code" property="provinceCode" jdbcType="VARCHAR" />
+    <result column="Province_Name" property="provinceName" jdbcType="VARCHAR" />
+    <result column="City_Code" property="cityCode" jdbcType="VARCHAR" />
+    <result column="City_Name" property="cityName" jdbcType="VARCHAR" />
+    <result column="District_Code" property="districtCode" jdbcType="VARCHAR" />
+    <result column="District_Name" property="districtName" jdbcType="VARCHAR" />
+    <result column="Town_Code" property="townCode" jdbcType="VARCHAR" />
+    <result column="Town_Name" property="townName" jdbcType="VARCHAR" />
+    <result column="Area_Code" property="areaCode" jdbcType="VARCHAR" />
+    <result column="Area" property="area" jdbcType="VARCHAR" />
+    <result column="Management_Company_Id" property="managementCompanyId" jdbcType="VARCHAR" />
+    <result column="Management_Company" property="managementCompany" jdbcType="VARCHAR" />
+    <result column="scene_type_id" property="sceneTypeId" jdbcType="INTEGER" />
+    <result column="ledger_deadline" property="ledgerDeadline" jdbcType="INTEGER" />
+    <result column="self_patrol_promise" property="selfPatrolPromise" jdbcType="BIT" />
+  </resultMap>
+  <sql id="Base_Column_List" >
+    <!--
+      WARNING - @mbg.generated
+    -->
+    id, User_Type_Id, User_Type, User_SubType_Id, User_SubType, Province_Code, Province_Name, 
+    City_Code, City_Name, District_Code, District_Name, Town_Code, Town_Name, Area_Code, 
+    Area, Management_Company_Id, Management_Company, scene_type_id, ledger_deadline, 
+    self_patrol_promise
+  </sql>
+</mapper>
\ No newline at end of file
diff --git a/src/main/resources/mapper/UserSettingRecordMapper.xml b/src/main/resources/mapper/UserSettingRecordMapper.xml
new file mode 100644
index 0000000..b22812f
--- /dev/null
+++ b/src/main/resources/mapper/UserSettingRecordMapper.xml
@@ -0,0 +1,17 @@
+<?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="cn.flightfeather.supervision.domain.mapper.UserSettingRecordMapper" >
+  <resultMap id="BaseResultMap" type="cn.flightfeather.supervision.domain.entity.UserSettingRecord" >
+    <!--
+      WARNING - @mbg.generated
+    -->
+    <id column="user_id" property="userId" jdbcType="VARCHAR" />
+    <result column="self_patrol_promised" property="selfPatrolPromised" jdbcType="BIT" />
+  </resultMap>
+  <sql id="Base_Column_List" >
+    <!--
+      WARNING - @mbg.generated
+    -->
+    user_id, self_patrol_promised
+  </sql>
+</mapper>
\ No newline at end of file

--
Gitblit v1.9.3