//面试职位 筛选 $jobsid = intval($_GET['jobsid']); if ($jobsid > 0) { $wheresql .= " AND i.jobs_id='{$jobsid}' "; } //对方查看状态 帅选 $look = intval($_GET['look']); if ($look > 0) { $wheresql .= " AND i.personal_look='{$look}' "; } $total_sql = "SELECT COUNT(*) AS num FROM " . table('company_interview') . " as i " . $wheresql; $total_val = $db->get_total($total_sql); $page = new page(array('total' => $total_val, 'perpage' => $perpage, 'getarray' => $_GET)); $currenpage = $page->nowindex; $offset = ($currenpage - 1) * $perpage; $resume = get_interview($offset, $perpage, $joinsql . $wheresql); $smarty->assign('act', $act); $smarty->assign('title', '我发起的面试邀请 - 企业会员中心 - ' . $_CFG['site_name']); $smarty->assign('resume', $resume); $count1 = count_interview($_SESSION['uid'], 1, $jobsid); //未查看 $count2 = count_interview($_SESSION['uid'], 2, $jobsid); //已查看 $count = $count1 + $count2; $smarty->assign('count', $count); $smarty->assign('count1', $count1); $smarty->assign('count2', $count2); $smarty->assign('filter_jobs', get_interview_jobs($_SESSION['uid'])); if ($total_val > $perpage) { $smarty->assign('page', $page->show(3)); }
$sql = "select jobs_name from " . table("hunter_jobs") . " where id=" . intval($_GET['jobsid']) . " "; $row = $db->getone($sql); $smarty->assign('jobs_name', $row["jobs_name"]); } $look = intval($_GET['look']); if ($look > 0) { $wheresql .= " AND i.personal_look='{$look}' "; } $total_sql = "SELECT COUNT(*) AS num FROM " . table('hunter_interview') . " as i " . $wheresql; $total_val = $db->get_total($total_sql); $page = new page(array('total' => $total_val, 'perpage' => $perpage, 'getarray' => $_GET)); $currenpage = $page->nowindex; $offset = ($currenpage - 1) * $perpage; $smarty->assign('act', $act); $smarty->assign('title', '我发起的面试邀请 - 猎头会员中心 - ' . $_CFG['site_name']); $smarty->assign('resume', get_interview($offset, $perpage, $joinsql . $wheresql)); $count1 = count_interview($_SESSION['uid'], 1, $jobsid); //未查看 $count2 = count_interview($_SESSION['uid'], 2, $jobsid); //以查看 $count = $count1 + $count2; $smarty->assign('count', $count); $smarty->assign('count1', $count1); $smarty->assign('count2', $count2); $smarty->assign('jobs', get_auditjobs($_SESSION['uid'])); $smarty->assign('page', $page->show(3)); $smarty->display('member_hunter/hunter_interview.htm'); } elseif ($act == 'interview_del') { $yid = !empty($_REQUEST['y_id']) ? $_REQUEST['y_id'] : showmsg("你没有选择简历!", 1); if (del_interview($yid, $_SESSION['uid'])) { showmsg("删除成功!", 2);