| | |
| | | Map<String,Object> values = new HashMap<>(); |
| | | values.put("isDel", BaseEntity.NO); |
| | | StringBuilder sql = new StringBuilder(); |
| | | sql.append("SELECT u.id,u.name,u.CIQ,u.tel,u.apiId,u.imgUrl,u.gender,DATE_FORMAT(u.createTime,'%Y-%m-%d %H:%i:%S') AS createTime" + |
| | | sql.append("SELECT u.id,u.name,u.CIQ,u.tel,u.apiId,u.imgUrl,u.gender,DATE_FORMAT(u.createTime,'%Y-%m-%d %H:%i:%S') AS createTim" + |
| | | ",(SELECT un.unionId FROM user_union_his un WHERE un.isDel = #{m.isDel} AND un.userId = u.id LIMIT 1) AS unionId" + |
| | | " FROM user u WHERE u.isDel = #{m.isDel}"); |
| | | if (StringUtils.noNull(userList.getTel())){ |
| | | values.put("tel","%"+userList.getTel()+"%"); |