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); }