tpl_vars["lunbo"] = new Smarty_Variable; $_smarty_tpl->tpl_vars["lunbo"]->_loop = false;
$_smarty_tpl->tpl_vars['key'] = new Smarty_Variable;
global $db,$db_config,$config;$AdArr=array();$paramer=array();$attr=array("classid"=>"3","item"=>"\"lunbo\"","key"=>"'key'","nocache"=>"")
;
include(PLUS_PATH.'pimg_cache.php');$add_arr = $ad_label[3];if(is_array($add_arr) && !empty($add_arr)){
$i=0;$limit = 0;$length = 0;
foreach($add_arr as $key=>$value){
if($config['did']){
if(($value['did']==$config['did']|| $value['did']==-1)&&$value['start']time()){
if($i>0 && $limit==$i){
break;
}
if($length>0){
$value['name'] = mb_substr($value['name'],0,$length);
}
if($paramer['type']!=""){
if($paramer['type'] == $value['type']){
$AdArr[] = $value;
}
}else{
$AdArr[] = $value;
}
$i++;
}
}else{
if(($value['did']==-1 || !$value['did']) && $value['start']time()){
if($i>0 && $limit==$i){
break;
}
if($length>0){
$value['name'] = mb_substr($value['name'],0,$length);
}
if($paramer['type']!=""){
if($paramer['type'] == $value['type']){
$AdArr[] = $value;
}
}else{
$AdArr[] = $value;
}
$i++;
}
}
}
if (isset($attr['random']) && $attr['random'] && count($AdArr) > $attr['random']) {
$temp = [];
$random_keys = array_rand($AdArr, $attr['random']);
if($attr['random'] == 1) {
$temp[] = $AdArr[$attr['random']];
} else {
foreach ($AdArr as $key => $value) {
if (in_array($key, $random_keys)) {
$temp[$key] = $value;
}
}
}
$AdArr = $temp;
}
}$AdArr = $AdArr; if (!is_array($AdArr) && !is_object($AdArr)) { settype($AdArr, 'array');}
foreach ($AdArr as $_smarty_tpl->tpl_vars["lunbo"]->key => $_smarty_tpl->tpl_vars["lunbo"]->value) {
$_smarty_tpl->tpl_vars["lunbo"]->_loop = true;
$_smarty_tpl->tpl_vars['key']->value = $_smarty_tpl->tpl_vars["lunbo"]->key;
?>
tpl_vars['lunbo']->value['lay_html'];?>
tpl_vars['urgent_list'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['urgent_list']->_loop = false;
$_smarty_tpl->tpl_vars['key'] = new Smarty_Variable;
global $db,$db_config,$config;
$time = time();
//可以做缓存
$paramer=array("namelen"=>"30","comlen"=>"30","urgent"=>"'1'","limit"=>"32","key"=>"'key'","item"=>"'urgent_list'","name"=>"'urgent_list1'","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;
$urgent_list = $db->select_all("company_job",$where.$limit);
if(is_array($urgent_list) && !empty($urgent_list)){
//处理类别字段
$cache_array = $db->cacheget();
$comuid=$jobid=array();
foreach($urgent_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($urgent_list as $key=>$value){
if($paramer[bid]){
$noids[] = $value[id];
}
//筛除重复
if($paramer[noids]==1 && !empty($noids) && in_array($value['id'],$noids)){
unset($urgent_list[$key]);
continue;
}else{
$urgent_list[$key] = $db->array_action($value,$cache_array);
$urgent_list[$key][stime] = date("Y-m-d",$value[sdate]);
$urgent_list[$key][etime] = date("Y-m-d",$value[edate]);
if($arr_data['sex'][$value['sex']]){
$urgent_list[$key][sex_n]=$arr_data['sex'][$value['sex']];
}
$urgent_list[$key][lastupdate] =lastupdateStyle($value[lastupdate]);
if($value[minsalary]&&$value[maxsalary]){
if($config['resume_salarytype']==1){
$urgent_list[$key][job_salary] =$value[minsalary]."-".$value[maxsalary];
}else{
if($value[maxsalary]<1000){
if($config['resume_salarytype']==2){
$urgent_list[$key][job_salary] = "1千以下";
}elseif($config['resume_salarytype']==3){
$urgent_list[$key][job_salary] = "1K以下";
}elseif($config['resume_salarytype']==4){
$urgent_list[$key][job_salary] = "1k以下";
}
}else if($value[minsalary]<1000){
$urgent_list[$key][job_salary] =changeSalary($value[maxsalary]);
}else{
$urgent_list[$key][job_salary] =changeSalary($value[minsalary])."-".changeSalary($value[maxsalary]);
}
}
}elseif($value[minsalary]){
if($config['resume_salarytype']==1){
$urgent_list[$key][job_salary] =$value[minsalary]."以上";
}else{
$urgent_list[$key][job_salary] =changeSalary($value[minsalary])."以上";
}
}else{
$urgent_list[$key][job_salary] ="面议";
}
if($r_uid[$value['uid']][shortname]){
$urgent_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]){
$urgent_list[$key][job_age] = $value[zp_minage]."周岁以上";
}else{
$urgent_list[$key][job_age] = $value[zp_minage]."-".$value[zp_maxage]."周岁";
}
}else if(!empty($value[zp_minage]) && empty($value[zp_maxage])){
$urgent_list[$key][job_age] = $value[zp_minage]."周岁以上";
}else{
$urgent_list[$key][job_age] = 0;
}
if($value[zp_num]==0){
$urgent_list[$key][job_number] = "";
}else{
$urgent_list[$key][job_number] = $value[zp_num]." 人";
}
$urgent_list[$key][yyzz_status] =$r_uid[$value['uid']][yyzz_status];
$urgent_list[$key][logo] =$r_uid[$value['uid']][logo];
$urgent_list[$key][pr_n] =$r_uid[$value['uid']][pr_n];
$urgent_list[$key][hy_n] =$r_uid[$value['uid']][hy_n];
$urgent_list[$key][mun_n] =$r_uid[$value['uid']][mun_n];
$urgent_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){
$urgent_list[$key]['time'] ="昨天";
}elseif($time>$beginToday){
$urgent_list[$key]['time'] = $urgent_list[$key]['lastupdate'];
$urgent_list[$key]['redtime'] =1;
}else{
$urgent_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){
$urgent_list[$key]['newtime'] =1;
}
//获得福利待遇名称
if($value[welfare]){
$value[welfare] = str_replace(' ', '',$value[welfare]);
$welfareList = @explode(',',trim($value[welfare]));
if(!empty($welfareList)){
$urgent_list[$key][welfarename] =array_filter($welfareList);
}
}
//截取公司名称
if($paramer[comlen]){
if($r_uid[$value['uid']][shortname]){
$urgent_list[$key][com_n] = mb_substr($r_uid[$value['uid']][shortname],0,$paramer[comlen],"utf-8");
}else{
$urgent_list[$key][com_n] = mb_substr($value['com_name'],0,$paramer[comlen],"utf-8");
}
}
//截取职位名称
if($paramer[namelen]){
if($value['rec_time']>time()){
$urgent_list[$key][name_n] = "".mb_substr($value['name'],0,$paramer[namelen],"utf-8")."";
}else{
$urgent_list[$key][name_n] = mb_substr($value['name'],0,$paramer[namelen],"utf-8");
}
}else{
if($value['rec_time']>time()){
$urgent_list[$key]['name_n'] = "".$value['name']."";
}else{
$urgent_list[$key][name_n] = $value['name'];
}
}
//构建职位伪静态URL
$urgent_list[$key][job_url] = Url("job",array("c"=>"comapply","id"=>$value[id]),"1");
//构建企业伪静态URL
$urgent_list[$key][com_url] = Url("company",array("c"=>"show","id"=>$value[uid]));
foreach($comrat as $k=>$v){
if($value[rating]==$v[id]){
$urgent_list[$key][color] = str_replace("#","",$v[com_color]);
if($v[com_pic]){
$urgent_list[$key][ratlogo] = checkpic($v[com_pic]);
}
$urgent_list[$key][ratname] = $v[name];
}
}
if($paramer[keyword]){
$urgent_list[$key][name]=str_replace($paramer[keyword],"".$paramer[keyword]."",$value[name]);
$urgent_list[$key][name_n]=str_replace($paramer[keyword],"".$paramer[keyword]."",$urgent_list[$key][name_n]);
$urgent_list[$key][com_n]=str_replace($paramer[keyword],"".$paramer[keyword]."",$urgent_list[$key][com_n]);
$urgent_list[$key][job_city_one]=str_replace($paramer[keyword],"".$paramer[keyword]."",$city_name[$value[provinceid]]);
$urgent_list[$key][job_city_two]=str_replace($paramer[keyword],"".$paramer[keyword]."",$city_name[$value[cityid]]);
}
}
}
if(is_array($urgent_list)){
if($paramer[keyword]!=""&&!empty($urgent_list)){
addkeywords('3',$paramer[keyword]);
}
}
}$urgent_list = $urgent_list; if (!is_array($urgent_list) && !is_object($urgent_list)) { settype($urgent_list, 'array');}
foreach ($urgent_list as $_smarty_tpl->tpl_vars['urgent_list']->key => $_smarty_tpl->tpl_vars['urgent_list']->value) {
$_smarty_tpl->tpl_vars['urgent_list']->_loop = true;
$_smarty_tpl->tpl_vars['key']->value = $_smarty_tpl->tpl_vars['urgent_list']->key;
?>
tpl_vars['urgent_list']->value['name'];?>
tpl_vars['urgent_list']->value['job_salary']!='面议') {
}
echo $_smarty_tpl->tpl_vars['urgent_list']->value['job_salary'];?>
]*?>!', ' ', $_smarty_tpl->tpl_vars['urgent_list']->value['com_name']),0,14,'utf-8');?>
网站公告更多
-
tpl_vars['announcementlist'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['announcementlist']->_loop = false;
$announcementlist=array();$time=time();$paramer=array("limit"=>"4","item"=>"'announcementlist'","t_len"=>"30","nocache"=>"")
;
global $db,$db_config,$config;
$ParamerArr = GetSmarty($paramer,$_GET,$_smarty_tpl);
$paramer = $ParamerArr[arr];
$Purl = $ParamerArr[purl];
global $ModuleName;
if(!$Purl["m"]){
$Purl["m"]=$ModuleName;
}
$where = 1;
//分站
if($config['did']){
$where.=" and (`did`='".$config['did']."' or `did`=-1)";
}else{
$where.=" and (`did`=-1 OR `did`=0 OR did='')";
}
$where.=" and (`startime`<=".time()." or `startime`=0 or `startime` is null)";
$where.=" and (`endtime`>".time()." or `endtime`=0 or `endtime` is null)";
if($paramer[limit]){
$limit=" LIMIT ".$paramer[limit];
}else{
$limit=" LIMIT 20";
}
if($paramer[ispage]){
$limit = PageNav($paramer,$_GET,"admin_announcement",$where,$Purl,"",0,$_smarty_tpl);
}
//排序字段 默认按照xuanshang排序
if($paramer[order]){
$where.=" ORDER BY `".$paramer[order]."`";
}else{
$where.=" ORDER BY `startime`";
}
//排序方式默认倒序
if($paramer[sort]){
$where.=" ".$paramer[sort];
}else{
$where.=" DESC";
}
$announcementlist=$db->select_all("admin_announcement",$where.$limit);
if(is_array($announcementlist)){
foreach($announcementlist as $key=>$value){
//截取标题
if($paramer[t_len]){
$announcementlist[$key][title_n] = mb_substr($value['title'],0,$paramer[t_len],"utf-8");
}
$announcementlist[$key][time]=date("Y-m-d",$value[startime]);
$announcementlist[$key][url] = Url("announcement",array("id"=>$value[id]),"1");
}
}$announcementlist = $announcementlist; if (!is_array($announcementlist) && !is_object($announcementlist)) { settype($announcementlist, 'array');}
foreach ($announcementlist as $_smarty_tpl->tpl_vars['announcementlist']->key => $_smarty_tpl->tpl_vars['announcementlist']->value) {
$_smarty_tpl->tpl_vars['announcementlist']->_loop = true;
?>
- tpl_vars['announcementlist']->value['title_n'];?>
找了好工作 ， 还能领红包！
-
tpl_vars['rlist'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['rlist']->_loop = false;
global $db,$db_config,$config;
$time = time();
//可以做缓存
$paramer=array("limit"=>"6","reward"=>"1","item"=>"'rlist'","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[reward]=='1'){
$where="`rewardpack`='1'";
}elseif($paramer[share]=='1'){
$where="`sharepack`='1'";
}
//城市大类
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]))";
}
$where .= " AND `r_status`='1' AND `state`=1 and `status`='0' ";
//按照职位名称匹配
if($paramer[keyword]){
$where1[]="`name` LIKE '%".$paramer[keyword]."%'";
$where1[]="`com_name` LIKE '%".$paramer[keyword]."%'";
$where.=" AND (".@implode(" or ",$where1).")";
}
//筛除重复
if($paramer[noids]==1 && !empty($noids)){
$where.=" AND `id` NOT IN (".@implode(',',$noids).")";
}
//查询条数
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);
}
//排序字段默认为更新时间
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;
$rlist = $db->select_all("company_job",$where.$limit);
if(is_array($rlist)){
//处理类别字段
$cache_array = $db->cacheget();
$comuid=$jobid=array();
foreach($rlist as $key=>$value){
$comuid[] = $value['uid'];
$jobid[] = $value['id'];
}
$comuids = @implode(',',$comuid);
$jobids = @implode(',',$jobid);
$r_uid = array();
if($comuids){
$r_uids=$db->select_all("company","`uid` IN (".$comuids.")","`name`,`uid`,`shortname`,`yyzz_status`,`logo`,`pr`,`hy`,`mun`");
if(is_array($r_uids)){
foreach($r_uids as $key=>$value){
if($value['shortname']){
$value['name'] =$value['shortname'];
}
$value['logo']= checkpic($value['logo'],$config['sy_unit_icon']);
$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]];
$r_uid[$value['uid']] = $value;
}
}
}
if($jobids){
//$db -> update_all("company_job", "`jobexpoure` = `jobexpoure` + 1", "`id` IN ($jobids)");
if($paramer[reward]=='1'){
$rewardList=$db->select_all("company_job_reward","`jobid` IN (".$jobids.")");
}elseif($paramer[share]=='1'){
$rewardList=$db->select_all("company_job_share","`jobid` IN (".$jobids.")","`jobid`,`packmoney`,`packprice`,`packnum`");
}
if(is_array($rewardList)){
foreach($rewardList as $key=>$value){
$rewadArr[$value['jobid']] = $value;
}
}
}
$noids=array();
foreach($rlist as $key=>$value){
if($paramer[bid]){
$noids[] = $value[id];
}
$rlist[$key] = $db->array_action($value,$cache_array);
$rlist[$key][stime] = date("Y-m-d",$value[sdate]);
$rlist[$key][etime] = date("Y-m-d",$value[edate]);
if($arr_data['sex'][$value['sex']]){
$rlist[$key][sex_n]=$arr_data['sex'][$value['sex']];
}
$rlist[$key][lastupdate] = date("Y-m-d",$value[lastupdate]);
if($value[minsalary] && $value[maxsalary]){
if($config['resume_salarytype']==1){
$rlist[$key][job_salary] =$value[minsalary]."~".$value[maxsalary]."元";
}else{
if($value[maxsalary]<1000){
if($config['resume_salarytype']==2){
$rlist[$key][job_salary] = "1千以下";
}elseif($config['resume_salarytype']==3){
$rlist[$key][job_salary] = "1K以下";
}elseif($config['resume_salarytype']==4){
$rlist[$key][job_salary] = "1k以下";
}
}else{
$rlist[$key][job_salary] =changeSalary($value[minsalary])."~".changeSalary($value[maxsalary]);
}
}
}elseif($value[minsalary]){
if($config['resume_salarytype']==1){
$rlist[$key][job_salary] =$value[minsalary];
}else{
$rlist[$key][job_salary] =changeSalary($value[minsalary]);
}
}else{
$rlist[$key][job_salary] ="面议";
}
//if($r_uid[$value['uid']][shortname]){
$rlist[$key][com_name] =$r_uid[$value['uid']][name];
//}
$rlist[$key][yyzz_status] =$r_uid[$value['com_id']][yyzz_status];
$rlist[$key][logo] =$r_uid[$value['uid']][logo];
$rlist[$key][pr_n] =$r_uid[$value['uid']][pr_n];
$rlist[$key][hy_n] =$r_uid[$value['uid']][hy_n];
$rlist[$key][mun_n] =$r_uid[$value['uid']][mun_n];
if($paramer[reward]=='1'){
$rlist[$key][sqmoney] =floatval( $rewadArr[$value['id']][sqmoney]);
$rlist[$key][invitemoney] =floatval( $rewadArr[$value['id']][invitemoney]);
$rlist[$key][offermoney] =floatval( $rewadArr[$value['id']][offermoney]);
$rlist[$key][money] =floatval( $rewadArr[$value['id']][money]);
$rlist[$key][r_exp] = $rewadArr[$value['id']][exp];
$rlist[$key][r_edu] = $rewadArr[$value['id']][edu];
$rlist[$key][r_project] = $rewadArr[$value['id']][project];
$rlist[$key][r_skill] = $rewadArr[$value['id']][skill];
}
if($paramer[share]=='1'){
$rlist[$key][packmoney] = $rewadArr[$value['id']][packmoney];
$rlist[$key][packnum] = $rewadArr[$value['id']][packnum];
$rlist[$key][packprice] = $rewadArr[$value['id']][packprice];
}
$time=$value['lastupdate'];
//今天开始时间戳
$beginToday=time(0,0,0,date('m'),date('d'),date('Y'));
//昨天开始时间戳
$beginYesterday=time(0,0,0,date('m'),date('d')-1,date('Y'));
if($time>$beginYesterday && $time<$beginToday){
$rlist[$key]['time'] ="昨天";
}elseif($time>$beginToday){
$rlist[$key]['time'] = date("H:i",$value['lastupdate']);
$rlist[$key]['redtime'] =1;
}else{
$rlist[$key]['time'] = date("Y-m-d",$value['lastupdate']);
}
//获得福利待遇名称
if(is_array($rlist[$key]['welfare'])&&$rlist[$key]['welfare']){
foreach($rlist[$key]['welfare'] as $val){
//$rlist[$key]['welfarename'][]=$cache_array['comclass_name'][$val];
$rlist[$key]['welfarename'][]=$val;
}
}
//截取公司名称
if($paramer[comlen]){
if($r_uid[$value['com_id']][shortname]){
$rlist[$key][com_n] = mb_substr($r_uid[$value['com_id']][shortname],0,$paramer[comlen],"utf-8");
}else{
$rlist[$key][com_n] = mb_substr($value['com_name'],0,$paramer[comlen],"utf-8");
}
}
//截取职位名称
if($paramer[namelen]){
if($value['rec_time']>time()){
$rlist[$key][name_n] = "".mb_substr($value['name'],0,$paramer[namelen],"utf-8")."";
}else{
$rlist[$key][name_n] = mb_substr($value['name'],0,$paramer[namelen],"utf-8");
}
}else{
if($value['rec_time']>time()){
$rlist[$key]['name_n'] = "".$value['name']."";
}else{
$rlist[$key]['name_n'] = $value['name'];
}
}
//构建职位伪静态URL
$rlist[$key][job_url] = Url("job",array("c"=>"comapply","id"=>$value[id]),"1");
$rlist[$key][job_wapurl] = Url("wap",array("c"=>"job","a"=>"comapply","id"=>$value[id]),"1");
//构建企业伪静态URL
$rlist[$key][com_url] = Url("company",array("c"=>"show","id"=>$value[uid]));
foreach($comrat as $k=>$v){
if($value[rating]==$v[id]){
$rlist[$key][color] = str_replace("#","",$v[com_color]);
$rlist[$key][ratlogo] = $v[com_pic];
$rlist[$key][ratname] = $v[name];
}
}
if($paramer[keyword]){
$rlist[$key][name]=str_replace($paramer[keyword],"".$paramer[keyword]."",$value[name]);
$rlist[$key][com_name]=str_replace($paramer[keyword],"".$paramer[keyword]."",$value[com_name]);
$rlist[$key][name_n]=str_replace($paramer[keyword],"".$paramer[keyword]."",$rlist[$key][name_n]);
$rlist[$key][com_n]=str_replace($paramer[keyword],"".$paramer[keyword]."",$rlist[$key][com_n]);
}
}
if(is_array($rlist)){
if($paramer[keyword]!=""&&!empty($rlist)){
addkeywords('3',$paramer[keyword]);
}
}
}$rlist = $rlist; if (!is_array($rlist) && !is_object($rlist)) { settype($rlist, 'array');}
foreach ($rlist as $_smarty_tpl->tpl_vars['rlist']->key => $_smarty_tpl->tpl_vars['rlist']->value) {
$_smarty_tpl->tpl_vars['rlist']->_loop = true;
?>
-
tpl_vars['rlist']->value['job_salary'];?>
tpl_vars['rlist']->value['job_city_two'],0,4,"utf-8");?>
tpl_vars['rlist']->value['job_city_three'],0,4,"utf-8");?>
￥tpl_vars['rlist']->value['money'];?> 入职赏金￥tpl_vars['rlist']->value['sqmoney'];?>投递￥tpl_vars['rlist']->value['invitemoney'];?>面试￥tpl_vars['rlist']->value['offermoney'];?>入职
tpl_vars['hotjoblist'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['hotjoblist']->_loop = false;
global $db,$db_config,$config;$paramer=array("item"=>"'hotjoblist'","limit"=>"12","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"].="
";
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;
?>
-
tpl_vars['hotjoblist']->value['username'];?>tpl_vars['hotjoblist']->value['mun_n'];?> |tpl_vars['hotjoblist']->value['hy'];?>tpl_vars['hotjoblist']->value['num'];?> 个热招职位tpl_vars['hotjoblist']->value['num']>0) {?> tpl_vars['hotjoblist']->value['hotjob'];?>
-
tpl_vars['job_list'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['job_list']->_loop = false;
global $db,$db_config,$config;
$time = time();
//可以做缓存
$paramer=array("namelen"=>"9","rec"=>"1","comlen"=>"18","limit"=>"32","item"=>"'job_list'","name"=>"'job_list1'","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;
?>
-
tpl_vars['job_list']->value['name_n'];?> tpl_vars['job_list']->value['job_salary']!='面议') { } echo $_smarty_tpl->tpl_vars['job_list']->value['job_salary'];?>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'];?> 学历
value;?> /images/lay-loding.png' lay-src="tpl_vars['job_list']->value['logo'];?> " class="index_newjob_com_tx"/>
tpl_vars['job_list']->value['com_n'];?> tpl_vars['job_list']->value['ratlogo']) {?>tpl_vars['job_list']->value['yyzz_status']==1) {?>
tpl_vars['job_list']->value['hy_n'];?> | tpl_vars['job_list']->value['mun_n'];?>
-
tpl_vars['job_list'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['job_list']->_loop = false;
global $db,$db_config,$config;
$time = time();
//可以做缓存
$paramer=array("namelen"=>"9","comlen"=>"18","limit"=>"32","item"=>"'job_list'","name"=>"'job_list1'","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;
?>
-
tpl_vars['job_list']->value['name_n'];?> tpl_vars['job_list']->value['job_salary']!='面议') { } echo $_smarty_tpl->tpl_vars['job_list']->value['job_salary'];?>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['com_n'];?> tpl_vars['job_list']->value['ratlogo']) {?>
tpl_vars['job_list']->value['hy_n'];?> | tpl_vars['job_list']->value['mun_n'];?>
-
tpl_vars['ulist_rec'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['ulist_rec']->_loop = false;
$_smarty_tpl->tpl_vars['key'] = new Smarty_Variable;
$ulist_rec=array();global $db,$db_config,$config;
if(is_array($_GET)){
foreach($_GET as $key=>$value){
if($value=='0'){
unset($_GET[$key]);
}
}
}
$paramer=array("item"=>"'ulist_rec'","post_len"=>"10","limit"=>"8","rec_resume"=>"1","key"=>"'key'","name"=>"'userlist2'","nocache"=>"")
;
$ParamerArr = GetSmarty($paramer,$_GET,$_smarty_tpl);
$paramer = $ParamerArr[arr];
$Purl = $ParamerArr[purl];
global $ModuleName;
if(!$Purl["m"]){
$Purl["m"]=$ModuleName;
}
//处理类别字段
include(CONFIG_PATH."db.data.php");
$cache_array = $db->cacheget();
$fscache_array = $db->fscacheget();
$userclass_name = $cache_array["user_classname"];
$city_name = $cache_array["city_name"];
$city_index = $cache_array["city_index"];
$job_name = $cache_array["job_name"];
$job_index = $cache_array["job_index"];
$job_type = $cache_array["job_type"];
$industry_name = $cache_array["industry_name"];
$city_parent = $fscache_array["city_parent"];
$job_parent = $fscache_array["job_parent"];
//是否属于分站下
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'];
}
}
$where = "a.`defaults`=1 and a.`state`=1 and a.`r_status`=1 AND a.`status`=1";
//关注我公司的人才--条件
if($paramer[where_uid]){
$where .=" AND a.`uid` in (".$paramer['where_uid'].")";
}
//黑名单不能查看已拉黑的个人用户简历
if($_COOKIE['uid']&&$_COOKIE['usertype']=="2"){
$blacklist=$db->select_all("blacklist","`p_uid`='".$_COOKIE['uid']."'","c_uid");
if(is_array($blacklist)&&$blacklist){
foreach($blacklist as $v){
$buid[]=$v['c_uid'];
}
$where .=" AND a.`uid` NOT IN (".@implode(",",$buid).")";
}
}
//置顶
if($paramer[topdate]){
$where .=" AND a.`top`=1 AND a.`topdate`>'".time()."'";
}
if($paramer[top]){
$where .=" AND a.`top`=1 AND a.`topdate`>'".time()."'";
}
//身份认证
if($paramer[idcard]){
$where .=" AND a.`idcard_status`=1";
}
//优质人才
if($paramer[height_status]){
$where .=" AND a.`height_status`=".$paramer[height_status];
}
//优质人才推荐
if($paramer[rec]){
$where .=" AND a.`rec`=1";
}
//普通推荐
if($paramer[rec_resume]){
$where .=" AND a.`rec_resume`=1";
}
//作品
if($paramer[work]){
$show=$db->select_all("resume_show","1 group by eid","`eid`");
if(is_array($show)){
foreach($show as $v){
$eid[]=$v['eid'];
}
}
$where .=" AND a.`id` in (".@implode(",",$eid).")";
}
//标签
if($paramer[tag]){
$tagname=$userclass_name[$paramer[tag]];
$tag=$db->select_all("resume","`def_job`>0 and `r_status`=1 and `status`=1 and FIND_IN_SET('".$tagname."',`tag`)","`def_job`");
if(is_array($tag)){
foreach($tag as $v){
$tagid[]=$v['def_job'];
}
}
$where .=" AND a.`id` in (".@implode(",",$tagid).")";
}
//更新时间区间
if($paramer[uptime]){
if($paramer[uptime]==1){
$beginToday=mktime(0,0,0,date('m'),date('d'),date('Y'));
$where.=" AND a.`lastupdate`>$beginToday";
}else{
$time=time();
$uptime = $time-($paramer[uptime]*86400);
$where.=" AND a.`lastupdate`>$uptime";
}
}else{
if($config[sy_datacycle]>0){
// 后台-页面设置-数据周期
$uptime = strtotime('-'.$config[sy_datacycle].' day');
$where.=" AND a.`lastupdate`>$uptime";
}
}
//添加时间区间，即审核时间
if($paramer[adtime]){
$time=time();
$adtime = $time-($paramer[adtime]*86400);
$where.=" AND a.`status_time`>$adtime";
}
//是否有照片
if($paramer[pic]=="1"){
$where .=" AND a.`photo`<>'' AND a.`phototype`!=1 AND a.`defphoto` = 1";
}
//行业
if($paramer['hy']!=""){
$where .= " AND a.`hy` IN (".$paramer['hy'].")";
}
$job_col = $city_col = "";
$cjwhere = "";
if($paramer[three_cityid]){
$city_col = "three_cityid";
$cjwhere .= " AND cj.`$city_col`= $paramer[three_cityid]";
}elseif($paramer[cityid]){
$city_col = "cityid";
$cjwhere .= " AND cj.`$city_col`= $paramer[cityid]";
}elseif($paramer[provinceid]){
$city_col = "provinceid";
$cjwhere .= " AND cj.`$city_col`= $paramer[provinceid]";
}
//城市区间,不建议执行该查询
if($paramer[cityin]){
if($city_parent[$paramer[cityin]]=='0'){
$city_col = "provinceid";
$cjwhere .= " AND cj.`$city_col` = $paramer[cityin]";
}elseif(in_array($city_parent[$paramer[cityin]],$city_index)){
$city_col = "cityid";
$cjwhere .= " AND cj.`$city_col` = $paramer[cityin]";
}elseif($city_parent[$paramer[cityin]]>0){
$city_col = "three_cityid";
$cjwhere .= " AND cj.`$city_col` = $paramer[cityin]";
}
}
if($paramer[job_post]){
$job_col = "job_post";
$cjwhere .= " AND cj.`$job_col`= $paramer[job_post]";
}elseif($paramer[job1_son]){
$job_col = "job1_son";
$cjwhere .= " AND cj.`$job_col`= $paramer[job1_son]";
}elseif($paramer[job1]){
$job_col = "job1";
$cjwhere .= " AND cj.`$job_col`= $paramer[job1]";
}
//职位区间,不建议执行该查询
if($paramer[jobin]){
if($job_parent[$paramer[jobin]]=='0'){
$job_col = "job1";
$cjwhere .=" AND cj.`$job_col`= $paramer[jobin]";
}elseif(in_array($job_parent[$paramer[jobin]],$job_index)){
$job_col = "job1_son";
$cjwhere .=" AND cj.`$job_col`= $paramer[jobin]";
}elseif($job_parent[$paramer[jobin]]>0){
$job_col = "job_post";
$cjwhere .=" AND cj.`$job_col`= $paramer[jobin]";
}
}
// 拼接唯一标识字段
if($city_col || $job_col){
if($city_col && $job_col){
$cjwhere .= " AND cj.`{$city_col}_{$job_col}_num`= 1";
}elseif($city_col){
$cjwhere .= " AND cj.`{$city_col}_num`= 1";
}elseif($job_col){
$cjwhere .= " AND cj.`{$job_col}_num`= 1";
}
}
//工作经验
if($paramer[exp]){
$expKey = $db->DB_select_once("userclass", "`variable` = 'user_word'", "`id`");
$expReq = $db->DB_select_once("userclass", "`id` = $paramer[exp]", "`sort`,`name`");
if($expReq[name] != "不限"){
$expArr = $db->select_all("userclass", "`keyid` = $expKey[id] AND `sort` >= $expReq[sort]", "`id`");
$expIds = array();
foreach($expArr as $v){
$expIds[] = $v[id];
}
$where .= " AND a.`exp` in (".@implode(",",$expIds).")";
}
}
//学历
if($paramer[edu]){
$eduKey = $db->DB_select_once("userclass", "`variable` = 'user_edu'", "`id`");
$eduReq = $db->DB_select_once("userclass", "`id` = $paramer[edu]", "`sort`,`name`");
if($eduReq[name] != "不限"){
$eduArr = $db->select_all("userclass", "`keyid` = $eduKey[id] AND `sort` >= $eduReq[sort]", "`id`");
$eduIds = array();
foreach($eduArr as $v){
$eduIds[] = $v[id];
}
$where .= " AND a.`edu` in (".@implode(",",$eduIds).")";
}
}
//性别
if($paramer[sex]){
$where .=" AND a.`sex`=$paramer[sex]";
}
//到岗时间
if($paramer[report]){
$where .=" AND a.`report`=$paramer[report]";
}
//工作性质
if($paramer[type]){
$where .= " AND a.`type`=$paramer[type]";
}
if($paramer[notid]){
$where.= " and `id`<>$paramer[notid]";
}
//简历完整度
if($paramer[integrity]){
$integrityR = $arr_data["integrity_val"];
$where.= " AND a.`integrity`>='".$integrityR[$paramer[integrity]]."'";
}
//关键字
if($paramer[keyword]){
$where1 = array();
$where1[]="a.`name` LIKE '%$paramer[keyword]%'";
$where1[]="a.`uname` LIKE '%$paramer[keyword]%'";
//搜索工作经历
$workList = $db->select_all('resume_work',"`title` LIKE '%$paramer[keyword]%' OR `content` LIKE '%$paramer[keyword]%' ORDER BY id DESC limit 500","`eid`");
if(!empty($workList)){
$workId = array();
foreach($workList as $value){
$workId[] = $value['eid'];
}
$where1[] = "a.id IN (".implode(',',$workId).")";
}
$where.=" AND (".@implode(" or ",$where1).")";
}
//薪资待遇
if($paramer[minsalary]&&$paramer[maxsalary]){
$where.= " AND ((a.`minsalary`<=".intval($paramer[minsalary])." and a.`maxsalary`>=".intval($paramer[minsalary]).")
or (a.`minsalary`<=".intval($paramer[maxsalary])." and a.`maxsalary`>=".intval($paramer[maxsalary])."))";
}elseif($paramer[minsalary]&&!$paramer[maxsalary]){
$where.= " AND ((a.`minsalary`<=".intval($paramer[minsalary])." and a.`maxsalary`>=".intval($paramer[minsalary]).")
or (a.`minsalary`>=".intval($paramer[minsalary])." and a.`maxsalary`>=".intval($paramer[minsalary]).")
or (a.`minsalary`!=0 and a.`maxsalary`=0))";
}elseif(!$paramer[minsalary]&&$paramer[maxsalary]){
$where.= " AND ((a.`minsalary`<=".intval($paramer[maxsalary])." and a.`maxsalary`>=".intval($paramer[maxsalary]).")
or (a.`minsalary`<=".intval($paramer[maxsalary])." and a.`maxsalary`<=".intval($paramer[maxsalary]).")
or (a.`minsalary`<=".intval($paramer[maxsalary])." and a.`maxsalary`=0)
or (a.`minsalary`=0 and a.`maxsalary`!=0)
)";
}
//年龄
if($paramer[minage]&&$paramer[maxage]){
$mintime=date("Y-m-d",strtotime("-".$paramer[minage]." year"));
$maxtime=date("Y-m-d",strtotime("-".$paramer[maxage]." year"));
$where.= " AND a.`birthday`>= '".$maxtime."' and a.`birthday`<='".$mintime."'";
}elseif($paramer[minage]&&!$paramer[maxage]){
$mintime=date("Y-m-d",strtotime("-".$paramer[minage]." year"));
$where.= " AND a.`birthday`<='".$mintime."'";
}elseif(!$paramer[minage]&&$paramer[maxage]){
$maxtime=date("Y-m-d",strtotime("-".$paramer[maxage]." year"));
$where.= " AND a.`birthday`>='".$maxtime."'";
}
//排序字段默认为更新时间
if($paramer[order] && $paramer[order]!="lastdate"){
if($paramer[order]=='topdate'){
$nowtime=time();
$order = " ORDER BY if(a.`topdate`>$nowtime,a.`topdate`,a.`lastupdate`) ";
}else{
$order = " ORDER BY a.`".$paramer[order]."` ";
}
}else{
$order = " ORDER BY a.`lastupdate` ";
}
//排序规则 默认为倒序
$sort = $paramer[sort]?$paramer[sort]:"DESC";
//查询条数
if($paramer[limit]){
$limit=" LIMIT ".$paramer[limit];
}
//自定义查询条件，默认取代上面任何参数直接使用该语句
if($paramer[where]){
$where = $paramer[where];
}
$pagewhere = "";$joinwhere = "";
if($cjwhere){
$pagewhere.=" ,`".$db_config[def]."resume_city_job_class` cj ";
$joinwhere .= " a.`id`=cj.`eid` " . $cjwhere;
}
if($paramer[ispage]){
// 查询分页
if($paramer["height_status"]){
$limit = PageNav($paramer,$_GET,"resume_expect",$where,$Purl,"",$paramer[islt]?$paramer[islt]:"3",$_smarty_tpl,$pagewhere,$joinwhere);
}else{
$limit = PageNav($paramer,$_GET,"resume_expect",$where,$Purl,"","0",$_smarty_tpl,$pagewhere,$joinwhere);
}
}
if($paramer[topdate] && $_GET[page]>1){
$ulist_rec = array();
}else{
$select="a.`id`,a.`uid`,a.`name`,a.`hy`,a.`job_classid`,a.`city_classid`,a.`jobstatus`,a.`type`,a.`report`,a.`lastupdate`,a.`rec`,a.`top`,a.`topdate`,a.`rec_resume`,a.`ctime`,a.`uname`,a.`idcard_status`,a.`minsalary`,a.`maxsalary`";
if($pagewhere!=""){
$sql = "select ".$select." from `".$db_config[def]."resume_expect` a ".$pagewhere." where ".$joinwhere." and ".$where.$order.$sort.$limit;
$ulist_rec=$db->DB_query_all($sql,"all");
}else{
$sql = "select ".$select." from `".$db_config[def]."resume_expect` a where ".$where.$order.$sort.$limit;
$ulist_rec=$db->DB_query_all($sql,"all");
}
}
if(!empty($ulist_rec) && is_array($ulist_rec)){
//如果存在top，则说明请求来自排行榜页面
if($paramer['top']){
$uids=$m_name=array();
foreach($ulist_rec as $k=>$v){
$uids[]=$v[uid];
}
$member=$db->select_all($db_config[def]."member","`uid` in(".@implode(',',$uids).")","uid,username");
foreach($member as $val){
$m_name[$val[uid]]=$val['username'];
}
}
$uid = $eid = array();
foreach($ulist_rec as $key=>$value){
$uid[] = $value['uid'];
$eid[] = $value['id'];
}
$eids = @implode(',',$eid);
$uids = @implode(',',$uid);
$resume=$db->select_all("resume","`uid` in(".$uids.")","uid,name,nametype,tag,sex,moblie_status,edu,exp,defphoto,photo,phototype,photo_status,birthday");
foreach($resume as $v){
$ruids[] = $v['uid'];
}
foreach($ulist_rec as $k=>$v){
if(!in_array($v['uid'],$ruids)){
unset($ulist_rec[$k]);
continue;
}
}
if($paramer[topdate]){
$noids=array();
}
if($paramer[workexp] == 1){
$eduList = $db -> select_all("resume_edu","`eid` in(".$eids.")");
if(!empty($eduList)){
foreach($eduList as $key=>$value){
$eduListNew[$value['eid']][] = $value;
}
foreach($eduListNew as $k=>$eduv){
$edumin = 0;
$edumax = 0;
$edutitle = array();
$education = array();
foreach($eduv as $v){
if($v['sdate']>0 && $edumin==0){
$edumin = $v['sdate'];
}elseif($edumin>$v['sdate']){
$edumin = $v['sdate'];
}
if($v['edate']==0 ){
$edumax = 0;
}elseif($edumax<$v['edate']){
$edumax = $v['edate'];
}
$education[] = $userclass_name[$v['education']];
$edutitle[] = $v['specialty'];
}
$return =array();
$return['edumin'] = date('Y-m',$edumin);
$return['edumax'] = $edumax == 0 ? '至今': date('Y',$edumax);
$return['education'] = @implode(',',$education);
$return['eduspecialty'] = @implode('、',$edutitle);
$return['edu_time'] = $return['edumin']."-".$return['edumax'];
if($return['eduspecialty']){
$workexpList[$k]['edu_content'] = $return['education'].'学历 ▪ '.$return['eduspecialty'].' ▪ 毕业于'.$return['edumax'].'年';
}else{
$workexpList[$k]['edu_content'] = $return['education'].'学历 ▪ 毕业于'.$return['edumax'].'年';
}
}
}
$workList = $db -> select_all("resume_work","`eid` in(".$eids.")");
if(!empty($workList)){
foreach($workList as $key=>$value){
$workListNew[$value['eid']][] = $value;
}
foreach($workListNew as $k=>$workv){
$whour = 0;
$hour = array();
$time = time();
$workmin = 0;
$workmax = 0;
$worknum = count($workv);
$wtitle = array();
foreach($workv as $v){
/* 计算每份工作时长(按月) */
if($v['sdate']>0 && $workmin==0){
$workmin = $v['sdate'];
}elseif($workmin>$v['sdate']){
$workmin = $v['sdate'];
}
if($v['edate']==0 ){
$workmax = 0;
}elseif($workmax<$v['edate']){
$workmax = $v['edate'];
}
$wtitle[] = $v['title'];
$hour[] = $workTime;
$whour += $workTime;
}
$workavg = ceil($whour/count($hour));
$return = array();
$return['worknum'] = $worknum > 0 ? $worknum:0;
$return['workavg'] = $workavg > 0 ? $workavg:0;
$return['workmin'] = date('Y-m',$workmin);
$return['workmax'] = $workmax == 0 ? '至今': date('Y-m',$workmax);
$return['worktit'] = @implode(',',$wtitle);
$return['work_time'] = $return['workmin'].'-'.$return['workmax'];
if($return['worktit']!=''){
$workexpList[$k]['work_content'] = ' 参加过'.$return['worknum'].'份工作 ▪ 涉及'.$return['worktit'].'等岗位';
}else{
$workexpList[$k]['work_content'] = ' 参加过'.$return['worknum'].'份工作';
}
}
}
}
foreach($ulist_rec as $k=>$v){
if($paramer[topdate]){
$noids[] = $v[id];
}
//筛除重复
if($paramer[noid]=='1' && !empty($noids) && in_array($v['id'],$noids)){
unset($ulist_rec[$k]);
continue;
}
foreach($resume as $val){
if($v['uid']==$val['uid']){
$ulist_rec[$k]['edu_n']=$userclass_name[$val['edu']];
$ulist_rec[$k]['exp_n']=$userclass_name[$val['exp']];
if($val['birthday']){
$year = date("Y",strtotime($val['birthday']));
$ulist_rec[$k]['age'] =date("Y")-$year;
}
if($val['sex']==152){
$val['sex']='1';
}elseif ($val['sex']==153){
$val['sex']='2';
}
$ulist_rec[$k]['sex'] =$arr_data[sex][$val['sex']];
$ulist_rec[$k]['phototype']=$val[phototype];
$photo=$icon="";
if($val['defphoto']==2){
$photo=$val['photo'];
}else{
if($config['user_pic']==1 || empty($config['user_pic'])){
if($val['photo'] && $val['photo_status']==0 && $val['phototype']!=1){
$photo=$val['photo'];
}else{
if($val['sex']==1){
$icon=$config['sy_member_icon'];
}else{
$icon=$config['sy_member_iconv'];
}
}
}elseif($config['user_pic']==2){
if($val['photo']&& $val['photo_status']==0){
$photo=$val['photo'];
}else{
if($val['sex']==1){
$icon=$config['sy_member_icon'];
}else{
$icon=$config['sy_member_iconv'];
}
}
}elseif($config['user_pic']==3){
if($val['sex']==1){
$icon=$config['sy_member_icon'];
}else{
$icon=$config['sy_member_iconv'];
}
}
}
$ulist_rec[$k]['photo']=checkpic($photo,$icon);
if($val['tag']){
$ulist_rec[$k]['tag']=explode(',',$val['tag']);
}
$ulist_rec[$k]['nametype']=$val[nametype];
$ulist_rec[$k]['moblie_status']=$val[moblie_status];
//名称显示处理
if($config['user_name']==1 || !$config['user_name']){
if($val['nametype']==3){
if($val['sex']==1){
$ulist_rec[$k]['username_n'] = mb_substr($val['name'],0,1,'utf-8')."先生";
}else{
$ulist_rec[$k]['username_n'] = mb_substr($val['name'],0,1,'utf-8')."女士";
}
}elseif($val['nametype']==2){
$ulist_rec[$k]['username_n'] = "NO.".$v['id'];
}else{
$ulist_rec[$k]['username_n'] = $val['name'];
}
}elseif($config['user_name']==3){
if($val['sex']==1){
$ulist_rec[$k]['username_n'] = mb_substr($val['name'],0,1,'utf-8')."先生";
}else{
$ulist_rec[$k]['username_n'] = mb_substr($val['name'],0,1,'utf-8')."女士";
}
}elseif($config['user_name']==2){
$ulist_rec[$k]['username_n'] = "NO.".$v['id'];
}elseif($config['user_name']==4){
$ulist_rec[$k]['username_n'] = $val['name'];
}
}
}
//更新时间显示方式
$time=$v['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){
$ulist_rec[$k]['time'] = "昨天";
}elseif($time>$beginToday){
$ulist_rec[$k]['time'] = lastupdateStyle($v['lastupdate']);
$ulist_rec[$k]['redtime'] =1;
}else{
$ulist_rec[$k]['time'] = date("Y-m-d",$v['lastupdate']);
}
// 前天
$beforeYesterday=mktime(0,0,0,date('m'),date('d')-2,date('Y'));
if($v['ctime']>$beforeYesterday){
$ulist_rec[$k]['newtime'] =1;
}
$ulist_rec[$k]['user_jobstatus_n']=$userclass_name[$v['jobstatus']];
// $ulist_rec[$k]['job_city_one']=$city_name[$v['provinceid']];
// $ulist_rec[$k]['job_city_two']=$city_name[$v['cityid']];
// $ulist_rec[$k]['job_city_three']=$city_name[$v['three_cityid']];
if($v['minsalary']&&$v['maxsalary']){
if($config['resume_salarytype']==1){
$ulist_rec[$k]["salary_n"] = $v['minsalary']."-".$v['maxsalary'];
}else{
if($v[maxsalary]<1000){
if($config['resume_salarytype']==2){
$ulist_rec[$k]["salary_n"] = "1千以下";
}elseif($config['resume_salarytype']==3){
$ulist_rec[$k]["salary_n"] = "1K以下";
}elseif($config['resume_salarytype']==4){
$ulist_rec[$k]["salary_n"] = "1k以下";
}
}else{
$ulist_rec[$k]["salary_n"] = changeSalary($v['minsalary'])."-".changeSalary($v['maxsalary']);
}
}
}else if($v['minsalary']){
if($config['resume_salarytype']==1){
$ulist_rec[$k]["salary_n"] = $v['minsalary'];
}else{
$ulist_rec[$k]["salary_n"] = changeSalary($v['minsalary']);
}
}else{
$ulist_rec[$k]["salary_n"] = "面议";
}
$ulist_rec[$k]['report_n']=$userclass_name[$v['report']];
$ulist_rec[$k]['type_n']=$userclass_name[$v['type']];
$ulist_rec[$k]['lastupdate']=date("Y-m-d",$v['lastupdate']);
$ulist_rec[$k]['user_url']=Url("resume",array("c"=>"show","id"=>$v['id']),"1");
$ulist_rec[$k]["hy_info"]=$industry_name[$v['hy']];
if($paramer['top']){
$ulist_rec[$k]['m_name']=$m_name[$v['uid']];
$ulist_rec[$k]['user_url']=Url("ask",array("c"=>"friend","a"=>"myquestion","uid"=>$v['uid']));
}
$ulist_rec[$k]['work_content']=$workexpList[$v['id']]['work_content'];
$ulist_rec[$k]['edu_content']=$workexpList[$v['id']]['edu_content'];
$kjob_classid=@explode(",",$v['job_classid']);
$kjob_classid=array_unique($kjob_classid);
$jobname=array();
if(is_array($kjob_classid)){
foreach($kjob_classid as $val){
if($val!=''){
if($paramer['keyword']){
$jobname[]=str_replace($paramer['keyword'],"".$paramer['keyword']."",$job_name[$val]);
}else{
$jobname[]=$job_name[$val];
}
}
}
}
//$ulist_rec[$k]['job_post']=@implode(",",$jobname);
$ulist_rec[$k]['expectjob']=$jobname;
$kcity_classid=@explode(",",$v['city_classid']);
$kcity_classid=array_unique($kcity_classid);
$cityname=array();
if(is_array($kcity_classid)){
foreach($kcity_classid as $val){
if($val!=''){
$cityname[]=$city_name[$val];
}
}
}
//$ulist_rec[$k]['citylist']=@implode("/",$cityname);
$ulist_rec[$k]['expectcity']=$cityname;
//截取标题
if($paramer['post_len']){
$postname[$k]=@implode(",",$jobname);
$ulist_rec[$k]['job_post_n']=mb_substr($postname[$k],0,$paramer[post_len],"utf-8");
}
if($paramer['city_len']){
$scityname[$k]=@implode("/",$cityname);
$ulist_rec[$k]['city_name_n']=mb_substr($scityname[$k],0,$paramer[city_len],"utf-8");
}
}
foreach($ulist_rec as $k=>$v){
if($paramer['keyword']){
$ulist_rec[$k]['username_n']=str_replace($paramer['keyword'],"".$paramer['keyword']."",$v['username_n']);
$ulist_rec[$k]['job_post']=str_replace($paramer['keyword'],"".$paramer['keyword']."",$ulist_rec[$k]['job_post']);
$ulist_rec[$k]['job_post_n']=str_replace($paramer['keyword'],"".$paramer['keyword']."",$ulist_rec[$k]['job_post_n']);
$ulist_rec[$k]['city_name_n']=str_replace($paramer['keyword'],"".$paramer['keyword']."",$ulist_rec[$k]['city_name_n']);
}
}
if($paramer['keyword']!=""&&!empty($ulist_rec)){
addkeywords('5',$paramer['keyword']);
}
}$ulist_rec = $ulist_rec; if (!is_array($ulist_rec) && !is_object($ulist_rec)) { settype($ulist_rec, 'array');}
foreach ($ulist_rec as $_smarty_tpl->tpl_vars['ulist_rec']->key => $_smarty_tpl->tpl_vars['ulist_rec']->value) {
$_smarty_tpl->tpl_vars['ulist_rec']->_loop = true;
$_smarty_tpl->tpl_vars['key']->value = $_smarty_tpl->tpl_vars['ulist_rec']->key;
?>
-
tpl_vars['ulist_rec']->value['age'];?> 岁|tpl_vars['ulist_rec']->value['exp_n'];?> 经验|tpl_vars['ulist_rec']->value['edu_n'];?> 学历意向：tpl_vars['ulist_rec']->value['job_post_n'];?>
-
tpl_vars['ulist'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['ulist']->_loop = false;
$_smarty_tpl->tpl_vars['key'] = new Smarty_Variable;
$ulist=array();global $db,$db_config,$config;
if(is_array($_GET)){
foreach($_GET as $key=>$value){
if($value=='0'){
unset($_GET[$key]);
}
}
}
$paramer=array("item"=>"'ulist'","post_len"=>"10","limit"=>"16","key"=>"'key'","name"=>"'userlist1'","nocache"=>"")
;
$ParamerArr = GetSmarty($paramer,$_GET,$_smarty_tpl);
$paramer = $ParamerArr[arr];
$Purl = $ParamerArr[purl];
global $ModuleName;
if(!$Purl["m"]){
$Purl["m"]=$ModuleName;
}
//处理类别字段
include(CONFIG_PATH."db.data.php");
$cache_array = $db->cacheget();
$fscache_array = $db->fscacheget();
$userclass_name = $cache_array["user_classname"];
$city_name = $cache_array["city_name"];
$city_index = $cache_array["city_index"];
$job_name = $cache_array["job_name"];
$job_index = $cache_array["job_index"];
$job_type = $cache_array["job_type"];
$industry_name = $cache_array["industry_name"];
$city_parent = $fscache_array["city_parent"];
$job_parent = $fscache_array["job_parent"];
//是否属于分站下
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'];
}
}
$where = "a.`defaults`=1 and a.`state`=1 and a.`r_status`=1 AND a.`status`=1";
//关注我公司的人才--条件
if($paramer[where_uid]){
$where .=" AND a.`uid` in (".$paramer['where_uid'].")";
}
//黑名单不能查看已拉黑的个人用户简历
if($_COOKIE['uid']&&$_COOKIE['usertype']=="2"){
$blacklist=$db->select_all("blacklist","`p_uid`='".$_COOKIE['uid']."'","c_uid");
if(is_array($blacklist)&&$blacklist){
foreach($blacklist as $v){
$buid[]=$v['c_uid'];
}
$where .=" AND a.`uid` NOT IN (".@implode(",",$buid).")";
}
}
//置顶
if($paramer[topdate]){
$where .=" AND a.`top`=1 AND a.`topdate`>'".time()."'";
}
if($paramer[top]){
$where .=" AND a.`top`=1 AND a.`topdate`>'".time()."'";
}
//身份认证
if($paramer[idcard]){
$where .=" AND a.`idcard_status`=1";
}
//优质人才
if($paramer[height_status]){
$where .=" AND a.`height_status`=".$paramer[height_status];
}
//优质人才推荐
if($paramer[rec]){
$where .=" AND a.`rec`=1";
}
//普通推荐
if($paramer[rec_resume]){
$where .=" AND a.`rec_resume`=1";
}
//作品
if($paramer[work]){
$show=$db->select_all("resume_show","1 group by eid","`eid`");
if(is_array($show)){
foreach($show as $v){
$eid[]=$v['eid'];
}
}
$where .=" AND a.`id` in (".@implode(",",$eid).")";
}
//标签
if($paramer[tag]){
$tagname=$userclass_name[$paramer[tag]];
$tag=$db->select_all("resume","`def_job`>0 and `r_status`=1 and `status`=1 and FIND_IN_SET('".$tagname."',`tag`)","`def_job`");
if(is_array($tag)){
foreach($tag as $v){
$tagid[]=$v['def_job'];
}
}
$where .=" AND a.`id` in (".@implode(",",$tagid).")";
}
//更新时间区间
if($paramer[uptime]){
if($paramer[uptime]==1){
$beginToday=mktime(0,0,0,date('m'),date('d'),date('Y'));
$where.=" AND a.`lastupdate`>$beginToday";
}else{
$time=time();
$uptime = $time-($paramer[uptime]*86400);
$where.=" AND a.`lastupdate`>$uptime";
}
}else{
if($config[sy_datacycle]>0){
// 后台-页面设置-数据周期
$uptime = strtotime('-'.$config[sy_datacycle].' day');
$where.=" AND a.`lastupdate`>$uptime";
}
}
//添加时间区间，即审核时间
if($paramer[adtime]){
$time=time();
$adtime = $time-($paramer[adtime]*86400);
$where.=" AND a.`status_time`>$adtime";
}
//是否有照片
if($paramer[pic]=="1"){
$where .=" AND a.`photo`<>'' AND a.`phototype`!=1 AND a.`defphoto` = 1";
}
//行业
if($paramer['hy']!=""){
$where .= " AND a.`hy` IN (".$paramer['hy'].")";
}
$job_col = $city_col = "";
$cjwhere = "";
if($paramer[three_cityid]){
$city_col = "three_cityid";
$cjwhere .= " AND cj.`$city_col`= $paramer[three_cityid]";
}elseif($paramer[cityid]){
$city_col = "cityid";
$cjwhere .= " AND cj.`$city_col`= $paramer[cityid]";
}elseif($paramer[provinceid]){
$city_col = "provinceid";
$cjwhere .= " AND cj.`$city_col`= $paramer[provinceid]";
}
//城市区间,不建议执行该查询
if($paramer[cityin]){
if($city_parent[$paramer[cityin]]=='0'){
$city_col = "provinceid";
$cjwhere .= " AND cj.`$city_col` = $paramer[cityin]";
}elseif(in_array($city_parent[$paramer[cityin]],$city_index)){
$city_col = "cityid";
$cjwhere .= " AND cj.`$city_col` = $paramer[cityin]";
}elseif($city_parent[$paramer[cityin]]>0){
$city_col = "three_cityid";
$cjwhere .= " AND cj.`$city_col` = $paramer[cityin]";
}
}
if($paramer[job_post]){
$job_col = "job_post";
$cjwhere .= " AND cj.`$job_col`= $paramer[job_post]";
}elseif($paramer[job1_son]){
$job_col = "job1_son";
$cjwhere .= " AND cj.`$job_col`= $paramer[job1_son]";
}elseif($paramer[job1]){
$job_col = "job1";
$cjwhere .= " AND cj.`$job_col`= $paramer[job1]";
}
//职位区间,不建议执行该查询
if($paramer[jobin]){
if($job_parent[$paramer[jobin]]=='0'){
$job_col = "job1";
$cjwhere .=" AND cj.`$job_col`= $paramer[jobin]";
}elseif(in_array($job_parent[$paramer[jobin]],$job_index)){
$job_col = "job1_son";
$cjwhere .=" AND cj.`$job_col`= $paramer[jobin]";
}elseif($job_parent[$paramer[jobin]]>0){
$job_col = "job_post";
$cjwhere .=" AND cj.`$job_col`= $paramer[jobin]";
}
}
// 拼接唯一标识字段
if($city_col || $job_col){
if($city_col && $job_col){
$cjwhere .= " AND cj.`{$city_col}_{$job_col}_num`= 1";
}elseif($city_col){
$cjwhere .= " AND cj.`{$city_col}_num`= 1";
}elseif($job_col){
$cjwhere .= " AND cj.`{$job_col}_num`= 1";
}
}
//工作经验
if($paramer[exp]){
$expKey = $db->DB_select_once("userclass", "`variable` = 'user_word'", "`id`");
$expReq = $db->DB_select_once("userclass", "`id` = $paramer[exp]", "`sort`,`name`");
if($expReq[name] != "不限"){
$expArr = $db->select_all("userclass", "`keyid` = $expKey[id] AND `sort` >= $expReq[sort]", "`id`");
$expIds = array();
foreach($expArr as $v){
$expIds[] = $v[id];
}
$where .= " AND a.`exp` in (".@implode(",",$expIds).")";
}
}
//学历
if($paramer[edu]){
$eduKey = $db->DB_select_once("userclass", "`variable` = 'user_edu'", "`id`");
$eduReq = $db->DB_select_once("userclass", "`id` = $paramer[edu]", "`sort`,`name`");
if($eduReq[name] != "不限"){
$eduArr = $db->select_all("userclass", "`keyid` = $eduKey[id] AND `sort` >= $eduReq[sort]", "`id`");
$eduIds = array();
foreach($eduArr as $v){
$eduIds[] = $v[id];
}
$where .= " AND a.`edu` in (".@implode(",",$eduIds).")";
}
}
//性别
if($paramer[sex]){
$where .=" AND a.`sex`=$paramer[sex]";
}
//到岗时间
if($paramer[report]){
$where .=" AND a.`report`=$paramer[report]";
}
//工作性质
if($paramer[type]){
$where .= " AND a.`type`=$paramer[type]";
}
if($paramer[notid]){
$where.= " and `id`<>$paramer[notid]";
}
//简历完整度
if($paramer[integrity]){
$integrityR = $arr_data["integrity_val"];
$where.= " AND a.`integrity`>='".$integrityR[$paramer[integrity]]."'";
}
//关键字
if($paramer[keyword]){
$where1 = array();
$where1[]="a.`name` LIKE '%$paramer[keyword]%'";
$where1[]="a.`uname` LIKE '%$paramer[keyword]%'";
//搜索工作经历
$workList = $db->select_all('resume_work',"`title` LIKE '%$paramer[keyword]%' OR `content` LIKE '%$paramer[keyword]%' ORDER BY id DESC limit 500","`eid`");
if(!empty($workList)){
$workId = array();
foreach($workList as $value){
$workId[] = $value['eid'];
}
$where1[] = "a.id IN (".implode(',',$workId).")";
}
$where.=" AND (".@implode(" or ",$where1).")";
}
//薪资待遇
if($paramer[minsalary]&&$paramer[maxsalary]){
$where.= " AND ((a.`minsalary`<=".intval($paramer[minsalary])." and a.`maxsalary`>=".intval($paramer[minsalary]).")
or (a.`minsalary`<=".intval($paramer[maxsalary])." and a.`maxsalary`>=".intval($paramer[maxsalary])."))";
}elseif($paramer[minsalary]&&!$paramer[maxsalary]){
$where.= " AND ((a.`minsalary`<=".intval($paramer[minsalary])." and a.`maxsalary`>=".intval($paramer[minsalary]).")
or (a.`minsalary`>=".intval($paramer[minsalary])." and a.`maxsalary`>=".intval($paramer[minsalary]).")
or (a.`minsalary`!=0 and a.`maxsalary`=0))";
}elseif(!$paramer[minsalary]&&$paramer[maxsalary]){
$where.= " AND ((a.`minsalary`<=".intval($paramer[maxsalary])." and a.`maxsalary`>=".intval($paramer[maxsalary]).")
or (a.`minsalary`<=".intval($paramer[maxsalary])." and a.`maxsalary`<=".intval($paramer[maxsalary]).")
or (a.`minsalary`<=".intval($paramer[maxsalary])." and a.`maxsalary`=0)
or (a.`minsalary`=0 and a.`maxsalary`!=0)
)";
}
//年龄
if($paramer[minage]&&$paramer[maxage]){
$mintime=date("Y-m-d",strtotime("-".$paramer[minage]." year"));
$maxtime=date("Y-m-d",strtotime("-".$paramer[maxage]." year"));
$where.= " AND a.`birthday`>= '".$maxtime."' and a.`birthday`<='".$mintime."'";
}elseif($paramer[minage]&&!$paramer[maxage]){
$mintime=date("Y-m-d",strtotime("-".$paramer[minage]." year"));
$where.= " AND a.`birthday`<='".$mintime."'";
}elseif(!$paramer[minage]&&$paramer[maxage]){
$maxtime=date("Y-m-d",strtotime("-".$paramer[maxage]." year"));
$where.= " AND a.`birthday`>='".$maxtime."'";
}
//排序字段默认为更新时间
if($paramer[order] && $paramer[order]!="lastdate"){
if($paramer[order]=='topdate'){
$nowtime=time();
$order = " ORDER BY if(a.`topdate`>$nowtime,a.`topdate`,a.`lastupdate`) ";
}else{
$order = " ORDER BY a.`".$paramer[order]."` ";
}
}else{
$order = " ORDER BY a.`lastupdate` ";
}
//排序规则 默认为倒序
$sort = $paramer[sort]?$paramer[sort]:"DESC";
//查询条数
if($paramer[limit]){
$limit=" LIMIT ".$paramer[limit];
}
//自定义查询条件，默认取代上面任何参数直接使用该语句
if($paramer[where]){
$where = $paramer[where];
}
$pagewhere = "";$joinwhere = "";
if($cjwhere){
$pagewhere.=" ,`".$db_config[def]."resume_city_job_class` cj ";
$joinwhere .= " a.`id`=cj.`eid` " . $cjwhere;
}
if($paramer[ispage]){
// 查询分页
if($paramer["height_status"]){
$limit = PageNav($paramer,$_GET,"resume_expect",$where,$Purl,"",$paramer[islt]?$paramer[islt]:"3",$_smarty_tpl,$pagewhere,$joinwhere);
}else{
$limit = PageNav($paramer,$_GET,"resume_expect",$where,$Purl,"","0",$_smarty_tpl,$pagewhere,$joinwhere);
}
}
if($paramer[topdate] && $_GET[page]>1){
$ulist = array();
}else{
$select="a.`id`,a.`uid`,a.`name`,a.`hy`,a.`job_classid`,a.`city_classid`,a.`jobstatus`,a.`type`,a.`report`,a.`lastupdate`,a.`rec`,a.`top`,a.`topdate`,a.`rec_resume`,a.`ctime`,a.`uname`,a.`idcard_status`,a.`minsalary`,a.`maxsalary`";
if($pagewhere!=""){
$sql = "select ".$select." from `".$db_config[def]."resume_expect` a ".$pagewhere." where ".$joinwhere." and ".$where.$order.$sort.$limit;
$ulist=$db->DB_query_all($sql,"all");
}else{
$sql = "select ".$select." from `".$db_config[def]."resume_expect` a where ".$where.$order.$sort.$limit;
$ulist=$db->DB_query_all($sql,"all");
}
}
if(!empty($ulist) && is_array($ulist)){
//如果存在top，则说明请求来自排行榜页面
if($paramer['top']){
$uids=$m_name=array();
foreach($ulist as $k=>$v){
$uids[]=$v[uid];
}
$member=$db->select_all($db_config[def]."member","`uid` in(".@implode(',',$uids).")","uid,username");
foreach($member as $val){
$m_name[$val[uid]]=$val['username'];
}
}
$uid = $eid = array();
foreach($ulist as $key=>$value){
$uid[] = $value['uid'];
$eid[] = $value['id'];
}
$eids = @implode(',',$eid);
$uids = @implode(',',$uid);
$resume=$db->select_all("resume","`uid` in(".$uids.")","uid,name,nametype,tag,sex,moblie_status,edu,exp,defphoto,photo,phototype,photo_status,birthday");
foreach($resume as $v){
$ruids[] = $v['uid'];
}
foreach($ulist as $k=>$v){
if(!in_array($v['uid'],$ruids)){
unset($ulist[$k]);
continue;
}
}
if($paramer[topdate]){
$noids=array();
}
if($paramer[workexp] == 1){
$eduList = $db -> select_all("resume_edu","`eid` in(".$eids.")");
if(!empty($eduList)){
foreach($eduList as $key=>$value){
$eduListNew[$value['eid']][] = $value;
}
foreach($eduListNew as $k=>$eduv){
$edumin = 0;
$edumax = 0;
$edutitle = array();
$education = array();
foreach($eduv as $v){
if($v['sdate']>0 && $edumin==0){
$edumin = $v['sdate'];
}elseif($edumin>$v['sdate']){
$edumin = $v['sdate'];
}
if($v['edate']==0 ){
$edumax = 0;
}elseif($edumax<$v['edate']){
$edumax = $v['edate'];
}
$education[] = $userclass_name[$v['education']];
$edutitle[] = $v['specialty'];
}
$return =array();
$return['edumin'] = date('Y-m',$edumin);
$return['edumax'] = $edumax == 0 ? '至今': date('Y',$edumax);
$return['education'] = @implode(',',$education);
$return['eduspecialty'] = @implode('、',$edutitle);
$return['edu_time'] = $return['edumin']."-".$return['edumax'];
if($return['eduspecialty']){
$workexpList[$k]['edu_content'] = $return['education'].'学历 ▪ '.$return['eduspecialty'].' ▪ 毕业于'.$return['edumax'].'年';
}else{
$workexpList[$k]['edu_content'] = $return['education'].'学历 ▪ 毕业于'.$return['edumax'].'年';
}
}
}
$workList = $db -> select_all("resume_work","`eid` in(".$eids.")");
if(!empty($workList)){
foreach($workList as $key=>$value){
$workListNew[$value['eid']][] = $value;
}
foreach($workListNew as $k=>$workv){
$whour = 0;
$hour = array();
$time = time();
$workmin = 0;
$workmax = 0;
$worknum = count($workv);
$wtitle = array();
foreach($workv as $v){
/* 计算每份工作时长(按月) */
if($v['sdate']>0 && $workmin==0){
$workmin = $v['sdate'];
}elseif($workmin>$v['sdate']){
$workmin = $v['sdate'];
}
if($v['edate']==0 ){
$workmax = 0;
}elseif($workmax<$v['edate']){
$workmax = $v['edate'];
}
$wtitle[] = $v['title'];
$hour[] = $workTime;
$whour += $workTime;
}
$workavg = ceil($whour/count($hour));
$return = array();
$return['worknum'] = $worknum > 0 ? $worknum:0;
$return['workavg'] = $workavg > 0 ? $workavg:0;
$return['workmin'] = date('Y-m',$workmin);
$return['workmax'] = $workmax == 0 ? '至今': date('Y-m',$workmax);
$return['worktit'] = @implode(',',$wtitle);
$return['work_time'] = $return['workmin'].'-'.$return['workmax'];
if($return['worktit']!=''){
$workexpList[$k]['work_content'] = ' 参加过'.$return['worknum'].'份工作 ▪ 涉及'.$return['worktit'].'等岗位';
}else{
$workexpList[$k]['work_content'] = ' 参加过'.$return['worknum'].'份工作';
}
}
}
}
foreach($ulist as $k=>$v){
if($paramer[topdate]){
$noids[] = $v[id];
}
//筛除重复
if($paramer[noid]=='1' && !empty($noids) && in_array($v['id'],$noids)){
unset($ulist[$k]);
continue;
}
foreach($resume as $val){
if($v['uid']==$val['uid']){
$ulist[$k]['edu_n']=$userclass_name[$val['edu']];
$ulist[$k]['exp_n']=$userclass_name[$val['exp']];
if($val['birthday']){
$year = date("Y",strtotime($val['birthday']));
$ulist[$k]['age'] =date("Y")-$year;
}
if($val['sex']==152){
$val['sex']='1';
}elseif ($val['sex']==153){
$val['sex']='2';
}
$ulist[$k]['sex'] =$arr_data[sex][$val['sex']];
$ulist[$k]['phototype']=$val[phototype];
$photo=$icon="";
if($val['defphoto']==2){
$photo=$val['photo'];
}else{
if($config['user_pic']==1 || empty($config['user_pic'])){
if($val['photo'] && $val['photo_status']==0 && $val['phototype']!=1){
$photo=$val['photo'];
}else{
if($val['sex']==1){
$icon=$config['sy_member_icon'];
}else{
$icon=$config['sy_member_iconv'];
}
}
}elseif($config['user_pic']==2){
if($val['photo']&& $val['photo_status']==0){
$photo=$val['photo'];
}else{
if($val['sex']==1){
$icon=$config['sy_member_icon'];
}else{
$icon=$config['sy_member_iconv'];
}
}
}elseif($config['user_pic']==3){
if($val['sex']==1){
$icon=$config['sy_member_icon'];
}else{
$icon=$config['sy_member_iconv'];
}
}
}
$ulist[$k]['photo']=checkpic($photo,$icon);
if($val['tag']){
$ulist[$k]['tag']=explode(',',$val['tag']);
}
$ulist[$k]['nametype']=$val[nametype];
$ulist[$k]['moblie_status']=$val[moblie_status];
//名称显示处理
if($config['user_name']==1 || !$config['user_name']){
if($val['nametype']==3){
if($val['sex']==1){
$ulist[$k]['username_n'] = mb_substr($val['name'],0,1,'utf-8')."先生";
}else{
$ulist[$k]['username_n'] = mb_substr($val['name'],0,1,'utf-8')."女士";
}
}elseif($val['nametype']==2){
$ulist[$k]['username_n'] = "NO.".$v['id'];
}else{
$ulist[$k]['username_n'] = $val['name'];
}
}elseif($config['user_name']==3){
if($val['sex']==1){
$ulist[$k]['username_n'] = mb_substr($val['name'],0,1,'utf-8')."先生";
}else{
$ulist[$k]['username_n'] = mb_substr($val['name'],0,1,'utf-8')."女士";
}
}elseif($config['user_name']==2){
$ulist[$k]['username_n'] = "NO.".$v['id'];
}elseif($config['user_name']==4){
$ulist[$k]['username_n'] = $val['name'];
}
}
}
//更新时间显示方式
$time=$v['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){
$ulist[$k]['time'] = "昨天";
}elseif($time>$beginToday){
$ulist[$k]['time'] = lastupdateStyle($v['lastupdate']);
$ulist[$k]['redtime'] =1;
}else{
$ulist[$k]['time'] = date("Y-m-d",$v['lastupdate']);
}
// 前天
$beforeYesterday=mktime(0,0,0,date('m'),date('d')-2,date('Y'));
if($v['ctime']>$beforeYesterday){
$ulist[$k]['newtime'] =1;
}
$ulist[$k]['user_jobstatus_n']=$userclass_name[$v['jobstatus']];
// $ulist[$k]['job_city_one']=$city_name[$v['provinceid']];
// $ulist[$k]['job_city_two']=$city_name[$v['cityid']];
// $ulist[$k]['job_city_three']=$city_name[$v['three_cityid']];
if($v['minsalary']&&$v['maxsalary']){
if($config['resume_salarytype']==1){
$ulist[$k]["salary_n"] = $v['minsalary']."-".$v['maxsalary'];
}else{
if($v[maxsalary]<1000){
if($config['resume_salarytype']==2){
$ulist[$k]["salary_n"] = "1千以下";
}elseif($config['resume_salarytype']==3){
$ulist[$k]["salary_n"] = "1K以下";
}elseif($config['resume_salarytype']==4){
$ulist[$k]["salary_n"] = "1k以下";
}
}else{
$ulist[$k]["salary_n"] = changeSalary($v['minsalary'])."-".changeSalary($v['maxsalary']);
}
}
}else if($v['minsalary']){
if($config['resume_salarytype']==1){
$ulist[$k]["salary_n"] = $v['minsalary'];
}else{
$ulist[$k]["salary_n"] = changeSalary($v['minsalary']);
}
}else{
$ulist[$k]["salary_n"] = "面议";
}
$ulist[$k]['report_n']=$userclass_name[$v['report']];
$ulist[$k]['type_n']=$userclass_name[$v['type']];
$ulist[$k]['lastupdate']=date("Y-m-d",$v['lastupdate']);
$ulist[$k]['user_url']=Url("resume",array("c"=>"show","id"=>$v['id']),"1");
$ulist[$k]["hy_info"]=$industry_name[$v['hy']];
if($paramer['top']){
$ulist[$k]['m_name']=$m_name[$v['uid']];
$ulist[$k]['user_url']=Url("ask",array("c"=>"friend","a"=>"myquestion","uid"=>$v['uid']));
}
$ulist[$k]['work_content']=$workexpList[$v['id']]['work_content'];
$ulist[$k]['edu_content']=$workexpList[$v['id']]['edu_content'];
$kjob_classid=@explode(",",$v['job_classid']);
$kjob_classid=array_unique($kjob_classid);
$jobname=array();
if(is_array($kjob_classid)){
foreach($kjob_classid as $val){
if($val!=''){
if($paramer['keyword']){
$jobname[]=str_replace($paramer['keyword'],"".$paramer['keyword']."",$job_name[$val]);
}else{
$jobname[]=$job_name[$val];
}
}
}
}
//$ulist[$k]['job_post']=@implode(",",$jobname);
$ulist[$k]['expectjob']=$jobname;
$kcity_classid=@explode(",",$v['city_classid']);
$kcity_classid=array_unique($kcity_classid);
$cityname=array();
if(is_array($kcity_classid)){
foreach($kcity_classid as $val){
if($val!=''){
$cityname[]=$city_name[$val];
}
}
}
//$ulist[$k]['citylist']=@implode("/",$cityname);
$ulist[$k]['expectcity']=$cityname;
//截取标题
if($paramer['post_len']){
$postname[$k]=@implode(",",$jobname);
$ulist[$k]['job_post_n']=mb_substr($postname[$k],0,$paramer[post_len],"utf-8");
}
if($paramer['city_len']){
$scityname[$k]=@implode("/",$cityname);
$ulist[$k]['city_name_n']=mb_substr($scityname[$k],0,$paramer[city_len],"utf-8");
}
}
foreach($ulist as $k=>$v){
if($paramer['keyword']){
$ulist[$k]['username_n']=str_replace($paramer['keyword'],"".$paramer['keyword']."",$v['username_n']);
$ulist[$k]['job_post']=str_replace($paramer['keyword'],"".$paramer['keyword']."",$ulist[$k]['job_post']);
$ulist[$k]['job_post_n']=str_replace($paramer['keyword'],"".$paramer['keyword']."",$ulist[$k]['job_post_n']);
$ulist[$k]['city_name_n']=str_replace($paramer['keyword'],"".$paramer['keyword']."",$ulist[$k]['city_name_n']);
}
}
if($paramer['keyword']!=""&&!empty($ulist)){
addkeywords('5',$paramer['keyword']);
}
}$ulist = $ulist; if (!is_array($ulist) && !is_object($ulist)) { settype($ulist, 'array');}
foreach ($ulist as $_smarty_tpl->tpl_vars['ulist']->key => $_smarty_tpl->tpl_vars['ulist']->value) {
$_smarty_tpl->tpl_vars['ulist']->_loop = true;
$_smarty_tpl->tpl_vars['key']->value = $_smarty_tpl->tpl_vars['ulist']->key;
?>
-
tpl_vars['ulist']->value['sex'];?> |tpl_vars['ulist']->value['age'];?> 岁|tpl_vars['ulist']->value['exp_n'];?> 经验|tpl_vars['ulist']->value['edu_n'];?> 学历意向：tpl_vars['ulist']->value['job_post_n'];?>
您关心的职场头条
tpl_vars['plist'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['plist']->_loop = false;
$_smarty_tpl->tpl_vars['key'] = new Smarty_Variable;
global $db,$db_config,$config;
include PLUS_PATH.'/group.cache.php';$plist= array();
$rs = null;
$nids = null;
$paramer = array("item"=>"'plist'","type"=>"'t'","pic"=>"1","urlstatic"=>"1","t_len"=>"20","limit"=>"2","key"=>"'key'","name"=>"'newlistpic'","nocache"=>"")
;
$ParamerArr = GetSmarty($paramer,$_GET,$_smarty_tpl);
$paramer = $ParamerArr['arr'];
$Purl = $ParamerArr['purl'];
if($paramer[cache]){
$Purl = "{{page}}.html";
}
global $ModuleName;
if(!$Purl["m"]){
$Purl["m"]=$ModuleName;
}
$where=1;
$where .=" and (`starttime`<=".time()." or `starttime`=0 or `starttime` is null)";
$where .=" and (`endtime`>".time()." or `endtime`=0 or `endtime` is null)";
if($config['did']){
$where .= " and (`did`='".$config['did']."' or `did`=-1)";
}else{
$where .= " and (`did`=-1 OR `did`=0 OR did='')";
}
include PLUS_PATH."/group.cache.php";
if($paramer['nid']){
$nid_s = @explode(',',$paramer[nid]);
foreach($nid_s as $v){
if($group_type[$v]){
$paramer[nid] = $paramer[nid].",".@implode(',',$group_type[$v]);
}
}
}
if($paramer['nid']!="" && $paramer['nid']!=0){
$where .=" AND `nid` in ($paramer[nid])";
$nids = @explode(',',$paramer['nid']);
$paramer['nid']=$paramer['nid'];
}else if($paramer['rec']!=""){
$nids=array();
if(is_array($group_rec)){
foreach($group_rec as $key=>$value){
if($key<=2){
$nids[]=$value;
}
}
$paramer[nid]=@implode(',',$nids);
}
}
if($paramer['type']){
$type = str_replace("\"","",$paramer[type]);
$type_arr = @explode(",",$type);
if(is_array($type_arr) && !empty($type_arr)){
foreach($type_arr as $key=>$value){
$where .=" AND FIND_IN_SET('".$value."',`describe`)";
if(count($nids)>0){
$picwhere .=" AND FIND_IN_SET('".$value."',`describe`)";
}
}
}
}
//拼接补充SQL条件
if($paramer['pic']!=""){
$where .=" AND `newsphoto`<>''";
}
//新闻搜索
if($paramer['keyword']!=""){
$where .=" AND `title` LIKE '%".$paramer[keyword]."%'";
}
//拼接查询条数
if(intval($paramer['limit'])>0){
$limit = intval($paramer['limit']);
$limit = " limit ".$limit;
}
if($paramer['ispage']){
if($Purl["m"]=="wap"){
$limit = PageNav($paramer,$_GET,"news_base",$where,$Purl,"","6",$_smarty_tpl);
}else{
$limit = PageNav($paramer,$_GET,"news_base",$where,$Purl,"","5",$_smarty_tpl);
}
}
//拼接字段排序
if($paramer['order']!=""){
$where .=" ORDER BY $paramer[order]";
}else{
$where .=" ORDER BY `starttime`";
}
//排序方式默认倒序
if($paramer['sort']){
$where.=" ".$paramer[sort];
}else{
$where.=" DESC";
}
//多类别新闻查找
if(!intval($paramer['ispage']) && count($nids)>0){
$nidArr = @explode(',',$paramer[nid]);
$rsnids = array();
if(is_array($group_type)){
foreach($group_type as $key=>$value){
if(in_array($key,$nidArr)){
if(is_array($value)){
foreach($value as $v){
$rsnids[$v] = $key;
$nidArr[] = $v;
}
}
}
}
}
$where = " `nid` IN (".@implode(',',$nidArr).")";
if($config['did']){
$where.=" and `did`='".$config['did']."'";
}
//查询带图新闻
if($paramer['pic']){
if(!$paramer['piclimit']){
$piclimit = 1;
}else{
$piclimit = $paramer['piclimit'];
}
$db->query("set @f=0,@n=0");
$query = $db->query("select * from (select id,title,color,datetime,starttime,description,newsphoto,@n:=if(@f=nid,@n:=@n+1,1) as aid,@f:=nid as nid from $db_config[def]news_base WHERE ".$where." AND `newsphoto` <>'' order by nid asc,starttime desc) a where aid <=".$piclimit);
$conque = $db->select_all("news_content","1 order by nbid desc".$limit);
foreach($conque as $cv){
$newcon[$cv[nbid]]=$cv;
}
while($rs = $db->fetch_array($query)){
if($rsnids[$rs['nid']]){
$rs['nid'] = $rsnids[$rs['nid']];
}
//处理标题长度
if(intval($paramer[t_len])>0){
$len = intval($paramer[t_len]);
$rs[title_n] = $rs[title];
$rs[title] = mb_substr($rs[title],0,$len,"utf-8");
}
if($rs[color]){
$rs[title] = "".$rs[title]."";
}
//处理描述内容长度
if(intval($paramer[d_len])>0){
$len = intval($paramer[d_len]);
$rs[description] = mb_substr($rs[description],0,$len,"utf-8");
}
$rs['name'] = $group_name[$rs['nid']];
//构建资讯静态链接
if($config[sy_news_rewrite]=="2"){
$rs["url"]=$config['sy_weburl']."/news/".date("Ymd",$rs["datetime"])."/".$rs[id].".html";
}else{
$rs["url"] = Url("article",array("c"=>"show","id"=>$rs[id]),"1");
}
if(mb_substr($rs[newsphoto],0,4)=="http"){
$rs["picurl"]=$rs[newsphoto];
}else{
if($rs['newsphoto']==""){
$content=str_replace(array('"',"'"),array("",""),$newcon[$rs[id]]["content"]);
preg_match_all("/]+src=(.*?)\s[^>]+>/im",$content,$res);
$str=str_replace("\\","",$res[1][0]);
if($str){
$rs[newsphoto]=".".$str;
}
}
$nopic=$config[sy_weburl]."/app/template/".$config[style]."/images/nopic.gif";
$rs["picurl"] = checkpic($rs['newsphoto'],$nopic);
}
$rs[time]=date("Y-m-d",$rs[starttime]);
$rs['starttime']=date("m-d",$rs[starttime]);
if(count($plist[$rs['nid']]['pic'])<$piclimit){
$plist[$rs['nid']]['pic'][] = $rs;
}
}//end while
}
$db->query("set @f=0,@n=0");
$query = $db->query("select * from (select id,title,datetime,starttime,color,description,newsphoto,@n:=if(@f=nid,@n:=@n+1,1) as aid,@f:=nid as nid from $db_config[def]news_base WHERE ".$where." order by nid asc,starttime desc) a where aid <=$paramer[limit]");
while($rs = $db->fetch_array($query)){
if($rsnids[$rs['nid']]){
$rs['nid'] = $rsnids[$rs['nid']];
}
//处理标题长度
if(intval($paramer[t_len])>0){
$len = intval($paramer[t_len]);
$rs[title_n] = $rs[title];
$rs[title] = mb_substr($rs[title],0,$len,"utf-8");
}
if($rs[color]){
$rs[title] = "".$rs[title]."";
}
//处理描述内容长度
if(intval($paramer[d_len])>0){
$len = intval($paramer[d_len]);
$rs[description] = mb_substr($rs[description],0,$len,"utf-8");
}
//获取所属类别名称
$rs['name'] = $group_name[$rs['nid']];
//构建资讯静态链接
if($config[sy_news_rewrite]=="2"){
$rs["url"]=$config['sy_weburl']."/news/".date("Ymd",$rs["datetime"])."/".$rs[id].".html";
}else{
$rs["url"] = Url("article",array("c"=>"show","id"=>$rs[id]),"1");
}
if(mb_substr($rs[newsphoto],0,4)=="http"){
$rs["picurl"]=$rs[newsphoto];
}else{
if($rs['newsphoto']==""){
$rs["picurl"] = $config[sy_weburl]."/app/template/".$config[style]."/images/nopic.gif";
}else{
$rs["picurl"] = checkpic($rs['newsphoto']);
}
}
$rs[time]=date("Y-m-d",$rs[starttime]);
$rs[starttime]=date("m-d",$rs[starttime]);
if(count($plist[$rs['nid']]['arclist'])<$paramer[limit]){
$plist[$rs['nid']]['arclist'][] = $rs;
}
}//end while
}//end if(!intval($paramer['ispage']) && count($nids)>0)
else{
$query = $db->query("SELECT * FROM `$db_config[def]news_base` WHERE ".$where.$limit);
while($rs = $db->fetch_array($query)){
//处理标题长度
if(intval($paramer[t_len])>0){
$len = intval($paramer[t_len]);
$rs[title_n] = $rs[title];
$rs[title] = mb_substr($rs[title],0,$len,"utf-8");
}
if($rs[color]){
$rs[title] = "".$rs[title]."";
}
//处理描述内容长度
if(intval($paramer[d_len])>0){
$len = intval($paramer[d_len]);
$rs[description] = mb_substr($rs[description],0,$len,"utf-8");
}
//获取所属类别名称
$rs['name'] = $group_name[$rs['nid']];
//构建资讯静态链接
if($config[sy_news_rewrite]=="2"){
$rs["url"]=$config['sy_weburl']."/news/".date("Ymd",$rs["datetime"])."/".$rs[id].".html";
}else{
$rs["url"] = Url("article",array("c"=>"show","id"=>$rs[id]),"1");
}
if(mb_substr($rs[newsphoto],0,4)=="http"){
$rs["picurl"]=$rs[newsphoto];
}else{
if($rs['newsphoto']==""){
$rs["picurl"] = $config[sy_weburl]."/app/template/".$config[style]."/images/nopic.gif";
}else{
$rs["picurl"] = checkpic($rs['newsphoto']);
}
}
$rs[time]=date("Y-m-d",$rs[starttime]);
$rs[starttime]=date("m-d",$rs[starttime]);
$plist[] = $rs;
}//end while
}$plist = $plist; if (!is_array($plist) && !is_object($plist)) { settype($plist, 'array');}
foreach ($plist as $_smarty_tpl->tpl_vars['plist']->key => $_smarty_tpl->tpl_vars['plist']->value) {
$_smarty_tpl->tpl_vars['plist']->_loop = true;
$_smarty_tpl->tpl_vars['key']->value = $_smarty_tpl->tpl_vars['plist']->key;
?>
value;?>
/images/lay-loding.png' lay-src="tpl_vars['plist']->value['picurl'];?>
" width="190" height="120" alt="tpl_vars['plist']->value['title_n'];?>
">
tpl_vars['plist']->value['name'];?>
tpl_vars['plist']->value['time'];?>
-
tpl_vars['nlist'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['nlist']->_loop = false;
$_smarty_tpl->tpl_vars['key'] = new Smarty_Variable;
global $db,$db_config,$config;
include PLUS_PATH.'/group.cache.php';$nlist= array();
$rs = null;
$nids = null;
$paramer = array("item"=>"'nlist'","t_len"=>"20","limit"=>"14","key"=>"'key'","name"=>"'newlist'","nocache"=>"")
;
$ParamerArr = GetSmarty($paramer,$_GET,$_smarty_tpl);
$paramer = $ParamerArr['arr'];
$Purl = $ParamerArr['purl'];
if($paramer[cache]){
$Purl = "{{page}}.html";
}
global $ModuleName;
if(!$Purl["m"]){
$Purl["m"]=$ModuleName;
}
$where=1;
$where .=" and (`starttime`<=".time()." or `starttime`=0 or `starttime` is null)";
$where .=" and (`endtime`>".time()." or `endtime`=0 or `endtime` is null)";
if($config['did']){
$where .= " and (`did`='".$config['did']."' or `did`=-1)";
}else{
$where .= " and (`did`=-1 OR `did`=0 OR did='')";
}
include PLUS_PATH."/group.cache.php";
if($paramer['nid']){
$nid_s = @explode(',',$paramer[nid]);
foreach($nid_s as $v){
if($group_type[$v]){
$paramer[nid] = $paramer[nid].",".@implode(',',$group_type[$v]);
}
}
}
if($paramer['nid']!="" && $paramer['nid']!=0){
$where .=" AND `nid` in ($paramer[nid])";
$nids = @explode(',',$paramer['nid']);
$paramer['nid']=$paramer['nid'];
}else if($paramer['rec']!=""){
$nids=array();
if(is_array($group_rec)){
foreach($group_rec as $key=>$value){
if($key<=2){
$nids[]=$value;
}
}
$paramer[nid]=@implode(',',$nids);
}
}
if($paramer['type']){
$type = str_replace("\"","",$paramer[type]);
$type_arr = @explode(",",$type);
if(is_array($type_arr) && !empty($type_arr)){
foreach($type_arr as $key=>$value){
$where .=" AND FIND_IN_SET('".$value."',`describe`)";
if(count($nids)>0){
$picwhere .=" AND FIND_IN_SET('".$value."',`describe`)";
}
}
}
}
//拼接补充SQL条件
if($paramer['pic']!=""){
$where .=" AND `newsphoto`<>''";
}
//新闻搜索
if($paramer['keyword']!=""){
$where .=" AND `title` LIKE '%".$paramer[keyword]."%'";
}
//拼接查询条数
if(intval($paramer['limit'])>0){
$limit = intval($paramer['limit']);
$limit = " limit ".$limit;
}
if($paramer['ispage']){
if($Purl["m"]=="wap"){
$limit = PageNav($paramer,$_GET,"news_base",$where,$Purl,"","6",$_smarty_tpl);
}else{
$limit = PageNav($paramer,$_GET,"news_base",$where,$Purl,"","5",$_smarty_tpl);
}
}
//拼接字段排序
if($paramer['order']!=""){
$where .=" ORDER BY $paramer[order]";
}else{
$where .=" ORDER BY `starttime`";
}
//排序方式默认倒序
if($paramer['sort']){
$where.=" ".$paramer[sort];
}else{
$where.=" DESC";
}
//多类别新闻查找
if(!intval($paramer['ispage']) && count($nids)>0){
$nidArr = @explode(',',$paramer[nid]);
$rsnids = array();
if(is_array($group_type)){
foreach($group_type as $key=>$value){
if(in_array($key,$nidArr)){
if(is_array($value)){
foreach($value as $v){
$rsnids[$v] = $key;
$nidArr[] = $v;
}
}
}
}
}
$where = " `nid` IN (".@implode(',',$nidArr).")";
if($config['did']){
$where.=" and `did`='".$config['did']."'";
}
//查询带图新闻
if($paramer['pic']){
if(!$paramer['piclimit']){
$piclimit = 1;
}else{
$piclimit = $paramer['piclimit'];
}
$db->query("set @f=0,@n=0");
$query = $db->query("select * from (select id,title,color,datetime,starttime,description,newsphoto,@n:=if(@f=nid,@n:=@n+1,1) as aid,@f:=nid as nid from $db_config[def]news_base WHERE ".$where." AND `newsphoto` <>'' order by nid asc,starttime desc) a where aid <=".$piclimit);
$conque = $db->select_all("news_content","1 order by nbid desc".$limit);
foreach($conque as $cv){
$newcon[$cv[nbid]]=$cv;
}
while($rs = $db->fetch_array($query)){
if($rsnids[$rs['nid']]){
$rs['nid'] = $rsnids[$rs['nid']];
}
//处理标题长度
if(intval($paramer[t_len])>0){
$len = intval($paramer[t_len]);
$rs[title_n] = $rs[title];
$rs[title] = mb_substr($rs[title],0,$len,"utf-8");
}
if($rs[color]){
$rs[title] = "".$rs[title]."";
}
//处理描述内容长度
if(intval($paramer[d_len])>0){
$len = intval($paramer[d_len]);
$rs[description] = mb_substr($rs[description],0,$len,"utf-8");
}
$rs['name'] = $group_name[$rs['nid']];
//构建资讯静态链接
if($config[sy_news_rewrite]=="2"){
$rs["url"]=$config['sy_weburl']."/news/".date("Ymd",$rs["datetime"])."/".$rs[id].".html";
}else{
$rs["url"] = Url("article",array("c"=>"show","id"=>$rs[id]),"1");
}
if(mb_substr($rs[newsphoto],0,4)=="http"){
$rs["picurl"]=$rs[newsphoto];
}else{
if($rs['newsphoto']==""){
$content=str_replace(array('"',"'"),array("",""),$newcon[$rs[id]]["content"]);
preg_match_all("/
- tpl_vars['nlist']->value['title'];?> tpl_vars['nlist']->value['time'];?>
-
tpl_vars['alist'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['alist']->_loop = false;
$_smarty_tpl->tpl_vars['key'] = new Smarty_Variable;
global $db,$db_config,$config;
include PLUS_PATH.'/group.cache.php';$alist= array();
$rs = null;
$nids = null;
$paramer = array("item"=>"'alist'","t_len"=>"15","type"=>"'indextj'","limit"=>"10","key"=>"'key'","name"=>"'newlisthot'","nocache"=>"")
;
$ParamerArr = GetSmarty($paramer,$_GET,$_smarty_tpl);
$paramer = $ParamerArr['arr'];
$Purl = $ParamerArr['purl'];
if($paramer[cache]){
$Purl = "{{page}}.html";
}
global $ModuleName;
if(!$Purl["m"]){
$Purl["m"]=$ModuleName;
}
$where=1;
$where .=" and (`starttime`<=".time()." or `starttime`=0 or `starttime` is null)";
$where .=" and (`endtime`>".time()." or `endtime`=0 or `endtime` is null)";
if($config['did']){
$where .= " and (`did`='".$config['did']."' or `did`=-1)";
}else{
$where .= " and (`did`=-1 OR `did`=0 OR did='')";
}
include PLUS_PATH."/group.cache.php";
if($paramer['nid']){
$nid_s = @explode(',',$paramer[nid]);
foreach($nid_s as $v){
if($group_type[$v]){
$paramer[nid] = $paramer[nid].",".@implode(',',$group_type[$v]);
}
}
}
if($paramer['nid']!="" && $paramer['nid']!=0){
$where .=" AND `nid` in ($paramer[nid])";
$nids = @explode(',',$paramer['nid']);
$paramer['nid']=$paramer['nid'];
}else if($paramer['rec']!=""){
$nids=array();
if(is_array($group_rec)){
foreach($group_rec as $key=>$value){
if($key<=2){
$nids[]=$value;
}
}
$paramer[nid]=@implode(',',$nids);
}
}
if($paramer['type']){
$type = str_replace("\"","",$paramer[type]);
$type_arr = @explode(",",$type);
if(is_array($type_arr) && !empty($type_arr)){
foreach($type_arr as $key=>$value){
$where .=" AND FIND_IN_SET('".$value."',`describe`)";
if(count($nids)>0){
$picwhere .=" AND FIND_IN_SET('".$value."',`describe`)";
}
}
}
}
//拼接补充SQL条件
if($paramer['pic']!=""){
$where .=" AND `newsphoto`<>''";
}
//新闻搜索
if($paramer['keyword']!=""){
$where .=" AND `title` LIKE '%".$paramer[keyword]."%'";
}
//拼接查询条数
if(intval($paramer['limit'])>0){
$limit = intval($paramer['limit']);
$limit = " limit ".$limit;
}
if($paramer['ispage']){
if($Purl["m"]=="wap"){
$limit = PageNav($paramer,$_GET,"news_base",$where,$Purl,"","6",$_smarty_tpl);
}else{
$limit = PageNav($paramer,$_GET,"news_base",$where,$Purl,"","5",$_smarty_tpl);
}
}
//拼接字段排序
if($paramer['order']!=""){
$where .=" ORDER BY $paramer[order]";
}else{
$where .=" ORDER BY `starttime`";
}
//排序方式默认倒序
if($paramer['sort']){
$where.=" ".$paramer[sort];
}else{
$where.=" DESC";
}
//多类别新闻查找
if(!intval($paramer['ispage']) && count($nids)>0){
$nidArr = @explode(',',$paramer[nid]);
$rsnids = array();
if(is_array($group_type)){
foreach($group_type as $key=>$value){
if(in_array($key,$nidArr)){
if(is_array($value)){
foreach($value as $v){
$rsnids[$v] = $key;
$nidArr[] = $v;
}
}
}
}
}
$where = " `nid` IN (".@implode(',',$nidArr).")";
if($config['did']){
$where.=" and `did`='".$config['did']."'";
}
//查询带图新闻
if($paramer['pic']){
if(!$paramer['piclimit']){
$piclimit = 1;
}else{
$piclimit = $paramer['piclimit'];
}
$db->query("set @f=0,@n=0");
$query = $db->query("select * from (select id,title,color,datetime,starttime,description,newsphoto,@n:=if(@f=nid,@n:=@n+1,1) as aid,@f:=nid as nid from $db_config[def]news_base WHERE ".$where." AND `newsphoto` <>'' order by nid asc,starttime desc) a where aid <=".$piclimit);
$conque = $db->select_all("news_content","1 order by nbid desc".$limit);
foreach($conque as $cv){
$newcon[$cv[nbid]]=$cv;
}
while($rs = $db->fetch_array($query)){
if($rsnids[$rs['nid']]){
$rs['nid'] = $rsnids[$rs['nid']];
}
//处理标题长度
if(intval($paramer[t_len])>0){
$len = intval($paramer[t_len]);
$rs[title_n] = $rs[title];
$rs[title] = mb_substr($rs[title],0,$len,"utf-8");
}
if($rs[color]){
$rs[title] = "".$rs[title]."";
}
//处理描述内容长度
if(intval($paramer[d_len])>0){
$len = intval($paramer[d_len]);
$rs[description] = mb_substr($rs[description],0,$len,"utf-8");
}
$rs['name'] = $group_name[$rs['nid']];
//构建资讯静态链接
if($config[sy_news_rewrite]=="2"){
$rs["url"]=$config['sy_weburl']."/news/".date("Ymd",$rs["datetime"])."/".$rs[id].".html";
}else{
$rs["url"] = Url("article",array("c"=>"show","id"=>$rs[id]),"1");
}
if(mb_substr($rs[newsphoto],0,4)=="http"){
$rs["picurl"]=$rs[newsphoto];
}else{
if($rs['newsphoto']==""){
$content=str_replace(array('"',"'"),array("",""),$newcon[$rs[id]]["content"]);
preg_match_all("/
- tpl_vars['key']->value+1;?> tpl_vars['alist']->value['title'];?>
tpl_vars['linklist'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['linklist']->_loop = false;
global $config;
//跨域名使用范围
$domain='';
if($config["cityid"]!="" || $config["hyclass"]!=""){
include(PLUS_PATH."/domain_cache.php");
$host_url=$_SERVER['HTTP_HOST'];
foreach($site_domain as $v){
if($v['host']==$host_url){
$domain=$v['id'];
}
}
}$tem_type = 2;
include PLUS_PATH."/link.cache.php";
if(is_array($link)){$linkList=array();
$i=0;
foreach($link as $key=>$value)
{
if($config["did"]!=0 && $value["did"]!=-1 && $config["did"]!=-1 && $config["did"]!=$value["did"])
{
continue;
}elseif(is_numeric('2') && $value['tem_type']!='2' && $value['tem_type']!='1'){
continue;
}elseif((!is_numeric('2') || '2'=='1') && $value['tem_type']!='1'){
continue;
}elseif(!$config["did"] && $value["did"]>0){
continue;
}
if(is_numeric('2') && $value['link_type']!='2')
{
continue;
}
if(is_numeric('') && intval('')<=$i)
{
break;
}
if($value['pic']&&$value['img_type']==1){
$value[pic] = checkpic($value['pic']);
}
$linkList[] = $value;
$i++;
}
}$linkList = $linkList; if (!is_array($linkList) && !is_object($linkList)) { settype($linkList, 'array');}
foreach ($linkList as $_smarty_tpl->tpl_vars['linklist']->key => $_smarty_tpl->tpl_vars['linklist']->value) {
$_smarty_tpl->tpl_vars['linklist']->_loop = true;
?>
value;?>
/images/lay-loding.png' lay-src="tpl_vars['linklist']->value['pic'];?>
" alt="tpl_vars['linklist']->value['link_name'];?>
" width="160" height="50"/>
tpl_vars['linklist2'] = new Smarty_Variable; $_smarty_tpl->tpl_vars['linklist2']->_loop = false;
global $config;
//跨域名使用范围
$domain='';
if($config["cityid"]!="" || $config["hyclass"]!=""){
include(PLUS_PATH."/domain_cache.php");
$host_url=$_SERVER['HTTP_HOST'];
foreach($site_domain as $v){
if($v['host']==$host_url){
$domain=$v['id'];
}
}
}$tem_type = 2;
include PLUS_PATH."/link.cache.php";
if(is_array($link)){$linkList=array();
$i=0;
foreach($link as $key=>$value)
{
if($config["did"]!=0 && $value["did"]!=-1 && $config["did"]!=-1 && $config["did"]!=$value["did"])
{
continue;
}elseif(is_numeric('2') && $value['tem_type']!='2' && $value['tem_type']!='1'){
continue;
}elseif((!is_numeric('2') || '2'=='1') && $value['tem_type']!='1'){
continue;
}elseif(!$config["did"] && $value["did"]>0){
continue;
}
if(is_numeric('1') && $value['link_type']!='1')
{
continue;
}
if(is_numeric('') && intval('')<=$i)
{
break;
}
if($value['pic']&&$value['img_type']==1){
$value[pic] = checkpic($value['pic']);
}
$linkList[] = $value;
$i++;
}
}$linkList = $linkList; if (!is_array($linkList) && !is_object($linkList)) { settype($linkList, 'array');}
foreach ($linkList as $_smarty_tpl->tpl_vars['linklist2']->key => $_smarty_tpl->tpl_vars['linklist2']->value) {
$_smarty_tpl->tpl_vars['linklist2']->_loop = true;
?>
tpl_vars['linklist2']->value['link_name'];?>