function export_resume($yid) { global $db; $yid_str = implode(",", $yid); $oederbysql = " order BY refreshtime desc "; $wheresql = empty($wheresql) ? " id in ({$yid_str}) " : " and id in ({$yid_str}) "; if (!empty($wheresql)) { $wheresql = " WHERE " . ltrim(ltrim($wheresql), 'AND'); } $data = $db->getall("select * from " . table('resume') . $wheresql); if (!empty($data)) { $result = $data; } if (!empty($result)) { foreach ($result as $key => $value) { $arr[$key]['num'] = $key; $arr[$key]['title'] = $value['title']; $arr[$key]['fullname'] = $value['fullname']; $arr[$key]['sex_cn'] = $value['sex_cn']; $arr[$key]['birthdate'] = $value['birthdate']; $arr[$key]['height'] = $value['height']; $arr[$key]['householdaddress'] = $value['householdaddress']; $arr[$key]['marriage_cn'] = $value['marriage_cn']; $arr[$key]['experience_cn'] = $value['experience_cn']; $arr[$key]['education_cn'] = $value['education_cn']; $arr[$key]['natrue_cn'] = $value['natrue_cn']; $arr[$key]['trade_cn'] = $value['trade_cn']; $arr[$key]['district_cn'] = $value['district_cn']; $arr[$key]['wage_cn'] = $value['wage_cn']; $arr[$key]['tag'] = preg_replace("/\\d+/", '', $value['tag']); $arr[$key]['tag'] = preg_replace('/\\,/', '', $arr[$key]['tag']); $arr[$key]['tag'] = preg_replace('/\\|/', ' ', $arr[$key]['tag']); $arr[$key]['school'] = ""; $school = $db->getall("select * from " . table('resume_education') . " where pid=" . $value['id'] . " order by id desc"); if (!empty($school)) { foreach ($school as $key1 => $value1) { $arr[$key]['school'] .= $value1['start'] . "-" . $value1['endtime'] . "就读于" . $value1['school'] . ",所学专业:" . $value1['speciality'] . ",学历:" . $value1['education_cn'] . "; "; } } $arr[$key]['work'] = ""; $work = $db->getall("select * from " . table('resume_work') . " where pid=" . $value['id'] . " order by id desc"); if (!empty($work)) { foreach ($work as $key1 => $value1) { $arr[$key]['work'] .= $value1['start'] . "-" . $value1['endtime'] . "就职于" . $value1['companyname'] . ",任职:" . $value1['jobs'] . "; "; } } $arr[$key]['train'] = ""; $train = $db->getall("select * from " . table('resume_training') . " where pid=" . $value['id'] . " order by id desc"); if (!empty($train)) { foreach ($train as $key1 => $value1) { $arr[$key]['train'] .= $value1['start'] . "-" . $value1['endtime'] . "在" . $value1['agency'] . "培训" . $value1['course'] . "课程; "; } } $arr[$key]['telephone'] = $value['telephone']; $arr[$key]['email'] = $value['email']; $arr[$key]['qq'] = $value['qq']; $arr[$key]['address'] = $value['address']; $arr[$key]['website'] = $value['website']; $arr[$key]['recentjobs'] = $value['recentjobs']; $arr[$key]['intention_jobs'] = $value['intention_jobs']; $arr[$key]['specialty'] = str_replace("\n", "", str_replace("\r", "", $value['specialty'])); $arr[$key]['addtime'] = date("Y-m-d", $value['addtime']); $arr[$key]['refreshtime'] = date("Y-m-d", $value['refreshtime']); $arr[$key]['talent'] = $value['talent'] == 1 ? "普通" : "高级"; $arr[$key]['complete_percent'] = $value['complete_percent']; } $top_str = "序号\t简历名称\t姓名\t性别\t出生年月\t身高\t户籍所在地\t婚姻状况\t工作经验\t学历\t意向职位性质\t意向行业\t意向工作地区\t意向薪资\t标签\t教育经历\t工作经历\t培训经历\t手机\t邮箱\tQQ\t地址\t个人主页\t最近从事工作\t意向职位\t技能特长\t添加时间\t刷新时间\t简历等级\t完整度\t\n"; create_excel($top_str, $arr); return true; } else { return false; } }
// // begin by creating pivot table from analyses_output table // // get full list of analyses $result = mysql_query("SELECT name from " . $current_project . ".analyses_list"); while ($row = mysql_fetch_array($result)) { $analyses_list[] = $row[0]; } // get full list of sessions $result = mysql_query("SELECT name from " . $current_project . ".session_list"); while ($row = mysql_fetch_array($result)) { $session_list[] = $row[0]; } // now build pivot table query $result = mysql_query("DROP TABLE IF EXISTS " . $current_project . ".output"); $output_trunk = " CREATE TABLE " . $current_project . ".output AS SELECT participant "; foreach ($analyses_list as $analysis) { foreach ($session_list as $session) { $output_trunk .= ", avg(if(session_id = '" . $session . "' and runner='" . $analysis . "', value, NULL)) \n\t \t\tAS " . $analysis . "_" . $session . ""; } } $output_trunk .= " FROM " . $current_project . ".analyses_output GROUP BY participant "; $result = mysql_query($output_trunk); echo "<div>"; table_builder($current_project . ".output"); echo "</div>"; } if (isset($_GET['create_excel'])) { create_excel($current_project . '.output'); echo "File has been saved. \n <br><a href='projects/" . $current_project . "/excel_output/" . $current_project . ".output.xls'><button>Click here to open it.</button></a>"; }
function export_company($yid) { global $db; $yid_str = implode(",", $yid); $oederbysql = " order BY refreshtime desc "; $wheresql = empty($wheresql) ? " uid in ({$yid_str}) " : " and uid in ({$yid_str}) "; if (!empty($wheresql)) { $wheresql = " WHERE " . ltrim(ltrim($wheresql), 'AND'); } $data = $db->getall("select * from " . table('company_profile') . $wheresql); $result = $data; if (!empty($result)) { foreach ($result as $key => $value) { $arr[$key]['num'] = $key; $user = $db->getone("select username from " . table('members') . " where uid=" . $value['uid']); $arr[$key]['username'] = $user['username']; $arr[$key]['company_id'] = $value['id']; $arr[$key]['companyname'] = $value['companyname']; $arr[$key]['nature_cn'] = $value['nature_cn']; $arr[$key]['trade_cn'] = $value['trade_cn']; $arr[$key]['scale_cn'] = $value['scale_cn']; $arr[$key]['district_cn'] = $value['district_cn']; $arr[$key]['street_cn'] = $value['street_cn']; $arr[$key]['registered'] = $value['registered'] . $value['currency']; $arr[$key]['contact'] = $value['contact']; $arr[$key]['website'] = $value['website']; $arr[$key]['telephone'] = $value['telephone']; $arr[$key]['address'] = $value['address']; $arr[$key]['email'] = $value['email']; $arr[$key]['contents'] = str_replace("\n", "", str_replace("\r", "", $value['contents'])); } $top_str = "序号\t所属会员\t公司ID\t公司名称\t公司性质\t行业类别\t公司规模\t所在地区\t所在街道\t注册资金\t联系人\t网址\t联系电话\t联系地址\t联系邮箱\t公司简介\t\n"; create_excel($top_str, $arr); write_log("导出企业uid为" . $yid_str . "的企业资料", $_SESSION['admin_name'], 3); return true; } else { return false; } }