| | |
| | | " END AS sex, " + |
| | | " t.phone, " + |
| | | " YEAR ( now( ) ) - YEAR ( substring( t.id_card, 7, 8 ) ) age, " + |
| | | " t1.area_name, " + |
| | | " t1.area_name as areaName, " + |
| | | " t.political_outlook politicalOutlook, " + |
| | | " CONCAT( " + |
| | | " IF " + |
| | |
| | | "<if test='pageInputUserDTO.phone != null and pageInputUserDTO.phone.trim() != ""'>" + |
| | | " and t.phone like concat(#{pageInputUserDTO.phone},'%') " + |
| | | " </if> " + |
| | | "<if test='pageInputUserDTO.areaId != null and pageInputUserDTO.areaId.trim() != ""'>" + |
| | | " and t.area_id = #{pageInputUserDTO.areaId} " + |
| | | "<if test='pageInputUserDTO.areaName != null and pageInputUserDTO.areaName.trim() != ""'>" + |
| | | "AND t1.`area_name` like concat(#{pageInputUserDTO.areaName},'%') " + |
| | | " </if> " + |
| | | " group by t.id_card "+ |
| | | "</script>") |
| | |
| | | " END AS sex, " + |
| | | " t.phone, " + |
| | | " YEAR ( now( ) ) - YEAR ( substring( t.id_card, 7, 8 ) ) age, " + |
| | | " t1.area_name, " + |
| | | " t1.area_name as areaName, " + |
| | | " t.political_outlook politicalOutlook, " + |
| | | " CONCAT( " + |
| | | " IF " + |
| | |
| | | " and t.phone like concat(#{pageInputUserDTO.phone},'%') " + |
| | | " </if> " + |
| | | "<if test='pageInputUserDTO.areaName != null and pageInputUserDTO.areaName.trim() != ""'>" + |
| | | "AND t.`area_name` like concat(#{pageInputUserDTO.areaName},'%') " + |
| | | "AND t1.`area_name` like concat(#{pageInputUserDTO.areaName},'%') " + |
| | | " </if> " + |
| | | "<if test='pageInputUserDTO.tags != null and pageInputUserDTO.tags.trim() != ""'>" + |
| | | " and t.tags like concat('%',#{pageInputUserDTO.tags},'%') " + |