linwei
2023-12-29 43b63baf216cd1b257bf476da1ffa6104ddffb06
Merge remote-tracking branch 'origin/master'
3 files modified
32 ■■■■ changed files
src/main/java/org/springblade/modules/house/entity/HouseholdEntity.java 9 ●●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.xml 18 ●●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/house/vo/HouseholdVO.java 5 ●●●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/house/entity/HouseholdEntity.java
@@ -220,9 +220,14 @@
    @ApiModelProperty(value = "其他联系方式")
    private String otherContact;
    /**
     * 现居住地址
     * 居住地行政区划
     */
    @ApiModelProperty(value = "现居住地址")
    @ApiModelProperty(value = "居住地行政区划")
    private String homeAdcode;
    /**
     * 现居住地址(居住地址)
     */
    @ApiModelProperty(value = "现居住地址(居住地址)")
    private String currentAddress;
    /**
     * 残疾证
src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.xml
@@ -242,7 +242,19 @@
    <!--查询房屋集合信息-按id-->
    <select id="getHouseholdListById" resultMap="householdAndLabelMap" >
        select
            jh.*,
            jh.id,jh.house_code,jh.name,jh.phone_number,jh.associated_user_id,
            jh.role_type,jh.associated_user_name,jh.relationship,jh.is_primary_contact,
            jh.residential_status,jh.gender,jh.birthday,jh.id_card,jh.hkmt_pass,jh.passport,
            jh.ethnicity,jh.education,jh.resident_type,
            jh.hukou_registration,jh.resident_adcode,jh.native_place_adcode,
            jh.religious_belief,jh.health_status,jh.disease_name,
            jh.work_status,jh.employer,jh.occupation,jh.cmpy_reg_addr,
            jh.go_out_addr,jh.go_out_where,jh.go_out_time,jh.go_out_reason,
            jh.marital_status,jh.card_number,jh.other_contact,
            if(jda.id is not null,jda.address_name,jh.current_address) as current_address,
            jh.disability_cert,jh.party_ember,jh.create_user,jh.create_time,jh.update_user,jh.update_time,jh.remark,jh.is_deleted,
            jh.confirm_flag,jh.housing_rental_id,
            jhs.source,
            jhl.id as cid,
            jhl.house_code houseCodes,
            jhl.label_id,
@@ -254,7 +266,9 @@
            jhl.remark as cremark
        from jczz_household jh
        left join jczz_user_house_label jhl on jh.id = jhl.household_id
        where 1=1 and is_deleted = 0
        left join jczz_doorplate_address jda on jda.address_code = jh.house_code
        left join jczz_house jhs on jhs.house_code = jh.house_code
        where 1=1 and jh.is_deleted = 0
        and jh.id = #{household.id}
    </select>
src/main/java/org/springblade/modules/house/vo/HouseholdVO.java
@@ -83,4 +83,9 @@
    @ApiModelProperty("用户id")
    private Long userId;
    /**
     * 来源
     */
    private Integer source;
}