function import_resume_temp($id)
{
global $db;
$response = array();
$response["msg"] = "导入成功";
$response["error"] = 0;
$rs = \ORM::for_table(table("resume_temp"))->where("id", $id)->find_one();
if ($rs) {
$rs = $rs->as_array();
$exist_tel = \ORM::for_table(table("resume"))->where("telephone", $rs["telephone"])->find_one();
if ($exist_tel) {
$response["msg"] = "已经存在相同手机号的用户，导入失败！";
$response["error"] = 1;
Ggven::log($response);
return $response;
}
} else {
$response["msg"] = "简历不存在！";
$response["error"] = 1;
Ggven::log($response);
return $response;
}
$upload_uid = $rs["upload_uid"];
$username = uniqid() . time();
$email = trim($rs["email"]);
$mobile = trim($rs["telephone"]);
//注册会员
$userid = import_user_register_upload($username, '123456', 2, $email, $mobile, false);
if ($userid > 0) {
//个人信息表
$member_info['uid'] = $userid;
$member_info['realname'] = $rs["fullname"];
$member_info['sex_cn'] = $rs["sex_cn"];
$member_info['birthday'] = $rs["birthdate"];
switch ($member_info['sex_cn']) {
case "男":
$member_info['sex'] = 1;
break;
case "女":
$member_info['sex'] = 2;
break;
default:
$member_info['sex'] = 1;
$member_info['sex_cn'] = "男";
break;
}
$member_info['residence'] = $rs["residence"];
$education_cn = get_reg($rs["education_cn"]);
if ($education_cn) {
$member_info['education_cn'] = $education_cn;
$member_info['education'] = getId($education_cn, "QS_education")["c_id"];
} else {
$member_info['education_cn'] = "大专";
$member_info['education'] = 69;
}
$major_cn = get_reg($rs["major_cn"]);
if ($major_cn) {
$member_info['major_cn'] = $major_cn;
$member_info['major'] = getmajor_Id($major_cn);
} else {
$member_info['major_cn'] = "";
$member_info['major'] = 0;
}
$experience_cn = get_reg($rs["experience_cn"]);
if ($experience_cn) {
$member_info['experience_cn'] = $experience_cn;
$member_info['experience'] = getId($experience_cn, "QS_experience")["c_id"];
} else {
$member_info['experience_cn'] = "无经验";
$member_info['experience'] = 74;
}
$member_info['email'] = $email;
$member_info['phone'] = $mobile;
$member_info['height'] = 0;
$member_info['householdaddress'] = $rs["householdaddress"];
$member_info['marriage_cn'] = $rs["marriage_cn"];
switch ($member_info['marriage_cn']) {
case "未婚":
$member_info['marriage'] = 1;
break;
case "已婚":
$member_info['marriage'] = 2;
break;
default:
$member_info['marriage'] = 1;
$member_info['marriage_cn'] = "未婚";
break;
}
if (!$db->inserttable(table('members_info'), $member_info, true)) {
continue;
}
//简历表
$resume['uid'] = $userid;
$resume['title'] = $rs["title"];
$resume['fullname'] = $rs["fullname"];
$resume['birthdate'] = $rs['birthdate'];
$resume['residence'] = $member_info['residence'];
$resume['height'] = $member_info['height'];
$resume['sex'] = $member_info['sex'];
$resume['sex_cn'] = $member_info['sex_cn'];
$resume['marriage'] = $member_info['marriage'];
$resume['marriage_cn'] = $member_info['marriage_cn'];
$resume['experience'] = $member_info['experience'];
$resume['experience_cn'] = $member_info['experience_cn'];
$resume['major_cn'] = $member_info['major_cn'];
$resume['major'] = $member_info['major'];
$resume['education'] = $member_info['education'];
$resume['education_cn'] = $member_info['education_cn'];
$resume['householdaddress'] = $member_info['householdaddress'];
$resume['email'] = $member_info['email'];
$resume['telephone'] = $member_info['phone'];
$resume['nature_cn'] = $rs["nature_cn"];
switch ($resume['nature_cn']) {
case "全职":
$resume['nature'] = 62;
break;
case "兼职":
$resume['nature'] = 63;
break;
case "实习":
$resume['nature'] = 64;
break;
default:
$resume['nature'] = 62;
$resume['nature_cn'] = "全职";
break;
}
$resume["trade_cn"] = "其他行业";
$resume["trade"] = 45;
$trade = addslashes($rs["trade_cn"]);
$trade = get_trade($trade);
$trade_array = explode(',', $trade);
foreach ($trade_array as $key => $value) {
$everyone = resume_trade1($value);
$resume['trade'] .= empty($resume['trade']) ? $everyone['id'] : "," . $everyone['id'];
$resume['trade_cn'] .= empty($resume['trade_cn']) ? $everyone['cn'] : "," . $everyone['cn'];
}
$intention_jobs = $rs["intention_jobs"];
$resume['intention_jobs'] = $intention_jobs;
$resume['district_cn'] = $rs["district_cn"];
$wage_cn = get_reg($rs["wage_cn"]);
if ($wage_cn) {
$resume['wage_cn'] = $wage_cn;
$resume['wage'] = getId($wage_cn, "QS_wage")["c_id"];
} else {
$resume['wage_cn'] = "面议";
$resume['wage'] = 294;
}
$resume['addtime'] = time();
$resume['refreshtime'] = time();
$resume['specialty'] = addslashes($rs["specialty"]);
$resume['complete_percent'] = addslashes($rs["complete_percent"]);
$resume['display_name'] = 2;
$resume['entrust'] = 0;
$resume['resume_from_pc'] = 1;
$resume['photo'] = 0;
$resume['email_notify'] = 1;
$resume['click'] = 1;
$resume['photo'] = 0;
// dump($resume);
$pid = $db->inserttable(table("resume"), $resume, 1);
$response["resume_id"] = $pid;
change_level($userid, $pid);
if ($pid) {
//索引表
// $searchtab['id'] = $pid;
$searchtab['uid'] = $userid;
$searchtab['sex'] = $resume['sex'];
$searchtab['nature'] = $resume['nature'];
$searchtab['marriage'] = $resume['marriage'];
$searchtab['experience'] = $resume['experience'];
$searchtab['wage'] = $resume['wage'];
$searchtab['education'] = $resume['education'];
$searchtab['refreshtime'] = $resume['refreshtime'];
$searchtab['major'] = $resume['major'];
$searchtab['audit'] = 1;
$db->inserttable(table('resume_search_rtime'), $searchtab);
$searchtab['likekey'] = $resume['trade_cn'] . ',' . $resume['fullname'];
$db->inserttable(table('resume_search_key'), $searchtab);
unset($searchtab);
$db->inserttable(table('resume_district'), array("uid" => $userid, "pid" => $pid, "district" => 3, "sdistrict" => 0));
$intention_jobs_array = explode(',', $intention_jobs);
foreach ($intention_jobs_array as $key => $value) {
resume_intention_jobs($userid, $pid, $value);
}
$district_array = explode(',', $resume["district_cn"]);
foreach ($district_array as $key => $value) {
resume_district_cn($userid, $pid, $value);
}
//教育经历
// $resume_education = trim($resume['education_cn']);
// $edu_array = explode(';', $resume_education);
// foreach ($edu_array as $key => $value)
// {
// if(empty($value))
// {
// continue;
// }
// $data_info = explode(',', $value);
// $time_edu = explode('就读于', $data_info[0]);
// $edu_time = explode('~', $time_edu[0]);
// $edu_start_time = explode('-', $edu_time[0]);
// $eduarrsql['startyear'] = $edu_start_time[0];
// $eduarrsql['startmonth'] = $edu_start_time[1];
// if(trim($edu_time[1]) == '至今')
// {
// $eduarrsql['todate'] = 1;
// $eduarrsql['endyear'] = 0;
// $eduarrsql['endmonth'] = 7;
// }
// else
// {
// $eduarrsql['todate'] = 0;
// $time_info = explode('-', $edu_time[1]);
// $eduarrsql['endyear'] = $time_info[0];
// $eduarrsql['endmonth'] = $time_info[1];
// }
//
// $eduarrsql['school'] = $time_edu[1];
// $major_info = explode('：', $data_info[1]);
// $eduarrsql['speciality'] = $major_info[1];
// $education_info = explode('：', $data_info[2]);
// $eduarrsql['education_cn'] = $education_info[1];
// $work_edu = resume_work_education($eduarrsql['education_cn']);
// $eduarrsql['education'] = $work_edu['id'];
// $eduarrsql['pid'] = $pid;
// $eduarrsql['uid'] = $userid;
// $db->inserttable(table("resume_education"),$eduarrsql);
// }
// //工作经历
// $resume_work = $data->sheets[0]['cells'][$i][19];
// $work_array = explode(';', $resume_work);
// foreach ($work_array as $key => $value)
// {
// if(empty($value))
// {
// continue;
// }
// $data_info = explode(',', $value);
// $time_work = explode('就职于', $data_info[0]);
// $work_time = explode('~', $time_work[0]);
// $edu_start_time = explode('-', $work_time[0]);
// $workarrsql['startyear'] = $edu_start_time[0];
// $workarrsql['startmonth'] = $edu_start_time[1];
// if(trim($work_time[1]) == '至今')
// {
// $workarrsql['todate'] = 1;
// $workarrsql['endyear'] = 0;
// $workarrsql['endmonth'] = 7;
// }
// else
// {
// $workarrsql['todate'] = 0;
// $time_info = explode('-', $work_time[1]);
// $workarrsql['endyear'] = $time_info[0];
// $workarrsql['endmonth'] = $time_info[1];
// }
//
// $workarrsql['companyname'] = $time_work[1];
// $job_info = explode('：', $data_info[1]);
// $workarrsql['jobs'] = $job_info[1];
// $workarrsql['pid'] = $pid;
// $workarrsql['uid'] = $userid;
// $db->inserttable(table("resume_work"),$workarrsql);
// }
// //培训经历
// $resume_training = trim($data->sheets[0]['cells'][$i][20]);
// $training_array = explode(';', $resume_training);
// foreach ($training_array as $key => $value)
// {
// if(empty($value))
// {
// continue;
// }
// $data_info = explode('在', $value);
// $work_time = explode('~', $data_info[0]);
// $edu_start_time = explode('-', $work_time[0]);
// $trainingarrsql['startyear'] = $edu_start_time[0];
// $trainingarrsql['startmonth'] = $edu_start_time[1];
// if(trim($data_info[1]) == '至今')
// {
// $trainingarrsql['todate'] = 1;
// $trainingarrsql['endyear'] = 0;
// $trainingarrsql['endmonth'] = 7;
// }
// else
// {
// $trainingarrsql['todate'] = 0;
// $time_info = explode('-', $work_time[1]);
// $trainingarrsql['endyear'] = $time_info[0];
// $trainingarrsql['endmonth'] = $time_info[1];
// }
// $agency_info = explode('培训', $data_info[1]);
// $trainingarrsql['agency'] = $agency_info[0];
// $trainingarrsql['course'] = $agency_info[1];
// $trainingarrsql['pid'] = $pid;
// $trainingarrsql['uid'] = $userid;
// $db->inserttable(table("resume_training"),$trainingarrsql);
// }
}
\ORM::for_table(table("resume_temp"))->where("id", $id)->delete_many();
\ORM::for_table(table("resume_check_log"))->where("rid", $id)->delete_many();
check_pass_add_point($upload_uid, $pid);
}
//给上传者增加积分；
return $response;
}
function createResume($obj)
{
unset($obj["id"]);
if (!$obj["title"]) {
$obj["title"] = $obj["fullname"] . "的简历";
}
//dump($obj);
$obj["sex"] = $obj["sex_cn"] == "男" ? 1 : 2;
$nature = getId($obj["nature_cn"], "QS_jobs_nature");
if ($nature) {
$obj["nature"] = $nature["c_id"];
} else {
$obj["nature"] = 62;
$obj["nature_cn"] = "全职";
}
$obj["trade_cn"] = "其他行业";
$obj["trade"] = 45;
$obj["height"] = 0;
$obj["height"] = 0;
$obj['marriage'] = 0;
$obj['marriage_cn'] = "未婚";
$experience_cn = get_reg($obj["experience_cn"]);
if ($experience_cn) {
$obj['experience_cn'] = $experience_cn;
$obj['experience'] = getId($experience_cn, "QS_experience")["c_id"];
} else {
$obj['experience_cn'] = "无经验";
$obj['experience'] = 74;
}
$wage_cn = get_reg($obj["wage_cn"]);
if ($wage_cn) {
$obj['wage_cn'] = $wage_cn;
$obj['wage'] = getId($wage_cn, "QS_wage")["c_id"];
} else {
$obj['wage_cn'] = "面议";
$obj['wage'] = 294;
}
$education_cn = get_reg($obj["education_cn"]);
if ($education_cn) {
$obj['education_cn'] = $education_cn;
$obj['education'] = getId($education_cn, "QS_education")["c_id"];
} else {
$obj['education_cn'] = "初中";
$obj['education'] = 65;
}
$major_cn = get_reg($obj["major_cn"]);
if ($major_cn) {
$obj['major_cn'] = $major_cn;
$obj['major'] = getId($major_cn, "QS_major")["c_id"];
} else {
$obj['major_cn'] = "其他专业";
$obj['major'] = 290;
}
$obj['tag_cn'] = "";
$obj['tag'] = "";
$obj['specialty'] = "";
$obj['photo_img'] = "";
$obj['addtime'] = time();
$obj['refreshtime'] = time();
$obj['level'] = 1;
$obj["current_cn"] = "观望有好的机会再考虑";
$obj["current"] = 243;
$obj["word_resume"] = "";
$obj["key"] = "";
$obj["tpl"] = "";
$obj["status"] = 0;
// dump($obj);
//exit;
$new = \ORM::for_table(table('resume'))->create($obj);
$a = $new->save();
$searchtab['id'] = $new->id;
$searchtab['uid'] = $obj['uid'];
$db = Leven::db();
require_once ROOT . 'include/fun_personal.php';
$db->inserttable(table('resume_search_key'), $searchtab);
$db->inserttable(table('resume_search_rtime'), $searchtab);
check_resume($obj["uid"], $new->id);
// dump($a);
}
