$sql['password'] = md5(md5($sql['password']) . $sql['pwd_hash'] . $QS_pwdhash);
$sql['reg_time'] = time();
$sql['reg_ip'] = $online_ip;
$insert_id = inserttable(table('members'), $sql, true);
if ($insert_id) {
write_memberslog($insert_id, 1, 1000, $sql['username'], "管理员在后台新增会员");
$link[0]['text'] = "返回列表";
$link[0]['href'] = "?act=members_list";
adminmsg('添加成功！', 2, $link);
}
} elseif ($act == 'resume_show') {
check_permissions($_SESSION['admin_purview'], "resume_show");
$id = !empty($_REQUEST['id']) ? intval($_REQUEST['id']) : adminmsg("你没有选择简历！", 1);
$uid = intval($_REQUEST['uid']);
$smarty->assign('pageheader', "查看简历");
$resume = get_resume_basic($uid, $id);
if (empty($resume)) {
$link[0]['text'] = "返回简历列表";
$link[0]['href'] = '?act=list';
adminmsg('简历不存在或已经被删除！', 1, $link);
}
$smarty->assign('random', mt_rand());
$smarty->assign('time', time());
$smarty->assign('url', $_SERVER["HTTP_REFERER"]);
$smarty->assign('resume', $resume);
$smarty->assign('resume_education', get_resume_education($uid, $id));
$smarty->assign('resume_work', get_resume_work($uid, $id));
$smarty->assign('resume_training', get_resume_training($uid, $id));
$smarty->assign('resumeaudit', get_resumeaudit_one($id));
$smarty->display('personal/admin_personal_resume_show.htm');
} elseif ($act == 'del_auditreason') {
/**
* Created by PhpStorm.
* User: leven
* Date: 16/1/13
* Time: 下午1:47
*/
define('IN_QISHI', true);
$alias = "QS_leven_list";
require_once dirname(__FILE__) . '/../include/common.inc.php';
require_once "lib.php";
$id = $_GET["id"];
//$resume= \ORM::for_table(table('resume_temp'))->find_one($id)->as_array();
//获取简历基本信息
function get_resume_basic($id)
{
global $db;
$id = intval($id);
$uid = intval($uid);
$info = $db->getone("select * from " . table('resume_temp') . " where id='{$id}' LIMIT 1 ");
if (empty($info)) {
return false;
} else {
$info['age'] = date("Y") - $info['birthdate'];
$info['number'] = "N" . str_pad($info['id'], 7, "0", STR_PAD_LEFT);
$info['lastname'] = $info['fullname'];
return $info;
}
}
$resume = get_resume_basic($id);
$smarty->assign('resume', $resume);
$smarty->display('admin_personal_resume_show.htm');
<td width="140" align="right"><img height="100" src="<?php
echo $_CFG['site_template'];
?>
images/14.gif" /></td>
<td>
<strong style="font-size:14px ; color:#0066CC;margin-left:20px">举报成功，管理员会认真处理!</strong>
</td>
</tr>
</table>
<?php
} elseif ($act == "app_save") {
$setsqlarr['content'] = trim($_POST['content']) ? trim($_POST['content']) : exit("出错了");
$setsqlarr['resume_id'] = $_POST['resume_id'] ? intval($_POST['resume_id']) : exit("出错了");
$setsqlarr['title'] = trim($_POST['full_name']) ? trim($_POST['full_name']) : exit("出错了");
$setsqlarr['resume_addtime'] = intval($_POST['resume_addtime']);
$setsqlarr['uid'] = intval($_SESSION['uid']);
$setsqlarr['addtime'] = time();
if (strcasecmp(QISHI_DBCHARSET, "utf8") != 0) {
$setsqlarr['content'] = utf8_to_gbk($setsqlarr['content']);
$setsqlarr['title'] = utf8_to_gbk($setsqlarr['title']);
}
$resume = get_resume_basic($setsqlarr['resume_id']);
if (empty($resume)) {
exit("简历丢失");
} else {
$insert_id = inserttable(table('report_resume'), $setsqlarr, 1);
}
if ($insert_id) {
exit("ok");
}
}
if ($page < 1) {
$page = 1;
}
$start = ($page - 1) * $perpage;
$total_sql = "SELECT COUNT(*) AS num FROM " . table('personal_jobs_apply') . " as a {$wheresql}";
$count = $db->get_total($total_sql);
$joinsql .= " LEFT JOIN " . table('jobs') . " AS j ON a.jobs_id=j.id ";
$smarty->assign('apply', get_apply_jobs($start, $perpage, $joinsql, $wheresql));
$smarty->display("m/personal/m-apply.html");
} elseif ($act == 'apply_add') {
$jobsid = intval($_POST["jobs_id"]) ? intval($_POST["jobs_id"]) : exit("出错了");
$resumeid = intval($_POST["resume_id"]) ? intval($_POST["resume_id"]) : exit("出错了");
$_POST = array_map("utf8_to_gbk", $_POST);
$sql = "select * from " . table("personal_jobs_apply") . " where personal_uid=" . intval($_SESSION['uid']) . " and resume_id=" . intval($_POST["resume_id"]) . " and jobs_id=" . intval($_POST["jobs_id"]) . "";
$row = $db->getone($sql);
$resume_basic = get_resume_basic($_SESSION['uid'], $resumeid);
$resume_basic = array_map("addslashes", $resume_basic);
if (empty($resume_basic)) {
exit("简历丢失");
}
if ($_SESSION['utype'] != 2) {
exit("个人会员请登录后申请职位");
} elseif ($row) {
exit("您已经申请过此职位！");
} else {
if (check_jobs_apply($jobs['id'], $resumeid, $_SESSION['uid'])) {
continue;
}
if ($resume_basic['display_name'] == "2") {
$personal_fullname = "N" . str_pad($resume_basic['id'], 7, "0", STR_PAD_LEFT);
} elseif ($resume_basic['display_name'] == "3") {
$contents = str_replace('{#$order_amount#}', '兑换' . $order['amount'] . '积分', $contents);
}
$contents = str_replace('{#$order_payname#}', get_payment_info($order['payment_name'], ture), $contents);
if ($order['notes']) {
$contents = str_replace('{#$order_note#}', $order['notes'], $contents);
} else {
$contents = str_replace('{#$order_note#}', "无", $contents);
}
$contents = str_replace('{#$order_id#}', $order['id'], $contents);
exit($contents);
} elseif ($act == "sendtoemail") {
global $_CFG;
$uid = intval($_GET['uid']);
$resume_id = intval($_GET['resume_id']);
$email = trim($_GET['email']);
$resume_basic = get_resume_basic($resume_id);
if ($resume_basic['tag_cn']) {
$resume_tag = explode(',', $resume_basic['tag_cn']);
$tag_str = '<p>';
foreach ($resume_tag as $value) {
$tag_str .= '<span style="color: #656565;display:inline-block;background-color: #f2f4f7; border: 1px solid #d6d6d7;text-align: center;height:30px;line-height: 30px;margin-right:10px;padding:0 10px">' . $value . '</span>';
}
$tag_str .= '</p>';
}
$resume_work = get_resume_work($uid, $resume_id);
$show_contact = false;
if ($_CFG['showapplycontact'] == '1' || $_CFG['showresumecontact'] == '0') {
$show_contact = '<p>手机号码：' . $resume_basic["telephone"] . ' 电子邮箱：' . $resume_basic["email"] . '</p>';
} else {
$show_contact = '<p>联系方式：<a href=' . url_rewrite('QS_resumeshow', array('id' => $resume_id)) . '>点击查看</a></p>';
}
function get_outward_resumes_tpl($uid, $resume_id)
{
global $_CFG;
$uid = intval($uid);
$resume_id = intval($resume_id);
$resume_basic = get_resume_basic($uid, $resume_id);
if ($resume_basic['tag_cn']) {
$resume_tag = explode(',', $resume_basic['tag_cn']);
$tag_str = '<p>';
foreach ($resume_tag as $value) {
$tag_str .= '<span style="color: #656565;display:inline-block;background-color: #f2f4f7; border: 1px solid #d6d6d7;text-align: center;height:30px;line-height: 30px;margin-right:10px;padding:0 10px">' . $value . '</span>';
}
$tag_str .= '</p>';
}
$resume_work = get_resume_work($uid, $resume_id);
$show_contact = false;
if ($_CFG['showapplycontact'] == '1' || $_CFG['showresumecontact'] == '0') {
$show_contact = '<p>手机号码：' . $resume_basic["telephone"] . ' 电子邮箱：' . $resume_basic["email"] . '</p>';
} else {
$show_contact = '<p>联系方式：<a href=' . url_rewrite('QS_resumeshow', array('id' => $resume_id)) . '>点击查看</a></p>';
}
$htm = '<div style="width: 900px;margin: 0 auto;font-size: 14px;">
<div style="margin-bottom:10px">
<div style="float: left;"><a href="' . $_CFG['site_domain'] . $_CFG['site_dir'] . '"><img src="' . $_CFG['site_domain'] . $_CFG['upfiles_dir'] . $_CFG['web_logo'] . '" alt="' . $_CFG['site_name'] . '" border="0" align="absmiddle" width=180 height=50 /></div>
<div style="float: right;padding-top:10px;">' . $templates . '更新时间：' . date("Y-m-d", $resume_basic["refreshtime"]) . '</div>
<div style="clear:both"></div>
</div>
<div style="padding-bottom: 10px;">
<span style="font-size: 18px;font-weight: 700;">' . $resume_basic["fullname"] . '</span><span>（' . $resume_basic["sex_cn"] . '，' . $resume_basic["age"] . '）</span>
<p>学历：' . $resume_basic["education_cn"] . ' | 专业：' . $resume_basic["major_cn"] . ' | 工作经验：' . $resume_basic["experience_cn"] . '年 | 现居住地：' . $resume_basic["residence"] . '</p>
' . $show_contact . $tag_str . '
</div>
<div style="padding-bottom: 10px;">
<p style="font-size: 16px;font-weight: 700;">求职意向</p>
<p>期望职位：' . $resume_basic["intention_jobs"] . '</p>
<p>期望薪资：' . $resume_basic["wage_cn"] . '</p>
<p>期望地区：' . $resume_basic["district_cn"] . '</p>
</div>
<div style="padding-bottom: 10px;">
<p style="font-size: 16px;font-weight: 700;">工作经验</p>';
if (!empty($resume_work)) {
foreach ($resume_work as $value) {
$htm .= '<div>
<p style="font-size: 14px;font-weight: 700;">' . $value["companyname"] . '</p>
<p>' . $value["startyear"] . '年' . $value["startmonth"] . '月-' . $value["endyear"] . '年' . $value["endmonth"] . '月 ' . $value["jobs"] . '</p>
<div style="float: left;width: 100px;">工作内容：</div>
<div style="float: right;width: 800px;">' . $value["achievements"] . '</div>
<div style="clear:both"></div>
</div>';
}
} else {
$htm .= '<div>
没有填写工作经历
</div>';
}
$htm .= '</div>';
if ($resume_basic["specialty"]) {
$htm .= '<div style="padding-bottom: 10px;">
<p style="font-size: 16px;font-weight: 700;">自我描述</p>
<p>' . $resume_basic["specialty"] . '</p>
</div>';
}
$htm .= '<div style="text-align: center;margin-top:20px">
该简历来自<a href="' . $_CFG["site_domain"] . $_CFG["site_dir"] . '">' . $_CFG["site_name"] . '</a>
</div>
</div>';
return $htm;
}
$contents = str_replace('{#$send_mobile_key#}', $_SESSION['send_mobile_key'], $contents);
$contents = str_replace('{#$site_template#}', $_CFG['site_template'], $contents);
exit($contents);
} elseif ($act == "edit_mobile") {
$tpl = '../../templates/' . $_CFG['template_dir'] . "plus/ajax_authenticate_edit_mobile_box.htm";
$contents = file_get_contents($tpl);
$_SESSION['send_mobile_key'] = mt_rand(100000, 999999);
$contents = str_replace('{#$send_mobile_key#}', $_SESSION['send_mobile_key'], $contents);
$contents = str_replace('{#$site_name#}', $_CFG['site_name'], $contents);
$contents = str_replace('{#$site_template#}', $_CFG['site_template'], $contents);
$contents = str_replace('{#$notice#}', '接收HR来电', $contents);
exit($contents);
} elseif ($act == "tpl") {
$pid = intval($_GET['pid']);
$uid = intval($_SESSION['uid']);
$resume_basic = get_resume_basic($uid, $pid);
$tpl = '../../templates/' . $_CFG['template_dir'] . "member_personal/ajax_tpl.htm";
$resumetpl = get_resumetpl();
$resume_url = url_rewrite("QS_resumeshow", array("id" => $pid), false);
if ($resume_basic['tpl'] == "") {
$resume_basic['tpl'] = $_CFG['tpl_personal'];
}
$html = "";
if (!empty($resumetpl)) {
foreach ($resumetpl as $key => $value) {
$html_l .= '<label><input type="radio" id="tpl_pid" name="resume_tpl" value="' . $value["tpl_dir"] . '" class="radio set_tpl" ' . ($resume_basic['tpl'] == $value['tpl_dir'] ? 'checked' : '') . '>' . $value["tpl_name"] . ($resume_basic['tpl'] == $value['tpl_dir'] ? '<span>[当前]</span>' : '') . '</label>';
$html .= '<div class="resume_box tpl_img' . $value["tpl_dir"] . '" ' . ($resume_basic['tpl'] == $value['tpl_dir'] ? 'style="display:block"' : 'style="display:none"') . '>
<div class="img"><img src="' . $_CFG["site_dir"] . 'templates/tpl_resume/' . $value["tpl_dir"] . '/thumbnail.jpg" alt="" /></div>
<p style="margin-top:10px;"><a target="_blank" href="' . $resume_url . '&style=' . $value["tpl_dir"] . '">[预览]</a></p>
</div>';
}
function check_resume($uid, $pid)
{
global $db, $timestamp, $_CFG;
$uid = intval($uid);
$pid = intval($pid);
$percent = 0;
$resume_basic = get_resume_basic($uid, $pid);
$resume_education = get_resume_education($uid, $pid);
$resume_work = get_resume_work($uid, $pid);
$resume_training = get_resume_training($uid, $pid);
$resume_tag = $resume_basic['tag'];
$resume_specialty = $resume_basic['specialty'];
$resume_photo = $resume_basic['photo_img'];
$resume_language = get_resume_language($uid, $pid);
$resume_credent = get_resume_credent($uid, $pid);
$resume_img = get_resume_img($uid, $pid);
if (!empty($resume_basic)) {
$percent = $percent + 35;
}
if (!empty($resume_education)) {
$percent = $percent + 15;
}
if (!empty($resume_work)) {
$percent = $percent + 15;
}
if (!empty($resume_training)) {
$percent = $percent + 5;
}
if (!empty($resume_tag)) {
$percent = $percent + 5;
}
if (!empty($resume_specialty)) {
$percent = $percent + 5;
}
if (!empty($resume_photo)) {
$percent = $percent + 5;
}
if (!empty($resume_language)) {
$percent = $percent + 5;
}
//语言
if (!empty($resume_credent)) {
$percent = $percent + 5;
}
//证书
if (!empty($resume_img)) {
$percent = $percent + 5;
}
//附件
if ($resume_basic['photo_img'] && $resume_basic['photo_audit'] == "1" && $resume_basic['photo_display'] == "1") {
$setsqlarr['photo'] = 1;
} else {
$setsqlarr['photo'] = 0;
}
$setsqlarr['complete_percent'] = $percent;
require_once QISHI_ROOT_PATH . 'include/splitword.class.php';
$sp = new SPWord();
$setsqlarr['key'] = addslashes($resume_basic['intention_jobs']) . addslashes($resume_basic['recentjobs']) . addslashes($resume_basic['specialty']);
$setsqlarr['key'] = addslashes($resume_basic['fullname']) . $sp->extracttag($setsqlarr['key']);
$setsqlarr['key'] = str_replace(",", " ", addslashes($resume_basic['intention_jobs'])) . " {$setsqlarr['key']} " . addslashes($resume_basic['education_cn']);
$setsqlarr['key'] = $sp->pad($setsqlarr['key']);
if (!empty($resume_education)) {
foreach ($resume_education as $li) {
$setsqlarr['key'] = addslashes($li['school']) . " {$setsqlarr['key']} " . addslashes($li['speciality']);
}
}
if (!empty($resume_work)) {
foreach ($resume_work as $li) {
$setsqlarr['key'] = addslashes($li['companyname']) . " {$setsqlarr['key']} " . addslashes($li['speciality']);
}
}
if (!empty($resume_training)) {
foreach ($resume_training as $li) {
$setsqlarr['key'] = addslashes($li['agency']) . " {$setsqlarr['key']} " . addslashes($li['speciality']);
}
}
$setsqlarr['refreshtime'] = $timestamp;
if ($setsqlarr['complete_percent'] < 60) {
$setsqlarr['level'] = 1;
} elseif ($setsqlarr['complete_percent'] >= 60 && $setsqlarr['complete_percent'] < 80) {
$setsqlarr['level'] = 2;
} elseif ($setsqlarr['complete_percent'] >= 80) {
$setsqlarr['level'] = 3;
}
$db->updatetable(table('resume'), $setsqlarr, "uid='{$uid}' AND id='{$pid}'");
// distribution_resume($pid,$uid);
$j = get_resume_basic($uid, $pid);
$j = array_map("addslashes", $j);
$searchtab['sex'] = $j['sex'];
$searchtab['nature'] = $j['nature'];
$searchtab['marriage'] = $j['marriage'];
$searchtab['experience'] = $j['experience'];
$searchtab['district'] = $j['district'];
$searchtab['sdistrict'] = $j['sdistrict'];
$searchtab['wage'] = $j['wage'];
$searchtab['education'] = $j['education'];
$searchtab['current'] = $j['current'];
$searchtab['major'] = $j['major'];
$searchtab['photo'] = $j['photo'];
$searchtab['refreshtime'] = $j['refreshtime'];
$searchtab['talent'] = $j['talent'];
$searchtab['audit'] = $j['audit'];
$db->updatetable(table('resume_search_rtime'), $searchtab, "uid='{$uid}' AND id='{$pid}'");
$searchtab['key'] = $j['key'];
$searchtab['likekey'] = $j['intention_jobs'] . ',' . $j['trade_cn'] . ',' . $j['specialty'] . ',' . $j['fullname'];
$db->updatetable(table('resume_search_key'), $searchtab, "uid='{$uid}' AND id='{$pid}'");
unset($searchtab);
}
}
}
} elseif ($act == "resume_train_del") {
$smarty->cache = false;
$id = intval($_GET['train_id']);
$uid = intval($_SESSION["uid"]);
$sql = "delete from " . table("resume_training") . " where id={$id} and uid={$uid} ";
if ($db->query($sql)) {
exit("ok");
} else {
exit("err");
}
} elseif ($act == "resume_evaluation") {
$smarty->cache = false;
$id = intval($_GET['pid']);
$resume_basic = get_resume_basic(intval($_SESSION['uid']), $id);
$smarty->assign('resume_basic', $resume_basic);
$smarty->display('wap/personal/wap-evaluation.html');
} elseif ($act == "resume_evaluation_save") {
$_POST = array_map("utf8_to_gbk", $_POST);
$smarty->cache = false;
$id = intval($_POST['pid']);
$uid = intval($_SESSION["uid"]);
$specialty = $_POST['specialty'] ? $_POST['specialty'] : exit("请填写自我评价");
$sql = "update " . table("resume") . " set specialty='{$specialty}' where id={$id} and uid={$uid} ";
if ($db->query($sql)) {
exit("ok");
} else {
exit("err");
}
} elseif ($act == "resume_refresh") {
