function wap_get_my_attention($offset, $perpage, $get_sql = '')
{
global $db;
$limit = " LIMIT {$offset},{$perpage}";
$selectstr = " a.*,r.subsite_id,r.uid as ruid,r.fullname,r.display_name,r.sex_cn,r.sex,r.education_cn,r.experience_cn,r.intention_jobs,r.district_cn,r.wage_cn,r.trade_cn,r.nature_cn,r.major_cn,r.birthdate,r.refreshtime";
$result = $db->query("SELECT {$selectstr} FROM " . table('view_resume') . " as a {$get_sql} ORDER BY a.id DESC {$limit}");
while ($row = $db->fetch_array($result)) {
$row['resume_url'] = wap_url_rewrite("resume-show", array('id' => $row['resumeid']), 1, $row['subsite_id']);
if ($row['display_name'] == "3") {
if ($row['sex'] == 1) {
$row['fullname'] = cut_str($row['fullname'], 1, 0, "先生");
} elseif ($row['sex'] == 2) {
$row['fullname'] = cut_str($row['fullname'], 1, 0, "女士");
}
} elseif ($row['display_name'] == "2") {
$row['fullname'] = "N" . str_pad($row['resumeid'], 7, "0", STR_PAD_LEFT);
}
//判断是否收藏过
if (check_favorites($row['resumeid'], $_SESSION['uid'])) {
$row['is_favorites'] = 1;
}
$y = date("Y");
$row['age'] = $y - $row['birthdate'];
$row['addtime'] = date('Y-m-d', $row['addtime']);
/*
获取简历标记
*/
$row_state = get_resume_state($_SESSION['uid'], $row['resumeid']);
$row['resume_state'] = $row_state['resume_state'];
$row['resume_state_cn'] = $row_state['resume_state_cn'];
$row_arr[] = $row;
}
return $row_arr;
}
function get_apply_jobs($offset, $perpage, $get_sql = '')
{
global $db;
$limit = " LIMIT {$offset},{$perpage}";
$selectstr = " a.*,r.subsite_id,r.id,r.uid as ruid,r.fullname,r.display_name,r.sex_cn,r.sex,r.education_cn,r.experience_cn,r.major_cn,r.intention_jobs,r.district_cn,r.wage_cn,r.trade_cn,r.nature_cn,r.birthdate,r.addtime,r.refreshtime,r.display";
$result = $db->query("SELECT {$selectstr} FROM " . table('personal_jobs_apply') . " as a {$get_sql} ORDER BY a.personal_look ASC , a.did DESC {$limit}");
while ($row = $db->fetch_array($result)) {
if ($row['display_name'] == "2") {
$row['fullname'] = "N" . str_pad($row['id'], 7, "0", STR_PAD_LEFT);
} elseif ($row['display_name'] == "3") {
if ($row['sex'] == 1) {
$row['fullname'] = cut_str($row['fullname'], 1, 0, "先生");
} elseif ($row['sex'] == 2) {
$row['fullname'] = cut_str($row['fullname'], 1, 0, "女士");
}
}
$row['jobs_name_'] = cut_str($row['jobs_name'], 7, 0, "...");
$row['specialty_'] = $row['specialty'];
$row['specialty'] = cut_str($row['specialty'], 30, 0, "...");
$row['resume_url'] = url_rewrite('QS_resumeshow', array('id' => $row['resume_id'], 'apply' => 1), 1, $row['subsite_id']);
$row['jobs_url'] = url_rewrite('QS_jobsshow', array('id' => $row['jobs_id']));
$y = date("Y");
if (intval($row['birthdate']) == 0) {
$row['age'] = '';
} else {
$row['age'] = $y - $row['birthdate'];
}
/* 教育经历 培训经历 */
$row['resume_education_list'] = get_resume_education($row['ruid'], $row['resume_id']);
$row['resume_work_list'] = get_resume_work($row['ruid'], $row['resume_id']);
/*
获取简历标记
*/
$row_state = get_resume_state($_SESSION['uid'], $row['resume_id']);
$row['resume_state'] = $row_state['resume_state'];
$row['resume_state_cn'] = $row_state['resume_state_cn'];
$row_arr[] = $row;
}
return $row_arr;
}
