/*
* 查询对应课程成绩
*/
/*
* 查询对应课程成绩
*/
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;
$retObj->study_ability = $studyObj->study_ability;
$retObj->study_attitube = $studyObj->study_attitube;
$retObj->innovation = $studyObj->innovation;
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;
}
