2026.1.19 1. 新增用户业务配置表和用户业务配置结果记录表

feiyu02

2026-01-19 b992b368da14ccd6b5f8c45496eaff7f3003ca8a

2026.1.19
1. 新增用户业务配置表和用户业务配置结果记录表

 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;
    }
}

 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;
    }
}

 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?>

 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?>

 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>

 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>