| | |
|---|
| | | + " LEFT JOIN sys_user u ON d.user_id = u.user_id\n" |
|---|
| | | + " LEFT JOIN com_mng_struct_area sa ON d.house_community_id = sa.id \n" + "where 1=1 " |
|---|
| | | + "<if test='pageComOpsHouseDTO.communityId != null '>" |
|---|
| | | + "AND ( d.community_id = #{pageComOpsHouseDTO.communityId} or sa.community_id = #{pageComOpsHouseDTO.communityId} )\n" |
|---|
| | | + "AND ( d.community_id = ${pageComOpsHouseDTO.communityId} or sa.community_id = ${pageComOpsHouseDTO.communityId} )\n" |
|---|
| | | + " </if> " + |
|---|
| | | |
|---|
| | | "<if test='pageComOpsHouseDTO.userId != null '>" + "AND d.user_id=#{pageComOpsHouseDTO.userId} \n" + " </if> " |
|---|
| | |
|---|
| | | + "AND d.brn <![CDATA[ >= ]]> 4 \n" + " </if> " + |
|---|
| | | |
|---|
| | | "<if test='pageComOpsHouseDTO.houseCommunityId != null '>" |
|---|
| | | + "AND d.house_community_id = #{pageComOpsHouseDTO.houseCommunityId} \n" + " </if> " |
|---|
| | | + "AND d.house_community_id = ${pageComOpsHouseDTO.houseCommunityId} \n" + " </if> " |
|---|
| | | + "<if test='pageComOpsHouseDTO.status != null and pageComOpsHouseDTO.status < 4 '>" |
|---|
| | | + "AND d.status=#{pageComOpsHouseDTO.status} \n" + " </if> " |
|---|
| | | + "<if test='pageComOpsHouseDTO.status != null and pageComOpsHouseDTO.status ==4 '>" |
|---|
