/** * 获取某一次课时的具体详情 * @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 $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; }
/** * 学员请假插入数据记录 * @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; }