www.gusucode.com > 74cms 骑士PHP人才系统 V3.4源码程序 > code/upload/admin/include/admin_company_fun.php
<?php
/*
* 74cms 管理中心 企业用户相关函数
* ============================================================================
* 版权所有: 骑士网络，并保留所有权利。
* 网站地址: http://www.74cms.com；
* ----------------------------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
* 使用；不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
*/
if(!defined('IN_QISHI'))
{
die('Access Denied!');
}
//******************************职位部分**********************************
//获取职位信息列表
function get_jobs($offset,$perpage,$get_sql= '')
{
global $db,$timestamp;
$row_arr = array();
$limit=" LIMIT ".$offset.','.$perpage;
$result = $db->query($get_sql.$limit);
while($row = $db->fetch_array($result))
{
$row['jobs_name']=cut_str($row['jobs_name'],12,0,"...");
if (!empty($row['highlight']))
{
$row['jobs_name']="<span style=\"color:{$row['highlight']}\">{$row['jobs_name']}</span>";
}
$row['companyname']=cut_str($row['companyname'],18,0,"...");
$row['company_url']=url_rewrite('QS_companyshow',array('id'=>$row['company_id']));
$row['jobs_url']=url_rewrite('QS_jobsshow',array('id'=>$row['id']));
$row_arr[] = $row;
}
return $row_arr;
}
function distribution_jobs($id)
{
global $db,$_CFG;
if (!is_array($id))$id=array($id);
$time=time();
foreach($id as $v)
{
$v=intval($v);
$t1=$db->getone("select * from ".table('jobs')." where id='{$v}' LIMIT 1");
$t2=$db->getone("select * from ".table('jobs_tmp')." where id='{$v}' LIMIT 1");
if ((empty($t1) && empty($t2)) || (!empty($t1) && !empty($t2)))
{
continue;
}
else
{
$j=!empty($t1)?$t1:$t2;
if (!empty($t1) && $j['audit']=="1" && $j['display']=="1" && $j['user_status']=="1")
{
if ($_CFG['outdated_jobs']=="1")
{
if ($j['deadline']>$time && ($j['setmeal_deadline']=="0" || $j['setmeal_deadline']>$time))
{
continue;
}
}
else
{
continue;
}
}
elseif (!empty($t2))
{
if ($j['audit']!="1" || $j['display']!="1" || $j['user_status']!="1")
{
continue;
}
else
{
if ($_CFG['outdated_jobs']=="1" && ($j['deadline']<$time || ($j['setmeal_deadline']<$time && $j['setmeal_deadline']!="0")))
{
continue;
}
}
}
//检测完毕
$j=array_map('addslashes',$j);
if (!empty($t1))
{
$db->query("Delete from ".table('jobs')." WHERE id='{$v}' LIMIT 1");
$db->query("Delete from ".table('jobs_tmp')." WHERE id='{$v}' LIMIT 1");
if (inserttable(table('jobs_tmp'),$j))
{
$db->query("Delete from ".table('jobs_search_hot')." WHERE id='{$v}' {$uidsql} LIMIT 1");
$db->query("Delete from ".table('jobs_search_key')." WHERE id='{$v}' {$uidsql} LIMIT 1");
$db->query("Delete from ".table('jobs_search_rtime')." WHERE id='{$v}' {$uidsql} LIMIT 1");
$db->query("Delete from ".table('jobs_search_scale')." WHERE id='{$v}' {$uidsql} LIMIT 1");
$db->query("Delete from ".table('jobs_search_stickrtime')." WHERE id='{$v}' {$uidsql} LIMIT 1");
$db->query("Delete from ".table('jobs_search_wage')." WHERE id='{$v}' {$uidsql} LIMIT 1");
$db->query("Delete from ".table('jobs_search_tag')." WHERE id='{$v}' {$uidsql} LIMIT 1");
}
}
else
{
$db->query("Delete from ".table('jobs')." WHERE id='{$v}' LIMIT 1");
$db->query("Delete from ".table('jobs_tmp')." WHERE id='{$v}' LIMIT 1");
if (inserttable(table('jobs'),$j))
{
$searchtab['id']=$j['id'];
$searchtab['uid']=$j['uid'];
$searchtab['subsite_id']=$j['subsite_id'];
$searchtab['recommend']=$j['recommend'];
$searchtab['emergency']=$j['emergency'];
$searchtab['nature']=$j['nature'];
$searchtab['sex']=$j['sex'];
$searchtab['category']=$j['category'];
$searchtab['subclass']=$j['subclass'];
$searchtab['trade']=$j['trade'];
$searchtab['district']=$j['district'];
$searchtab['sdistrict']=$j['sdistrict'];
$searchtab['street']=$j['street'];
$searchtab['officebuilding']=$j['officebuilding'];
$searchtab['education']=$j['education'];
$searchtab['experience']=$j['experience'];
$searchtab['wage']=$j['wage'];
$searchtab['refreshtime']=$j['refreshtime'];
$searchtab['scale']=$j['scale'];
//--
inserttable(table('jobs_search_wage'),$searchtab);
inserttable(table('jobs_search_scale'),$searchtab);
//--
$searchtab['map_x']=$j['map_x'];
$searchtab['map_y']=$j['map_y'];
inserttable(table('jobs_search_rtime'),$searchtab);
unset($searchtab['map_x'],$searchtab['map_y']);
//--
$searchtab['stick']=$j['stick'];
inserttable(table('jobs_search_stickrtime'),$searchtab);
unset($searchtab['stick']);
//--
$searchtab['click']=$j['click'];
inserttable(table('jobs_search_hot'),$searchtab);
unset($searchtab['click']);
//--
$searchtab['key']=$j['key'];
$searchtab['likekey']=$j['jobs_name'].','.$j['companyname'];
$searchtab['map_x']=$j['map_x'];
$searchtab['map_y']=$j['map_y'];
inserttable(table('jobs_search_key'),$searchtab);
unset($searchtab);
$tag=explode('|',$j['tag']);
$tagindex=1;
$tagsql['tag1']=$tagsql['tag2']=$tagsql['tag3']=$tagsql['tag4']=$tagsql['tag5']=0;
if (!empty($tag) && is_array($tag))
{
foreach($tag as $v)
{
$vid=explode(',',$v);
$tagsql['tag'.$tagindex]=intval($vid[0]);
$tagindex++;
}
}
$tagsql['id']=$j['id'];
$tagsql['uid']=$j['uid'];
$tagsql['subsite_id']=$j['subsite_id'];
$tagsql['category']=$j['category'];
$tagsql['subclass']=$j['subclass'];
$tagsql['district']=$j['district'];
$tagsql['sdistrict']=$j['sdistrict'];
inserttable(table('jobs_search_tag'),$tagsql);
}
}
}
}
}
function distribution_jobs_uid($uid)
{
global $db;
$uid=intval($uid);
$result = $db->query("select id from ".table('jobs')." where uid={$uid} UNION ALL select id from ".table('jobs_tmp')." where uid={$uid} ");
while($row = $db->fetch_array($result))
{
$id[] = $row['id'];
}
if (!empty($id))
{
return distribution_jobs($id);
}
}
function get_jobs_one($id)
{
global $db;
$id=intval($id);
$tb1=$db->getone("select * from ".table('jobs')." where id='{$id}' LIMIT 1");
$tb2=$db->getone("select * from ".table('jobs_tmp')." where id='{$id}' LIMIT 1");
$val=!empty($tb1)?$tb1:$tb2;
$val['jobs_url']=url_rewrite('QS_jobsshow',array('id'=>$val['id']));
$val['company_url']=url_rewrite('QS_companyshow',array('id'=>$val['company_id']));
$val['user']=get_user($val['uid']);
$val['contact']=$db->getone("select * from ".table('jobs_contact')." where pid='{$id}' LIMIT 1");
return $val;
}
//删除职位
function del_jobs($id)
{
global $db;
if (!is_array($id))$id=array($id);
$sqlin=implode(",",$id);
$return=0;
if (preg_match("/^(\d{1,10},)*(\d{1,10})$/",$sqlin))
{
if (!$db->query("Delete from ".table('jobs')." WHERE id IN ({$sqlin})")) return false;
$return=$return+$db->affected_rows();
if (!$db->query("Delete from ".table('jobs_tmp')." WHERE id IN ({$sqlin})")) return false;
$return=$return+$db->affected_rows();
if (!$db->query("Delete from ".table('jobs_contact')." WHERE pid IN ({$sqlin}) ")) return false;
if (!$db->query("Delete from ".table('promotion')." WHERE cp_jobid IN ({$sqlin}) ")) return false;
if (!$db->query("Delete from ".table('jobs_search_hot')." WHERE id IN ({$sqlin})")) return false;
if (!$db->query("Delete from ".table('jobs_search_key')." WHERE id IN ({$sqlin})")) return false;
if (!$db->query("Delete from ".table('jobs_search_rtime')." WHERE id IN ({$sqlin})")) return false;
if (!$db->query("Delete from ".table('jobs_search_scale')." WHERE id IN ({$sqlin})")) return false;
if (!$db->query("Delete from ".table('jobs_search_stickrtime')." WHERE id IN ({$sqlin})")) return false;
if (!$db->query("Delete from ".table('jobs_search_wage')." WHERE id IN ({$sqlin})")) return false;
if (!$db->query("Delete from ".table('jobs_search_tag')." WHERE id IN ({$sqlin})")) return false;
return $return;
}
else
{
return false;
}
}
//修改职位审核状态
function edit_jobs_audit($id,$audit,$reason,$pms_notice='1')
{
global $db,$_CFG;
$audit=intval($audit);
$reason=trim($reason);
if (!is_array($id))$id=array($id);
$sqlin=implode(",",$id);
$return=0;
if (preg_match("/^(\d{1,10},)*(\d{1,10})$/",$sqlin))
{
if (!$db->query("update ".table('jobs')." SET audit={$audit} WHERE id IN ({$sqlin})")) return false;
$return=$return+$db->affected_rows();
if (!$db->query("update ".table('jobs_tmp')." SET audit={$audit} WHERE id IN ({$sqlin})")) return false;
$return=$return+$db->affected_rows();
distribution_jobs($id);
//发送站内信
if ($pms_notice=='1')
{
$result = $db->query("SELECT * FROM ".table('jobs')." WHERE id IN ({$sqlin}) UNION ALL SELECT * FROM ".table('jobs_tmp')." WHERE id IN ({$sqlin})");
$reason=$reason==''?'原因：未知':'原因：'.$reason;
while($list = $db->fetch_array($result))
{
$user_info=get_user($list['uid']);
$setsqlarr['message']=$audit=='1'?"您发布的职位：{$list['jobs_name']},成功通过网站管理员审核！":"您发布的职位：{$list['jobs_name']},未通过网站管理员审核,{$reason}";
$setsqlarr['msgtype']=1;
$setsqlarr['msgtouid']=$user_info['uid'];
$setsqlarr['msgtoname']=$user_info['username'];
$setsqlarr['dateline']=time();
$setsqlarr['replytime']=time();
$setsqlarr['new']=1;
inserttable(table('pms'),$setsqlarr);
}
}
//审核未通过增加原因
if($audit=='3'){
foreach($id as $list){
$auditsqlarr['jobs_id']=$list;
$auditsqlarr['reason']=$reason;
$auditsqlarr['addtime']=time();
inserttable(table('audit_reason'),$auditsqlarr);
}
}
//发送邮件
$mailconfig=get_cache('mailconfig');
$sms=get_cache('sms_config');
if ($audit=="1" && $mailconfig['set_jobsallow']=="1")//审核通过
{
$result = $db->query("SELECT * FROM ".table('jobs')." WHERE id IN ({$sqlin}) UNION ALL SELECT * FROM ".table('jobs_tmp')." WHERE id IN ({$sqlin})");
while($list = $db->fetch_array($result))
{
$user_info=get_user($list['uid']);
if ($user_info['email_audit']=="1")
{
dfopen($_CFG['site_domain'].$_CFG['site_dir']."plus/asyn_mail.php?uid=".$list['uid']."&key=".asyn_userkey($list['uid'])."&jobs_name=".$list['jobs_name']."&act=set_jobsallow");
}
}
}
if ($audit=="3" && $mailconfig['set_jobsnotallow']=="1")//审核未通过
{
$result = $db->query("SELECT * FROM ".table('jobs')." WHERE id IN ({$sqlin}) UNION ALL SELECT * FROM ".table('jobs_tmp')." WHERE id IN ({$sqlin}) ");
while($list = $db->fetch_array($result))
{
$user_info=get_user($list['uid']);
if ($user_info['email_audit']=="1")
{
dfopen($_CFG['site_domain'].$_CFG['site_dir']."plus/asyn_mail.php?uid=".$list['uid']."&key=".asyn_userkey($list['uid'])."&jobs_name=".$list['jobs_name']."&act=set_jobsnotallow");
}
}
}
//sms
if ($audit=="1" && $sms['open']=="1" && $sms['set_jobsallow']=="1" )
{
$result = $db->query("SELECT * FROM ".table('jobs')." WHERE id IN ({$sqlin}) UNION ALL SELECT * FROM ".table('jobs_tmp')." WHERE id IN ({$sqlin}) ");
while($list = $db->fetch_array($result))
{
$user_info=get_user($list['uid']);
if ($user_info['mobile_audit']=="1")
{
dfopen($_CFG['site_domain'].$_CFG['site_dir']."plus/asyn_sms.php?uid=".$list['uid']."&key=".asyn_userkey($list['uid'])."&jobs_name=".$list['jobs_name']."&act=set_jobsallow");
}
}
}
//sms
if ($audit=="3" && $sms['open']=="1" && $sms['set_jobsnotallow']=="1" )//认证未通过
{
$result = $db->query("SELECT * FROM ".table('jobs')." WHERE id IN ({$sqlin}) UNION ALL SELECT * FROM ".table('jobs_tmp')." WHERE id IN ({$sqlin}) ");
while($list = $db->fetch_array($result))
{
$user_info=get_user($list['uid']);
if ($user_info['mobile_audit']=="1")
{
dfopen($_CFG['site_domain'].$_CFG['site_dir']."plus/asyn_sms.php?uid=".$list['uid']."&key=".asyn_userkey($list['uid'])."&jobs_name=".$list['jobs_name']."&act=set_jobsnotallow");
}
}
}
//sms
return $return;
}
else
{
return $return;
}
}
function edit_jobs_display($id,$display)
{
global $db;
$display=intval($display);
if (!is_array($id))$id=array($id);
$sqlin=implode(",",$id);
if (preg_match("/^(\d{1,10},)*(\d{1,10})$/",$sqlin))
{
if (!$db->query("update ".table('jobs')." SET display='{$display}' WHERE id IN ({$sqlin})")) return false;
distribution_jobs($id);
return true;
}
return false;
}
function get_user($uid)
{
global $db;
$sql = "select * from ".table('members')." where uid=".intval($uid)." LIMIT 1";
return $db->getone($sql);
}
function refresh_company($uid,$refresjobs=false)
{
global $db;
$return=0;
if (!is_array($uid))$uid=array($uid);
$sqlin=implode(",",$uid);
if (preg_match("/^(\d{1,10},)*(\d{1,10})$/",$sqlin))
{
if (!$db->query("update ".table('company_profile')." SET refreshtime='".time()."' WHERE uid IN ({$sqlin})")) return false;
$return=$return+$db->affected_rows();
if ($refresjobs)
{
if (!$db->query("update ".table('jobs')." SET refreshtime='".time()."' WHERE uid IN ({$sqlin})")) return false;
if (!$db->query("update ".table('jobs_tmp')." SET refreshtime='".time()."' WHERE uid IN ({$sqlin})")) return false;
if (!$db->query("update ".table('jobs_search_hot')." SET refreshtime='{$time}' WHERE uid IN ({$sqlin})")) return false;
if (!$db->query("update ".table('jobs_search_key')." SET refreshtime='{$time}' WHERE uid IN ({$sqlin})")) return false;
if (!$db->query("update ".table('jobs_search_rtime')." SET refreshtime='{$time}' WHERE uid IN ({$sqlin})")) return false;
if (!$db->query("update ".table('jobs_search_scale')." SET refreshtime='{$time}' WHERE uid IN ({$sqlin})")) return false;
if (!$db->query("update ".table('jobs_search_stickrtime')." SET refreshtime='{$time}' WHERE uid IN ({$sqlin})")) return false;
if (!$db->query("update ".table('jobs_search_wage')." SET refreshtime='{$time}' WHERE uid IN ({$sqlin})")) return false;
$return=$return+$db->affected_rows();
}
}
return $return;
}
function refresh_jobs($id)
{
global $db;
$return=0;
if (!is_array($id))$id=array($id);
$sqlin=implode(",",$id);
$time=time();
if (preg_match("/^(\d{1,10},)*(\d{1,10})$/",$sqlin))
{
if (!$db->query("update ".table('jobs')." SET refreshtime='{$time}' WHERE id IN ({$sqlin})")) return false;
$return=$return+$db->affected_rows();
if (!$db->query("update ".table('jobs_tmp')." SET refreshtime='{$time}' WHERE id IN ({$sqlin})")) return false;
$return=$return+$db->affected_rows();
if (!$db->query("update ".table('jobs_search_hot')." SET refreshtime='{$time}' WHERE id IN ({$sqlin})")) return false;
if (!$db->query("update ".table('jobs_search_key')." SET refreshtime='{$time}' WHERE id IN ({$sqlin})")) return false;
if (!$db->query("update ".table('jobs_search_rtime')." SET refreshtime='{$time}' WHERE id IN ({$sqlin})")) return false;
if (!$db->query("update ".table('jobs_search_scale')." SET refreshtime='{$time}' WHERE id IN ({$sqlin})")) return false;
if (!$db->query("update ".table('jobs_search_stickrtime')." SET refreshtime='{$time}' WHERE id IN ({$sqlin})")) return false;
if (!$db->query("update ".table('jobs_search_wage')." SET refreshtime='{$time}' WHERE id IN ({$sqlin})")) return false;
}
return $return;
}
function delay_jobs($id,$days)
{
global $db;
$days=intval($days);
$return=0;
if (empty($days)) return false;
if (!is_array($id))$id=array($id);
$sqlin=implode(",",$id);
$time=time();
if (preg_match("/^(\d{1,10},)*(\d{1,10})$/",$sqlin))
{
$result = $db->query("SELECT id,deadline FROM ".table('jobs')." WHERE id IN ({$sqlin}) UNION ALL SELECT id,deadline FROM ".table('jobs_tmp')." WHERE id IN ({$sqlin})");
while($row = $db->fetch_array($result))
{
if ($row['deadline']>$time)
{
$deadline=strtotime("+{$days} day",$row['deadline']);
}
else
{
$deadline=strtotime("+{$days} day");
}
if (!$db->query("update ".table('jobs')." SET deadline='{$deadline}' WHERE id='{$row['id']}' LIMIT 1")) return false;
$return=$return+$db->affected_rows();
if (!$db->query("update ".table('jobs_tmp')." SET deadline='{$deadline}' WHERE id='{$row['id']}' LIMIT 1")) return false;
$return=$return+$db->affected_rows();
}
}
return $return;
}
function delay_meal($id,$days)
{
global $db;
$days=intval($days);
$return=0;
if (empty($days)) return false;
if (!is_array($id))$id=array($id);
$sqlin=implode(",",$id);
$time=time();
if (preg_match("/^(\d{1,10},)*(\d{1,10})$/",$sqlin))
{
$result = $db->query("SELECT id,uid,endtime FROM ".table('members_setmeal')." WHERE uid IN ({$sqlin})");
while($row = $db->fetch_array($result))
{
if($row['endtime']=="0")
{
continue;
}
else
{
if ($row['endtime']>$time)
{
$deadline=strtotime("{$days} day",$row['endtime']);
}
else
{
$deadline=strtotime("{$days} day");
}
if (!$db->query("update ".table('members_setmeal')." SET endtime='{$deadline}' WHERE id='{$row['id']}' LIMIT 1")) return false;
$return=$return+$db->affected_rows();
if (!$db->query("update ".table('jobs')." SET setmeal_deadline='{$deadline}' WHERE uid='{$row['uid']}' LIMIT 1")) return false;
if (!$db->query("update ".table('jobs_tmp')." SET setmeal_deadline='{$deadline}' WHERE uid='{$row['uid']}' LIMIT 1")) return false;
}
}
}
return $return;
}
//******************************企业部分**********************************
//获取企业列表
function get_company($offset,$perpage,$get_sql= '',$mode=1)
{
global $db;
$colum=$mode==1?'p.points':'p.setmeal_name';
$row_arr = array();
$limit=" LIMIT ".$offset.','.$perpage;
$result = $db->query("SELECT c.*,m.username,m.mobile,m.email as memail,{$colum} FROM ".table('company_profile')." AS c ".$get_sql.$limit);
while($row = $db->fetch_array($result))
{
$row['company_url']=url_rewrite('QS_companyshow',array('id'=>$row['id']));
$row_arr[] = $row;
}
return $row_arr;
}
//获取单条企业资料
function get_company_one_id($id)
{
global $db;
$id=intval($id);
$sql = "select * from ".table('company_profile')." where id='{$id}'";
$val=$db->getone($sql);
$val['user']=get_user($val['uid']);
return $val;
}
function get_company_one_uid($uid)
{
global $db;
$uid=intval($uid);
$sql = "select * from ".table('company_profile')." where uid={$uid}";
$val=$db->getone($sql);
return $val;
}
//更改企业认证状态
function edit_company_audit($uid,$audit,$reason,$pms_notice)
{
global $db,$_CFG;
$audit=intval($audit);
$pms_notice=intval($pms_notice);
$reason=trim($reason);
if (!is_array($uid)) $uid=array($uid);
$sqlin=implode(",",$uid);
if (preg_match("/^(\d{1,10},)*(\d{1,10})$/",$sqlin))
{
if (!$db->query("update ".table('company_profile')." SET audit='{$audit}' WHERE uid IN ({$sqlin})")) return false;
if (!$db->query("update ".table('jobs')." SET company_audit='{$audit}' WHERE uid IN ({$sqlin})")) return false;
if (!$db->query("update ".table('jobs_tmp')." SET company_audit='{$audit}' WHERE uid IN ({$sqlin})")) return false;
//发送站内信
if ($pms_notice=='1')
{
$reasonpm=$reason==''?'无':$reason;
if($audit=='1') {$note='成功通过网站管理员审核!';}elseif($audit=='2'){$note='正在审核中!';}else{$note='未通过网站管理员审核！';}
$result = $db->query("SELECT companyname,uid FROM ".table('company_profile')." WHERE uid IN ({$sqlin})");
while($list = $db->fetch_array($result))
{
$user_info=get_user($list['uid']);
$setsqlarr['message']="您的公司：{$list['companyname']},".$note.'其他说明：'.$reasonpm;
$setsqlarr['msgtype']=1;
$setsqlarr['msgtouid']=$user_info['uid'];
$setsqlarr['msgtoname']=$user_info['username'];
$setsqlarr['dateline']=time();
$setsqlarr['replytime']=time();
$setsqlarr['new']=1;
inserttable(table('pms'),$setsqlarr);
}
}
//审核未通过增加原因
if($audit=='3'){
$reasona=$reason==''?'原因：无':'原因：'.$reason;
foreach($uid as $list){
$auditsqlarr['company_id']=$list;
$auditsqlarr['reason']=$reasona;
$auditsqlarr['addtime']=time();
inserttable(table('audit_reason'),$auditsqlarr);
}
}
if ($audit=='1')
{
//3.4升级修改注意,只有积分模式奖励积分
if($_CFG['operation_mode']=='1'){
$points_rule=get_cache('points_rule');
if ($points_rule['company_auth']['value']>0)//如果设置了认证赠送积分
{
gift_points($sqlin,'companyauth',$points_rule['company_auth']['type'],$points_rule['company_auth']['value']);
}
}
//删除执照
$result = $db->query("SELECT * FROM ".table('company_profile')." WHERE uid IN ({$sqlin})");
while($list = $db->fetch_array($result))
{
@unlink("../data/".$_CFG['updir_certificate']."/".$list['certificate_img']);
}
$db->query("update ".table('company_profile')." SET certificate_img='' WHERE uid IN ({$sqlin})");
}
$mailconfig=get_cache('mailconfig');
$sms=get_cache('sms_config');
if ($audit=="1" && $mailconfig['set_licenseallow']=="1")//认证通过
{
$result = $db->query("SELECT * FROM ".table('company_profile')." WHERE uid IN ({$sqlin})");
while($list = $db->fetch_array($result))
{
$user_info=get_user($list['uid']);
if ($user_info['email_audit']=="1")
{
dfopen($_CFG['site_domain'].$_CFG['site_dir']."plus/asyn_mail.php?uid={$list['uid']}&key=".asyn_userkey($list['uid'])."&act=set_licenseallow");
}
}
}
if ($audit=="3" && $mailconfig['set_licensenotallow']=="1")//认证未通过
{
$result = $db->query("SELECT * FROM ".table('company_profile')." WHERE uid IN ({$sqlin})");
while($list = $db->fetch_array($result))
{
$user_info=get_user($list['uid']);
if ($user_info['email_audit']=="1")
{
dfopen($_CFG['site_domain'].$_CFG['site_dir']."plus/asyn_mail.php?uid={$list['uid']}&key=".asyn_userkey($list['uid'])."&act=set_licensenotallow");
}
}
}
//sms
if ($audit=="1" && $sms['open']=="1" && $sms['set_licenseallow']=="1" )
{
$result = $db->query("SELECT * FROM ".table('company_profile')." WHERE uid IN ({$sqlin})");
while($list = $db->fetch_array($result))
{
$user_info=get_user($list['uid']);
if ($user_info['mobile_audit']=="1")
{
dfopen($_CFG['site_domain'].$_CFG['site_dir']."plus/asyn_sms.php?uid={$list['uid']}&key=".asyn_userkey($list['uid'])."&act=set_licenseallow");
}
}
}
//sms
if ($audit=="3" && $sms['open']=="1" && $sms['set_licensenotallow']=="1" )//认证未通过
{
$result = $db->query("SELECT * FROM ".table('company_profile')." WHERE uid IN ({$sqlin})");
while($list = $db->fetch_array($result))
{
$user_info=get_user($list['uid']);
if ($user_info['mobile_audit']=="1")
{
dfopen($_CFG['site_domain'].$_CFG['site_dir']."plus/asyn_sms.php?uid={$list['uid']}&key=".asyn_userkey($list['uid'])."&act=set_licensenotallow");
}
}
}
//sms
distribution_jobs_uid($uid);
return true;
}
return false;
}
//删除企业资料，uid=array
function del_company($uid)
{
global $db,$certificate_dir;
if (!is_array($uid))$uid=array($uid);
$sqlin=implode(",",$uid);
if (preg_match("/^(\d{1,10},)*(\d{1,10})$/",$sqlin))
{
$result = $db->query("SELECT certificate_img FROM ".table('company_profile')." WHERE uid IN ({$sqlin})");
while($row = $db->fetch_array($result))
{
@unlink($certificate_dir.$row['certificate_img']);
}
if (!$db->query("Delete from ".table('company_profile')." WHERE uid IN ({$sqlin})")) return false;
return true;
}
return false;
}
function del_company_alljobs($uid)
{
global $db;
if (!is_array($uid))$uid=array($uid);
$sqlin=implode(",",$uid);
if (preg_match("/^(\d{1,10},)*(\d{1,10})$/",$sqlin))
{
$result = $db->query("SELECT id FROM ".table('jobs')." WHERE uid IN ({$sqlin}) UNION ALL SELECT id FROM ".table('jobs_tmp')." WHERE uid IN ({$sqlin}) ");
while($row = $db->fetch_array($result))
{
$db->query("Delete from ".table('jobs_contact')." WHERE pid IN ({$row['id']})");
}
$db->query("Delete from ".table('jobs')." WHERE uid IN ({$sqlin})");
$db->query("Delete from ".table('jobs_tmp')." WHERE uid IN ({$sqlin})");
$db->query("Delete from ".table('jobs_search_hot')." WHERE uid IN ({$sqlin})");
$db->query("Delete from ".table('jobs_search_key')." WHERE uid IN ({$sqlin})");
$db->query("Delete from ".table('jobs_search_rtime')." WHERE uid IN ({$sqlin})");
$db->query("Delete from ".table('jobs_search_scale')." WHERE uid IN ({$sqlin})");
$db->query("Delete from ".table('jobs_search_stickrtime')." WHERE uid IN ({$sqlin})");
$db->query("Delete from ".table('jobs_search_wage')." WHERE uid IN ({$sqlin})");
$db->query("Delete from ".table('jobs_search_tag')." WHERE uid IN ({$sqlin})");
return true;
}
return false;
}
//******************************订单管理**********************************
//订单列表
function get_order_list($offset,$perpage,$get_sql= '')
{
global $db;
$row_arr = array();
$limit=" LIMIT ".$offset.','.$perpage;
$result = $db->query("SELECT o.*,m.username,m.email,c.companyname FROM ".table('order')." as o ".$get_sql.$limit);
while($row = $db->fetch_array($result))
{
$row['payment_name']=get_payment_info($row['payment_name'],true);
$row_arr[] = $row;
}
return $row_arr;
}
//获取订单
function get_order_one($id=0)
{
global $db;
$sql = "select * from ".table('order')." where id=".intval($id)." LIMIT 1";
$val=$db->getone($sql);
$val['payment_name']=get_payment_info($val['payment_name'],true);
$val['payment_username']=get_user($val['uid']);
return $val;
}
//取消订单
function del_order($id)
{
global $db;
if (!is_array($id))$id=array($id);
$sqlin=implode(",",$id);
if (preg_match("/^(\d{1,10},)*(\d{1,10})$/",$sqlin))
{
if (!$db->query("Delete from ".table('order')." WHERE id IN (".$sqlin.") AND is_paid=1 ")) return false;
return true;
}
return false;
}
//获取充值支付方式名称
function get_payment_info($typename,$name=false)
{
global $db;
$sql = "select * from ".table('payment')." where typename ='".$typename."'";
$val=$db->getone($sql);
if ($name)
{
return $val['byname'];
}
else
{
return $val;
}
}
function get_meal_members_list($offset,$perpage,$get_sql= '')
{
global $db;
$row_arr = array();
$limit=" LIMIT ".$offset.','.$perpage;
$result = $db->query("SELECT a.*,b.*,c.companyname FROM ".table('members_setmeal')." as a ".$get_sql.$limit);
while($row = $db->fetch_array($result))
{
$row_arr[] = $row;
}
return $row_arr;
}
//获取会员的套餐变更记录
function get_meal_members_log($offset,$perpage,$get_sql= '',$mode='1')
{
global $db;
$colum=$mode==1?'b.points':'b.setmeal_name';
$row_arr = array();
$limit=" LIMIT ".$offset.','.$perpage;
$result = $db->query("SELECT a.*,{$colum},c.companyname FROM ".table('members_charge_log')." as a ".$get_sql.$limit);
while($row = $db->fetch_array($result))
{
$row['log_value_']=$row['log_value'];
$row['log_value']=cut_str($row['log_value'],20 ,0,"...");
$row_arr[] = $row;
}
return $row_arr;
}
//删除企业会员套餐变更记录
function del_meal_log($id)
{
global $db;
if (!is_array($id)) $id=array($id);
$sqlin=implode(",",$id);
if (!preg_match("/^(\d{1,10},)*(\d{1,10})$/",$sqlin)) return false;
if (!$db->query("Delete from ".table('members_charge_log')." WHERE log_id IN ({$sqlin})")) return false;
return $db->affected_rows();
}
function get_member_list($offset,$perpage,$get_sql= '')
{
global $db;
$row_arr = array();
$limit=" LIMIT ".$offset.','.$perpage;
$result = $db->query("SELECT m.*,c.companyname,c.id,c.addtime FROM ".table('members')." as m ".$get_sql.$limit);
while($row = $db->fetch_array($result))
{
$row['company_url']=url_rewrite('QS_companyshow',array('id'=>$row['id']));
$row_arr[] = $row;
}
return $row_arr;
}
function delete_company_user($uid)
{
global $db;
if (!is_array($uid))$uid=array($uid);
$sqlin=implode(",",$uid);
if (preg_match("/^(\d{1,10},)*(\d{1,10})$/",$sqlin))
{
if (!$db->query("Delete from ".table('members')." WHERE uid IN (".$sqlin.")")) return false;
if (!$db->query("Delete from ".table('members_info')." WHERE uid IN (".$sqlin.")")) return false;
if (!$db->query("Delete from ".table('members_log')." WHERE log_uid IN (".$sqlin.")")) return false;
if (!$db->query("Delete from ".table('members_points')." WHERE uid IN (".$sqlin.")")) return false;
if (!$db->query("Delete from ".table('order')." WHERE uid IN (".$sqlin.")")) return false;
if (!$db->query("Delete from ".table('members_setmeal')." WHERE uid IN (".$sqlin.")")) return false;
return true;
}
return false;
}
//******************************其他**********************************
//获取会员信息，返回用户名等相关信息
function get_user_points($uid)
{
global $db;
$sql = "select * from ".table('members_points')." where uid = ".intval($uid)." LIMIT 1 ";
$points=$db->getone($sql);
return $points['points'];
}
//获取积分规则
function get_points_rule()
{
global $db;
$sql = "select * from ".table('members_points_rule')." WHERE utype='1' order BY id asc";
$list=$db->getall($sql);
return $list;
}
//-------------------------------------------------------
//付款后开通
function order_paid($v_oid)
{
global $db,$timestamp,$_CFG;
$order=$db->getone("select * from ".table('order')." WHERE oid ='{$v_oid}' AND is_paid= '1' LIMIT 1 ");
if ($order)
{
$user=get_user($order['uid']);
$sql = "UPDATE ".table('order')." SET is_paid= '2',payment_time='{$timestamp}' WHERE oid='{$v_oid}' LIMIT 1 ";
if (!$db->query($sql)) return false;
if($order['amount']=='0.00'){
$ismoney=1;
}else{
$ismoney=2;
}
if ($order['points']>0)
{
report_deal($order['uid'],1,$order['points']);
$user_points=get_user_points($order['uid']);
$notes="操作人：{$_SESSION['admin_name']},说明：确认收款。收款金额：{$order['amount']} 。".date('Y-m-d H:i',time())."通过：".get_payment_info($order['payment_name'],true)." 成功充值 ".$order['amount']."元，(+{$order['points']})，(剩余:{$user_points}),订单:{$v_oid}";
write_memberslog($order['uid'],1,9001,$user['username'],$notes);
//会员套餐变更记录。管理员后台设置会员订单购买成功。4表示：管理员后台开通
write_setmeallog($order['uid'],$user['username'],$notes,4,$order['amount'],$ismoney,1,1);
}
if ($order['setmeal']>0)
{
set_members_setmeal($order['uid'],$order['setmeal']);
$setmeal=get_setmeal_one($order['setmeal']);
$notes="操作人：{$_SESSION['admin_name']},说明：确认收款，收款金额：{$order['amount']} 。".date('Y-m-d H:i',time())."通过：".get_payment_info($order['payment_name'],true)." 成功充值 ".$order['amount']."元并开通{$setmeal['setmeal_name']}";
write_memberslog($order['uid'],1,9002,$user['username'],$notes);
//会员套餐变更记录。管理员后台设置会员订单购买成功。4表示：管理员后台开通
write_setmeallog($order['uid'],$user['username'],$notes,4,$order['amount'],$ismoney,2,1);
}
//发送邮件
$mailconfig=get_cache('mailconfig');
if ($mailconfig['set_payment']=="1" && $user['email_audit']=="1")
{
dfopen($_CFG['site_domain'].$_CFG['site_dir']."plus/asyn_mail.php?uid=".$order['uid']."&key=".asyn_userkey($order['uid'])."&act=set_payment");
}
//发送邮件完毕
//sms
$sms=get_cache('sms_config');
if ($sms['open']=="1" && $sms['set_payment']=="1" && $user['mobile_audit']=="1")
{
dfopen($_CFG['site_domain'].$_CFG['site_dir']."plus/asyn_sms.php?uid=".$order['uid']."&key=".asyn_userkey($order['uid'])."&act=set_payment");
}
//sms
return true;
}
return true;
}
function report_deal($uid,$i_type=1,$points=0)
{
global $db,$timestamp;
$points_val=get_user_points($uid);
if ($i_type==1)
{
$points_val=$points_val+$points;
}
if ($i_type==2)
{
$points_val=$points_val-$points;
$points_val=$points_val<0?0:$points_val;
}
$sql = "UPDATE ".table('members_points')." SET points= '{$points_val}' WHERE uid='{$uid}' LIMIT 1 ";
return $db->query($sql);
}
function gift_points($uid,$gift,$ptype,$points)
{
global $db;
$operator=$ptype=="1"?"+":"-";
$time=time();
if (preg_match("/^(\d{1,10},)*(\d{1,10})$/",$uid))
{
$uid=explode(',',$uid);
}
if (!is_array($uid))$uid=array($uid);
if (!empty($uid) && is_array($uid))
{
foreach($uid as $vuid)
{
$vuid=intval($vuid);
if ($gift=='companyauth')
{
$com=$db->getone("SELECT uid FROM ".table('members_handsel')." WHERE uid ='{$vuid}' AND htype='{$gift}' LIMIT 1");
if(empty($com))
{
report_deal($vuid,$ptype,$points);
$user=get_user($vuid);
$mypoints=get_user_points($vuid);
write_memberslog($vuid,1,9001,$user['username']," 成为已认证企业({$operator}{$points})，(剩余:{$mypoints})");
$db->query("INSERT INTO ".table('members_handsel')." (uid,htype,addtime) VALUES ('{$vuid}', '{$gift}','{$time}')");
}
}
}
}
}
function get_setmeal($apply=true)
{
global $db;
if ($apply==true)
{
$where="";
}
else
{
$where=" WHERE display=1 ";
}
$sql = "select * from ".table('setmeal').$where." order BY display desc,show_order desc,id asc";
return $db->getall($sql);
}
function get_setmeal_one($id)
{
global $db;
$sql = "select * from ".table('setmeal')." WHERE id=".intval($id)."";
return $db->getone($sql);
}
function get_user_setmeal($uid)
{
global $db;
$sql = "select * from ".table('members_setmeal')." WHERE uid=".intval($uid)." AND effective=1 LIMIT 1";
return $db->getone($sql);
}
function del_setmeal_one($id)
{
global $db;
if (!$db->query("Delete from ".table('setmeal')." WHERE id=".intval($id)." ")) return false;
return true;
}
function set_members_setmeal($uid,$setmealid)
{
global $db,$timestamp;
$setmeal=$db->getone("select * from ".table('setmeal')." WHERE id = ".intval($setmealid)." AND display=1 LIMIT 1");
if (empty($setmeal)) return false;
$setsqlarr['effective']=1;
$setsqlarr['setmeal_id']=$setmeal['id'];
$setsqlarr['setmeal_name']=$setmeal['setmeal_name'];
$setsqlarr['days']=$setmeal['days'];
$setsqlarr['starttime']=$timestamp;
if ($setmeal['days']>0)
{
$setsqlarr['endtime']=strtotime("".$setmeal['days']." days");
}
else
{
$setsqlarr['endtime']="0";
}
$setsqlarr['expense']=$setmeal['expense'];
$setsqlarr['jobs_ordinary']=$setmeal['jobs_ordinary'];
$setsqlarr['download_resume_ordinary']=$setmeal['download_resume_ordinary'];
$setsqlarr['download_resume_senior']=$setmeal['download_resume_senior'];
$setsqlarr['interview_ordinary']=$setmeal['interview_ordinary'];
$setsqlarr['interview_senior']=$setmeal['interview_senior'];
$setsqlarr['talent_pool']=$setmeal['talent_pool'];
$setsqlarr['recommend_num']=$setmeal['recommend_num'];
$setsqlarr['recommend_days']=$setmeal['recommend_days'];
$setsqlarr['stick_num']=$setmeal['stick_num'];
$setsqlarr['stick_days']=$setmeal['stick_days'];
$setsqlarr['emergency_num']=$setmeal['emergency_num'];
$setsqlarr['emergency_days']=$setmeal['emergency_days'];
$setsqlarr['highlight_num']=$setmeal['highlight_num'];
$setsqlarr['highlight_days']=$setmeal['highlight_days'];
$setsqlarr['change_templates']=$setmeal['change_templates'];
$setsqlarr['map_open']=$setmeal['map_open'];
$setsqlarr['refresh_jobs_space']=$setmeal['refresh_jobs_space'];
$setsqlarr['refresh_jobs_time']=$setmeal['refresh_jobs_time'];
$setsqlarr['added']=$setmeal['added'];
if (!updatetable(table('members_setmeal'),$setsqlarr," uid=".$uid."")) return false;
$setmeal_jobs['setmeal_deadline']=$setsqlarr['endtime'];
$setmeal_jobs['setmeal_id']=$setsqlarr['setmeal_id'];
$setmeal_jobs['setmeal_name']=$setsqlarr['setmeal_name'];
if (!updatetable(table('jobs'),$setmeal_jobs," uid=".intval($uid)." AND add_mode='2' ")) return false;
if (!updatetable(table('jobs_tmp'),$setmeal_jobs," uid=".intval($uid)." AND add_mode='2' ")) return false;
distribution_jobs_uid($uid);
return true;
}
//企业推广
function get_promotion_cat($available='')
{
global $db;
if ($available<>"")
{
$wheresql=" WHERE cat_available='$available' ";
}
$sql = "select * from ".table('promotion_category')." {$wheresql} order BY cat_order desc";
return $db->getall($sql);
}
function get_promotion_cat_one($id)
{
global $db;
$sql = "select * from ".table('promotion_category')." WHERE cat_id='".intval($id)."' LIMIT 1";
return $db->getone($sql);
}
function get_promotion($offset,$perpage,$get_sql= '')
{
global $db,$timestamp;
$row_arr = array();
$limit=" LIMIT ".$offset.','.$perpage;
$result = $db->query("SELECT p.*,j.jobs_name,j.addtime,j.companyname,j.company_id,j.company_addtime,j.recommend,j.emergency,j.highlight,j.stick,c.cat_name FROM ".table('promotion')." AS p ".$get_sql.$limit);
while($row = $db->fetch_array($result))
{
$row['jobs_name']=cut_str($row['jobs_name'],10,0,"...");
if (!empty($row['highlight']))
{
$row['jobs_name']="<span style=\"color:{$row['highlight']}\">{$row['jobs_name']}</span>";
}
$row['jobs_url']=url_rewrite('QS_jobsshow',array('id'=>$row['cp_jobid']));
$row['companyname']=cut_str($row['companyname'],15,0,"...");
$row['company_url']=url_rewrite('QS_companyshow',array('id'=>$row['company_id']));
$row_arr[] = $row;
}
return $row_arr;
}
function del_promotion($id)
{
global $db;
$n=0;
if (!is_array($id))$id=array($id);
foreach ($id as $did)
{
$info=$db->getone("select p.*,m.username from ".table('promotion')." AS p INNER JOIN ".table('members')." as m ON p.cp_uid=m.uid WHERE p.cp_id='".intval($did)."' LIMIT 1");
write_memberslog($info['cp_uid'],1,3006,$info['username'],"管理员取消推广，职位ID:{$info['cp_jobid']}");
cancel_promotion($info['cp_jobid'],$info['cp_promotionid']);
$db->query("Delete from ".table('promotion')." WHERE cp_id ='".intval($did)."'");
$n+=$db->affected_rows();
}
return $n;
}
function get_promotion_one($id)
{
global $db;
$sql = "select * from ".table('promotion')." WHERE cp_id='".intval($id)."' LIMIT 1";
return $db->getone($sql);
}
function check_promotion($jobid,$promotionid)
{
global $db;
$sql = "select * from ".table('promotion')." WHERE cp_jobid='".intval($jobid)."' AND cp_promotionid='".intval($promotionid)."' LIMIT 1";
return $db->getone($sql);
}
function set_job_promotion($jobid,$promotionid,$val='')
{
global $db;
if ($promotionid=="1")
{
$db->query("UPDATE ".table('jobs')." SET recommend=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_tmp')." SET recommend=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_hot')." SET recommend=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_key')." SET recommend=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_rtime')." SET recommend=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_scale')." SET recommend=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_stickrtime')." SET recommend=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_wage')." SET recommend=1 WHERE id='{$jobid}' LIMIT 1");
return true;
}
elseif ($promotionid=="2")
{
$db->query("UPDATE ".table('jobs')." SET emergency=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_tmp')." SET emergency=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_hot')." SET emergency=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_key')." SET emergency=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_rtime')." SET emergency=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_scale')." SET emergency=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_stickrtime')." SET emergency=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_wage')." SET emergency=1 WHERE id='{$jobid}' LIMIT 1");
return true;
}
elseif ($promotionid=="3")
{
$db->query("UPDATE ".table('jobs')." SET stick=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_tmp')." SET stick=1 WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_stickrtime')." SET stick=1 WHERE id='{$jobid}' LIMIT 1");
return true;
}
elseif ($promotionid=="4")
{
$db->query("UPDATE ".table('jobs')." SET highlight='{$val}' WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_tmp')." SET highlight='{$val}' WHERE id='{$jobid}' LIMIT 1");
return true;
}
}
function cancel_promotion($jobid,$promotionid)
{
global $db;
if($promotionid=="1")
{
$db->query("UPDATE ".table('jobs')." SET recommend='0' WHERE id='{$jobid}' LIMIT 1 ");
$db->query("UPDATE ".table('jobs_tmp')." SET recommend='0' WHERE id='{$jobid}' LIMIT 1 ");
$db->query("UPDATE ".table('jobs_search_hot')." SET recommend='0' WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_key')." SET recommend='0' WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_rtime')." SET recommend='0' WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_scale')." SET recommend='0' WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_stickrtime')." SET recommend='0' WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_wage')." SET recommend='0' WHERE id='{$jobid}' LIMIT 1");
return true;
}
elseif($promotionid=="2")
{
$db->query("UPDATE ".table('jobs')." SET emergency='0' WHERE id='{$jobid}' LIMIT 1 ");
$db->query("UPDATE ".table('jobs_tmp')." SET emergency='0' WHERE id='{$jobid}' LIMIT 1 ");
$db->query("UPDATE ".table('jobs_search_hot')." SET emergency='0' WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_key')." SET emergency='0' WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_rtime')." SET emergency='0' WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_scale')." SET emergency='0' WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_stickrtime')." SET emergency='0' WHERE id='{$jobid}' LIMIT 1");
$db->query("UPDATE ".table('jobs_search_wage')." SET emergency='0' WHERE id='{$jobid}' LIMIT 1");
return true;
}
elseif($promotionid=="3")
{
$db->query("UPDATE ".table('jobs')." SET stick='0' WHERE id='{$jobid}' LIMIT 1 ");
$db->query("UPDATE ".table('jobs_tmp')." SET stick='0' WHERE id='{$jobid}' LIMIT 1 ");
$db->query("UPDATE ".table('jobs_search_stickrtime')." SET stick='0' WHERE id='{$jobid}' LIMIT 1");
return true;
}
elseif($promotionid=="4")
{
$db->query("UPDATE ".table('jobs')." SET highlight='' WHERE id='{$jobid}' LIMIT 1 ");
$db->query("UPDATE ".table('jobs_tmp')." SET highlight='' WHERE id='{$jobid}' LIMIT 1 ");
return true;
}
}
//获取职位的审核日志
function get_jobsaudit_one($jobs_id){
global $db;
$sql = "select * from ".table('audit_reason')." WHERE jobs_id='".intval($jobs_id)."' ORDER BY id DESC";
return $db->getall($sql);
}
function get_comaudit_one($company_id){
global $db;
$uid=$db->getone("select uid from ".table('company_profile')." where id='".intval($company_id)."' limit 1");
$sql = "select * from ".table('audit_reason')." WHERE company_id='".intval($uid['uid'])."' ORDER BY id DESC";
return $db->getall($sql);
}
function reasonaudit_del($id)
{
global $db;
if (!is_array($id)) $id=array($id);
$sqlin=implode(",",$id);
if (!preg_match("/^(\d{1,10},)*(\d{1,10})$/",$sqlin)) return false;
if (!$db->query("Delete from ".table('audit_reason')." WHERE id IN ({$sqlin})")) return false;
return $db->affected_rows();
}
function edit_setmeal_notes($setarr,$setmeal){
$diff_arr= array_diff_assoc($setarr,$setmeal);
if($diff_arr){
foreach($diff_arr as $key=>$value){
if($key=='jobs_ordinary'){
$str.="普通职位：{$setmeal['jobs_ordinary']}-{$setarr['jobs_ordinary']}";
}elseif($key=='download_resume_ordinary'){
$str.=",下载普通人才简历：{$setmeal['download_resume_ordinary']}-{$setarr['download_resume_ordinary']}";
}elseif($key=='download_resume_senior'){
$str.=",下载高级人才简历：{$setmeal['download_resume_senior']}-{$setarr['download_resume_senior']}";
}elseif($key=='interview_ordinary'){
$str.=",邀请普通人才面试数：{$setmeal['interview_ordinary']}-{$setarr['interview_ordinary']}";
}elseif($key=='interview_senior'){
$str.=",邀请高级人才面试数：{$setmeal['interview_senior']}-{$setarr['interview_senior']}";
}
elseif($key=='talent_pool'){
$str.=",人才库容量：{$setmeal['talent_pool']}-{$setarr['talent_pool']}";
}elseif($key=='recommend_num'){
$str.=",允许推荐职位数：{$setmeal['recommend_num']}-{$setarr['recommend_num']}";
}elseif($key=='recommend_days'){
$str.=",推荐职位天数设定：{$setmeal['recommend_days']}-{$setarr['recommend_days']}";
}elseif($key=='stick_num'){
$str.=",允许置顶职位数：{$setmeal['stick_num']}-{$setarr['stick_num']}";
}elseif($key=='stick_days'){
$str.=",置顶天数设定：{$setmeal['stick_days']}-{$setarr['stick_days']}";
}elseif($key=='emergency_num'){
$str.=",允许紧急职位数：{$setmeal['emergency_num']}-{$setarr['emergency_num']}";
}elseif($key=='emergency_days'){
$str.=",紧急职位天数设定：{$setmeal['emergency_days']}-{$setarr['emergency_days']}";
}elseif($key=='highlight_num'){
$str.=",允许套色职位数：{$setmeal['highlight_num']}-{$setarr['highlight_num']}";
}elseif($key=='highlight_days'){
$str.=",套色职位天数设定：{$setmeal['highlight_days']}-{$setarr['highlight_days']}";
}elseif($key=='change_templates'){
$flag=$setmeal['change_templates']=='1'?'允许':'不允许';
$flag1=$setarr['change_templates']=='1'?'允许':'不允许';
$str.=",自由切换模板：{$flag}-{$flag1}";
}elseif($key=='map_open'){
$flag=$setmeal['map_open']=='1'?'允许':'不允许';
$flag1=$setarr['map_open']=='1'?'允许':'不允许';
$str.=",电子地图：{$flag}-{$flag1}";
}elseif($key=='endtime'){
if($setarr['endtime']=='1970-01-01') $setarr['endtime']='无限期';
$str.=",修改套餐到期时间：{$setmeal['endtime']}~{$setarr['endtime']}";
}elseif($key=='log_amount' && $value){
$str.=",收取套餐金额：{$value} 元";
}
}
$strend=$str?"操作人：{$_SESSION['admin_name']}。说明：".$str:'';
return $strend;
}else{
return '';
}
}
?>