| | |
| | | + "<if test='pageComMngCarDTO.villageId != null and pageComMngCarDTO.villageId != ""'>" |
| | | + " and t.area_id = #{pageComMngCarDTO.villageId} " + " </if> " |
| | | + "<if test='pageComMngCarDTO.communityId != null and pageComMngCarDTO.communityId != 0'>" |
| | | + " and t.community_id = #{pageComMngCarDTO.communityId} " + " </if> " |
| | | + " and t.community_id = ${pageComMngCarDTO.communityId} " + " </if> " |
| | | + "<if test='pageComMngCarDTO.areaName != null and pageComMngCarDTO.areaName != ""'>" |
| | | + " and t2.area_name LIKE concat( '%',#{pageComMngCarDTO.areaName}, '%' ) " + " </if> " |
| | | + " order by t.create_at desc" + "</script>") |
| | |
| | | + "<if test='exportComMngCarExcelDTO.areaName != null and exportComMngCarExcelDTO.areaName.trim() != ""'>" |
| | | + " and t.area_name LIKE concat( #{exportComMngCarExcelDTO.areaName}, '%' ) " + " </if> " |
| | | + "<if test='exportComMngCarExcelDTO.communityId != null and exportComMngCarExcelDTO.communityId != ""'>" |
| | | + " and t.community_id = #{exportComMngCarExcelDTO.communityId} " + " </if> " |
| | | + " and t.community_id = ${exportComMngCarExcelDTO.communityId} " + " </if> " |
| | | + "<if test='exportComMngCarExcelDTO.villageId != null and exportComMngCarExcelDTO.villageId != ""'>" |
| | | + " and t.area_id = #{exportComMngCarExcelDTO.villageId} " + " </if> " |
| | | + "<if test='exportComMngCarExcelDTO.userName != null and exportComMngCarExcelDTO.userName.trim() != ""'>" |