| | |
| | | "<if test='pageComOpsHouseDTO.houseCommunityId != null '>" + |
| | | "AND d.house_community_id=#{pageComOpsHouseDTO.houseCommunityId} \n" + |
| | | " </if> " + |
| | | "<if test='pageComOpsHouseDTO.status != null and pageComOpsHouseDTO.status !=4 '>" + |
| | | "<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 '>" + |
| | | "AND d.status in (0,2) \n" + |
| | | " </if> " + |
| | | "<if test='pageComOpsHouseDTO.status != null and pageComOpsHouseDTO.status ==5 '>" + |
| | | "AND d.status in (1,3) \n" + |
| | | " </if> " + |
| | | "<if test='pageComOpsHouseDTO.houseCommunityName != null and pageComOpsHouseDTO.houseCommunityName.trim() != ""'>" + |
| | | " and d.`house_community_name` LIKE concat( #{pageComOpsHouseDTO.houseCommunityName}, '%' ) \n" + |
| | | " </if> " + |