PHP count_resume Examples

Example #1

File: personal_index.php Project: winiceo/job

*/
define('IN_QISHI', true);
require_once dirname(__FILE__) . '/personal_common.php';
$smarty->assign('leftmenu', "index");
if ($act == 'index') {
    $uid = intval($_SESSION['uid']);
    $smarty->assign('title', '个人会员中心 - ' . $_CFG['site_name']);
    $smarty->assign('user', $user);
    require_once QISHI_ROOT_PATH . 'include/fun_user.php';
    $smarty->assign('loginlog', get_loginlog_one($uid, '1001'));
    $wheresql = " WHERE uid='" . $_SESSION['uid'] . "' ";
    $sql = "SELECT * FROM " . table('resume') . $wheresql;
    $smarty->assign('rand', rand(1, 100));
    $smarty->assign('points', get_user_points($uid));
    $smarty->assign('my_resume', get_resume_list($sql));
    $smarty->assign('count_resume', count_resume($uid));
    $smarty->assign('count_interview', count_interview($uid));
    $smarty->assign('count_apply', count_personal_jobs_apply($uid));
    $smarty->assign('count_attention_me', count_personal_attention_me($uid));
    $smarty->assign('msg_total1', $db->get_total("SELECT COUNT(*) AS num FROM " . table('pms') . " WHERE (msgfromuid='{$uid}' OR msgtouid='{$uid}') AND `new`='1' AND `replyuid`<>'{$uid}' AND msgtype=1"));
    $smarty->assign('msg_total2', $db->get_total("SELECT COUNT(*) AS num FROM " . table('pms') . " WHERE (msgfromuid='{$uid}' OR msgtouid='{$uid}') AND `new`='2' AND `replyuid`<>'{$uid}' AND msgtype=1"));
    //首页提示消息(最近两周 下载 和 面试邀请的信息)
    $message = array();
    $time = strtotime("- 14 day");
    $down_resume = $db->getall("SELECT distinct company_uid , company_name FROM " . table('company_down_resume') . " WHERE resume_uid='" . $_SESSION['uid'] . "' AND down_addtime > " . $time);
    foreach ($down_resume as $key => $value) {
        $company_id = $db->getone("SELECT id FROM " . table('company_profile') . " WHERE uid=" . $value['company_uid'] . " LIMIT 1");
        $company_url = url_rewrite('QS_companyshow', array('id' => $company_id['id']));
        $message[] = "您的简历被<a href=\"" . $company_url . "\" target=\"_black\" class=\"underline\">【" . $value['company_name'] . "】</a>下载！主动联系招聘单位更容易获得工作机会！";
    }
    $inter_resume = $db->getall("SELECT distinct company_id , company_name FROM " . table('company_interview') . " WHERE resume_uid='" . $_SESSION['uid'] . "' AND interview_addtime > " . $time . " AND personal_look=1 ");

Example #2

File: user.php Project: winiceo/job

    $str .= "alert('请先验证手机！');";
    $str .= "window.location.href='account_security.php';";
    $str .= "</script>";
    echo $str;
}
if ($act == 'index') {
    $smarty->cache = false;
    $user = wap_get_user_info(intval($_SESSION['uid']));
    $smarty->assign('user', $user);
    $resume_info = get_userprofile(intval($_SESSION['uid']));
    if (empty($resume_info)) {
        header("Location: ?act=make_resume");
    } else {
        $resume_info['age'] = date("Y") - $resume_info['birthday'];
        //统计简历数
        $smarty->assign('count_resume', count_resume(intval($_SESSION['uid'])));
        //统计面试邀请对方未查看数
        $smarty->assign('count_interview', count_interview($_SESSION['uid'], 2, 1));
        $smarty->assign('resume_info', $resume_info);
        $smarty->display("m/personal/m-user-personal-index.html");
    }
} elseif ($act == 'favorites') {
    $perpage = 7;
    $count = 0;
    $page = empty($_GET['page']) ? 1 : intval($_GET['page']);
    if ($page < 1) {
        $page = 1;
    }
    $theurl = "wap_user.php?act=favorites";
    $start = ($page - 1) * $perpage;
    $wheresql = " WHERE f.personal_uid='{$_SESSION['uid']}' ";