@Override
public QueryUsersResult quickSearchUser(QueryCondition condition) {
QueryUsersResult result = null;
try {
List<UserEntity> userList = new ArrayList<UserEntity>();
System.out.println("query pageNumber is =" + condition.getPageNum());
int pageSize = condition.getPageSize();
if (pageSize < 1) {
pageSize = 1;
}
int curNum = condition.getPageNum();
if (curNum < 1) {
curNum = 1;
}
String sql = "where ";
if (condition.getKey() != null) {
sql +=
" (loginname like '%"
+ condition.getKey().trim()
+ "%' or name like '%"
+ condition.getKey().trim()
+ "%' or realname like '%"
+ condition.getKey().trim()
+ "%') and";
}
if (condition.getUsertype() != null) {
sql += " usertype =" + condition.getUsertype() + " and";
}
sql = sql.substring(0, sql.length() - 3);
String searchSql = "";
if (sql.length() > 8) {
searchSql = "from User " + sql;
} else {
searchSql = "from User";
}
List<User> users = userService.find(searchSql, curNum, pageSize);
try {
if (users != null && users.size() > 0) {
for (User user : users) {
UserDetail userdetail = userDetailService.findByUserId(user.getId());
UserEntity userInfo = ConvertHelper.toUserEntity(user, userdetail);
userList.add(userInfo);
}
}
} catch (Exception e1) {
e1.printStackTrace();
}
if (condition.getPageNum() == 1) {
List<UserDetail> userDetails =
userDetailService.find("from UserDetail where room='" + condition.getKey() + "'");
if (userDetails != null && userDetails.size() > 0) {
for (UserDetail userDetail : userDetails) {
if (!isContain(users, userDetail.getUserid())) {
User user = userService.findById(userDetail.getUserid());
UserEntity userInfo = ConvertHelper.toUserEntity(user, userDetail);
userList.add(userInfo);
}
}
}
}
System.out.println("get all users");
result = new QueryUsersResult(0, "", userList, userList.size());
return result;
} catch (Exception e) {
result = new QueryUsersResult(-1, "系统错误!", null, 0);
return result;
}
}
@Override
public QueryUsersResult getAllConditionUser(QueryCondition condition) {
QueryUsersResult result = null;
Map<Integer, String> remarkMap = new HashMap<Integer, String>();
if (condition.getRemarkUserId() != null) {
// 获取所有好友的remark信息
List<UserRemark> userRemarks =
userRemarkService.find(" from UserRemark where userId=" + condition.getRemarkUserId());
if (userRemarks != null && userRemarks.size() > 0) {
for (int i = 0; i < userRemarks.size(); i++) {
UserRemark userRemark = userRemarks.get(i);
remarkMap.put(userRemark.getFriendId(), userRemark.getRemark());
}
}
}
// 先查询航班号
String hsql = "from User order by createDate desc";
List<User> husers = userService.find(hsql, 1, 5);
String voyagId = null;
if (husers != null && husers.size() > 0) {
voyagId = husers.get(0).getVoyagId();
}
try {
List<UserEntity> userList = new ArrayList<UserEntity>();
String phone = condition.getPhone();
System.out.println("query pageNumber is =" + condition.getPageNum());
int pageSize = condition.getPageSize();
if (pageSize < 1) {
pageSize = 1;
}
int curNum = condition.getPageNum();
if (curNum < 1) {
curNum = 1;
}
String sql = "where ";
if (condition.getUserName() != null && !condition.getUserName().isEmpty()) {
sql += " loginname like '%" + condition.getUserName() + "%' and";
}
if (condition.getName() != null && !condition.getName().isEmpty()) {
sql += " name like '%" + condition.getName() + "%' and";
}
if (condition.getCountry() != null && !condition.getCountry().isEmpty()) {
sql += " country='" + condition.getCountry() + "' and";
}
if (condition.getPhone() != null && !condition.getPhone().isEmpty()) {
sql += " phone='" + condition.getPhone() + "' and";
}
if (condition.getArea() != null && !condition.getArea().isEmpty()) {
sql += " area ='" + condition.getArea() + "' and";
}
if (condition.getAgeStart() > 0) {
sql += " age >" + condition.getAgeStart() + " and";
}
if (condition.getAgeEnd() > 0) {
sql += " age <" + condition.getAgeEnd() + " and";
}
if (condition.getSex() > 0) {
sql += " sex =" + condition.getSex() + " and";
}
if (condition.getUsertype() != null) {
sql += " usertype =" + condition.getUsertype() + " and";
}
sql = sql.substring(0, sql.length() - 3);
String searchSql = "";
if (sql.length() > 8) {
if (StringUtils.isBlank(phone)) {
searchSql = "from User " + sql + " and cansearch=1";
} else {
searchSql = "from User " + sql + " and cansearchbyphone=1";
}
} else {
if (StringUtils.isBlank(phone)) {
searchSql = "from User where cansearch=1";
} else {
searchSql = "from User " + sql + " and cansearchbyphone=1";
}
}
if (condition.getUsertype() != null && condition.getUsertype().equals(1) && voyagId != null) {
searchSql += " and voyagId='" + voyagId + "'";
}
List<User> users = userService.find(searchSql, curNum, pageSize);
try {
if (users != null && users.size() > 0) {
for (User user : users) {
UserDetail userdetail = userDetailService.findByUserId(user.getId());
UserEntity userInfo = ConvertHelper.toUserEntity(user, userdetail);
String remark = remarkMap.get(user.getId());
if (remark != null) {
userInfo.setRemark(remark);
}
userList.add(userInfo);
}
}
} catch (Exception e1) {
e1.printStackTrace();
}
System.out.println("get all users");
result = new QueryUsersResult(0, "", userList, userList.size());
return result;
} catch (Exception e) {
// TODO: handle exception
result = new QueryUsersResult(-1, "系统错误!", null, 0);
return result;
}
}
