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) {
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);