function get_apply_jobs($offset, $perpage, $joinsql, $wheresql) { global $db; $limit = " LIMIT " . intval($offset) . ',' . intval($perpage); $get_sql = $joinsql . $wheresql; //申请的普通职位 $select = " a.*,j.addtime,j.company_id,j.companyname,j.company_addtime,j.wage_cn,j.district_cn,j.deadline,j.refreshtime,j.click"; $sql = "SELECT {$select} FROM " . table('personal_jobs_apply') . " AS a {$get_sql} ORDER BY a.did DESC " . $limit; $result = $db->query($sql); while ($row = $db->fetch_array($result)) { //标识一下普通职位 $row['is_senior_job'] = '0'; if (empty($row['companyname'])) { $jobs = $db->getone("select * from " . table('jobs_tmp') . " WHERE id='{$row['jobs_id']}' LIMIT 1"); $row['addtime'] = $jobs['addtime']; $row['companyname'] = $jobs['companyname']; $row['company_addtime'] = $jobs['company_addtime']; $row['company_id'] = $jobs['company_id']; $row['wage_cn'] = $jobs['wage_cn']; $row['district_cn'] = $jobs['district_cn']; $row['deadline'] = $jobs['deadline']; $row['refreshtime'] = $jobs['refreshtime']; $row['click'] = $jobs['click']; } $resume = $db->getone("select title from " . table('resume') . " where id=" . $row['resume_id']); if ($resume) { $row['resume_name'] = $resume['title']; } else { $row['resume_name'] = "该简历已经删除"; } $row['company_url'] = url_rewrite('QS_companyshow', array('id' => $row['company_id'])); $row['belong_name'] = $row['company_name']; $row['belong_url'] = $row['company_url']; $row['jobs_url'] = url_rewrite('QS_jobsshow', array('id' => $row['jobs_id'])); $row['wap_jobs_url'] = m_url_rewrite("jobs-show", array("id" => $row['jobs_id'])); //答复状态 if ($row['personal_look'] == '1') { $row['reply_status'] = "企业未查看"; } else { if ($row['is_reply'] == '0') { $row['reply_status'] = "待反馈"; } elseif ($row['is_reply'] == '1') { $row['reply_status'] = "合格"; } elseif ($row['is_reply'] == '2') { $row['reply_status'] = "不合格"; } elseif ($row['is_reply'] == '3') { $row['reply_status'] = "待定"; } elseif ($row['is_reply'] == '4') { $row['reply_status'] = "未接通"; } } $row_arr[] = $row; } return $row_arr; }
header("Location: ../login.php"); } $user = get_user_info($_SESSION['uid']); if ($_CFG['login_per_audit_mobile'] && $user['mobile_audit'] == "0") { $str = "<script>"; $str .= "alert('请先验证手机!');"; $str .= "window.location.href='account_security.php';"; $str .= "</script>"; echo $str; } elseif ($act == 'interview') { $uid = intval($_SESSION["uid"]); $wheresql = " WHERE i.resume_uid={$uid} "; $perpage = 5; $count = 0; $page = empty($_GET['page']) ? 1 : intval($_GET['page']); if ($page < 1) { $page = 1; } $start = ($page - 1) * $perpage; $total_sql = "SELECT COUNT(*) AS num FROM " . table('company_interview') . " as i {$wheresql}"; $count = $db->get_total($total_sql); $limit = " LIMIT {$start},{$perpage}"; $sql = "select * from " . table("company_interview") . " as i {$wheresql} order by i.interview_addtime " . $limit; $interview = $db->getall($sql); foreach ($interview as $key => $value) { $value['job_url'] = m_url_rewrite("jobs-show", array("id" => $value['jobs_id'])); $interview[$key] = $value; } $smarty->assign('interview', $interview); $smarty->display("m/personal/m-interview.html"); }