| | |
| | | " SELECT " + |
| | | " t.area_name AS areaName, " + |
| | | " t.user_name AS userName, " + |
| | | " t.card_no AS cardNo, " + |
| | | " t.brand, " + |
| | | " t.plate_num AS plateNum, " + |
| | | " t.color, " + |
| | |
| | | "<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 != 0'>" + |
| | | "<if test='exportComMngCarExcelDTO.communityId != null and exportComMngCarExcelDTO.communityId != ""'>" + |
| | | " and t.community_id = #{exportComMngCarExcelDTO.communityId} " + |
| | | " </if> " + |
| | | "<if test='exportComMngCarExcelDTO.villageId != null and exportComMngCarExcelDTO.villageId != 0'>" + |
| | | " and t.village_id = #{exportComMngCarExcelDTO.villageId} " + |
| | | "<if test='exportComMngCarExcelDTO.villageId != null and exportComMngCarExcelDTO.villageId != ""'>" + |
| | | " and t.area_id = #{exportComMngCarExcelDTO.villageId} " + |
| | | " </if> " + |
| | | "<if test='exportComMngCarExcelDTO.userName != null and exportComMngCarExcelDTO.userName.trim() != ""'>" + |
| | | " and t.user_name LIKE concat( #{exportComMngCarExcelDTO.userName}, '%' ) " + |