www.gusucode.com > 74cms PHP骑士人才系统 v3.5.1源码程序 > 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']),false); $row['jobs_url']=url_rewrite('QS_jobsshow',array('id'=>$row['id'])); $get_resume_nolook = $db->getone("select count(*) from ".table('personal_jobs_apply')." where personal_look=1 and jobs_id=".$row['id']); $get_resume_all = $db->getone("select count(*) from ".table('personal_jobs_apply')." where jobs_id=".$row['id']); $row['get_resume'] = "( ".$get_resume_nolook['count(*)']." / ".$get_resume_all['count(*)']." )"; $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['recommend']=$j['recommend']; $searchtab['emergency']=$j['emergency']; $searchtab['nature']=$j['nature']; $searchtab['sex']=$j['sex']; $searchtab['topclass']=$j['topclass']; $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['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['topclass']=$j['topclass']; $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']),false); $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']),false); $get_resume_nolook = $db->getone("select count(*) from ".table('personal_jobs_apply')." where personal_look=1 and company_id=".$row['id']); $get_resume_all = $db->getone("select count(*) from ".table('personal_jobs_apply')." where company_id=".$row['id']); $row['get_resume'] = "( ".$get_resume_nolook['count(*)']." / ".$get_resume_all['count(*)']." )"; $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升级修改注意,只有积分模式奖励积分 //3.5升级修改注意,积分和混合模式都奖励积分 if($_CFG['operation_mode']=='1' || ($_CFG['operation_mode']=='3' && $_CFG['setmeal_to_points']=='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']); } } } $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']),false); $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(defined('UC_API')) { include_once(QISHI_ROOT_PATH.'uc_client/client.php'); foreach($uid as $tuid) { $userinfo=get_user($tuid); $uc_user=uc_get_user($userinfo['username']); $uc_uid_arr[]=$uc_user[0]; } uc_user_delete($uc_uid_arr); } 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})",1,1013,"认证营业执照","{$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['added']=$setmeal['added']; $setsqlarr['refresh_jobs_space']=$setmeal['refresh_jobs_space']; $setsqlarr['refresh_jobs_time']=$setmeal['refresh_jobs_time']; 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']),false); $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 ''; } } function get_consultant($offset,$perpage,$get_sql= '') { global $db; $row_arr = array(); $limit=" LIMIT ".$offset.','.$perpage; $result = $db->query("SELECT * FROM ".table('consultant').$get_sql.$limit); while($row = $db->fetch_array($result)) { $row_arr[] = $row; } return $row_arr; } function get_consultant_one($id) { global $db; $result = $db->getone("SELECT * FROM ".table('consultant')." where id=".$id); return $result; } function del_consultant($id){ global $db; $db->query("delete from ".table('consultant')." where id=".$id); return true; } function set_user_status($status,$uid) { global $db; $status=intval($status); $uid=intval($uid); if (!$db->query("UPDATE ".table('members')." SET status= {$status} WHERE uid={$uid} LIMIT 1")) return false; if (!$db->query("UPDATE ".table('company_profile')." SET user_status= {$status} WHERE uid={$uid} ")) return false; if (!$db->query("UPDATE ".table('jobs')." SET user_status= {$status} WHERE uid={$uid} ")) return false; if (!$db->query("UPDATE ".table('jobs_tmp')." SET user_status= {$status} WHERE uid={$uid} ")) return false; distribution_jobs_uid($uid); return true; } ?>