public function getAds() { $data = array(); try { $result = Yii::app()->cnhutong_user->createCommand()->select('id, picture, text, link')->from('com_ads')->queryAll(); // 判断数据是否为空数组 if (ApiPublicController::array_is_null($result)) { $data[] = []; } foreach ($result as $row) { $ads = array(); $ads['adPicture'] = $row['picture']; $ads['adContent'] = $row['text']; $ads['adUrl'] = $row['link']; $data[] = $ads; } } catch (Exception $e) { error_log($e); } return $data; }
public function getAppVersion() { $data = array(); try { $result = Yii::app()->cnhutong_user->createCommand()->select('id, last_version, new_version, download')->from('com_channel')->queryAll(); // 判断数据是否为空数组 if (ApiPublicController::array_is_null($result)) { $data[] = []; } foreach ($result as $row) { $version = array(); $version['lastVersion'] = $row['last_version']; $version['updateVersion'] = $row['new_version']; $version['downloadUrl'] = $row['download']; $data[] = $version; } } catch (Exception $e) { error_log($e); } return $data; }
/** * 获取某一次课时的具体详情 * @param $userId -- 用户ID * @param $token -- 用户验证token * @param $memberId -- 用户当前绑定的学员所对应的ID * @param $lessonStudentId -- 课时唯一编号 * @return array|int */ public function lessonDetails($userId, $token, $memberId, $lessonStudentId) { $data = array(); try { // 用户ID验证 $user = User::model()->IsUserId($userId); if (!$user) { return 10010; // MSG_ERR_FAIL_USER } // 用户token验证 $userToken = UserToken::model()->IsToken($userId, $token); // var_dump($userToken);exit; if (!$userToken) { return 10009; // MSG_ERR_FAIL_TOKEN } $isExistUserMemberId = UserMember::model()->IsExistMemberId($userId, $memberId); if (!$isExistUserMemberId) { return 40003; // MSG_ERR_FAIL_MEMBER } $isLessonStudentId = self::IsLessonStudentId($memberId, $lessonStudentId); if (!$isLessonStudentId) { return 60002; } $result = Yii::app()->cnhutong->createCommand()->select('id as lessonStudentId, lesson_serial as lessonSerial, date, time, step, teacher_id as teacherId, student_rating, student_comment, lesson_content')->from('ht_lesson_student')->where('student_id = :studentId And id = :id', array(':studentId' => $memberId, ':id' => $lessonStudentId))->order('date')->queryAll(); // 判断数据是否为空数组 if (ApiPublicController::array_is_null($result)) { $data[] = []; } foreach ($result as $row) { // 获取数据 $lessonDetail = array(); $lessonDetail['lessonStudentId'] = $row['lessonStudentId']; $lessonDetail['lessonSerial'] = $row['lessonSerial']; $lessonDetail['lessonDate'] = $row['date'] . ' ' . $row['time']; $lessonDetail['lessonStatus'] = self::getLessonStatus($row['step']); $lessonDetail['teacherId'] = $row['teacherId']; $lessonDetail['teacherName'] = ApiPublicLesson::model()->getNameByMemberId($row['teacherId']); $lessonDetail['lessonScore'] = $row['student_rating']; if (empty($lessonDetail['lessonScore'])) { $lessonDetail['lessonScore'] = ''; } $lessonDetail['lessonCharge'] = $row['student_comment']; $lessonDetail['lessonContent'] = $row['lesson_content']; if (empty($lessonDetail['lessonContent'])) { $lessonDetail['lessonContent'] = ''; } $data[] = $lessonDetail; } // $data = $result; } catch (Exception $e) { error_log($e); } return $data; }
/** * 获取某一次课时的具体详情 * @param $userId -- 用户ID * @param $token -- 用户验证token * @param $memberId -- 用户当前绑定的学员所对应的ID * @param $lessonStudentId -- 课时唯一编号 * @return array|int */ public function lessonDetails($userId, $token, $memberId, $lessonStudentId) { $data = array(); try { // 用户ID验证 $user = User::model()->IsUserId($userId); if (!$user) { return 20008; // MSG_ERR_FAIL_USER } // 用户token验证 $userToken = UserToken::model()->IsToken($userId, $token); // var_dump($userToken);exit; if (!$userToken) { return 20007; // MSG_ERR_FAIL_TOKEN } $isExistUserMemberId = UserMember::model()->IsExistMemberId($userId, $memberId); if (!$isExistUserMemberId) { return 20017; // MSG_ERR_FAIL_MEMBER } $isLessonStudentId = self::IsLessonStudentId($memberId, $lessonStudentId); if (!$isLessonStudentId) { return 20021; } $result = Yii::app()->cnhutong->createCommand()->select('id as lessonStudentId, lesson_serial as lessonSerial, date, time, status_id, step, teacher_id as teacherId, student_rating, student_comment, lesson_content')->from('ht_lesson_student')->where('student_id = :studentId And id = :id', array(':studentId' => $memberId, ':id' => $lessonStudentId))->order('date')->queryAll(); // 判断数据是否为空数组 if (ApiPublicController::array_is_null($result)) { $data[] = []; } foreach ($result as $row) { // 获取数据 $lessonDetail = array(); $lessonDetail['lessonStudentId'] = $row['lessonStudentId']; $lessonDetail['lessonSerial'] = $row['lessonSerial']; $lessonDetail['lessonDate'] = $row['date'] . ' ' . $row['time']; // $lessonDetail['lessonStatus'] = self::getLessonStatusNow($row['step']); $lessonDetail['lessonStatus'] = self::lessonStatus($row['step'], $row['status_id'], $row['student_rating']); // 此课程状态和课程表的课时状态保持一致;状态为3表示未上,可以请假,其他状态都不可请假 $lessonDetail['teacherId'] = $row['teacherId']; $lessonDetail['teacherName'] = ApiPublicLesson::model()->getNameByMemberId($row['teacherId']); // $lessonDetail['lessonScore'] = $row['student_rating']; $eval = Yii::app()->cnhutong_user->createCommand()->select('teach_attitude, teach_content, teach_environment, statement')->from('lesson_student_eval')->where('member_id = :memberId And lesson_student_id = :lessonStudentId', array(':memberId' => $memberId, ':lessonStudentId' => $lessonStudentId))->queryRow(); $lessonDetail['teachAttitude'] = isset($eval['teach_attitude']) ? $eval['teach_attitude'] : ''; $lessonDetail['teachContent'] = isset($eval['teach_content']) ? $eval['teach_content'] : ''; $lessonDetail['teachEnvironment'] = isset($eval['teach_environment']) ? $eval['teach_environment'] : ''; $lessonDetail['lessonCharge'] = isset($eval['statement']) ? $eval['statement'] : ''; // $lessonDetail['lessonCharge'] = $row['student_comment']; $lessonDetail['lessonContent'] = $row['lesson_content']; if (empty($lessonDetail['lessonContent'])) { $lessonDetail['lessonContent'] = ''; } // 课时状态数组 aStatus $aStatus = array(1, 2, 4, 5); if (in_array($lessonDetail['lessonStatus'], $aStatus)) { $step = 4; } elseif ($lessonDetail['lessonStatus'] == 1) { $leave = self::getHtReminder($memberId, $lessonStudentId); $step = $leave['step']; } $lessonDetail['step'] = $step; $data[] = $lessonDetail; } // $data = $result; } catch (Exception $e) { var_dump($e); error_log($e); } return $data; }