PHP get_apply_jobs Examples

Example #1

File: company_recruitment.php Project: winiceo/job

    $is_apply = intval($_GET['is_apply']);
    if ($is_apply > 0) {
        if ($is_apply == 1) {
            $wheresql .= " AND a.is_apply=1 ";
        } else {
            $wheresql .= " AND a.is_apply=0 ";
        }
    }
    $perpage = 10;
    $total_sql = "SELECT COUNT(*) AS num FROM " . table('personal_jobs_apply') . " AS a  " . $joinsql . " {$wheresql} ";
    $total = $db->get_total($total_sql);
    $page = new page(array('total' => $total, 'perpage' => $perpage));
    $offset = ($page->nowindex - 1) * $perpage;
    $smarty->assign('act', $act);
    $smarty->assign('title', '收到的职位申请 - 企业会员中心 - ' . $_CFG['site_name']);
    $smarty->assign('jobs_apply', get_apply_jobs($offset, $perpage, $joinsql . $wheresql));
    if ($total > $perpage) {
        $smarty->assign('page', $page->show(3));
    }
    $smarty->assign('count', count_jobs_apply($_SESSION['uid'], 0, $jobsid));
    $smarty->assign('count1', count_jobs_apply($_SESSION['uid'], 1, $jobsid));
    $smarty->assign('count2', count_jobs_apply($_SESSION['uid'], 2, $jobsid));
    $smarty->assign('jobs', get_auditjobs($_SESSION['uid']));
    $smarty->display('member_company/company_apply_jobs.htm');
} elseif ($act == 'set_apply_jobs') {
    $yid = !empty($_REQUEST['y_id']) ? $_REQUEST['y_id'] : showmsg("你没有选择任何项目！", 1);
    set_apply($yid, $_SESSION['uid'], 2) ? showmsg("设置成功！", 2) : showmsg("设置失败！", 0);
} elseif ($act == 'apply_jobs_del') {
    $yid = !empty($_REQUEST['y_id']) ? $_REQUEST['y_id'] : showmsg("你没有选择项目！", 1);
    if ($n = del_apply_jobs($yid, $_SESSION['uid'])) {
        showmsg("删除成功！共删除 {$n} 行", 2);

Example #2

File: apply.php Project: winiceo/fenzhan

    $str .= "window.location.href='account_security.php';";
    $str .= "</script>";
    echo $str;
} elseif ($act == 'apply') {
    $wheresql = " WHERE a.personal_uid='{$_SESSION['uid']}' ";
    $perpage = 6;
    $count = 0;
    $page = empty($_GET['page']) ? 1 : intval($_GET['page']);
    if ($page < 1) {
        $page = 1;
    }
    $start = ($page - 1) * $perpage;
    $total_sql = "SELECT COUNT(*) AS num FROM  " . table('personal_jobs_apply') . " as a  {$wheresql}";
    $count = $db->get_total($total_sql);
    $joinsql .= " LEFT JOIN " . table('jobs') . " AS j ON a.jobs_id=j.id ";
    $smarty->assign('apply', get_apply_jobs($start, $perpage, $joinsql, $wheresql));
    $smarty->display("m/personal/m-apply.html");
} elseif ($act == 'apply_add') {
    $jobsid = intval($_POST["jobs_id"]) ? intval($_POST["jobs_id"]) : exit("出错了");
    $resumeid = intval($_POST["resume_id"]) ? intval($_POST["resume_id"]) : exit("出错了");
    $_POST = array_map("utf8_to_gbk", $_POST);
    $sql = "select * from " . table("personal_jobs_apply") . " where personal_uid=" . intval($_SESSION['uid']) . " and resume_id=" . intval($_POST["resume_id"]) . " and jobs_id=" . intval($_POST["jobs_id"]) . "";
    $row = $db->getone($sql);
    $resume_basic = get_resume_basic($_SESSION['uid'], $resumeid);
    $resume_basic = array_map("addslashes", $resume_basic);
    if (empty($resume_basic)) {
        exit("简历丢失");
    }
    if ($_SESSION['utype'] != 2) {
        exit("个人会员请登录后申请职位");
    } elseif ($row) {