网格人员户籍地

xuhy

2025-12-30 c712b42e1910520a91f3071f3c5c04bee18394f4

网格人员户籍地

 ruoyi-system/src/main/java/com/ruoyi/system/model/TLargeKeyGridUser.java

@@ -56,6 +56,10 @@
    @TableField("house_number")
    private String houseNumber;

    @ApiModelProperty(value = "户籍地")
    @TableField("registered_residence")
    private String registeredResidence;

    @Length(max = 20,message = "姓名不能超过20个字符")
    @ApiModelProperty(value = "姓名")
    @TableField("user_name")

 ruoyi-system/src/main/resources/mapper/system/TLargeKeyGridUserMapper.xml

@@ -10,6 +10,7 @@
        <result column="building_info" property="buildingInfo" />
        <result column="unit_number" property="unitNumber" />
        <result column="house_number" property="houseNumber" />
        <result column="registered_residence" property="registeredResidence" />
        <result column="user_name" property="userName" />
        <result column="user_sex" property="userSex" />
        <result column="id_card" property="idCard" />
@@ -25,13 +26,14 @@

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, grid_info, community_name, building_info, unit_number, house_number, user_name, user_sex, id_card, contact_number, type_id, user_type, create_time, update_time, create_by, update_by, disabled
        id, grid_info, community_name, building_info, unit_number, house_number,registered_residence,
          user_name, user_sex, id_card, contact_number, type_id, user_type, create_time, update_time, create_by, update_by, disabled
    </sql>
    <select id="pageList" resultType="com.ruoyi.system.vo.TLargeKeyGridUserVO">
        select
            tlkgu.id, tlkgu.grid_info, tlkgu.community_name, tlkgu.building_info, tlkgu.unit_number, tlkgu.house_number,
            tlkgu.user_name, tlkgu.user_sex, tlkgu.id_card, tlkgu.contact_number, tlkgu.type_id, tlkgu.user_type,
            tlkgu.create_time, tlkgu.update_time, tlkgu.create_by, tlkgu.update_by, tlkgu.disabled,
            tlkgu.registered_residence,tlkgu.user_name, tlkgu.user_sex, tlkgu.id_card, tlkgu.contact_number, tlkgu.type_id,
            tlkgu.user_type,tlkgu.create_time, tlkgu.update_time, tlkgu.create_by, tlkgu.update_by, tlkgu.disabled,
            tlkpt.type_name
        from t_large_key_grid_user tlkgu
        left join t_large_key_personnel_type tlkpt on tlkgu.type_id = tlkpt.id