public void fillBuyHistoryPerInfo(ComResumeBuyHistory comResumeBuyHistory) { if (comResumeBuyHistory != null && StringUtils.isBlank(comResumeBuyHistory.getSchoolName())) { Integer perId = comResumeBuyHistory.getPerUserId(); Integer id = comResumeBuyHistory.getId(); try { Map<String, Object> perMap = getJdbcTemplate().queryForMap("SELECT * FROM per_user WHERE id=?", perId); String birthday = ObjectUtils.toString(perMap.get("birthday")); Integer age = 16; if (StringUtils.isNotBlank(birthday)) { // 计算年龄的公司修改为精确到年与搜索引擎匹配 DateTime bDate = new DateTime(birthday); bDate = bDate.monthOfYear().setCopy(1).dayOfMonth().setCopy(1); DateTime nDate = DateTime.now(); nDate = nDate.monthOfYear().setCopy(1).dayOfMonth().setCopy(1); age = Years.yearsBetween(bDate, nDate).getYears(); age = (age < 16 || age > 65) ? 16 : age; } Integer gender = NumberUtils.toInt(ObjectUtils.toString(perMap.get("gender")), 0); Integer jobyearType = NumberUtils.toInt(ObjectUtils.toString(perMap.get("jobyearType")), 0); String schoolName = ""; String speciality = ""; String genderStr = OptionMap.getValueByType(OptionMap.OptionType.OPT_GENDER, gender, null); PerUser perUser = perUserEao.get(perId); if (perUser != null) { PerResumeBo vo; try { vo = perResumeEao.getResumeVo(perUser.getResId()); } catch (Exception ex) { vo = null; } if (vo != null) { int degree = 0; if (vo.getEducationInfoVoList() != null) { for (PerResumeBo.EducationInfoVo eduVo : vo.getEducationInfoVoList()) { if (eduVo != null && eduVo.getDegree() != null && eduVo.getDegree() > degree) { degree = eduVo.getDegree(); schoolName = eduVo.getSchoolName(); speciality = eduVo.getSpeciality(); } } } } } String degreeStr = OptionMap.getValueByType(OptionMap.OptionType.OPT_PER_DEGREE, gender, null); ; comResumeBuyHistory.setAge(age); comResumeBuyHistory.setGender(genderStr); comResumeBuyHistory.setDegree(degreeStr); comResumeBuyHistory.setSchoolName(schoolName); comResumeBuyHistory.setSpeciality(speciality); comResumeBuyHistory.setJobyear(jobyearType); getJdbcTemplate() .update( "UPDATE com_resume_buy_history SET " + " age = ?," + " gender = ?," + " degree = ?," + " school_name = ? " + " speciality = ? " + " jobyear = ? " + " WHERE " + " id=? ", age, genderStr, degreeStr, schoolName, speciality, jobyearType, id); } catch (Exception e) { // 不处理 } } }
private Map<String, String> updateResumeMixInfo(Integer perId, String updateTable) { PerUser perUser = perUserEao.get(perId); if (perUser != null) { PerResumeBo vo; try { vo = perResumeEao.getResumeVo(perUser.getResId()); } catch (Exception ex) { vo = null; } if (vo != null) { int degree = 0; String schoolName = ""; String speciality = ""; if (vo.getEducationInfoVoList() != null) { for (PerResumeBo.EducationInfoVo eduVo : vo.getEducationInfoVoList()) { if (eduVo != null && eduVo.getDegree() != null && eduVo.getDegree() > degree) { degree = eduVo.getDegree(); schoolName = eduVo.getSchoolName(); speciality = eduVo.getSpeciality(); } } } ComReceiveAssistBo craVo = new ComReceiveAssistBo(); if (vo.getWorkInfoVoList() != null && CollectionUtils.size(vo.getWorkInfoVoList()) > 0) { PerResumeBo.WorkInfoVo workVo = vo.getWorkInfoVoList().get(0); craVo.setLastPosName(workVo.getJobName()); // craVo.setLastJobLocation(workVo.get); //个人简历无此数据 craVo.setComName(workVo.getComName()); craVo.setStart(workVo.getBegin()); craVo.setEnd(workVo.getEnd()); } craVo.setJobyearType(perUser.getJobyearType()); craVo.setMobile(perUser.getMobile()); if (vo.getIntentInfoVo() != null) { craVo.setSkill(vo.getIntentInfoVo().getProfessionSkill()); } // craVo.setFileName(); // craVo.setFilePath(); // 计算年龄的公式修改为精确到年与搜索引擎匹配 DateTime bDate = new DateTime(perUser.getBirthday()); bDate = bDate.monthOfYear().setCopy(1).dayOfMonth().setCopy(1); DateTime nDate = DateTime.now(); nDate = nDate.monthOfYear().setCopy(1).dayOfMonth().setCopy(2); Integer age = Years.yearsBetween(bDate, nDate).getYears(); if (perUser.getResId() != null && perUser.getResId() > 0 && StringUtils.isNotBlank(perUser.getUserName())) { getJdbcTemplateAction() .update( "update " + updateTable + " set " + "resume_id = ? , " + "user_name=? , " + "gender = ? , " + // "job_location = ? , " + // "location = ? , " + "age = ? , " + "degree = ? , " + "mix_info = ? , " + "school_name = ? , " + "speciality = ?, " + "jobyear_type = ? " + "where per_user_id = ?", perUser.getResId(), perUser.getUserName(), perUser.getGender(), // vo.getIntentInfoVo().getJobLocation(), // "", (age < 16 || age > 65) ? 16 : age, degree, (new Gson()).toJson(craVo), schoolName, speciality, perUser.getJobyearType(), perUser.getId()); } Map<String, String> map = Maps.newHashMap(); map.put("resumeId", String.valueOf(perUser.getResId())); map.put("userName", perUser.getUserName()); map.put("gender", String.valueOf(perUser.getGender())); map.put("age", String.valueOf((age < 16 || age > 65) ? 16 : age)); map.put("degree", String.valueOf(degree)); map.put("mixInfo", (new Gson()).toJson(craVo)); map.put("schoolName", schoolName); map.put("speciality", speciality); map.put("schoolName", schoolName); map.put("jobyearType", String.valueOf(perUser.getJobyearType())); return map; } } return null; }
public void fillIrcReservePerInfo(IrcReserve ircReserve) { if (ircReserve != null && StringUtils.isBlank(ircReserve.getUserName())) { Integer perId = ircReserve.getUserId(); Integer resId = ircReserve.getResId(); try { Map<String, Object> perMap = getJdbcTemplate().queryForMap("SELECT * FROM per_user WHERE id=?", perId); String birthday = ObjectUtils.toString(perMap.get("birthday")); Integer age = 16; if (StringUtils.isNotBlank(birthday)) { age = Years.yearsBetween(new DateTime(birthday), DateTime.now()).getYears(); age = (age < 16 || age > 65) ? 16 : age; } String userName = ObjectUtils.toString(perMap.get("userName")); Integer gender = NumberUtils.toInt(ObjectUtils.toString(perMap.get("gender")), 0); Integer jobyearType = NumberUtils.toInt(ObjectUtils.toString(perMap.get("jobyearType")), 0); String schoolName = ""; int degree = 0; PerUser perUser = perUserEao.get(perId); if (perUser != null) { PerResumeBo vo; try { vo = perResumeEao.getResumeVo(perUser.getResId()); } catch (Exception ex) { vo = null; } if (vo != null) { if (vo.getEducationInfoVoList() != null) { for (PerResumeBo.EducationInfoVo eduVo : vo.getEducationInfoVoList()) { if (eduVo != null && eduVo.getDegree() != null && eduVo.getDegree() > degree) { degree = eduVo.getDegree(); schoolName = eduVo.getSchoolName(); } } } } } ircReserve.setUserName(userName); ircReserve.setGender(gender); ircReserve.setAge(age); ircReserve.setDegree(degree); ircReserve.setSchoolName(schoolName); ircReserve.setJobyearType(jobyearType); getJdbcTemplateIrc() .update( "UPDATE irc_reserve SET " + " user_name = ?," + " age = ?," + " gender=?," + " jobyear_type = ? " + " WHERE " + " res_id=? ", userName, age, gender, jobyearType, resId); } catch (Exception e) { // 不处理 } } }