select_num('sysmsg', array('fa_uid' => $uid, 'usertype' => $usertype, 'remind_status' => '0')); if ($sysMsgNum > 0) { $msgNum += $sysMsgNum; $arr['sysmsgNum'] = $sysMsgNum; } if (!empty($this->config['sy_chat_open']) && $this->config['sy_chat_open'] == 1) { // 未读聊天条数 // 根据后台设置聊天记录查询日期时限来查询 $day = !empty($this->config['sy_chat_day']) ? $this->config['sy_chat_day'] : 30; $time = strtotime('-' . $day . ' day') * 1000; $chatNum = $this->select_num('chat_log', array('to' => $uid, 'tusertype' => $usertype, 'status' => 2, 'sendTime' => array('>', $time))); if ($chatNum > 0) { $msgNum += $chatNum; $arr['chatNum'] = $chatNum; } } if ($_COOKIE['couponOT'] && $_COOKIE['couponOT'] == $uid) { $arr['couponNum'] = 0; } else { $couponNum = $this->select_num('coupon_list', array('uid' => $uid, 'validity' => array(array('>', time()), array('<', strtotime('+ ' . $this->config['sy_couponday'] . ' days'), 'AND')), 'status' => 1)); $arr['couponNum'] = $couponNum; if ($usertype == 2 || $usertype == 3) { require_once('cookie.model.php'); $cookieM = new cookie_model($this->db, $this->def); $cookieM->setcookie('couponOT', $uid, strtotime(date('Y-m-d', strtotime('+1 day')))); } } if ($usertype == 1) { // 邀请面试 $userid_msg = $this->select_num('userid_msg', array('uid' => $uid,'isdel'=>9,'is_browse' => '1')); if ($userid_msg > 0) { $msgNum += $userid_msg; $arr['userid_msgNum'] = $userid_msg; } // 求职咨询 $usermsg = $this->select_num('msg', array('uid' => $uid, 'status' => 1, 'user_remind_status' => '0')); if ($usermsg > 0) { $msgNum += $usermsg; $arr['usermsgNum'] = $usermsg; } // 邀请面试总数量 $yqnum = $this->select_num('userid_msg', array('uid' => $uid,'isdel'=>9)); $arr['yqnum'] = $yqnum; // 未读邀请面试数量 $wkyqnum = $this->select_num('userid_msg', array('uid' => $uid,'is_browse'=>'1','isdel'=>9)); $arr['wkyqnum'] = $wkyqnum; // 申请职位数量 $sq_nums = $this->select_num('userid_job', array('uid' => $uid,'isdel'=>9)); $arr['sq_jobnum'] = $sq_nums; // 收藏的职位数量 $favwhere['uid'] = $uid; if ($data['type']) {//小程序只显示普通职位 $favwhere['type'] = $data['type']; } $fav_jobnum = $this->select_num('fav_job', $favwhere); $arr['fav_jobnum'] = $fav_jobnum; // 关注数量 require_once('atn.model.php'); $atnM = new atn_model($this->db, $this->def); $where['uid'] = $uid; $where['sc_usertype'] = '2'; $where['PHPYUNBTWSTART_A'] = ''; $where['xjhid'][] = array('=', 0); $where['xjhid'][] = array('isnull', '', 'OR'); $where['PHPYUNBTWEND_A'] = ''; $atncomnum = $atnM->getAtnNum($where); $atnltnum = $atnM->getAtnNum(array('uid' => $uid, 'sc_usertype' => '3')); $atnacademynum = $atnM->getAtnNum(array('uid' => $uid, 'sc_usertype' => '5')); $atnxjhnum = $atnM->getAtnNum(array('uid' => $uid, 'sc_usertype' => '2', 'xjhid' => array('<>', ''))); $atn_num = $atncomnum + $atnltnum + $atnacademynum + $atnxjhnum; $arr['atn_num'] = $atn_num; } elseif ($usertype == 2) { //职位申请数 $jobApplyNum = $this->select_num('userid_job', array('com_id' => $uid,'isdel'=>9,'type' => array('<>', 3), 'is_browse' => '1')); if ($jobApplyNum > 0) { $msgNum += $jobApplyNum; $arr['jobApplyNum'] = $jobApplyNum; } //求职咨询数 $qzwhere['job_uid'] = $uid; $qzwhere['status'] = 1; $qzwhere['del_status'] = array('<>', '1'); $qzwhere['PHPYUNBTWSTART'] = ''; $qzwhere['reply'][] = array('isnull'); $qzwhere['reply'][] = array('=', '', 'OR'); $qzwhere['PHPYUNBTWEND'] = ''; $jobAskNum = $this->select_num('msg', $qzwhere); if ($jobAskNum > 0) { $msgNum += $jobAskNum; $arr['jobAskNum'] = $jobAskNum; } //赏金投递数 if ($data['from'] == 'wxapp') { $jobpackNum = $this->select_num('company_job_rewardlist', array('comid' => $uid, 'usertype' => '1', 'status' => '0')); } else { $jobpackNum = $this->select_num('company_job_rewardlist', array('comid' => $uid, 'status' => '0')); } if ($jobpackNum > 0) { $msgNum += $jobpackNum; $arr['jobpackNum'] = $jobpackNum; } //面试评价数 $company_msg = $this->select_once('company_msg', array('cuid' => $uid, 'status' => 1, 'orderby' => 'ctime,desc')); if ($company_msg) { $ComMsgNum = $this->select_num('company_msg', array('cuid' => $uid, 'status' => 1, 'reply' => '')); if ($ComMsgNum > 0) { $msgNum += $ComMsgNum; $arr['ComMsgNum'] = $ComMsgNum; } } $sqnum = $this->select_num('userid_job', array('com_id' => $uid,'isdel'=>9,'type' => array('<>', 3))); $arr['sqnum'] = $sqnum; $invite_num = $this->select_num('userid_msg', array('fid' => $uid,'isdel'=>9)); $arr['invite_num'] = $invite_num; $msgnum = $this->select_num('msg', array('job_uid' => $uid, 'status' => 1)); $arr['msgnum'] = $msgnum; $attention_menum = $this->select_num('atn', array('sc_uid' => $uid)); $arr['attention_menum'] = $attention_menum; $companyjobnum = $this->select_num('company_job', array('uid' => $uid, 'state' => 1, 'status' => 0, 'r_status' => 1)); $arr['companyjobnum'] = $companyjobnum; $arr['look_jobnum'] = $this->select_num('look_job', array('com_id' => $uid)); $talent_pool_num = $this->select_num('talent_pool', array('cuid' => $uid)); $arr['talent_pool_num'] = $talent_pool_num; require_once 'company.model.php'; $comM = new company_model($this->db, $this->def); $hitsExpour = $comM->getHitsExpoure($uid); $arr['hits'] = $hitsExpour['hits']; $arr['expoure'] = $hitsExpour['expoure']; } elseif ($usertype == 3) { //应聘简历 $userid_job = $this->select_num('userid_job', array('com_id' => $uid,'isdel'=>9,'type' => 3, 'is_browse' => '1')); if ($userid_job > 0) { $msgNum += $userid_job; $arr['userid_jobNum'] = $userid_job; } //委托简历 $entrust = $this->select_num('entrust', array('lt_uid' => $uid, 'remind_status' => '0')); if ($entrust > 0) { $msgNum += $entrust; $arr['entrustNum'] = $entrust; } //求职咨询 $msg = $this->select_num('msg', array('job_uid' => $uid, 'status' => 1, 'type' => 3, 'com_remind_status' => '0')); if ($msg > 0) { $msgNum += $msg; $arr['commsgNum'] = $msg; } $downnum = $this->select_num('down_resume', array('comid' => $uid, 'usertype' => 3,'isdel'=>9)); $arr['downnum'] = $downnum; $ypnum = $this->select_num('userid_job', array('com_id' => $uid, 'type' => 3,'isdel'=>9)); $arr['ypnum'] = $ypnum; $jobnum = $this->select_num('lt_job', array('uid' => $uid, 'status' => '1', 'zp_status' => array('<>', '1'))); $arr['jobnum'] = $jobnum; } elseif ($usertype == 4) { //咨询留言 $message = $this->select_num('px_zixun', array('s_uid' => $uid, 'status' => '1')); if ($message > 0) { $msgNum += $message; $arr['messageNum'] = $message; } //课程预约 $sign_up = $this->select_num('px_baoming', array('s_uid' => $uid, 'status' => '0')); if ($sign_up > 0) { $msgNum += $sign_up; $arr['sign_upNum'] = $sign_up; } //课程数目 $subject_num = $this->select_num('px_subject', array('uid' => $uid)); $arr['subject_num'] = $subject_num; //课程预约数目 $baoming_num = $this->select_num('px_baoming', array('s_uid' => $uid)); $arr['baoming_num'] = $baoming_num; //咨询留言数目 $zixun_num = $this->select_num('px_zixun', array('s_uid' => $uid)); $arr['zixun_num'] = $zixun_num; } } $arr['usertype'] = $usertype; $arr['msgNum'] = $msgNum; return $arr; } /** * @desc 设置管理后台右上角用户名展示未审核消息数 */ function msgNum() { $msgNum = 0; $arr = array(); //待审核企业 $company = $this->select_num('company', array('r_status' => '0')); if ($company > 0) { $msgNum += $company; $arr['company'] = $company; } //待审核职位 $company_job = $this->select_num('company_job', array('state' => '0')); if ($company_job > 0) { $msgNum += $company_job; $arr['company_job'] = $company_job; } //待审核兼职 $partjob = $this->select_num('partjob', array('state' => '0')); if ($partjob > 0) { $msgNum += $partjob; $arr['partjob'] = $partjob; } //待审核企业认证 $company_cert = $this->select_num('company_cert', array('status' => '0', 'type' => '3')); if ($company_cert > 0) { $msgNum += $company_cert; $arr['company_cert']= $company_cert; } //待审核企业logo $comlogo = $this->select_num('company', array('logo' => array('<>', ''), 'logo_status' => '1')); if ($comlogo > 0) { $msgNum += $comlogo; $arr['comlogo'] = $comlogo; } //待审核企业环境 $comshow = $this->select_num('company_show', array('picurl' => array('<>', ''), 'status' => '1')); if ($comshow > 0) { $msgNum += $comshow; $arr['comshow'] = $comshow; } //待审核企业横幅 $combanner = $this->select_num('banner', array('pic' => array('<>', ''), 'status' => '1')); if ($combanner > 0) { $msgNum += $combanner; $arr['combanner'] = $combanner; } //待审核企业产品 $company_product = $this->select_num('company_product', array('status' => '0')); if ($company_product > 0) { $msgNum += $company_product; $arr['company_product'] = $company_product; } //待审核发票 $invoice = $this->select_num('invoice_record', array('status' => '0')); if ($invoice > 0) { $msgNum += $invoice; $arr['invoiceNum'] = $invoice; } //待审核企业新闻 $company_news = $this->select_num('company_news', array('status' => '0')); if ($company_news > 0) { $msgNum += $company_news; $arr['company_news']= $company_news; } //待审核个人 $user = $this->select_num('resume', array('r_status' => '0')); if ($user > 0) { $msgNum += $user; $arr['userNum'] = $user; } //待审核简历 $resume_expect = $this->select_num('resume_expect', array('state' => '0')); if ($resume_expect > 0) { $msgNum += $resume_expect; $arr['resume_expect'] = $resume_expect; } //待审核委托简历 $resumetrust = $this->select_num('user_entrust', array('status' => '0')); if ($resumetrust > 0) { $msgNum += $resumetrust; $arr['resumetrust'] = $resumetrust; } //错误日志 $errlog = $this->select_num('error_log', array('isread' => 0)); if ($errlog > 0) { $msgNum += $errlog; $arr['errlog'] = $errlog; } //待审核网络招聘会报名 $zphnetcomtrust = $this->select_num('zphnet_com', array('status' => '0')); if ($zphnetcomtrust > 0) { $msgNum += $zphnetcomtrust; $arr['zphnetcomtrust'] = $zphnetcomtrust; } //待审核优质简历 $heightuser = $this->select_num('resume_expect', array('height_status' => '1')); if ($heightuser > 0) { $msgNum += $heightuser; $arr['ltheightuser'] = $heightuser; } //待审核个人认证 $usercertNum = $this->select_num('resume', array('idcard_pic' => array('<>', ''), 'idcard_status' => '0')); if ($usercertNum > 0) { $msgNum += $usercertNum; $arr['usercertNum'] = $usercertNum; } //待审核猎头 $lt = $this->select_num('lt_info', array('r_status' => '0')); if ($lt > 0) { $msgNum += $lt; $arr['ltNum'] = $lt; } //待审核猎头认证 $ltcert_n = $this->select_all('lt_info'); $ltcertuids = array(); foreach ($ltcert_n as $val) { $ltcertuids[] = $val['uid']; } $ltcert = $this->select_num('company_cert', array('type' => '4', 'status' => '0', 'uid' => array('in', pylode(',', $ltcertuids)))); if ($ltcert > 0) { $msgNum += $ltcert; $arr['ltcert'] = $ltcert; } //待审核猎头职位 $lt_job = $this->select_num('lt_job', array('status' => '0')); if ($lt_job > 0) { $msgNum += $lt_job; $arr['ltjob'] = $lt_job; } //待审核猎头logo $ltlogo = $this->select_num('lt_info', array('photo_big' => array('<>', ''), 'photo_status' => '1')); if ($ltlogo > 0) { $msgNum += $ltlogo; $arr['ltlogo'] = $ltlogo; } //待审核培训 $train = $this->select_num('px_train', array('r_status' => '0')); if ($train > 0) { $msgNum += $train; $arr['trainNum'] = $train; } //待审核培训讲师 $teacher = $this->select_num('px_teacher', array('status' => '0')); if ($teacher > 0) { $msgNum += $teacher; $arr['teacher'] = $teacher; } //待审核培训课程 $subject = $this->select_num('px_subject', array('status' => '0')); if ($subject > 0) { $msgNum += $subject; $arr['subject'] = $subject; } //待审核培训认证 $traincert_n = $this->select_all('px_train'); $traincertuids = array(); foreach ($traincert_n as $val) { $traincertuids[] = $val['uid']; } $traincert = $this->select_num('company_cert', array('type' => '5', 'status' => '0', 'uid' => array('in', pylode(',', $traincertuids)))); if ($traincert > 0) { $msgNum += $traincert; $arr['traincert'] = $traincert; } //待审核培训新闻 $trainnews = $this->select_num('px_train_news', array('status' => '0')); if ($trainnews > 0) { $msgNum += $trainnews; $arr['trainnews'] = $trainnews; } //待审核培训logo $pxlogo = $this->select_num('px_train', array('logo' => array('<>', ''), 'logo_status' => '1')); if ($pxlogo > 0) { $msgNum += $pxlogo; $arr['pxlogo'] = $pxlogo; } //待审核培训环境 $pxshow = $this->select_num('px_train_show', array('picurl' => array('<>', ''), 'status' => '1')); if ($pxshow > 0) { $msgNum += $pxshow; $arr['pxshow'] = $pxshow; } //待审核培训横幅 $pxbanner = $this->select_num('px_banner', array('pic' => array('<>', ''), 'status' => '1')); if ($pxbanner > 0) { $msgNum += $pxbanner; $arr['pxbanner'] = $pxbanner; } //会员申诉 $appealnum = $this->select_num('member', array('appealtime' => array('>', '0'), 'appealstate' => '1')); if ($appealnum > 0) { if (!$this->config['did'] || $this->config['did'] == 0) { $msgNum += $appealnum; } $arr['appealnum'] = $appealnum; } //待审核店铺招聘 $once_job = $this->select_num('once_job', array('status' => '0', 'edate' => array('>', time()))); if ($once_job > 0) { $msgNum += $once_job; $arr['once_job'] = $once_job; } //待审核普工简历 $tiny = $this->select_num('resume_tiny', array('status' => '0')); if ($tiny > 0) { $msgNum += $tiny; $arr['tiny'] = $tiny; } //待审核赏金提现 $withdrawNum = $this->select_num('member_withdraw', array('order_state' => '0')); if ($withdrawNum > 0) { $msgNum += $withdrawNum; $arr['withdrawNum'] = $withdrawNum; } //待审核应届毕业生职位 $schooljob = $this->select_num('company_job', array('is_graduate' => '1', 'state' => '0')); if ($schooljob > 0) { $msgNum += $schooljob; $arr['schooljob'] = $schooljob; } //待审核宣讲会 $schoolxjh = $this->select_num('school_xjh', array('status' => '0')); if ($schoolxjh > 0) { $msgNum += $schoolxjh; $arr['schoolxjh'] = $schoolxjh; } //待审核参会企业 $zphcom = $this->select_num('zhaopinhui_com', array('status' => '0')); if ($zphcom > 0) { $msgNum += $zphcom; $arr['zphcom'] = $zphcom; } //待审核问答 $ask = $this->select_num('question', array('state' => '0')); if ($ask > 0) { $msgNum += $ask; $arr['ask'] = $ask; } //待付款订单 $order = $this->select_num('company_order', array('order_state' => '1')); if ($order > 0) { $msgNum += $order; $arr['order'] = $order; } //待确认授课订单 $adorder = $this->select_num('ad_order', array('status' => '0')); if ($adorder > 0) { $msgNum += $adorder; $arr['adorder'] = $adorder; } //待处理举报职位 $rjwhere['usertype'] = 1; $rjwhere['type'] = 0; $rjwhere['status'] = 0; $rjwhere['PHPYUNBTWSTART'] = ''; $rjwhere['result'][] = array('=', ''); $rjwhere['result'][] = array('isnull', '', 'OR'); $rjwhere['PHPYUNBTWEND'] = ''; $reportjob = $this->select_num('report', $rjwhere); if ($reportjob > 0) { $msgNum += $reportjob; $arr['reportjob'] = $reportjob; } //待处理举报简历 $rrwhere['usertype'] = 2; $rrwhere['type'] = 0; $rrwhere['status'] = 0; $rrwhere['PHPYUNBTWSTART'] = ''; $rrwhere['result'][] = array('=', ''); $rrwhere['result'][] = array('isnull', '', 'OR'); $rrwhere['PHPYUNBTWEND'] = ''; $reportresume = $this->select_num('report', $rrwhere); if ($reportresume > 0) { $msgNum += $reportresume; $arr['reportresume'] = $reportresume; } //待处理举报问答 $rtwhere['status'] = 0; $rtwhere['type'] = 1; $rtwhere['status'] = 0; $rtwhere['PHPYUNBTWSTART'] = ''; $rtwhere['result'][] = array('=', ''); $rtwhere['result'][] = array('isnull', '', 'OR'); $rtwhere['PHPYUNBTWEND'] = ''; $reportask = $this->select_num('report', $rtwhere); if ($reportask > 0) { $msgNum += $reportask; $arr['reportask'] = $reportask; } //待处理举报顾问 $rgwhere['status'] = 0; $rgwhere['type'] = 2; $rgwhere['status'] = 0; $rgwhere['PHPYUNBTWSTART'] = ''; $rgwhere['result'][] = array('=', ''); $rgwhere['result'][] = array('isnull', '', 'OR'); $rgwhere['PHPYUNBTWEND'] = ''; $reportgw = $this->select_num('report', $rgwhere); if ($reportgw > 0) { $msgNum += $reportgw; $arr['reportgw'] = $reportgw; } // 待处理纠错宣讲会 $rxwhere['status'] = 0; $rxwhere['type'] = 3; $rxwhere['status'] = 0; $rxwhere['PHPYUNBTWSTART'] = ''; $rxwhere['result'][] = array('=', ''); $rxwhere['result'][] = array('isnull', '', 'OR'); $rxwhere['PHPYUNBTWEND'] = ''; $reportxjh = $this->select_num('report', $rxwhere); if ($reportxjh > 0) { $msgNum += $reportxjh; $arr['reportxjh'] = $reportxjh; } //待审核个人头像 $userpic = $this->select_num('resume', array('photo' => array('<>', ''),'defphoto'=>1,'photo_status' => '1')); if ($userpic > 0) { $msgNum += $userpic; $arr['userpic'] = $userpic; } //待审核个人作品 $usershow = $this->select_num('resume_show', array('picurl' => array('<>', ''), 'status' => '1')); if ($usershow > 0) { $msgNum += $usershow; $arr['usershow'] = $usershow; } //待审核供求会员 $gq_u = $this->select_all('member', array('status' => '0', 'usertype' => '5')); $gquids = array(); foreach ($gq_u as $val) { $gquids[] = $val['uid']; } $gqinfo = $this->select_num('gq_info', array('uid' => array('in', pylode(',', $gquids)))); if ($gqinfo > 0) { $msgNum += $gqinfo; $arr['gqNum'] = $gqinfo; } //待审核供求头像 $gqpic = $this->select_num('gq_info', array('photo' => array('<>', ''), 'photo_status' => '1')); if ($gqpic > 0) { $msgNum += $gqpic; $arr['gqpic'] = $gqpic; } //待审核项目任务 $gqtask = $this->select_num('gq_task', array('status' => '0')); if ($gqtask > 0) { $msgNum += $gqtask; $arr['gqtask'] = $gqtask; } if (!$this->config['did']) { //待审核友情链接 $linkNum = $this->select_num('admin_link', array('link_state' => '0')); if ($linkNum > 0) { $msgNum += $linkNum; $arr['linkNum'] = $linkNum; } //待审核商品兑换 $redeem = $this->select_num('change', array('status' => '0')); if ($redeem > 0) { $msgNum += $redeem; $arr['redeem'] = $redeem; } //待付款订单 $specialcom = $this->select_num('special_com', array('status' => '0')); if ($specialcom > 0) { $msgNum += $specialcom; $arr['specialcom'] = $specialcom; } //待审核转换申请 $userchangenum = $this->select_num('user_change', array('status' => '0')); if ($userchangenum > 0) { $msgNum += $userchangenum; $arr['userchangenum'] = $userchangenum; } //待处理意见反馈 $handlenum = $this->select_num('advice_question', array('status' => '1')); if ($handlenum > 0) { $msgNum += $handlenum; $arr['handlenum'] = $handlenum; } } //待处理注销账号 $logout = $this->select_num('member_logout', array('status' => 1)); if ($logout > 0) { $msgNum += $logout; $arr['logout'] = $logout; } //待审核视频面试 $spview = $this->select_num('spview', array('status' => 0)); if ($spview > 0) { $msgNum += $spview; $arr['spview'] = $spview; } //待审核面试评价 $company_msg = $this->select_num('company_msg', array('status' => 0)); if ($company_msg > 0) { $msgNum += $company_msg; $arr['company_msg'] = $company_msg; } //待审核面试模板 $yqmb_msg = $this->select_num('yqmb', array('status' => 0)); if ($yqmb_msg > 0) { $msgNum += $yqmb_msg; $arr['yqmb_msg'] = $yqmb_msg; } //待审核求职咨询 $usermsg_msg = $this->select_num('msg', array('status' => 0)); if ($usermsg_msg > 0) { $msgNum += $usermsg_msg; $arr['usermsg_msg'] = $usermsg_msg; } //待审核问答回复 $answer_msg = $this->select_num('answer', array('status' => 0)); if ($answer_msg > 0) { $msgNum += $answer_msg; $arr['answer_msg'] = $answer_msg; } //待审核问答评价 $answerreview_msg = $this->select_num('answer_review', array('status' => 0)); if ($answerreview_msg > 0) { $msgNum += $answerreview_msg; $arr['answerreview_msg']= $answerreview_msg; } //待处理内容检测 $concheck_msg = $this->select_num('concheck_log', array('status' => 0)); if ($concheck_msg > 0) { $msgNum += $concheck_msg; $arr['concheck_msg']= $concheck_msg; } if (!empty($this->config['sy_chat_open']) && $this->config['sy_chat_open'] == 1) { // 未读聊天条数 // 根据后台设置聊天记录查询日期时限来查询 $day = !empty($this->config['sy_chat_day']) ? $this->config['sy_chat_day'] : 30; $time = strtotime('-' . $day . ' day') * 1000; $chatNum = $this->select_num('chat_log', array('to' => $_SESSION['auid'], 'tusertype' => 9, 'status' => 2, 'sendTime' => array('>', $time))); if ($chatNum > 0) { $arr['chatNum'] = $chatNum; } } $arr['msgNum'] = $msgNum; return json_encode($arr); } function companyNum() { $arr = array(); //企业总数 $companyAllNum = $this->select_num('company'); if ($companyAllNum > 0) { $arr['companyAllNum'] = $companyAllNum; } //待审核企业 $companyStatusNum1 = $this->select_num('company', array('r_status' => '0')); if ($companyStatusNum1 > 0) { $arr['companyStatusNum1'] = $companyStatusNum1; } //未通过企业 $companyStatusNum2 = $this->select_num('company', array('r_status' => '3')); if ($companyStatusNum2 > 0) { $arr['companyStatusNum2'] = $companyStatusNum2; } //锁定企业 $companyStatusNum3 = $this->select_num('company', array('r_status' => '2')); if ($companyStatusNum3 > 0) { $arr['companyStatusNum3'] = $companyStatusNum3; } return json_encode($arr); } function hotNum() { $arr = array(); //名企总数 $hotAllNum = $this->select_num('hotjob'); if ($hotAllNum > 0) { $arr['hotAllNum'] = $hotAllNum; } //已过期名企 $hoted = $this->select_num('hotjob', array('time_end' => array('<=', time()))); if ($hoted > 0) { $arr['hoted'] = $hoted; } return json_encode($arr); } function comCertNum() { $arr = array(); //企业认证总数 $comCertAll = $this->select_num('company_cert', array('type' => '3')); if ($comCertAll > 0) { $arr['comCertAll'] = $comCertAll; } //未审核企业认证 $comCert1 = $this->select_num('company_cert', array('type' => '3', 'status' => '0')); if ($comCert1 > 0) { $arr['comCert1'] = $comCert1; } //未通过认证 $comCert2 = $this->select_num('company_cert', array('type' => '3', 'status' => '2')); if ($comCert2 > 0) { $arr['comCert2'] = $comCert2; } return json_encode($arr); } function jobNum() { $arr = array(); //职位总数 $jobAllNum = $this->select_num('company_job'); if ($jobAllNum > 0) { $arr['jobAllNum'] = $jobAllNum; } //待审核职位 $jobStatusNum1 = $this->select_num('company_job', array('state' => '0')); if ($jobStatusNum1 > 0) { $arr['jobStatusNum1'] = $jobStatusNum1; } // 未通过职位 $jobStatusNum2 = $this->select_num('company_job', array('state' => '3')); if ($jobStatusNum2 > 0) { $arr['jobStatusNum2'] = $jobStatusNum2; } //下架职位 $jobStatusNum3 = $this->select_num('company_job', array('status' => '1')); if ($jobStatusNum3 > 0) { $arr['jobStatusNum3'] = $jobStatusNum3; } return json_encode($arr); } function partNum() { $arr = array(); //兼职总数 $partAllNum = $this->select_num('partjob'); if ($partAllNum > 0) { $arr['partAllNum'] = $partAllNum; } //待审核兼职 $partStatusNum1 = $this->select_num('partjob', array('state' => '0')); if ($partStatusNum1 > 0) { $arr['partStatusNum1'] = $partStatusNum1; } //未通过兼职 $partStatusNum2 = $this->select_num('partjob', array('state' => '3')); if ($partStatusNum2 > 0) { $arr['partStatusNum2'] = $partStatusNum2; } //已过期兼职 $ewhere = array( 'PHPYUNBTWSTART_A' => '', 'edate' => array( '0' => array('<', time(), 'AND'), '1' => array('>', '0', 'AND') ), 'PHPYUNBTWEND_A' => '', ); $partStatusNum3 = $this->select_num('partjob', $ewhere); if ($partStatusNum3 > 0) { $arr['partStatusNum3'] = $partStatusNum3; } return json_encode($arr); } function orderSum($where=array()) { $order_state_where = isset($where['order_state'])?$where['order_state']:''; unset($where['order_state']); if($order_state_where!=''){ $where['order_state'][]= array('=',$order_state_where); } $arr = array(); //订单总额 $where1 = $where; $where1['order_price'] = array('>','0'); $orderAll = $this->select_once('company_order',$where1, 'sum(`order_price`) as `pricesum`'); if ($orderAll['pricesum'] > 0) { $arr['orderPriceAll'] = $orderAll['pricesum']; } //已支付金额 $where2 = $where; $where2['order_price'] = array('>','0'); $where2['order_state'][] = array('=',2,'and'); $orderPayed = $this->select_once('company_order',$where2, 'sum(`order_price`) as `orderPayed`'); if ($orderPayed['orderPayed'] > 0) { $arr['orderPayed'] = $orderPayed['orderPayed']; } //待支付金额 $where3 = $where; $where3['order_price'] = array('>','0'); $where3['order_state'][] = array('=',1,'and'); $orderPay = $this->select_once('company_order',$where3, 'sum(`order_price`) as `orderPay`'); if ($orderPay['orderPay'] > 0) { $arr['orderPay'] = $orderPay['orderPay']; } //等待确认金额 $where4 = $where; $where4['order_price'] = array('>','0'); $where4['order_state'][] = array('=',3,'and'); $orderPaying = $this->select_once('company_order',$where4, 'sum(`order_price`) as `orderPaying`'); if ($orderPaying['orderPaying'] > 0) { $arr['orderPaying'] = $orderPaying['orderPaying']; } return json_encode($arr); } function userNum() { $arr = array(); //个人总数 $userAllNum = $this->select_num('resume'); if ($userAllNum > 0) { $arr['userAllNum'] = $userAllNum; } //待审核个人 $userStatusNum1 = $this->select_num('resume', array('r_status' => '0')); if ($userStatusNum1 > 0) { $arr['userStatusNum1'] = $userStatusNum1; } //未通过个人 $userStatusNum2 = $this->select_num('resume', array('r_status' => '3')); if ($userStatusNum2 > 0) { $arr['userStatusNum2'] = $userStatusNum2; } //锁定个人 $userStatusNum3 = $this->select_num('resume', array('r_status' => '2')); if ($userStatusNum3 > 0) { $arr['userStatusNum3'] = $userStatusNum3; } return json_encode($arr); } function gqNum() { $arr = array(); //供求总数 $gqAllNum = $this->select_num('gq_info', array('state' => 1)); if ($gqAllNum > 0) { $arr['gqAllNum'] = $gqAllNum; } //待审核供求 $gqStatusNum1 = $this->select_num('gq_info', array('status' => '0', 'state' => '1')); if ($gqStatusNum1 > 0) { $arr['gqStatusNum1'] = $gqStatusNum1; } //未通过供求 $gqStatusNum2 = $this->select_num('gq_info', array('status' => '3', 'state' => '1')); if ($gqStatusNum2 > 0) { $arr['gqStatusNum2'] = $gqStatusNum2; } //锁定供求 $gqStatusNum3 = $this->select_num('gq_info', array('r_status' => '2', 'state' => '1')); if ($gqStatusNum3 > 0) { $arr['gqStatusNum3'] = $gqStatusNum3; } return json_encode($arr); } function resumeNum() { $arr = array(); //简历总数 $resumeAllNum = $this->select_num('resume_expect'); if ($resumeAllNum > 0) { $arr['resumeAllNum'] = $resumeAllNum; } //待审核简历 $resumeStatusNum1 = $this->select_num('resume_expect', array('state' => '0')); if ($resumeStatusNum1 > 0) { $arr['resumeStatusNum1'] = $resumeStatusNum1; } //未通过简历 $resumeStatusNum2 = $this->select_num('resume_expect', array('state' => '3')); if ($resumeStatusNum2 > 0) { $arr['resumeStatusNum2'] = $resumeStatusNum2; } //锁定简历 $resumeStatusNum3 = $this->select_num('resume_expect', array('r_status' => '2')); if ($resumeStatusNum3 > 0) { $arr['resumeStatusNum3'] = $resumeStatusNum3; } //未成年 $datetime=strtotime('-16 years'); $resumeTeenNum = $this->select_num('resume_expect', array('birthday' => array('unixtime','>',$datetime))); if ($resumeTeenNum > 0) { $arr['resumeTeenNum'] = $resumeTeenNum; } return json_encode($arr); } function idCardNum() { $arr = array(); //个人认证总数 $idCardAll = $this->select_num('resume', array('idcard_pic' => array('<>', ''), 'idcard_status' => '1')); if ($idCardAll > 0) { $arr['idCardAll'] = $idCardAll; } //未审核个人认证 $idCardNum1 = $this->select_num('resume', array('idcard_pic' => array('<>', ''), 'idcard_status' => '0')); if ($idCardNum1 > 0) { $arr['idCardNum1'] = $idCardNum1; } //未通过身份认证 $idCardNum2 = $this->select_num('resume', array('idcard_pic' => array('<>', ''), 'idcard_status' => '2')); if ($idCardNum2 > 0) { $arr['idCardNum2'] = $idCardNum2; } return json_encode($arr); } function trustNum() { $arr = array(); //简历总数 $resumeAllNum = $this->select_num('user_entrust'); if ($resumeAllNum > 0) { $arr['resumeAllNum'] = $resumeAllNum; } //待审核委托 $resumeStatusNum1 = $this->select_num('user_entrust', array('status' => '0')); if ($resumeStatusNum1 > 0) { $arr['resumeStatusNum1'] = $resumeStatusNum1; } //未接受委托 $resumeStatusNum2 = $this->select_num('user_entrust', array('status' => '2')); if ($resumeStatusNum2 > 0) { $arr['resumeStatusNum2'] = $resumeStatusNum2; } return json_encode($arr); } function ltNum() { $arr = array(); //lt会员总数 $ltAllNum = $this->select_num('lt_info'); if ($ltAllNum > 0) { $arr['ltAllNum'] = $ltAllNum; } //待审核猎头会员 $ltStatusNum1 = $this->select_num('lt_info', array('r_status' => '0')); if ($ltStatusNum1 > 0) { $arr['ltStatusNum1'] = $ltStatusNum1; } //未通过猎头会员 $ltStatusNum2 = $this->select_num('lt_info', array('r_status' => '3')); if ($ltStatusNum2 > 0) { $arr['ltStatusNum2'] = $ltStatusNum2; } //锁定猎头会员 $ltStatusNum3 = $this->select_num('lt_info', array('r_status' => '2')); if ($ltStatusNum3 > 0) { $arr['ltStatusNum3'] = $ltStatusNum3; } return json_encode($arr); } function ltjobNum() { $arr = array(); //lt职位总数 $ltjobAllNum = $this->select_num('lt_job'); if ($ltjobAllNum > 0) { $arr['ltjobAllNum'] = $ltjobAllNum; } //待审核lt职位 $ltjobStatusNum1 = $this->select_num('lt_job', array('status' => '0')); if ($ltjobStatusNum1 > 0) { $arr['ltjobStatusNum1'] = $ltjobStatusNum1; } //未通过lt职位 $ltjobStatusNum2 = $this->select_num('lt_job', array('status' => '3')); if ($ltjobStatusNum2 > 0) { $arr['ltjobStatusNum2'] = $ltjobStatusNum2; } return json_encode($arr); } function gresumeNum() { $arr = array(); //优质人才简历总数 $resumeAllNum = $this->select_num('resume_expect', array('height_status' => array('<>', '0'))); if ($resumeAllNum > 0) { $arr['resumeAllNum'] = $resumeAllNum; } //待审核简历 $resumeStatusNum1 = $this->select_num('resume_expect', array('height_status' => '1')); if ($resumeStatusNum1 > 0) { $arr['resumeStatusNum1'] = $resumeStatusNum1; } //未通过简历 $resumeStatusNum2 = $this->select_num('resume_expect', array('height_status' => '3')); if ($resumeStatusNum2 > 0) { $arr['resumeStatusNum2'] = $resumeStatusNum2; } return json_encode($arr); } function ltcertNum() { $arr = array(); //lt认证总数 $ltCertAllNum = $this->select_num('company_cert', array('type' => '4')); if ($ltCertAllNum > 0) { $arr['ltCertAllNum'] = $ltCertAllNum; } //未审核lt认证 $ltcertStatusNum1 = $this->select_num('company_cert', array('type' => '4', 'status' => '0')); if ($ltcertStatusNum1 > 0) { $arr['ltcertStatusNum1'] = $ltcertStatusNum1; } //未通过认证 $ltcertStatusNum2 = $this->select_num('company_cert', array('type' => '4', 'status' => '2')); if ($ltcertStatusNum2 > 0) { $arr['ltcertStatusNum2'] = $ltcertStatusNum2; } return json_encode($arr); } function pxNum() { $arr = array(); //PX总数 $pxAllNum = $this->select_num('px_train'); if ($pxAllNum > 0) { $arr['pxAllNum'] = $pxAllNum; } //未审核培训机构 $pxStatusNum1 = $this->select_num('px_train', array('r_status' => '0')); if ($pxStatusNum1 > 0) { $arr['pxStatusNum1'] = $pxStatusNum1; } //未通过培训机构 $pxStatusNum2 = $this->select_num('px_train', array('r_status' => '3')); if ($pxStatusNum2 > 0) { $arr['pxStatusNum2'] = $pxStatusNum2; } //锁定培训机构 $pxStatusNum3 = $this->select_num('px_train', array('r_status' => '2')); if ($pxStatusNum3 > 0) { $arr['pxStatusNum3'] = $pxStatusNum3; } return json_encode($arr); } function teacherNum() { $arr = array(); //讲师总数 $teacherAllNum = $this->select_num('px_teacher'); if ($teacherAllNum > 0) { $arr['teacherAllNum'] = $teacherAllNum; } //未审核讲师 $teachStatusNum1 = $this->select_num('px_teacher', array('status' => '0')); if ($teachStatusNum1 > 0) { $arr['teachStatusNum1'] = $teachStatusNum1; } //未通过讲师 $teachStatusNum2 = $this->select_num('px_teacher', array('status' => '2')); if ($teachStatusNum2 > 0) { $arr['teachStatusNum2'] = $teachStatusNum2; } return json_encode($arr); } function subjectNum() { $arr = array(); //课程总数 $subjectAllNum = $this->select_num('px_subject'); if ($subjectAllNum > 0) { $arr['subjectAllNum'] = $subjectAllNum; } //未审核课程 $subjectStatusNum1 = $this->select_num('px_subject', array('status' => '0')); if ($subjectStatusNum1 > 0) { $arr['subjectStatusNum1'] = $subjectStatusNum1; } //未通过课程 $subjectStatusNum2 = $this->select_num('px_subject', array('status' => '2')); if ($subjectStatusNum2 > 0) { $arr['subjectStatusNum2'] = $subjectStatusNum2; } return json_encode($arr); } function pxcertNum() { $arr = array(); //px认证总数 $pxCertAllNum = $this->select_num('company_cert', array('type' => '5')); if ($pxCertAllNum > 0) { $arr['certAllNum'] = $pxCertAllNum; } //未审核px认证 $certStatusNum1 = $this->select_num('company_cert', array('type' => '5', 'status' => '0')); if ($certStatusNum1 > 0) { $arr['certStatusNum1'] = $certStatusNum1; } //未通过认证 $certStatusNum2 = $this->select_num('company_cert', array('type' => '5', 'status' => '2')); if ($certStatusNum2 > 0) { $arr['certStatusNum2'] = $certStatusNum2; } return json_encode($arr); } function onceNum() { $arr = array(); //店铺总数 $onceAllNum = $this->select_num('once_job'); if ($onceAllNum > 0) { $arr['onceAllNum'] = $onceAllNum; } //未审核 $onceStatusNum1 = $this->select_num('once_job', array('status' => '0', 'edate' => array('>', time()))); if ($onceStatusNum1 > 0) { $arr['onceStatusNum1'] = $onceStatusNum1; } //已过期 $onceStatusNum2 = $this->select_num('once_job', array('edate' => array('<', time()))); if ($onceStatusNum2 > 0) { $arr['onceStatusNum2'] = $onceStatusNum2; } return json_encode($arr); } function tinyNum() { $arr = array(); //普工总数 $tinyAllNum = $this->select_num('resume_tiny'); if ($tinyAllNum > 0) { $arr['tinyAllNum'] = $tinyAllNum; } //未审核 $tinyStatusNum = $this->select_num('resume_tiny', array('status' => '0')); if ($tinyStatusNum > 0) { $arr['tinyStatusNum'] = $tinyStatusNum; } return json_encode($arr); } function sjobNum() { $arr = array(); //应届生职位总数 $jobAllNum = $this->select_num('company_job', array('is_graduate' => '1')); if ($jobAllNum > 0) { $arr['jobAllNum'] = $jobAllNum; } //待审核职位 $jobStatusNum1 = $this->select_num('company_job', array('is_graduate' => '1', 'state' => '0')); if ($jobStatusNum1 > 0) { $arr['jobStatusNum1'] = $jobStatusNum1; } //未通过职位 $jobStatusNum2 = $this->select_num('company_job', array('is_graduate' => '1', 'state' => '3')); if ($jobStatusNum2 > 0) { $arr['jobStatusNum2'] = $jobStatusNum2; } //下架职位 $jobStatusNum3 = $this->select_num('company_job', array('is_graduate' => '1', 'status' => '1')); if ($jobStatusNum3 > 0) { $arr['jobStatusNum3'] = $jobStatusNum3; } return json_encode($arr); } function xjhNum() { $arr = array(); //宣讲会总数 $xjhAllNum = $this->select_num('school_xjh'); if ($xjhAllNum > 0) { $arr['xjhAllNum'] = $xjhAllNum; } //待审核宣讲会 $xjhStatusNum1 = $this->select_num('school_xjh', array('status' => '0')); if ($xjhStatusNum1 > 0) { $arr['xjhStatusNum1'] = $xjhStatusNum1; } //未通过宣讲会 $xjhStatusNum2 = $this->select_num('school_xjh', array('status' => '2')); if ($xjhStatusNum2 > 0) { $arr['xjhStatusNum2'] = $xjhStatusNum2; } //待举办宣讲会 $xjhStateNum1 = $this->select_num('school_xjh', array('stime' => array('>', time()))); if ($xjhStateNum1 > 0) { $arr['xjhStateNum1'] = $xjhStateNum1; } //已结束宣讲会 $xjhStateNum2 = $this->select_num('school_xjh', array('etime' => array('<', time()))); if ($xjhStateNum2 > 0) { $arr['xjhStateNum2'] = $xjhStateNum2; } return json_encode($arr); } function taskNum() { $arr = array(); //供求任务总数 $taskAllNum = $this->select_num('gq_task'); if ($taskAllNum > 0) { $arr['taskAllNum'] = $taskAllNum; } //待审核供求任务 $taskStatusNum1 = $this->select_num('gq_task', array('status' => '0')); if ($taskStatusNum1 > 0) { $arr['taskStatusNum1'] = $taskStatusNum1; } //未通过供求任务 $taskStatusNum2 = $this->select_num('gq_task', array('status' => '2')); if ($taskStatusNum2 > 0) { $arr['taskStatusNum2'] = $taskStatusNum2; } //已过期供求任务 $taskStatusNum3 = $this->select_num('gq_task', array('etime' => array('<', time()))); if ($taskStatusNum3 > 0) { $arr['taskStatusNum3'] = $taskStatusNum3; } return json_encode($arr); } function memNum() { $arr = array(); //会员总数 $memAllNum = $this->select_num('member'); if ($memAllNum > 0) { $arr['memAllNum'] = $memAllNum; } //子账户总数 $memAllNum1 = $this->select_num('company_account'); if ($memAllNum1 > 0) { $arr['memAllNum1'] = $memAllNum1; } //待审核会员 $memStatusNum1 = $this->select_num('member', array('status' => '0')); if ($memStatusNum1 > 0) { $arr['memStatusNum1'] = $memStatusNum1; } //未通过会员 $memStatusNum2 = $this->select_num('member', array('status' => '3')); if ($memStatusNum2 > 0) { $arr['memStatusNum2'] = $memStatusNum2; } //锁定会员 $memStatusNum3 = $this->select_num('member', array('status' => '2')); if ($memStatusNum3 > 0) { $arr['memStatusNum3'] = $memStatusNum3; } //锁定子账户 $rows = $this->select_all('company_account', '`uid`'); $uids = array(); foreach ($rows as $v) { $uids[] = $v['uid']; } $memStatusNum4 = $this->select_num('member', array('status' => '2', 'uid' => array('in', pylode(',', $uids)))); if ($memStatusNum4 > 0) { $arr['memStatusNum4'] = $memStatusNum4; } return json_encode($arr); } function memchangeNum() { $arr = array(); //供求任务总数 $memAllNum = $this->select_num('user_change'); if ($memAllNum > 0) { $arr['memAllNum'] = $memAllNum; } //已拒绝申请 $memStatusNum3 = $this->select_num('user_change', array('status' => '0')); if ($memStatusNum3 > 0) { $arr['memStatusNum3'] = $memStatusNum3; } return json_encode($arr); } function helpSum() { $arr = array(); include(CONFIG_PATH . "db.data.php"); //任务总数 $helpAll = $this->select_num('friend_help'); //助力总数 $logAll = $this->select_num('friend_help_log'); //已发权益 //$logAll = $this -> select_num('friend_help_log'); $receiveAll = $this->select_all('friend_help_receive', array('groupby' => 'name'), '`name`,sum(`num`) as `receivenum`'); if (!empty($receiveAll) && isset($arr_data)) { $html = array(); foreach ($receiveAll as $key => $value) { $html[] = $arr_data['helpconfig'][$value['name']]['name'] . ':' . $value['receivenum']; } } $arr['helpall'] = $helpAll > 0 ? $helpAll : 0; $arr['logall'] = $logAll > 0 ? $logAll : 0; $arr['receiveall'] = @implode(',', $html); return json_encode($arr); } } ?>