| | |
| | | " LEFT JOIN sys_user t3 ON t.create_by = t3.user_id " + |
| | | " WHERE t.source =2 " + |
| | | "<if test='pageComMngCarDTO.name != null and pageComMngCarDTO.name.trim() != ""'>" + |
| | | " and t.user_name LIKE concat( #{pageComMngCarDTO.name}, '%' ) " + |
| | | " and t.user_name LIKE concat( '%',#{pageComMngCarDTO.name}, '%' ) " + |
| | | " </if> " + |
| | | "<if test='pageComMngCarDTO.communityId != null and pageComMngCarDTO.communityId != 0'>" + |
| | | " and t.community_id = #{pageComMngCarDTO.communityId} " + |
| | | " </if> " + |
| | | "<if test='pageComMngCarDTO.areaName != null and pageComMngCarDTO.areaName != 0'>" + |
| | | " and t2.area_name LIKE concat( #{pageComMngCarDTO.areaName}, '%' ) " + |
| | | "<if test='pageComMngCarDTO.areaName != null'>" + |
| | | " and t2.area_name LIKE concat( '%',#{pageComMngCarDTO.areaName}, '%' ) " + |
| | | " </if> " + |
| | | " order by t.create_at desc"+ |
| | | " order by t.create_at desc" + |
| | | "</script>") |
| | | IPage<ComMngCarVO> pageQueryComMngCar(Page page, @Param(value = "pageComMngCarDTO") PageComMngCarDTO pageComMngCarDTO); |
| | | } |