function tpl_function_qishi_resume_show($params, &$smarty) { global $db, $_CFG, $QS_cookiepath, $QS_cookiedomain; $arr = explode(',', $params['set']); foreach ($arr as $str) { $a = explode(':', $str); switch ($a[0]) { case "简历ID": $aset['id'] = $a[1]; break; case "列表名": $aset['listname'] = $a[1]; break; } } $aset = array_map("get_smarty_request", $aset); $aset['id'] = $aset['id'] ? intval($aset['id']) : 0; $aset['listname'] = $aset['listname'] ? $aset['listname'] : "list"; $wheresql = " WHERE id=" . $aset['id'] . ""; $val = $db->getone("select id,uid,display,display_name,fullname,sex,sex_cn,major_cn,birthdate,photo,photo_img,photo_display,tag_cn,refreshtime,height,marriage_cn,education_cn,experience_cn,householdaddress,residence,talent,wage_cn,nature_cn,district_cn,trade_cn,intention_jobs,current_cn,specialty,title,telephone,email,addtime,resume_from_pc from " . table('resume') . $wheresql . " LIMIT 1"); if (intval($_SESSION['utype']) == 1) { $company_profile = $db->getone("select companyname from " . table('company_profile') . " where uid=" . intval($_SESSION['uid'])); } if ($val) { setcookie('QS[view_resume_log][' . $val['id'] . ']', $val['id'], 0, $QS_cookiepath, $QS_cookiedomain); if (intval($_SESSION['uid']) > 0 && intval($_SESSION['utype']) == 1) { //检查企业是否被个人屏蔽过 $company_profile = $db->getone("select companyname from " . table('company_profile') . " where uid=" . intval($_SESSION['uid'])); $shield_company = $db->getall("select comkeyword from " . table('personal_shield_company') . " where pid=" . $val['id'] . " and uid=" . $val['uid']); foreach ($shield_company as $key => $value) { if (!empty($value['comkeyword']) && stristr($company_profile['companyname'], $value['comkeyword'])) { header("HTTP/1.1 404 Not Found"); $smarty->display("404.htm"); exit; } } //检查是否查看过 $check = check_view_log(intval($_SESSION['uid']), $val['id']); if (!$check) { add_view_log(intval($_SESSION['uid']), $val['id']); $sql = "select did from " . table("personal_jobs_apply") . " where resume_id={$val['id']} and company_uid=" . intval($_SESSION['uid']) . " "; if ($db->getone($sql)) { $db->query("update " . table("personal_jobs_apply") . " set personal_look=2 where resume_id={$val['id']} and company_uid=" . intval($_SESSION['uid']) . ""); } } else { $db->query("update " . table("personal_jobs_apply") . " set personal_look=2 where resume_id={$val['id']} and company_uid=" . intval($_SESSION['uid']) . ""); } // 简历处理率 $resume_applyed = $db->getone("select count(*) num from " . table("personal_jobs_apply") . " where company_uid=" . intval($_SESSION['uid']) . " and resume_id={$val['id']} "); if (!empty($resume_applyed)) { $apply_see = $db->getone("select count(*) num from " . table("personal_jobs_apply") . " where company_uid=" . intval($_SESSION['uid']) . " and personal_look=2 "); $apply_all = $db->getone("select count(*) num from " . table("personal_jobs_apply") . " where company_uid=" . intval($_SESSION['uid']) . " "); $company_info['resume_processing'] = $apply_see['num'] / $apply_all['num'] * 100; $db->updatetable(table("company_profile"), $company_info, array("uid" => $_SESSION['uid'])); } //查看是否已经下载过简历 $download = $db->getone("select did from " . table("company_down_resume") . " where resume_id={$val['id']} and company_uid=" . intval($_SESSION['uid']) . " "); if ($download) { if ($val['display_name'] == "2") { $val['fullname'] = "N" . str_pad($val['id'], 7, "0", STR_PAD_LEFT); $val['fullname_'] = $val['fullname']; } elseif ($val['display_name'] == "3") { if ($val['sex'] == 1) { $val['fullname'] = cut_str($val['fullname'], 1, 0, "先生"); } elseif ($val['sex'] == 2) { $val['fullname'] = cut_str($val['fullname'], 1, 0, "女士"); } } else { $val['fullname_'] = $val['fullname']; $val['fullname'] = $val['fullname']; } } //提示信息 $mes_apply = $db->getone("select jobs_name,apply_addtime from " . table('personal_jobs_apply') . " where `resume_id`=" . $val['id'] . " and `company_uid`=" . intval($_SESSION['uid']) . " limit 1 "); if ($mes_apply) { $val['message'] = "应聘职位:" . $mes_apply['jobs_name'] . " 投递时间:" . date('Y-m-d', $mes_apply['apply_addtime']); } else { $val['message'] = ""; } } else { if ($val['display_name'] == "2") { $val['fullname'] = "N" . str_pad($val['id'], 7, "0", STR_PAD_LEFT); $val['fullname_'] = $val['fullname']; } elseif ($val['display_name'] == "3") { if ($val['sex'] == 1) { $val['fullname'] = cut_str($val['fullname'], 1, 0, "先生"); } elseif ($val['sex'] == 2) { $val['fullname'] = cut_str($val['fullname'], 1, 0, "女士"); } } else { $val['fullname_'] = $val['fullname']; $val['fullname'] = $val['fullname']; } } $val['education_list'] = get_this_education($val['uid'], $val['id']); $val['work_list'] = get_this_work($val['uid'], $val['id']); $val['training_list'] = get_this_training($val['uid'], $val['id']); $val['language_list'] = get_this_language($val['uid'], $val['id']); $val['credent_list'] = get_this_credent($val['uid'], $val['id']); $val['img_list'] = get_this_img($val['uid'], $val['id']); $val['age'] = date("Y") - $val['birthdate']; if ($val['photo'] == "1") { $download = $db->getone("select did from " . table("company_down_resume") . " where resume_id={$val['id']} and company_uid=" . intval($_SESSION['uid']) . " "); if (empty($download)) { if ($val['photo_display'] == "1") { $val['photosrc'] = $_CFG['resume_photo_dir'] . $val['photo_img']; } else { $val['photosrc'] = $_CFG['resume_photo_dir_thumb'] . "no_photo_display.gif"; } } else { $val['photosrc'] = $_CFG['resume_photo_dir'] . $val['photo_img']; } } else { $val['photosrc'] = $_CFG['resume_photo_dir_thumb'] . "no_photo.gif"; } if ($val['tag_cn']) { $tag_cn = explode(',', $val['tag_cn']); $val['tag_cn'] = $tag_cn; } else { $val['tag_cn'] = array(); } $apply = $db->getone("select * from " . table('personal_jobs_apply') . " where `resume_id`=" . $val['id']); $val['jobs_name'] = $apply['jobs_name']; $val['apply_addtime'] = $apply['apply_addtime']; $val['jobs_url'] = url_rewrite('QS_jobsshow', array('id' => $apply['jobs_id'])); if ($val['jobs_name']) { $val['apply'] = 1; } else { $val['apply'] = 0; } /* 简历活跃度 更新时间 主动申请职位数 浏览职位数 */ $vitality = 0; $val['refreshtime_cn'] = daterange(time(), $val['refreshtime'], 'Y-m-d', "#FF3300"); $timestr = time() - $val['refreshtime']; $day = intval($timestr / 86400); if ($day < 3) { $vitality += 2; } else { $vitality += 1; } $time = time() - 15 * 86400; $val['apply_jobs'] = $db->get_total("select count(*) num from " . table("personal_jobs_apply") . " where resume_id={$val['id']} and apply_addtime>{$time} and is_apply=1 "); if ($val['apply_jobs'] > 0 && $val['apply_jobs'] < 10) { $vitality += 1; } elseif ($val['apply_jobs'] >= 10) { $vitality += 2; } $val['view_jobs'] = $db->get_total("select count(*) num from " . table("view_jobs") . " where uid={$val['uid']} and addtime>{$time} "); if ($val['view_jobs'] >= 10) { $vitality += 1; } $val['vitality'] = $vitality; /*企业关注度 start */ $attention = 0; $val['com_down'] = $db->get_total("select count(*) num from " . table("company_down_resume") . " where resume_id={$val['id']} and down_addtime>{$time} "); if ($val['com_down'] >= 0 && $val['com_down'] < 10) { $attention += 1; } elseif ($val['com_down'] >= 10) { $attention += 2; } $val['com_invite'] = $db->get_total("select count(*) num from " . table("company_interview") . " where resume_id={$val['id']} and interview_addtime>{$time} "); if ($val['com_invite'] > 0 && $val['com_invite'] < 10) { $attention += 1; } elseif ($val['com_invite'] >= 10) { $attention += 2; } $val['com_view'] = $db->get_total("select count(*) num from " . table("view_resume") . " where resumeid={$val['id']} and addtime>{$time} "); if ($val['com_view'] >= 10) { $attention += 1; } $val['attention'] = $attention; /*企业关注度 end */ //判断手机、微信、邮箱是否验证 $is_audit_phone = $db->getone("SELECT mobile_audit,email_audit,weixin_openid FROM " . table('members') . " WHERE uid={$val['uid']} LIMIT 1 "); $val['is_audit_mobile'] = $is_audit_phone['mobile_audit']; $val['is_audit_email'] = $is_audit_phone['email_audit']; $val['is_audit_weixin'] = $is_audit_phone['weixin_openid']; //个人自己预览 if ($_SESSION['utype'] == '2' && $_SESSION['uid'] == $val['uid']) { $val['isminesee'] = '1'; } } else { header("HTTP/1.1 404 Not Found"); $smarty->display("404.htm"); exit; } $smarty->assign($aset['listname'], $val); }
function resume_one($id) { global $db; $id = intval($id); if (intval($_SESSION['uid']) > 0 && intval($_SESSION['utype']) == 1) { $check = check_view_log(intval($_SESSION['uid']), $id); if (!$check) { add_view_log(intval($_SESSION['uid']), $id); } } $db->query("update " . table('resume') . " set click=click+1 WHERE id='{$id}' LIMIT 1"); $wheresql = " WHERE id='{$id}'"; $sql = "select * from " . table('resume') . $wheresql . " LIMIT 1"; $val = $db->getone($sql); if ($val['display_name'] == "2") { $val['fullname'] = "N" . str_pad($val['id'], 7, "0", STR_PAD_LEFT); $val['fullname_'] = $val['fullname']; } elseif ($val['display_name'] == "3") { if ($val['sex'] == 1) { $val['fullname'] = cut_str($val['fullname'], 1, 0, "先生"); } elseif ($val['sex'] == 2) { $val['fullname'] = cut_str($val['fullname'], 1, 0, "女士"); } $val['fullname_'] = $val['fullname']; } else { $val['fullname_'] = $val['fullname']; $val['fullname'] = $val['fullname']; } if ($val['talent'] == 1) { $val['talent_'] = "1"; $val['talent'] = "普通"; } elseif ($val['talent'] == 2) { $val['talent_'] = "2"; $val['talent'] = "高级"; } $val['fullname_3'] = cut_str($val['fullname'], 1, 0, "先生/女士"); $val['age'] = date("Y") - $val['birthdate']; $val['education_list'] = get_this_education_all($val['uid'], $val['id']); //统计教育经历数 $education_num = 0; foreach ($val['education_list'] as $key => $value) { $education_num++; } $val['education_num'] = $education_num; $val['work_list'] = get_this_work_all($val['uid'], $val['id']); //统计工作经历数 和 每份工作时间 $work_num = 0; foreach ($val['work_list'] as $key => $value) { $work_num++; if ($value['todate'] == 1) { $value['work_time'] = intval((time() - strtotime($value['startyear'] . "-" . $value['startmonth'] . "-" . "01")) / 2592000); } else { $value['work_time'] = intval((strtotime($value['endyear'] . "-" . $value['endmonth'] . "-" . "01") - strtotime($value['startyear'] . "-" . $value['startmonth'] . "-" . "01")) / 2592000); } $val['work_list'][$key] = $value; } $val['work_num'] = $work_num; $val['training_list'] = get_this_training_all($val['uid'], $val['id']); //统计培训经历数 $training_num = 0; foreach ($val['training_list'] as $key => $value) { $training_num++; } $val['training_num'] = $training_num; if ($val['tag_cn']) { $tag_cn = explode(',', $val['tag_cn']); $val['tag_cn'] = $tag_cn; foreach ($val['tag_cn'] as $key => $value) { $tag_one['cn'] = $value; $tag_one['key'] = $key + 1; $val['tag_cn_list'][] = $tag_one; } } else { $val['tag_cn'] = array(); } $two_week_time = strtotime("-2 week"); //两周内被浏览的次数 $val['click_num'] = $db->get_total("SELECT COUNT(*) AS num FROM " . table('view_resume') . " WHERE resumeid=" . $val['id'] . " and addtime > " . $two_week_time); //两周内被下载的次数 $val['down_num'] = $db->get_total("SELECT COUNT(*) AS num FROM " . table('company_down_resume') . " WHERE resume_id=" . $val['id'] . " and down_addtime > " . $two_week_time); //两周内投递的次数 $val['apply_num'] = $db->get_total("SELECT COUNT(*) AS num FROM " . table('personal_jobs_apply') . " WHERE resume_id=" . $val['id'] . " and apply_addtime > " . $two_week_time); //该简历会员信息 $sql = "select mobile_audit from " . table("members") . " where uid={$val['uid']} "; $members_info = $db->getone($sql); $val['mobile_audit'] = $members_info['mobile_audit']; //判断是否是自己预览 //个人自己预览 if ($_SESSION['utype'] == '2' && $_SESSION['uid'] == $val['uid']) { $val['isminesee'] = '1'; } return $val; }
function tpl_function_qishi_jobs_show($params, &$smarty) { global $db, $timestamp, $_CFG; $arr = explode(',', $params['set']); foreach ($arr as $str) { $a = explode(':', $str); switch ($a[0]) { case "职位ID": $aset['id'] = $a[1]; break; case "列表名": $aset['listname'] = $a[1]; break; case "描述长度": $aset['brieflylen'] = $a[1]; break; case "填补字符": $aset['dot'] = $a[1]; break; } } $aset = array_map("get_smarty_request", $aset); $aset['id'] = $aset['id'] ? intval($aset['id']) : 0; $aset['brieflylen'] = isset($aset['brieflylen']) ? intval($aset['brieflylen']) : 0; $aset['listname'] = $aset['listname'] ? $aset['listname'] : "list"; $smarty->assign("is_reward", get_jobs_is_reward($_SESSION["uid"], $aset['id'])); $wheresql = " WHERE id={$aset['id']} "; $sql = "select id,uid,audit,display,setmeal_deadline,add_mode,amount,company_id,district_cn,contents,refreshtime,tag_cn,category,subclass,sdistrict,jobs_name,companyname,wage_cn,nature_cn,category_cn,sex_cn,age,education_cn,experience_cn,deadline,graduate from " . table('jobs') . $wheresql . " LIMIT 1"; $val = $db->getone($sql); if (empty($val)) { $sql_tmp = "select id,uid,audit,display,setmeal_deadline,add_mode,amount,company_id,district_cn,contents,refreshtime,tag_cn,category,subclass,sdistrict,jobs_name,companyname,wage_cn,nature_cn,category_cn,sex_cn,age,education_cn,deadline,experience_cn from " . table('jobs_tmp') . $wheresql . " LIMIT 1"; $val = $db->getone($sql_tmp); } if (empty($val)) { header("HTTP/1.1 404 Not Found"); $smarty->display("404.htm"); exit; } if ($val['deadline'] < time()) { $val['jobs_gq'] = 1; } elseif ($val['audit'] != '1' || $val['display'] != '1' || $val['setmeal_deadline'] != '0' && $val['setmeal_deadline'] < time()) { $val['jobs_gq'] = 2; } setcookie('QS[view_jobs_log][' . $val['id'] . ']', $val['id'], 0, $QS_cookiepath, $QS_cookiedomain); if (intval($_SESSION['uid']) > 0 && intval($_SESSION['utype']) == 2) { //检查是否看过该职位 $check = check_view_log(intval($_SESSION['uid']), $val['id']); if (!$check) { add_view_log(intval($_SESSION['uid']), $val['id']); } //检查该职位是否对此会员发起面试邀请,并且此会员没看 $check_int = check_interview(intval($_SESSION['uid']), $val['id']); if ($check_int) { update_interview(intval($_SESSION['uid']), $val['id']); } //检查该职位是否被此会员收藏过 $check_fav = check_favorites(intval($_SESSION['uid']), $val['id']); if ($check_fav) { $val['check_fav'] = 1; } } if ($val['setmeal_deadline'] < time() && $val['setmeal_deadline'] != "0" && $val['add_mode'] == "2") { $val['deadline'] = $val['setmeal_deadline']; } $val['amount'] = $val['amount'] == "0" ? '若干' : $val['amount']; $val['jobs_url'] = url_rewrite('QS_jobsshow', array('id' => $val['id'])); $profile = GetJobsCompanyProfile($val['company_id']); $val['company'] = $profile; $val['contact'] = GetJobsContact($val['id']); $district_cn = $val['district_cn']; $d_arr = explode("/", $district_cn); $val['district_ch'] = $d_arr[0]; $val['sdistrict_ch'] = $d_arr[1]; $val['expire'] = sub_day($val['deadline'], time()); $val['countresume'] = $db->get_total("SELECT COUNT(*) AS num FROM " . table('personal_jobs_apply') . " WHERE jobs_id= '{$val['id']}'"); if ($aset['brieflylen'] > 0) { $val['briefly'] = cut_str(strip_tags($val['contents']), $aset['brieflylen'], 0, $aset['dot']); } else { $val['briefly'] = strip_tags($val['contents']); } $val['contents'] = htmlspecialchars_decode($val['contents'], ENT_QUOTES); $val['refreshtime_cn'] = daterange(time(), $val['refreshtime'], 'Y-m-d', "#FF3300"); $val['company_url'] = url_rewrite('QS_companyshow', array('id' => $val['company_id'])); if ($val['company']['logo']) { $val['company']['logo'] = $_CFG['site_dir'] . "data/logo/" . $val['company']['logo']; } else { $val['company']['logo'] = $_CFG['site_dir'] . "data/logo/no_logo.gif"; } if ($val['company']['website']) { if (strstr($val['company']['website'], "http://") === false) { $val['company']['website'] = "http://" . $val['company']['website']; } } if (intval($_SESSION['utype']) == 2) { $view_log = get_view_log(intval($_SESSION['uid'])); foreach ($view_log as $key => $value) { $jobs_info = $db->getone("select id,company_id,jobs_name,companyname from " . table('jobs') . " where id=" . $value['jobsid']); $val['view_log'][$key]['jobsid'] = $jobs_info['id']; $val['view_log'][$key]['jobs_name'] = $jobs_info['jobs_name']; $val['view_log'][$key]['jobs_url'] = url_rewrite('QS_jobsshow', array('id' => $jobs_info['id'])); $val['view_log'][$key]['companyname'] = $jobs_info['companyname']; } $interest_id = get_interest_jobs_id(intval($_SESSION['uid'])); } if ($val['tag_cn']) { $tag_cn = explode(',', $val['tag_cn']); $val['tag_cn'] = $tag_cn; } else { $val['tag_cn'] = array(); } /* 薪酬统计 如果职位有三级分类 则根据职位的 subclass 如果职位没有有三级分类 则根据职位的 category */ if ($val['subclass']) { $salary_data = $db->getall("select c.c_name from " . table('jobs_search_wage') . " as j left join " . table('category') . " as c on c.c_id=j.wage where j.subclass=" . $val['subclass'] . " and j.sdistrict=" . $val['sdistrict']); } else { $salary_data = $db->getall("select c.c_name from " . table('jobs_search_wage') . " as j left join " . table('category') . " as c on c.c_id=j.wage where j.category=" . $val['category'] . " and j.sdistrict=" . $val['sdistrict']); } if ($salary_data) { $total = 0; $total_salary = 0; foreach ($salary_data as $key => $value) { $total_salary += intval($value['c_name']) + 500; $total++; } $val['salary']['value'] = intval($total_salary / $total); $val['salary']['px'] = $val['salary']['value'] / 12000 * 446 . "px"; } /* 薪酬统计 */ $user = get_jobs_username($val['uid']); $hashstr = substr(md5($user['username']), 8, 16); $smarty->assign('hashstr', $hashstr); $smarty->assign("is_reward", get_jobs_is_reward($aset['id'])); $smarty->assign($aset['listname'], $val); }