select_once('member', array('uid' => $uid),'`usertype`'); if($member['usertype'] == 2){ $row = $this -> select_once('company_statis', array('rating_type'=>2,'uid'=>$uid), 'uid, `rating`'); }else if ($member['usertype'] == 3){ $row = $this -> select_once('lt_statis', array('rating_type'=>2,'uid'=>$uid), 'uid, `rating`'); } if(isset($row['uid']) && $row['uid'] > 0){ return $row['rating']; } return false; } //时间套餐企业会员，每天操作次数是否超量检查 public function comVipDayActionCheck($type,$uid) { //时间会员等级id $ratingId = $this->_isComVipDayActionNeedCheck($uid); //如果不需要限制每日最大操作次数，则直接可以进行操作 if(!$ratingId){ return array('status' => 1); } //各操作项每日最大操作次数配置字段 $typeMapping = array( 'jobnum' => 'job_num',//发布职位 'resume' => 'resume',//下载（查看联系方式）简历 'interview' => 'interview',//邀请面试 'refreshjob' => 'breakjob_num',//刷新职位 'zph' => 'zph_num',//报名招聘会 'zphnet' => 'zph_num', 'spview' => 'spview_num', 'chat' => 'chat_num' ); if(!isset($typeMapping[$type])){ return array('status' => -1, 'msg' => '函数参数错误'); } $field = $typeMapping[$type]; //如果该配置为0，则不限操作次数 $row = $this->select_once('company_rating', array('id' => $ratingId), '`' . $field . '`,`name`'); if(!isset($row[$field]) || $row[$field] == 0){ return array('status' => 1); } $dayMaxNum = $row[$field]; $currentNum = 0; $today = strtotime('today'); switch($type){ case 'jobnum'://发布职位 $currentNum1 = $this->select_num('company_job',array('uid'=>$uid,'sdate'=>array('>=',$today))); $currentNum2 = $this->select_num('partjob',array('uid'=>$uid,'addtime'=>array('>=',$today))); $currentNum3 = $this->select_num('lt_job',array('uid'=>$uid,'lastupdate'=>array('>=',$today))); $currentNum4 = 0; if($this->config['upjob_jobnum']==1){ $joball = $this->select_all('company_job',array('uid'=>$uid,'upstatus_time'=>array('>=',$today)),'`id`,`upstatus_count`,`upstatus_time`'); if(!empty($joball)){ foreach ($joball as $jk => $jv) { $currentNum4 += $jv['upstatus_count']; } } } $currentNum = $currentNum1+$currentNum2+$currentNum3+$currentNum4; break; case 'resume'://查看（下载）简历 $currentNum = $this->select_num('down_resume',array('comid'=>$uid,'downtime'=>array('>=',$today))); break; case 'interview'://邀请面试 $currentNum = $this->select_num('userid_msg',array('fid'=>$uid,'datetime'=>array('>=',$today))); break; case 'refreshjob': $jobSxLog = $this->select_all('member_log', array('uid' => $uid, 'ctime' => array('>=', $today),'opera'=>'1', 'type'=>'4'),'`jobnum`'); if (!empty($jobSxLog)) { $currentNum1 = 0; foreach ($jobSxLog as $v){ if ($v['jobnum']) { $currentNum1 = $currentNum1 + $v['jobnum']; } } } $partSxLog = $this->select_all('member_log', array('uid' => $uid, 'ctime' => array('>=', $today),'opera'=>'9', 'type'=>'4'),'`jobnum`'); if (!empty($partSxLog)) { $currentNum2 = 0; foreach ($partSxLog as $v){ if ($v['jobnum']) { $currentNum2 = $currentNum2 + $v['jobnum']; } } } $ltJobSxLog = $this->select_all('member_log', array('uid' => $uid, 'ctime' => array('>=', $today),'opera'=>'10', 'type'=>'4'),'`jobnum`'); if (!empty($ltJobSxLog)) { $currentNum3 = 0; foreach ($ltJobSxLog as $v){ if ($v['jobnum']) { $currentNum3 = $currentNum3 + $v['jobnum']; } } } $currentNum = $currentNum1+$currentNum2+$currentNum3; break; case 'zph'://招聘会流程有待优化 $currentNum = $this->select_num('zhopinhui_com',array('uid' => $uid, 'ctime' => array('>=' , $today))); break; //网络招聘会 case 'zphnet': $currentNum = $this->select_num('zphnet_com',array('uid' => $uid, 'ctime' => array('>=' , $today))); break; case 'spview': $currentNum = $this->select_num('spview',array('uid' => $uid, 'ctime' => array('>=' , $today))); break; case 'chat': $currentNum = $this->select_num('chat_right', array('comid' => $uid, 'ctime' => array('>=', $today))); break; } $typeMsgMapping = array( 'jobnum' => $this->config['upjob_jobnum']==1?'发布或上架职位':'发布职位',//发布职位 'resume' => '下载简历（查看联系方式）',//下载（查看联系方式）简历 'interview' => '邀请面试',//邀请面试 'refreshjob' => '刷新职位',//刷新职位 'zph' => '报名招聘会',//报名招聘会 'zphnet' => '报名网络招聘会',//报名网络招聘会 'spview' => '发布视频面试',//发布视频面试 'chat' => $this->config['sy_chat_name'], 'sons' => '添加子账号' ); $msg = $row['name'].'每天最多'.$typeMsgMapping[$type].$dayMaxNum.' 次'; $num = $dayMaxNum - $currentNum; if($type == 'refreshjob'){ return $currentNum < $dayMaxNum ? array('status' => 1, 'sxnum' => $num) : array('status' => -1, 'msg' => $msg); }else{ return $currentNum < $dayMaxNum ? array('status' => 1,'restnum'=>$num) : array('status' => -1, 'msg' => $msg); } } /* =================================以下为 phpyun5.0 新增========================================= */ /** * @desc 引用log类，添加用户日志 * * @param int $uid * @param int $usertype * @param string $content * @param string $opera * @param string $type * @return boolean */ private function addMemberLog($uid, $usertype, $content, $opera = '', $type = '') { require_once ('log.model.php'); $LogM = new log_model($this->db, $this->def); return $LogM->addMemberLog($uid, $usertype, $content, $opera, $type); } /** * @desc 引用 integral类，获取积分 * * @param int $uid * @param string $type config 配置积分调用参数 * @param string $msg 备注说明：获取积分途径 */ private function getIntegral($uid,$usertype, $type, $msg) { require_once 'integral.model.php'; $IntegralM = new integral_model($this->db, $this->def); return $IntegralM->invtalCheck($uid,$usertype, $type, $msg); } /** * @desc 获取缓存数据 * * @param array $options * @return array $cache */ private function getClass($options) { include_once ('cache.model.php'); $cacheM = new cache_model($this->db, $this->def); $cache = $cacheM -> GetCache($options); return $cache; } /** * @desc 查询企业数目 company */ public function getCompanyNum($whereData = array()) { return $this -> select_num('company', $whereData); } /** * 非uid条件查询企业基本信息 */ public function getCompanyInfo($whereData = array(),$data = array('field'=>'')) { $field = !empty($data['field']) ? $data['field'] : '*'; return $this -> select_once('company', $whereData, $field); } /** * @desc 企业基本信息 * * @param int $uid * @param array $data ('edit':后台修改企业 'info':PC企业会员中心,'wxapp':wxapp小程序, 'logo'：图片预处理) */ public function getInfo($uid, $data = array('field'=>'','utype'=>'','logo'=>'', 'hb' => '')) { if (!empty($uid)) { $select = !empty($data['field']) ? $data['field'] : '*'; $uid = intval($uid); $ComInfo = $this -> select_once('company', array('uid'=>$uid), $select); $cache = $this -> getClass(array('hy','city','com', 'crm')); if($ComInfo && is_array($ComInfo)){ if($ComInfo['hotstart']<=time() && $ComInfo['hottime']>=time()){ $ComInfo['hotlogo'] = 1; } if($data['setname'] == 1 || $data['crm'] == 1){ require_once ('userinfo.model.php'); $UserinfoM = new userinfo_model($this->db, $this->def); $info = $UserinfoM -> getInfo(array('uid'=> $uid),array('setname'=>'1')); } if (!empty($info) && is_array($info)) { $ComInfo['setname'] = $info['setname']=='1'?1:0; if ($data['crm'] == 1) { $auid = $data['auid'] ? intval($data['auid']) : ''; $ComInfo['username'] = $info['username']; $ComInfo['usertype'] = $info['usertype']; $ComInfo['reg_date'] = $info['reg_date']; $ComInfo['lastupdate_day'] = $info['login_date']?format_datetime($info['login_date'], 2, 1, ''):'未登录'; $ComInfo['crm_status_n'] = $cache['crmclass_name'][$ComInfo['crm_status']]; $ComInfo['crm_type_n'] = $ComInfo['crm_type'] ? $cache['crmclass_name'][$ComInfo['crm_type']] : "未标记等级"; $statisInfo = $this -> select_once('company_statis', array('uid' => $uid), '`integral`'); if (!empty($statisInfo) && is_array($statisInfo)) { $ComInfo['integral'] = $statisInfo['integral']; } // 在招职位 $jobNum = $this -> select_num('company_job', array('uid' => $uid, 'state' => 1, 'status' => 0)); $ComInfo['inJobNum'] = intval($jobNum); // 收到简历 $sqNum = $this->select_num('userid_job', array('com_id' => $uid)); $ComInfo['sqNum'] = intval($sqNum); // 未查看简历 $lookResumeNum = $this->select_num('userid_job', array('com_id' => $uid, 'isdel' => 9, 'is_browse' => 1)); $ComInfo['llNum'] = intval($lookResumeNum); // 转移查询 $isDelive = $this->select_num('crm_comlog', array('type' => 1, 'uid' => $uid, 'auid' => $auid)); $ComInfo['isDeliver'] = $isDelive; // 放弃查询 $isGiveUp = $this->select_num('crm_comlog', array('type' => 2, 'uid' => $uid, 'auid' => $auid)); $ComInfo['isGiveUp'] = $isGiveUp; // 今日跟进记录 $followInfo = $this->select_once('crmnew_concern', array('uid' => $uid, 'auid' => $auid, 'atime' => array('>', strtotime(date('Y-m-d'))), 'orderby'=>'atime,desc')); if(!empty($followInfo)){ /* 跟进时间 */ $followInfo['ftime_n'] = $followInfo['ftime'] ? $followInfo['ftime'] * 1000 : ($followInfo['atime'] - 300) * 1000; /* 计划时间 */ $followInfo['time_n'] = $followInfo['time'] ? $followInfo['time'] * 1000 : ''; $ComInfo['followInfo'] = $followInfo; } } } if($ComInfo['shortname'] && !empty($data['short'])){//企业名称显示成简称 $ComInfo['name'] = $ComInfo['shortname']; } if($ComInfo['provinceid']){ $ComInfo['job_city_one'] = $cache['city_name'][$ComInfo['provinceid']]; $ComInfo['citystr'] = $cache['city_name'][$ComInfo['provinceid']]; } if($ComInfo['cityid']){ $ComInfo['job_city_two'] = $cache['city_name'][$ComInfo['cityid']]; if (isset($ComInfo['citystr'])){ $ComInfo['citystr'] .= '-'.$cache['city_name'][$ComInfo['cityid']]; }else{ $ComInfo['citystr'] = $cache['city_name'][$ComInfo['cityid']]; } } if($ComInfo['three_cityid']){ $ComInfo['job_city_three'] = $cache['city_name'][$ComInfo['three_cityid']]; } if($ComInfo['hy']){ $ComInfo['hy_n'] = $cache['industry_name'][$ComInfo['hy']]; } if($ComInfo['pr']){ $ComInfo['pr_n'] = $cache['comclass_name'][$ComInfo['pr']]; } if($ComInfo['mun']){ $ComInfo['mun_n'] = $cache['comclass_name'][$ComInfo['mun']]; } if($ComInfo['lastupdate']){ $ComInfo['lastupdate_n'] = date('Y-m-d', $ComInfo['lastupdate']); } if($ComInfo['moneytype']){ $ComInfo['moneytype_n'] = $ComInfo['moneytype']==1 ? '万元':'万美元'; } if($data['utype']=='wxapp'){ $content = str_replace(array('"',' ','<
>'), array('','',''), $ComInfo['content']); $content = htmlspecialchars_decode($content); preg_match_all('',$content,$res); if(!empty($res[2])){ foreach($res[2] as $v){ if(strpos($v,'https:')===false && strpos($v,'http:')===false){ $imgurl = checkpic($v); $content = str_replace($v,$imgurl,$content); } } } $ComInfo['content'] = $content; $ComInfo['address_n'] = mb_substr($ComInfo['address'],0,20,"utf-8"); }else{ $ComInfo['content'] = str_replace(array('title','“','”'),array('title',' ',' '),$ComInfo['content']); } if ($data['logo']=='1') { //非企业用户查看||企业本身查看 if ( (!empty($ComInfo['logo']) && $ComInfo['logo_status']==0) || ($data['utype'] == 'user' && !empty($ComInfo['logo'])) || ($data['utype'] == 'admin' && !empty($ComInfo['logo']))){ $ComInfo['logo_n'] = $ComInfo['logo']; $ComInfo['logo'] = checkpic($ComInfo['logo']); }else{ $ComInfo['logo_n'] = $ComInfo['logo']; $ComInfo['logo'] = checkpic($this->config['sy_unit_icon']); } } if($ComInfo['crm_uid']){ $crminfo = $this -> select_once('admin_user', array('uid' => $ComInfo['crm_uid'])); $ComInfo['crm_name'] = $crminfo['name']; $ComInfo['aphone'] = $crminfo['moblie']; } //公司福利 if(!empty($ComInfo['welfare']) && $ComInfo['welfare'] !='undefined'){ $ComInfo['welfare_n'] = @explode(',',$ComInfo['welfare']); }else{ $ComInfo['welfare_n'] = ""; } /* 企业 - 修改 */ if (!empty($data['edit'])) { if ($ComInfo['welfare']){ $ComInfo['arraywelfare'] = explode(',', $ComInfo['welfare']); } $ComInfo['comqcode'] = checkpic($ComInfo['comqcode'] ); // 企业创建时间单位是年，要对以前的数据进行处理 if (!empty($ComInfo['sdate'])){ if (strlen($ComInfo['sdate']) > 4){ $sdate = explode('-',$ComInfo['sdate']); $ComInfo['sdate'] = $sdate[0]; } } } /* PC/WAP 企业会员中心 - 修改 */ if(!empty($data['info'])) { if (($ComInfo['x'] == '' || $ComInfo['y'] == '') && $ComInfo['address'] != ''){ $ComInfo['setmap'] = 1; }elseif ($ComInfo['x'] != '' && $ComInfo['y'] != ''){ $ComInfo['setmap'] = 2; }else{ $ComInfo['setmap'] = 3; } $tel = $this -> getCertInfo(array('uid'=>$uid, 'type'=>'2')); $cert = $this -> getCertInfo(array('uid'=>$uid, 'type'=>'3')); $ComInfo['info'] = $ComInfo; $ComInfo['tel'] = $tel; $ComInfo['cert'] = $cert; } }else{ $ComInfo['logo'] = checkpic($this->config['sy_unit_icon']); } $ComInfo['money'] = $ComInfo['money'] == '0' ? '' : $ComInfo['money']; return $ComInfo; } } public function getChCompanyList($whereData, $data = array()) { $select = $data['field'] ? $data['field'] : '*'; $ChCompanyList = $this -> select_all('company',$whereData, $select); return $ChCompanyList; } /** * @DESC 获取企业信息，多条查询 * * @param array $whereData * @param array $data[] from:wxapp小程序获取数据 */ public function getList( $whereData , $data=array('logo'=>null)) { $ListCom = array(); $select = isset($data['field']) ? $data['field'] : '*'; $List = $this -> select_all('company', $whereData, $select); if (!empty($List)) { $ListCom['list'] = $List; $options = array('hy','city','com'); $cache = $this -> getClass($options); if (isset($data['cache'])) { $ListCom['cache'] = $cache; } foreach ($List as $k => $v){ if(isset($v['provinceid'])){ $List[$k]['job_city_one'] = $cache['city_name'][$v['provinceid']]; $List[$k]['citystr'] = $cache['city_name'][$v['provinceid']]; } if(isset($v['cityid'])){ $citytwoStr = $cache['city_name'][$v['cityid']]; $List[$k]['job_city_two'] = $citytwoStr; if (!empty($citytwoStr)){ if (isset($List[$k]['citystr'])){ $List[$k]['citystr'] .= '-'.$citytwoStr; }else{ $List[$k]['citystr'] = $citytwoStr; } } } if(isset($v['three_cityid'])){ $List[$k]['job_city_three'] = $cache['city_name'][$v['three_cityid']]; } $uids[]=$v['uid']; if(isset($v['hy'])){ $List[$k]['hy_n'] = $cache['industry_name'][$v['hy']]; } if(isset($v['pr'])){ $List[$k]['pr_n'] = $cache['comclass_name'][$v['pr']]; } if(isset($v['mun'])){ $List[$k]['mun_n'] = $cache['comclass_name'][$v['mun']]; } if((isset($v['hotstart']) && isset($v['hottime'])) && $v['hotstart']<=time() && $v['hottime']>=time()){ $List[$k]['hotlogo'] = 1; } if (isset($data['logo']) && $data['logo'] == '1') { if(isset($data['utype']) && $data['utype']=='wxapp'){ if(empty($v['logo']) || (isset($v['logo_status']) && $v['logo_status']!=0)){ $List[$k]['logo'] = checkpic($this->config['sy_unit_icon']); }else{ $List[$k]['logo'] = checkpic($v['logo']); } }else{ if(empty($v['logo']) || $v['logo_status']==1){ $List[$k]['logo'] = checkpic($this->config['sy_unit_icon']); }else{ $List[$k]['logo'] = checkpic($v['logo']); $List[$k]['com_logo'] = checkpic($v['logo']); } } }else{ $List[$k]['logo'] = checkpic($v['logo']); } } if (isset($data['utype']) && $data['utype']=='special') { $all = $this->select_all("special_com",array('uid'=>array('in',pylode(',',$uids)),'sid'=>$data['sid'])); foreach($List as $k => $val){ $List[$k]['uid_n'] = $val['uid']; $List[$k]['name_n'] = $val['name']; foreach($all as $v){ if($val['uid'] == $v['uid']){ $List[$k]['cuid'] = $v['uid']; } } } } if (isset($data['statis'])) { $sList = $this -> getStatisList(array('uid'=>$whereData['uid']),array('usertype'=>2,'field'=>'`uid`,`rating_name`,`vip_stime`')); foreach ($List as $k => $v){ foreach ($sList as $sv){ if ($v['uid'] == $sv['uid']) { $List[$k]['rating'] = $sv['rating_name']; $List[$k]['vip_stime'] = $sv['vip_stime']; } } } } /* 处理后台所需数据 */ if (isset($data['utype']) && $data['utype']=='admin') { $List = $this -> getDataList($List); } if (isset($data['utype']) && $data['utype']=='crm') { $List = $this -> getDataCrmList($List, $data); } // 微信小程序所用参数 if (isset($data['utype']) && $data['utype']=='wxapp') { $List = $this -> getDataWxComList($List,array('jobfield'=>'`id`,`uid`,`name`')); } if(isset($data['url']) && $data['url']){ foreach ($List as $k => $v){ $List[$k]['comurl'] = Url('company',array('c'=>'show','id'=>$v['uid'])) ; $List[$k]['wapurl'] = Url('wap',array('c'=>'company','a'=>'show','id'=>$v['uid'])) ; $List[$k]['wapurl_showjob'] = Url('wap',array('c'=>'company','a'=>'show','id'=>$v['uid'], 'show'=>'job')) ; } } $ListCom['list'] = $List; } return $ListCom; } /** * @desc 查询company表数据，提取小程序模块所需内容信息 * * @param array $List * @param array $data,自定义数组: jobfield-获取企业职位表指定字段 */ private function getDataWxComList($List,$data){ foreach ($List as $lv){ $uids[$lv['uid']] = $lv['uid']; } // 小程序请求企业数据，更新企业曝光量 $this->upExpoure(array('expoure' => array('+', 1)), array('uid' => array('in', pylode(',', $uids)))); $options = array('city','industry'); $cache = $this -> getClass($options); if($data['jobfield']){ // 查询company_job $jWhere['uid'] = array('in', pylode(',', $uids)); $jWhere['r_status'] = 1; $jWhere['status'] = 0; $jWhere['state'] = 1; if ((int)$this->config['sy_datacycle'] > 0){ $jWhere['lastupdate'] = array('>', strtotime('- '.$this->config["sy_datacycle"].' day')); } $jData['field'] = $data['jobfield']; $row = $this -> getJobList($jWhere, $jData); $jList = $row['list']; foreach($jList as $jk=>$jv){ $jobname[$jv['uid']][]=$jv['name']; } } include PLUS_PATH.'comrating.cache.php'; foreach($List as $k=>$v){ // 提取job查询数据 $List[$k]['jobnum'] = 0; if (!empty($jobname)) { $List[$k]['jobname'] = $jobname[$v['uid']]; $List[$k]['jobnum'] = count($jobname[$v['uid']]); } if($v['shortname']){ $list[$k]['name'] = mb_substr($v['shortname'], 0,16,'utf-8'); }else{ $list[$k]['name'] = mb_substr($v['name'], 0,16,'utf-8'); } if (isset($comrat)){ foreach ($comrat as $rv){ if ($v['rating'] == $rv['id']) { $List[$k]['rating_logo'] = checkpic($rv['com_pic']); } } } } return $List; } /** * @desc 查询company表数据，提取CRM业务模块所需内容信息 * * @param array $List * @param array $data * @return array */ private function getDataCrmList($List, $data = array()){ $c_uids = $uids = $c_uids = array(); foreach ($List as $ke => $v){ $uids[$v['uid']] = $v['uid']; $c_uids[] = $v['uid']; $cuids[$v['crm_uid']] = $v['crm_uid']; } $options = array('city','crm'); $cache = $this -> getClass($options); /* 提取任务记录和联系跟进记录 */ require_once 'crm.model.php'; $crmM = new crm_model($this->db, $this->def); if(!empty($c_uids)){ $concernList = $crmM -> getConcernList(array('uid' => array('in', pylode(',', $c_uids)),'groupby' => 'uid', 'orderby' => 'd1'), array('field' => '`uid`,MAX(`atime`) AS `d1`, `content`')); $taskList = $crmM -> getTaskList(array('comid' => array('in', pylode(',', $c_uids)), 'type' => '22', 'status' => 1, 'orderby' => 'stime'), array('field' => '`comid`,`stime`')); } if (!empty($cuids)){ $crmUsers = $this->select_all('admin_user', array('uid' => array('in', pylode(',', $cuids))), '`uid`, `name`'); } require_once 'userinfo.model.php'; $uInfoM = new userinfo_model($this->db, $this->def); $uInfos = $uInfoM -> getList(array('uid' => array('in', pylode(',', $c_uids))), array('field' => '`uid`, `username`,`reg_date`,`wxopenid`,`wxid`,`unionid`,`app_wxid`')); // 查询company_cert $cWhere['uid'] = array('in', pylode(',', $uids)); $cWhere['type'] = '3'; $cData['field'] = '`uid`,`check`,`status`,`social_credit`,`owner_cert`,`wt_cert`,`other_cert`'; $cList = $this -> getCertList($cWhere, $cData); foreach ($List as $k => $v){ $List[$k]['login_date_n'] = $v['login_date'] > 0 ? date('Y-m-d', $v['login_date']) : '从未登录'; $List[$k]['release_time_n'] = !empty($v['release_time']) ? date('Y-m-d H:i', $v['release_time']) : '--'; foreach($uInfos as $uv){ if($v['uid'] == $uv['uid']){ $List[$k]['username'] = $uv['username']; $List[$k]['reg_date_n'] = date('Y-m-d', $uv['reg_date']); $List[$k]['app_wxid'] = $uv['app_wxid']; $List[$k]['wxopenid'] = $uv['wxopenid']; $List[$k]['wxid'] = $uv['wxid']; $List[$k]['unionid'] = $uv['unionid']; } } foreach ($crmUsers as $ck => $cv){ if ($v['crm_uid'] == $cv['uid']){ $List[$k]['crm_name'] = $cv['name']; } } if ($v['vipetime'] > strtotime(date('Y-m-d'))) { $List[$k]['vipDay'] = format_datetime($v['vipetime'], 2, 3, ''); }elseif ($v['vipetime']< strtotime(date('Y-m-d')) && $v['vipetime'] != '0'){ $List[$k]['vipDay'] = format_datetime($v['vipetime'], 2, 4, ''); } $List[$k]['crm_type'] = $cache['crmclass_name'][$v['crm_type']]; $List[$k]['crm_status'] = $cache['crmclass_name'][$v['crm_status']]; if (!empty($concernList)) { foreach ($concernList as $cv) { if ($v['uid'] == $cv['uid']) { if ($v['f_time'] != $cv['d1']) { $List[$k]['lastTime'] = date('y-m-d H:i', $cv['d1']); $List[$k]['lastDay'] = format_datetime($cv['d1'], 2, 1, ''); $this->update_once('company', array('isfollow' => 1, 'f_time' => $cv['d1']), array('uid' => $cv['uid'])); }else{ $List[$k]['lastTime'] = date('y-m-d H:i', $v['f_time']); $List[$k]['lastDay'] = format_datetime($v['f_time'], 2, 1, ''); } $List[$k]['c_desc'] = $cv['content']; } } } if (!empty($taskList)) { foreach ($taskList as $tv) { if ($v['uid'] == $tv['comid']) { $List[$k]['nextTime'] = date('y-m-d H:i',$tv['stime']); if ($tv['stime'] >= strtotime(date('Y-m-d'))) { $List[$k]['nextDay'] = format_datetime($tv['stime'], 2, 2, ''); }else{ $List[$k]['nextDay'] = format_datetime($tv['stime'], 2, 1, ''); } } } } // 提取company_cer查询数据，默认显示未认证，查到数据再进行审核等判断 $List[$k]['yyzz_n'] = '未认证'; if (!empty($cList)) { foreach ($cList as $cv){ if ($v['uid'] == $cv['uid']) { $List[$k]['social_credit'] = $cv['social_credit']; $List[$k]['yyzzurl'] = checkpic($cv['check']); $List[$k]['owner_cert_url'] = checkpic($cv['owner_cert']); $List[$k]['wt_cert_url'] = checkpic($cv['wt_cert']); $List[$k]['other_cert_url'] = checkpic($cv['other_cert']); if($cv['status'] == 1){ $List[$k]['yyzz_n'] = '已审核'; }elseif($cv['status'] == 2){ $List[$k]['yyzz_n'] = '未通过'; }elseif($cv['status'] == 0){ $List[$k]['yyzz_n'] = '未审核'; } } } } } if (isset($data['todayNum']) && $data['todayNum'] == '1') { $ListArray['list'] = $List; return $ListArray; }else{ return $List; } } /** * @desc 查询company表内没有的数据，引用相关类，查询关联表，提取列表数据所需信息 * @param array $List * @return array */ private function getDataList($List) { foreach ($List as $v){ $uids[$v['uid']] = $v['uid']; if ($v['crm_uid']) { $cids[$v['uid']] = $v['crm_uid']; } if ((isset($v['rating']) && $v['rating'] == 0) || $v['vip_etime'] <= strtotime('today')){ // 取得过期会员的uid $guids[] = $v['uid']; } } // 查询member $mWhere['uid'] = array('in', pylode(',', $uids)); $mData['field'] = '`uid`,`username`,`status`,`login_date`,`reg_date`,`source`,`usertype`,`wxopenid`,`wxid`,`unionid`,`app_wxid`'; $mList = $this -> getMemberList($mWhere, $mData); // 查询company_statis $sWhere['uid'] = array('in', pylode(',', $uids)); $sData['field'] = '`uid`,`pay`,`integral`'; $sList = $this -> getStatisList($sWhere, $sData); // 查询company_cert $cWhere['uid'] = array('in', pylode(',', $uids)); $cWhere['type'] = '3'; $cData['field'] = '`uid`,`check`,`status`,`social_credit`,`owner_cert`,`wt_cert`,`other_cert`'; $cList = $this -> getCertList($cWhere, $cData); // 查询company_job $jWhere['uid'] = array('in', pylode(',', $uids)); $jData['field'] = '`uid`'; $jList = $this -> getJobList($jWhere, $jData); // 查询用户最新一次会员套餐购买成功记录，来确定过期用户，过期前的会员套餐 if (!empty($guids)){ $viporder = $this->select_all('company_order', array('uid'=>array('in', pylode(',', $guids)),'order_state'=>2,'groupby'=>'uid'), 'MAX(`id`) AS `id`'); $viplist = $this->select_all('company_rating',array('category'=>1),'`id`,`name`'); $comrat = array(); foreach ($viplist as $v){ $comrat[$v['id']] = $v['name']; } foreach ($viporder as $v){ $ordreid[] = $v['id']; } // 通过最新订单记录id来查询订单 $orders = $this->select_all('company_order', array('id'=>array('in', pylode(',', $ordreid)),'orderby'=>'id'), '`uid`,`rating`'); foreach ($List as $k=>$v){ foreach ($orders as $val){ if ($v['uid'] == $val['uid'] && isset($comrat[$val['rating']])){ $List[$k]['oldrating_name'] = $comrat[$val['rating']]; } } } } // 查询admin_user 业务员信息 $crmList = $this -> select_all('admin_user', array('uid' => array('in', pylode(',', $cids))), '`uid`,`name`'); foreach ($List as $k => $v){ $List[$k]['comUrl'] = $this ->config['sy_weburl']."/company/index.php?c=show&id=".$v['uid']."&look=admin"; // 分站did字段为空的数据 if($v['did'] == ''){ $List[$k]['did'] = '0'; } // 提取member查询数据 if (!empty($mList)) { foreach ($mList as $mv){ if ($v['uid'] == $mv['uid']) { $List[$k]['username'] = $mv['username']; $List[$k]['status'] = $mv['status']; $List[$k]['login_date'] = $mv['login_date']; $List[$k]['reg_date'] = $mv['reg_date']; $List[$k]['source'] = $mv['source']; $List[$k]['usertype'] = $mv['usertype']; $List[$k]['app_wxid'] = $mv['app_wxid']; $List[$k]['wxopenid'] = $mv['wxopenid']; $List[$k]['wxid'] = $mv['wxid']; $List[$k]['unionid'] = $mv['unionid']; } } } // 提取company_statis查询数据 if (!empty($sList)) { foreach ($sList as $sv){ if ($v['uid'] == $sv['uid']) { $List[$k]['pay'] = $sv['pay']; $List[$k]['integral'] = $sv['integral']; } } } // 提取company_cer查询数据，默认显示未认证，查到数据再进行审核等判断 $List[$k]['yyzz_n'] = '未认证'; if (!empty($cList)) { foreach ($cList as $cv){ if ($v['uid'] == $cv['uid']) { $List[$k]['social_credit'] = $cv['social_credit']; $List[$k]['yyzzurl'] = checkpic($cv['check']); $List[$k]['owner_cert_url'] = checkpic($cv['owner_cert']); $List[$k]['wt_cert_url'] = checkpic($cv['wt_cert']); $List[$k]['other_cert_url'] = checkpic($cv['other_cert']); if($cv['status'] == 1){ $List[$k]['yyzz_n'] = '已审核'; }elseif($cv['status'] == 2){ $List[$k]['yyzz_n'] = '未通过'; }elseif($cv['status'] == 0){ $List[$k]['yyzz_n'] = '未审核'; } } } } // 提取job查询数据，统计职位总数 if (!empty($jList['list'])) { $jobList = $jList['list']; foreach ($jobList as $jv){ if($v[uid] == $jv[uid]){ $List[$k]['jobnum']++; } } } // 提取顾问表查询数据 if (!empty($crmList)) { foreach ($crmList as $crm){ if($v['crm_uid'] == $crm['uid']){ $List[$k]['crm_name'] = $crm['name']; } } } } return $List; } /** * @desc 引用userinfo类，查询membernum信息 * @param array $whereData * @param array $data * @return array|bool|false|string|void */ private function getMemberNum($whereData = array(), $data = array()) { require_once ('userinfo.model.php'); $UserInfoM = new userinfo_model($this->db, $this->def); return $UserInfoM->GetMemberNum($whereData , $data); } /** * @desc 引用userinfo类，查询member列表信息 */ private function getMemberList($whereData = array(), $data = array()) { require_once ('userinfo.model.php'); $UserinfoM = new userinfo_model($this->db, $this->def); return $UserinfoM -> getList($whereData , $data); } /** * @desc 引用statis类，查询company_statis列表信息 * * @param array $whereData ： 查询条件 * @param array $data : 自定义查询 */ private function getStatisList($whereData = array(), $data = array()) { require_once ('statis.model.php'); $StatisM = new statis_model($this->db, $this->def); return $StatisM -> getList($whereData , $data); } /** * @desc 引用job类，查询company_job列表信息 * * @param array $whereData ： 查询条件 * @param array $data : 自定义查询 * * @return array array('list'=>array()):职位列表 */ private function getJobList($whereData = array(), $data = array()) { require_once ('job.model.php'); $JobM = new job_model($this->db, $this->def); return $JobM -> getList($whereData , $data); } /** * @desc 更新数据 * * @param int/array $id * @param array $where * @param array $data */ public function upInfo( $id , $where = array() , $Data = array()) { if (!empty($id) || $where) { if(!empty($id)){ if (is_array($id)) { $whereD = array( 'uid' => array('in', pylode(',', $id)) ); } else { $whereD = array( 'uid' => intval($id) ); } } if(!empty($where) && !empty($whereD)){ $where = array_merge($where, $whereD); }else if(!empty($where) && empty($whereD)){ $where = $where; }else if(!empty($whereD) && empty($where)){ $where = $whereD; } $nid = $this -> update_once('company', $Data, $where); return $nid; } } /** * @desc 查询company_cert数目 * @param array $whereData * @return number */ public function getCertNum($whereData = array()) { return $this -> select_num('company_cert', $whereData); } /** * @desc 查询company_news数目 * @param array $whereData * @return number */ public function getCompanyNewsNum($whereData = array()) { return $this -> select_num('company_news', $whereData); } /** * @desc 查询company_product数目 * @param array $whereData * @return number */ public function getCompanyProductNum($whereData = array()) { return $this -> select_num('company_product', $whereData); } /** * @desc 查询company_cert详细数据 * * @param array $whereData ： 查询条件 * @param array $data : 自定义查询 */ public function getCertInfo($whereData = array(), $data = array()) { $select = $data['field'] ? $data['field'] : '*'; $Info = $this -> select_once('company_cert', $whereData, $select); if($Info['type'] == '3' || $Info['type'] == '4' || $Info['type'] == '5' ){ $Info['old_check'] = checkpic($Info['check']); $Info['old_owner_cert'] = checkpic($Info['owner_cert']); $Info['old_wt_cert'] = checkpic($Info['wt_cert']); $Info['old_other_cert'] = checkpic($Info['other_cert']); } return $Info; } /** * @desc 查询company_cert列表数据 * * @param array $whereData ： 查询条件 * @param array $data : 自定义查询 */ public function getCertList($whereData = array(), $data = array()) { $select = $data['field'] ? $data['field'] : '*'; $List = $this -> select_all('company_cert', $whereData, $select); if ($List && is_array($List)) { $uids = array(); foreach ($List as $value) { $uids[] = $value['uid']; } if (isset($data['utype']) && $data['utype']='comcert') { $ListCA = $this -> getList(array('uid'=>array('in', pylode(',', $uids))),array('field'=>'uid,name')); $comList = $ListCA['list']; } if (isset($data['utype']) && $data['utype']='ltcert') { $ltList = $this -> select_all('lt_info',array('uid'=>array('in', pylode(',', $uids))),'`uid`,`realname`'); } if (isset($data['utype']) && $data['utype']='pxcert') { $pxList = $this -> select_all('px_train',array('uid'=>array('in', pylode(',', $uids))),'`uid`,`name`'); } foreach ($List as $k => $v) { $List[$k]['check'] = checkpic($v['check']); $List[$k]['owner_cert'] = checkpic($v['owner_cert']); $List[$k]['wt_cert'] = checkpic($v['wt_cert']); $List[$k]['other_cert'] = checkpic($v['other_cert']); if (!empty($comList) && is_array($comList)) { foreach ($comList as $cv){ if ($v['uid'] == $cv['uid']) { $List[$k]['name'] = $cv['name']; } } } if (!empty($ltList) && is_array($ltList)) { foreach ($ltList as $lv){ if ($v['uid'] == $lv['uid']) { $List[$k]['realname'] = $lv['realname']; } } } if (!empty($pxList) && is_array($pxList)) { foreach ($pxList as $pv){ if ($v['uid'] == $pv['uid']) { $List[$k]['name'] = $pv['name']; } } } } return $List; } } /** * @desc 修改company_cert（手机认证、邮箱认证、企业资质修改/审核） * * @param array $whereData : 修改条件 * @param array $upData : 修改的数据 * @param array $data : 自定义处理数组 */ public function upCertInfo($whereData = array(), $upData = array(), $data = array()){ if (!empty($upData) && !empty($whereData)){ /* 手机认证绑定 */ if (!empty($data['moblie'])) { $return = $this -> upCertMobile($whereData, $upData, $data); } /* 邮箱认证绑定 */ if (isset($data['email']) && !empty($data['email'])) { $return = $this -> upCertEmail($whereData, $upData, $data); } /* 更新营业/培训执照 */ if (isset($data['yyzz']) && $data['yyzz'] == '1') { $return = $this -> upCertYyzz($whereData, $upData, $data); } if ($data['utype']=='admin') { $return = $this -> update_once('company_cert', $upData, $whereData); } } return $return; } /** * @desc 手机认证 */ private function upCertMobile($whereData = array(), $upData = array(), $data = array()){ $return = 0; $moblie = trim($data['moblie']); $uid = intval($whereData['uid']); $usertype = intval($data['usertype']); $cert = $this -> getCertInfo(array('uid'=>$uid, 'check'=>$moblie, 'type'=>'2'),array('field'=>'`check2`,`ctime`')); if ($cert && is_array($cert)) { $time = time(); $codeTime = $cert['ctime'] + $this->config['moblie_codetime'] * 60 ; // moblie_codetime 后台设定验证码时效（单位分钟） if ($codeTime < $time) { // 验证码时效性验证 $return = 4; }else if ($cert['check2'] != $whereData['check2']) { $return = 3; } else { /* 清除该号码以前认证 使用uid和moblie 防止更新其他用户 START */ $this -> update_once('member', array('moblie'=>''),array('moblie' => $moblie,'uid'=>array('<>',$uid))); // 解除个人手机绑定，简历重置未审核 start $resumes = $this -> select_all('resume', array('telphone' => $moblie, 'uid' => array('<>', $uid)), '`uid`'); if(!empty($resumes)){ $ruids = array(); foreach($resumes as $rk=> $rv){ $ruids[] = $rv['uid']; } $this -> update_once('resume', array('moblie_status'=>'0', 'telphone'=>''), array('uid'=>array('in', pylode(',', $ruids)))); include_once('resume.model.php'); $resumeM = new resume_model($this->db, $this->def); $resumeM->setExpectState(array('state'=>'0'),array('uid'=>array('in', pylode(',', $ruids)))); } // end $this -> update_once('company', array('moblie_status'=>'0', 'linktel'=>''), array('linktel'=>$moblie, 'uid'=>array('<>',$uid))); $this -> update_once('lt_info', array('moblie_status'=>'0', 'moblie'=>''), array('moblie'=>$moblie, 'uid'=>array('<>',$uid))); $this -> update_once('px_train', array('moblie_status'=>'0', 'linktel'=>''), array('linktel'=>$moblie, 'uid'=>array('<>',$uid))); /* 清除该号码以前认证 END */ // 获取用户信息，用来判断旧手机号和用户名是否一致 $member = $this->select_once('member', array('uid' => $uid), "username,moblie"); $upMemberMobileData = array('moblie'=>$moblie,'moblie_status'=>'1'); if($member['username'] == $member['moblie']){ $upMemberMobileData['username'] = $moblie; } /* 更新账号表数据 */ $this->update_once('member', $upMemberMobileData, array('uid'=>$uid)); /* 根据会员类型 更新基本信息表数据,一个认证 全部认证 */ $this -> update_once('resume',array('telphone'=>$moblie,'moblie_status'=>'1'),array('uid'=>$uid)); $this -> update_once('company', array('linktel'=>$moblie,'moblie_status'=>'1'), array('uid'=>$uid)); $this -> update_once('lt_info', array('moblie'=>$moblie,'moblie_status'=>'1'), array('uid'=>$uid)); $this -> update_once('px_train',array('linktel'=>$moblie,'moblie_status'=>'1'),array('uid'=>$uid)); $this -> update_once('gq_info',array('moblie'=>$moblie,'moblie_status'=>'1'),array('uid'=>$uid)); $this -> update_once('gq_task',array('link_moblie'=>$moblie),array('uid'=>$uid)); /* 添加日志 */ $this -> addMemberLog($uid, $usertype, '手机号码认证成功， 认证手机号：'.$moblie, 13 ,1); /* 第一次绑定查询，获取积分奖励 */ $pay = $this -> select_once('company_pay', array('pay_remark'=>'手机绑定', 'com_id'=>intval($whereData['uid']))); if (empty($pay)) { $this -> getIntegral(intval($whereData['uid']), $usertype, 'integral_mobliecert', '手机绑定'); } } }else{ $return = 2; } if ($return == 0) { $return = $this -> update_once('company_cert', $upData, $whereData); if($return){ $return=1; }else{ $return=5; } } return $return; } /** * @desc 发送邮箱认证 */ function sendCertEmail($whereData = array(), $data = array()) { if (empty($whereData['uid']) || empty($data['usertype'])) { $return = '0'; }else if ($this->config['sy_email_set'] != '1') { $return = '3'; }else if ($this->config['sy_email_cert'] == '2'){ $return = '2'; }else{ $cert = $this -> getCertInfo($whereData); $uid = intval($whereData['uid']); $usertype = intval($data['usertype']); $email = trim($data['email']); $randstr = rand(10000000,99999999); $value = array( 'status' => '0', 'step' => '1', 'check' => $email, 'check2' => $randstr, 'ctime' => time() ); if ($cert && is_array($cert)) { $this -> update_once('company_cert', $value, $whereData); $this -> addMemberLog($uid, $usertype, '更新邮箱认证，认证邮箱：'.$email, 13 ,2); } else { $values = array( 'uid' => $uid, 'did' => intval($data['did']), 'type' => '1' ); $value = array_merge($value, $values); $this -> insert_into('company_cert', $value); $this -> addMemberLog($uid, $usertype, '添加邮箱认证，认证邮箱：'.$email, 13 ,1); } $base = base64_encode($uid.'|'.$randstr.'|'.$this->config['coding'].'|'.$email); $url = Url('qqconnect', array('c'=>'cert','id'=>$base),'1'); include_once('userinfo.model.php'); $UserinfoM = new userinfo_model($this->db, $this->def); $userwhere['uid'] = $uid; $fdata = $UserinfoM->getUserInfo($userwhere,array('usertype'=>$usertype,'field'=>'`name`')); $emailData = array( 'uid' => $uid, 'name' => trim($fdata['name']), 'type' => 'cert', 'email' => $email, 'url' => '点击认证 如果您不能在邮箱中直接打开，请复制该链接到浏览器地址栏中直接打开：'.$url, 'date' => date('Y-m-d') ); require_once 'notice.model.php'; $noticeM = new notice_model($this->db, $this->def); $noticeM -> sendEmailType($emailData); $return = '1'; } return $return; } /** * @desc 邮箱认证 */ private function upCertEmail($whereData = array(), $upData = array(), $data = array()){ $return = array(); $email = trim($data['email']); $check2 = intval($whereData['check2']); $uid = intval($whereData['uid']); $usertype = intval($data['usertype']); $cert = $this -> getCertInfo(array('uid'=>$uid,'check'=>$email, 'check2'=>$check2, 'type'=>'1')); if ($cert && is_array($cert)) { /* 清除该邮箱以前认证 使用uid和moblie 防止更新其他用户 同uid则不清除 START */ $this -> update_once('member',array('email'=>''), array('email' => $email,'uid' =>array('<>',$cert['uid']))); $this -> update_once('resume',array('email_status'=>'0', 'email'=>''), array('email'=>$email,'uid' =>array('<>',$cert['uid']))); $this -> update_once('company',array('email_status'=>'0', 'linkmail'=>''), array('linkmail'=>$email,'uid' =>array('<>',$cert['uid']))); $this -> update_once('lt_info',array('email_status'=>'0', 'email'=>''), array('email'=>$email,'uid' =>array('<>',$cert['uid']))); $this -> update_once('px_train',array('email_status'=>'0', 'linkmail'=>''),array('linkmail'=>$email,'uid' =>array('<>',$cert['uid']))); /* 清除该号码以前认证 END */ $return['id'] = $this -> update_once('company_cert', $upData, $whereData); if ($return['id']) { /* 更新账号表数据 */ $this->update_once('member', array('email'=>$email,'email_status'=>'1'), array('uid'=>$uid)); /* 根据会员类型 更新基本信息表数据 */ $this -> update_once('resume',array('email'=>$email,'email_status'=>'1'),array('uid'=>$uid)); $this -> update_once('company', array('linkmail'=>$email,'email_status'=>'1'), array('uid'=>$uid)); $this -> update_once('lt_info', array('email'=>$email,'email_status'=>'1'), array('uid'=>$uid)); $this -> update_once('px_train',array('linkmail'=>$email,'email_status'=>'1'),array('uid'=>$uid)); /* 添加日志 */ $this -> addMemberLog($uid, $usertype, '邮箱认证成功， 认证邮箱：'.$email, 13 ,1); $pay = $this -> select_once('company_pay', array('pay_remark'=>'邮箱认证', 'com_id'=>$uid)); if (empty($pay)) { $this -> getIntegral($uid,$usertype, 'integral_emailcert', '邮箱认证'); } $return['errcode'] = '9'; $return['msg'] = '认证成功！'; } else { $return['errcode'] = 8; $return['msg'] = '认证失败，联系管理员认证！'; } }else{ $return['errcode'] = 8; $return['msg'] = '认证失败，请检查来路！'; } return $return; } /** * @desc 企业资质更新认证 * @param array $whereData * @param array $upData * @param array $data */ private function upCertYyzz($whereData = array(), $upData = array(), $data = array()) { $return = array(); $uid = intval($whereData['uid']); $usertype = intval($data['usertype']); if ($data['type']=='3') { if ($data['com_name']) { $comnum = $this -> select_num('company', array('uid' => array('<>', $uid), 'name' => trim($data['com_name']))); if ($comnum > 0) { $return['msg'] = '企业名称已存在！'; $return['errcode'] = 8; return $return; } }else{ $return['msg'] = '企业名称不能为空！'; $return['errcode'] = 8; } $msg = '更新企业资质'; } if ($data['type']=='4') { $msg = '更新认证'; } if ($data['type']=='5'){ if ($data['px_name']) { $pxnum = $this -> select_num('px_trian', array('uid' => array('<>', $data['uid']), 'name'=>trim($data['px_name']))); if ($pxnum > 0) { $return['msg'] = '机构名称已存在！'; $return['errcode'] = 8; } }else{ $return['msg'] = '机构名称不能为空！'; $return['errcode'] = 8; } $msg = '更新培训执照'; } //营业执照 if ((is_array($upData['check']) && $upData['check']['tmp_name']) || $upData['base']){ $upArr = array( 'file' => $upData['check'], 'dir' => 'cert', 'base' => $upData['base'], 'preview' => $upData['preview'] ); $result = $this -> upload($upArr); if (!empty($result['msg'])){ $return['msg'] = $result['msg']; $return['errcode'] = '8'; return $return; }elseif (!empty($result['picurl'])){ $picurl = $result['picurl']; } unset($upData['check']); unset($upData['base']); unset($upData['preview']); } //经办人身份证 if ((is_array($upData['owner_cert']) && $upData['owner_cert']['tmp_name']) || $upData['base_owner_cert']){ $upArr = array( 'file' => $upData['owner_cert'], 'dir' => 'cert', 'base' => $upData['base_owner_cert'], 'preview' => $upData['preview_owner_cert'] ); $oresult = $this -> upload($upArr); if (!empty($oresult['msg'])){ $return['msg'] = $oresult['msg']; $return['errcode'] = '8'; return $return; }elseif (!empty($oresult['picurl'])){ $picurl_owner_cert = $oresult['picurl']; } unset($upData['owner_cert']); unset($upData['base_owner_cert']); unset($upData['preview_owner_cert']); } //经办人身份证 if ((is_array($upData['wt_cert']) && $upData['wt_cert']['tmp_name']) || $upData['base_wt_cert']){ $upArr = array( 'file' => $upData['wt_cert'], 'dir' => 'cert', 'base' => $upData['base_wt_cert'], 'preview' => $upData['preview_wt_cert'] ); $wresult = $this -> upload($upArr); if (!empty($wresult['msg'])){ $return['msg'] = $wresult['msg']; $return['errcode'] = '8'; return $return; }elseif (!empty($wresult['picurl'])){ $picurl_wt_cert = $wresult['picurl']; } unset($upData['wt_cert']); unset($upData['base_wt_cert']); unset($upData['preview_wt_cert']); } //经办人身份证 if ((is_array($upData['other_cert']) && $upData['other_cert']['tmp_name']) || $upData['base_other_cert']){ $upArr = array( 'file' => $upData['other_cert'], 'dir' => 'cert', 'base' => $upData['base_other_cert'], 'preview' => $upData['preview_other_cert'] ); $wresult = $this -> upload($upArr); if (!empty($wresult['msg'])){ $return['msg'] = $wresult['msg']; $return['errcode'] = '8'; return $return; }elseif (!empty($wresult['picurl'])){ $picurl_other_cert = $wresult['picurl']; } unset($upData['other_cert']); unset($upData['base_other_cert']); unset($upData['preview_other_cert']); } if (isset($picurl)){ $upData['check'] = $picurl; } if (isset($picurl_owner_cert)){ $upData['owner_cert'] = $picurl_owner_cert; } if (isset($picurl_wt_cert)){ $upData['wt_cert'] = $picurl_wt_cert; } if (isset($picurl_other_cert)){ $upData['other_cert'] = $picurl_other_cert; } $return['id'] = $this -> update_once('company_cert', $upData, $whereData); if ($return['id']) { //名称 if ($data['com_name']) { $this -> update_once('company_job',array('com_name'=>trim($data['com_name'])),array('uid'=>$uid)); $this -> update_once('company',array('name'=>trim($data['com_name']), 'yyzz_status'=>intval($upData['status'])),array('uid'=>$uid)); } if ($data['px_name']) { $this -> update_once('px_train',array('name'=>trim($data['px_name']), 'yyzz_status'=>intval($upData['status'])),array('uid'=>$uid)); } $this -> addMemberLog($uid, $usertype, $msg, 13 ,2); if($usertype==2){ $company = $this->select_once('company',array('uid'=>$uid),'`name`'); $this -> update_once('company',array('yyzz_status'=>intval($upData['status'])),array('uid'=>$uid)); if ($this->config['com_cert_status'] == '0') { $return['msg'] = '更新成功！'; }else{ $return['msg'] = '更新成功，等待审核！'; require_once('admin.model.php'); $adminM = new admin_model($this->db,$this->def); $adminM->sendAdminMsg(array('first'=>'有新的企业资质需要审核，企业《'.$company['name'].'》更新企业资质成功，等待审核！','type'=>24)); } } if($usertype==3){ $lt_info = $this->select_once('lt_info',array('uid'=>$uid),'`realname`'); $this -> update_once('lt_info',array('yyzz_status'=>intval($upData['status'])),array('uid'=>$uid)); if ($this->config['lt_cert_status'] == '0') { $return['msg'] = '更新成功！'; }else{ $return['msg'] = '更新成功，等待审核！'; require_once('admin.model.php'); $adminM = new admin_model($this->db,$this->def); $adminM->sendAdminMsg(array('first'=>'有新的猎头执照需要审核，猎头《'.$lt_info['realname'].'》更新执照成功，等待审核！','type'=>25)); } } if($usertype==4){ $pxinfo = $this->select_once('px_train',array('uid'=>$uid),'`name`'); if ($this->config['px_cert_status'] == '0') { $return['msg'] = '更新成功！'; }else{ $return['msg'] = '更新成功，等待审核！'; require_once('admin.model.php'); $adminM = new admin_model($this->db,$this->def); $adminM->sendAdminMsg(array('first'=>'有新的培训认证需要审核，培训机构《'.$pxinfo['name'].'》更新执照成功，等待审核！','type'=>26)); } } $return['errcode'] = 9; }else{ $return['msg'] = '更新失败！'; $return['errcode'] = 8; } return $return; } /** * @desc 新增 company_cert信息 * * @param $data['type'] : 3=>企业企业资质 ; 4=>猎头资格认证 ; 5=> 培训执照; 6=>认领会员 */ public function addCertInfo($data = array()){ $return = array(); if (!empty($data)) { if($data['type'] != '6'){ if($data['check'] && !is_array($data['check'])){ $picurl = $data['check']; } if($data['owner_cert'] && !is_array($data['owner_cert'])){ $picurl_owner_cert = $data['owner_cert']; } if($data['wt_cert'] && !is_array($data['wt_cert'])){ $picurl_wt_cert = $data['wt_cert']; } if($data['other_cert'] && !is_array($data['other_cert'])){ $picurl_other_cert = $data['other_cert']; } } //营业执照 if ((is_array($data['check']) && $data['check']['tmp_name']) || $data['base']){ $upArr = array( 'file' => $data['check'], 'dir' => 'cert', 'base' => $data['base'], 'preview' => $data['preview'] ); $result = $this -> upload($upArr); if (!empty($result['msg'])){ $return['msg'] = $result['msg']; $return['errcode'] = '8'; return $return; }elseif (!empty($result['picurl'])){ $picurl = $result['picurl']; } } //经办人身份证 if ((is_array($data['owner_cert']) && $data['owner_cert']['tmp_name']) || $data['base_owner_cert']){ $upArr = array( 'file' => $data['owner_cert'], 'dir' => 'cert', 'base' => $data['base_owner_cert'], 'preview' => $data['preview_owner_cert'] ); $oresult = $this -> upload($upArr); if (!empty($oresult['msg'])){ $return['msg'] = $oresult['msg']; $return['errcode'] = '8'; return $return; }elseif (!empty($oresult['picurl'])){ $picurl_owner_cert = $oresult['picurl']; } } //委托书 承诺函 if ((is_array($data['wt_cert']) && $data['wt_cert']['tmp_name']) || $data['base_wt_cert']){ $upArr = array( 'file' => $data['wt_cert'], 'dir' => 'cert', 'base' => $data['base_wt_cert'], 'preview' => $data['preview_wt_cert'] ); $wresult = $this -> upload($upArr); if (!empty($wresult['msg'])){ $return['msg'] = $wresult['msg']; $return['errcode'] = '8'; return $return; }elseif (!empty($wresult['picurl'])){ $picurl_wt_cert = $wresult['picurl']; } } //委托书 承诺函 if ((is_array($data['other_cert']) && $data['other_cert']['tmp_name']) || $data['base_other_cert']){ $upArr = array( 'file' => $data['other_cert'], 'dir' => 'cert', 'base' => $data['base_other_cert'], 'preview' => $data['preview_other_cert'] ); $otresult = $this -> upload($upArr); if (!empty($otresult['msg'])){ $return['msg'] = $otresult['msg']; $return['errcode'] = '8'; return $return; }elseif (!empty($otresult['picurl'])){ $picurl_other_cert = $otresult['picurl']; } } $value = array( 'uid' => intval($data['uid']), 'usertype' => $data['usertype'], 'type' => trim($data['type']), 'status' => intval($data['status']), 'step' => intval($data['step']), 'did' => intval($data['did']), 'check2' => $data['type'] == '6' ? $data['check2'] : 0, 'ctime' => time(), 'did' => $data['did'] ); if(isset($picurl)){ $value['check'] = $picurl; }else if($data['type'] != '6'){ $return['msg'] = '请上传营业执照！'; $return['errcode'] = 8; return $return; } //以下企业认证专用 if(isset($data['social_credit'])){ $value['social_credit'] = $data['social_credit']; }else if($data['type'] == '3' && $this->config['com_social_credit']==1){ $return['msg'] = '请填写统一社会信用代码！'; $return['errcode'] = 8; return $return; } if(isset($picurl_owner_cert)){ $value['owner_cert'] = $picurl_owner_cert; }else if($data['type'] == '3' && $this->config['com_cert_owner']==1){ $return['msg'] = '请上传经办人身份证！'; $return['errcode'] = 8; return $return; } if(isset($picurl_wt_cert)){ $value['wt_cert'] = $picurl_wt_cert; }else if($data['type'] == '3' && $this->config['com_cert_wt']==1){ $return['msg'] = '请上传委托书/承诺函！'; $return['errcode'] = 8; return $return; } if(isset($picurl_other_cert)){ $value['other_cert'] = $picurl_other_cert; } /* 企业资质企业名称检测 */ if ($data['type'] == '3') { if ($data['com_name']) { $comnum = $this -> select_num('company', array('uid' => array('<>', $data['uid']), 'name'=>trim($data['com_name']))); if ($comnum > 0) { $return['msg'] = '企业名称已存在！'; $return['errcode'] = 8; return $return; } }else{ $return['msg'] = '企业名称不能为空！'; $return['errcode'] = 8; } } /* 培训机构执照机构名称检测 */ if ($data['type'] == '5') { if ($data['px_name']) { $pxnum = $this -> select_num('px_trian', array('uid' => array('<>', $data['uid']), 'name'=>trim($data['px_name']))); if ($pxnum > 0) { $return['msg'] = '机构名称已存在！'; $return['errcode'] = 8; } }else{ $return['msg'] = '机构名称不能为空！'; $return['errcode'] = 8; } } $return['id'] = $this -> insert_into('company_cert', $value); if ($return['id']) { //名称 if ($data['type']=='3') { $cominfo = $this->select_once('company',array('uid'=>$data['uid']),'`uid`'); if(empty($cominfo)){ $this->activUser($data['uid'], $data['usertype']); } $this -> update_once('company', array('name'=>trim($data['com_name']), 'yyzz_status'=>intval($data['status'])),array('uid'=>intval($data['uid']))); $msg = '上传企业资质'; }else if ($data['type']=='4') { $ltinfo = $this->select_once('lt_info',array('uid'=>$data['uid']),'`uid`'); if(empty($ltinfo)){ $this->activUser($data['uid'], $data['usertype']); } $this -> update_once('lt_info', array('yyzz_status'=>intval($data['status'])),array('uid'=>intval($data['uid']))); $msg = '添加认证'; }else if ($data['type']=='5'){ $pxinfo = $this->select_once('px_train',array('uid'=>$data['uid']),'`uid`'); if(empty($ltinfo)){ $this->activUser($data['uid'], $data['usertype']); } $this -> update_once('px_train', array('name'=>trim($data['px_name']), 'yyzz_status'=>intval($data['status'])),array('uid'=>intval($data['uid']))); $msg = '上传培训执照'; } $this -> addMemberLog(intval($data['uid']), intval($data['usertype']), $msg, 13 ,1); if($data['usertype']==2){ if ($this->config['com_cert_status'] == '0') { $this -> getIntegral(intval($data['uid']), intval($data['usertype']), 'integral_comcert', '认证企业资质'); $return['msg'] = '上传成功！'; }else{ $return['msg'] = '上传成功，等待审核！'; $cominfo = $this->select_once('company',array('uid'=>$data['uid']),'`name`'); require_once('admin.model.php'); $adminM = new admin_model($this->db,$this->def); $adminM->sendAdminMsg(array('first'=>'有新的企业资质需要审核，企业《'.$cominfo['name'].'》上传资质成功，等待审核！','type'=>24)); } } if($data['usertype']==3){ if ($this->config['lt_cert_status'] == '0') { $uid = $data['uid']; $ulen = 9 - strlen($uid); for ($a = 1; $a < $ulen; $a++){ $rzid = '0'.$uid; } $this -> update_once('lt_info', array('rzid'=>'YLT'.$rzid, 'rz_time' => time()), array('uid'=>$uid)); $this -> getIntegral(intval($data['uid']), intval($data['usertype']), 'integral_ltcert', '猎头执照认证'); $return['msg'] = '上传成功！'; }else{ $return['msg'] = '上传成功，等待审核！'; $lt_info = $this->select_once('lt_info',array('uid'=>$data['uid']),'`realname`'); require_once('admin.model.php'); $adminM = new admin_model($this->db,$this->def); $adminM->sendAdminMsg(array('first'=>'有新的猎头执照需要审核，猎头《'.$lt_info['realname'].'》上传执照成功，等待审核！','type'=>25)); } } if($data['usertype']==4){ if ($this->config['px_cert_status'] == '0') { $return['msg'] = '上传成功！'; }else{ $return['msg'] = '上传成功，等待审核！'; $px_info = $this->select_once('px_train',array('uid'=>$uid),'`name`'); require_once('admin.model.php'); $adminM = new admin_model($this->db,$this->def); $adminM->sendAdminMsg(array('first'=>'有新的培训认证需要审核，培训机构《'.$px_info['name'].'》上传认证成功，等待审核！','type'=>26)); } } $return['errcode'] = 9; }else{ $return['msg'] = '上传失败！'; $return['errcode'] = 8; } } return $return; } /** * 添加相应用户 * @param $uid * @param $usertype */ private function activUser($uid, $usertype) { include_once('userinfo.model.php'); $userInfoM = new userinfo_model($this->db, $this->def); $userInfoM->activUser($uid, $usertype); } /** * @desc 删除company_cert * @param null $uid * @param array $data * @return array */ public function delCert($uid = null, $data = array()) { $return = array(); if (!empty($uid)) { if (is_array($uid)) { $uids = $uid; $return['layertype'] = 1; } else { $uids = @explode(',', $uid); $return['layertype'] = 0; } /* 查询证书图片 */ $certs = $this->getCertList(array('uid' => array('in', pylode(',', $uids))), array('field' => '`uid`,`check`')); if (empty($certs)) { $return['msg'] = '数据错误，请重试！'; $return['errcode'] = '8'; } else { $return['id'] = $this->delete_all('company_cert', array('uid' => array('in', pylode(',', $uids)), 'type' => $data['type']), ''); if ($return['id']) { if ($data['type'] == '3') { $return['msg'] = '企业认证(UID:' . pylode(',', $uid); } elseif ($data['type'] == '4') { $return['msg'] = '猎头认证(UID:' . pylode(',', $uid); } elseif ($data['type'] == '5') { $return['msg'] = '培训机构认证(UID:' . pylode(',', $uid); } $return['msg'] .= ')删除成功'; $return['errcode'] = '9'; } else { $return['msg'] .= ')删除失败'; $return['errcode'] = '8'; } } } else { $return['msg'] = '请选择您要删除的信息！'; $return['errcode'] = '8'; } return $return; } /** * @desc 查询company_order详细数据 * @param array $whereData * @param array $data * @return array|bool|false|string|void */ public function getOrderInfo($whereData = array(), $data = array()) { $select = $data['field'] ? $data['field'] : '*'; return $this->select_once('company_order', $whereData, $select); } /** * @desc 修改企业名称，同步修改相关表数据 */ function upComName($uid = null, $comname = null) { if (!empty($uid) && !empty($comname)) { $uid = intval($uid); $comname = trim($comname); $this -> update_once('userid_job',array('com_name'=>$comname),array('com_id'=>$uid)); $this -> update_once('fav_job',array('com_name'=>$comname),array('com_id'=>$uid)); $this -> update_once('report',array('r_name'=>$comname),array('c_uid'=>$uid)); $this -> update_once('blacklist',array('com_name'=>$comname),array('c_uid'=>$uid)); $this -> update_once('msg',array('com_name'=>$comname),array('job_uid'=>$uid)); $this -> update_once('hotjob',array('username'=>$comname),array('uid'=>$uid)); } } /** * @desc 分配顾问 * @param array $data * @param array $whereData * @return array */ function setComGw($data = array(), $whereData = array()) { $return = array(); if (!empty($data) && !empty($whereData)) { $uids = $whereData['uid']; $crm_uid = $whereData['crm_uid']; $adminUser = $this->select_once('admin_user', array('uid' => $crm_uid), '`name`'); $result = $this->update_once('company', $data, array('uid' => array('in', $uids))); if ($result) { $msg = '管理员为您分配招聘顾问：' . $adminUser['name']; //发送系统通知 include_once('sysmsg.model.php'); $msgM = new sysmsg_model($this->db, $this->def); $msgM->addInfo(array('uid' => $uids, 'usertype' => 2, 'content' => $msg)); } $return['msg'] = '顾问(ID:' . $crm_uid . ')'; $return['errcode'] = $result ? '9' : '8'; $return['msg'] = $result ? $return['msg'] . '分配成功！' : $return['msg'] . '分配失败！'; } return $return; } /** * @desc 新增名企 */ function addHotJob($data = array()) { if (!empty($data)) { $uid = intval($data['uid']); if ($data['time_end'] > $data['time_start']) { $value = array( 'uid' => intval($data['uid']), 'username' => trim($data['username']), 'rating' => trim($data['rating']), 'hot_pic' => trim($data['hot_pic']), 'service_price' => intval($data['service_price']), 'time_start' => $data['time_start'], 'time_end' => $data['time_end'], 'sort' => intval($data['sort']), 'beizhu' => trim($data['beizhu']), 'rating_id' => intval($data['rating_id']), 'did' => intval($data['did']) ); $return['id'] = $this -> insert_into('hotjob', $value); if ($return['id']) { $this -> update_once('company',array('hottime' => $data['time_end'], 'rec' => '1','hotstart' => $data['time_start']),array('uid'=>$uid)); $msg = '您的企业已被设置为名企招聘，时间：'.date('Y-m-d',$data['time_start']).'-'.date('Y-m-d',$data['time_end']); //发送系统通知 include_once('sysmsg.model.php'); $sysmsgM = new sysmsg_model($this->db, $this->def); $sysmsgM -> addInfo(array('uid'=>$uid,'usertype'=>2, 'content'=>$msg)); } $return['msg'] = '名企招聘(ID:'.$return['id'].')'; $return['errcode'] = $return['id'] ? '9' :'8'; $return['msg'] = $return['id'] ? $return['msg'].'设置成功！' : $return['msg'].'设置失败！'; }else{ $return['msg'] = '名企结束时间必须大于开始时间！'; $return['errcode'] = 8; } return $return; } } /** * @desc 修改名企招聘 */ function upHotJob($id, $data = array()) { if (!empty($id)){ $id = intval($id); $uid = intval($data['uid']); $hot = $this -> getHotJob(array('id'=>$id),array('field'=>'`hot_pic`')); if ($data['time_end'] > $data['time_start']) { $value = array( 'uid' => intval($data['uid']), 'username' => trim($data['username']), 'rating' => trim($data['rating']), 'service_price' => intval($data['service_price']), 'time_start' => $data['time_start'], 'time_end' => $data['time_end'], 'sort' => intval($data['sort']), 'beizhu' => trim($data['beizhu']), 'rating_id' => intval($data['rating_id']), 'did' => intval($data['did']) ); if (!empty($data['hot_pic'])) { $value['hot_pic'] = $data['hot_pic']; } $return['id'] = $this -> update_once('hotjob',$value, array('uid'=>$id)); if ($return['id']) { $this -> update_once('company',array('hottime' => $data['time_end'], 'rec' => '1','hotstart' =>$data['time_start']),array('uid'=>$uid)); $msg = '您的企业已被设置为名企招聘，时间：'.date('Y-m-d',$data['time_start']).'-'.date('Y-m-d',$data['time_end']); //发送系统通知 include_once('sysmsg.model.php'); $sysmsgM = new sysmsg_model($this->db, $this->def); $sysmsgM -> addInfo(array('uid'=>$uid,'usertype'=>2, 'content'=>$msg)); } $return['msg'] = '名企招聘(ID:'.$return['id'].')'; $return['errcode'] = $return['id'] ? '9' :'8'; $return['msg'] = $return['id'] ? $return['msg'].'设置成功！' : $return['msg'].'设置失败！'; }else { $return['msg'] = '名企结束时间必须大于开始时间！'; $return['errcode'] = 8; } }else{ $return['msg'] = '系统繁忙！'; $return['errcode'] = 8; } return $return; } /** * @desc 查询hotjob表，单条 */ function getHotJob($whereData = array(), $data = array()) { $select = $data['field'] ? $data['field'] : '*'; $info = $this -> select_once('hotjob', $whereData, $select); if (!empty($info)) { if($info['hot_pic']){ $info['hot_pic_n'] = checkpic($info['hot_pic']); }else{ $company = $this->getInfo($whereData['uid'],array('logo'=>1,'utype'=>'admin','field'=>'`uid`,`logo`')); $info['hot_pic_n'] = $company['logo']; } } return $info; } /** * @desc 查询hotjob表，多条 */ function getHotJobList($whereData = array(), $data = array('utype'=>'')) { $select = $data['field'] ? $data['field'] : '*'; $List = $this -> select_all('hotjob', $whereData, $select); if (!empty($List)) { if ($data['utype'] == 'admin') { $List = $this -> getHotAList($List); } if ($data['utype'] == 'wxapp') { $List = $this -> getHotWList($List); } } return $List; } /** * @desc 名企信息完善 */ private function getHotAList($list) { foreach ($list as $k => $v){ if(mb_strlen($v['username']) > 12){ $list[$k]['username'] = mb_substr($v['username'],'0','12','utf-8').'...'; } if(mb_strlen($v['beizhu']) > 12){ $list[$k]['beizhu'] = mb_substr($v['beizhu'],'0','12','utf-8').'...'; } if($v['did']<1){ $list[$k]['did'] = 0; } $list[$k]['hot_pic'] = checkpic($v['hot_pic']); } return $list; } /** * @desc 小程序名企信息完善 * @param $list * @return */ private function getHotWList($list) { foreach ($list as $v){ $uid[]=$v['uid']; } $com = $this->select_all('company',array('uid'=>array('in',pylode(',', $uid))),'`uid`,`name`,`shortname`'); $hjwhere['uid'] = array('in',pylode(',', $uid)); $hjwhere['state'] = 1; $hjwhere['status'] = 0; $hjwhere['r_status'] = 1; if ((int)$this->config['sy_datacycle'] > 0){ $hjwhere['lastupdate'] = array('>', strtotime('- '.$this->config["sy_datacycle"].' day')); } $hjwhere['groupby'] = 'uid'; $hjrows = $this->select_all('company_job',$hjwhere,'count(*) as num,uid'); foreach ($list as $k => $v){ $list[$k]['hot_pic'] = checkpic($v['hot_pic'],$this->config['sy_unit_icon']); foreach ($com as $val){ if ($v['uid'] == $val['uid']){ if($val['shortname']){ $list[$k]['name'] = $val['shortname']; }else{ $list[$k]['name'] = $val['name']; } } } $list[$k]['jobnum'] = 0; foreach ($hjrows as $val){ if ($v['uid'] == $val['uid']){ $list[$k]['jobnum'] = $val['num']; } } } return $list; } /** * @desc 删除名企操作 * @param array $whereData */ public function delHotJob($uid = null) { if(!empty($uid)){ $where = array('uid'=>array('in', pylode(',', $uid))); $result = $this -> delete_all('hotjob', $where, ''); if ($result) { $this -> update_once('company',array('hottime'=>' ','rec'=>'0'),$where); $msg = '管理员设置：名企招聘已取消'; //发送系统通知 include_once('sysmsg.model.php'); $sysmsgM = new sysmsg_model($this->db, $this->def); $sysmsgM -> addInfo(array('uid'=>$uid,'usertype'=>2, 'content'=>$msg)); } } return $result; } /** * 查询企业产品信息 * @param 表：company_product，company * @param 功能说明：获取company_product表里面所有店铺信息 * @param 引用字段：$whereData：条件 2:$data:查询字段 * */ public function getCompanyProductList($whereData,$data=array()){ $CpNew = array(); $field = $data['field'] ? $data['field'] : '*'; $CpList = $this -> select_all('company_product',$whereData,$field); foreach($CpList as $val){ $uids[] = $val['uid']; } if(!empty($CpList) && $CpList){ $companywhere['uid'] = array('in', pylode(',', $uids)); $ListCA = $this -> getList($companywhere); $companyList = $ListCA['list']; foreach($CpList as $key=>$val){ $CpList[$key]['pic'] = checkpic($val['pic']); foreach($companyList as $v){ if($val['uid']==$v['uid']){ $CpList[$key]['name'] = $v['name']; } } } } return $CpList; } /** * 查询单条信息 * @param 查询表：company_product * @param 功能说明：根据条$where条件 获取company_product表里面 单条信息 * @param 引用字段：$where :条件 2:$data:查询字段 */ public function getComProductInfo($where = array(),$data=array()){ if(!empty($where)){ $select = $data['field'] ? $data['field'] : '*'; $info = $this -> select_once('company_product', $where, $select); if(!empty($info)){ $info['pic'] = checkpic($info['pic']); } } return $info; } /** * 更新审核功能 * @param 查询表：company_product * @param 功能说明：根据条$id 获取company_product表里面 单条信息 * @param 引用字段：$id :条件 2:$data:查询字段 * @param lockInfo:审核说明 * */ public function upCompanyProductStatus($id,$data = array()){ $where = array(); if(!empty($id)){ $where['id'] = array('in',pylode(',',$id)); $updata = array( 'status' => $data['status'], 'statusbody' => $data['statusbody'], ); } $nid = $this -> update_once('company_product', $updata, $where); return $nid; } /** * 删除信息 * @param 表：company_product * @param 功能说明：根据条件$id 删除company_product表里面信息 * @param 引用字段：$id :条件 2:$data:字段 * */ public function delCompanyProduct($id,$data=array()){ if(!empty($id)){ if(is_array($id)){ $ids = $id; $return['layertype'] = 1; }else{ $ids = @explode(',', $id); $return['layertype'] = 0; } $id = pylode(',', $ids); if($data['utype'] == 'user'){ $delWhere = array('id' => array('in',$id),'uid'=>$data['uid']); }else{ $delWhere = array('id' => array('in',$id)); } $return['id'] = $this -> delete_all('company_product',$delWhere,''); if($return['id']){ $return['msg'] = $data['utype'] == 'user' ? '删除成功' : '企业产品(ID:'.pylode(',', $id).')删除成功'; $return['errcode'] = '9'; } else{ $return['msg'] = $data['utype'] == 'user' ? '删除失败' : '企业产品(ID:'.pylode(',', $id).')删除失败'; $return['errcode'] = '8'; } }else{ $return['msg'] = '系统繁忙'; $return['errcode'] = '8'; $return['layertype'] = '1'; } return $return; } /** * 更新company_product功能 * @param 查询表：company_product * @param 功能说明：根据条$whereData 获取company_product表里面 单条信息 * @param 引用字段：$whereData :条件 2:$data:查询字段 * */ public function upCompanyProduct($whereData,$data = array()){ if(!empty($whereData)){ $updata = array( 'title' => $data['title'], 'uid' => $data['uid'], 'did' => $data['did'], 'body' => str_replace('&','&',$data['body']), 'ctime' => $data['ctime'], 'statusbody'=> $data['statusbody'], 'status' => $data['status'] ); if($data['pic']){ $updata['pic'] = $data['pic']; } } $nid = $this -> update_once('company_product', $updata, $whereData); return $nid; } /** * 添加company_product功能 * @param 查询表：company_product * @param 引用字段：$data:操作字段 * */ public function addCompanyProduct($data = array()){ if(!empty($data)){ $addata = array( 'title' => $data['title'], 'uid' => $data['uid'], 'did' => $data['did'], 'body' => str_replace('&','&',$data['body']), 'ctime' => $data['ctime'], 'pic' => $data['pic'], 'statusbody'=> $data['statusbody'], 'status' => $data['status'] ); } $nid = $this -> insert_into('company_product', $addata); return $nid; } /** * 保存company_product * @param 表：company_product * */ public function setCompanyProduct($whereData,$data=array(),$usertype){ if ($data['file']['tmp_name'] || $data['base']){ $upArr = array( 'file' => $data['file'], 'dir' => 'product', 'base' => $data['base'], 'preview' => $data['preview'] ); $result = $this -> upload($upArr); if (!empty($result['msg'])){ $return['msg'] = $result['msg']; $return['errcode'] = '8'; return $return; }elseif (!empty($result['picurl'])){ $picurl = $result['picurl']; } } unset($data['file']); unset($data['base']); unset($data['preview']); if (isset($picurl)){ $data['pic'] = $picurl; } if(!empty($whereData)){ $nid = $this->upCompanyProduct($whereData,$data); $msg = '修改'; $type = '2'; }else{ if(!isset($picurl)){ $return['msg'] = '请上传图片！'; $return['errcode'] = 8; return $return; } $nid = $this->addCompanyProduct($data); $msg = '添加'; $type = '1'; } if($nid){ $this -> addMemberLog($data['uid'],$usertype,$msg.'企业产品',16,$type); $return['msg'] = '操作成功！'; $return['errcode'] = 9; $return['url'] = 'index.php?c=product'; }else{ $return['msg'] = '操作失败，请稍后再试！'; $return['url'] = 'index.php?c=product'; } return $return; } //企业新闻 /** * 查询企业新闻信息 * @param 表：company_news，company * @param 功能说明：获取ccompany_news表里面所有店铺信息 * @param 引用字段：$whereData：条件 2:$data:查询字段 * */ public function getCompanyNewsList($whereData,$data=array()){ $field = $data['field'] ? $data['field'] : '*'; $CnewsList = $this -> select_all('company_news',$whereData,$field); foreach($CnewsList as $val){ $uids[] = $val['uid']; } if(!empty($CnewsList) && $CnewsList){ $companywhere['uid'] = array('in', pylode(',', $uids)); $ListCA = $this -> getList($companywhere); $companyList = $ListCA['list']; foreach($CnewsList as $key=>$val){ foreach($companyList as $v){ if($val['uid']==$v['uid']){ $CnewsList[$key]['name'] = $v['name']; } } } } return $CnewsList; } /** * 查询单条信息(审核说明) * @param 查询表：company_news * @param 功能说明：根据条$id 获取company_news表里面 单条信息 * @param 引用字段：$id :条件 2:$data:查询字段 * @param lockInfo:审核说明 * */ public function getCompanyNewsLockInfo($id,$data=array()){ if(!empty($id)){ $select = $data['field'] ? $data['field'] : '*'; $CnewsLock = $this -> select_once('company_news', array('id'=>intval($id)), $select); } return $CnewsLock; } /** * 查询单条信息(审核说明) * @param 查询表：company_news * @param 功能说明：根据条$id 获取company_news表里面 单条信息 * @param 引用字段：$id :条件 2:$data:查询字段 * @param lockInfo:审核说明 * */ public function getCompanyNewsInfo($whereData,$data=array()){ if(!empty($whereData)){ $select = $data['field'] ? $data['field'] : '*'; $info = $this -> select_once('company_news', $whereData, $select); } return $info; } /** * 删除信息 * @param 表：company_product * @param 功能说明：根据条件$id 删除company_product表里面信息 * @param 引用字段：$id :条件 2:$data:字段 * */ public function delCompanyNews($id,$data=array()){ if(!empty($id)){ if(is_array($id)){ $ids = $id; $return['layertype'] = 1; }else{ $ids = @explode(',', $id); $return['layertype'] = 0; } $id = pylode(',', $ids); if($data['utype'] == 'user'){ $delWhere = array('id' => array('in',$id),'uid'=>$data['uid']); }else{ $delWhere = array('id' => array('in',$id)); } $return['id'] = $this -> delete_all('company_news',$delWhere,''); if($return['id']){ $this -> addMemberLog($data['uid'],$data['usertype'],'删除企业新闻',16,3); $return['msg'] = $data['utype'] == 'user' ? '删除成功' : '企业新闻(ID:'.pylode(',', $id).')删除成功'; $return['errcode'] = '9'; } else{ $return['msg'] = $data['utype'] == 'user' ? '删除失败' : '企业新闻(ID:'.pylode(',', $id).')删除失败'; $return['errcode'] = '8'; } }else{ $return['msg'] = '系统繁忙'; $return['errcode'] = '8'; $return['layertype'] = '0'; } return $return; } /** * 更新审核功能 * @param 查询表：company_news * @param 功能说明：根据条$id 获取company_news表里面 单条信息 * @param 引用字段：$id :条件 2:$data:查询字段 * @param lockInfo:审核说明 * */ public function upCompanyNewsStatus($id,$data = array()){ $where = array(); if(!empty($id)){ $where['id'] = array('in',pylode(',',$id)); $updata = array( 'status' => $data['status'], 'statusbody' => $data['statusbody'], ); } $nid = $this -> update_once('company_news', $updata, $where); return $nid; } /** * 更新company_news功能 * @param 查询表：company_news * @param 功能说明：根据条$whereData 获取company_news表里面 单条信息 * @param 引用字段：$whereData :条件 2:$data:查询字段 * */ public function upCompanyNews($whereData,$data = array()){ if(!empty($whereData)){ $updata = array( 'title' => $data['title'], 'body' => str_replace('&','&',$data['body']), 'ctime' => $data['ctime'], 'status' => $data['status'] ); } $nid = $this -> update_once('company_news', $updata, $whereData); return $nid; } /** * 添加company_news功能 * @param 查询表：company_news * @param 功能说明：根据条$whereData 获取company_news表里面 单条信息 * @param 引用字段：$data:操作字段 * */ public function addCompanyNews($data = array()){ if(!empty($data)){ $addata = array( 'title' => $data['title'], 'uid' => $data['uid'], 'did' => $data['did'], 'body' => str_replace('&','&',$data['body']), 'ctime' => $data['ctime'], 'status' => $data['status'] ); } $nid = $this -> insert_into('company_news', $addata); return $nid; } /** * 保存company_news * @param 表：company_news * */ public function setCompanyNews($whereData,$data=array()){ if(!empty($data['body'])){ if($this->config['sy_outlinks']!=1){ $patten = array("\r\n", "\n", "\r"); $patea = "/]*>(.*?)<\/a>/is";//匹配a标签 $patet = "/href=\"(.*)\"/";//取a标签的值 $pateh = '//is'; $content = str_replace($patten, "
", $data['body']); $str = htmlspecialchars_decode($content); $data['body'] = preg_replace($patea,"$1", $str); } } if(!empty($whereData)){ $nid = $this->upCompanyNews($whereData,$data); $msg = '修改'; $type = '2'; }else{ $nid = $this->addCompanyNews($data); $msg = '添加'; $type = '1'; } if($nid){ if(!$data['uid']){ $data['uid'] = $whereData['uid']; } $this -> addMemberLog($data['uid'],$data['usertype'],$msg.'企业新闻',16,$type); $return['msg'] = '操作成功！'; $return['errcode'] = 9; }else{ $return['msg'] = '操作失败，请稍后再试！'; $return['errcode'] = 8; } return $return; } /** * 查询面试评价信息 * @param 表：company_msg，company，resume * @param 功能说明：获取company_msg表里面所有店铺信息 * @param 引用字段：$whereData：条件 2:$data:查询字段 * */ public function getCompanyMsgList($whereData,$data=array()){ if($this -> config['com_msg_status'] =='1' || $data['utype'] == 'admin'){ require_once ('resume.model.php'); $resumeM = new resume_model($this->db, $this->def); $field = $data['field'] ? $data['field'] : '*'; $CompanyMsgList = $this -> select_all('company_msg',$whereData,$field); foreach($CompanyMsgList as $val){ //个人uid 表：resume 调用：resume.model.php $uids[] = $val['uid']; //企业uid 表：company 调用 company.model.php $cuids[] = $val['cuid']; $jobids[] = $val['jobid']; } if(!empty($CompanyMsgList) && $CompanyMsgList){ $resumewhere['uid'] = array('in', pylode(',', $uids)); $resumeList = $resumeM -> getResumeList($resumewhere,array('utype'=>$data['utype'])); $companywhere['uid'] = array('in', pylode(',', $cuids)); $ListCA = $this -> getList($companywhere); $companyList = $ListCA['list']; $comjoblist = $this->select_all('company_job',array('id'=>array('in',pylode(',',$jobids))) , '`id`,`name`'); if(is_array($comjoblist)){ foreach($comjoblist as $vv){ $msgJob[$vv['id']]= $vv['name']; } } foreach($CompanyMsgList as $key=>$val){ $CompanyMsgList[$key]['comscorepf'] = round($val['comscore']/5 * 100,2); $CompanyMsgList[$key]['hrscorepf'] = round($val['hrscore']/5 * 100,2); $CompanyMsgList[$key]['desscorepf'] = round($val['desscore']/5 * 100,2); $CompanyMsgList[$key]['ctime_n'] = date('Y-m-d',$val['ctime']); foreach($companyList as $v){ if($val['cuid']==$v['uid']){ $CompanyMsgList[$key]['com_name'] = $v['name']; } } foreach($resumeList as $v){ if($val['uid'] == $v['uid']){ if($data['utype'] == 'admin'){ $CompanyMsgList[$key]['username'] = $v['username_n']; }else{ $CompanyMsgList[$key]['username'] = $val['isnm']==1?'匿名':mb_substr($v['username_n'],0,1)."**"; } $CompanyMsgList[$key]['name'] = $v['name']; $CompanyMsgList[$key]['photo'] = $v['photo']; $CompanyMsgList[$key]['eid'] = $v['def_job']; } } if($val['tag']){ $cache = $this->getClass(array('com')); $taglist = explode(',',$val['tag']); $tags = array(); foreach($taglist as $v){ $tags[] = $cache['comclass_name'][$v]; } $CompanyMsgList[$key]['tags'] = $tags; } $CompanyMsgList[$key]['jobname'] = $msgJob[$val['jobid']]?$msgJob[$val['jobid']] :'职位已下架'; } } } return $CompanyMsgList; } /** * @desc 查询单条信息(面试评价), 查询表：company_msg, 功能说明：根据条件 获取company_msg表里面 单条信息 * * @param 引用字段：$whereData :条件 2:$data:查询字段 */ public function getCompanyMsgInfo($whereData,$data=array()){ if(!empty($whereData)){ $select = $data['field'] ? $data['field'] : '*'; $Info = $this -> select_once('company_msg', $whereData, $select); if(!empty($Info)){ $rinfo = $this->select_once('resume',array('uid'=>$Info['uid']),'`name`'); $Info['name'] = $rinfo['name']; if($Info['isnm']==1){ $Info['name_n'] = '匿名'; }else{ $Info['name_n'] = mb_substr($rinfo['name'],0,1).'**'; } if($Info['ctime']){ $Info['ctime_n'] = date('Y-m-d H:i',$Info['ctime']); } if($Info['tag']){ $Info['tag_n'] = @explode(',',$Info['tag']); } } } return $Info; } function statusComment($whereData=array(),$data=array()){ if (!empty($whereData)) { $post = $data['post']; $up = array('status' => $post['status'],'statusbody'=>$post['statusbody']); // 保存审核信息 $nid = $this->update_once('company_msg',$up,$whereData); if ($nid) { $uids = array(); $msgs = $this->select_all('company_msg',$whereData); foreach ($msgs as $key => $value) { $uids[] = $value['uid']; } $statusInfo = ''; //处理审核信息 if($post['status'] == 1){ $statusInfo = '审核通过！'; }elseif($post['status'] == 2){ $statusInfo = '审核未通过，'; if($post['statusbody']){ $statusInfo .= '原因：'.$post['statusbody']; } } //发送系统通知 include_once('sysmsg.model.php'); $sysmsgM = new sysmsg_model($this->db, $this->def); $statusInfo = '您的面试评价'.$statusInfo; $sysmsgM -> addInfo(array('uid'=>$uids,'content'=>$statusInfo,'usertype' =>1)); $return['msg'] = '面试评价审核设置成功'; $return['errcode'] = '9'; } else { $return['msg'] = '面试评价审核设置失败'; $return['errcode'] = '8'; } } return $return; } /** * @desc 查询company_msg 数目 * @param array $Where * @return number */ function getCompanyMsgNum($Where = array()){ return $this -> select_num('company_msg', $Where); } /** * @desc 查询company_msg 数目 * @param array $Where * @return number */ function addCompanyMsg($data){ $id=intval($data['id']); if($id){ //验证信息 $msg = $this->select_once('userid_msg',array('id'=>$id,'uid'=>$data['uid'],'is_browse'=>3)); if(!empty($msg)){ //查询是否已经评论过 $msgInfo = $this->getCompanyMsgInfo(array('msgid'=>$msg['id'])); $desscore = (int)$data['desscore']; $hrscore = (int)$data['hrscore']; $comscore = (int)$data['comscore']; $content = $data['content']; $othercontent = $data['othercontent']; if($desscore<1 || $hrscore<1 || $comscore<1 || !$content){ return array('errcode'=>8,'msg'=>'请完整填写评论信息！'); }else{ //计算综合评分 $score = round(($desscore+$hrscore+$comscore)/3,1); if($data['tag']){ $cache = $this->getClass(array('com')); $tags = explode(',',$data['tag']); foreach($tags as $v){ if($cache['comclass_name'][$v]){ $tagsList[] = $v; } } $tag = pylode(',',$tagsList); } $cdata = array( 'uid' => $data['uid'], //求职ID 'cuid' => $msg['fid'], //企业ID 'ctime' => time(), //评论时间 'jobid' => $msg['jobid'], //面试职位 'desscore' => $desscore, //描述评分 'hrscore' => $hrscore, //面试官评分 'comscore' => $comscore, //企业环境评分 'score' => $score, //综合评分 'status' => $this->config['com_comment_status'], 'did' => $data['did'], 'content' => $content, //面试过程 'othercontent' => $othercontent, //其他评价 'tag' => $tag, //印象标签 'msgid' => $msg['id'], //邀请面试id 'isnm' => (int)$data['isnm'] //是否匿名 ); if(!empty($msgInfo)){ $this->update_once('company_msg',$cdata, array('id' => $msgInfo['id'])); return array('errcode'=>9,'msg'=>'面试评价修改成功！'); }else{ $this->insert_into('company_msg',$cdata); return array('errcode'=>9,'msg'=>'面试评价成功！'); } } }else{ return array('errcode'=>8,'msg'=>'暂不符合评论条件！'); } }else{ return array('errcode'=>8,'msg'=>'请选择正确的信息！'); } } /** * @desc 企业回复面试评价 */ public function upReplyCompanymsgInfo($whereData, $data = array()){ if(!empty($whereData)) { $PostData = array( 'reply' => $data['reply'], 'reply_time' => $data['reply_time'], ); $nid = $this -> update_once('company_msg', $PostData, array('id'=>$whereData['id'],'cuid'=>$whereData['cuid'])); } return $nid; } /** * 删除面试评价 * @param 表：company_msg * @param 功能说明：根据条件$id 删除company_msg表里面信息 * @param 引用字段：$id :条件 2:$data:字段 * */ public function delCompanyMsg($id,$data=array()){ if(!empty($id)){ if(is_array($id)){ $ids = $id; $return['layertype'] = 1; }else{ $ids = @explode(',', $id); $return['layertype'] = 0; } $id = pylode(',', $ids); $return['id'] = $this -> delete_all('company_msg',array('id' => array('in',$id)),''); if($return['id']){ $return['msg'] = '面试评价(ID:'.pylode(',', $id).')删除成功'; $return['errcode'] = '9'; } else{ $return['msg'] = '面试评价(ID:'.pylode(',', $id).')删除失败'; $return['errcode'] = '8'; } }else{ $return['msg'] = '系统繁忙'; $return['errcode'] = '8'; $return['layertype'] = '1'; } return $return; } /** * 添加company_show功能 * @param 查询表：company_show * @param 功能说明：根据条$whereData 获取company_news表里面 单条信息 * @param 引用字段：$data:操作字段 * */ public function addCompanyshow($data = array()){ if(!empty($data)){ $addata = array( 'title' => $data['title'], 'uid' => $data['uid'], 'sort' => $data['sort'], 'body' => $data['body'], 'ctime' => $data['ctime'], 'status' => $data['status'], 'picurl' => $data['picurl'] ); } $nid = $this -> insert_into('company_show', $addata); return $nid; } /** * @desc 查询/企业环境图片 * @param 表：company_show，company * @param 功能说明：获取company_show表里面所有企业环境信息 * @param 引用字段：$whereData：条件 2:$data:查询字段 */ public function getCompanyShowList($whereData,$data=array()){ $field = $data['field'] ? $data['field'] : '*'; $CompanyShowList = $this -> select_all('company_show',$whereData,$field); foreach($CompanyShowList as $val){ $uids[] = $val['uid']; } if(!empty($CompanyShowList) && $CompanyShowList){ $companyList = array(); if(!empty($uids)){ $ListCA = $this -> getList(array('uid'=>array('in', pylode(',', $uids)))); $companyList = $ListCA['list']; } foreach($CompanyShowList as $key => $val){ $CompanyShowList[$key]['picurl'] = checkpic($val['picurl']); foreach($companyList as $v){ if($val['uid']==$v['uid']){ $CompanyShowList[$key]['name'] = $v['name']; } } } } return $CompanyShowList; } /** * @desc 查询/企业环境图片(单张图片) * @param 表：company_show，company * @param 功能说明：获取company_show表里面根据id获取企业环境信息 * @param 引用字段：$id：条件 2:$data:查询字段 */ public function getCompanyShowInfo($id,$data=array()){ if(!empty($id)){ $where['id'] = $id; if($data['uid']){ $where['uid'] = $data['uid']; } $select = $data['field'] ? $data['field'] : '*'; $companyShowInfo = $this -> select_once('company_show', $where, $select); }elseif($data['where']){ $select = $data['field'] ? $data['field'] : '*'; $companyShowInfo = $this -> select_once('company_show', $data['where'], $select); } if(!empty($companyShowInfo)){ if($data['type']=='showpic'){ $companyShowInfo['picurl'] = checkpic($companyShowInfo['picurl']); } } return $companyShowInfo; } /** * @desc 删除企业环境图片操作 * @param $id * @param array $data * @return bool */ public function delCompanyShow($id, $data = array()) { if (!empty($id)) { if ($data['utype'] == 'admin') { $where = array(); } else { $where = array('uid' => $data['uid']); } if (is_array($id)) { $where['id'] = array('in', pylode(',', $id)); } else { $where['id'] = intval($id); } $result = $this->delete_all('company_show', $where, ''); }else{ $result = false; } return $result; } /** * @desc 删除企业环境图片操作 * @param array $whereData */ public function delComshowInfo($whereData=array(),$data = array()){ $row = $this -> getCompanyShowInfo($whereData['id']); if(is_array($row)){ $oid = $this -> delete_all('company_show', array('id'=>$whereData['id'],'uid'=>$whereData['uid']),''); if($oid){ $this -> addMemberLog($whereData['uid'],$whereData['usertype'],'删除企业环境展示',16,3); } } return $oid; } /** * @desc 更新企业环境图片操作 * @param array $whereData */ public function upCompanyShow($id,$data = array()){ if (!empty($id)) { if (is_array($id)) { $where['id'] = array('in' , pylode(',' , $id)); } else { $where['id'] = intval($id); } if($data['uid']){ $where['uid'] = $data['uid']; } $nid = $this -> update_once('company_show', $data, $where); } return $nid; } /** * @desc 查询company_show 数量 */ public function getComShowNum($whereData = array()){ return $this -> select_num('company_show', $whereData); } /** * @desc 查询//企业横幅 * @param 表：banner，company * @param 功能说明：获取company_show表里面所有/企业横幅信息 * @param 引用字段：$whereData：条件 2:$data:查询字段 */ public function getBannerList($whereData,$data=array()){ $field = $data['field'] ? $data['field'] : '*'; $BannerList = $this -> select_all('banner',$whereData,$field); foreach($BannerList as $val){ $uids[] = $val['uid']; } if(!empty($BannerList) && $BannerList){ $ListCA = $this -> getList(array('uid'=>array('in', pylode(',', $uids)))); $companyList = $ListCA['list']; foreach($BannerList as $key=>$val){ $BannerList[$key]['pic'] = checkpic($val['pic']); foreach($companyList as $v){ if($val['uid']==$v['uid']){ $BannerList[$key]['name'] = $v['name']; } } } } return $BannerList; } /** * 查询/企业横幅图片(单张图片) * @param 表：banner，company * @param 功能说明：获取banner表里面根据id获取企业环境信息 * @param 引用字段：$id：条件 2:$data:查询字段 * */ public function getBannerInfo($id,$data=array()){ if(!empty($id)){ $where['id'] = $id; }elseif($data['where']){ $where = $data['where']; } $select = $data['field'] ? $data['field'] : '*'; $banner = $this -> select_once('banner', $where, $select); if (!empty($banner) && is_array($banner)) { $banner['pic'] = checkpic($banner['pic'],$this->config['sy_banner']); } return $banner; } //5.0 2019-07-23整合企业横幅 /** * $data 自定义数组,uid，usertype,pc：file必要参数 */ public function setBanner($data = array()){ if(!empty($data)){ if ($data['file']['tmp_name'] || $data['base']){ $upArr = array( 'file' => $data['file'], 'dir' => 'company', 'base' => $data['base'], 'preview' => $data['preview'] ); $result = $this -> upload($upArr); if (!empty($result['msg'])){ $return['msg'] = $result['msg']; $return['errcode'] = '8'; return $return; }elseif (!empty($result['picurl'])){ $picurl = $result['picurl']; } } if(isset($picurl)){ $cominfo = $this -> select_once('company',array('uid'=>$data['uid']),'`r_status`'); $valueData = array( 'pic' => $picurl, 'status' => $cominfo['r_status']==0?1:$this->config['com_banner_status'] ); } if($data['type']=='add'){ $member = $this->select_once('member',array('uid'=>$data['uid']),'`did`'); $valueData['did'] = $member['did']; $valueData['uid'] = $data['uid']; $row = $this->getBannerNum(array('uid'=>$data['uid'])); if($row>0){ $return['msg'] = '已有横幅，不能再添加横幅！'; $return['errcode'] = 8; $return['url'] = $_SERVER['HTTP_REFERER']; }else{ $this -> addBanner($valueData); $this -> addMemberLog($data['uid'],$data['usertype'],"上传企业横幅",16,1);//会员日志 require_once ('integral.model.php'); $IntegralM = new integral_model($this->db, $this->def); $IntegralM -> invtalCheck($data['uid'],$data['usertype'],"integral_banner","上传企业横幅"); $return['msg'] = '设置成功！'; $return['errcode'] = 9; $return['url'] = $_SERVER['HTTP_REFERER']; } }else if ($data['type']=='update'){ $whereData['uid'] = $data['uid']; $this -> upBanner("",$valueData,$whereData); $this -> addMemberLog($data['uid'],$data['usertype'],"修改企业横幅",16,2);//会员日志 $return['msg'] = '修改成功！'; $return['errcode'] = 9; $return['url'] = $_SERVER['HTTP_REFERER']; } return $return; } } public function upBanner($id,$data = array(),$where= array()){ if(!empty($id)){ if (is_array($id)) { $where['id'] = array('in' , pylode(',' , $id)); } else { $where['id'] = intval($id); } } $nid = $this -> update_once('banner', $data, $where); return $nid; } /** * @desc 添加企业横幅 */ public function addBanner($data = array()){ $nid = $this -> insert_into('banner', $data); return $nid; } /** * @desc 查询企业横幅数目 * @param array $Where * @return number */ public function getBannerNum($whereData = array()){ return $this->select_num('banner', $whereData); } /** * @desc 删除企业横幅操作 * @param array $whereData */ public function delBanner($id) { if(!empty($id)){ $where = array(); if (is_array($id)) { $where['id'] = array('in' , pylode(',' , $id)); } else { $where['id'] = intval($id); } $result = $this -> delete_all('banner', $where, '', '', ''); } return $result; } /** * @desc 更新企业信息操作 * @param array $whereData * mData member表要修改数据; comData company表要修改数据; sData 后台修改操作数量数据; utype 修改操作类型：admin-后台，user-会员中心; wap 手机站来的(此来源固话有不同) */ public function setCompany($whereData , $data = array('mData' => null, 'comData' => null, 'sData' => null,'utype' => null,'wap'=>null)) { $return = array(); if(!empty($whereData) && is_array($whereData)){ $mData = $data['mData']; $comData = $data['comData']; //修改相应字段检查 $setCheck = $this -> setFieldCheck($whereData['uid'], $comData, $data['wap']); if(!empty($setCheck['msg'])){ $setCheck['errcode'] = 8; return $setCheck; } if (!empty($setCheck['linkphone'])){ $comData['linkphone'] = $setCheck['linkphone']; }else{ $comData['linkphone'] = ''; } //会员操作的修改，需要判断手机号、邮件是否已绑定,企业资质是否已验证，绑定的不能修改 if ($data['utype'] == 'user'){ $comField = '`uid`,`lastupdate`,`moblie_status`,`email_status`,`yyzz_status`,`x`,`y`,`linktel`,`moblie_status`,`crm_uid`,`crm_time`,`provinceid`,`cityid`,`three_cityid`'; $com = $this -> select_once('company',array('uid' => $whereData['uid']), $comField); if($com['linktel'] && $com['moblie_status']=='1'){ $comData['linktel'] = $com['linktel']; } if (!empty($com)){ if ($com['moblie_status'] == '1'){ if (!empty($mData) && $mData['moblie']){ unset($mData['moblie']); } if (!empty($comData) && $comData['moblie']){ unset($comData['moblie']); } } if ($com['email_status'] == '1'){ if (!empty($mData) && $mData['email']){ unset($mData['email']); } if (!empty($comData) && $comData['email']){ unset($comData['email']); } } if ($com['yyzz_status'] == '1'){ if (!empty($comData) && $comData['name']){ unset($comData['name']); } } } if($com['x'] == '' && $com['y'] == ''){ $is_map = 1; } } // 处理会员基本信息 if (!empty($mData)){ require_once ('userinfo.model.php'); $UserinfoM = new userinfo_model($this->db, $this->def); $ckresult = $UserinfoM -> addMemberCheck($mData, $whereData['uid'], $data['utype']); if (isset($ckresult) && $ckresult['msg']){ $ckresult['errcode'] = 8; return $ckresult; } } // 管理员操作的，有操作数量或会员等级，对其进行处理 /**if ($data['utype'] == 'admin' && !empty($data['sData'])){ $this -> setStatisInfo($whereData['uid'], $data['sData']); }*/ // 处理企业基本信息 if (!empty($comData)){ if(!empty($comData['welfare']) && is_array($comData['welfare'])){ $comData['welfare'] = @implode(',',$comData['welfare']); } if(!empty($comData['preview'])){ $upArr = array( 'base' => $comData['preview'], 'dir' => 'company' ); $result = $this -> upload($upArr); if(!empty($result['msg'])){ $return['msg'] = $result['msg']; $return['errcode'] = 8; return $return; }else{ $comData['comqcode'] = $result['picurl']; } unset($comData['preview']); } // wxapp上传二维码 if(!empty($comData['photos'])){ $upArr = array( 'file' => $comData['photos'], 'dir' => 'company' ); $result = $this -> upload($upArr); if(!empty($result['msg'])){ $return['msg'] = $result['msg']; $return['errcode'] = 8; return $return; }else{ $comData['comqcode'] = $result['picurl']; } unset($comData['preview']); } //内容检测 if ($data['utype'] == 'user'){ $pass = $this->infoConCheck($comData,array('uid'=>$whereData['uid'],'usertype'=>2,'source'=>$data['source'])); if(!$pass){ $comData['r_status'] = 0; } } $return['id'] = $this -> update_once('company', $comData, $whereData); if ($return['id']){ //更新company_job $this -> setJobInfo($whereData['uid'], $comData); // 更新之后的企业信息 $comField = '`uid`,`lastupdate`,`moblie_status`,`email_status`,`yyzz_status`,`x`,`y`,`linktel`,`moblie_status`,`crm_uid`,`crm_time`,`provinceid`,`cityid`,`three_cityid`'; $com = $this -> select_once('company',array('uid' => $whereData['uid']), $comField); if ($data['utype'] == 'user'){ require_once ('cookie.model.php'); $cookieM = new cookie_model($this->db, $this->def); $cookieM -> SetCookie('delay', '', time() - 60); //会员日志 $this -> addMemberLog($whereData['uid'], 2, '修改企业信息',7); require_once ('integral.model.php'); $IntegralM = new integral_model($this->db, $this->def); if($is_map == 1 && $com['x']!='' && $com['y']!=''){ $IntegralM -> invtalCheck($whereData['uid'],'2','integral_map','设置企业地图'); } //首次完善基本资料获得积分 if(!empty($com) && $com['lastupdate'] == ''){ $IntegralM -> invtalCheck($whereData['uid'],'2', 'integral_userinfo','首次填写基本资料', 25); //首次完善企业基本资料，发微信红包 require_once 'wxredpack.model.php'; $wxRedPackM = new wxredpack_model($this->db, $this->def); $wxRedPackM -> sendRedPack(array('type'=>'4','uid'=>$whereData['uid'])); $return['integralnum'] = 1; require_once ('statis.model.php'); $statisM = new statis_model($this->db, $this->def); $statis = $statisM -> vipOver($whereData['uid'], 2); $return['addjobnum'] = $statis['addjobnum']; } // 业务员按区域划分分配 if ($this->config['sy_crm_duty'] == '2' && $com['crm_uid'] == 0 && $com['crm_time'] == 0) { require_once ('userinfo.model.php'); $UserinfoM = new userinfo_model($this->db, $this->def); $crm_uid = $UserinfoM -> getCrmUid(array('type' => 2, 'city' => 1, 'provinceid' => $com['provinceid'], 'cityid' => $com['cityid'], 'three_cityid' => $com['three_cityid'])); if ($crm_uid) { $this->update_once('company', array('crm_uid' => $crm_uid, 'crm_time' => time()), array('uid' => $whereData['uid'])); } } /* 资质（企业资质、手机、邮箱、地图设置）认证查询 */ $cert = $this -> getCertInfo(array('uid' => $com['uid'], 'type' => 3), array('field' => 'status')); if (!empty($cert) && is_array($cert)) { $return['yyzz_i'] = $cert['status']; } $return['moblie_i'] = $com['moblie_status']; $return['email_i'] = $com['email_status']; $return['map_i'] = ($com['x'] != '' && $com['y']!='') ? 1 : 0; $return['msg'] = '基本资料修改成功'; }else{ $return['msg'] = '企业会员(ID:'.$whereData['uid'].')基本资料修改成功'; } $return['errcode'] = 9; }else{ if ($data['utype'] == 'user'){ $return['msg'] = '基本资料修改失败'; }else{ $return['msg'] = '企业会员(ID:'.$whereData['uid'].')基本资料修改失败'; } $return['errcode'] = 8; } }else{ $return['msg'] = '没有要修改的企业信息'; $return['errcode'] = 8; } }else{ $return['msg'] = '请选择要修改的企业'; $return['errcode'] = 8; } return $return; } /** * @desc 更新企业补充信息操作 * @param array $whereData * comData company表要修改数据; sData 后台修改操作数量数据; utype 修改操作类型：admin-后台，user-会员中心; wap 手机站来的(此来源固话有不同) */ public function setCompanySideInfo($whereData, $data = array('comData' => null, 'sData' => null,'utype' => null,'wap'=>null)) { $return = array(); if(!empty($whereData) && is_array($whereData)){ $comData = $data['comData']; // 处理企业基本信息 if (!empty($comData)){ if(!empty($comData['welfare']) && is_array($comData['welfare'])){ $comData['welfare'] = @implode(',',$comData['welfare']); } if(!empty($comData['preview'])){ $upArr = array( 'base' => $comData['preview'], 'dir' => 'company' ); $result = $this -> upload($upArr); if(!empty($result['msg'])){ $return['msg'] = $result['msg']; $return['errcode'] = 8; return $return; }else{ $comData['comqcode'] = $result['picurl']; } unset($comData['preview']); } // wxapp上传二维码 if(!empty($comData['photos'])){ $upArr = array( 'file' => $comData['photos'], 'dir' => 'company' ); $result = $this -> upload($upArr); if(!empty($result['msg'])){ $return['msg'] = $result['msg']; $return['errcode'] = 8; return $return; }else{ $comData['comqcode'] = $result['picurl']; } unset($comData['preview']); } //内容检测 if ($data['utype'] == 'user'){ $pass = $this->infoConCheck($comData,array('uid'=>$whereData['uid'],'usertype'=>2,'source'=>$data['source'])); if(!$pass){ $comData['r_status'] = 0; } } $return['id'] = $this -> update_once('company', $comData, $whereData); if ($return['id']){ //更新company_job $this -> setJobInfo($whereData['uid'], $comData); // 更新之后的企业信息 $comField = '`uid`,`lastupdate`,`moblie_status`,`email_status`,`yyzz_status`,`x`,`y`,`linktel`,`moblie_status`,`crm_uid`,`crm_time`,`provinceid`,`cityid`,`three_cityid`'; $com = $this -> select_once('company',array('uid' => $whereData['uid']), $comField); if ($data['utype'] == 'user'){ require_once ('cookie.model.php'); $cookieM = new cookie_model($this->db, $this->def); $cookieM -> SetCookie('delay', '', time() - 60); //会员日志 $this -> addMemberLog($whereData['uid'], 2, '修改企业补充资料信息',7); }else{ $return['msg'] = '企业会员(ID:'.$whereData['uid'].')企业补充信息修改成功'; } $return['errcode'] = 9; }else{ if ($data['utype'] == 'user'){ $return['msg'] = '补充信息修改失败'; }else{ $return['msg'] = '企业会员(ID:'.$whereData['uid'].')补充信息修改失败'; } $return['errcode'] = 8; } }else{ $return['msg'] = '没有要修改的企业信息'; $return['errcode'] = 8; } }else{ $return['msg'] = '请选择要修改的企业'; $return['errcode'] = 8; } return $return; } function infoConCheck($comdata,$data){ require_once('concheck.model.php'); $concheckM = new concheck_model($this->db,$this->def); $check_con =array(); $check_pic =array(); $pass = true; if(isset($comdata['name']) && $comdata['name']!=''){ $check_con['name'] = strip_tags($comdata['name']); } if(isset($comdata['address']) && $comdata['address']!=''){ $check_con['address'] = strip_tags($comdata['address']); } if(isset($comdata['content']) && $comdata['content']!=''){ $check_con['content'] = strip_tags($comdata['content']); } if(isset($comdata['link_man']) && $comdata['link_man']!=''){ $check_con['link_man'] = strip_tags($comdata['link_man']); } if(isset($comdata['linkjob']) && $comdata['linkjob']!=''){ $check_con['linkjob'] = strip_tags($comdata['linkjob']); } if(isset($comdata['shortname']) && $comdata['shortname']!=''){ $check_con['shortname'] = strip_tags($comdata['shortname']); } if(isset($comdata['busstops']) && $comdata['busstops']!=''){ $check_con['busstops'] = strip_tags($comdata['busstops']); } if(isset($comdata['welfare']) && $comdata['welfare']!=''){ $check_con['welfare'] = strip_tags($comdata['welfare']); } $check_con_data = array( 'type' => 'text', 'uid' => $data['uid'], 'usertype' => $data['usertype'], 'ctype' => 4, 'cid' => $data['uid'] ); if(isset($data['source'])){ $check_con_data['source'] = $data['source']; } if(!empty($check_con)){ $cresult = $concheckM->checkContent($check_con,$check_con_data); $code = isset($cresult['code']) ? $cresult['code'] : 0; if ($code != 1) { $pass = false; } } return $pass; } /** * @desc 后台修改企业基本信息时，对企业会员等级和操作数量处理 */ public function setStatisInfo($uid, $sData){ if (!empty($sData['rating'])) { require_once 'statis.model.php'; $statisM = new statis_model($this->db, $this->def); $comRating = $this -> select_once('company_statis', array('uid' => $uid),'`rating`, `job_num`, `breakjob_num`, `down_resume`, `invite_resume`, `zph_num`, `top_num`, `rec_num`, `urgent_num`, `sons_num`, `chat_num`, `spview_num`, `vip_etime`'); $sonList = $this -> select_all('company_account', array('comid' => $uid, 'status' => 1), '`uid`'); $msg = array(); foreach($sData as $key => $value){ if($key == 'job_num' && $value != $comRating[$key]){ $msg[] = " 发布职位数：".$comRating[$key]." -> ".$value; }else if($key == 'breakjob_num' && $value != $comRating[$key]){ $msg[] = " 刷新职位数：".$comRating[$key]." -> ".$value; }else if($key == 'down_resume' && $value != $comRating[$key]){ $msg[] = " 下载简历数：".$comRating[$key]." -> ".$value; }else if($key == 'invite_resume' && $value != $comRating[$key]){ $msg[] = " 邀请面试数：".$comRating[$key]." -> ".$value; }else if($key == 'zph_num' && $value != $comRating[$key]){ $msg[] = " 招聘会报名：".$comRating[$key]." -> ".$value; }else if($key == 'top_num' && $value != $comRating[$key]){ $msg[] = " 职位置顶数：".$comRating[$key]." -> ".$value; }else if($key == 'urgent_num' && $value != $comRating[$key]){ $msg[] = " 紧急招聘数：".$comRating[$key]." -> ".$value; }else if($key == 'rec_num' && $value != $comRating[$key]){ $msg[] = " 职位推荐数：".$comRating[$key]." -> ".$value; }else if($key == 'sons_num' && $value != $comRating[$key]){ $msg[] = " 子账户数：".$comRating[$key]." -> ".$value; }else if($key == 'chat_num' && $value != $comRating[$key]){ $msg[] = " 直聊对象数：".$comRating[$key]." -> ".$value; }else if($key == 'spview_num' && $value != $comRating[$key]){ $msg[] = " 视频面试数：".$comRating[$key]." -> ".$value; }else if($key == 'vip_etime' && $value != $comRating[$key]){ $vEtime = $value ? $value : '不限'; $vRtime = $comRating[$key] ? date('Y-m-d', $comRating[$key]) : '不限'; $msg[] = "会员到期时间：".$vRtime." -> ".$vEtime; } } if(!empty($msg)){ $msgContent = @implode('，', $msg); } //企业会员等级做出了修改 if ($sData['rating'] != $comRating['rating']){ require_once 'rating.model.php'; $ratingM = new rating_model($this->db, $this->def); $rvalue = $ratingM -> ratingInfo($sData['rating'], $uid); $rvalue['job_num'] = $rvalue['job_num'] == $sData['job_num'] ? $rvalue['job_num'] : $sData['job_num']; $rvalue['breakjob_num'] = $rvalue['breakjob_num'] == $sData['breakjob_num'] ? $rvalue['breakjob_num'] : $sData['breakjob_num']; $rvalue['down_resume'] = $rvalue['down_resume'] == $sData['down_resume'] ? $rvalue['down_resume'] : $sData['down_resume']; $rvalue['invite_resume'] = $rvalue['invite_resume'] == $sData['invite_resume'] ? $rvalue['invite_resume'] : $sData['invite_resume']; $rvalue['zph_num'] = $rvalue['zph_num'] == $sData['zph_num'] ? $rvalue['zph_num'] : $sData['zph_num']; $rvalue['rec_num'] = $rvalue['rec_num'] == $sData['rec_num'] ? $rvalue['rec_num'] : $sData['rec_num']; $rvalue['top_num'] = $rvalue['top_num'] == $sData['top_num'] ? $rvalue['top_num'] : $sData['top_num']; $rvalue['urgent_num'] = $rvalue['urgent_num'] == $sData['urgent_num'] ? $rvalue['urgent_num'] : $sData['urgent_num']; $rvalue['chat_num'] = $rvalue['chat_num'] == $sData['chat_num'] ? $rvalue['chat_num'] : $sData['chat_num']; $rvalue['spview_num'] = $rvalue['spview_num'] == $sData['spview_num'] ? $rvalue['spview_num'] : $sData['spview_num']; $rvalue['sons_num'] = $rvalue['sons_num'] == $sData['sons_num'] ? $rvalue['sons_num'] : $sData['sons_num']; $rvalue['vip_etime'] = $rvalue['vip_etime'] == $sData['vip_etime'] ? $rvalue['vip_etime'] : $sData['vip_etime']; $rinfo = $ratingM -> getInfo(array('id'=>$sData['rating']),array('field'=>'`name`,`time_start`,`time_end`,`yh_price`,`service_price`')); $result = $statisM -> upInfo($rvalue, array('uid' => $uid, 'usertype' => 2, 'adminedit' => '1', 'info' => $rinfo)); if (is_array($sonList) && ! empty($sonList)) { $spids = array(); foreach ($sonList as $v) { $spids[] = $v['uid']; } if ($rvalue['rating_type'] == 2) { $sonData = $rvalue; } else { if ($comRating['rating'] == $rvalue['rating'] && isVip($comRating['vip_etime'])) { $sonData = array(); } else { $sonData = array( 'job_num' => 0, 'breakjob_num' => 0, 'down_resume' => 0, 'invite_resume' => 0, 'zph_num' => 0, 'top_num' => 0, 'rec_num' => 0, 'urgent_num' => 0, 'sons_num' => 0, 'chat_num' => 0, 'rating_name' => $rvalue['rating_name'], 'rating_type' => $rvalue['rating_type'], 'vip_etime' => $rvalue['vip_etime'], 'vip_stime' => $rvalue['vip_stime'], 'rating' => $rvalue['rating'] ); } } if (!empty($spids) && !empty($sonData)) { $this->update_once('company_statis', $sonData, array('uid' => array('in', pylode(',', $spids)))); } } $msg = "会员等级：".$comRating['rating_name']." -> ".$rinfo['name']; $msgContent = $msgContent ? $msg.'，'.$msgContent : $msg; } else { $result = $this -> update_once('company_statis', $sData, array('uid' => $uid)); $this -> update_once('company', array('vipetime' => $sData['vip_etime']), array('uid' => $uid)); } if($result){ if(!empty($msgContent)){ require_once ('log.model.php'); $logM = new log_model($this->db, $this->def); $msgContent = '企业（UID：'.$uid.'）修改套餐信息；'.$msgContent; $logM -> addAdminLog($msgContent); $return = array( 'errcode' => '9', 'msg' => '套餐信息更新成功！' ); }else{ $return = array( 'errcode' => '9', 'msg' => '套餐信息未做修改！' ); } }else{ $return = array( 'errcode' => '8', 'msg' => '套餐信息更新失败！' ); } }else{ $return = array( 'errcode' => '8', 'msg' => '参数错误，请重试！' ); } return $return; } /** * @desc 修改企业基本信息同步修改职位相关信息 */ private function setJobInfo($uid, $comData) { $jobField = '`pr`,`mun`,`welfare`,`com_provinceid`,`rating`,`com_name`,`r_status`,`x`,`y`'; $job = $this->select_once('company_job', array('uid' => $uid), $jobField); // 有职位的比较各修改项，有改动的才修改 if (isset($comData['pr'])) { $cjdata['pr'] = $comData['pr']; } if (isset($comData['mun'])){ $cjdata['mun'] = $comData['mun']; } if (isset($comData['rating'])){ $cjdata['rating'] = $comData['rating']; } if (isset($comData['provinceid'])){ $cjdata['com_provinceid'] = $comData['com_provinceid']; } if (isset($comData['r_status'])){ $cjdata['r_status'] = $comData['r_status']; } if(isset($comData['x'])){ $cjdata['x'] = $comData['x']; } if(isset($comData['y'])){ $cjdata['y'] = $comData['y']; } // 如企业名称改变 if (!empty($comData['name'])){ $cjdata['com_name'] = $comData['name']; //修改其他表中的企业名称 $this -> update_once('blacklist',array('com_name'=>$comData['name']),array('c_uid'=>$uid)); $this -> update_once('fav_job',array('com_name'=>$comData['name']),array('com_id'=>$uid)); $this -> update_once('hotjob',array('username'=>$comData['name']),array('uid'=>$uid)); $this -> update_once('msg',array('com_name'=>$comData['name']),array('job_uid'=>$uid)); $this -> update_once('partjob',array('com_name'=>$comData['name']),array('uid'=>$uid)); $this -> update_once('report',array('r_name'=>$comData['name']),array('c_uid'=>$uid)); $this -> update_once('userid_job',array('com_name'=>$comData['name']),array('com_id'=>$uid)); $this -> update_once('wxpub_twtask',array('comname'=>$comData['name']),array('cuid'=>$uid)); } if (!empty($cjdata)){ $this -> update_once('company_job', $cjdata, array('uid'=>$uid)); } } /** * @desc 保存企业基本信息，检查相应字段 */ private function setFieldCheck($uid, $comData, $data = array('wap' => null)){ $return = array(); $comname = $this -> select_once('company', array('name' => $comData['name']), '`uid`'); if($comData['name']==''){ $return['msg'] = '企业全称不能为空！'; }elseif(!empty($comname) && $comname['uid'] != $uid){ $return['msg'] = '企业全称已存在！'; }elseif($comData['hy']==''){ $return['msg'] = '从事行业不能为空！'; }elseif($comData['pr']==''){ $return['msg'] = '企业性质不能为空！'; }elseif($comData['mun']==''){ $return['msg'] = '企业规模不能为空！'; } elseif ($comData['provinceid'] == '') { $return['msg'] = '所在地不能为空！'; } elseif ($comData['address'] == '') { $return['msg'] = '公司地址不能为空！'; } elseif ($comData['linkman'] == '') { $return['msg'] = '联系人不能为空！'; } elseif ($comData['content'] == '') { $return['msg'] = '企业简介不能为空！'; } $mstatus = $this -> select_once('company', array('uid' => $uid), '`moblie_status`'); if($mstatus['moblie_status']!=1){ if($comData['linktel']==''){ if($comData['linkphone']==''){ $return['msg'] = '联系手机和固定电话任填一项！'; } } } if (!empty($return['msg'])){ return $return; } elseif (!empty($comData['linkphone'])){ return array('linkphone'=> $comData['linkphone']); } } /** * 修改企业LOGO * @param array $whereData * @param array $data photo/需上传的图片文件; thumb/已处理好的缩略图; utype/操作的用户类型; base/需上传的base4图片; preview/pc预览即上传 */ public function upLogo($whereData, $data=array('photo'=>null,'thumb'=>null,'utype'=>null,'base'=>null,'preview'=>null)) { if (!empty($whereData['uid'])){ $uid = $whereData['uid']; // logo还需上传的 if ($data['photo'] || $data['base']){ $upArr = array( 'file' => $data['photo'], 'dir' => 'company', 'type' => 'logo' ); if (!empty($data['base'])){ $upArr['base'] = $data['base']; } if (!empty($data['preview'])){ $upArr['preview'] = $data['preview']; } $upArr['watermark'] = 0; $result = $this -> upload($upArr); if (!empty($result['msg'])){ $return['msg'] = $result['msg']; $return['errcode'] = '8'; return $return; }elseif (!empty($result['picurl'])){ $logo = $result['picurl']; } } // 已处理好的logo缩略图 if (!empty($data['thumb'])){ $logo = str_replace('../data','./data',$data['thumb'][1]); } if (!empty($logo)){ // 用户操作，且后台设置用户头像需要审核的 $cominfo = $this -> getInfo($uid,array('field'=>'r_status')); if(empty($cominfo)){ $this->activUser($uid, 2); } if ($data['utype'] == 'user' && $this -> config['com_logo_status'] == 1){ $logo_status = 1; }else if ($data['notoken'] == 1){ $logo_status = 0; }else{ $logo_status = $cominfo['r_status']==0?1:0; } $comData = array('logo'=>$logo); //内容检测 if ($data['utype'] == 'user'){ $pass = $this->infoConCheck($comData,array('uid'=>$uid,'usertype'=>2,'source'=>$data['source'])); if(!$pass){ $logo_status = 1; } } $comData['logo_status'] = $logo_status; $return['id'] = $this->update_once('company',$comData,array('uid'=>$uid)); if ($logo_status == 0){ $this->update_once('company_job',array('com_logo'=>$logo),array('uid'=>$uid)); }else{ $this->update_once('company_job',array('com_logo'=>''),array('uid'=>$uid)); } } if (isset($return['id'])) { // 用户操作的，判断处理logo上传积分 if ($data['utype'] == 'user'){ require_once ('integral.model.php'); $IntegralM = new integral_model($this -> db, $this -> def); $IntegralM -> invtalCheck($uid,'2','integral_avatar','上传LOGO'); $this -> addMemberLog($uid, 2, '上传LOGO', 16, 1); if ($this -> config['com_logo_status'] == 1){ $return['errcode'] = '9'; $return['msg'] = '上传成功，管理员审核后对其他用户开放显示'; }else{ $return['errcode'] = '9'; $return['msg'] = '上传成功'; } }else{ $return['msg'] = '企业LOGO(ID:'.$uid.')修改成功'; $return['errcode'] = '9'; } // pc会员中心预览即上传，处理预览图 if ($data['preview']){ $return['picurl'] = checkpic($logo); } }else{ $return['msg'] = '企业LOGO(ID:'.$uid.')修改失败'; $return['errcode'] = '8'; } }else{ $return['msg'] = '请选择需要修改的用户'; $return['errcode'] = '8'; } return $return; } /** * 修改企业二维码 * @param array $whereData * @param array $data photo/需上传的图片文件; thumb/已处理好的缩略图; utype/操作的用户类型; base/需上传的base4图片; preview/pc预览即上传 */ public function upEwm($whereData,$data=array('photo'=>null,'base'=>null,'preview'=>null)) { if (!empty($whereData['uid'])){ $uid = $whereData['uid']; if ($data['photo'] || $data['base']){ $upArr = array( 'file' => $data['photo'], 'dir' => 'company', 'type' => 'ewm', 'base' => $data['base'], 'preview' => $data['preview'] ); $result = $this -> upload($upArr); if (!empty($result['msg'])){ $return['msg'] = $result['msg']; $return['errcode'] = '8'; return $return; }elseif (!empty($result['picurl'])){ $logo = $result['picurl']; } } if (!empty($logo)){ $cominfo = $this -> getInfo($uid,array('field'=>'uid')); if(empty($cominfo)){ $this->activUser($uid, 2); } $comData = array('comqcode'=>$logo); //内容检测 if ($data['utype'] == 'user'){ $pass = $this->infoConCheck($comData,array('uid'=>$uid,'usertype'=>2)); if(!$pass){ $comData['r_status'] = 0; } } $return['id'] = $this->update_once('company',$comData,array('uid'=>$uid)); } if (isset($return['id'])) { $this -> addMemberLog($uid, 2, '上传二维码', 16, 1); if ($data['preview']){ $return['picurl'] = checkpic($logo); } $return['msg'] = $data['utype'] == 'user' ? '修改成功' : '企业二维码(ID:'.$uid.')修改成功'; $return['errcode'] = '9'; }else{ $return['msg'] = $data['utype'] == 'user' ? '修改失败' : '企业二维码(ID:'.$uid.')修改失败'; $return['errcode'] = '8'; } }else{ $return['msg'] = '请选择需要修改的用户'; $return['errcode'] = '8'; } return $return; } /** * 修改企业相关图片 * @param array $whereData * @param array $data photo/需上传的图片文件; base/需上传的base4图片; preview/pc预览即上传 type/图片类别; dir/上传路径 */ public function upPic($whereData, $data=array('photo'=>null,'base'=>null,'preview'=>null,'type'=>null,'dir'=>null)) { if ($data['photo'] || $data['base']){ $upArr = array( 'file' => $data['photo'], 'dir' => $data['dir'], 'type' => $data['type'], 'base' => $data['base'], 'preview' => $data['preview'] ); $result = $this -> upload($upArr); if (!empty($result['msg'])){ $return['msg'] = $result['msg']; $return['errcode'] = '8'; return $return; }elseif (!empty($result['picurl'])){ $logo = $result['picurl']; } } if ($data['preview']){ $return['picurl'] = checkpic($logo); } return $return; } //设置地图 public function setMap($id,$data=array()){ $return = array('cod'=>8,'url'=>$_SERVER['HTTP_REFERER']); if($id){ if($data){ $row = $this->getInfo($id,array('field'=>'`x`,`y`')); if($row['x'] == '' && $row['y'] == ''){ require_once ('integral.model.php'); $IntegralM = new integral_model($this->db, $this->def); $IntegralM -> invtalCheck($id,'2','integral_map','设置企业地图'); } $updata['x'] = (float)$data['xvalue']; $updata['y'] = (float)$data['yvalue']; $return['id'] = $this -> update_once('company', $updata, array('uid'=>$id)); if($return['id']){ require_once ('log.model.php'); $logM = new log_model($this->db, $this->def); $logM -> member_log('设置企业地图',15);//会员日志 $this -> update_once('company_job',array('x'=>$updata['x'],'y'=>$updata['y']),array('uid'=>$id)); $return['msg'] = '地图设置成功！'; if($data['type']=='wap'){ $return['url'] = 'index.php?c=set'; }else{ $return['url'] = 'index.php?c=map'; } $return['cod'] = 9; }else{ $return['msg'] = '地图设置失败！'; } }else{ $return['msg'] = '请设置企业地图！'; } }else{ $return['msg'] = '系统繁忙！'; } return $return; } /** * 解除绑定 moblie、email、sina、QQ、wx * @param 表：member、company、resume、lt_info、px_train * @param 功能说明：更新company、resume、lt_info、px_train，更新member绑定状态 * @param 参数：data:解除参数、id：uid * */ public function delBd($id, $data = array()){ $return = array(); if(!empty($id)) { if($data['type']=='moblie'){ $nid = $this -> update_once('resume',array('moblie_status'=>'0'),array('uid'=>$id)); // 解除手机绑定，简历重置未审核 include_once('resume.model.php'); $resumeM = new resume_model($this->db, $this->def); $nid = $resumeM->setExpectState(array('state'=>'0'),array('uid'=>$id)); $nid = $this -> update_once('company', array('moblie_status'=>'0'), array('uid'=>$id)); $nid = $this -> update_once('lt_info',array('moblie_status'=>'0'),array('uid'=>$id)); $nid = $this -> update_once('px_train',array('moblie_status'=>'0'),array('uid'=>$id)); $nid = $this -> update_once('member',array('moblie_status'=>'0'),array('uid'=>$id)); if ($nid) { $this -> addMemberLog($id, $data['usertype'], "解除手机绑定", 12 ); } } if($data['type']=='email'){ $nid = $this -> update_once('resume',array('email_status'=>'0'),array('uid'=>$id)); $nid = $this -> update_once('company', array('email_status'=>'0'), array('uid'=>$id)); $nid = $this -> update_once('lt_info',array('email_status'=>'0'),array('uid'=>$id)); $nid = $this -> update_once('px_train',array('email_status'=>'0'),array('uid'=>$id)); $nid = $this -> update_once('member',array('email_status'=>'0'),array('uid'=>$id)); if ($nid) { $this -> addMemberLog($id, $data['usertype'], "解除邮箱绑定", 12 ); } } if($data['type']=='qqid' || $data['type']=='qq'){ $nid = $this -> update_once('member',array('qqid'=>'','qqunionid'=>''),array('uid'=>$id)); if ($nid) { $this -> addMemberLog($id, $data['usertype'], "解除QQ绑定", 12 ); } } if($data['type']=='sinaid' || $data['type']=='sina'){ $nid = $this -> update_once('member',array('sinaid'=>''),array('uid'=>$id)); if($nid){ $this -> addMemberLog($id, $data['usertype'], "解除新浪微博绑定", 12 ); } } if($data['type']=='wxid' || $data['type']=='weixin'){ $nid = $this -> update_once('member', array('wxid'=>'', 'wxopenid'=>'', 'unionid'=>'','app_wxid'=>''), array('uid'=>$id)); if($nid){ $this -> addMemberLog($id, $data['usertype'], "解除微信公众号绑定", 12 ); } } if($data['type'] == 'baidu'){ $nid = $this -> update_once('member', array('bdopenid'=>''), array('uid'=>$id)); if($nid){ $this -> addMemberLog($id, $data['usertype'], "解除百度绑定", 12 ); } } if($data['type']=='maguid'){ $nid = $this -> update_once('member',array('maguid'=>''),array('uid'=>$id)); if ($nid) { $this -> addMemberLog($id, $data['usertype'], "解除马甲绑定", 12 ); } } if($data['type']=='qfyuid'){ $nid = $this -> update_once('member',array('qfyuid'=>''),array('uid'=>$id)); if ($nid) { $this -> addMemberLog($id, $data['usertype'], "解除千帆云绑定", 12 ); } } if($nid){ $return['msg'] = '解除绑定成功'; $return['errcode'] = '9' ; }else{ $return['msg'] = '解除绑定失败'; $return['errcode'] = '8' ; } }else{ $return['msg'] = '系统繁忙'; $return['errcode'] = '8' ; } return $return; } /** * @desc 添加、更新企业环境 * @param 表：company_show * @param 参数：data:参数、data['utype']上传类型wap\pc * */ function setShow($data=array()){ $return = array('errcode'=>8,'url'=>'index.php?c=show'); if(!empty($data)){ if ($data['file']['tmp_name'] || $data['base']){ $upArr = array( 'file' => $data['file'], 'dir' => 'show', 'base' => $data['base'], 'preview' => $data['preview'] ); $result = $this -> upload($upArr); if (!empty($result['msg'])){ $return['msg'] = $result['msg']; $return['errcode'] = '8'; return $return; }elseif (!empty($result['picurl'])){ $picurl = $result['picurl']; } } $datashow=array( 'uid' => $data['uid'], 'ctime' => time() ); if($data['sort']){ $datashow['sort'] = $data['sort']; } if($data['id']){ $datashow['title'] = $data['title']; if (isset($picurl)){ $datashow['picurl'] = $picurl; } $datashow['status'] = $data['r_status']==0?1:$this->config['com_show_status']; $nid = $this->upCompanyShow(intval($data['id']),$datashow); if($nid){ $return['msg'] = '更新成功！'; $return['errcode'] = 9; }else{ $return['msg'] = '更新失败！'; } }else{ if(!$picurl){ $return['msg'] = '请上传企业环境！'; }else{ if($data['title']){ $datashow['title'] = $data['title']; }else{ $datashow['title'] = $data['file']['name']; } $datashow['picurl'] = $picurl; $datashow['status'] = $data['r_status']==0?1:$this->config['com_show_status']; $member = $this->select_once('member',array('uid'=>$data['uid']),'`did`'); $datashow['did'] = $member['did']; $id = $this->addCompanyShow($datashow); if($id){ $this->addMemberLog($data['uid'], 2, '添加环境展示', 16,1); $return['msg'] = '上传成功！'; $return['id'] = $id ; $return['errcode'] = 9; }else{ $return['msg'] = '上传失败！'; } } } }else{ $return['msg'] = '系统繁忙'; } return $return; } /** * @desc 处理单个图片上传 * @param file/需上传文件; dir/上传目录; type/上传图片类型; base/需上传base64; preview/pc预览即上传 */ private function upload($data = array('file'=>null,'dir'=>null,'type'=>null,'base'=>null,'preview'=>null)){ include_once('upload.model.php'); $UploadM = new upload_model($this->db, $this->def); $upArr = array( 'file' => $data['file'], 'dir' => $data['dir'], 'type' => $data['type'] ); if (!empty($data['base'])){ $upArr['base'] = $data['base']; } if (!empty($data['preview'])){ $upArr['preview'] = $data['preview']; } if (isset($data['watermark'])){ $upArr['watermark'] = $data['watermark']; } $return = $UploadM -> newUpload($upArr); return $return; } /** * 后台企业logo审核 * @param string $id 格式：单个，如1 ; 批量，如1,2,3 * @param array $data */ public function statusLogo($uid,$data = array()){ $uid = @explode(',',$uid); foreach($uid as $v){ if($v){ $uids[] = $v; } } if (!empty($uids)){ $uidstr = pylode(',', $uids); $post = $data['post']; if ($post['logo_status'] == 2){ //审核不通过删除图片 $post['logo'] =''; } $result = $this -> update_once('company', $post, array('uid'=>array('in',$uidstr))); if ($result){ if ($post['logo_status'] == 2){ // 审核不通过，相关表头像删除 $this -> update_once('company_job',array('com_logo'=>''),array('uid'=>array('in',$uidstr))); $this -> update_once('answer',array('pic'=>''),array('uid'=>array('in',$uidstr))); $this -> update_once('question',array('pic'=>''),array('uid'=>array('in',$uidstr))); $statusInfo = '您的LOGO'; foreach ($uids as $k=>$v){ /* 处理审核信息 */ if($post['logo_statusbody']){ $statusInfo .= ' , 因为'.$post['logo_statusbody'].' , '; } $statusInfo .= '已被管理员删除'; $msg[$v] = $statusInfo; } //发送系统通知 include_once('sysmsg.model.php'); $sysmsgM = new sysmsg_model($this->db, $this->def); $sysmsgM -> addInfo(array('uid'=>$uids,'usertype'=>2,'content'=>$msg)); }else{ // 审核通过，修改相关表logo $company = $this->select_all('company',array('uid'=>array('in',$uidstr)),'`uid`,`logo`'); foreach ($company as $k=>$v){ $newlogo[$v['uid']] = $v['logo']; } $this -> update_once('company_job',array('com_logo'=>array('CASE','uid',$newlogo)),array('uid'=>array('in',$uidstr))); $this -> update_once('answer',array('pic'=>array('CASE','uid',$newlogo)),array('uid'=>array('in',$uidstr))); $this -> update_once('question',array('pic'=>array('CASE','uid',$newlogo)),array('uid'=>array('in',$uidstr))); } $return['msg'] = 'LOGO审核(ID:'.$uidstr.')设置成功'; $return['errcode'] = '9'; }else{ $return['msg'] = 'LOGO审核(ID:'.$uidstr.')设置失败'; $return['errcode'] = '8'; } }else{ $return['msg'] = '请选择要审核的LOGO'; $return['errcode'] = '8'; } return $return; } public function statusShow($id,$data=array()){ $id = @explode(',',$id); foreach($id as $v){ if($v){ $ids[] = $v; } } if (!empty($ids)){ $idstr = pylode(',', $ids); $shows = $this -> getCompanyShowList(array('id'=>array('in',$idstr)),array('field'=>'`uid`,`title`')); $post = $data['post']; if ($post['status'] == 2){ //审核不通过删除 $result = $this -> delete_all('company_show', array('id'=>array('in',$idstr)),''); }elseif($post['status'] == 0){ $result = $this -> update_once('company_show',$post, array('id'=>array('in',$idstr)),''); } if ($result){ if ($post['status'] == 0 || $post['status'] == 2){ foreach ($shows as $k=>$v){ $uids[] = $v['uid']; /* 处理审核信息 */ if ($post['status'] == 2){ if ($v['title'] != ''){ $statusInfo = '您的企业环境('.$v['title'].')审核未通过'; }else{ $statusInfo = '您的企业环境审核未通过'; } if($post['statusbody']){ $statusInfo .= ', 原因：'.$post['statusbody']; } $msg[$v['uid']][] = $statusInfo; }elseif($post['status'] == 0){ if ($v['title'] != '') { $msg[$v['uid']][] = '您的企业环境(' . $v['title'] . ')已审核通过'; }else{ $msg[$v['uid']][] = '您的企业环境已审核通过'; } } } //发送系统通知 include_once('sysmsg.model.php'); $sysmsgM = new sysmsg_model($this->db, $this->def); $sysmsgM -> addInfo(array('uid'=>$uids,'usertype'=>2, 'content'=>$msg)); } $return['msg'] = '企业环境审核(ID:'.$idstr.')设置成功'; $return['errcode'] = '9'; }else{ $return['msg'] = '企业环境审核(ID:'.$idstr.')设置失败'; $return['errcode'] = '8'; } }else{ $return['msg'] = '请选择要审核的企业环境'; $return['errcode'] = '8'; } return $return; } public function statusBanner($id,$data=array()){ $id = @explode(',',$id); foreach($id as $v){ if($v){ $ids[] = $v; } } if (!empty($ids)){ $idstr = pylode(',', $ids); $shows = $this -> getBannerList(array('id'=>array('in',$idstr)),array('field'=>'`uid`')); $post = $data['post']; if ($post['status'] == 2){ //审核不通过删除 $result = $this -> delete_all('banner', array('id'=>array('in',$idstr)),''); }elseif($post['status'] == 0){ $result = $this -> update_once('banner',$post, array('id'=>array('in',$idstr)),''); } if ($result){ if ($post['status'] == 0 || $post['status'] == 2){ foreach ($shows as $k=>$v){ $uids[] = $v['uid']; /* 处理审核信息 */ if ($post['status'] == 2){ $statusInfo = '您的企业横幅审核未通过'; if($post['statusbody']){ $statusInfo .= ', 原因：'.$post['statusbody']; } $msg[$v['uid']][] = $statusInfo; }elseif($post['status'] == 0){ $msg[$v['uid']][] = '您的企业横幅已审核通过'; } } //发送系统通知 include_once('sysmsg.model.php'); $sysmsgM = new sysmsg_model($this->db, $this->def); $sysmsgM -> addInfo(array('uid'=>$uids,'usertype'=>2, 'content'=>$msg)); } $return['msg'] = '企业横幅审核(ID:'.$idstr.')设置成功'; $return['errcode'] = '9'; }else{ $return['msg'] = '企业横幅审核(ID:'.$idstr.')设置失败'; $return['errcode'] = '8'; } }else{ $return['msg'] = '请选择要审核的企业横幅'; $return['errcode'] = '8'; } return $return; } function status($data=array()){ $uid = $data['uid']; $type = $data['type']; $company = $this->getInfo($uid); if($this->config['com_enforce_mobilecert']==1 && $company['moblie_status']!=1){ $return['msg'] = '请先认证手机号'; $return['errcode'] = 10; return $return; } if($this->config['com_enforce_licensecert']==1 && $company['yyzz_status']!=1){ $return['msg'] = '请先认证企业资质'; $return['errcode'] = 11; return $return; } if($this->config['com_enforce_emailcert']==1 && $company['email_status']!=1){ $return['msg'] = '请先认证邮箱'; $return['errcode'] = 12; return $return; } $result = $this->comVipDayActionCheck($type,$uid); $return['result'] = $result; return $return; } /** * @desc 企业名称、手机号码是否使用排查 * @param int $uid * @param array ($typeStr|$checkStr) */ function getCheckUsed($uid, $data = array()){ if (!empty($uid) && !empty($data)) { $typeStr = $data['typeStr']; $checkStr = $data['checkStr']; if ($typeStr == 'name') { $com = $this->select_once('company', array('name' => $checkStr, 'uid' => array('<>', $uid))); $return['errcode'] = $com ? 8 : 9; }else if ($typeStr == 'linktel') { $member = $this->select_once('member', array('moblie' => $checkStr, 'uid' => array('<>', $uid))); $return['errcode'] = $member ? 8 : 9; } $return['type'] = $typeStr; return $return; } } //微信发布工具 public function Getcompany($where='',$data=array()) { if($where){ $lists = $this->DB_query_all($where,'all'); $uids = array(); if(!empty($lists)){ foreach($lists as $lk=>$lv){ $uids[] = $lv['uid']; } $jWhere = array(); if(isset($data['jWhere'])){ $jWhere = $data['jWhere']; } $joblimit = $jWhere['limit']; unset($jWhere['limit']); $jWhere['uid'] = array('in',pylode(',',$uids)); $joblists = $this->getJobList($jWhere); $jobbycom = array(); if(!empty($joblists['list'])){ foreach($joblists['list'] as $jrk=>$jrv){ $description = strip_tags($jrv['description']); if(mb_strlen($description)>50){ $jrv['description'] = mb_substr($description,0,50).'...'; }else{ $jrv['description'] = $description; } if($jrv['job_salary']!='面议'){ $jrv['job_salary'] = $jrv['job_salary'].'(元/月)'; } if($jrv['job_exp']){ $jrv['job_exp'] = $jrv['job_exp'].'经验'; } if($jrv['job_edu']){ $jrv['job_edu'] = $jrv['job_edu'].'学历'; } $jobbycom[$jrv['uid']][] = $jrv; } } foreach($lists as $k=>$v){ $lists[$k]['row'] = array_slice($jobbycom[$v['uid']],0,$joblimit); } return $lists; } } } /** * @param $uid * @return array */ public function getHitsExpoure($uid) { $info = $this->select_once('company', array('uid' => $uid), '`expoure`, `hits`'); $jobs = $this->select_once('company_job', array('uid' => $uid), 'sum(`jobexpoure`) as expoure, sum(`jobhits`) as hits'); $hits = $info['hits'] + $jobs['hits']; $expoure = $info['expoure'] + $jobs['expoure']; //浏览量处理 if($hits>10000){ $hitsNum= floatval(round(($hits/10000),1))."w"; }else{ $hitsNum= $hits; } //曝光量处理 if($expoure>10000){ $expoureNum = floatval(round(($expoure/10000),1))."w"; }else{ $expoureNum = $expoure; } return array( 'hits' => $hitsNum, 'expoure' => $expoureNum ); } /** * 小程序请求企业列表，更新企业曝光量 * * @param array $upData * @param array $whereData */ public function upExpoure($upData = array(), $whereData = array()) { if (!empty($upData) && !empty($whereData)) { $this->update_once('company', $upData, $whereData); } } public function setLogoByAdmin($logoData = array(), $data = array()) { if (!empty($logoData) && !empty($data)) { $result = $this->update_once('company', $logoData, array('uid' => $data['uid'])); if ($result){ $this->update_once('company_job', array('com_logo' => $logoData['logo']), array('uid' => $data['uid'])); } } return $result; } } ?>