$wheresql .= " AND f.favoritesa_ddtime>" . $settr_val; } $total_sql = "SELECT COUNT(*) AS num FROM " . table('company_favorites') . " AS f " . $wheresql; $total_val = $db->get_total($total_sql); $page = new page(array('total' => $total_val, 'perpage' => $perpage, 'getarray' => $_GET)); $offset = ($page->nowindex - 1) * $perpage; $smarty->assign('title', '企业人才库 - 企业会员中心 - ' . $_CFG['site_name']); $smarty->assign('act', $act); $smarty->assign('favorites', get_favorites($offset, $perpage, $joinsql . $wheresql)); if ($total_val > $perpage) { $smarty->assign('page', $page->show(3)); } $smarty->display('member_company/company_favorites.htm'); } elseif ($act == 'favorites_del') { $yid = !empty($_REQUEST['y_id']) ? $_REQUEST['y_id'] : showmsg("你没有选择简历!", 1); if ($n = del_favorites($yid, $_SESSION['uid'])) { showmsg("删除成功!共删除 {$n} 行", 2); } else { showmsg("失败!", 0); } } elseif ($act == 'interview_list') { require_once QISHI_ROOT_PATH . 'include/page.class.php'; $perpage = 10; $joinsql = " LEFT JOIN " . table('resume') . " as r ON i.resume_id=r.id "; $wheresql = " WHERE i.company_uid='{$_SESSION['uid']}' "; //面试职位 筛选 $jobsid = intval($_GET['jobsid']); if ($jobsid > 0) { $wheresql .= " AND i.jobs_id='{$jobsid}' "; } //对方查看状态 帅选
} $perpage = 10; $total_sql = "SELECT COUNT(*) AS num FROM " . table('personal_favorites') . " AS f {$wheresql} "; $total_val = $db->get_total($total_sql); $page = new page(array('total' => $total_val, 'perpage' => $perpage)); $currenpage = $page->nowindex; $offset = ($currenpage - 1) * $perpage; $smarty->assign('title', '职位收藏夹 - 个人会员中心 - ' . $_CFG['site_name']); $smarty->assign('act', $act); $joinsql = " LEFT JOIN " . table('jobs') . " as j ON f.jobs_id=j.id "; $smarty->assign('favorites', get_favorites($offset, $perpage, $joinsql . $wheresql)); $smarty->assign('page', $page->show(3)); $smarty->display('member_personal/personal_favorites.htm'); } elseif ($act == 'del_favorites') { $yid = !empty($_REQUEST['y_id']) ? $_REQUEST['y_id'] : showmsg("你没有选择项目!", 1); $_POST['delete'] ? !del_favorites($yid, $_SESSION['uid']) ? showmsg("删除失败!", 0) : showmsg("删除成功!", 2) : ''; } elseif ($act == 'apply_jobs') { require_once QISHI_ROOT_PATH . 'include/page.class.php'; $wheresql = " WHERE a.personal_uid='{$_SESSION['uid']}' "; $resume_id = intval($_GET['resume_id']); if ($resume_id > 0) { $wheresql .= " AND a.resume_id='{$resume_id}' "; } $aetlook = intval($_GET['aetlook']); if ($aetlook > 0) { $wheresql .= " AND a.personal_look='{$aetlook}'"; } $perpage = 10; $total_sql = "SELECT COUNT(*) AS num FROM " . table('personal_jobs_apply') . " AS a {$wheresql} "; $total_val = $db->get_total($total_sql); $page = new page(array('total' => $total_val, 'perpage' => $perpage));