您当前的位置： 首页 > 找工作
tpl_vars['member']->value)&&$_smarty_tpl->tpl_vars['member']->value['usertype']==1&&$_smarty_tpl->tpl_vars['member']->value['unionid']==''&&$_smarty_tpl->tpl_vars['member']->value['wxid']==''&&$_smarty_tpl->tpl_vars['wxtz_tips']->value==0) {?>
tpl_vars['zd_list'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['zd_list']->_loop = false;
$_smarty_tpl->tpl_vars['key'] = new Smarty_Variable;
global $db,$db_config,$config;
$time = time();
//可以做缓存
$paramer=array("namelen"=>"30","comlen"=>"30","report"=>"'auto.report'","hy"=>"'auto.hy'","job1"=>"'auto.job1'","welfare"=>"'auto.welfare'","job1_son"=>"'auto.job1_son'","job_post"=>"'auto.job_post'","jobids"=>"'auto.jobids'","pr"=>"'auto.pr'","mun"=>"'auto.mun'","provinceid"=>"'auto.provinceid'","cityid"=>"'auto.cityid'","three_cityid"=>"'auto.three_cityid'","type"=>"'auto.type'","edu"=>"'auto.edu'","exp"=>"'auto.exp'","sex"=>"'auto.sex'","minsalary"=>"'auto.minsalary'","maxsalary"=>"'auto.maxsalary'","keyword"=>"'auto.keyword'","cert"=>"'auto.cert'","urgent"=>"'auto.urgent'","rec"=>"'auto.rec'","bid"=>"1","uptime"=>"'auto.uptime'","key"=>"'key'","item"=>"'zd_list'","name"=>"'zdlist1'","nocache"=>"")
;
$ParamerArr = GetSmarty($paramer,$_GET,$_smarty_tpl);
$paramer = $ParamerArr[arr];
$Purl = $ParamerArr[purl];
global $ModuleName;
if(!$Purl["m"]){
$Purl["m"]=$ModuleName;
}
include_once PLUS_PATH."/comrating.cache.php";
include(CONFIG_PATH."db.data.php");
if($config[sy_web_site]=="1"){
if($config[province]>0 && $config[province]!=""){
$paramer[provinceid] = $config[province];
}
if($config[cityid]>0 && $config[cityid]!=""){
$paramer[cityid] = $config[cityid];
}
if($config[three_cityid]>0 && $config[three_cityid]!=""){
$paramer[three_cityid] = $config[three_cityid];
}
if($config[hyclass]>0 && $config[hyclass]!=""){
$paramer[hy]=$config[hyclass];
}
}
if($paramer[sdate]){
$where = "`sdate`>".strtotime("-".intval($paramer[sdate])." day",time())." and `state`=1";
}else{
$where = "`state`=1";
}
//按照UID来查询（按公司地址查询可用GET[id]获取当前公司ID）
if($paramer[uid]){
$where .= " AND `uid` = '$paramer[uid]'";
}
if($paramer[com_id]){
$where .= " AND `uid` = '$paramer[com_id]'";
}
//是否推荐职位
if($paramer[rec]){
$where.=" AND `rec_time`>=".time();
}
//企业认证条件
if($paramer['cert']){
$job_uid=array();
$company=$db->select_all("company","`yyzz_status`=1","`uid`");
if(is_array($company)){
foreach($company as $v){
$job_uid[]=$v['uid'];
}
}
$where.=" and `uid` in (".@implode(",",$job_uid).")";
}
//取不包含当前企业的职位
if($paramer[nouid]){
$where.= " and `uid`<>$paramer[nouid]";
}
//取不包含当前id的职位
if($paramer[noid]){
$where.= " and `id`<>$paramer[noid]";
}
//是否被锁定
if($paramer[r_status]){
$where.= " and `r_status`=2";
}else{
$where.= " and `r_status`=1";
}
//是否下架职位
if($paramer[status]){
$where.= " and `status`='1'";
}else{
$where.= " and `status`='0'";
}
//公司体制
if($paramer[pr]){
$where .= " AND `pr` =$paramer[pr]";
}
//公司行业分类
if($paramer['hy']){
$where .= " AND `hy` = $paramer[hy]";
}
//职位大类
if($paramer[job1]){
$where .= " AND `job1` = $paramer[job1]";
}
//职位子类
if($paramer[job1_son]){
$where .= " AND `job1_son` = $paramer[job1_son]";
}
//职位三级分类
if($paramer[job_post]){
$where .= " AND (`job_post` IN ($paramer[job_post]))";
}
//您可能感兴趣的职位--个人会员中心
if($paramer['jobwhere']){
$where .=" and ".$paramer['jobwhere'];
}
//职位分类综合查询
if($paramer['jobids']){
$where.= " AND (`job1` = '$paramer[jobids]' OR `job1_son`= '$paramer[jobids]' OR `job_post`='$paramer[jobids]')";
}
//职位分类区间,不建议执行该查询
if($paramer['jobin']){
$where .= " AND (`job1` IN ($paramer[jobin]) OR `job1_son` IN ($paramer[jobin]) OR `job_post` IN ($paramer[jobin]))";
}
//城市大类
if($paramer[provinceid]){
$where .= " AND `provinceid` = $paramer[provinceid]";
}
//城市子类
if($paramer['cityid']){
$where .= " AND (`cityid` IN ($paramer[cityid]))";
}
//城市三级子类
if($paramer['three_cityid']){
$where .= " AND (`three_cityid` IN ($paramer[three_cityid]))";
}
if($paramer['cityin']){
$where .= " AND `three_cityid` IN ($paramer[cityin])";
}
//学历
if($paramer[edu]){
$eduKey = $db->DB_select_once("comclass", "`variable` = 'job_edu'", "`id`");
$eduReq = $db->DB_select_once("comclass", "`id` = $paramer[edu]", "`sort`,`name`");
if($eduReq[name] != "不限"){
$eduArr = $db->select_all("comclass", "`keyid` = $eduKey[id] AND `sort` <= $eduReq[sort]", "`id`");
$eduIds = array();
foreach($eduArr as $v){
$eduIds[] = $v[id];
}
$where .= " AND `edu` in (".@implode(",",$eduIds).")";
}
}
//工作经验
if($paramer[exp]){
$expKey = $db->DB_select_once("comclass", "`variable` = 'job_exp'", "`id`");
$expReq = $db->DB_select_once("comclass", "`id` = $paramer[exp]", "`sort`,`name`");
if($expReq[name] != "不限"){
$expArr = $db->select_all("comclass", "`keyid` = $expKey[id] AND `sort` <= $expReq[sort]", "`id`");
$expIds = array();
foreach($expArr as $v){
$expIds[] = $v[id];
}
$where .= " AND `exp` in (".@implode(",",$expIds).")";
}
}
//到岗时间
if($paramer[report]){
$where .= " AND `report` = $paramer[report]";
}
//职位性质
if($paramer[type]){
$where .= " AND `type` = $paramer[type]";
}
//性别
if($paramer[sex]){
$where .= " AND `sex` = $paramer[sex]";
}
//应届生
if($paramer[is_graduate]){
$where .= " AND `is_graduate` = $paramer[is_graduate]";
}
//公司规模
if($paramer[mun]){
$where .= " AND `mun` = $paramer[mun]";
}
if($paramer[minsalary] && $paramer[maxsalary]){
$where.= " AND (`minsalary`>=".intval($paramer[minsalary])." and `minsalary`<=".intval($paramer[maxsalary])." and `maxsalary`<=".intval($paramer[maxsalary]).") ";
}elseif($paramer[minsalary]&&!$paramer[maxsalary]){
$where.= " AND (`minsalary`>=".intval($paramer[minsalary]).") ";
}elseif(!$paramer[minsalary]&&$paramer[maxsalary]){
$where.= " AND (`minsalary`<=".intval($paramer[maxsalary])." and `maxsalary`<=".intval($paramer[maxsalary]).") ";
}
//福利待遇
$cache_array = $db->cacheget();
$comclass_name = $cache_array["comclass_name"];
if($paramer[welfare]){
$welfarename=$comclass_name[$paramer[welfare]];
$where .=" AND `welfare` LIKE '%".$welfarename."%' ";
}
//城市区间,不建议执行该查询
if($paramer[cityin]){
$where .= " AND (`provinceid` IN ($paramer[cityin]) OR `cityid` IN ($paramer[cityin]) OR `three_cityid` IN ($paramer[cityin]))";
}
//紧急招聘urgent
if($paramer[urgent]){
$where.=" AND `urgent_time`>".time();
}
//更新时间区间
if($paramer[uptime]){
if($paramer[uptime]==1){
$beginToday=mktime(0,0,0,date('m'),date('d'),date('Y'));
$where.=" AND lastupdate>$beginToday";
}else{
$time=time();
$uptime = $time-($paramer[uptime]*86400);
$where.=" AND lastupdate>$uptime";
}
}else{
if($config[sy_datacycle]>0){
// 后台-页面设置-数据周期
$uptime = strtotime('-'.$config[sy_datacycle].' day');
$where.=" AND lastupdate>$uptime";
}
}
//按类似公司名称,不建议进行大数据量操作
if($paramer[comname]){
$where.=" AND `com_name` LIKE '%".$paramer[comname]."%'";
}
//按公司归属地,只适合查询一级城市分类
if($paramer[com_pro]){
$where.=" AND `com_provinceid` ='".$paramer[com_pro]."'";
}
//按照职位名称匹配
if($paramer[keyword]){
$where1[]="`name` LIKE '%".$paramer[keyword]."%'";
$where1[]="`com_name` LIKE '%".$paramer[keyword]."%'";
include PLUS_PATH."/city.cache.php";
foreach($city_name as $k=>$v){
if(strpos($v,$paramer[keyword])!==false){
$cityid[]=$k;
}
}
if(is_array($cityid)){
foreach($cityid as $value){
$class[]= "(provinceid = '".$value."' or cityid = '".$value."')";
}
$where1[]=@implode(" or ",$class);
}
$where.=" AND (".@implode(" or ",$where1).")";
}
//多选职位
if($paramer["job"]){
$where.=" AND `job_post` in ($paramer[job])";
}
//置顶招聘
if($paramer[bid]){
if($config[joblist_top]!=1){
$paramer[limit] = 5;
}
$where.=" and `xsdate`>'".time()."'";
}
//自定义查询条件，默认取代上面任何参数直接使用该语句
if($paramer[where]){
$where = $paramer[where];
}
//查询条数
$limit = '';
if($paramer[limit]){
$limit = " limit ".$paramer[limit];
}
if($paramer[ispage]){
$limit = PageNav($paramer,$_GET,"company_job",$where,$Purl,"",$paramer[islt]?$paramer[islt]:"6",$_smarty_tpl);
}
//排序字段默认为更新时间
//置顶设置为随机5条时，随机查询
if($paramer[bid] && $paramer[limit]){
$order = " ORDER BY rand() ";
}else{
if($paramer[order] && $paramer[order]!="lastdate"){
$order = " ORDER BY ".str_replace("'","",$paramer[order])." ";
}else{
$order = " ORDER BY `lastupdate` ";
}
}
//排序规则 默认为倒序
if($paramer[sort]){
$sort = $paramer[sort];
}else{
$sort = " DESC";
}
$where.=$order.$sort;
$zd_list = $db->select_all("company_job",$where.$limit);
if(is_array($zd_list) && !empty($zd_list)){
//处理类别字段
$cache_array = $db->cacheget();
$comuid=$jobid=array();
foreach($zd_list as $key=>$value){
if(in_array($value['uid'],$comuid)==false){$comuid[] = $value['uid'];}
if(in_array($value['id'],$jobid)==false){$jobid[] = $value['id'];}
}
$comuids = @implode(',',$comuid);
$jobids = @implode(',',$jobid);
//减少曝光量统计维度 只有列表才统计
if($paramer[ispage]){
$db->update_all("company_job", "`jobexpoure` = `jobexpoure` + 1", "`id` in ($jobids)");
}
if($comuids){
$r_uids=$db->select_all("company","`uid` IN (".$comuids.")","`uid`,`yyzz_status`,`logo`,`logo_status`,`pr`,`hy`,`mun`,`shortname`,`welfare`,`hotstart`,`hottime`");
if(is_array($r_uids)){
foreach($r_uids as $key=>$value){
if($value[shortname]){
$value['shortname_n'] = $value[shortname];
}
if(!$value['logo'] || $value['logo_status']!=0){
$value['logo'] = checkpic("",$config['sy_unit_icon']);
}else{
$value['logo']= checkpic($value['logo']);
}
$value['pr_n'] = $cache_array['comclass_name'][$value[pr]];
$value['hy_n'] = $cache_array['industry_name'][$value[hy]];
$value['mun_n'] = $cache_array['comclass_name'][$value[mun]];
if($value['hotstart']<=time() && $value['hottime']>=time()){
$value['hotlogo'] = 1;
}
$r_uid[$value['uid']] = $value;
}
}
}
if($paramer[bid]){
$noids=array();
}
foreach($zd_list as $key=>$value){
if($paramer[bid]){
$noids[] = $value[id];
}
//筛除重复
if($paramer[noids]==1 && !empty($noids) && in_array($value['id'],$noids)){
unset($zd_list[$key]);
continue;
}else{
$zd_list[$key] = $db->array_action($value,$cache_array);
$zd_list[$key][stime] = date("Y-m-d",$value[sdate]);
$zd_list[$key][etime] = date("Y-m-d",$value[edate]);
if($arr_data['sex'][$value['sex']]){
$zd_list[$key][sex_n]=$arr_data['sex'][$value['sex']];
}
$zd_list[$key][lastupdate] =lastupdateStyle($value[lastupdate]);
if($value[minsalary]&&$value[maxsalary]){
if($config['resume_salarytype']==1){
$zd_list[$key][job_salary] =$value[minsalary]."-".$value[maxsalary];
}else{
if($value[maxsalary]<1000){
if($config['resume_salarytype']==2){
$zd_list[$key][job_salary] = "1千以下";
}elseif($config['resume_salarytype']==3){
$zd_list[$key][job_salary] = "1K以下";
}elseif($config['resume_salarytype']==4){
$zd_list[$key][job_salary] = "1k以下";
}
}else if($value[minsalary]<1000){
$zd_list[$key][job_salary] =changeSalary($value[maxsalary]);
}else{
$zd_list[$key][job_salary] =changeSalary($value[minsalary])."-".changeSalary($value[maxsalary]);
}
}
}elseif($value[minsalary]){
if($config['resume_salarytype']==1){
$zd_list[$key][job_salary] =$value[minsalary]."以上";
}else{
$zd_list[$key][job_salary] =changeSalary($value[minsalary])."以上";
}
}else{
$zd_list[$key][job_salary] ="面议";
}
if($r_uid[$value['uid']][shortname]){
$zd_list[$key][com_name] =$r_uid[$value['uid']][shortname];
}
if(!empty($value[zp_minage]) && !empty($value[zp_maxage])){
if($value[zp_minage]==$value[zp_maxage]){
$zd_list[$key][job_age] = $value[zp_minage]."周岁以上";
}else{
$zd_list[$key][job_age] = $value[zp_minage]."-".$value[zp_maxage]."周岁";
}
}else if(!empty($value[zp_minage]) && empty($value[zp_maxage])){
$zd_list[$key][job_age] = $value[zp_minage]."周岁以上";
}else{
$zd_list[$key][job_age] = 0;
}
if($value[zp_num]==0){
$zd_list[$key][job_number] = "";
}else{
$zd_list[$key][job_number] = $value[zp_num]." 人";
}
$zd_list[$key][yyzz_status] =$r_uid[$value['uid']][yyzz_status];
$zd_list[$key][logo] =$r_uid[$value['uid']][logo];
$zd_list[$key][pr_n] =$r_uid[$value['uid']][pr_n];
$zd_list[$key][hy_n] =$r_uid[$value['uid']][hy_n];
$zd_list[$key][mun_n] =$r_uid[$value['uid']][mun_n];
$zd_list[$key][hotlogo] =$r_uid[$value['uid']][hotlogo];
$time=$value['lastupdate'];
//今天开始时间戳
$beginToday=mktime(0,0,0,date('m'),date('d'),date('Y'));
//昨天开始时间戳
$beginYesterday=mktime(0,0,0,date('m'),date('d')-1,date('Y'));
if($time>$beginYesterday && $time<$beginToday){
$zd_list[$key]['time'] ="昨天";
}elseif($time>$beginToday){
$zd_list[$key]['time'] = $zd_list[$key]['lastupdate'];
$zd_list[$key]['redtime'] =1;
}else{
$zd_list[$key]['time'] = date("Y-m-d",$value['lastupdate']);
}
// 前天
$beforeYesterday=mktime(0,0,0,date('m'),date('d')-2,date('Y'));
if($value['sdate']>$beforeYesterday){
$zd_list[$key]['newtime'] =1;
}
//获得福利待遇名称
if($value[welfare]){
$value[welfare] = str_replace(' ', '',$value[welfare]);
$welfareList = @explode(',',trim($value[welfare]));
if(!empty($welfareList)){
$zd_list[$key][welfarename] =array_filter($welfareList);
}
}
//截取公司名称
if($paramer[comlen]){
if($r_uid[$value['uid']][shortname]){
$zd_list[$key][com_n] = mb_substr($r_uid[$value['uid']][shortname],0,$paramer[comlen],"utf-8");
}else{
$zd_list[$key][com_n] = mb_substr($value['com_name'],0,$paramer[comlen],"utf-8");
}
}
//截取职位名称
if($paramer[namelen]){
if($value['rec_time']>time()){
$zd_list[$key][name_n] = "".mb_substr($value['name'],0,$paramer[namelen],"utf-8")."";
}else{
$zd_list[$key][name_n] = mb_substr($value['name'],0,$paramer[namelen],"utf-8");
}
}else{
if($value['rec_time']>time()){
$zd_list[$key]['name_n'] = "".$value['name']."";
}else{
$zd_list[$key][name_n] = $value['name'];
}
}
//构建职位伪静态URL
$zd_list[$key][job_url] = Url("job",array("c"=>"comapply","id"=>$value[id]),"1");
//构建企业伪静态URL
$zd_list[$key][com_url] = Url("company",array("c"=>"show","id"=>$value[uid]));
foreach($comrat as $k=>$v){
if($value[rating]==$v[id]){
$zd_list[$key][color] = str_replace("#","",$v[com_color]);
if($v[com_pic]){
$zd_list[$key][ratlogo] = checkpic($v[com_pic]);
}
$zd_list[$key][ratname] = $v[name];
}
}
if($paramer[keyword]){
$zd_list[$key][name]=str_replace($paramer[keyword],"".$paramer[keyword]."",$value[name]);
$zd_list[$key][name_n]=str_replace($paramer[keyword],"".$paramer[keyword]."",$zd_list[$key][name_n]);
$zd_list[$key][com_n]=str_replace($paramer[keyword],"".$paramer[keyword]."",$zd_list[$key][com_n]);
$zd_list[$key][job_city_one]=str_replace($paramer[keyword],"".$paramer[keyword]."",$city_name[$value[provinceid]]);
$zd_list[$key][job_city_two]=str_replace($paramer[keyword],"".$paramer[keyword]."",$city_name[$value[cityid]]);
}
}
}
if(is_array($zd_list)){
if($paramer[keyword]!=""&&!empty($zd_list)){
addkeywords('3',$paramer[keyword]);
}
}
}$zd_list = $zd_list; if (!is_array($zd_list) && !is_object($zd_list)) { settype($zd_list, 'array');}
foreach ($zd_list as $_smarty_tpl->tpl_vars['zd_list']->key => $_smarty_tpl->tpl_vars['zd_list']->value) {
$_smarty_tpl->tpl_vars['zd_list']->_loop = true;
$_smarty_tpl->tpl_vars['key']->value = $_smarty_tpl->tpl_vars['zd_list']->key;
?>
tpl_vars['job_list'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['job_list']->_loop = false;
$_smarty_tpl->tpl_vars['key'] = new Smarty_Variable;
global $db,$db_config,$config;
$time = time();
//可以做缓存
$paramer=array("namelen"=>"30","comlen"=>"30","noids"=>"1","ispage"=>"1","report"=>"'auto.report'","welfare"=>"'auto.welfare'","rec"=>"'auto.rec'","hy"=>"'auto.hy'","job1"=>"'auto.job1'","job1_son"=>"'auto.job1_son'","job_post"=>"'auto.job_post'","jobids"=>"'auto.jobids'","pr"=>"'auto.pr'","mun"=>"'auto.mun'","provinceid"=>"'auto.provinceid'","cityid"=>"'auto.cityid'","ltype"=>"'auto.ltype'","three_cityid"=>"'auto.three_cityid'","type"=>"'auto.type'","edu"=>"'auto.edu'","exp"=>"'auto.exp'","sex"=>"'auto.sex'","minsalary"=>"'auto.minsalary'","maxsalary"=>"'auto.maxsalary'","keyword"=>"'auto.keyword'","key"=>"'key'","sdate"=>"'auto.sdate'","cert"=>"'auto.cert'","urgent"=>"'auto.urgent'","uptime"=>"'auto.uptime'","order"=>"'auto.order'","limit"=>"20","item"=>"'job_list'","name"=>"'joblist1'","nocache"=>"")
;
$ParamerArr = GetSmarty($paramer,$_GET,$_smarty_tpl);
$paramer = $ParamerArr[arr];
$Purl = $ParamerArr[purl];
global $ModuleName;
if(!$Purl["m"]){
$Purl["m"]=$ModuleName;
}
include_once PLUS_PATH."/comrating.cache.php";
include(CONFIG_PATH."db.data.php");
if($config[sy_web_site]=="1"){
if($config[province]>0 && $config[province]!=""){
$paramer[provinceid] = $config[province];
}
if($config[cityid]>0 && $config[cityid]!=""){
$paramer[cityid] = $config[cityid];
}
if($config[three_cityid]>0 && $config[three_cityid]!=""){
$paramer[three_cityid] = $config[three_cityid];
}
if($config[hyclass]>0 && $config[hyclass]!=""){
$paramer[hy]=$config[hyclass];
}
}
if($paramer[sdate]){
$where = "`sdate`>".strtotime("-".intval($paramer[sdate])." day",time())." and `state`=1";
}else{
$where = "`state`=1";
}
//按照UID来查询（按公司地址查询可用GET[id]获取当前公司ID）
if($paramer[uid]){
$where .= " AND `uid` = '$paramer[uid]'";
}
if($paramer[com_id]){
$where .= " AND `uid` = '$paramer[com_id]'";
}
//是否推荐职位
if($paramer[rec]){
$where.=" AND `rec_time`>=".time();
}
//企业认证条件
if($paramer['cert']){
$job_uid=array();
$company=$db->select_all("company","`yyzz_status`=1","`uid`");
if(is_array($company)){
foreach($company as $v){
$job_uid[]=$v['uid'];
}
}
$where.=" and `uid` in (".@implode(",",$job_uid).")";
}
//取不包含当前企业的职位
if($paramer[nouid]){
$where.= " and `uid`<>$paramer[nouid]";
}
//取不包含当前id的职位
if($paramer[noid]){
$where.= " and `id`<>$paramer[noid]";
}
//是否被锁定
if($paramer[r_status]){
$where.= " and `r_status`=2";
}else{
$where.= " and `r_status`=1";
}
//是否下架职位
if($paramer[status]){
$where.= " and `status`='1'";
}else{
$where.= " and `status`='0'";
}
//公司体制
if($paramer[pr]){
$where .= " AND `pr` =$paramer[pr]";
}
//公司行业分类
if($paramer['hy']){
$where .= " AND `hy` = $paramer[hy]";
}
//职位大类
if($paramer[job1]){
$where .= " AND `job1` = $paramer[job1]";
}
//职位子类
if($paramer[job1_son]){
$where .= " AND `job1_son` = $paramer[job1_son]";
}
//职位三级分类
if($paramer[job_post]){
$where .= " AND (`job_post` IN ($paramer[job_post]))";
}
//您可能感兴趣的职位--个人会员中心
if($paramer['jobwhere']){
$where .=" and ".$paramer['jobwhere'];
}
//职位分类综合查询
if($paramer['jobids']){
$where.= " AND (`job1` = '$paramer[jobids]' OR `job1_son`= '$paramer[jobids]' OR `job_post`='$paramer[jobids]')";
}
//职位分类区间,不建议执行该查询
if($paramer['jobin']){
$where .= " AND (`job1` IN ($paramer[jobin]) OR `job1_son` IN ($paramer[jobin]) OR `job_post` IN ($paramer[jobin]))";
}
//城市大类
if($paramer[provinceid]){
$where .= " AND `provinceid` = $paramer[provinceid]";
}
//城市子类
if($paramer['cityid']){
$where .= " AND (`cityid` IN ($paramer[cityid]))";
}
//城市三级子类
if($paramer['three_cityid']){
$where .= " AND (`three_cityid` IN ($paramer[three_cityid]))";
}
if($paramer['cityin']){
$where .= " AND `three_cityid` IN ($paramer[cityin])";
}
//学历
if($paramer[edu]){
$eduKey = $db->DB_select_once("comclass", "`variable` = 'job_edu'", "`id`");
$eduReq = $db->DB_select_once("comclass", "`id` = $paramer[edu]", "`sort`,`name`");
if($eduReq[name] != "不限"){
$eduArr = $db->select_all("comclass", "`keyid` = $eduKey[id] AND `sort` <= $eduReq[sort]", "`id`");
$eduIds = array();
foreach($eduArr as $v){
$eduIds[] = $v[id];
}
$where .= " AND `edu` in (".@implode(",",$eduIds).")";
}
}
//工作经验
if($paramer[exp]){
$expKey = $db->DB_select_once("comclass", "`variable` = 'job_exp'", "`id`");
$expReq = $db->DB_select_once("comclass", "`id` = $paramer[exp]", "`sort`,`name`");
if($expReq[name] != "不限"){
$expArr = $db->select_all("comclass", "`keyid` = $expKey[id] AND `sort` <= $expReq[sort]", "`id`");
$expIds = array();
foreach($expArr as $v){
$expIds[] = $v[id];
}
$where .= " AND `exp` in (".@implode(",",$expIds).")";
}
}
//到岗时间
if($paramer[report]){
$where .= " AND `report` = $paramer[report]";
}
//职位性质
if($paramer[type]){
$where .= " AND `type` = $paramer[type]";
}
//性别
if($paramer[sex]){
$where .= " AND `sex` = $paramer[sex]";
}
//应届生
if($paramer[is_graduate]){
$where .= " AND `is_graduate` = $paramer[is_graduate]";
}
//公司规模
if($paramer[mun]){
$where .= " AND `mun` = $paramer[mun]";
}
if($paramer[minsalary] && $paramer[maxsalary]){
$where.= " AND (`minsalary`>=".intval($paramer[minsalary])." and `minsalary`<=".intval($paramer[maxsalary])." and `maxsalary`<=".intval($paramer[maxsalary]).") ";
}elseif($paramer[minsalary]&&!$paramer[maxsalary]){
$where.= " AND (`minsalary`>=".intval($paramer[minsalary]).") ";
}elseif(!$paramer[minsalary]&&$paramer[maxsalary]){
$where.= " AND (`minsalary`<=".intval($paramer[maxsalary])." and `maxsalary`<=".intval($paramer[maxsalary]).") ";
}
//福利待遇
$cache_array = $db->cacheget();
$comclass_name = $cache_array["comclass_name"];
if($paramer[welfare]){
$welfarename=$comclass_name[$paramer[welfare]];
$where .=" AND `welfare` LIKE '%".$welfarename."%' ";
}
//城市区间,不建议执行该查询
if($paramer[cityin]){
$where .= " AND (`provinceid` IN ($paramer[cityin]) OR `cityid` IN ($paramer[cityin]) OR `three_cityid` IN ($paramer[cityin]))";
}
//紧急招聘urgent
if($paramer[urgent]){
$where.=" AND `urgent_time`>".time();
}
//更新时间区间
if($paramer[uptime]){
if($paramer[uptime]==1){
$beginToday=mktime(0,0,0,date('m'),date('d'),date('Y'));
$where.=" AND lastupdate>$beginToday";
}else{
$time=time();
$uptime = $time-($paramer[uptime]*86400);
$where.=" AND lastupdate>$uptime";
}
}else{
if($config[sy_datacycle]>0){
// 后台-页面设置-数据周期
$uptime = strtotime('-'.$config[sy_datacycle].' day');
$where.=" AND lastupdate>$uptime";
}
}
//按类似公司名称,不建议进行大数据量操作
if($paramer[comname]){
$where.=" AND `com_name` LIKE '%".$paramer[comname]."%'";
}
//按公司归属地,只适合查询一级城市分类
if($paramer[com_pro]){
$where.=" AND `com_provinceid` ='".$paramer[com_pro]."'";
}
//按照职位名称匹配
if($paramer[keyword]){
$where1[]="`name` LIKE '%".$paramer[keyword]."%'";
$where1[]="`com_name` LIKE '%".$paramer[keyword]."%'";
include PLUS_PATH."/city.cache.php";
foreach($city_name as $k=>$v){
if(strpos($v,$paramer[keyword])!==false){
$cityid[]=$k;
}
}
if(is_array($cityid)){
foreach($cityid as $value){
$class[]= "(provinceid = '".$value."' or cityid = '".$value."')";
}
$where1[]=@implode(" or ",$class);
}
$where.=" AND (".@implode(" or ",$where1).")";
}
//多选职位
if($paramer["job"]){
$where.=" AND `job_post` in ($paramer[job])";
}
//置顶招聘
if($paramer[bid]){
if($config[joblist_top]!=1){
$paramer[limit] = 5;
}
$where.=" and `xsdate`>'".time()."'";
}
//自定义查询条件，默认取代上面任何参数直接使用该语句
if($paramer[where]){
$where = $paramer[where];
}
//查询条数
$limit = '';
if($paramer[limit]){
$limit = " limit ".$paramer[limit];
}
if($paramer[ispage]){
$limit = PageNav($paramer,$_GET,"company_job",$where,$Purl,"",$paramer[islt]?$paramer[islt]:"6",$_smarty_tpl);
}
//排序字段默认为更新时间
//置顶设置为随机5条时，随机查询
if($paramer[bid] && $paramer[limit]){
$order = " ORDER BY rand() ";
}else{
if($paramer[order] && $paramer[order]!="lastdate"){
$order = " ORDER BY ".str_replace("'","",$paramer[order])." ";
}else{
$order = " ORDER BY `lastupdate` ";
}
}
//排序规则 默认为倒序
if($paramer[sort]){
$sort = $paramer[sort];
}else{
$sort = " DESC";
}
$where.=$order.$sort;
$job_list = $db->select_all("company_job",$where.$limit);
if(is_array($job_list) && !empty($job_list)){
//处理类别字段
$cache_array = $db->cacheget();
$comuid=$jobid=array();
foreach($job_list as $key=>$value){
if(in_array($value['uid'],$comuid)==false){$comuid[] = $value['uid'];}
if(in_array($value['id'],$jobid)==false){$jobid[] = $value['id'];}
}
$comuids = @implode(',',$comuid);
$jobids = @implode(',',$jobid);
//减少曝光量统计维度 只有列表才统计
if($paramer[ispage]){
$db->update_all("company_job", "`jobexpoure` = `jobexpoure` + 1", "`id` in ($jobids)");
}
if($comuids){
$r_uids=$db->select_all("company","`uid` IN (".$comuids.")","`uid`,`yyzz_status`,`logo`,`logo_status`,`pr`,`hy`,`mun`,`shortname`,`welfare`,`hotstart`,`hottime`");
if(is_array($r_uids)){
foreach($r_uids as $key=>$value){
if($value[shortname]){
$value['shortname_n'] = $value[shortname];
}
if(!$value['logo'] || $value['logo_status']!=0){
$value['logo'] = checkpic("",$config['sy_unit_icon']);
}else{
$value['logo']= checkpic($value['logo']);
}
$value['pr_n'] = $cache_array['comclass_name'][$value[pr]];
$value['hy_n'] = $cache_array['industry_name'][$value[hy]];
$value['mun_n'] = $cache_array['comclass_name'][$value[mun]];
if($value['hotstart']<=time() && $value['hottime']>=time()){
$value['hotlogo'] = 1;
}
$r_uid[$value['uid']] = $value;
}
}
}
if($paramer[bid]){
$noids=array();
}
foreach($job_list as $key=>$value){
if($paramer[bid]){
$noids[] = $value[id];
}
//筛除重复
if($paramer[noids]==1 && !empty($noids) && in_array($value['id'],$noids)){
unset($job_list[$key]);
continue;
}else{
$job_list[$key] = $db->array_action($value,$cache_array);
$job_list[$key][stime] = date("Y-m-d",$value[sdate]);
$job_list[$key][etime] = date("Y-m-d",$value[edate]);
if($arr_data['sex'][$value['sex']]){
$job_list[$key][sex_n]=$arr_data['sex'][$value['sex']];
}
$job_list[$key][lastupdate] =lastupdateStyle($value[lastupdate]);
if($value[minsalary]&&$value[maxsalary]){
if($config['resume_salarytype']==1){
$job_list[$key][job_salary] =$value[minsalary]."-".$value[maxsalary];
}else{
if($value[maxsalary]<1000){
if($config['resume_salarytype']==2){
$job_list[$key][job_salary] = "1千以下";
}elseif($config['resume_salarytype']==3){
$job_list[$key][job_salary] = "1K以下";
}elseif($config['resume_salarytype']==4){
$job_list[$key][job_salary] = "1k以下";
}
}else if($value[minsalary]<1000){
$job_list[$key][job_salary] =changeSalary($value[maxsalary]);
}else{
$job_list[$key][job_salary] =changeSalary($value[minsalary])."-".changeSalary($value[maxsalary]);
}
}
}elseif($value[minsalary]){
if($config['resume_salarytype']==1){
$job_list[$key][job_salary] =$value[minsalary]."以上";
}else{
$job_list[$key][job_salary] =changeSalary($value[minsalary])."以上";
}
}else{
$job_list[$key][job_salary] ="面议";
}
if($r_uid[$value['uid']][shortname]){
$job_list[$key][com_name] =$r_uid[$value['uid']][shortname];
}
if(!empty($value[zp_minage]) && !empty($value[zp_maxage])){
if($value[zp_minage]==$value[zp_maxage]){
$job_list[$key][job_age] = $value[zp_minage]."周岁以上";
}else{
$job_list[$key][job_age] = $value[zp_minage]."-".$value[zp_maxage]."周岁";
}
}else if(!empty($value[zp_minage]) && empty($value[zp_maxage])){
$job_list[$key][job_age] = $value[zp_minage]."周岁以上";
}else{
$job_list[$key][job_age] = 0;
}
if($value[zp_num]==0){
$job_list[$key][job_number] = "";
}else{
$job_list[$key][job_number] = $value[zp_num]." 人";
}
$job_list[$key][yyzz_status] =$r_uid[$value['uid']][yyzz_status];
$job_list[$key][logo] =$r_uid[$value['uid']][logo];
$job_list[$key][pr_n] =$r_uid[$value['uid']][pr_n];
$job_list[$key][hy_n] =$r_uid[$value['uid']][hy_n];
$job_list[$key][mun_n] =$r_uid[$value['uid']][mun_n];
$job_list[$key][hotlogo] =$r_uid[$value['uid']][hotlogo];
$time=$value['lastupdate'];
//今天开始时间戳
$beginToday=mktime(0,0,0,date('m'),date('d'),date('Y'));
//昨天开始时间戳
$beginYesterday=mktime(0,0,0,date('m'),date('d')-1,date('Y'));
if($time>$beginYesterday && $time<$beginToday){
$job_list[$key]['time'] ="昨天";
}elseif($time>$beginToday){
$job_list[$key]['time'] = $job_list[$key]['lastupdate'];
$job_list[$key]['redtime'] =1;
}else{
$job_list[$key]['time'] = date("Y-m-d",$value['lastupdate']);
}
// 前天
$beforeYesterday=mktime(0,0,0,date('m'),date('d')-2,date('Y'));
if($value['sdate']>$beforeYesterday){
$job_list[$key]['newtime'] =1;
}
//获得福利待遇名称
if($value[welfare]){
$value[welfare] = str_replace(' ', '',$value[welfare]);
$welfareList = @explode(',',trim($value[welfare]));
if(!empty($welfareList)){
$job_list[$key][welfarename] =array_filter($welfareList);
}
}
//截取公司名称
if($paramer[comlen]){
if($r_uid[$value['uid']][shortname]){
$job_list[$key][com_n] = mb_substr($r_uid[$value['uid']][shortname],0,$paramer[comlen],"utf-8");
}else{
$job_list[$key][com_n] = mb_substr($value['com_name'],0,$paramer[comlen],"utf-8");
}
}
//截取职位名称
if($paramer[namelen]){
if($value['rec_time']>time()){
$job_list[$key][name_n] = "".mb_substr($value['name'],0,$paramer[namelen],"utf-8")."";
}else{
$job_list[$key][name_n] = mb_substr($value['name'],0,$paramer[namelen],"utf-8");
}
}else{
if($value['rec_time']>time()){
$job_list[$key]['name_n'] = "".$value['name']."";
}else{
$job_list[$key][name_n] = $value['name'];
}
}
//构建职位伪静态URL
$job_list[$key][job_url] = Url("job",array("c"=>"comapply","id"=>$value[id]),"1");
//构建企业伪静态URL
$job_list[$key][com_url] = Url("company",array("c"=>"show","id"=>$value[uid]));
foreach($comrat as $k=>$v){
if($value[rating]==$v[id]){
$job_list[$key][color] = str_replace("#","",$v[com_color]);
if($v[com_pic]){
$job_list[$key][ratlogo] = checkpic($v[com_pic]);
}
$job_list[$key][ratname] = $v[name];
}
}
if($paramer[keyword]){
$job_list[$key][name]=str_replace($paramer[keyword],"".$paramer[keyword]."",$value[name]);
$job_list[$key][name_n]=str_replace($paramer[keyword],"".$paramer[keyword]."",$job_list[$key][name_n]);
$job_list[$key][com_n]=str_replace($paramer[keyword],"".$paramer[keyword]."",$job_list[$key][com_n]);
$job_list[$key][job_city_one]=str_replace($paramer[keyword],"".$paramer[keyword]."",$city_name[$value[provinceid]]);
$job_list[$key][job_city_two]=str_replace($paramer[keyword],"".$paramer[keyword]."",$city_name[$value[cityid]]);
}
}
}
if(is_array($job_list)){
if($paramer[keyword]!=""&&!empty($job_list)){
addkeywords('3',$paramer[keyword]);
}
}
}$job_list = $job_list; if (!is_array($job_list) && !is_object($job_list)) { settype($job_list, 'array');}
foreach ($job_list as $_smarty_tpl->tpl_vars['job_list']->key => $_smarty_tpl->tpl_vars['job_list']->value) {
$_smarty_tpl->tpl_vars['job_list']->_loop = true;
$_smarty_tpl->tpl_vars['key']->value = $_smarty_tpl->tpl_vars['job_list']->key;
?>
tpl_vars['zd_list']->value['newtime']==1) {?>
置顶
tpl_vars['zd_list']->value['id'],$_smarty_tpl->tpl_vars['lookJobIds']->value)) {?>
tpl_vars['zd_list']->value['name_n'];?>
tpl_vars['zd_list']->value['urgent_time']>time()) {?>
tpl_vars['zd_list']->value['rec_time']>time()) {?>
tpl_vars['zd_list']->value['rec_time']>time()) {?> tpl_vars['zd_list']->value['com_n'];?>
tpl_vars['zd_list']->value['hotlogo']==1) {?> 
tpl_vars['zd_list']->value['ratlogo']!=''&&$_smarty_tpl->tpl_vars['zd_list']->value['ratlogo']!="0") {?>![<?php echo $_smarty_tpl->tpl_vars['zd_list']->value['ratname'];?>](<?php echo $_smarty_tpl->tpl_vars['zd_list']->value['ratlogo'];?>
)
tpl_vars['zd_list']->value['yyzz_status']=='1') {?> 
tpl_vars['zd_list']->value['ratlogo']!=''&&$_smarty_tpl->tpl_vars['zd_list']->value['ratlogo']!="0") {?> tpl_vars['zd_list']->value['job_salary'];?>
|tpl_vars['zd_list']->value['job_city_one'];?>
-tpl_vars['zd_list']->value['job_city_two'];?>
tpl_vars['zd_list']->value['job_exp']) {?>|tpl_vars['zd_list']->value['job_exp'];?>
经验 |
tpl_vars['zd_list']->value['job_edu']) {?>tpl_vars['zd_list']->value['job_edu'];?>
学历
tpl_vars['zd_list']->value['hy_n'];?>
|tpl_vars['zd_list']->value['pr_n'];?>
|tpl_vars['zd_list']->value['mun_n'];?>
tpl_vars['zd_list']->value['welfarename']) {?>
tpl_vars['waflist'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['waflist']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['zd_list']->value['welfarename']; if (!is_array($_from) && !is_object($_from)) { settype($_from, 'array');}
foreach ($_from as $_smarty_tpl->tpl_vars['waflist']->key => $_smarty_tpl->tpl_vars['waflist']->value) {
$_smarty_tpl->tpl_vars['waflist']->_loop = true;
?> tpl_vars['waflist']->value;?>
tpl_vars['zd_list']->value['job_number']) {?>招聘tpl_vars['zd_list']->value['job_number'];?>
tpl_vars['zd_list']->value['job_age']) {?> 年龄tpl_vars['zd_list']->value['job_age'];?>
tpl_vars['zd_list']->value['sex_n']) {?>性别tpl_vars['zd_list']->value['sex_n'];?>
tpl_vars['config']->value['sy_h5_share']==1) {?>
微信扫一扫快速求职
微信扫一扫快速求职浏览过
tpl_vars['job_list']->value['newtime']==1) {?>
tpl_vars['job_list']->value['id'],$_smarty_tpl->tpl_vars['lookJobIds']->value)) {?>
tpl_vars['total']->value!=0||is_array($_smarty_tpl->tpl_vars['zd_list']->value)) {?>
tpl_vars['job_list']->value['name_n'];?>
tpl_vars['job_list']->value['urgent_time']>time()) {?> tpl_vars['job_list']->value['rec_time']>time()) {?>
tpl_vars['job_list']->value['rec_time']>time()) {?> tpl_vars['job_list']->value['com_n'];?>
tpl_vars['job_list']->value['hotlogo']==1) {?> tpl_vars['job_list']->value['ratlogo']!=''&&$_smarty_tpl->tpl_vars['job_list']->value['ratlogo']!="0") {?>![<?php echo $_smarty_tpl->tpl_vars['job_list']->value['ratname'];?>](<?php echo $_smarty_tpl->tpl_vars['job_list']->value['ratlogo'];?>
)
tpl_vars['job_list']->value['yyzz_status']=='1') {?>
tpl_vars['job_list']->value['ratlogo']!=''&&$_smarty_tpl->tpl_vars['job_list']->value['ratlogo']!="0") {?> tpl_vars['job_list']->value['job_salary'];?>
|tpl_vars['job_list']->value['job_city_one'];?>
-tpl_vars['job_list']->value['job_city_two'];?>
tpl_vars['job_list']->value['job_exp']) {?> | tpl_vars['job_list']->value['job_exp'];?>
经验 |
tpl_vars['job_list']->value['job_edu']) {?>tpl_vars['job_list']->value['job_edu'];?>
学历
tpl_vars['job_list']->value['hy_n'];
if ($_smarty_tpl->tpl_vars['job_list']->value['pr_n']) {?>|tpl_vars['job_list']->value['pr_n'];
}
if ($_smarty_tpl->tpl_vars['job_list']->value['mun_n']) {?>|tpl_vars['job_list']->value['mun_n'];
}?>
浏览过
tpl_vars['job_list']->value['welfarename']) {?>
tpl_vars['job_list']->value['time']=='昨天'||$_smarty_tpl->tpl_vars['job_list']->value['redtime']=='1') {?> tpl_vars['job_list']->value['time'];?>
tpl_vars['job_list']->value['time'];?>
tpl_vars['waflist'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['waflist']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['job_list']->value['welfarename']; if (!is_array($_from) && !is_object($_from)) { settype($_from, 'array');}
foreach ($_from as $_smarty_tpl->tpl_vars['waflist']->key => $_smarty_tpl->tpl_vars['waflist']->value) {
$_smarty_tpl->tpl_vars['waflist']->_loop = true;
?> tpl_vars['waflist']->value;?>
tpl_vars['job_list']->value['job_number']) {?>招聘tpl_vars['job_list']->value['job_number'];?>
tpl_vars['job_list']->value['job_age']) {?> 年龄tpl_vars['job_list']->value['job_age'];?>
tpl_vars['job_list']->value['sex_n']) {?> 性别tpl_vars['job_list']->value['sex_n'];?>
tpl_vars['pagenav']->value;
echo $_smarty_tpl->tpl_vars['totalshow']->value;?>
很抱歉，没有找到满足条件的职位
建议您适当减少已选择的条件或适当删减或更改搜索关键字
精选职位推荐 tpl_vars['recNum']->value>10) {?>换一组
-
tpl_vars['blist'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['blist']->_loop = false;
global $db,$db_config,$config;
$time = time();
//可以做缓存
$paramer=array("namelen"=>"15","comlen"=>"19","rec"=>"1","limit"=>"10","item"=>"'blist'","nocache"=>"")
;
$ParamerArr = GetSmarty($paramer,$_GET,$_smarty_tpl);
$paramer = $ParamerArr[arr];
$Purl = $ParamerArr[purl];
global $ModuleName;
if(!$Purl["m"]){
$Purl["m"]=$ModuleName;
}
include_once PLUS_PATH."/comrating.cache.php";
include(CONFIG_PATH."db.data.php");
if($config[sy_web_site]=="1"){
if($config[province]>0 && $config[province]!=""){
$paramer[provinceid] = $config[province];
}
if($config[cityid]>0 && $config[cityid]!=""){
$paramer[cityid] = $config[cityid];
}
if($config[three_cityid]>0 && $config[three_cityid]!=""){
$paramer[three_cityid] = $config[three_cityid];
}
if($config[hyclass]>0 && $config[hyclass]!=""){
$paramer[hy]=$config[hyclass];
}
}
if($paramer[sdate]){
$where = "`sdate`>".strtotime("-".intval($paramer[sdate])." day",time())." and `state`=1";
}else{
$where = "`state`=1";
}
//按照UID来查询（按公司地址查询可用GET[id]获取当前公司ID）
if($paramer[uid]){
$where .= " AND `uid` = '$paramer[uid]'";
}
if($paramer[com_id]){
$where .= " AND `uid` = '$paramer[com_id]'";
}
//是否推荐职位
if($paramer[rec]){
$where.=" AND `rec_time`>=".time();
}
//企业认证条件
if($paramer['cert']){
$job_uid=array();
$company=$db->select_all("company","`yyzz_status`=1","`uid`");
if(is_array($company)){
foreach($company as $v){
$job_uid[]=$v['uid'];
}
}
$where.=" and `uid` in (".@implode(",",$job_uid).")";
}
//取不包含当前企业的职位
if($paramer[nouid]){
$where.= " and `uid`<>$paramer[nouid]";
}
//取不包含当前id的职位
if($paramer[noid]){
$where.= " and `id`<>$paramer[noid]";
}
//是否被锁定
if($paramer[r_status]){
$where.= " and `r_status`=2";
}else{
$where.= " and `r_status`=1";
}
//是否下架职位
if($paramer[status]){
$where.= " and `status`='1'";
}else{
$where.= " and `status`='0'";
}
//公司体制
if($paramer[pr]){
$where .= " AND `pr` =$paramer[pr]";
}
//公司行业分类
if($paramer['hy']){
$where .= " AND `hy` = $paramer[hy]";
}
//职位大类
if($paramer[job1]){
$where .= " AND `job1` = $paramer[job1]";
}
//职位子类
if($paramer[job1_son]){
$where .= " AND `job1_son` = $paramer[job1_son]";
}
//职位三级分类
if($paramer[job_post]){
$where .= " AND (`job_post` IN ($paramer[job_post]))";
}
//您可能感兴趣的职位--个人会员中心
if($paramer['jobwhere']){
$where .=" and ".$paramer['jobwhere'];
}
//职位分类综合查询
if($paramer['jobids']){
$where.= " AND (`job1` = '$paramer[jobids]' OR `job1_son`= '$paramer[jobids]' OR `job_post`='$paramer[jobids]')";
}
//职位分类区间,不建议执行该查询
if($paramer['jobin']){
$where .= " AND (`job1` IN ($paramer[jobin]) OR `job1_son` IN ($paramer[jobin]) OR `job_post` IN ($paramer[jobin]))";
}
//城市大类
if($paramer[provinceid]){
$where .= " AND `provinceid` = $paramer[provinceid]";
}
//城市子类
if($paramer['cityid']){
$where .= " AND (`cityid` IN ($paramer[cityid]))";
}
//城市三级子类
if($paramer['three_cityid']){
$where .= " AND (`three_cityid` IN ($paramer[three_cityid]))";
}
if($paramer['cityin']){
$where .= " AND `three_cityid` IN ($paramer[cityin])";
}
//学历
if($paramer[edu]){
$eduKey = $db->DB_select_once("comclass", "`variable` = 'job_edu'", "`id`");
$eduReq = $db->DB_select_once("comclass", "`id` = $paramer[edu]", "`sort`,`name`");
if($eduReq[name] != "不限"){
$eduArr = $db->select_all("comclass", "`keyid` = $eduKey[id] AND `sort` <= $eduReq[sort]", "`id`");
$eduIds = array();
foreach($eduArr as $v){
$eduIds[] = $v[id];
}
$where .= " AND `edu` in (".@implode(",",$eduIds).")";
}
}
//工作经验
if($paramer[exp]){
$expKey = $db->DB_select_once("comclass", "`variable` = 'job_exp'", "`id`");
$expReq = $db->DB_select_once("comclass", "`id` = $paramer[exp]", "`sort`,`name`");
if($expReq[name] != "不限"){
$expArr = $db->select_all("comclass", "`keyid` = $expKey[id] AND `sort` <= $expReq[sort]", "`id`");
$expIds = array();
foreach($expArr as $v){
$expIds[] = $v[id];
}
$where .= " AND `exp` in (".@implode(",",$expIds).")";
}
}
//到岗时间
if($paramer[report]){
$where .= " AND `report` = $paramer[report]";
}
//职位性质
if($paramer[type]){
$where .= " AND `type` = $paramer[type]";
}
//性别
if($paramer[sex]){
$where .= " AND `sex` = $paramer[sex]";
}
//应届生
if($paramer[is_graduate]){
$where .= " AND `is_graduate` = $paramer[is_graduate]";
}
//公司规模
if($paramer[mun]){
$where .= " AND `mun` = $paramer[mun]";
}
if($paramer[minsalary] && $paramer[maxsalary]){
$where.= " AND (`minsalary`>=".intval($paramer[minsalary])." and `minsalary`<=".intval($paramer[maxsalary])." and `maxsalary`<=".intval($paramer[maxsalary]).") ";
}elseif($paramer[minsalary]&&!$paramer[maxsalary]){
$where.= " AND (`minsalary`>=".intval($paramer[minsalary]).") ";
}elseif(!$paramer[minsalary]&&$paramer[maxsalary]){
$where.= " AND (`minsalary`<=".intval($paramer[maxsalary])." and `maxsalary`<=".intval($paramer[maxsalary]).") ";
}
//福利待遇
$cache_array = $db->cacheget();
$comclass_name = $cache_array["comclass_name"];
if($paramer[welfare]){
$welfarename=$comclass_name[$paramer[welfare]];
$where .=" AND `welfare` LIKE '%".$welfarename."%' ";
}
//城市区间,不建议执行该查询
if($paramer[cityin]){
$where .= " AND (`provinceid` IN ($paramer[cityin]) OR `cityid` IN ($paramer[cityin]) OR `three_cityid` IN ($paramer[cityin]))";
}
//紧急招聘urgent
if($paramer[urgent]){
$where.=" AND `urgent_time`>".time();
}
//更新时间区间
if($paramer[uptime]){
if($paramer[uptime]==1){
$beginToday=mktime(0,0,0,date('m'),date('d'),date('Y'));
$where.=" AND lastupdate>$beginToday";
}else{
$time=time();
$uptime = $time-($paramer[uptime]*86400);
$where.=" AND lastupdate>$uptime";
}
}else{
if($config[sy_datacycle]>0){
// 后台-页面设置-数据周期
$uptime = strtotime('-'.$config[sy_datacycle].' day');
$where.=" AND lastupdate>$uptime";
}
}
//按类似公司名称,不建议进行大数据量操作
if($paramer[comname]){
$where.=" AND `com_name` LIKE '%".$paramer[comname]."%'";
}
//按公司归属地,只适合查询一级城市分类
if($paramer[com_pro]){
$where.=" AND `com_provinceid` ='".$paramer[com_pro]."'";
}
//按照职位名称匹配
if($paramer[keyword]){
$where1[]="`name` LIKE '%".$paramer[keyword]."%'";
$where1[]="`com_name` LIKE '%".$paramer[keyword]."%'";
include PLUS_PATH."/city.cache.php";
foreach($city_name as $k=>$v){
if(strpos($v,$paramer[keyword])!==false){
$cityid[]=$k;
}
}
if(is_array($cityid)){
foreach($cityid as $value){
$class[]= "(provinceid = '".$value."' or cityid = '".$value."')";
}
$where1[]=@implode(" or ",$class);
}
$where.=" AND (".@implode(" or ",$where1).")";
}
//多选职位
if($paramer["job"]){
$where.=" AND `job_post` in ($paramer[job])";
}
//置顶招聘
if($paramer[bid]){
if($config[joblist_top]!=1){
$paramer[limit] = 5;
}
$where.=" and `xsdate`>'".time()."'";
}
//自定义查询条件，默认取代上面任何参数直接使用该语句
if($paramer[where]){
$where = $paramer[where];
}
//查询条数
$limit = '';
if($paramer[limit]){
$limit = " limit ".$paramer[limit];
}
if($paramer[ispage]){
$limit = PageNav($paramer,$_GET,"company_job",$where,$Purl,"",$paramer[islt]?$paramer[islt]:"6",$_smarty_tpl);
}
//排序字段默认为更新时间
//置顶设置为随机5条时，随机查询
if($paramer[bid] && $paramer[limit]){
$order = " ORDER BY rand() ";
}else{
if($paramer[order] && $paramer[order]!="lastdate"){
$order = " ORDER BY ".str_replace("'","",$paramer[order])." ";
}else{
$order = " ORDER BY `lastupdate` ";
}
}
//排序规则 默认为倒序
if($paramer[sort]){
$sort = $paramer[sort];
}else{
$sort = " DESC";
}
$where.=$order.$sort;
$blist = $db->select_all("company_job",$where.$limit);
if(is_array($blist) && !empty($blist)){
//处理类别字段
$cache_array = $db->cacheget();
$comuid=$jobid=array();
foreach($blist as $key=>$value){
if(in_array($value['uid'],$comuid)==false){$comuid[] = $value['uid'];}
if(in_array($value['id'],$jobid)==false){$jobid[] = $value['id'];}
}
$comuids = @implode(',',$comuid);
$jobids = @implode(',',$jobid);
//减少曝光量统计维度 只有列表才统计
if($paramer[ispage]){
$db->update_all("company_job", "`jobexpoure` = `jobexpoure` + 1", "`id` in ($jobids)");
}
if($comuids){
$r_uids=$db->select_all("company","`uid` IN (".$comuids.")","`uid`,`yyzz_status`,`logo`,`logo_status`,`pr`,`hy`,`mun`,`shortname`,`welfare`,`hotstart`,`hottime`");
if(is_array($r_uids)){
foreach($r_uids as $key=>$value){
if($value[shortname]){
$value['shortname_n'] = $value[shortname];
}
if(!$value['logo'] || $value['logo_status']!=0){
$value['logo'] = checkpic("",$config['sy_unit_icon']);
}else{
$value['logo']= checkpic($value['logo']);
}
$value['pr_n'] = $cache_array['comclass_name'][$value[pr]];
$value['hy_n'] = $cache_array['industry_name'][$value[hy]];
$value['mun_n'] = $cache_array['comclass_name'][$value[mun]];
if($value['hotstart']<=time() && $value['hottime']>=time()){
$value['hotlogo'] = 1;
}
$r_uid[$value['uid']] = $value;
}
}
}
if($paramer[bid]){
$noids=array();
}
foreach($blist as $key=>$value){
if($paramer[bid]){
$noids[] = $value[id];
}
//筛除重复
if($paramer[noids]==1 && !empty($noids) && in_array($value['id'],$noids)){
unset($blist[$key]);
continue;
}else{
$blist[$key] = $db->array_action($value,$cache_array);
$blist[$key][stime] = date("Y-m-d",$value[sdate]);
$blist[$key][etime] = date("Y-m-d",$value[edate]);
if($arr_data['sex'][$value['sex']]){
$blist[$key][sex_n]=$arr_data['sex'][$value['sex']];
}
$blist[$key][lastupdate] =lastupdateStyle($value[lastupdate]);
if($value[minsalary]&&$value[maxsalary]){
if($config['resume_salarytype']==1){
$blist[$key][job_salary] =$value[minsalary]."-".$value[maxsalary];
}else{
if($value[maxsalary]<1000){
if($config['resume_salarytype']==2){
$blist[$key][job_salary] = "1千以下";
}elseif($config['resume_salarytype']==3){
$blist[$key][job_salary] = "1K以下";
}elseif($config['resume_salarytype']==4){
$blist[$key][job_salary] = "1k以下";
}
}else if($value[minsalary]<1000){
$blist[$key][job_salary] =changeSalary($value[maxsalary]);
}else{
$blist[$key][job_salary] =changeSalary($value[minsalary])."-".changeSalary($value[maxsalary]);
}
}
}elseif($value[minsalary]){
if($config['resume_salarytype']==1){
$blist[$key][job_salary] =$value[minsalary]."以上";
}else{
$blist[$key][job_salary] =changeSalary($value[minsalary])."以上";
}
}else{
$blist[$key][job_salary] ="面议";
}
if($r_uid[$value['uid']][shortname]){
$blist[$key][com_name] =$r_uid[$value['uid']][shortname];
}
if(!empty($value[zp_minage]) && !empty($value[zp_maxage])){
if($value[zp_minage]==$value[zp_maxage]){
$blist[$key][job_age] = $value[zp_minage]."周岁以上";
}else{
$blist[$key][job_age] = $value[zp_minage]."-".$value[zp_maxage]."周岁";
}
}else if(!empty($value[zp_minage]) && empty($value[zp_maxage])){
$blist[$key][job_age] = $value[zp_minage]."周岁以上";
}else{
$blist[$key][job_age] = 0;
}
if($value[zp_num]==0){
$blist[$key][job_number] = "";
}else{
$blist[$key][job_number] = $value[zp_num]." 人";
}
$blist[$key][yyzz_status] =$r_uid[$value['uid']][yyzz_status];
$blist[$key][logo] =$r_uid[$value['uid']][logo];
$blist[$key][pr_n] =$r_uid[$value['uid']][pr_n];
$blist[$key][hy_n] =$r_uid[$value['uid']][hy_n];
$blist[$key][mun_n] =$r_uid[$value['uid']][mun_n];
$blist[$key][hotlogo] =$r_uid[$value['uid']][hotlogo];
$time=$value['lastupdate'];
//今天开始时间戳
$beginToday=mktime(0,0,0,date('m'),date('d'),date('Y'));
//昨天开始时间戳
$beginYesterday=mktime(0,0,0,date('m'),date('d')-1,date('Y'));
if($time>$beginYesterday && $time<$beginToday){
$blist[$key]['time'] ="昨天";
}elseif($time>$beginToday){
$blist[$key]['time'] = $blist[$key]['lastupdate'];
$blist[$key]['redtime'] =1;
}else{
$blist[$key]['time'] = date("Y-m-d",$value['lastupdate']);
}
// 前天
$beforeYesterday=mktime(0,0,0,date('m'),date('d')-2,date('Y'));
if($value['sdate']>$beforeYesterday){
$blist[$key]['newtime'] =1;
}
//获得福利待遇名称
if($value[welfare]){
$value[welfare] = str_replace(' ', '',$value[welfare]);
$welfareList = @explode(',',trim($value[welfare]));
if(!empty($welfareList)){
$blist[$key][welfarename] =array_filter($welfareList);
}
}
//截取公司名称
if($paramer[comlen]){
if($r_uid[$value['uid']][shortname]){
$blist[$key][com_n] = mb_substr($r_uid[$value['uid']][shortname],0,$paramer[comlen],"utf-8");
}else{
$blist[$key][com_n] = mb_substr($value['com_name'],0,$paramer[comlen],"utf-8");
}
}
//截取职位名称
if($paramer[namelen]){
if($value['rec_time']>time()){
$blist[$key][name_n] = "".mb_substr($value['name'],0,$paramer[namelen],"utf-8")."";
}else{
$blist[$key][name_n] = mb_substr($value['name'],0,$paramer[namelen],"utf-8");
}
}else{
if($value['rec_time']>time()){
$blist[$key]['name_n'] = "".$value['name']."";
}else{
$blist[$key][name_n] = $value['name'];
}
}
//构建职位伪静态URL
$blist[$key][job_url] = Url("job",array("c"=>"comapply","id"=>$value[id]),"1");
//构建企业伪静态URL
$blist[$key][com_url] = Url("company",array("c"=>"show","id"=>$value[uid]));
foreach($comrat as $k=>$v){
if($value[rating]==$v[id]){
$blist[$key][color] = str_replace("#","",$v[com_color]);
if($v[com_pic]){
$blist[$key][ratlogo] = checkpic($v[com_pic]);
}
$blist[$key][ratname] = $v[name];
}
}
if($paramer[keyword]){
$blist[$key][name]=str_replace($paramer[keyword],"".$paramer[keyword]."",$value[name]);
$blist[$key][name_n]=str_replace($paramer[keyword],"".$paramer[keyword]."",$blist[$key][name_n]);
$blist[$key][com_n]=str_replace($paramer[keyword],"".$paramer[keyword]."",$blist[$key][com_n]);
$blist[$key][job_city_one]=str_replace($paramer[keyword],"".$paramer[keyword]."",$city_name[$value[provinceid]]);
$blist[$key][job_city_two]=str_replace($paramer[keyword],"".$paramer[keyword]."",$city_name[$value[cityid]]);
}
}
}
if(is_array($blist)){
if($paramer[keyword]!=""&&!empty($blist)){
addkeywords('3',$paramer[keyword]);
}
}
}$blist = $blist; if (!is_array($blist) && !is_object($blist)) { settype($blist, 'array');}
foreach ($blist as $_smarty_tpl->tpl_vars['blist']->key => $_smarty_tpl->tpl_vars['blist']->value) {
$_smarty_tpl->tpl_vars['blist']->_loop = true;
?>
- tpl_vars['blist']->value['name_n'];?>
tpl_vars['blist']->value['com_n'];?>
tpl_vars['blist']->value['job_salary'];?>
推荐企业
-
tpl_vars['hotjoblist'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['hotjoblist']->_loop = false;
global $db,$db_config,$config;$paramer=array("item"=>"'hotjoblist'","limit"=>"8","nocache"=>"")
;$hotjoblist=array();
$time = time();
//处理传入参数，并且构造分页参数
$ParamerArr = GetSmarty($paramer,$_GET,$_smarty_tpl);
$paramer = $ParamerArr['arr'];
$Purl = $ParamerArr['purl'];
global $ModuleName;
if(!$Purl["m"]){
$Purl["m"]=$ModuleName;
}
//是否属于分站下
if($config[sy_web_site]=="1"){
$jobwheres="";
if($config[province]>0 && $config[province]!=""){
$jobwheres.=" and `provinceid`='$config[province]'";
}
if($config[cityid]>0 && $config[cityid]!=""){
$jobwheres.=" and `cityid`='$config[cityid]'";
}
if($config[three_cityid]>0 && $config[three_cityid]!=""){
$jobwheres.=" and `three_cityid`='$config[three_cityid]'";
}
if($config[hyclass]>0 && $config[hyclass]!=""){
$jobwheres.=" and `hy`='".$config[hyclass]."'";
}
if($jobwheres){
$comlist=$db->select_all("company","`hottime`>$time ".$jobwheres,"`uid`");
if(is_array($comlist)){
foreach($comlist as $v){
$cuid[]=$v[uid];
}
}
$hotwhere=" and `uid` in (".@implode(",",$cuid).")";
}
}
if($paramer['limit']){
$limit=" limit ".$paramer['limit'];
}
$where = "`time_start`<$time AND `time_end`>$time".$hotwhere;
if($config['hotcom_top'] == 1){
// 职位更新时间(职位修改时，会更新名企表lastupdate字段)
$order = " ORDER BY `lastupdate` DESC ";
}elseif($config['hotcom_top'] == 2){
// 随机
$order = " ORDER BY rand() ";
}else{
// 后台手动设置
$order = " ORDER BY `sort` DESC ";
}$where.=$order;
$Query = $db->query("SELECT * FROM $db_config[def]hotjob where ".$where.$limit);
while($rs = $db->fetch_array($Query)){
$hotjoblist[] = $rs;
$ListId[] = $rs[uid];
}
//是否需要查询对应职位
$ComId = @implode(",",$ListId);
$comList= $db->select_all("company","`uid` IN ($ComId)","`shortname`,`uid`,`hy`,`mun`,`provinceid`,`cityid`,`three_cityid`, `r_status`");
if($config[sy_datacycle]>0){
$uptime = strtotime('-'.$config[sy_datacycle].' day');
$JobList= $db->select_all("company_job","`uid` IN ($ComId) and state=1 and r_status=1 and status=0 and lastupdate > $uptime $jobwheres","`id`,`uid`,`name`");
}else{
$JobList= $db->select_all("company_job","`uid` IN ($ComId) and state=1 and r_status=1 and status=0 $jobwheres","`id`,`uid`,`name`");
}
$statis=$db->select_all("company_statis","`uid` IN ($ComId)","`uid`,`comtpl`");
if(is_array($ListId)){
foreach($hotjoblist as $key=>$value){
foreach($comList as $v){
if($v['uid'] == $value['uid']){
if($v['r_status'] != 1){
unset($hotjoblist[$key]);
}
}
}
}
$JobIds = array();
//处理类别字段
$cache_array = $db->cacheget();
foreach($hotjoblist as $key=>$value){
$hotjoblist[$key]["hot_pic"]=checkpic($value[hot_pic],$config[sy_unit_icon]);
foreach($comList as $v){
if($value['uid']==$v['uid']){
if($v['shortname']){
$hotjoblist[$key]["username"]= $v[shortname];
}
$hotjoblist[$key]["hy"]= $cache_array[industry_name][$v[hy]];
$hotjoblist[$key]["mun_n"]= $cache_array[comclass_name][$v[mun]];
$hotjoblist[$key]["job_city_one"]= $cache_array[city_name][$v[provinceid]];
$hotjoblist[$key]["job_city_two"]= $cache_array[city_name][$v[cityid]];
}
}
$i=0;$j=0;
$hotjoblist[$key]["num"]=0;
if(is_array($JobList)){
foreach($JobList as $ke=>$va){
if($value[uid]==$va[uid]){
if($j<3){
$hotjob_url = Url("job",array("c"=>"comapply","id"=>"$va[id]"),"1");
$curl= Url("company",array("c"=>"show","id"=>$value[uid]));
$va[name] = mb_substr($va[name],0,8,"utf-8");
$hotjoblist[$key]["hotjob"].="";
$JobIds[] = $va['id'];
}else{
if($j==3){
$hotjoblist[$key]["hotjob"].="";
}
}
$j++;
}
}
$hotjoblist[$key]["job"].="
-
tpl_vars['hotjoblist']->value['username'],0,13,'utf-8');?>
tpl_vars['hotjoblist']->_loop) {
?>
";
foreach($JobList as $k=>$v){
if($value[uid]==$v[uid] && $i<5){
$job_url = Url("job",array("c"=>"comapply","id"=>"$v[id]"),"1");
$v[name] = mb_substr($v[name],0,10,"utf-8");
$hotjoblist[$key]["job"].="".$v[name]."";
$i++;
}
if($value[uid]==$v[uid]){
$hotjoblist[$key]["num"]=$hotjoblist[$key]["num"]+1;
}
}
foreach($statis as $v){
if($value['uid']==$v['uid']){
if($v['comtpl'] && $v['comtpl']!="default"){
$jobs_url = Url("company",array("c"=>"show","id"=>$value[uid]))."#job";
}else{
$jobs_url = Url("company",array("c"=>"show","id"=>$value[uid]));
}
}
}
$com_url = Url("company",array("c"=>"show","id"=>$value[uid]));
$hotjoblist[$key]["job"].="
";
$hotjoblist[$key]["url"]=$com_url;
}
}
if(!empty($JobIds)){
//$db -> update_all("company_job", "`jobexpoure` = `jobexpoure` + 1", "`id` IN (".@implode(',',$JobIds).")");
}
}$hotjoblist = $hotjoblist; if (!is_array($hotjoblist) && !is_object($hotjoblist)) { settype($hotjoblist, 'array');}
foreach ($hotjoblist as $_smarty_tpl->tpl_vars['hotjoblist']->key => $_smarty_tpl->tpl_vars['hotjoblist']->value) {
$_smarty_tpl->tpl_vars['hotjoblist']->_loop = true;
?>
暂无推荐企业