Ejemplo n.º 1
0
 //面试职位 筛选
 $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));
 }
Ejemplo n.º 2
0
        $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);