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"] . '" did="' . $value["id"] . '" title="' . $value["categoryname"] . '">' . $value["categoryname"] . '</li>';
}
exit($html);
}
if (empty($count[$x])) {
$count[$x] = 0;
}
}
//分页
require_once QISHI_ROOT_PATH . 'include/page.class.php';
$perpage = 10;
$total_sql = "SELECT COUNT(*) AS num from " . table('evaluation_record') . " WHERE uid=" . $_SESSION['uid'];
$total_val = $db->get_total($total_sql);
$page = new page(array('total' => $total_val, 'perpage' => $perpage, 'getarray' => $_GET));
$currenpage = $page->nowindex;
$offset = ($currenpage - 1) * $perpage;
$limit = " LIMIT " . intval($offset) . ',' . intval($perpage);
//答卷信息
$paper_sql = "SELECT r.*,name FROM " . table('evaluation_record') . " AS r LEFT JOIN " . table('evaluation_type') . " AS t ON r.type_id=t.id WHERE uid=" . $_SESSION['uid'] . " ORDER BY addtime desc " . $limit;
$record_list = $db->getall($paper_sql);
foreach ($record_list as $key => $value) {
switch ($value['type_id']) {
case '1':
$value['url'] = url_rewrite('QS_selfcognition');
break;
case '2':
$value['url'] = url_rewrite('QS_occupation');
break;
case '3':
$value['url'] = url_rewrite('QS_talents');
break;
default:
$value['url'] = url_rewrite('QS_management');
break;
}
}
if (!empty($wheresql)) {
$wheresql = " WHERE " . ltrim(ltrim($wheresql), 'AND');
$wheresql .= " AND map_x!='' AND map_y!='' ";
}
$id = array();
if (!empty($lng) && !empty($lat)) {
$idresult = $db->query("SELECT id , ROUND(6378.138*2*ASIN(SQRT(POW(SIN((" . $lat . "*PI()/180-map_y*PI()/180)/2),2)+COS(" . $lat . "*PI()/180)*COS(map_y*PI()/180)*POW(SIN((" . $lng . "*PI()/180-map_x*PI()/180)/2),2)))*1000) AS juli FROM {$jobstable} " . $wheresql . " ORDER BY juli ASC LIMIT {$offset},{$rows}");
while ($row = $db->fetch_array($idresult)) {
$id[] = $row['id'];
}
}
if (!empty($id)) {
$wheresql = " WHERE id IN (" . implode(',', $id) . ") ";
$sql = "SELECT *, ROUND(6378.138*2*ASIN(SQRT(POW(SIN((" . $lat . "*PI()/180-map_y*PI()/180)/2),2)+COS(" . $lat . "*PI()/180)*COS(map_y*PI()/180)*POW(SIN((" . $lng . "*PI()/180-map_x*PI()/180)/2),2)))*1000) AS juli FROM " . table('jobs') . $wheresql . " ORDER BY juli ASC , stick DESC , refreshtime DESC ";
$jobs_list = $db->getall($sql);
foreach ($jobs_list as $key => $value) {
$jobs_list[$key]["juli"] = distancerange($value["juli"]);
}
} else {
$jobs_list = array();
}
$smarty->assign('jobs', $jobs_list);
$smarty->assign('goback', $_SERVER["HTTP_REFERER"]);
//热门关键字
$sqlnearhot = "select w_word,w_hot from " . table("hotword") . " order by w_hot desc limit 15 ";
$hotword_list = $db->getall($sqlnearhot);
$smarty->assign('hotword', $hotword_list);
$smarty->display("m/m-jobs-near-list.html");
} elseif ($act == 'ajaxjobsnearlist') {
$district = intval($_GET['district']) == 0 ? "" : intval($_GET['district']);
require_once QISHI_ROOT_PATH . 'include/fun_wap.php';
require_once QISHI_ROOT_PATH . 'include/mysql.class.php';
$smarty->cache = false;
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
require_once dirname(__FILE__) . '/weixin_share.php';
$show = jobfair_one($_GET['id']);
$time = time();
if ($show) {
//状态
if ($show['predetermined_status'] == "1" && $show['predetermined_start'] > $time) {
$show['predetermined_ok'] = 1;
// 未开始
} else {
if ($show['predetermined_status'] == "1" && $show['holddate_start'] > $time && ($show['predetermined_end'] == "0" || $show['predetermined_end'] > $time) && ($show['predetermined_web'] == "1" || $show['predetermined_tel'] == "1")) {
$show['predetermined_ok'] = 2;
// 预定中
} else {
$show['predetermined_ok'] = 0;
// 已结束
}
}
//参会行业
$jobfair_trade = explode(",", $show['trade_cn']);
$show["trade_cn"] = $jobfair_trade;
$smarty->assign('show', $show);
//参会企业
$exhibitors = $db->getall("SELECT * FROM " . table('jobfair_exhibitors') . " WHERE jobfairid=" . $show["id"]);
$smarty->assign('exhibitors', $exhibitors);
}
$smarty->assign('goback', $_SERVER["HTTP_REFERER"]);
$smarty->display("m/jobfair-show.html");
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
if ($page < 1) {
$page = 1;
}
$theurl = "resume-list.php?sdistrict=" . $sdistrict . "&subclass=" . $subclass . "&key=" . $key;
$start = ($page - 1) * $perpage;
$total_sql = "SELECT COUNT(*) AS num FROM {$jobstable} as r {$joinsql} {$wheresql}";
$count = $db->get_total($total_sql);
$limit = " LIMIT {$start},{$perpage}";
$idresult = $db->query("SELECT id FROM {$jobstable} as r " . $joinsql . $wheresql . $orderbysql . $limit);
while ($row = $db->fetch_array($idresult)) {
$id[] = $row['id'];
}
if (!empty($id)) {
$wheresql = " WHERE id IN (" . implode(',', $id) . ") AND display=1 AND audit=1 ";
$resume = $db->getall("SELECT * FROM " . table('resume') . $wheresql . $orderbysql);
foreach ($resume as $key => $value) {
if ($value['display_name'] == "2") {
$value['fullname'] = "N" . str_pad($value['id'], 7, "0", STR_PAD_LEFT);
$value['fullname_'] = $value['fullname'];
} elseif ($value['display_name'] == "3") {
if ($value['sex'] == 1) {
$value['fullname'] = cut_str($value['fullname'], 1, 0, "先生");
} elseif ($value['sex'] == 2) {
$value['fullname'] = cut_str($value['fullname'], 1, 0, "女士");
}
$value['fullname_'] = $value['fullname'];
} else {
$value['fullname_'] = $value['fullname'];
$value['fullname'] = $value['fullname'];
}
* ============================================================================
*/
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';
$smarty->cache = false;
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
require_once dirname(__FILE__) . '/weixin_share.php';
wap_weixin_logon($_GET['from']);
$row = jobs_one($_GET['id']);
//感兴趣的职位
$interest_show = interest_jobs($row['topclass'], $row['category'], $row['subclass'], $_GET['id']);
if ($_SESSION["uid"] && $_SESSION["utype"] == 2) {
$sql = "select * from " . table("resume") . " where uid={$_SESSION['uid']} ";
$resume_list = $db->getall($sql);
$smarty->assign('resume_list', $resume_list);
}
$show = false;
if ($_CFG['showjobcontact_wap'] == '0') {
$show = true;
} elseif ($_CFG['showjobcontact_wap'] == '1') {
if ($_SESSION['uid'] && $_SESSION['username'] && $_SESSION['utype'] == '2') {
$show = true;
} else {
$show = false;
}
} elseif ($_CFG['showjobcontact_wap'] == '2') {
if ($_SESSION['uid'] && $_SESSION['username'] && $_SESSION['utype'] == '2') {
$val = $db->getone("select uid from " . table('resume') . " where uid='{$_SESSION['uid']}' LIMIT 1");
if (!empty($val)) {
$company_info['wzp_click'] = $praise;
if ($company_info['logo']) {
$company_info['logo'] = $_CFG['site_domain'] . $_CFG['site_dir'] . 'data/logo/' . $company_info['logo'];
} else {
$company_info['logo'] = $_CFG['site_domain'] . $_CFG['site_dir'] . 'data/logo/no_logo.gif';
}
$smarty->assign('company_info', $company_info);
if (empty($company_info)) {
$smarty->display("m/m-wzp_error.html");
} else {
// 企业自己访问出现菜单
if ($vip_menu == "1") {
$smarty->assign('show_menue', 1);
}
// 企业职位
$company_jobs = $db->getall("SELECT j.*,c.telephone from " . table("jobs") . " as j left join " . table("jobs_contact") . " as c on j.id=c.pid where j.uid={$company_info['uid']} ");
$smarty->assign('company_jobs', $company_jobs);
// 企业标签
$company_tag = explode(",", $company_info['tag']);
foreach ($company_tag as $key => $value) {
$val = explode("|", $value);
$company_tagarr['id'][] = $val[0];
$company_tagarr['tag_cn'][] = $val[1];
}
// 默认标签
$_CAT = get_cache('category');
if (!empty($_CAT['QS_jobtag'])) {
foreach ($_CAT["QS_jobtag"] as $cat) {
$list[] = $cat['categoryname'];
}
$list = array_slice($list, 0, 6);
}
$perpage = 5;
$count = 0;
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
if ($page < 1) {
$page = 1;
}
$theurl = "wap-jobs-list.php?district=" . $district . "&sdistrict=" . $sdistrict . "&trade=" . $trade . "&topclass=" . $topclass . "&category=" . $category . "&subclass=" . $subclass . "&wage=" . $wage . "&key=" . $key;
$start = ($page - 1) * $perpage;
$total_sql = "SELECT COUNT(*) AS num FROM {$jobstable} {$wheresql}";
$count = $db->get_total($total_sql);
$limit = " LIMIT {$start},{$perpage}";
$idresult = $db->query("SELECT id FROM {$jobstable} " . $wheresql . $orderbysql . $limit);
while ($row = $db->fetch_array($idresult)) {
$id[] = $row['id'];
}
if (!empty($id)) {
$wheresql = " WHERE id IN (" . implode(',', $id) . ") ";
$jobs = $db->getall("SELECT * FROM " . table('jobs') . $wheresql . $orderbysql);
foreach ($jobs as $key => $value) {
$jobs[$key]['url'] = wap_url_rewrite("wap-jobs-show", array("id" => $value['id']));
if (!empty($value['highlight'])) {
$jobs[$key]['jobs_name'] = "<span style=\"color:{$value['highlight']}\">{$value['jobs_name']}</span>";
}
}
} else {
$jobs = array();
}
$smarty->assign('jobs', $jobs);
$smarty->assign('pagehtml', wapmulti($count, $perpage, $page, $theurl));
$smarty->display("wap/wap-jobs-list.html");
* 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';
$smarty->cache = false;
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
require_once dirname(__FILE__) . '/weixin_share.php';
$id = intval($_GET['id']);
$row = resume_one($id);
wap_weixin_logon($_GET['from']);
if (intval($_SESSION["uid"]) > 0) {
$sql = "select * from " . table("company_down_resume") . " where company_uid={$_SESSION['uid']} and resume_id=" . $id;
$down_resume = $db->getone($sql);
$smarty->assign('down_resume', $down_resume);
$time = time();
$jobs_sql = "select * from " . table("jobs") . " where uid={$_SESSION['uid']} and display=1 and deadline>{$time} ";
$jobs_row = $db->getall($jobs_sql);
$smarty->assign('jobs_row', $jobs_row);
}
$smarty->assign('show', $row);
$smarty->assign('goback', $_SERVER["HTTP_REFERER"]);
$smarty->display("m/m-resume-show.html");
$smarty->cache = false;
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
$jobstable = table('article');
$orderbysql = " ORDER BY `id` desc";
$perpage = 5;
$count = 0;
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
if ($page < 1) {
$page = 1;
}
$theurl = "wap-news-list.php";
$start = ($page - 1) * $perpage;
$total_sql = "SELECT COUNT(*) AS num FROM {$jobstable} ";
$count = $db->get_total($total_sql);
$limit = " LIMIT {$start},{$perpage}";
$idresult = $db->query("SELECT id FROM {$jobstable} " . $orderbysql . $limit);
while ($row = $db->fetch_array($idresult)) {
$id[] = $row['id'];
}
if (!empty($id)) {
$wheresql = " WHERE id IN (" . implode(',', $id) . ") ";
$article = $db->getall("SELECT * FROM " . table('article') . $wheresql . $orderbysql);
foreach ($article as $key => $value) {
$article[$key]['url'] = wap_url_rewrite("wap-news-show", array("id" => $value['id']));
}
} else {
$article = array();
}
$smarty->assign('article', $article);
$smarty->display("wap/wap-news-list.html");
$redirect_sitename = $subinfo['sitename'];
}
}
$smarty->assign('redirect_to_subsite', $redirect_to_subsite);
$smarty->assign('redirect_url', $redirect_url);
$smarty->assign('redirect_disname', $redirect_disname);
$smarty->assign('redirect_sitename', $redirect_sitename);
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
require_once dirname(__FILE__) . '/weixin_share.php';
if ($_CFG['subsite_id'] > 0) {
$subsite_wheresql = ' subsite_id=' . intval($_CFG['subsite_id']) . ' ';
} else {
$subsite_wheresql = ' 1=1 ';
}
//公告
$notice_list = $db->getall("SELECT * FROM " . table('notice') . " where " . $subsite_wheresql . " ORDER BY `sort` DESC,`id` DESC LIMIT 5");
$smarty->assign('notice_list', $notice_list);
//紧急职位
$emergency_jobs = $db->getall("SELECT id,subsite_id,jobs_name,district_cn,companyname,wage_cn,refreshtime FROM " . table('jobs') . " WHERE emergency=1 and " . $subsite_wheresql . " ORDER BY `refreshtime` DESC,`id` DESC LIMIT 5");
foreach ($emergency_jobs as $key => $value) {
$emergency_jobs[$key]['url'] = wap_url_rewrite("jobs-show", array("id" => $value['id']), 1, $value['subsite_id']);
$emergency_jobs[$key]['r_time'] = daterange(time(), $value['refreshtime'], 'Y-m-d', "#FF3300");
}
$smarty->assign('emergency_jobs', $emergency_jobs);
//推荐职位
$recommend_jobs = $db->getall("SELECT id,subsite_id,jobs_name,district_cn,companyname,wage_cn,refreshtime FROM " . table('jobs') . " WHERE recommend=1 and " . $subsite_wheresql . " ORDER BY `refreshtime` DESC,`id` DESC LIMIT 5");
foreach ($recommend_jobs as $key => $value) {
$recommend_jobs[$key]['url'] = wap_url_rewrite("jobs-show", array("id" => $value['id']), 1, $value['subsite_id']);
$recommend_jobs[$key]['r_time'] = daterange(time(), $value['refreshtime'], 'Y-m-d', "#FF3300");
}
$smarty->assign('recommend_jobs', $recommend_jobs);
$infoarr['experience'] = $setsqlarr['experience'];
$infoarr['experience_cn'] = $setsqlarr['experience_cn'];
$infoarr['phone'] = $setsqlarr['telephone'];
$infoarr['email'] = $setsqlarr['email'];
$infoarr['uid'] = intval($_SESSION['uid']);
$db->inserttable(table('members_info'), $infoarr);
}
baidu_submiturl(url_rewrite('QS_resumeshow', array('id' => $pid)), 'addresume');
echo $pid;
// header("Location: ?act=resume_success&pid=".$pid);
}
} elseif ($act == "resume_success") {
$smarty->cache = false;
$id = intval($_GET['pid']);
$sql = "select j.* from " . table("jobs") . " as j left join " . table("resume_jobs") . " as r on r.category=j.category where r.pid={$id} limit 5";
$resume_jobs = $db->getall($sql);
$smarty->assign('resume_jobs', $resume_jobs);
$smarty->display('wap/personal/wap-create-resume-success.html');
} elseif ($act == "resume_list") {
$smarty->cache = false;
$wheresql = " WHERE uid='" . intval($_SESSION['uid']) . "' ";
$sql = "SELECT * FROM " . table('resume') . $wheresql;
$resume_list = get_resume_list($sql, 12, true, true, true);
$smarty->assign('resume_list', $resume_list);
$smarty->display('wap/personal/wap-resume-index.html');
} elseif ($act == "resume_one") {
$smarty->cache = false;
$id = intval($_GET['pid']);
$resume_one = resume_one($id);
$smarty->assign('resume_one', $resume_one);
$smarty->assign('resume_basic', get_resume_basic(intval($_SESSION['uid']), $id));
define('IN_QISHI', true);
$alias = "QS_evaluation_index";
require_once dirname(__FILE__) . '/../include/common.inc.php';
$smarty->assign("evaluation_nav", "index");
if ($mypage['caching'] > 0) {
$smarty->cache = true;
$smarty->cache_lifetime = $mypage['caching'];
} else {
$smarty->cache = false;
}
$cached_id = $alias . (isset($_GET['id']) ? "|" . intval($_GET['id']) % 100 . '|' . intval($_GET['id']) : '') . (isset($_GET['page']) ? "|p" . intval($_GET['page']) % 100 : '');
require_once QISHI_ROOT_PATH . 'include/mysql.class.php';
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
//统计测评类型参与人数
$sql = "SELECT * FROM " . table('evaluation_type') . " ";
$type_info = $db->getall($sql);
foreach ($type_info as $key => $value) {
$num = 0;
$sql_num = "SELECT * FROM " . table('evaluation_paper') . " WHERE type_id=" . $value['id'];
$type_num = $db->query($sql_num);
while ($row = $db->fetch_array($type_num)) {
$num = $num + intval($row['join_num']);
}
$type_info[$key]['join_num'] = $num;
}
//热门测评
$paper_sql = "SELECT * FROM " . table('evaluation_paper') . " ORDER BY join_num LIMIT 10 ";
$paper_info = $db->getall($paper_sql);
foreach ($paper_info as $key => $value) {
$paper_info[$key]['key'] = $key + 1;
}
$smarty->assign('next_page', 1);
if ($page != 1) {
$smarty->assign('pre_page', 1);
}
} else {
$page = $_REQUEST['page'] ? intval($_REQUEST['page']) + 1 : 2;
if ($page != $page_num) {
$smarty->assign('next_page', 1);
}
$smarty->assign('pre_page', 1);
$offset = ($page - 1) * $perpage;
$smarty->assign('page', $page);
}
$limit = " LIMIT " . intval($offset) . ',' . intval($perpage);
$question_sql = "SELECT * FROM " . table('evaluation_question') . " WHERE paper_id=" . $id . " ORDER BY id asc " . $limit;
$question_list = $db->getall($question_sql);
foreach ($question_list as $key => $value) {
$option_sql = "SELECT * FROM " . table('evaluation_option') . " WHERE question_id=" . $value['id'] . " ORDER BY id asc ";
$option_list = $db->getall($option_sql);
$question_list2[intval($offset) + intval($key) + 1] = $value;
$question_list2[intval($offset) + intval($key) + 1]['key'] = intval($offset) + intval($key) + 1;
$question_list2[intval($offset) + intval($key) + 1]['option'] = $option_list;
}
$smarty->assign('question_list', $question_list2);
$paperid = intval($_REQUEST['paperid']);
$page_num = intval($_REQUEST['page_num']);
$perpage = intval($_REQUEST['perpage']);
$total_val = intval($_REQUEST['total_val']);
//读取 答完页的session 整合当前页面的 要不然当前页面的数据会把之前存的session覆盖掉
if (!empty($_SESSION['paper_info'])) {
$pagerarr = json_decode($_SESSION['paper_info'], true);
}
if (!empty($wheresql)) {
$wheresql = " WHERE " . ltrim(ltrim($wheresql), 'AND');
$wheresql .= " AND map_x!='' AND map_y!='' ";
}
$id = array();
if (!empty($lng) && !empty($lat)) {
$idresult = $db->query("SELECT id , ROUND(6378.138*2*ASIN(SQRT(POW(SIN((" . $lat . "*PI()/180-map_y*PI()/180)/2),2)+COS(" . $lat . "*PI()/180)*COS(map_y*PI()/180)*POW(SIN((" . $lng . "*PI()/180-map_x*PI()/180)/2),2)))*1000) AS juli FROM {$jobstable} " . $wheresql . " ORDER BY juli ASC LIMIT {$offset},{$rows}");
while ($row = $db->fetch_array($idresult)) {
$id[] = $row['id'];
}
}
if (!empty($id)) {
$wheresql = " WHERE id IN (" . implode(',', $id) . ") ";
$sql = "SELECT *, ROUND(6378.138*2*ASIN(SQRT(POW(SIN((" . $lat . "*PI()/180-map_y*PI()/180)/2),2)+COS(" . $lat . "*PI()/180)*COS(map_y*PI()/180)*POW(SIN((" . $lng . "*PI()/180-map_x*PI()/180)/2),2)))*1000) AS juli FROM " . table('jobs') . $wheresql . " ORDER BY juli ASC , stick DESC , refreshtime DESC ";
$jobs_list = $db->getall($sql);
foreach ($jobs_list as $key => $value) {
$jobs_list[$key]["juli"] = distancerange($value["juli"]);
}
} else {
$jobs_list = array();
}
$smarty->assign('jobs', $jobs_list);
$smarty->assign('goback', $_SERVER["HTTP_REFERER"]);
$smarty->display("m/m-jobs-near-list.html");
} elseif ($act == 'ajaxjobsnearlist') {
$district = intval($_GET['district']) == 0 ? "" : intval($_GET['district']);
$sdistrict = intval($_GET['sdistrict']) == 0 ? "" : intval($_GET['sdistrict']);
$trade = intval($_GET['trade']) == 0 ? "" : intval($_GET['trade']);
$topclass = intval($_GET['topclass']) == 0 ? "" : intval($_GET['topclass']);
$category = intval($_GET['category']) == 0 ? "" : intval($_GET['category']);
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') {
$jobsid = intval($_POST["jobs_id"]) ? intval($_POST["jobs_id"]) : exit("出错了");
$resumeid = intval($_POST["resume_id"]) ? intval($_POST["resume_id"]) : exit("出错了");
$_POST = array_map("utf8_to_gbk", $_POST);
$sql = "select * from " . table("personal_jobs_apply") . " where personal_uid=" . intval($_SESSION['uid']) . " and resume_id=" . intval($_POST["resume_id"]) . " and jobs_id=" . intval($_POST["jobs_id"]) . "";
$row = $db->getone($sql);
$resume_basic = get_resume_basic($_SESSION['uid'], $resumeid);
$resume_basic = array_map("addslashes", $resume_basic);
if (empty($resume_basic)) {
exit("简历丢失");
}
if ($_SESSION['utype'] != 2) {
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
if ($page < 1) {
$page = 1;
}
$theurl = "resume-list.php?sdistrict=" . $sdistrict . "&subclass=" . $subclass . "&key=" . $key;
$start = ($page - 1) * $perpage;
$total_sql = "SELECT COUNT(*) AS num FROM {$jobstable} as r {$joinsql} {$wheresql}";
$count = $db->get_total($total_sql);
$limit = " LIMIT {$start},{$perpage}";
$idresult = $db->query("SELECT id FROM {$jobstable} as r " . $joinsql . $wheresql . $orderbysql . $limit);
while ($row = $db->fetch_array($idresult)) {
$id[] = $row['id'];
}
if (!empty($id)) {
$wheresql = " WHERE id IN (" . implode(',', $id) . ") AND display=1 AND audit=1 ";
$resume = $db->getall("SELECT * FROM " . table('resume') . $wheresql . $orderbysql);
foreach ($resume as $key => $value) {
if ($value['display_name'] == "2") {
$value['fullname'] = "N" . str_pad($value['id'], 7, "0", STR_PAD_LEFT);
$value['fullname_'] = $value['fullname'];
} elseif ($value['display_name'] == "3") {
if ($value['sex'] == 1) {
$value['fullname'] = cut_str($value['fullname'], 1, 0, "先生");
} elseif ($value['sex'] == 2) {
$value['fullname'] = cut_str($value['fullname'], 1, 0, "女士");
}
$value['fullname_'] = $value['fullname'];
} else {
$value['fullname_'] = $value['fullname'];
$value['fullname'] = $value['fullname'];
}
define('IN_QISHI', true);
$alias = "QS_paper_result";
error_reporting(E_ERROR);
require_once dirname(__FILE__) . '/../include/common.inc.php';
if ($mypage['caching'] > 0) {
$smarty->cache = true;
$smarty->cache_lifetime = $mypage['caching'];
} else {
$smarty->cache = false;
}
$cached_id = $alias . (isset($_GET['id']) ? "|" . intval($_GET['id']) % 100 . '|' . intval($_GET['id']) : '') . (isset($_GET['page']) ? "|p" . intval($_GET['page']) % 100 : '');
//测卷结果详情
require_once QISHI_ROOT_PATH . 'include/mysql.class.php';
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
$id = $_GET['id'] ? intval($_GET['id']) : 0;
$paper_sql = "SELECT r.score,r.result_description,p.* FROM " . table('evaluation_record') . " AS r LEFT JOIN " . table('evaluation_paper') . " AS p ON r.paper_id=p.id WHERE uid=" . $_SESSION['uid'] . " and r.id = {$id} ";
$paper_info = $db->getone($paper_sql);
//var_dump($paper_info);
$smarty->assign('paper_info', $paper_info);
//测评推荐
$paper_list_sql = "SELECT * FROM " . table('evaluation_paper') . " ORDER BY join_num desc LIMIT 3 ";
$paper_list = $db->getall($paper_list_sql);
$smarty->assign('paper_list', $paper_list);
if (!$smarty->is_cached($mypage['tpl'], $cached_id)) {
$mypage['tpl'] = '../tpl_evaluation/default/' . $mypage['tpl'];
$smarty->display($mypage['tpl'], $cached_id);
$db->close();
} else {
$smarty->display($mypage['tpl'], $cached_id);
}
unset($smarty);
}
if ($scale != '') {
$wheresql .= " AND scale={$scale} ";
}
if (!empty($wheresql)) {
$wheresql = " WHERE " . ltrim(ltrim($wheresql), 'AND');
}
$rows = intval($_GET['rows']);
$offset = intval($_GET['offset']);
$idresult = $db->query("SELECT id FROM {$jobstable} " . $wheresql . $orderbysql . " LIMIT {$offset},{$rows}");
while ($row = $db->fetch_array($idresult)) {
$id[] = $row['id'];
}
if (!empty($id)) {
$wheresql = " WHERE id IN (" . implode(',', $id) . ") ";
$jobs = $db->getall("SELECT * FROM " . table('jobs') . $wheresql . $orderbysql);
foreach ($jobs as $key => $value) {
$jobs[$key]['url'] = wap_url_rewrite("jobs-show", array("id" => $value['id']));
}
} else {
$jobs = array();
}
// $jobslistarray=$db->getall("select * from ".table("jobs").$wheresql." ORDER BY `refreshtime` DESC LIMIT {$offset},{$rows}");
if (!empty($jobs) && $offset <= 100) {
foreach ($jobs as $li) {
$url = wap_url_rewrite("jobs-show", array("id" => $li['id']));
$jobslisthtml .= '<section class="jobs-item thisurl box" url="' . $url . '">';
$ding = '';
if ($li['stick'] == "1") {
$ding = '<span class="job-ding"></span><h3><a href="' . $url . '">' . $li["jobs_name"] . '</a>';
} else {
header("Location: ../wap_login.php");
} elseif ($act == 'index') {
$smarty->cache = false;
$wheresql = " WHERE a.company_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.*,r.title,r.fullname,r.display_name,r.education_cn,r.birthdate,r.experience_cn,r.residence_cn from " . table("personal_jobs_apply") . " as a left join " . table("resume") . " as r on a.resume_id=r.id {$wheresql} order by a.apply_addtime desc " . $limit;
$apply = $db->getall($sql);
foreach ($apply as $key => $value) {
$value["birthdate_"] = date('Y', time()) - $value["birthdate"];
if ($value['display_name'] == "2") {
$value['fullname'] = "N" . str_pad($value['resume_id'], 7, "0", STR_PAD_LEFT);
} elseif ($value['display_name'] == "3") {
$value['fullname'] = cut_str($value['fullname'], 1, 0, "**");
}
$apply[$key] = $value;
}
$smarty->assign('apply', $apply);
$smarty->display("wap/company/wap-get-resumes.html");
} elseif ($act == "ajax_get_resume") {
$favoriteshtml = "";
$rows = intval($_GET['rows']);
$offset = intval($_GET['offset']);
$smarty->cache = false;
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
$act = !empty($_REQUEST['act']) ? trim($_REQUEST['act']) : 'interview';
if ($_SESSION['uid'] == '' || $_SESSION['username'] == '' || intval($_SESSION['utype']) == 1) {
header("Location: ../login.php");
}
$user = get_user_info($_SESSION['uid']);
if ($_CFG['login_per_audit_mobile'] && $user['mobile_audit'] == "0") {
$str = "<script>";
$str .= "alert('请先验证手机！');";
$str .= "window.location.href='account_security.php';";
$str .= "</script>";
echo $str;
} elseif ($act == 'interview') {
$uid = intval($_SESSION["uid"]);
$wheresql = " WHERE i.resume_uid={$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('company_interview') . " as i {$wheresql}";
$count = $db->get_total($total_sql);
$limit = " LIMIT {$start},{$perpage}";
$sql = "select * from " . table("company_interview") . " as i {$wheresql} order by i.interview_addtime " . $limit;
$interview = $db->getall($sql);
$smarty->assign('interview', $interview);
$smarty->display("m/personal/m-interview.html");
}
$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('company_interview') . " as i " . $joinsql . " {$wheresql}";
$count = $db->get_total($total_sql);
$interview = wap_get_interview($start, $perpage, $joinsql . $wheresql);
$smarty->assign('interview', $interview);
$smarty->display("m/company/m-interview-list.html");
} elseif ($act == "ajax_get_interview") {
$favoriteshtml = "";
$rows = intval($_GET['rows']);
$offset = intval($_GET['offset']);
$wheresql = " WHERE i.company_uid='{$_SESSION['uid']}' ";
$favoritesarry = $db->getall("select i.*,r.title,r.fullname,r.display_name,r.education_cn,r.birthdate,r.experience_cn,r.residence from " . table("company_interview") . " as i left join " . table("resume") . " as r on i.resume_id=r.id {$wheresql} order by i.interview_addtime desc limit {$offset},{$rows}");
if (!empty($favoritesarry) && $offset <= 100) {
foreach ($favoritesarry as $list) {
$list["birthdate_"] = date('Y', time()) - $list["birthdate"];
$favoriteshtml .= '<div class="get_resume_box" onclick="window.location.href="../resume-show.php?id=' . $list["resume_id"] . '"">
<div class="get_resume_left">
<div class="name_box">
<div class="name_box_l">' . $list["fullname"] . '</div>
<div class="name_box_r">' . date("Y-m-d", $list["apply_addtime"]) . '</div>
<div class="clear"></div>
</div>
<div class="person_detail">' . $list["education_cn"] . '|' . $list["birthdate_"] . '|' . $list["experience_cn"] . '|' . $list["residence"] . '<br />邀请职位：' . $list["jobs_name"] . '
</div>
</div>
<div class="get_resume_right"><img src="../images/34.gif" alt="" /></div>
<div class="clear"></div>
}
$theurl = "news-list.php";
$start = ($page - 1) * $perpage;
$total_sql = "SELECT COUNT(*) AS num FROM {$jobstable} " . $wheresql . $orderbysql;
$count = $db->get_total($total_sql);
$limit = " LIMIT {$start},{$perpage}";
$idresult = $db->query("SELECT * FROM {$jobstable} " . $wheresql . $orderbysql . $limit);
$article = array();
while ($row = $db->fetch_array($idresult)) {
$row['url'] = wap_url_rewrite("news-show", array("id" => $row['id']));
$row['addtime'] = daterange(time(), $row['addtime'], 'Y-m-d', "#FF3300");
$row['bimg'] = $_CFG['upfiles_dir'] . $row['Small_img'];
$row['content'] = strip_tags($row['content']);
$row['content'] = cut_str($row['content'], 100, 0, "...");
$article[] = $row;
}
$smarty->assign('article', $article);
//新闻资讯分类
if ($type > 0) {
$category_first = $db->getone("SELECT id,parentid,categoryname FROM " . table('article_category') . " where id=" . $type);
$category_more = $db->getall("SELECT id,parentid,categoryname FROM " . table('article_category') . " where parentid!=0 and id!=" . $type . " ORDER BY id asc");
} else {
$category = $db->getall("SELECT id,parentid,categoryname FROM " . table('article_category') . " where parentid!=0 ORDER BY id asc");
$category_first = $category[0];
for ($i = 1; $i < count($category); $i++) {
$category_more[] = $category[$i];
}
}
$smarty->assign('category_first', $category_first);
$smarty->assign('category_more', $category_more);
$smarty->display("m/news-list.html");
<?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';
$smarty->cache = false;
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
$emergency_jobs = $db->getall("SELECT * FROM " . table('jobs') . " WHERE `emergency`=1 ORDER BY `refreshtime` DESC LIMIT 5");
foreach ($emergency_jobs as $key => $value) {
$emergency_jobs[$key]['url'] = wap_url_rewrite("wap-jobs-show", array("id" => $value["id"]));
}
$smarty->assign('emergency_jobs', $emergency_jobs);
$smarty->display("wap/wap.html");
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
$act = !empty($_REQUEST['act']) ? trim($_REQUEST['act']) : '';
if ($act == 'ajaxjobslist') {
$jobslisthtml = "";
if (isset($_GET['recommend']) && intval($_GET['recommend']) == 1) {
$wheresql .= " AND `recommend`=1 ";
}
if (isset($_GET['emergency']) && intval($_GET['emergency']) == 1) {
$wheresql .= " AND `emergency`=1 ";
}
if (!empty($wheresql)) {
$wheresql = " WHERE " . ltrim(ltrim($wheresql), 'AND');
}
$rows = intval($_GET['rows']);
$offset = intval($_GET['offset']);
$jobslistarray = $db->getall("select * from " . table('jobs') . $wheresql . " ORDER BY `refreshtime` DESC LIMIT {$offset},{$rows}");
if (!empty($jobslistarray) && $offset <= 100) {
foreach ($jobslistarray as $li) {
$url = wap_url_rewrite("wap-jobs-show", array("id" => $li["id"]));
$jobslisthtml .= '<div class="list" id="li-' . $offset . '" url="' . $url . '">
<div class="t1"><span><a href="' . $url . '">' . $li["jobs_name"] . '</a></span><br />
' . $li["companyname"] . '</div>
<div class="t2">' . $li["district_cn"] . '<br />' . $li["wag_cn"] . '</div>
<div class="t3"><img src="images/14.jpg" border="0"/></div>
<div class="clear"></div>
</div>';
}
exit($jobslisthtml);
} else {
exit('-1');
}
if (empty($_SESSION["openid"])) {
exit("openid is empty");
}
$val['username'] = !empty($_POST['username']) ? trim(utf8_to_gbk($_POST['username'])) : exit("输入用户名");
$val['email'] = !empty($_POST['email']) ? trim($_POST['email']) : exit("输入邮箱");
$val['member_type'] = intval($_POST['member_type']);
$val['password'] = !empty($_POST['password']) ? trim($_POST['password']) : exit("输入密码");
if ($val['password'] != trim($_POST['rpassword'])) {
exit("密码不一致");
}
require_once QISHI_ROOT_PATH . 'include/mysql.class.php';
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
unset($dbhost, $dbuser, $dbpass, $dbname);
require_once QISHI_ROOT_PATH . 'include/fun_user.php';
$sql = "select * from " . table("members") . " where username='******'username']}' or email='{$val['email']}'";
$row = $db->getall($sql);
if (!empty($row)) {
exit("用户名或邮箱已经存在！");
}
$userid = user_register($val['username'], $val['password'], $val['member_type'], $val['email']);
if ($userid) {
$db->query("UPDATE " . table('members') . " SET qq_openid = '{$_SESSION['openid']}' WHERE uid='{$userid}' AND qq_openid='' LIMIT 1");
update_user_info($userid);
exit("ok");
} else {
require_once QISHI_ROOT_PATH . 'include/tpl.inc.php';
exit("reg_err");
}
} elseif ($act == 'binding') {
$url = "https://graph.qq.com/oauth2.0/authorize?response_type=token&client_id={$_CFG['qq_appid']}&redirect_uri={$_CFG['wap_domain']}/connect_qq_client.php" . urlencode('?act=binding_check');
header("Location:{$url}");
* ============================================================================
* 版权所有: 骑士网络，并保留所有权利。
* 网站地址: http://www.74cms.com；
* ----------------------------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
* 使用；不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
*/
define('IN_QISHI', true);
require_once dirname(__FILE__) . '/../include/common.inc.php';
$act = !empty($_REQUEST['act']) ? trim($_REQUEST['act']) : 'add';
require_once QISHI_ROOT_PATH . 'include/mysql.class.php';
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
if ($act == "add") {
$sql = "select * from " . table('link_category') . "";
$cat = $db->getall($sql);
$smarty->assign('cat', $cat);
$text = get_cache('text');
$smarty->assign('link_application_txt', $text['link_application_txt']);
$smarty->assign('random', mt_rand());
$captcha = get_cache('captcha');
$smarty->assign('verify_link', $captcha['verify_link']);
$smarty->display('link/add.htm');
} elseif ($act == "save") {
$captcha = get_cache('captcha');
$postcaptcha = trim($_POST['postcaptcha']);
if ($captcha['verify_link'] == '1' && empty($postcaptcha)) {
showmsg("请填写验证码", 1);
}
if ($captcha['verify_link'] == '1' && strcasecmp($_SESSION['imageCaptcha_content'], $postcaptcha) != 0) {
showmsg("验证码错误", 1);
$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('company_favorites') . " as f " . $joinsql . " {$wheresql}";
$count = $db->get_total($total_sql);
$smarty->assign('favorites', wap_get_favorites($start, $perpage, $joinsql . $wheresql));
$smarty->display("m/company/m-collect-resumes.html");
} elseif ($act == "ajax_collect_resume") {
$favoriteshtml = "";
$rows = intval($_GET['rows']);
$offset = intval($_GET['offset']);
$wheresql = " WHERE a.company_uid='{$_SESSION['uid']}' ";
$row = $db->getall("select a.*,r.title,r.fullname,r.sex,r.display_name,r.education_cn,r.birthdate,r.experience_cn,r.residence from " . table("company_favorites") . " as a left join " . table("resume") . " as r on a.resume_id=r.id {$wheresql} order by a.favoritesa_ddtime desc limit {$offset},{$rows}");
if (!empty($row) && $offset <= 100) {
foreach ($row as $list) {
$list["birthdate_"] = date('Y', time()) - $list["birthdate"];
if ($list['display_name'] == "2") {
$list['fullname'] = "N" . str_pad($list['resume_id'], 7, "0", STR_PAD_LEFT);
} elseif ($list['display_name'] == "3") {
if ($list['sex'] == 1) {
$list['fullname'] = cut_str($list['fullname'], 1, 0, "先生");
} elseif ($list['sex'] == 2) {
$list['fullname'] = cut_str($list['fullname'], 1, 0, "女士");
}
}
$favoriteshtml .= '<div class="get_resume_box" onclick="window.location.href="../resume-show.php?id=' . $list["resume_id"] . '
""><div class="get_resume_left"><div class="name_box"><div class="name_box_l">' . $list["fullname"] . '</div><div class="name_box_r">' . date("Y-m-d", $list["apply_addtime"]) . '</div><div class="clear"></div></div><div class="person_detail">' . $list["education_cn"] . '|' . $list["birthdate_"] . '|' . $list["experience_cn"] . '|' . $list["residence"] . '</div></div><div class="get_resume_right"><img src="../images/34.gif" alt="" /></div><div class="clear"></div></div>';
}
$page = empty($_GET['page']) ? 1 : intval($_GET['page']);
if ($page < 1) {
$page = 1;
}
$theurl = "jobs-list.php?district=" . $district . "&sdistrict=" . $sdistrict . "&trade=" . $trade . "&topclass=" . $topclass . "&category=" . $category . "&subclass=" . $subclass . "&wage=" . $wage . "&key=" . $key;
$start = ($page - 1) * $perpage;
$total_sql = "SELECT COUNT(*) AS num FROM {$jobstable} {$wheresql}";
$count = $db->get_total($total_sql);
$limit = " LIMIT {$start},{$perpage}";
$idresult = $db->query("SELECT id FROM {$jobstable} " . $wheresql . $orderbysql . $limit);
while ($row = $db->fetch_array($idresult)) {
$id[] = $row['id'];
}
if (!empty($id)) {
$wheresql = " WHERE id IN (" . implode(',', $id) . ") ";
$jobs = $db->getall("SELECT * FROM " . table('jobs') . $wheresql . $orderbysql);
foreach ($jobs as $key => $value) {
$jobs[$key]['url'] = wap_url_rewrite("jobs-show", array("id" => $value['id']));
if (!empty($value['highlight'])) {
$jobs[$key]['jobs_name'] = "<span style=\"color:{$value['highlight']}\">{$value['jobs_name']}</span>";
}
}
} else {
$jobs = array();
}
$smarty->assign('jobs', $jobs);
$smarty->assign('pagehtml', wapmulti($count, $perpage, $page, $theurl));
//热门关键字
$sql = "select w_word,w_hot from " . table("hotword") . " order by w_hot desc limit 15 ";
$hotword_list = $db->getall($sql);
$smarty->assign('hotword', $hotword_list);
