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>
