| | |
|---|
| | | |
|---|
| | | @Select("<script> " + "SELECT d.*,\n" + "u.name userName,u.type as userType\n" + "FROM\n" + "com_ops_house d\n" |
|---|
| | | + " LEFT JOIN sys_user u ON d.user_id = u.user_id\n" |
|---|
| | | + " LEFT JOIN com_act ca ON d.community_id = ca.community_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" |
|---|
| | | + " </if> " |
|---|
| | | + "<if test='pageComOpsHouseDTO.areaCode != null '>" |
|---|
| | | + "AND ca.area_code = #{pageComOpsHouseDTO.areaCode}" |
|---|
| | | + " </if> " + |
|---|
| | | |
|---|
| | | "<if test='pageComOpsHouseDTO.userId != null '>" + "AND d.user_id=#{pageComOpsHouseDTO.userId} \n" + " </if> " |
|---|
| | | + "<if test='pageComOpsHouseDTO.orient != null '>" + "AND d.orient=#{pageComOpsHouseDTO.orient} \n" + " </if> " |
|---|
| | | + "<if test='pageComOpsHouseDTO.houseType != null '>" + "AND d.house_type=#{pageComOpsHouseDTO.houseType} \n" |
|---|
