| | |
| | | " LEFT JOIN com_mng_struct_area t2 ON t2.id = t.area_id " + |
| | | " LEFT JOIN sys_user t3 ON t.create_by = t3.user_id " + |
| | | " WHERE 1=1" + |
| | | "<if test='pageComMngCarDTO.name != null and pageComMngCarDTO.name.trim() != ""'>" + |
| | | "<if test='pageComMngCarDTO.name != null and pageComMngCarDTO.name != ""'>" + |
| | | " and t.user_name LIKE concat( '%',#{pageComMngCarDTO.name}, '%' ) " + |
| | | " </if> " + |
| | | "<if test='pageComMngCarDTO.villageId != null'>" + |
| | | " and t.area_id = #{pageComMngCarDTO.villageId} " + |
| | | " </if> " + |
| | | "<if test='pageComMngCarDTO.communityId != null and pageComMngCarDTO.communityId != 0'>" + |
| | | " and t.community_id = #{pageComMngCarDTO.communityId} " + |
| | | " </if> " + |