www.gusucode.com > 74cms PHP骑士人才系统 v3.5.1源码程序 > code/upload/plus/ajax_simple.php
<?php /* * 74cms ajax 微招聘 * ============================================================================ * 版权所有: 骑士网络,并保留所有权利。 * 网站地址: http://www.74cms.com; * ---------------------------------------------------------------------------- * 这不是一个自由软件!您只能在不用于商业目的的前提下对程序代码进行修改和 * 使用;不允许对程序代码以任何形式任何目的的再发布。 * ============================================================================ */ define('IN_QISHI', true); require_once(dirname(dirname(__FILE__)).'/include/common.inc.php'); $act = !empty($_GET['act']) ? trim($_GET['act']) : 'add'; if ($_PLUG['simple']['p_install']==1) { showmsg('管理员已关闭该模块!',1); } require_once(QISHI_ROOT_PATH.'include/mysql.class.php'); $db = new mysql($dbhost,$dbuser,$dbpass,$dbname); if ($act=="add") { $smarty->cache =true; $smarty->cache_lifetime=60*60*72; $smarty->assign('ip',$online_ip); $captcha=get_cache('captcha'); $smarty->assign('verify_simple',$captcha['verify_simple']); $smarty->display('simple/simple-add.htm'); exit(); } elseif ($act=="addsave") { $captcha=get_cache('captcha'); $postcaptcha = trim($_POST['postcaptcha']); if($captcha['verify_simple']=='1' && empty($postcaptcha)) { showmsg("请填写验证码",1); } if ($captcha['verify_simple']=='1' && strcasecmp($_SESSION['imageCaptcha_content'],$postcaptcha)!=0) { showmsg("验证码错误",1); } $setsqlarr['audit']=intval($_CFG['simple_add_audit']); $setsqlarr['jobname']=trim($_POST['jobname'])?trim($_POST['jobname']):showmsg('您没有填写职位名称!',1); $setsqlarr['amount']=intval($_POST['amount']); $setsqlarr['comname']=trim($_POST['comname'])?trim($_POST['comname']):showmsg('您没有填写单位名称!',1); $setsqlarr['contact']=trim($_POST['contact'])?trim($_POST['contact']):showmsg('您没有填写联系人!',1); $setsqlarr['tel']=trim($_POST['tel'])?trim($_POST['tel']):showmsg('您没有填写联系电话!',1); if(preg_match("/^\d*$/",$setsqlarr['tel'])) { if ($captcha['simple_tel_repeat']=='0') { $sql = "select id from ".table('simple')." where tel = '{$setsqlarr['tel']}' LIMIT 1"; $info=$db->getone($sql); if (!empty($info)) { showmsg('电话号码已经存在!',1); } } } else { showmsg('电话号码格式错误!',1); } $setsqlarr['district']=intval($_POST['district']); $setsqlarr['sdistrict']=intval($_POST['sdistrict']); $setsqlarr['district_cn']=trim($_POST['district_cn']); $setsqlarr['sdistrict_cn']=trim($_POST['sdistrict_cn']); $setsqlarr['detailed']=trim($_POST['detailed']); $setsqlarr['addtime']=time(); $setsqlarr['refreshtime']=time(); $setsqlarr['deadline']=0; $validity=intval($_POST['validity']); if ($validity>0) { $setsqlarr['deadline']=strtotime("{$validity} day"); } $setsqlarr['pwd']=trim($_POST['pwd'])?trim($_POST['pwd']):showmsg('您没有填写管理密码!',1); $setsqlarr['pwd_hash']=substr(md5(uniqid().mt_rand()),mt_rand(0,6),6); $setsqlarr['pwd']=md5(md5($setsqlarr['pwd']).$setsqlarr['pwd_hash'].$QS_pwdhash); $setsqlarr['addip']=$online_ip; require_once(QISHI_ROOT_PATH.'include/splitword.class.php'); $sp = new SPWord(); $setsqlarr['key']=$setsqlarr['jobname'].$setsqlarr['comname'].$setsqlarr['address'].$setsqlarr['detailed']; $setsqlarr['key']="{$setsqlarr['jobname']} {$setsqlarr['comname']} ".$sp->extracttag($setsqlarr['key']); $setsqlarr['key']=$sp->pad($setsqlarr['key']); $link[0]['text'] = "返回微招聘列表"; $link[0]['href'] =url_rewrite('QS_simplelist'); if(inserttable(table('simple'),$setsqlarr)) { if ($setsqlarr['audit']<>1) { $str=",请等待管理员审核"; } showmsg("添加成功{$str}!",2,$link); } else { showmsg("添加失败!",0); } } elseif ($act=="delsimple") { $smarty->cache =false; $smarty->assign('id',intval($_GET['id'])); $smarty->display('simple/simple-del.htm'); exit(); } elseif ($act=="exe_delsimple") { $pwd=$_POST['pwd']; $id=intval($_POST['id']); $sql = "select * from ".table('simple')." where id = '{$id}' LIMIT 1"; $info=$db->getone($sql); $thispwd=md5(md5($pwd).$info['pwd_hash'].$QS_pwdhash); if ($thispwd==$info['pwd']) { $db->query("Delete from ".table('simple')." WHERE id = '{$id}'"); $link[0]['text'] = "返回微招聘列表"; $link[0]['href'] =url_rewrite('QS_simplelist'); showmsg("删除成功!",2,$link); } } elseif ($act=="refreshsimple") { $smarty->cache =false; $smarty->assign('id',intval($_GET['id'])); $smarty->display('simple/simple-refresh.htm'); exit(); } elseif ($act=="exe_refreshsimple") { $pwd=$_POST['pwd']; $id=intval($_POST['id']); $sql = "select * from ".table('simple')." where id = '{$id}' LIMIT 1"; $info=$db->getone($sql); $thispwd=md5(md5($pwd).$info['pwd_hash'].$QS_pwdhash); if ($thispwd==$info['pwd']) { $db->query("update ".table('simple')." SET refreshtime='".time()."' WHERE id = '{$id}'"); $link[0]['text'] = "返回微招聘列表"; $link[0]['href'] =url_rewrite('QS_simplelist'); showmsg("刷新成功!",2,$link); } } elseif ($act=="editsimple") { $id=intval($_GET['id']); $smarty->cache =false; $info=$db->getone("select * from ".table('simple')." where id = '{$id}' LIMIT 1"); $smarty->assign('info',$info); $smarty->assign('id',$id); $captcha=get_cache('captcha'); $smarty->assign('verify_simple',$captcha['verify_simple']); $smarty->display('simple/simple-edit.htm'); exit(); } elseif ($act=="editsave") { $captcha=get_cache('captcha'); $postcaptcha = trim($_POST['postcaptcha']); if($captcha['verify_simple']=='1' && empty($postcaptcha)) { showmsg("请填写验证码",1); } if ($captcha['verify_simple']=='1' && strcasecmp($_SESSION['imageCaptcha_content'],$postcaptcha)!=0) { showmsg("验证码错误",1); } $id=intval($_POST['id']); $pwd=trim($_POST['pwd']); $info=$db->getone("select * from ".table('simple')." where id = '{$id}' LIMIT 1"); $thispwd=md5(md5($pwd).$info['pwd_hash'].$QS_pwdhash); if ($thispwd!=$info['pwd']) { showmsg("管理密码错误",1); } if ($_CFG['simple_edit_audit']!="-1") { $setsqlarr['audit']=intval($_CFG['simple_edit_audit']); } $setsqlarr['jobname']=trim($_POST['jobname'])?trim($_POST['jobname']):showmsg('您没有填写职位名称!',1); $setsqlarr['amount']=intval($_POST['amount']); $setsqlarr['comname']=trim($_POST['comname'])?trim($_POST['comname']):showmsg('您没有填写单位名称!',1); $setsqlarr['contact']=trim($_POST['contact'])?trim($_POST['contact']):showmsg('您没有填写联系人!',1); if ($_CFG['simple_tel_edit']=="1") { $setsqlarr['tel']=trim($_POST['tel'])?trim($_POST['tel']):showmsg('您没有填写联系电话!',1); if(preg_match("/^\d*$/",$setsqlarr['tel'])) { if ($captcha['simple_tel_repeat']=='0') { $sql = "select id from ".table('simple')." where tel = '{$setsqlarr['tel']}' AND id<>'{$id}' LIMIT 1"; $info=$db->getone($sql); if (!empty($info)) { showmsg('电话号码已经存在!',1); } } } } $setsqlarr['district']=intval($_POST['district']); $setsqlarr['sdistrict']=intval($_POST['sdistrict']); $setsqlarr['district_cn']=trim($_POST['district_cn']); $setsqlarr['sdistrict_cn']=trim($_POST['sdistrict_cn']); $setsqlarr['detailed']=trim($_POST['detailed']); $setsqlarr['refreshtime']=time(); $days=intval($_POST['days']); if ($days>0) { $time=$info['deadline']>time()?$info['deadline']:time(); $setsqlarr['deadline']=strtotime("{$days} day",$time); } require_once(QISHI_ROOT_PATH.'include/splitword.class.php'); $sp = new SPWord(); $setsqlarr['key']=$setsqlarr['jobname'].$setsqlarr['comname'].$setsqlarr['address'].$setsqlarr['detailed']; $setsqlarr['key']="{$setsqlarr['jobname']} {$setsqlarr['comname']} ".$sp->extracttag($setsqlarr['key']); $setsqlarr['key']=$sp->pad($setsqlarr['key']); $link[0]['text'] = "返回微招聘列表"; $link[0]['href'] =url_rewrite('QS_simplelist'); if(updatetable(table('simple'),$setsqlarr," id='{$id}' ")) { if ($_CFG['simple_edit_audit']>1) { $str=",请等待管理员审核"; } showmsg("修改成功{$str}!",2,$link); } else { showmsg("修改失败!",0); } } elseif($act =='check_tel') { $tel=$_GET['tel']; $id=intval($_GET['id']); if(preg_match("/^\d*$/",$tel)) { if ($id>0) { $wheresql=" AND id<>'{$id}'"; } $sql = "select id from ".table('simple')." where tel = '{$tel}' {$wheresql} LIMIT 1"; $info=$db->getone($sql); if (!empty($info)) { exit('false'); } else { exit('true'); } } else { exit('false'); } } elseif($act =='check_pwd') { $pwd=$_GET['pwd']; $id=intval($_GET['id']); if (strcasecmp(QISHI_DBCHARSET,"utf8")!=0) { $pwd=utf8_to_gbk($pwd); } $sql = "select * from ".table('simple')." where id = '{$id}' LIMIT 1"; $info=$db->getone($sql); $thispwd=md5(md5($pwd).$info['pwd_hash'].$QS_pwdhash); if ($thispwd==$info['pwd']) { exit('true'); } else { exit('false'); } } elseif($act == "get_simple_tel"){ $id=intval($_GET['id']); $sql = "select contact,tel from ".table('simple')." where id=".$id; $tel = $db->getone($sql); exit("联系方式:".$tel['tel']." ".$tel['contact']); } elseif($act == "get_simple_detailed"){ $id=intval($_GET['id']); $sql = "select detailed from ".table('simple')." where id=".$id; $detailed = $db->getone($sql); exit("要求:".$detailed['detailed'].'<a href="javascript:void(0);" class="hidden_detailed" id="'.$id.'">[收起]</a>'); } elseif($act == "hidden_simple_detailed"){ $id=intval($_GET['id']); $sql = "select detailed from ".table('simple')." where id=".$id; $detailed = $db->getone($sql); $detailed['detailed'] = cut_str($detailed['detailed'],40,0,"..."); exit("要求:".$detailed['detailed'].'<a href="javascript:void(0);" class="show_detailed" id="'.$id.'">[展开]</a>'); } elseif($act == "get_sdistrict"){ $id = intval($_GET['id']); $sql = "select id,categoryname from ".table('category_district')." where parentid=".$id; $result = $db->getall($sql); $html=""; foreach ($result as $key => $value) { $html .= '<li id="'.$value["id"].'" title="'.$value["categoryname"].'">'.$value["categoryname"].'</li>'; } exit($html); } ?>