$db->close();
$result->outputResult($retObj);
break;
/*
* 获取资源信息
*/
/*
* 获取资源信息
*/
case 'getRes':
if (!array_key_exists('resource_id', $_GET)) {
$result->outputErrResult('001');
}
$resource_id = $_GET['resource_id'];
//查询信息
$db = new WebTrainDBConnection();
$retObj = new stdClass();
$resRS = $db->query("SELECT t1.*,IFNULL(t2.name,t2.user_name) AS uploader FROM resources AS t1 LEFT JOIN pineapple_user AS t2 ON t1.user_id=t2.user_id WHERE resource_id='{$resource_id}' LIMIT 1");
if (!$resRS) {
$db->close();
$result->outputErrResult('004');
}
$resObj = $resRS->fetch_object();
if ($resObj == NULL) {
$db->close();
$result->outputErrResult('401');
}
$retObj->resource_name = $resObj->resource_name;
$retObj->resource_type = $resObj->resource_type;
$retObj->resource_tag = $resObj->resource_tag;
$retObj->instruction = $resObj->instruction;
$result->outputEnd();
//更新数据库
break;
/*
* 查询对应课程成绩
*/
/*
* 查询对应课程成绩
*/
case 'getGrade':
if (!array_key_exists('user_id', $_GET) || !array_key_exists('lesson_id', $_GET)) {
$result->outputErrResult('001');
}
$user_id = $_GET['user_id'];
$lesson_id = $_GET['lesson_id'];
$db = new WebTrainDBConnection();
$studyRS = $db->query("SELECT * FROM lesson_study WHERE lesson_id='{$lesson_id}' AND user_id='{$user_id}' AND pay_flag=1 LIMIT 1");
if (!$studyRS) {
$db->close();
$result->outputErrResult('004');
}
$studyObj = $studyRS->fetch_object();
if ($studyObj == NULL) {
$db->close();
$result->outputErrResult('501');
}
$retObj = new stdClass();
$retObj->study_id = $studyObj->study_id;
$retObj->theory_score = $studyObj->theory_score;
$retObj->practical_score = $studyObj->practical_score;
$retObj->communicate_ability = $studyObj->communicate_ability;
$_SESSION['identify_number'] = $managerObj->identify_number;
$result->outputEnd();
break;
/*
* 管理员列表
*/
/*
* 管理员列表
*/
case 'managerList':
if (!array_key_exists('start', $_GET) || !array_key_exists('count', $_GET)) {
$result->outputErrResult('001');
}
$start = $_GET['start'];
$count = $_GET['count'];
$db = new WebTrainDBConnection();
$retObj = new stdClass();
//查询总数量
$countRS = $db->query("SELECT COUNT(identify_number) AS tcount FROM system_manager");
if ($countRS == FALSE) {
$db->close();
$result->outputErrResult('004');
}
$countObj = $countRS->fetch_object();
$retObj->tcount = $countObj->tcount;
$managerList = $db->query("SELECT * FROM system_manager ORDER BY root DESC,identify_number LIMIT {$start},{$count}");
if (!$managerList) {
$db->close();
$result->outputErrResult('004');
}
if ($managerList->num_rows == 0) {
}
$db->close();
$result->outputEnd();
break;
/*
* 获取个人信息
*/
/*
* 获取个人信息
*/
case 'getUser':
if (!array_key_exists('user_id', $_SESSION)) {
$result->outputErrResult('007');
}
$user_id = $_SESSION['user_id'];
$db = new WebTrainDBConnection();
$userRS = $db->query("SELECT * FROM pineapple_user WHERE user_id='{$user_id}' LIMIT 1");
if (!$userRS) {
$db->close();
$result->outputErrResult('004');
}
$userObj = $userRS->fetch_object();
if ($userObj == NULL) {
$db->close();
$result->outputErrResult('004');
}
$retObj = new stdClass();
$retObj->user = $userObj->user_name;
$retObj->email = $userObj->email;
$retObj->email_active = $userObj->email_active;
$retObj->mobile_phone = $userObj->mobile_phone;
public function parse($token)
{
// 使用-将token拆成两段
// [0]:info
// [1]:userid
$token_array = explode('-', $token);
// 规则规定，token_array必将是长度为2的数组
if (2 != count($token_array)) {
$this->error = 05;
return false;
}
// 使用.拆分第一段
// [0]:类型
// [1]:校验字符串
// [2]:timeout
// [3]:timegen
// [4]:ticket
$token_info = explode('.', $token_array[0]);
// 规则规定，token_info必将是长度5的数组
if (5 != count($token_info)) {
$this->error = 05;
return false;
}
// 进行token的md5校验
$verifystring = $token_array[1] . $token_info[4] . TOKEN_GEN_SEED;
if (md5($verifystring) != $token_info[1]) {
$this->error = 05;
return false;
}
// 查询token是否匹配
$db = new WebTrainDBConnection();
if ($result = $db->query('SELECT token,email_token FROM pineapple_user WHERE user_id=' . $token_array[1])) {
if ($result->num_rows == 0) {
$result->close();
$db->close();
$this->error = 05;
return false;
}
$obj = $result->fetch_object();
if ($token_info[0] == NORMAL_TOKEN) {
$res_token = $obj->token;
} elseif ($token_info[0] == EMAIL_TOKEN) {
$res_token = $obj->email_token;
} else {
$result->close();
$db->close();
$this->error = 05;
return false;
}
if ($token != $res_token) {
$result->close();
$db->close();
$this->error = 05;
return false;
}
$result->close();
} else {
$db->close();
$this->error = 04;
return false;
}
$db->close();
// 检查是否超时
$outoftime = $token_info[3] + $token_info[2];
$currenttime = @gmmktime();
if ($currenttime > $outoftime) {
$this->error = 05;
return false;
}
// 完整过滤，填充信息
$this->m_type = $token_info[0];
$this->m_timeout = $token_info[2];
$this->m_timegen = $token_info[3];
$this->m_ticket = $token_info[4];
$this->m_userid = $token_array[1];
$this->error = 0;
return true;
}
$img_size = 17.25;
//生成图片大小 500*500
$margin = 2;
//生成二维码图片
echo QRcode::png($url, false, $errorCorrectionLevel, $img_size, $margin);
exit;
break;
/*********************************************************************************************************************************/
/*********************************************************************************************************************************/
case 'editable':
if (!array_key_exists('lesson_id', $_GET)) {
$result->outputErrResult('001');
}
$lesson_id = $_GET['lesson_id'];
//检查是否可编辑，通过审核则不可删除
$db = new WebTrainDBConnection();
$lessonRS = $db->query("SELECT * FROM lesson WHERE lesson_id='{$lesson_id}' LIMIT 1");
if ($lessonRS == FALSE) {
$db->close();
$result->outputErrResult('004');
}
$lessonObj = $lessonRS->fetch_object();
if ($lessonObj == NULL) {
$db->close();
$result->outputErrResult('301');
}
$retObj = new WebTrainDBConnection();
$retObj->active = $lessonObj->active;
$result->outputResult($retObj);
break;
default:
* 行业信息关键字搜索
*/
/*
* 行业信息关键字搜索
*/
case 'searchNews':
if (!array_key_exists('keyword', $_GET) || !array_key_exists('start', $_GET) || !array_key_exists('count', $_GET)) {
$result->outputErrResult('001');
}
$count = $_GET['count'];
$start = $_GET['start'];
$keyword = $_GET['keyword'];
if (empty($_GET['keyword'])) {
$keyword = '.';
}
$db = new WebTrainDBConnection();
$retObj = new stdClass();
//查询总数量
$countRS = $db->query("SELECT COUNT(news_id) AS tcount FROM news WHERE news_title REGEXP '{$keyword}' AND active=1");
if ($countRS == FALSE) {
$db->close();
$result->outputErrResult('004');
}
$countObj = $countRS->fetch_object();
$retObj->tcount = $countObj->tcount;
//查询列表,用户列表按照更新时间倒序，news_id倒序
$newsList = $db->query("SELECT * FROM news WHERE news_title REGEXP '{$keyword}' ORDER BY update_time DESC,news_id DESC LIMIT {$start},{$count}");
if (!$newsList) {
$db->close();
$result->outputErrResult('004');
}
