public function saveRecruit()
{
$params = isset($_REQUEST['params']) ? $_REQUEST['params'] : '';
$recruit = paramsToArr($params);
$recruit['public_time'] = date('Y-m-d H:i:s', time());
if (empty($recruit['id'])) {
M('zhaopin')->add($recruit);
} else {
M('zhaopin')->where('id=' . $recruit['id'])->save($recruit);
}
}
public function exportPersonalInfo()
{
$params = addslashes($_REQUEST['params']);
$params = str_replace('&', ',', $params);
$params = str_replace('=', ':', $params);
$arr = paramsToArr($params);
$paramsArr = array();
if (!empty($arr['education'])) {
$paramsArr['pi.education'] = urldecode($arr['education']);
}
if (!empty($arr['depart_code'])) {
$paramsArr['depart_code'] = $arr['depart_code'];
}
if (!empty($arr['name'])) {
$paramsArr['name'] = array('like', "%" . $arr['name'] . "%");
}
if (!empty($arr['status'])) {
$paramsArr['status'] = $arr['status'];
if ($arr['status'] == 3) {
$paramsArr['status'] = array('in', array(3, 4));
}
} else {
$paramsArr['status'] = array('gt', 0);
}
$data = M('personal_information pi')->join('left join zhaopin on zhaopin.id = pi.zhaopin_id')->join('left join education on (pi.user_id = education.user_id and pi.education = education.education)')->join('left join job on pi.user_id = job.user_id')->field('pi.user_id,name,gender,nation,native_place,card_no,position,depart_code,current,max(job.jobtitle) as jobtitle,
pi.education,education.major,train,education.school,job.workon,link1,status,pi.remark,pi.submit_time')->group('pi.user_id')->order('null')->where($paramsArr)->select();
for ($i = 0; $i < count($data); $i++) {
switch ($data[$i]['status']) {
case '1':
$data[$i]['status'] = '未审核';
break;
case '3':
$data[$i]['status'] = '审核通过';
break;
case '4':
$data[$i]['status'] = '审核通过';
break;
case '2':
$data[$i]['status'] = '审核不通过';
break;
case '5':
$data[$i]['status'] = '重新填写待审核';
break;
}
$data[$i]['native_place'] = str_replace(array('直辖市', '市辖区', '|区|', '|县|', '|市|', '|', '请选择'), '', $data[$i]['native_place']);
$data[$i]['card_no'] = $data[$i]['card_no'];
$data[$i]['jobtitle'] = jobTitleToString($data[$i]['jobtitle']);
if ($data[$i]['submit_time']) {
$data[$i]['submit_time'] = date('Y-m-d H:i:s', $data[$i]['submit_time']);
}
}
$ths = '应聘者编号,姓名,性别,民族,籍贯,身份证号码,应聘科室,岗位代码,应/往届,职称,学历学位,专业,培养方式,' . '毕业院校,工作单位,联系方式,审核状态,审核备注,提交时间';
$titles = explode(',', $ths);
$filename = '应聘人员信息';
set_time_limit(0);
D('Common')->exportExcel($data, $titles, $filename);
}
