@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; } }