优化代码

java110

2020-11-26 b9dd9329a3ac55098f3e41068b0d64301067e8a5

优化代码

 java110-bean/src/main/java/com/java110/dto/owner/OwnerAppUserDto.java

@@ -34,6 +34,7 @@
    private String communityId;
    private String appTypeCd;
    private String memberId;
    private String ownerId;
    private String userId;
    private String appType;
    private String[] userIds;
@@ -46,7 +47,6 @@
    private String areaName;
    private String parentAreaCode;
    private String parentAreaName;



    private Date createTime;
@@ -238,4 +238,12 @@
    public void setOldAppUserId(String oldAppUserId) {
        this.oldAppUserId = oldAppUserId;
    }

    public String getOwnerId() {
        return ownerId;
    }

    public void setOwnerId(String ownerId) {
        this.ownerId = ownerId;
    }
}

 java110-db/src/main/resources/mapper/user/OwnerAppUserServiceDaoImplMapper.xml

@@ -129,12 +129,16 @@
        statusCd,t.app_user_name,t.app_user_name appUserName,t.community_name,t.community_name
        communityName,t.state,t.app_user_id,t.app_user_id appUserId,t.community_id,t.community_id
        communityId,t.app_type_cd,t.app_type_cd appTypeCd,t.b_id,t.b_id bId,t.member_id,t.member_id memberId,
        td1.name stateName,t.user_id,t.user_id userId,t.app_type,t.app_type appType,t.create_time createTime
        from owner_app_user t,t_dict td1
        td1.name stateName,t.user_id,t.user_id userId,t.app_type,t.app_type appType,t.create_time createTime,
        bo.owner_id ownerId
        from owner_app_user t,t_dict td1,building_owner bo
        where 1 =1
        and t.state = td1.status_cd
        and td1.table_name = 'owner_app_user'
        and td1.table_columns = 'state'
        and t.member_id = bo.member_id
        and t.community_id = bo.community_id
        and bo.status_cd = '0'
        <if test="idCard !=null and idCard != ''">
            and t.id_card= #{idCard}
        </if>