www.gusucode.com > 74cms PHP骑士人才系统 v3.5.1源码程序 > code/upload/wap/personal/wap_apply.php
<?php /* * 74cms WAP * ============================================================================ * 版权所有: 骑士网络,并保留所有权利。 * 网站地址: http://www.74cms.com; * ---------------------------------------------------------------------------- * 这不是一个自由软件!您只能在不用于商业目的的前提下对程序代码进行修改和 * 使用;不允许对程序代码以任何形式任何目的的再发布。 * ============================================================================ */ define('IN_QISHI', true); require_once(dirname(__FILE__).'/../../include/common.inc.php'); require_once(QISHI_ROOT_PATH.'include/fun_wap.php'); require_once(QISHI_ROOT_PATH.'include/mysql.class.php'); require_once(QISHI_ROOT_PATH.'include/fun_personal.php'); $smarty->cache = false; $db = new mysql($dbhost,$dbuser,$dbpass,$dbname); $act = !empty($_REQUEST['act']) ? trim($_REQUEST['act']) : 'apply'; if ($_SESSION['uid']=='' || $_SESSION['username']==''||intval($_SESSION['utype'])==1) { header("Location: ../wap_login.php"); } elseif ($act == 'apply') { $wheresql=" WHERE a.personal_uid='{$_SESSION['uid']}' "; $perpage = 5; $count = 0; $page = empty($_GET['page'])?1:intval($_GET['page']); if($page<1) $page = 1; $start = ($page-1)*$perpage; $total_sql="SELECT COUNT(*) AS num FROM ".table('personal_jobs_apply')." as a {$wheresql}"; $count=$db->get_total($total_sql); $limit=" LIMIT {$start},{$perpage}"; $sql="select a.*,j.wage_cn from ".table("personal_jobs_apply")." as a left join ".table("jobs")." as j on a.jobs_id=j.id $wheresql order by apply_addtime desc ".$limit; $apply=$db->getall($sql); $smarty->assign('apply',$apply); // $smarty->assign('pagehtml',wapmulti($count, $perpage, $page, $theurl)); $smarty->display("wap/personal/wap-apply.html"); } elseif ($act == 'apply_add') { $_POST=array_map("utf8_to_gbk", $_POST); $sql="select * from ".table("personal_jobs_apply")." where resume_id=".intval($_POST["resume_id"])." and jobs_id=".intval($_POST["jobs_id"]).""; $row=$db->getone($sql); if($_SESSION['utype']!=2){ exit("个人会员请登录后申请职位"); } elseif($row){ exit("您已经申请过此职位!"); } else{ $setsqlarr["jobs_id"]=intval($_POST["jobs_id"]); $setsqlarr["jobs_name"]=$_POST["jobs_name"]; $setsqlarr["company_id"]=intval($_POST["company_id"]); $setsqlarr["company_name"]=$_POST["company_name"]; $setsqlarr["company_uid"]=intval($_POST["company_uid"]); $setsqlarr["resume_id"]=intval($_POST["resume_id"]); $setsqlarr["resume_name"]=$_POST["resume_title"]; $setsqlarr["personal_uid"]=intval($_SESSION["uid"]); $setsqlarr["apply_addtime"]=time(); inserttable(table('personal_jobs_apply'),$setsqlarr)?exit("ok"):exit("err"); } } ?>