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; }