/**
* 查询用户数据
*
* @param user
* @param page
* @return
*/
public List<User> listUsers(User user, PageInfo page) {
StringBuilder sql = new StringBuilder();
sql.append("SELECT T1.id,nickname,phone,industry, ")
.append("T2.name as schoolName,major,grade,T3.name AS gradeName ")
.append("FROM USER_INFO T1 ")
.append("LEFT JOIN SYS_SCHOOL T2 ON T2.ID=T1.schoolId ")
.append("LEFT JOIN SYS_DICT T3 ON T3.CODE=T1.grade AND T3.groupName=? ")
.append("WHERE 1=1 ");
ParamInfo paramInfo = new ParamInfo();
paramInfo.setTypeAndData(Types.VARCHAR, GloabConstant.GROUP_GRADE);
if (!Utils.isEmpty(user.getNickname())) {
sql.append(" AND T1.nickname like ? ");
paramInfo.setTypeAndData(Types.VARCHAR, "%" + user.getNickname() + "%");
}
if (!Utils.isEmpty(user.getType())) {
sql.append(" AND T1.type = ? ");
paramInfo.setTypeAndData(Types.CHAR, user.getType());
}
// if(!Utils.isEmpty(user.getStatus()))
// {
// sql.append(" AND status = ? ");
// paramInfo.setTypeAndData(Types.CHAR, user.getStatus());
// }
return userDao.getRecords(sql.toString(), paramInfo, page, User.class);
}
/**
* 更新大拿
*
* @param user
* @return
*/
@Transactional
public void updateGreater(User user, Greater greater) {
updateUser(user);
StringBuilder sql = new StringBuilder();
sql.append("update USER_GREATER set ");
ParamInfo paramInfo = new ParamInfo();
if (!Utils.isEmpty(greater.getCompany())) {
sql.append("company=?,");
paramInfo.setTypeAndData(Types.VARCHAR, greater.getCompany());
}
if (!Utils.isEmpty(greater.getPost())) {
sql.append("post=?,");
paramInfo.setTypeAndData(Types.VARCHAR, greater.getPost());
}
if (!Utils.isEmpty(greater.getTags())) {
sql.append("tags=?,");
paramInfo.setTypeAndData(Types.VARCHAR, greater.getTags());
}
if (!Utils.isEmpty(greater.getExperience())) {
sql.append("experience=?,");
paramInfo.setTypeAndData(Types.VARCHAR, greater.getExperience());
}
if (!Utils.isEmpty(greater.getSpecialty())) {
sql.append("specialty=?,");
paramInfo.setTypeAndData(Types.CHAR, greater.getSpecialty());
}
if (!Utils.isEmpty(greater.getJob())) {
sql.append("job=?,");
paramInfo.setTypeAndData(Types.VARCHAR, greater.getJob());
}
if (!Utils.isEmpty(greater.getAnswerTimes())) {
sql.append("answerTimes=?,");
paramInfo.setTypeAndData(Types.BIGINT, greater.getAnswerTimes());
}
if (!Utils.isEmpty(greater.getIsshow())) {
sql.append("isshow=?,");
paramInfo.setTypeAndData(Types.CHAR, greater.getIsshow());
}
if (!Utils.isEmpty(greater.getOrderNo())) {
sql.append("orderNo=?,");
paramInfo.setTypeAndData(Types.INTEGER, greater.getOrderNo());
}
if (sql.toString().endsWith(",")) {
sql.replace(sql.length() - 1, sql.length(), "");
sql.append(" where id=?");
paramInfo.setTypeAndData(Types.BIGINT, greater.getId());
userDao.updateRecord(sql.toString(), paramInfo);
}
}
/**
* 更新用户
*
* @param user
* @return
*/
public void updateUser(User user) {
StringBuilder sql = new StringBuilder();
sql.append("update USER_INFO set ");
ParamInfo paramInfo = new ParamInfo();
if (!Utils.isEmpty(user.getName())) {
sql.append("name=?,");
paramInfo.setTypeAndData(Types.VARCHAR, user.getName());
}
if (!Utils.isEmpty(user.getPhone())) {
sql.append("phone=?,");
paramInfo.setTypeAndData(Types.VARCHAR, user.getPhone());
}
if (!Utils.isEmpty(user.getNickname())) {
sql.append("nickname=?,");
paramInfo.setTypeAndData(Types.VARCHAR, user.getNickname());
}
if (!Utils.isEmpty(user.getSchoolId())) {
sql.append("schoolId=?,");
paramInfo.setTypeAndData(Types.BIGINT, user.getSchoolId());
}
if (!Utils.isEmpty(user.getMajor())) {
sql.append("major=?,");
paramInfo.setTypeAndData(Types.VARCHAR, user.getMajor());
}
if (!Utils.isEmpty(user.getGrade())) {
sql.append("grade=?,");
paramInfo.setTypeAndData(Types.CHAR, user.getGrade());
}
if (!Utils.isEmpty(user.getUrl())) {
sql.append("url=?,");
paramInfo.setTypeAndData(Types.VARCHAR, user.getUrl());
}
if (!Utils.isEmpty(user.getBackground_url())) {
sql.append("background_url=?,");
paramInfo.setTypeAndData(Types.VARCHAR, user.getBackground_url());
}
if (!Utils.isEmpty(user.getIndustry())) {
sql.append("industry=?,");
paramInfo.setTypeAndData(Types.VARCHAR, user.getIndustry());
}
if (sql.toString().endsWith(",")) {
sql.replace(sql.length() - 1, sql.length(), "");
sql.append(" where id=?");
paramInfo.setTypeAndData(Types.BIGINT, user.getId());
userDao.updateRecord(sql.toString(), paramInfo);
}
}
/**
* 查询用户数据的数量
*
* @param user
* @return
*/
public long getUserCount(User user) {
StringBuilder sql = new StringBuilder();
sql.append(" select count(1) from USER_INFO WHERE 1=1 ");
ParamInfo paramInfo = new ParamInfo();
if (!Utils.isEmpty(user.getName())) {
sql.append(" AND name like ? ");
paramInfo.setTypeAndData(Types.VARCHAR, "%" + user.getName() + "%");
}
if (!Utils.isEmpty(user.getType())) {
sql.append(" AND type = ? ");
paramInfo.setTypeAndData(Types.CHAR, user.getType());
}
if (!Utils.isEmpty(user.getStatus())) {
sql.append(" AND status = ? ");
paramInfo.setTypeAndData(Types.CHAR, user.getStatus());
}
return userDao.getCount(sql.toString(), paramInfo);
}
/**
* 判断用户是否存在
*
* @param user
* @return
*/
public boolean isExistUser(User user) {
StringBuilder sql = new StringBuilder();
sql.append(" select 1 from USER_INFO WHERE phone=? ");
ParamInfo paramInfo = new ParamInfo();
paramInfo.setTypeAndData(Types.VARCHAR, user.getPhone());
// paramInfo.setTypeAndData(Types.CHAR, user.getType());
if (!Utils.isEmpty(user.getId())) {
sql.append("and id <> ?");
paramInfo.setTypeAndData(Types.BIGINT, user.getId());
}
List<User> l = userDao.getRecords(sql.toString(), paramInfo, User.class);
if (l != null && l.size() > 0) return true;
return false;
}
/**
* 获取大拿数量
*
* @param user
* @return
*/
public long getGreaterCount(User user) {
StringBuilder sql = new StringBuilder();
sql.append("SELECT count(1) ")
.append("FROM USER_GREATER T1 ")
.append("INNER JOIN USER_INFO T2 ON T2.ID=T1.ID ")
.append("WHERE 1=1 ");
ParamInfo paramInfo = new ParamInfo();
if (user != null) {
if (!Utils.isEmpty(user.getNickname())) {
sql.append(" AND T2.nickname like ? ");
paramInfo.setTypeAndData(Types.VARCHAR, "%" + user.getNickname() + "%");
}
}
return greaterDao.getCount(sql.toString(), paramInfo);
}
/**
* 查询大拿列表
*
* @param page
* @return
*/
public List<Greater> listGreaters(User user, PageInfo page) {
StringBuilder sql = new StringBuilder();
sql.append(
"SELECT T1.id,T2.phone,T1.tags,T2.nickname,T1.company,T1.post,T2.url,T1.answerTimes ")
.append("FROM USER_GREATER T1 ")
.append("INNER JOIN USER_INFO T2 ON T2.ID=T1.ID ")
.append("WHERE 1=1 ");
ParamInfo paramInfo = new ParamInfo();
if (user != null) {
if (!Utils.isEmpty(user.getNickname())) {
sql.append(" AND T2.nickname like ? ");
paramInfo.setTypeAndData(Types.VARCHAR, "%" + user.getNickname() + "%");
}
} else {
sql.append("AND isshow=? ");
paramInfo.setTypeAndData(Types.CHAR, GloabConstant.YESNO_YES);
}
sql.append("ORDER BY orderNo ASC ");
return greaterDao.getRecords(sql.toString(), paramInfo, page, Greater.class);
}