<?php
|
|
|
|
class zphnet_model extends model
|
{
|
|
/**
|
* @desc 获取网络招聘会列表
|
* @param $whereData :查询条件
|
* @param $data :自定义处理数组
|
* @return array|bool|false|string|void
|
*/
|
public function getList($whereData , $data = array('field'=>null,'utype'=>null))
|
{
|
|
$select = $data['field'] ? $data['field'] : '*';
|
|
$List = $this -> select_all('zphnet',$whereData,$select);
|
|
$time = time();
|
|
if($List&&is_array($List)){
|
|
if ($data['utype'] == 'admin'){
|
|
foreach($List as $key => $val){
|
|
$zid[] = $val['id'];
|
|
$List[$key]['comnum'] = '0';
|
$List[$key]['booking'] = '0';
|
}
|
|
$all = $this->select_all('zphnet_com',array('zid'=>array('in',pylode(',', $zid)),'groupby'=>'zid'),'zid,count(*) as num');
|
|
$status = $this->select_all('zphnet_com',array('zid'=>array('in',pylode(',', $zid)),'status'=>'0','groupby'=>'zid'),'`zid`,count(*) as num');
|
|
$spLog = $this->select_all('spview_log',array('zid' => array('in', pylode(',', $zid)),'groupby'=>'zid'), '`zid`, count(*) as `num`, sum(`sptime`) as `sptime_t`');
|
|
$userwhere = array('zid' => array('in', pylode(',', $zid)), 'usertype' => 1, 'groupby' => 'zid');
|
|
$usercount = $this->select_all("zphnet_user",$userwhere,"`zid`,`uid`,count(*) as `num`");
|
|
foreach($List as $key => $v){
|
if(!empty($spLog)){
|
foreach($spLog as $val){
|
if($v['id'] == $val['zid']){
|
|
$List[$key]['spnum'] = $val['num']; // 视频场次
|
$List[$key]['sptime_total'] = ceil($val['sptime_t'] / 60); // 视频时间（分钟）
|
}
|
}
|
}
|
foreach($all as $val){
|
if($v['id'] == $val['zid']){
|
|
$List[$key]['comnum'] = $val['num'];
|
}
|
}
|
foreach($usercount as $uk=>$uv){
|
if($uv["zid"] == $v["id"]){
|
|
$List[$key]["usernum"] = $uv["num"];
|
}
|
}
|
foreach($status as $val){
|
if($v['id'] == $val['zid']){
|
|
$List[$key]['booking'] = $val['num'];
|
}
|
}
|
if($v['did']<1){
|
|
$List[$key]['did'] = '0';
|
}
|
}
|
}
|
if ($data['utype'] == 'wxapp'){
|
|
$zids = $zcount = array();
|
|
foreach($List as $k=>$v){
|
|
$zids[] = $v["id"];
|
}
|
|
$userwhere = array('zid' => array('in', pylode(',', $zids)), 'usertype' => 1, 'groupby' => 'zid');
|
|
$usercount = $this->select_all("zphnet_user",$userwhere,"`zid`,count(*) as `num`");
|
|
$comlist = $this->select_all("zphnet_com",array('zid'=>array('in',pylode(',', $zids)),'status'=>1),"`zid`,`uid`,`jobid`");
|
|
$cuids = array();
|
$job_ids = array();
|
foreach($comlist as $comk=>$comv){
|
|
if(!in_array($comv['uid'],$cuids)){
|
|
$cuids[] = $comv["uid"];
|
}
|
if($comv['jobid']){
|
|
$job_ids = array_unique(array_merge($job_ids,@explode(",",$comv['jobid'])));
|
}
|
}
|
|
$jobarr = array();
|
|
if(!empty($cuids)){
|
|
$coms = $this->select_all("company", array('uid' => array('in', pylode(',', $cuids)), 'r_status' => 1), "`uid`");
|
|
$comids = array();
|
|
foreach($coms as $comk=>$comv){
|
|
$comids[] = $comv['uid'];
|
}
|
|
foreach($comlist as $ck=>$cv){
|
if(!in_array($cv['uid'],$comids)){
|
|
unset($comlist[$ck]);
|
}
|
}
|
|
$jobwhere = array(
|
'uid' => array('in',pylode(',',$cuids)),
|
'state' => 1,
|
'r_status' => 1,
|
'status' => 0,
|
'groupby' => 'uid'
|
);
|
|
$jobs = $this->select_all("company_job",$jobwhere,"count(*) as num,`uid`,sum(`zp_num`) as `zpnum`");
|
|
$comjobzparr= array();
|
|
foreach($jobs as $jk=>$jv){
|
|
$jobarr[$jv["uid"]] = $jv["num"];
|
$comjobzparr[$jv["uid"]] = $jv['zpnum'];
|
}
|
|
$jobidwhere = array(
|
'id' => array('in',pylode(',',$job_ids)),
|
'state' => 1,
|
'r_status' => 1,
|
'status' => 0
|
);
|
|
$jobidlist = $this->select_all("company_job", $jobidwhere, "`id`,`zp_num`");
|
|
$jidarr = array();
|
$jusernumarr= array();
|
foreach ($jobidlist as $jidv) {
|
|
$jidarr[] = $jidv['id'];
|
$jusernumarr[$jidv['id']] = $jidv['zp_num'];
|
}
|
}
|
|
foreach($comlist as $clk=>$clv){
|
|
$comlist[$clk]['jobnum'] = 0;
|
$comlist[$clk]['zpnum'] = 0;
|
|
if($clv["jobid"]){
|
|
$jobidarr = @explode(",",$clv["jobid"]);
|
|
foreach($jobidarr as $jv){
|
|
if(in_array($jv,$jidarr)){
|
$zp_num = !empty($jusernumarr[$jv])?$jusernumarr[$jv]:0;
|
$comlist[$clk]['jobnum']++;
|
$comlist[$clk]['zpnum']+=$zp_num;
|
}
|
}
|
}else{
|
|
$comlist[$clk]['jobnum'] = $jobarr[$clv['uid']];
|
$comlist[$clk]['zpnum'] = $comjobzparr[$clv['uid']] ? $comjobzparr[$clv['uid']] : 0;
|
}
|
}
|
foreach($List as $key => $val){
|
|
$List[$key]["usernum"] = 0;
|
$List[$key]["comnum"] = 0;
|
$List[$key]["jobnum"] = 0;
|
$List[$key]["zpnum"] = 0;
|
$List[$key]["zphtype"] = 'zphnet';
|
|
foreach($comlist as $cv){
|
if($cv['zid'] == $val['id']){
|
$List[$key]["comnum"]++;
|
$List[$key]["jobnum"] += $cv['jobnum'];
|
$List[$key]["zpnum"] += $cv['zpnum'];
|
}
|
}
|
|
if (isset($val['pnum']) && (int)$val['pnum'] > 0) {
|
$List[$key]['comnum'] = $List[$key]['comnum'] + $val['pnum'];
|
}
|
if (isset($val['jnum']) && (int)$val['jnum'] > 0) {
|
$List[$key]['jobnum'] = $List[$key]['jobnum'] + $val['jnum'];
|
}
|
if (isset($val['zpnum']) && (int)$val['zpnum'] > 0) {
|
$List[$key]['zpnum'] = $List[$key]['zpnum'] + $val['zpnum'];
|
}
|
|
$List[$key]['starttime_timestamp'] = strtotime($val['starttime']);
|
$List[$key]['endtime_timestamp'] = strtotime($val['endtime']);
|
$List[$key]['starttime'] = date('Y-m-d H:i',strtotime($val['starttime']));
|
$List[$key]['endtime'] = date('Y-m-d H:i',strtotime($val['endtime']));
|
$List[$key]['stime'] = strtotime($val['starttime'])-$time;
|
$List[$key]['etime'] = strtotime($val['endtime'])-$time;
|
|
if($data['utype']=='wxapp' && $val['pic_wap']){
|
$List[$key]['pic_n'] = checkpic($val['pic_wap'],$this->config['sy_zph_icon']);
|
}else{
|
$List[$key]['pic_n'] = checkpic($val['pic'],$this->config['sy_zph_icon']);
|
}
|
if(($data['utype']=='wxapp') && $val['banner_wap']){
|
$List[$key]['banner_wap_n'] = checkpic($val['banner_wap'],$this->config['sy_zph_icon']);
|
}else{
|
$List[$key]['banner_wap_n'] = checkpic($this->config['sy_zph_icon']);
|
}
|
|
foreach($usercount as $uk=>$uv){
|
if($uv["zid"] == $val["id"]){
|
|
$List[$key]["usernum"] = $uv["num"];
|
}
|
}
|
}
|
}
|
}
|
return $List;
|
}
|
|
/**
|
* @desc 获取招聘会列表详细信息
|
*/
|
public function getInfo($whereData,$data = array())
|
{
|
$select = $data['field'] ? $data['field'] : '*';
|
|
$Info = $this -> select_once('zphnet', $whereData, $select);
|
|
if (!empty($Info)) {
|
|
if (!empty($Info['starttime']))
|
{
|
$Info['starttime_n'] = date('Y-m-d H:i',strtotime($Info['starttime']));
|
$Info['stime'] = strtotime($Info['starttime']) - time();
|
}
|
|
if (!empty($Info['endtime']))
|
{
|
$Info['endtime_n'] = date('Y-m-d H:i',strtotime($Info['endtime']));
|
$Info['etime'] = strtotime($Info['endtime']) - time();
|
}
|
|
if (!empty($Info['body'])){
|
|
$body = str_replace(array('"',' ','<>'), array('','',''), $Info['body']);
|
$body = htmlspecialchars_decode($body);
|
|
preg_match_all('/<img(.*?)src=("|\'|\s)?(.*?)(?="|\'|\s)/',$body,$res);
|
if(!empty($res[3])){
|
foreach($res[3] as $v){
|
if(strpos($v,'http:')===false && strpos($v,'https:')===false){
|
$body = str_replace($v,$this->config['sy_ossurl'].$v,$body);
|
}
|
}
|
}
|
$Info['body_n'] = mb_substr(strip_tags($body),0,50).'...';
|
$Info['body'] = $body;
|
}
|
$Info['pic_n'] = checkpic($Info['pic'], $this->config['sy_zph_icon']);
|
$Info['pic_wap_n'] = checkpic($Info['pic_wap'], $this->config['sy_zph_icon']);
|
// pc横幅
|
$Info['banner_n'] = checkpic($Info['banner'], $this->config['sy_zphbanner_icon']);
|
// wap横幅
|
$Info['banner_wap_n'] = checkpic($Info['banner_wap'], $Info['banner_n']);
|
}
|
return $Info;
|
}
|
|
/**
|
* @desc 添加招聘会
|
* @param array $data
|
* @return bool
|
*/
|
public function addInfo($data = array())
|
{
|
|
$AddData = array(
|
'title' => $data['title'],
|
'address' => $data['address'],
|
'phone' => $data['phone'],
|
'starttime' => $data['starttime'],
|
'endtime' => $data['endtime'],
|
'body' => $data['body'],
|
'ctime' => time(),
|
'did' => $data['did'],
|
'toptitle' => $data['toptitle'],
|
'zw' => $data['zw'],
|
'is_open' => $data['is_open'],
|
'sort' => $data['sort'],
|
'hits' => $data['hits'],
|
'pnum' => $data['pnum'],
|
'jnum' => $data['jnum'],
|
'zpnum' => $data['zpnum'],
|
'anum' => $data['anum'],
|
'unum' => $data['unum'],
|
'pic' => $data['pic'],
|
'banner' => $data['banner'],
|
'pic_wap' => $data['pic_wap'],
|
'banner_wap' => $data['banner_wap']
|
);
|
if($data['issync']){
|
|
$AddData['issync'] = $data['issync'];
|
}
|
if ($AddData && is_array($AddData)){
|
|
$nid = $this -> insert_into('zphnet',$AddData);
|
}
|
return $nid;
|
}
|
|
/**
|
* @desc 修改招聘会
|
* @param $whereData
|
* @param array $data
|
* @return bool
|
*/
|
public function upInfo($whereData, $data = array())
|
{
|
|
if(!empty($whereData)) {
|
|
$PostData = array(
|
'title' => $data['title'],
|
'phone' => $data['phone'],
|
'starttime' => $data['starttime'],
|
'endtime' => $data['endtime'],
|
'body' => $data['body'],
|
'did' => $data['did'],
|
'toptitle' => $data['toptitle'],
|
'zw' => $data['zw'],
|
'is_open' => $data['is_open'],
|
'sort' => $data['sort'],
|
'hits' => $data['hits'],
|
'pnum' => $data['pnum'],
|
'jnum' => $data['jnum'],
|
'zpnum' => $data['zpnum'],
|
'anum' => $data['anum'],
|
'unum' => $data['unum'],
|
'pic' => $data['pic'],
|
'banner' => $data['banner'],
|
'pic_wap' => $data['pic_wap'],
|
'banner_wap' => $data['banner_wap']
|
);
|
if($data['issync']){
|
|
$PostData['issync'] = $data['issync'];
|
}
|
if ($PostData && is_array($PostData)){
|
|
$nid = $this -> update_once('zphnet',$PostData,array('id'=>$whereData['id']));
|
}
|
return $nid;
|
}
|
}
|
|
/**
|
* @desc 删除招聘会
|
* @param $delId
|
* @return array
|
*/
|
public function delZph($delId){
|
|
if (empty($delId)) {
|
|
$return = array( 'errcode' => 8, 'msg' => '请选择要删除的数据！');
|
} else {
|
if (is_array($delId)) {
|
|
$delId = pylode(',', $delId);
|
$return['layertype'] = 1;
|
} else {
|
|
$return['layertype'] = 0;
|
}
|
|
$delid = $this -> delete_all('zphnet', array('id' => array('in', $delId)), '');
|
|
if ($delid) {
|
|
$this -> delete_all('zphnet_com', array('zid' => array('in', $delId)), '');
|
$this -> delete_all('zphnet_look', array('zid' => array('in', $delId)), '');
|
$this -> delete_all('zphnet_user', array('zid' => array('in', $delId)), '');
|
}
|
$return['msg'] = '网络招聘会';
|
$return['errcode'] = $delid ? '9' : '8';
|
$return['msg'] = $delid ? $return['msg'].'删除成功！' : $return['msg'].'删除失败！';
|
}
|
|
return $return;
|
}
|
|
/**
|
* @desc 获取参会企业列表
|
* @param $whereData
|
* @param string[] $data
|
* @return array|bool|false|string|void
|
*/
|
public function getZphnetComList($whereData , $data=array('utype'=>''))
|
{
|
$select = $data['field'] ? $data['field'] : '*';
|
|
$List = $this -> select_all('zphnet_com' , $whereData, $select);
|
|
if(!empty($List)){
|
|
$jobids = $jobuid = $uid = $zid = array();
|
|
foreach($List as $v){
|
if($v['uid'] && !in_array($v['uid'] , $uid)){
|
$uid[] = $v['uid'];
|
}
|
if($v['zid'] && !in_array($v['zid'],$zid)){
|
$zid[] = $v['zid'];
|
}
|
|
if($v['jobid']){
|
|
$jobarr = @explode(',',$v['jobid']);
|
$jobids = array_merge($jobids,$jobarr);
|
}else{
|
if(!in_array($v['uid'] , $jobuid)){
|
$jobuid[] = $v['uid'];
|
}
|
}
|
}
|
|
if ($data['utype'] == 'admin'){
|
|
$company = $this -> select_all('company', array('uid'=>array('in',pylode(',',$uid))),'`uid`,`name`,`logo`,`logo_status`,`r_status`');
|
|
$jfield = '`id`,`uid`,`name`';
|
|
$jobwhere = array(
|
'state' => 1,
|
'status' => 0,
|
'r_status' => 1
|
);
|
|
$jobwhere['PHPYUNBTWSTART'] = 1;
|
$jobwhere['uid'] = array('in',pylode(',',$jobuid));
|
$jobwhere['id'] = array('in',pylode(',',$jobids),'OR');
|
$jobwhere['PHPYUNBTWEND'] = 1;
|
|
$listA = $this -> select_all('company_job',$jobwhere,$jfield);
|
}
|
|
$zph = $this -> select_all('zphnet',array('id'=>array('in',pylode(',',$zid))),'`id`,`title`,`starttime`,`endtime`');
|
|
$spwhere = array('zid' => array('in', pylode(',', $zid)),'groupby'=>'zid');
|
|
if($data['comid']){
|
|
$spwhere['comid'] = array('in',$data['comid']);
|
}
|
|
$spLog = $this->select_all('spview_log',$spwhere, '`zid`, count(*) as `num`, sum(`sptime`) as `sptime_t`');
|
|
foreach($List as $k => $v){
|
|
$List[$k]['wapurl'] = Url('wap', array('c'=>'zphnet','a'=>'show','id'=>$v['zid']));
|
$List[$k]['bmctime_n'] = date('Y-m-d',$v['ctime']);
|
|
$List[$k]['spnum'] = 0;
|
$List[$k]['sptime_total'] = 0;
|
if(!empty($spLog)){
|
foreach($spLog as $val){
|
if($v['zid'] == $val['zid']){
|
|
$List[$k]['spnum'] = $val['num']; // 视频场次
|
$List[$k]['sptime_total'] = ceil($val['sptime_t'] / 60); // 视频时间（分钟）
|
}
|
}
|
}
|
|
if ($data['utype'] == 'admin'){
|
foreach($company as $val){
|
|
if($v['uid'] == $val['uid']){
|
|
$List[$k]['comname'] = $val['name'];
|
}
|
}
|
$jobname = array();
|
|
foreach($listA as $val){
|
if ($v['uid'] == $val['uid']) {
|
if (count($jobname) < 10){
|
$jobname[] = $val['name'];
|
$List[$k]['jobname'] = @implode('、',$jobname);
|
}
|
}
|
}
|
}
|
foreach($zph as $val){
|
|
if($v['zid'] == $val['id']){
|
$List[$k]['zphname'] = $val['title'];
|
$List[$k]['title'] = $val['title'];
|
$List[$k]['starttime'] = $val['starttime'];
|
$List[$k]['endtime'] = $val['endtime'];
|
if(strtotime($val['starttime'])>time()){
|
$List[$k]['notstart'] = 1;
|
}
|
if(strtotime($val['endtime'])>time()){
|
$List[$k]['notend'] = 1;
|
}
|
}
|
}
|
}
|
}
|
return $List;
|
}
|
//
|
function getAreaComList($whereData, $data = array('zw'=>'','keyword'=>''))
|
{
|
$whereData['status'] = 1;
|
|
if (!empty($data['zw'])){
|
$whereData['zw'] = $data['zw'];
|
}
|
// 先查出所有参会企业。为排序做准备
|
$comlist = $this->select_all('zphnet_com', array('zid'=>$whereData['zid'],'status'=>1),'`uid`,`jobid`,`sort`');
|
|
if (!empty($comlist)){
|
|
$comid = $jobid = $nojobuid = $ucom = $zcom = array();
|
|
foreach ($comlist as $v){
|
$comid[] = $v['uid'];
|
}
|
if (!empty($data['keyword'])){
|
// 关键字搜索的，先处理
|
$kcom = $this->select_all('company', array('uid'=>array('in',pylode(',',$comid)), 'name'=>array('like',$data['keyword'])), '`uid`');
|
if (!empty($kcom)){
|
$comid = array();
|
foreach ($kcom as $v){
|
$comid[] = $v['uid'];
|
}
|
}
|
}
|
// 按处理过的企业id数组来，获取要查询的职位
|
foreach ($comlist as $k=>$v){
|
if (in_array($v['uid'], $comid)){
|
$jobarr = !empty($v['jobid']) ? explode(',', $v['jobid']) : array();
|
if (empty($jobarr)){
|
$nojobuid[] = $v['uid'];
|
}else{
|
$jobid = array_merge($jobid, $jobarr);
|
}
|
}else{
|
// 清理掉没搜索到的
|
unset($comlist[$k]);
|
}
|
}
|
// 处理参会职位是空的记录
|
if (!empty($nojobuid)){
|
$otherjob = $this->select_all('company_job', array('uid'=>array('in', pylode(',', $nojobuid)),'state'=>1,'r_status'=>1,'status'=>0),'id');
|
foreach ($otherjob as $v){
|
$jobid[] = $v['id'];
|
}
|
}
|
if (!empty($jobid)){
|
// 按职位更新时间查询，为排序准备数据
|
$sjwhere = array('id'=>array('in', pylode(',', $jobid)),'state'=>1,'r_status'=>1,'status'=>0,'groupby'=>'uid','orderby'=>array('lastupdate,DESC'));
|
$sortjob = $this->select_all('company_job', $sjwhere,'`uid`,`lastupdate`');
|
// 组合企业和最新更新时间数组
|
foreach ($sortjob as $v){
|
$zcom[] = $v['uid'];
|
$ucom[$v['uid']] = $v['lastupdate'];
|
}
|
$lastupdate = $sort = array();
|
|
foreach ($comlist as $k=>$v){
|
if (!in_array($v['uid'], $zcom)){
|
// 清掉没有在招职位的企业
|
unset($comlist[$k]);
|
}else{
|
foreach ($ucom as $key=>$val){
|
if ($v['uid'] == $key){
|
$comlist[$k]['lastupdate'] = $val;
|
$lastupdate[$k] = $val;
|
$sort[$k] = empty($v['sort']) ? 0 : $v['sort'];
|
}
|
}
|
}
|
}
|
|
// 根据职位刷新时间、参会企业排序倒序排，参会企业排序值最优先
|
array_multisort($sort, SORT_DESC, $lastupdate, SORT_DESC, $comlist);
|
|
$uw = $ruid = $njuid = $njobid =array();
|
// 处理分页数据
|
if (is_array($whereData['limit'])){
|
$start = $whereData['limit'][0];
|
$end = $start + $whereData['limit'][1];
|
// 计算总页数
|
$count = count($comlist);
|
$area['total'] = intval(ceil($count/$whereData['limit'][1]));
|
}else{
|
$start = 0;
|
$end = $whereData['limit'];
|
// 计算总页数
|
$count = count($comlist);
|
$area['total'] = intval(ceil($count/$whereData['limit']));
|
}
|
if (!empty($data['keyword'])){
|
// 关键词搜索时全部展示
|
$end = $count;
|
$area['total'] = 1;
|
}
|
unset($whereData['limit']);
|
|
foreach ($comlist as $k=>$v){
|
if ($k >=$start && $k < $end){
|
$uw[] = $v['uid'];
|
}
|
}
|
|
$whereData['uid'] = array('in', pylode(',', $uw));
|
// 按组装好条件，查询数据
|
$rows = $this->select_all('zphnet_com', $whereData);
|
|
foreach ($rows as $v){
|
$ruid[] = $v['uid'];
|
$jobarr = !empty($v['jobid']) ? explode(',', $v['jobid']) : array();
|
if (empty($jobarr)){
|
$njuid[] = $v['uid'];
|
}else{
|
$njobid = array_merge($njobid, $jobarr);
|
}
|
}
|
|
$company = $this->select_all('company', array('uid'=>array('in',pylode(',',$ruid))), '`uid`,`name`,`shortname`,`logo`,`logo_status`,`r_status`,`mun`,`pr`,`hy`');
|
|
$jfield = '`id`,`uid`,`name`,`exp`,`edu`,`sex`,`age`,`marriage`,`minsalary`,`maxsalary`,`lastupdate`';
|
|
$jobwhere = array(
|
'state' => 1,
|
'status' => 0,
|
'r_status' => 1
|
);
|
// 区分是否有参会记录中，参会职位为空来区分查询
|
if (!empty($njuid)){
|
$jobwhere['PHPYUNBTWSTART'] = 1;
|
$jobwhere['uid'] = array('in',pylode(',',$njuid));
|
$jobwhere['id'] = array('in',pylode(',',$njobid),'OR');
|
$jobwhere['PHPYUNBTWEND'] = 1;
|
}else{
|
$jobwhere['id'] = array('in',pylode(',',$njobid));
|
}
|
$jobwhere['orderby'] =['lastupdate, desc'];
|
$job = $this->select_all('company_job', $jobwhere,$jfield);
|
|
include_once ('cache.model.php');
|
$cacheM = new cache_model($this->db, $this->def);
|
$cache = $cacheM -> GetCache(array('com','hy'));
|
foreach ($company as $k=>$v){
|
if ($v['shortname']){
|
$company[$k]['comname'] = $v['shortname'];
|
}else{
|
$company[$k]['comname'] = $v['name'];
|
}
|
if ($v['logo_status'] == 0){
|
$company[$k]['logo'] = checkpic($v['logo'],$this->config['sy_unit_icon']);
|
}else{
|
$company[$k]['logo'] = checkpic($this->config['sy_unit_icon']);
|
}
|
if($v['hy']){
|
$company[$k]['hy_n'] = $cache['industry_name'][$v['hy']];
|
}
|
if($v['pr']){
|
$company[$k]['pr_n'] = $cache['comclass_name'][$v['pr']];
|
}
|
if($v['mun']){
|
$company[$k]['mun_n'] = $cache['comclass_name'][$v['mun']];
|
}
|
foreach ($job as $val){
|
|
if ($v['uid'] == $val['uid']){
|
|
$company[$k]['job'][] = $this->jobData($val, $cache);
|
}
|
}
|
}
|
|
foreach ($company as $k=>$v){
|
$company[$k]['online'] = 0;
|
$company[$k]['jobnum'] = count($v['job']);
|
foreach ($v['job'] as $key=>$val){
|
if ($key > 4){
|
unset($company[$k]['job'][$key]);
|
}
|
}
|
}
|
foreach ($comlist as $key=>$val){
|
|
foreach ($company as $k=>$v){
|
|
if($val['uid']==$v['uid']){
|
|
$comnew[] = $v;
|
|
}
|
}
|
|
}
|
|
$area['com'] = $comnew;
|
}
|
}
|
|
return $area;
|
|
}
|
|
private function jobData($job, $cache){
|
|
$name = $cache['comclass_name'];
|
$sex = $cache['com_sex'];
|
|
$data = array(
|
'id'=>$job['id'],
|
'uid'=>$job['uid'],
|
'name'=>$job['name']
|
);
|
|
if (!empty($job['minsalary']) || !empty($job['maxsalary'])) {
|
|
if(!empty($job['minsalary']) && !empty($job['maxsalary'])){
|
if($this ->config['resume_salarytype']==1){
|
$data['job_salary'] = $job['minsalary'].'-'.$job['maxsalary'];
|
}else{
|
if($job['maxsalary']<1000){
|
if($this->config['resume_salarytype']==2){
|
$data['job_salary'] = '1千以下';
|
}elseif($this->config['resume_salarytype']==3){
|
$data['job_salary'] = '1K以下';
|
}elseif($this->config['resume_salarytype']==4){
|
$data['job_salary'] = '1k以下';
|
}
|
}else{
|
$data['job_salary'] = changeSalary($job[minsalary]).'-'.changeSalary($job[maxsalary]);
|
}
|
|
}
|
}elseif (!empty($job['minsalary'])){
|
if($this ->config['resume_salarytype']==1){
|
$data['job_salary'] = $job["minsalary"];
|
}else{
|
$data['job_salary'] = changeSalary($job['minsalary']);
|
}
|
}else{
|
|
$data['job_salary'] = '面议';
|
}
|
}else{
|
|
$data['job_salary'] = '面议';
|
}
|
|
$require = array();
|
if (!empty($job['exp'])){
|
|
$require[] = $name[$job['exp']].'经验';
|
}
|
if (!empty($job['edu'])){
|
|
$require[] = $name[$job['edu']].'学历';
|
}
|
if (!empty($job['age'])){
|
|
$require[] = '年龄'.$name[$job['age']];
|
}
|
if (!empty($job['sex'])){
|
|
$require[] = '性别'.$sex[$job['sex']];
|
}
|
if (!empty($job['marriage'])){
|
|
$marriage = $name[$job['marriage']];
|
|
if ($marriage == '不限'){
|
|
$require[] = '婚况不限';
|
|
}else{
|
|
$require[] = $marriage;
|
}
|
}
|
$data['require'] = implode(',', $require);
|
|
return $data;
|
}
|
/**
|
* @desc 获取参会企业详细信息
|
*/
|
public function getZphnetCom($whereData,$data = array()){
|
|
$select = $data['field'] ? $data['field'] : '*';
|
|
$ZComInfo = $this -> select_once('zphnet_com', $whereData, $select);
|
|
return $ZComInfo;
|
|
}
|
/**
|
* @desc 获取参会企业数量
|
*/
|
public function getZphnetComNum($whereData=array(),$data=array()){
|
|
|
if (!empty($data['zw'])){
|
$whereData['zw'] = $data['zw'];
|
}
|
return $this -> select_num('zphnet_com', $whereData);
|
|
}
|
|
/**
|
* @desc 获取参会企业数量总数、职位总数量
|
*/
|
public function getZphnetAllNum($whereData=array(),$data=array())
|
{
|
|
$com = $this->select_all('zphnet_com', $whereData, '`uid`,`status`,`jobid`');
|
|
|
if (!empty($com)){
|
|
$jobids = $jobuid = array();
|
|
foreach ($com as $v){
|
|
if($v['status']== 1){
|
$uids[] = $v['uid'];
|
}
|
if($v['jobid']){
|
|
$jobarr = @explode(',',$v['jobid']);
|
$jobids = array_merge($jobids,$jobarr);
|
|
}else{
|
|
if(!in_array($v['uid'] , $jobuid)){
|
$jobuid[] = $v['uid'];
|
}
|
}
|
}
|
|
$jobwhere = array(
|
'state' => 1,
|
'status' => 0,
|
'r_status' => 1
|
);
|
if(!empty($jobuid)){
|
|
$jobwhere['PHPYUNBTWSTART'] = 1;
|
$jobwhere['uid'] = array('in',pylode(',',$jobuid));
|
$jobwhere['id'] = array('in',pylode(',',$jobids),'OR');
|
$jobwhere['PHPYUNBTWEND'] = 1;
|
}else{
|
$jobwhere['id'] = array('in',pylode(',',$jobids));
|
}
|
|
$comnum = $this->select_num('company',array('uid'=>array('in',pylode(',', $uids)),'r_status'=>1));
|
|
$jobnum = $this->select_num('company_job',$jobwhere);
|
|
|
$jobwhere['zp_num'] = array('>',0);
|
$zpnum = $this->select_all('company_job',$jobwhere,'sum(zp_num) as num');
|
$zpnum = $zpnum[0]['num'];
|
}
|
|
$usernum = $this->select_num('zphnet_user',array('zid'=>$whereData['zid'],'usertype'=>1),'distinct uid');
|
$zphinfo = $this->select_once('zphnet',array('id'=>$whereData['zid']),'pnum,jnum,anum,zpnum,unum,starttime,endtime');
|
if(!empty($jobuid)){
|
|
$userjobwehre['PHPYUNBTWSTART'] = 1;
|
$userjobwehre['com_id'] = array('in',pylode(',',$jobuid));
|
$userjobwehre['job_id'] = array('in',pylode(',',$jobids),'OR');
|
$userjobwehre['PHPYUNBTWEND'] = 1;
|
}else{
|
$userjobwehre['job_id'] = array('in',pylode(',',$jobids));
|
}
|
$userjobwehre['PHPYUNBTWSTART_B'] = "";
|
$userjobwehre['datetime'][] = array(">=" , strtotime($zphinfo['starttime']));
|
$userjobwehre['datetime'][] = array("<=" , strtotime($zphinfo['endtime']),'and');
|
$userjobwehre['PHPYUNBTWEND_B'] = "";
|
$userjobnum = $this->select_num('userid_job',$userjobwehre);
|
|
if ($zphinfo['pnum'] > 0) {
|
$comnum = $comnum + $zphinfo['pnum'];
|
}
|
if ($zphinfo['anum'] > 0) {
|
$userjobnum = $userjobnum + $zphinfo['anum'];
|
}
|
if ($zphinfo['zpnum'] > 0) {
|
$zpnum = $zpnum + $zphinfo['zpnum'];
|
}
|
if ($zphinfo['jnum'] > 0) {
|
$jobnum = $jobnum + $zphinfo['jnum'];
|
}
|
if ($zphinfo['unum'] > 0) {
|
$usernum = $usernum + $zphinfo['unum'];
|
}
|
|
$return = array(
|
'comnum' => isset($comnum) ? $comnum : 0,
|
'jobnum' => isset($jobnum) ? $jobnum : 0,
|
'usernum' => isset($usernum) ? $usernum : 0,
|
'zpnum' => isset($zpnum) ? $zpnum : 0,
|
'userjobnum' => isset($userjobnum) ? $userjobnum : 0,
|
);
|
|
return $return;
|
}
|
|
/**
|
* @desc 添加参会企业
|
*/
|
public function addZphnetCom($data = array()){
|
|
$return = array();
|
$AddData = array(
|
'uid' => $data['comid'],
|
'zid' => $data['zphid'],
|
'sort' => $data['sort'],
|
'ctime' => time(),
|
'status' => isset($data['status']) ? $data['status'] : 1,
|
'jobid' => $data['jobid']
|
);
|
|
$row = $this->select_once('zphnet_com',array('zid'=>$AddData['zid'],'uid'=>$AddData['uid']));
|
|
if (!empty($row)){
|
|
$return['errcode'] = 8;
|
$return['msg'] = '该企业已参加本次招聘会';
|
|
}else{
|
|
$nid = $this -> insert_into('zphnet_com',$AddData);
|
|
$return['errcode'] = 9;
|
$return['msg'] = '添加成功';
|
$return['id'] = $nid;
|
}
|
return $return;
|
}
|
|
/**
|
* @desc 审核参会企业表信息
|
*/
|
public function zphnetComStatus($id , $data = array(), $data1 = array()){
|
$where = array();
|
|
if (! empty($id)) {
|
|
$where['id'] = array( 'in', pylode(',', $id));
|
|
if ($data['status']) {
|
|
$updata = array('status' => $data['status'],'statusbody' => $data['statusbody']);
|
|
}else if ($data['did']) {
|
|
$updata = array('did' => $data['did']);
|
}
|
|
$nid = $this->update_once('zphnet_com', $updata, $where);
|
|
if (!empty($data['status'])) {
|
|
$List = $this -> getZphnetComList($where, $data1);
|
|
/* 消息前缀 */
|
$tagName = '参会企业';
|
|
if (! empty($List)) {
|
|
foreach ($List as $v) {
|
|
$uids[] = $v['uid'];
|
|
if ($updata['status'] == 2) {
|
|
$statusInfo = $tagName . ':<a href="zphnettpl,'.$v['zid'].'">'.$v['comname'].'</a>,审核未通过';
|
|
if ($updata['statusbody']) {
|
|
$statusInfo .= ' , 原因：' . $updata['statusbody'];
|
}
|
|
$msg[$v['uid']] = $statusInfo;
|
|
} elseif ($updata['status'] == 1) {
|
|
$msg[$v['uid']] = $tagName . ':<a href="zphnettpl,'.$v['zid'].'">'.$v['comname'].'</a>,已审核通过';
|
}
|
}
|
|
// 发送系统通知
|
include_once ('sysmsg.model.php');
|
$sysmsgM = new sysmsg_model($this->db, $this->def);
|
$sysmsgM -> addInfo(array('uid' => $uids,'usertype'=>2, 'content' => $msg));
|
}
|
}
|
|
return $nid;
|
}
|
}
|
|
/**
|
* @desc 删除参会企业
|
*/
|
public function delZphnetCom($delId = null, $uid=''){
|
|
|
if (empty($delId)) {
|
|
$return = array('errcode' => 8, 'msg' => '请选择要删除的数据！');
|
} else {
|
|
if (is_array($delId)) {
|
|
$delId = pylode(',', $delId);
|
|
$return['layertype'] = 1;
|
} else {
|
|
$return['layertype'] = 0;
|
}
|
$zcwhere = array('id'=>array('in',$delId));
|
if($uid!=''){
|
$zcwhere['uid'] = $uid;
|
}
|
$list = $this->select_all('zphnet_com',$zcwhere);
|
|
if(!empty($list)){
|
$zuid = array();
|
foreach ($list as $v){
|
|
if(!in_array($v['uid'],$zuid)){
|
$zuid[] = $v['uid'];
|
}
|
|
$zid = $v['zid'];
|
|
}
|
|
$this->delete_all('zphnet_look',array('zid'=>$zid,'comid'=>array('in',pylode(',', $zuid))),'');
|
|
}
|
|
$return['id'] = $this -> delete_all('zphnet_com', $zcwhere, '');
|
|
$return['errcode'] = $return['id'] ? 9 : 8;
|
|
$msg = '网络招聘会参会企业（ID：'.$delId.'）';
|
|
$return['msg'] = $return['id'] ? $msg.'删除成功！' : '删除失败！';
|
}
|
return $return;
|
}
|
|
/**
|
* @desc 招聘会预定
|
*/
|
public function ajaxZphnet($data = array())
|
{
|
|
$uid = intval($data['uid']);
|
$spid = intval($data['spid']);
|
$usertype = intval($data['usertype']);
|
|
$did = $data['did'] ? intval($data['did']) : $this->config['did'];
|
$zid = $data['zid'] ? intval($data['zid']) : '';
|
|
$time = time();
|
$return = array();
|
|
if (empty($uid) || empty($usertype)) {
|
|
$return['login'] = 1;
|
|
} else if ($usertype != 2) {
|
|
$return['msg'] = '企业用户才可以预定招聘会！';
|
|
} else {
|
|
//判断后台是否开启该单项购买
|
$single_can = @explode(',', $this->config['com_single_can']);
|
$serverOpen = 1;
|
if(!in_array('zphnet',$single_can)){
|
$serverOpen = 0;
|
}
|
|
$zph = $this->getInfo(array('id' => $zid), array('field' => '`starttime`,`endtime`'));
|
|
if (strtotime($zph['endtime']) < $time) {
|
|
$return['msg'] = '招聘会已经结束！';
|
} else {
|
|
$cInfo = $this->select_once('company',array('uid' => $uid), '`name`,`r_status`');
|
|
if (empty($cInfo['name'])){
|
|
$return['msg'] = '请先完善基本资料！';
|
|
} elseif ($cInfo['r_status'] != 1) {
|
|
$return['msg'] = '您的账号未通过审核，请联系管理员加速审核进度！';
|
|
} else {
|
|
$zphcom = $this->getZphnetCom(array('uid' => $uid, 'zid' => $zid));
|
|
if (!empty($zphcom)) {
|
|
if ($zphcom['status'] == 2) {
|
|
$return['msg'] = '您的报名未通过审核，请联系管理员！';
|
} else {
|
$return['msg'] = '您已报名该招聘会！';
|
}
|
} else {
|
|
$suid = !empty($spid) ? $spid : $uid;
|
|
require_once ('statis.model.php');
|
$statisM = new statis_model($this->db, $this->def);
|
$statis = $statisM -> getInfo($suid, array('usertype' => $usertype, 'field' => '`rating_type`,`vip_etime`,`zph_num`,`integral`'));
|
|
$com = $this->select_once('company',array('uid'=>$uid),'`name`');
|
|
$zData = array();
|
$zData['uid'] = $uid;
|
$zData['usertype'] = $usertype;
|
$zData['com_name'] = $com['name'];
|
$zData['did'] = $did;
|
$zData['zid'] = $zid;
|
$zData['jobid'] = $data['jobid'];
|
$zData['fuid'] = $uid;
|
// 价格
|
|
$price = $this->config['integral_zphnet'];
|
$jifen = $price * $this->config['integral_proportion'];
|
$online = $this->config['com_integral_online'];
|
|
if ($price == 0) {
|
|
$return = $this->reserveZphnet($zData);
|
|
return $return;
|
}
|
|
if (isVip($statis['vip_etime'])) {
|
|
if ($statis['rating_type'] == 1) {
|
|
// 没有招聘会报名次数
|
if ($statis['zph_num'] == 0) {
|
|
if(empty($spid)){
|
|
if ($online != 4) { // 套餐模式
|
|
if ($online == 3 && !in_array('zphnet', explode(',', $this->config['sy_only_price']))) { // 积分消费
|
if($serverOpen){
|
$return['msg'] = "您的等级特权已经用完，继续报名将消费 <span style=color:red;>" .$jifen . "</span> ".$this->config['integral_pricename']."，是否继续？";
|
}else{
|
$return['msg'] = "您的等级特权已经用完，可以<a href=\"" . $this->config['sy_weburl'] . "/wap/member/index.php?c=rating\" style=\"color:red;cursor:pointer;\">购买会员</a>！";
|
}
|
|
$return['url'] = $this->config['sy_weburl'] . 'wap/member/index.php?c=getserver&id=' . $uid . '&server=15';
|
$return['jifen'] = $jifen;
|
$return['integral'] = intval($statis['integral']);
|
$return['pro'] = $this->config['integral_proportion'];
|
} else {
|
|
$return['url'] = $this->config['sy_weburl'] . 'wap/member/index.php?c=getserver&id=' . $uid . '&server=15';
|
if($serverOpen){
|
$return['msg'] = "您的等级特权已经用完，继续报名将消费 <span style=color:red;>" . $price . "</span> 元，是否继续？";
|
}else{
|
$return['msg'] = "您的等级特权已经用完，可以<a href=\"" . $this->config['sy_weburl'] . "/wap/member/index.php?c=rating\" style=\"color:red;cursor:pointer;\">购买会员</a>！";
|
}
|
$return['price'] = $price;
|
}
|
} else {
|
$return['price'] = $price;
|
$return['url'] = $this->config['sy_weburl'] . 'wap/member/index.php?c=rating';
|
$return['msg'] = "您的等级特权已经用完，可以<a href=\"" . $this->config['sy_weburl'] . "/wap/member/index.php?c=rating\" style=\"color:red;cursor:pointer;\">购买会员</a>！";
|
}
|
$return['zid'] = $zid;
|
$return['status'] = 2;
|
}else{
|
|
$return['msg'] = '当前账户套餐余量不足，请联系主账户增配！';
|
}
|
|
} else {
|
|
$statisM -> upInfo(array('zph_num' => array('-', 1)), array('uid' => $suid, 'usertype' => $usertype));
|
$return = $this->reserveZphnet($zData);
|
}
|
} else if ($statis['rating_type'] == 2) {
|
|
// 判断当天是否已达到最大报名次数
|
require_once ('company.model.php');
|
$companyM = new company_model($this->db, $this->def);
|
$result = $companyM->comVipDayActionCheck('zphnet', $uid);
|
|
if ($result['status'] != 1) {
|
return $result;
|
}
|
|
$return = $this->reserveZphnet($zData);
|
}
|
} else { // 过期会员
|
|
if(empty($spid)){
|
|
if ($online != 4) {
|
|
if ($online == 3 && !in_array('zphnet', explode(',', $this->config['sy_only_price']))) { // 积分消费
|
|
$return['jifen'] = $jifen;
|
$return['integral'] = intval($statis['integral']);
|
$return['pro'] = $this->config['integral_proportion'];
|
} else {
|
$return['price'] = $price;
|
}
|
$return['msg'] = "你的会员已到期，请先购买会员！";
|
} else {
|
$return['url'] = $this->config['sy_weburl'] . 'wap/member/index.php?c=rating';
|
$return['msg'] = "你的会员已到期，你可以<a href='" . $this->config['sy_weburl'] . "/wap/member/index.php?c=rating' style='color:red;cursor:pointer;'>购买会员</a>！";
|
}
|
$return['zid'] = $zid;
|
$return['status'] = 2;
|
|
}else{
|
|
$return['msg'] = '当前账户会员已过期，请联系主账户升级！';
|
}
|
}
|
}
|
}
|
}
|
}
|
return $return;
|
}
|
/**
|
* 修改参会企业
|
* @param array $where
|
* @param array $up
|
*/
|
public function upZphnetCom($where = array(), $up = array())
|
{
|
$return = array();
|
if (!empty($where)){
|
|
$nid = $this->update_once('zphnet_com', $up, $where);
|
|
$return['errcode'] = $nid ? '9' :'8';
|
$return['msg'] = $nid ? '参会企业修改成功！' : '修改失败！';
|
}
|
return $return;
|
}
|
|
/**
|
* 修改参会企业参会职位
|
*/
|
public function editZphnetComjob($where = array(),$post = array()){
|
$return = array();
|
if (!empty($where)){
|
$up['jobid'] = $post['jobid'];
|
$nid = $this->update_once('zphnet_com', $up, $where);
|
if($nid && $post['uid']){
|
//查询职位名称
|
$jfield = '`id`,`uid`,`name`';
|
$jobwhere['id'] = array('in',$up['jobid']);
|
$listA = $this -> select_all('company_job',$jobwhere,$jfield);
|
if ($listA){
|
$jobnamestr = '';
|
foreach ($listA as $k=>$v){
|
if($jobnamestr == ''){
|
$jobnamestr .= $v['name'];
|
}else{
|
$jobnamestr .= ",".$v['name'];
|
}
|
}
|
}
|
require_once ('log.model.php');
|
$logM = new log_model($this->db, $this->def);
|
$logM -> addMemberLog($post['uid'], $post['usertype'],'修改网络招聘会参会职位：'.$jobnamestr,14,1);
|
}
|
$return['errcode'] = $nid ? '9' :'8';
|
$return['msg'] = $nid ? '参会职位修改成功！' : '修改失败！';
|
}
|
return $return;
|
}
|
/**
|
* @Desc 网络招聘会报名
|
*
|
* @param array $data
|
*/
|
private function reserveZphnet($data = array()){
|
|
$sql = array(
|
'uid' => $data['uid'],
|
'com_name' => $data['com_name'],
|
'zid' => $data['zid'],
|
'jobid' => $data['jobid'],
|
'ctime' => time(),
|
'status' => 0,
|
'did' => $data['did']
|
);
|
|
require_once('company.model.php');
|
$comM = new company_model($this->db,$this->def);
|
|
$com = $comM -> getInfo($data['uid'], array('field' => '`name`'));
|
|
$zph = $this -> getInfo(array('id' =>$data['zid']));
|
|
$nid = $this->insert_into('zphnet_com', $sql);
|
$return = array();
|
|
if ($nid){
|
require_once ('log.model.php');
|
$logM = new log_model($this->db, $this->def);
|
$logM -> addMemberLog($data['fuid'], $data['usertype'],'报名网络招聘会,ID:'.$data['zid'],14,1);
|
|
require_once('admin.model.php');
|
$adminM = new admin_model($this->db,$this->def);
|
$adminM -> sendAdminMsg(array('first'=>'有新的网络招聘会报名需要审核，企业《'.$com['name'].'》报名网络招聘会《'.$zph['title'].'》','type'=>13));
|
|
$return['status'] = 1;
|
$return['msg'] = '报名成功,等待管理员审核！';
|
|
}else{
|
$return['msg'] = '报名失败,请稍候重试！';
|
}
|
return $return;
|
}
|
function insertZphnetCom($data=array()){
|
$nid = $this->insert_into('zphnet_com', $data);
|
return $nid;
|
}
|
/**
|
* 记录用户进入网络招聘会大厅，同一招聘会不重复记录
|
* @param array $data
|
*/
|
public function addZphnetUser($data = array()){
|
|
if (!empty($data['zid']) && !empty($data['uid']) && !empty($data['usertype'])){
|
|
if ($data['usertype'] == 1 || $data['usertype'] == 2){
|
|
$row = $this->select_once('zphnet_user',array('zid'=>$data['zid'],'uid'=>$data['uid'],'usertype'=>$data['usertype']));
|
|
if (empty($row)){
|
|
if ($data['usertype'] == 1){
|
// 个人用户 能在列表正常展示的简历，才统计
|
$expect = $this->select_once('resume_expect',array('uid'=>$data['uid'],'defaults'=>1,'state'=>'1','status'=>'1','r_status'=>'1'),'`id`');
|
|
if (empty($expect)){
|
return;
|
}
|
}
|
|
$data['ctime'] = time();
|
|
$this->insert_into('zphnet_user',$data);
|
}
|
}
|
}
|
}
|
/**
|
* 查询进入大厅记录
|
*/
|
public function getZphnetUser($where = array(),$data = array('resume'=>'','keyword'=>'','photo'=>'','utype'=>''))
|
{
|
// 求职者大厅
|
if (!empty($data['resume'])){
|
|
$row = $this->select_all('zphnet_user',array('zid'=>$where['zid'],'usertype'=>1,'orderby'=>'ctime','limit'=>$data['resume']),'`uid`');
|
|
if (!empty($row)){
|
|
foreach ($row as $v){
|
|
$uids[] = $v['uid'];
|
}
|
|
include_once('resume.model.php');
|
$resumeM = new resume_model($this->db, $this->def);
|
if ($data['utype'] == 'admin'){
|
$rwhere = array('uid' => array('in', pylode(',', $uids)));
|
}else {
|
$rwhere = array('uid' => array('in', pylode(',', $uids)), 'defaults' => 1, 'state' => '1', 'status' => '1', 'r_status' => '1');
|
}
|
if (!empty($data['keyword'])){
|
|
$rwhere['name'] = array('like', $data['keyword']);
|
}
|
|
$expect = $resumeM->getList($rwhere,array('utype'=>'zphnet'));
|
|
return $expect['list'];
|
}
|
}else{
|
|
$row = $this->select_all('zphnet_user',$where);
|
|
if (!empty($row)){
|
$u = $c = array();
|
|
foreach ($row as $v){
|
|
if ($v['usertype'] == 1){
|
$u[] = $v['uid'];
|
}elseif ($v['usertype'] == 2){
|
$c[] = $v['uid'];
|
}
|
}
|
if (!empty($c)){
|
|
$com = $this->select_all('company',array('uid'=>array('in',pylode(',', $c))),'`uid`,`name`,`shortname`,`logo`,`logo_status`');
|
}
|
if (!empty($u)){
|
|
$user = $this->select_all('resume',array('uid'=>array('in',pylode(',', $u))),'`uid`,`name`,`photo`,`phototype`,`photo_status`,`sex`');
|
}
|
|
foreach ($row as $k=>$v){
|
|
foreach ($com as $val){
|
|
if ($v['uid'] == $val['uid']){
|
|
if ($val['shortname']){
|
|
$row[$k]['name'] = $val['shortname'].'进入了大厅';
|
|
}else{
|
|
$row[$k]['name'] = $val['name'].'进入了大厅';
|
}
|
if($val['logo'] !='' && $val['logo_status']==0){
|
$row[$k]['photo_n'] = checkpic($v['logo'],$this->config['sy_unit_icon']);
|
}else{
|
$row[$k]['photo_n'] = checkpic($this->config['sy_unit_icon']);
|
}
|
}
|
}
|
foreach ($user as $val){
|
|
if ($v['uid'] == $val['uid']){
|
|
$name = mb_substr($val['name'], 1, 1, 'utf8');
|
$row[$k]['name'] = str_replace($name, '*', $val['name']).'进入了大厅';
|
//设置头像
|
$maleUrl = checkpic('',$this -> config['sy_member_icon']);
|
$femaleUrl = checkpic('',$this -> config['sy_member_iconv']);
|
$sexArr = array(1, 152);
|
if($val['defphoto']==2){
|
$resumePhoto = checkpic($val['photo']);
|
}else{
|
if(empty($this -> config['user_pic']) || $this -> config['user_pic'] == 1){
|
if($val['photo'] && $val['photo_status'] == 0 && $val['phototype'] != 1){
|
$resumePhoto = checkpic($val['photo']);
|
}else{
|
if(in_array($val['sex'], $sexArr)){
|
$resumePhoto = $maleUrl;
|
}else{
|
$resumePhoto = $femaleUrl;
|
}
|
}
|
}elseif($this -> config['user_pic'] == 2){
|
if($val['photo'] && $val['photo_status'] == 0){
|
$resumePhoto = checkpic($val['photo']);
|
}else{
|
if(in_array($val['sex'], $sexArr)){
|
$resumePhoto = $maleUrl;
|
}else{
|
$resumePhoto = $femaleUrl;
|
}
|
}
|
}elseif($this -> config['user_pic'] == 3){
|
if(in_array($val['sex'], $sexArr)){
|
$resumePhoto = $maleUrl;
|
}else{
|
$resumePhoto = $femaleUrl;
|
}
|
}
|
}
|
$row[$k]['photo_n'] = $resumePhoto;
|
}
|
}
|
}
|
return $row;
|
}
|
}
|
}
|
|
/***
|
* 删除网络招聘会参会个人记录
|
* @param null $delId
|
* @param string $uid
|
* @return array
|
*/
|
public function delZphnetUser($delId = null, $uid=''){
|
|
if (empty($delId)) {
|
|
$return = array('errcode' => 8, 'msg' => '请选择要删除的数据！');
|
} else {
|
|
if (is_array($delId)) {
|
|
$delId = pylode(',', $delId);
|
|
$return['layertype'] = 1;
|
} else {
|
|
$return['layertype'] = 0;
|
}
|
$zcwhere = array('uid'=>array('in',$delId));
|
if($uid!=''){
|
$zcwhere['uid'] = $uid;
|
}
|
$return['id'] = $this -> delete_all('zphnet_user', $zcwhere, '');
|
|
$return['errcode'] = $return['id'] ? 9 : 8;
|
|
$msg = '网络招聘会参会个人（ID：'.$delId.'）';
|
|
$return['msg'] = $return['id'] ? $msg.'删除成功！' : '删除失败！';
|
}
|
return $return;
|
}
|
|
|
/**
|
* 网络招聘会查看职位记录
|
*/
|
public function addZphnetLook($data = array()){
|
|
if (!empty($data)){
|
|
if (!empty($data['uid'])){
|
|
$row = $this->select_once('zphnet_look',array('uid'=>$data['uid'],'zid'=>$data['zid'],'jobid'=>$data['jobid']));
|
}
|
// 用户登录时，个人查看才记录
|
if (empty($row) && (empty($data['usertype']) || (!empty($data['usertype']) && $data['usertype'] ==1))){
|
|
$nid = $this->insert_into('zphnet_look',$data);
|
}
|
|
return $nid;
|
}
|
}
|
/**
|
* 获取招聘会查看职位记录
|
*/
|
public function getZphnetLook($where = array()){
|
|
$list = $this->select_all('zphnet_look',$where);
|
|
if (!empty($list)){
|
|
$j = $u = $c = array();
|
|
foreach ($list as $v){
|
|
$j[] = $v['jobid'];
|
if ($v['usertype'] == 1){
|
|
$u[] = $v['uid'];
|
}
|
if (!empty($v['comid'])){
|
|
$c[] = $v['comid'];
|
}
|
}
|
if (!empty($j)){
|
$job = $this->select_all('company_job',array('id'=>array('in',pylode(',', $j))),'`id`,`name`');
|
}
|
if (!empty($u)){
|
$user = $this->select_all('resume',array('uid'=>array('in',pylode(',', $u))),'`uid`,`name`,`photo`,`phototype`,`photo_status`,`sex`');
|
}
|
if (!empty($c)){
|
$com = $this->select_all('company',array('uid'=>array('in',pylode(',', $c))),'`uid`,`name`,`shortname`,`logo`,`logo_status`');
|
}
|
|
foreach ($list as $k=>$v){
|
|
if (!empty($job)){
|
foreach ($job as $val){
|
|
if ($v['jobid'] == $val['id']){
|
|
$list[$k]['jobname'] = $val['name'];
|
}
|
}
|
}
|
|
$list[$k]['name'] = '访客';
|
$list[$k]['photo_n'] = checkpic("",$this->config['sy_member_icon']);
|
if (!empty($user)){
|
|
foreach ($user as $val){
|
|
if ($v['uid'] == $val['uid']){
|
|
$name = mb_substr($val['name'], 1, 1, 'utf8');
|
$list[$k]['name'] = str_replace($name, '*', $val['name']);
|
//设置头像
|
$maleUrl = checkpic('',$this -> config['sy_member_icon']);
|
$femaleUrl = checkpic('',$this -> config['sy_member_iconv']);
|
$sexArr = array(1, 152);
|
if($val['defphoto']==2){
|
$resumePhoto = checkpic($val['photo']);
|
}else{
|
if(empty($this -> config['user_pic']) || $this -> config['user_pic'] == 1){
|
if($val['photo'] && $val['photo_status'] == 0 && $val['phototype'] != 1){
|
$resumePhoto = checkpic($val['photo']);
|
}else{
|
if(in_array($val['sex'], $sexArr)){
|
$resumePhoto = $maleUrl;
|
}else{
|
$resumePhoto = $femaleUrl;
|
}
|
}
|
}elseif($this -> config['user_pic'] == 2){
|
if($val['photo'] && $val['photo_status'] == 0){
|
$resumePhoto = checkpic($val['photo']);
|
}else{
|
if(in_array($val['sex'], $sexArr)){
|
$resumePhoto = $maleUrl;
|
}else{
|
$resumePhoto = $femaleUrl;
|
}
|
}
|
}elseif($this -> config['user_pic'] == 3){
|
if(in_array($val['sex'], $sexArr)){
|
$resumePhoto = $maleUrl;
|
}else{
|
$resumePhoto = $femaleUrl;
|
}
|
}
|
}
|
$row[$k]['photo_n'] = $resumePhoto;
|
}
|
}
|
}
|
if (!empty($com)){
|
|
foreach ($com as $val){
|
|
if ($v['comid'] == $val['uid']){
|
|
if ($val['shortname']){
|
|
$list[$k]['comname'] = $val['shortname'];
|
|
}else{
|
|
$list[$k]['comname'] = $val['name'];
|
}
|
|
}
|
}
|
}
|
}
|
}
|
|
return $list;
|
}
|
/**
|
* wxapp 参展职位列表
|
*/
|
public function getZphnetJob($where = array(), $data = array())
|
{
|
$return = array();
|
|
if (!empty($where['zid'])){
|
|
$zphcom = $this->select_all('zphnet_com', array('zid'=>$where['zid'],'status'=>1),'`uid`,`jobid`');
|
|
if (!empty($zphcom)){
|
|
$jobids = $jobuid = array();
|
|
foreach ($zphcom as $v){
|
|
$cuid[] = $v['uid'];
|
|
if($v['jobid']){
|
|
$jobarr = @explode(',',$v['jobid']);
|
$jobids = array_merge($jobids,$jobarr);
|
|
}else{
|
|
if(!in_array($v['uid'] , $jobuid)){
|
$jobuid[] = $v['uid'];
|
}
|
}
|
}
|
|
$jwhere = array(
|
'state' => 1,
|
'status' => 0,
|
'r_status' => 1
|
);
|
|
$jwhere['PHPYUNBTWSTART'] = 1;
|
$jwhere['uid'] = array('in',pylode(',',$jobuid));
|
$jwhere['id'] = array('in',pylode(',',$jobids),'OR');
|
$jwhere['PHPYUNBTWEND'] = 1;
|
|
if (!empty($data['keyword'])){
|
|
$jwhere['name'] = array('like',$data['keyword']);
|
}
|
$jwhere['limit'] = $where['limit'];
|
|
$job = $this->select_all('company_job',$jwhere,'`id`,`uid`,`name`,`exp`,`edu`,`minsalary`,`maxsalary`');
|
|
if (!empty($job)){
|
|
foreach ($job as $v){
|
|
$juid[] = $v['uid'];
|
}
|
$juid = array_unique($juid);
|
|
$com = $this->select_all('company',array('uid'=>array('in',pylode(',', $juid))),'`uid`,`name`,`shortname`');
|
|
include_once('cache.model.php');
|
$cacheM = new cache_model($this->db,$this->def);
|
$cache = $cacheM -> GetCache('com');
|
|
foreach ($job as $k=>$v){
|
|
$job[$k]['exp_n'] = $cache['comclass_name'][$v['exp']].'经验';
|
$job[$k]['edu_n'] = $cache['comclass_name'][$v['edu']].'学历';
|
|
if (!empty($v['minsalary']) || !empty($v['minsalary'])) {
|
|
if(!empty($v['minsalary']) && !empty($v['maxsalary'])){
|
if($this ->config['resume_salarytype']==1){
|
$job[$k]['job_salary'] = $v['minsalary'].'-'.$v['maxsalary'].'元';
|
}else{
|
if($v['maxsalary']<1000){
|
if($this->config['resume_salarytype']==2){
|
$job[$k]['job_salary'] = '1千以下';
|
}elseif($this->config['resume_salarytype']==3){
|
$job[$k]['job_salary'] = '1K以下';
|
}elseif($this->config['resume_salarytype']==4){
|
$job[$k]['job_salary'] = '1k以下';
|
}
|
}else{
|
$job[$k]['job_salary'] = changeSalary($v['minsalary']).'-'.changeSalary($v['maxsalary']);
|
}
|
}
|
}elseif (!empty($v['minsalary'])){
|
if($this ->config['resume_salarytype']==1){
|
$job[$k]['job_salary'] = $v['minsalary'].'元';
|
}else{
|
$job[$k]['job_salary'] = changeSalary($v['minsalary']);
|
}
|
}else{
|
|
$job[$k]['job_salary'] = '面议';
|
}
|
}else{
|
|
$job[$k]['job_salary'] = '面议';
|
}
|
|
foreach ($com as $val){
|
|
if ($v['uid'] == $val['uid']){
|
|
if ($val['shortname']){
|
|
$job[$k]['comname'] = $val['shortname'];
|
|
}else {
|
|
$job[$k]['comname'] = $val['name'];
|
}
|
}
|
}
|
}
|
}
|
}
|
if (!empty($job)){
|
|
$return = $job;
|
}
|
|
return $return;
|
}
|
}
|
/**
|
* 推荐企业类别列表
|
*/
|
public function getClassList($where = array(), $data = array())
|
{
|
|
$list = $this->select_all('zphnet_class',$where);
|
|
return $list;
|
}
|
/**
|
* 展位分区类别
|
*/
|
public function getClass($where = array())
|
{
|
|
$list = $this->select_once('zphnet_class',$where);
|
return $list;
|
}
|
/**
|
* 添加或更新展位分区
|
* $addData 提交分类数据
|
* $whereData 更新分类查询条件
|
*/
|
function addClass($addData=array(),$whereData = array()){
|
|
if(!empty($whereData)){
|
if($addData['name']){//修改名称
|
$type = '名称';
|
}else{
|
unset($addData['name']);
|
}
|
if($addData['sort']){//修改排序
|
$type = '排序';
|
}else{
|
unset($addData['sort']);
|
}
|
$this->update_once('zphnet_class',$addData,$whereData);
|
$showid = $whereData['id'] ? "(ID:".$whereData['id'].")" : '';
|
$this->adminLog('网络招聘会展位分区类别'.$showid.$type.'修改成功');
|
}else{
|
$name = array();
|
foreach ($addData['name'] as $val){
|
if($val){
|
$name[] = $val;
|
}
|
}
|
|
if($addData['keyid']){
|
$where['keyid'] = $addData['keyid'];
|
}
|
if(count($name)){
|
$where['name'] = array('in',"'".@implode("','",$name)."'");
|
}
|
//检查提交的类别名称是否有同名
|
$class = $this->getClassList($where);
|
$valueData = array();
|
|
if(empty($class)){//没有同名类则正常添加
|
if($addData['ctype'] == '1'){//添加的是一级分类
|
foreach ($name as $key => $val){
|
$valueData[$key]['name'] = $val;
|
|
}
|
}else{//添加二级分类
|
foreach ($name as $key => $val){
|
$valueData[$key]['name'] = $val;
|
$valueData[$key]['keyid'] = intval($addData['keyid']);
|
}
|
}
|
$nid = $this->DB_insert_multi('zphnet_class',$valueData);
|
$return['msg'] = $nid ? 2 : 3;
|
$this -> adminLog('网络招聘会展位分区类别添加成功');
|
}else{//有同名类，给出提示
|
$return['msg'] = 1;
|
}
|
}
|
return $return;
|
}
|
/**
|
* 修改企业推荐类别
|
*/
|
public function insertClass($data = array())
|
{
|
if (!empty($data)){
|
|
$zcid = $this->insert_into('zphnet_class', $data);
|
|
return $zcid;
|
}
|
}
|
/**
|
* 修改企业推荐类别
|
*/
|
public function upClass($where = array(), $data = array())
|
{
|
if (!empty($data)){
|
|
$this->update_once('zphnet_class', $data, $where);
|
}
|
}
|
/**
|
* 删除招聘会企业推荐类别
|
*/
|
public function delClass($delId){
|
|
if (empty($delId)) {
|
|
$return = array( 'errcode' => 8, 'msg' => '请选择要删除的数据！');
|
|
} else {
|
|
if (is_array($delId)) {
|
|
$delId = pylode(',', $delId);
|
|
$return['layertype'] = 1;
|
|
} else {
|
|
$return['layertype'] = 0;
|
}
|
|
$id = array();
|
$sclass = $this -> select_all('zphnet_class',array('id' => array('in', $delId)),'id');
|
foreach ($sclass as $key => $value) {
|
$id[] = $value['id'];
|
}
|
$ids = $this->sonclass('zphnet_class',$id);//获取当前项及其所有子类的id集合
|
if(count($ids)){
|
$result = $this->delete_all('zphnet_class',array('id'=>array('in',pylode(',',$ids))),'');
|
}
|
$return['errcode'] = $result ? '9' :'8';
|
$return['msg'] = $result ? '网络招聘会展位分区类别删除成功！' : '删除失败！';
|
}
|
|
return $return;
|
}
|
function sonclass($table,$id=array()){
|
$ids = array();
|
if(count($id)){
|
$class = $this -> select_all($table,array('keyid'=>array('in',pylode(',',$id))),'id');
|
if($class&&is_array($class)){
|
foreach($class as $val){
|
$ids[] = $val['id'];
|
}
|
}
|
$ids = array_merge($id,$ids);
|
}
|
return $ids;
|
}
|
|
/**
|
* 修改招聘前台显示
|
*/
|
|
public function upIsOpen($id,$is_open){
|
if (!empty($id)) {
|
$result = $this->update_once('zphnet',array('is_open' => $is_open), array('id' => $id));
|
|
if ($result){
|
$return['msg'] = '修改成功！';
|
$return['errcode'] = 9;
|
}else{
|
$return['msg'] = '修改失败！';
|
$return['errcode'] = 8;
|
}
|
}else{
|
$return['msg'] = '参数错误！';
|
$return['errcode'] = 8;
|
}
|
return $return;
|
}
|
|
/*
|
* 添加管理员日志
|
*/
|
function adminLog($content, $opera = '', $type = '', $opera_id=''){
|
require_once('log.model.php');
|
$logM = new log_model($this->db,$this->def);
|
return $logM -> addAdminLog($content, $opera = '', $type = '', $opera_id='');
|
}
|
|
//更新网络招聘会浏览数
|
function addZphnetHits($id){
|
if($this -> config['sy_job_hits'] > 100 || !$this -> config['sy_job_hits']){
|
$hits = 1;
|
}else{
|
$hits = mt_rand(1, $this->config['sy_job_hits']);
|
}
|
|
$this -> update_once('zphnet', array('hits' => array('+', $hits)), array('id' => $id));
|
}
|
}
|
?>
|
