コード例 #1
0
 /**
  * 获取某一次课时的具体详情
  * @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;
 }
コード例 #2
0
 /**
  * 获取秦汉胡同老师所教课程的学生评价
  * @param $teacherId
  * @param $evalId
  * @return array
  */
 public function evalTeacherStudent($teacherId, $evalId)
 {
     $data = array();
     try {
         $evaluates = array();
         if ($evalId == 0) {
             $evaluates = Yii::app()->cnhutong_user->createCommand()->select('id, member_id, lesson_student_id, teach_attitude, teach_content, teach_environment, statement, create_ts, teacher_id, teacher_statement, teacher_create_ts')->from('lesson_student_eval')->where('teacher_id = :teacherId', array(':teacherId' => $teacherId))->order('id asc')->limit('10')->queryAll();
         } else {
             $evaluates = Yii::app()->cnhutong_user->createCommand()->select('id, member_id, lesson_student_id, teach_attitude, teach_content, teach_environment, statement, create_ts, teacher_id, teacher_statement, teacher_create_ts')->from('lesson_student_eval')->where('teacher_id = :teacherId And id > :evalId', array(':teacherId' => $teacherId, ':evalId' => $evalId))->order('id asc')->limit('10')->queryAll();
         }
         if (!$evaluates) {
             return 20039;
             // MSG_ERR_FAIL_EVAL
         }
         foreach ($evaluates as $row) {
             $result = array();
             $result['evalId'] = $row['id'];
             $result['studentId'] = $row['member_id'];
             $result['studentName'] = ApiPublicLesson::model()->getNameByMemberId($row['member_id']);
             $courseId = self::getCourseByLessonStudentId($row['lesson_student_id']);
             $subjectId = ApiPublicLesson::model()->getSubjectIdByCourseId($courseId);
             $subjectInfo = ApiPublicLesson::model()->getSubjectInfoById($subjectId);
             $result['studentSubject'] = $subjectInfo['title'];
             $create = date("Y-m-d", strtotime($row['create_ts']));
             $result['studentTime'] = $create;
             $result['studentContent'] = $row['statement'];
             $result['studentCharge'] = number_format(($row['teach_attitude'] + $row['teach_content'] + $row['teach_environment']) / 3, 1);
             $result['teacherReplyContent'] = $row['teacher_statement'];
             if (!$row['teacher_statement']) {
                 $replyTime = '';
             } else {
                 $replyTime = date("Y-m-d", strtotime($row['teacher_create_ts']));
             }
             $result['teacherReplyTime'] = $replyTime;
             $data['evaluates'][] = $result;
         }
     } catch (Exception $e) {
         error_log($e);
     }
     return $data;
 }
コード例 #3
0
 /**
  * 学员请假插入数据记录
  * @param $memberId
  * @param $lessonStudentId
  * @return int
  */
 public function insertLeave($memberId, $lessonStudentId)
 {
     $nowTime = date('Y-m-d H:m:s');
     $data = 0;
     try {
         $departmentId = ApiPublicLesson::model()->getDepartmentId($memberId, $lessonStudentId);
         // 获区校区ID
         $data = Yii::app()->cnhutong->createCommand()->insert('ht_reminder', array('member_id' => $memberId, 'item_type' => 7, 'item_id' => $lessonStudentId, 'create_time' => $nowTime, 'step' => 0, 'to_member_id' => 0, 'department_id' => $departmentId));
     } catch (Exception $e) {
         error_log($e);
     }
     return $data;
 }