public function getCourse(Slide $slide) { $result = $this->_access->getRow($this->_access->prepare("SELECT * FROM " . StudyPressDB::getTableNameLesson() . " WHERE " . StudyPressDB::COL_ID_ACTIVITY . " = '%d'", $slide->courseId())); return LessonManager::returnedLesson($result); }
public function getActivitiesOfCourse($courseId) { $activities = array(); $result = $this->_access->getResults($this->_access->prepare("SELECT * FROM " . StudyPressDB::getTableNameActivity() . " WHERE " . StudyPressDB::COL_ID_COURSE_ACTIVITY . " = '%d' ORDER BY " . StudyPressDB::COL_ORDER_ACTIVITY . " ASC", $courseId)); foreach ($result as $row) { $activity = array(); if ($row[StudyPressDB::COL_TYPE_ACTIVITY] === "lesson") { $activity = LessonManager::returnedLesson($row); } else { $activity = QuizManager::returnedQuiz($row); } if ($activity) { $activities[] = $activity; } } return $activities; }