Exemple #1
0
        $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}' ";
    }
    //对方查看状态 帅选
Exemple #2
0
    }
    $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));