www.gusucode.com > 74cms PHP骑士人才系统 v3.5.1源码程序 > code/upload/plus/ajax_common.php
<?php /* * 74cms ajax * ============================================================================ * 版权所有: 骑士网络,并保留所有权利。 * 网站地址: http://www.74cms.com; * ---------------------------------------------------------------------------- * 这不是一个自由软件!您只能在不用于商业目的的前提下对程序代码进行修改和 * 使用;不允许对程序代码以任何形式任何目的的再发布。 * ============================================================================ */ define('IN_QISHI', true); require_once(dirname(dirname(__FILE__)).'/include/plus.common.inc.php'); $act = !empty($_GET['act']) ? trim($_GET['act']) : ''; if ($act=="countinfo") { if(intval($_GET['subsite_id'])>0){ $wheresql = " where subsite_id=".intval($_GET['subsite_id']); }else{ $wheresql=""; } $total="SELECT COUNT(*) AS num FROM ".table('company_profile'); $total_company=$db->get_total($total); $total="SELECT COUNT(*) AS num FROM ".table('jobs').$wheresql; $total_jobs=$db->get_total($total); $total="SELECT COUNT(*) AS num FROM ".table('resume').$wheresql; $total_resume=$db->get_total($total); $total="SELECT COUNT(*) AS num FROM ".table('members'); $total_members=$db->get_total($total); $contents = "企业总数:<span>{$total_company}</span> 有效职位:<span>{$total_jobs}</span> 有效简历:<span>{$total_resume}</span> 会员总数:<span>{$total_members}</span>"; $contents = ereg_replace("\t","",$contents); $contents = ereg_replace("\r\n","",$contents); $contents = ereg_replace("\r","",$contents); $contents = ereg_replace("\n","",$contents); exit($contents); } elseif ($act=="company_down_resume") { $wheresql = ""; if ($_CFG['subsite']=="1" && $_CFG['subsite_filter_jobs']=="1" && intval($_CFG['subsite_id'])>0) { $wheresql.=" WHERE c.subsite_id=".intval($_CFG['subsite_id']); } $result = $db->query("SELECT a.down_addtime,b.companyname,b.id AS bid,b.addtime AS baddtime,c.id AS cid,c.display_name,c.addtime AS caddtime,c.fullname,c.subsite_id FROM ".table('company_down_resume')." AS a LEFT JOIN ".table('company_profile')." AS b ON a.company_uid=b.uid LEFT JOIN ".table('resume')." AS c ON a.resume_id=c.id".$wheresql." ORDER BY a.down_addtime DESC LIMIT 30"); $html=array(); while($row = $db->fetch_array($result)) { if ($row['companyname'] && $row['fullname'] && empty($html[$row['bid']])) { $row['time']=daterange(time(),$row['down_addtime'],'Y-m-d',"#FF3300"); if ($row['display_name']=="2") { $row['fullname']="N".str_pad($row['cid'],7,"0",STR_PAD_LEFT); } elseif ($row['display_name']=="3") { $row['fullname']=cut_str($row['fullname'],1,0,"**"); } if($_CFG['closetime']==1){ $html[$row['bid']]="<li><a href=".url_rewrite('QS_companyshow',array('id'=>$row['bid']),false)." target=\"_blank\">".$row['companyname']." </a> 下载了 <a href=".url_rewrite('QS_resumeshow',array('id'=>$row['cid']),true,$row['subsite_id'])." target=\"_blank\">".$row['fullname']." </a>的个人简历</li>"; }else{ $html[$row['bid']]="<li><a href=".url_rewrite('QS_companyshow',array('id'=>$row['bid']),false)." target=\"_blank\">".$row['companyname']." </a> 下载了 <a href=".url_rewrite('QS_resumeshow',array('id'=>$row['cid']),true,$row['subsite_id'])." target=\"_blank\">".$row['fullname']." </a>的个人简历<span>{$row['time']}</span></li>"; } } } exit(implode("",$html)); } elseif($act=="hotword") { if (empty($_GET['query'])) { exit(); } $gbk_query=trim($_GET['query']); if (strcasecmp(QISHI_DBCHARSET,"utf8")!=0) { $gbk_query=utf8_to_gbk($gbk_query); } $sql="SELECT * FROM ".table('hotword')." WHERE w_word like '%{$gbk_query}%' ORDER BY `w_hot` DESC LIMIT 0 , 10"; $result = $db->query($sql); while($row = $db->fetch_array($result)) { $list[]="'".$row['w_word']."'"; } if ($list) { $liststr=implode(',',$list); $str="{"; $str.="query:'{$gbk_query}',"; $str.="suggestions:[{$liststr}]"; $str.="}"; exit($str); } } elseif($act=="joblisttip") { $uid=intval($_GET['uid']); $wheresql=''; if ($_CFG['subsite']=="1" && $_CFG['subsite_filter_jobs']=="1" && intval($_CFG['subsite_id'])>0) { $wheresql.=" AND subsite_id=".intval($_CFG['subsite_id'])." "; } $result = $db->query("SELECT * FROM ".table('jobs')." WHERE uid='{$uid}' {$wheresql} ORDER BY refreshtime desc limit 6"); $i=1; while($row = $db->fetch_array($result)) { $row['jobs_name']=cut_str($row['jobs_name'],8,0,""); $row['refreshtime_cn']=daterange(time(),$row['refreshtime'],'Y-m-d',"#FF3300"); if (!empty($row['highlight'])) { $row['jobs_name']="<span style=\"color:{$row['highlight']}\">{$row['jobs_name']}</span>"; } $row['companyname_']=$row['companyname']; $row['companyname']=cut_str($row['companyname'],15,0,"..."); $row['jobs_url']=url_rewrite('QS_jobsshow',array('id'=>$row['id']),true,$row['subsite_id']); $row['company_url']=url_rewrite('QS_companyshow',array('id'=>$row['company_id']),false); if ($i>5) { $html.="<li class=\"more\"><a href=\"{$row['company_url']}\" target=\"_blank\">更多...</span></li>"; break; } if($_CFG['closetime']==1){ $html.="<li><a href=\"{$row['jobs_url']}\" target=\"_blank\">{$row['jobs_name']}</a></li>"; }else{ $html.="<li><a href=\"{$row['jobs_url']}\" target=\"_blank\">{$row['jobs_name']}</a> <span>({$row['refreshtime_cn']})</span></li>"; } $i++; } exit($html); } elseif($act=="ajaxcomlist") { $categoryid=intval($_GET['categoryid']); $tradeid=intval($_GET['tradeid']); $showtype=trim($_GET['showtype']); $limit=intval($_GET['comrow'])>0?intval($_GET['comrow']):10; $jobrow=intval($_GET['jobrow'])>0?intval($_GET['jobrow']):3; $companynamelen=intval($_GET['companynamelen'])>0?intval($_GET['companynamelen']):12; $jobslen=intval($_GET['jobslen'])>0?intval($_GET['jobslen']):6; $jobstable=table('jobs_search_rtime'); $wheresql=''; $ordersql=' ORDER BY refreshtime desc '; $limitsql=" LIMIT ".$limit*15; if ($_CFG['subsite']=='1' && $_CFG['subsite_filter_jobs']=='1' && intval($_CFG['subsite_id'])>0) { $wheresql.=" AND subsite_id=".intval($_CFG['subsite_id'])." "; } if ($showtype=="category") { if ($categoryid>0) { $wheresql.=" AND topclass='{$categoryid}' "; } } elseif($showtype=="trade" && $tradeid>0) { $wheresql.=" AND trade='{$tradeid}' "; } if (!empty($wheresql)) { $wheresql=" WHERE ".ltrim(ltrim($wheresql),'AND'); } $result = $db->query("SELECT id,uid FROM ".$jobstable.$wheresql.$ordersql.$limitsql); $uidarr= array(); while($row = $db->fetch_array($result)) { if (count($uidarr)>=$limit) break; $uidarr[$row['uid']]=$row['uid']; } if (!empty($uidarr)) { $uidarr= implode(",",$uidarr); $wheresql=$wheresql?$wheresql." AND uid IN ({$uidarr}) ":" WHERE uid IN ({$uidarr}) "; $sql="SELECT company_audit,subsite_id,company_id,companyname,company_addtime,refreshtime,id,jobs_name,addtime,uid,click,highlight,highlight,setmeal_id,setmeal_name FROM ".table('jobs').$wheresql.$ordersql; $countuid=array(); $result = $db->query($sql); while($row = $db->fetch_array($result)) { $countuid[$row['uid']][]=$row['uid']; if (count($countuid[$row['uid']])>$jobrow)continue; $companyarray[$row['uid']]['companyname_']=$row['companyname']; $companyarray[$row['uid']]['companyname']=cut_str($row['companyname'],$companynamelen,0,''); $companyarray[$row['uid']]['company_url']=url_rewrite('QS_companyshow',array('id'=>$row['company_id']),false); $companyarray[$row['uid']]['company_addtime']=$row['company_addtime']; $companyarray[$row['uid']]['refreshtime']=$companyarray[$row['uid']]['refreshtime']>$row['refreshtime']?$companyarray[$row['uid']]['refreshtime']:$row['refreshtime']; $companyarray[$row['uid']]['refreshtime_cn']=daterange(time(),$companyarray[$row['uid']]['refreshtime'],'m-d',"#A9A9A9"); $companyarray[$row['uid']]['setmeal_id']=$row['setmeal_id']; $companyarray[$row['uid']]['company_audit']=$row['company_audit']; $companyarray[$row['uid']]['setmeal_name']=$row['setmeal_name']; $companyarray[$row['uid']]['uid']=$row['uid']; $companyarray[$row['uid']]['jobs'][$row['id']]['jobs_addtime']=$row['addtime']; $companyarray[$row['uid']]['jobs'][$row['id']]['jobs_refreshtime']=$row['refreshtime']; $companyarray[$row['uid']]['jobs'][$row['id']]['jobs_click']=$row['click']; $companyarray[$row['uid']]['jobs'][$row['id']]['jobs_name']=cut_str($row['jobs_name'],$jobslen,0,''); if (!empty($row['highlight'])) { $companyarray[$row['uid']]['jobs'][$row['id']]['jobs_name']="<span style=\"color:{$row['highlight']}\">{$companyarray[$row['uid']]['jobs'][$row['id']]['jobs_name']}</span>"; } $companyarray[$row['uid']]['jobs'][$row['id']]['jobs_url']=url_rewrite('QS_jobsshow',array('id'=>$row['id']),true,$row['subsite_id']); } } if (!empty($companyarray)) { $html=''; foreach($companyarray as $li) { if($_CFG['closetime']==1){ $html.="<li><p><a class=\"com_name\" href=\"{$li['company_url']}\" target=\"_blank\"><span class=\"comtip\" id=\"{$li['uid']}\">{$li['companyname']}</span> "; if ($li['company_audit'] == 1) { $html.="<img title=\"企业已认证\" class=\"vtip\" src=\"$_CFG[site_template]images/iconren.jpg\" border=\"0\"> "; } if ($_CFG['operation_mode'] == 2 && $li['setmeal_id'] > 1) { $html.="<img src=\"$_CFG[site_dir]data/setmealimg/{$li['setmeal_id']}.gif\" border=\"0\" title=\"{$li['setmeal_name']}\" class=\"vtip\"/>"; } $html.="</a><span> </span></p>"; }else{ $html.="<li><p><a class=\"com_name\" href=\"{$li['company_url']}\" target=\"_blank\"><span class=\"comtip\" id=\"{$li['uid']}\">{$li['companyname']}</span> "; if ($li['company_audit'] == 1) { $html.="<img title=\"企业已认证\" class=\"vtip\" src=\"$_CFG[site_template]images/iconren.jpg\" border=\"0\"> "; } if ($_CFG['operation_mode'] == 2 && $li['setmeal_id'] > 1) { $html.="<img src=\"$_CFG[site_dir]data/setmealimg/{$li['setmeal_id']}.gif\" border=\"0\" title=\"{$li['setmeal_name']}\" class=\"vtip\"/>"; } $html.="</a><span>{$li['refreshtime_cn']}更新</span></p>"; } if (!empty($li['jobs'])){ $html.="<p>聘:"; foreach($li['jobs'] as $jobsli){ $html.="<a href=\"{$jobsli['jobs_url']}\" target=\"_blank\">{$jobsli['jobs_name']}</a>"; } $html.="</p>"; } } } exit($html); } elseif($act=="ajaxjoblist") { $trade=intval($_GET['trade']); $wheresql=$trade>0?' WHERE trade='.$trade." ":""; if ($_CFG['subsite']=="1" && $_CFG['subsite_filter_jobs']=="1" && intval($_CFG['subsite_id'])>0) { $wheresql .= ($wheresql==""?" WHERE ":" AND ")."subsite_id=".intval($_CFG['subsite_id'])." "; } $result = $db->query("SELECT * FROM ".table('jobs')." {$wheresql} ORDER BY refreshtime desc limit 12"); $i=1; $html = '<ul class="clearfix">'; while($row = $db->fetch_array($result)) { $row['jobs_name']=cut_str($row['jobs_name'],12,0,""); $row['refreshtime_cn']=daterange(time(),$row['refreshtime'],'Y-m-d',"#FF3300"); if (!empty($row['highlight'])) { $row['jobs_name']="<span style=\"color:{$row['highlight']}\">{$row['jobs_name']}</span>"; } $row['companyname_']=$row['companyname']; $row['companyname']=cut_str($row['companyname'],13,0,""); $row['jobs_url']=url_rewrite('QS_jobsshow',array('id'=>$row['id']),true,$row['subsite_id']); $row['company_url']=url_rewrite('QS_companyshow',array('id'=>$row['company_id'])); if($_CFG['closetime']==1){ $html.="<li class=\"clearfix\"><span>.</span><a target=\"_blank\" href=\"{$row['jobs_url']}\">{$row['jobs_name']}</a><b><a target=\"_blank\" href=\"{$row['company_url']}\">{$row['companyname']}</a></b></li>"; }else{ $html.="<li class=\"clearfix\"><span>.</span><a target=\"_blank\" href=\"{$row['jobs_url']}\">{$row['jobs_name']}</a><b><a target=\"_blank\" href=\"{$row['company_url']}\">{$row['companyname']}</a></b><em>{$row['refreshtime_cn']}</em></li>"; } $i++; } $html .= '</div>'; exit($html); } ?>