function get_resume_list($wheresql, $titlele = 12, $countinterview = false, $countdown = false, $countapply = false) { global $db; $result = $db->query("{$wheresql} LIMIT 30"); while ($row = $db->fetch_array($result)) { $row['resume_url'] = url_rewrite('QS_resumeshow', array('id' => $row['id'])); $row['title'] = cut_str($row['title'], $titlele, 0, "..."); $row['number'] = "N" . str_pad($row['id'], 7, "0", STR_PAD_LEFT); $row['lastname'] = cut_str($row['fullname'], 1, 0, "**"); if ($countinterview) { $wheresql = " WHERE resume_uid='{$row['uid']}' AND resume_id= '{$row['id']}'"; $row['countinterview'] = $db->get_total("SELECT COUNT(*) AS num FROM " . table('company_interview') . $wheresql); } if ($countdown) { $wheresql = " WHERE resume_uid='{$row['uid']}' AND resume_id= '{$row['id']}'"; $row['countdown'] = $db->get_total("SELECT COUNT(*) AS num FROM " . table('company_down_resume') . $wheresql); } if ($countapply) { $wheresql = " WHERE personal_uid='{$row['uid']}' AND resume_id= '{$row['id']}'"; $row['countapply'] = $db->get_total("SELECT COUNT(*) AS num FROM " . table('personal_jobs_apply') . $wheresql); } $interest_jobs_id = get_interest_jobs_id_by_resume($row['uid'], $row['id']); $interest_jobs_id = explode("-", $interest_jobs_id); $interest_jobs_id = implode(",", $interest_jobs_id); if ($interest_jobs_id) { $cate = $db->getall("select id,parentid from " . table('category_jobs') . " where id in (" . $interest_jobs_id . ")"); foreach ($cate as $k => $v) { $arr[] = $v['parentid'] . "." . $v['id'] . ".0"; } $row['interestjobs'] = implode("_", $arr); } else { $row['interestjobs'] = ""; } $row_arr[] = $row; } return $row_arr; }
$company_url = url_rewrite('QS_companyshow', array('id' => $company_id['id'])); $message[] = "您的简历被<a href=\"" . $company_url . "\" target=\"_black\" class=\"underline\">【" . $value['company_name'] . "】</a>下载!主动联系招聘单位更容易获得工作机会!"; } $inter_resume = $db->getall("SELECT distinct company_id , company_name FROM " . table('company_interview') . " WHERE resume_uid='" . $_SESSION['uid'] . "' AND interview_addtime > " . $time . " AND personal_look=1 "); foreach ($inter_resume as $key => $value) { $company_url = url_rewrite('QS_companyshow', array('id' => $value['company_id'])); $message[] = "<a href=\"" . $company_url . "\" target=\"_black\" class=\"underline\">【" . $value['company_name'] . "】</a>对您发起面试邀请,请尽快联系该招聘单位!"; } $smarty->assign('message', $message); $smarty->display('member_personal/personal_index.htm'); } elseif ($act == 'ajax_get_interest_jobs') { global $_CFG; $uid = intval($_SESSION['uid']); $pid = intval($_GET['pid']); $html = ""; $interest_id = get_interest_jobs_id_by_resume($uid, $pid); $jobs_list = get_interest_jobs_list($interest_id); if (!empty($jobs_list)) { foreach ($jobs_list as $k => $v) { $jobs_url = url_rewrite("QS_jobsshow", array("id" => $v['id'])); $company_url = url_rewrite("QS_companyshow", array("id" => $v['company_id'])); $html .= '<table> <tbody> <tr> <td class="frist" width="117"><div class="index-line1"><a target="_black" href="' . $jobs_url . '" class="underline job-link">' . $v["jobs_name"] . '</a></div></td> <td width="228"><div class="index-line2"><a target="_black" href="' . $company_url . '" class="underline com-link">' . $v["companyname"] . '</a></div></td> <td width="139"><div class="index-line3">' . $v["district_cn"] . '</div></td> <td width="195"><span class="yh">' . $v["wage_cn"] . '</span></td> <td width="75">' . date("Y-m-d", $v["refreshtime"]) . '</td> </tr> </tbody>