protected function getCourseByName($courses_name)
{
if (!$this->courseNamesToIds) {
$constraints = array('return_objects' => false);
$courses = EfrontCourse::getAllCourses($constraints);
foreach ($courses as $course) {
if (!isset($this->courseNamesToIds[$course['name']])) {
$this->courseNamesToIds[$course['name']] = array($course['id']);
} else {
$this->courseNamesToIds[$course['name']][] = $course['id'];
}
}
}
return $this->courseNamesToIds[$courses_name];
}
private function getRssSource($source, $mode, $lesson)
{
$feeds = $this->getProvidedFeeds();
foreach ($feeds as $value) {
if ($value['active'] && $value['mode'] == 'system') {
$systemFeeds[$value['type']] = $value;
} else {
if ($value['active'] && $value['mode'] == 'lesson') {
$lessonFeeds[$value['type']] = $value;
}
}
}
if ($mode == 'system' && !in_array($source, array_keys($systemFeeds))) {
return array();
} elseif ($mode == 'lesson' && !in_array($source, array_keys($lessonFeeds))) {
return array();
}
$data = array();
switch ($source) {
case 'announcements':
if ($mode == 'system') {
$news = news::getNews(0, true);
} elseif ($mode == 'lesson') {
if ($lesson) {
$news = news::getNews($lesson, true);
} else {
$lessons = eF_getTableDataFlat("lessons", "id, name");
$lessonNames = array_combine($lessons['id'], $lessons['name']);
$news = news::getNews($lessons['id'], true);
}
}
$count = 1;
foreach ($news as $value) {
if ($mode == 'lesson' && !$lesson) {
$value['title'] = $lessonNames[$value['lessons_ID']] . ': ' . $value['title'];
$link = G_SERVERNAME . 'userpage.php?lessons_ID=' . $value['lessons_ID'] . '&ctg=news&view=' . $value['id'];
} else {
$link = G_SERVERNAME . 'userpage.php?ctg=news&view=' . $value['id'];
}
$data[] = array('title' => $value['title'], 'link' => $link, 'description' => $value['data']);
/*
if ($count++ == $this -> feedLimit) {
break;
}
*/
}
break;
case 'catalog':
$constraints = array("return_objects" => false, 'archive' => false, 'active' => true);
$result = EfrontCourse::getAllCourses($constraints);
$directionsTree = new EfrontDirectionsTree();
$directionPaths = $directionsTree->toPathString();
foreach ($result as $value) {
$pathString = $directionPaths[$value['directions_ID']] . ' → ' . $value['name'];
$data[] = array('title' => $pathString, 'link' => G_SERVERNAME . 'index.php?ctg=lesson_info&courses_ID=' . $value['id'], 'description' => implode("<br>", unserialize($value['info'])));
}
$result = eF_getTableData("lessons", "id,name,directions_ID, info", "archive=0 and instance_source = 0 and active=1 and course_only=0", "name");
foreach ($result as $value) {
$pathString = $directionPaths[$value['directions_ID']] . ' → ' . $value['name'];
$data[] = array('title' => $pathString, 'link' => G_SERVERNAME . 'index.php?ctg=lesson_info&lessons_ID=' . $value['id'], 'description' => implode("<br>", unserialize($value['info'])));
}
$data = array_values(eF_multisort($data, 'title', 'asc'));
//Sort results based on path string
break;
case 'calendar':
if ($mode == 'system') {
$events = calendar::getGlobalCalendarEvents();
} elseif ($mode == 'lesson') {
if ($lesson) {
$events = calendar::getLessonCalendarEvents($lesson);
} else {
$events = calendar::getCalendarEventsForAllLessons();
}
}
foreach ($events as $value) {
$value['name'] ? $title = formatTimestamp($value['timestamp']) . ' (' . $value['name'] . ')' : ($title = formatTimestamp($value['timestamp']));
$data[] = array('title' => $title, 'link' => G_SERVERNAME . 'userpage.php?ctg=calendar&view_calendar=' . $value['timestamp'] . '&type=0', 'description' => $value['data']);
}
break;
/*
case 'history':
$currentUser = $this -> getCurrentUser();
$eventObjects = array();
$result = eF_getTableData("events", "*", "", "timestamp DESC limit 100");
foreach ($result as $value) {
$eventObject = new EfrontEvent($value);
$eventObject -> createMessage();
pr($eventObject);
}
break;
*/
/*
case 'history':
$currentUser = $this -> getCurrentUser();
$eventObjects = array();
$result = eF_getTableData("events", "*", "", "timestamp DESC limit 100");
foreach ($result as $value) {
$eventObject = new EfrontEvent($value);
$eventObject -> createMessage();
pr($eventObject);
}
break;
*/
case 'structure':
if ($lesson) {
$contentTree = new EfrontContentTree($lesson);
$contentPath = $contentTree->toPathStrings();
foreach ($contentPath as $key => $value) {
$data[] = array('title' => $value, 'link' => G_SERVERNAME . 'userpage.php?lessons_ID=' . $lesson . '&unit=' . $key, 'description' => $value);
}
}
break;
case 'forum':
if ($mode == 'system') {
$result = eF_getTableData("f_messages fm JOIN f_topics ft JOIN f_forums ff LEFT OUTER JOIN lessons l ON ff.lessons_ID = l.id", "ff.title as forum_name, fm.body, fm.title, fm.id, ft.id as topic_id, ft.title as topic_title, fm.users_LOGIN, fm.timestamp, l.name as lessons_name, lessons_id as show_lessons_id", "ft.f_forums_ID=ff.id AND fm.f_topics_ID=ft.id ", "fm.timestamp desc LIMIT 100");
} elseif ($mode == 'lesson') {
if ($lesson) {
$result = eF_getTableData("f_messages fm JOIN f_topics ft JOIN f_forums ff LEFT OUTER JOIN lessons l ON ff.lessons_ID = l.id", "ff.title as forum_name, fm.body, fm.title, fm.id, ft.id as topic_id, ft.title as topic_title, fm.users_LOGIN, fm.timestamp, l.name as lessons_name, lessons_id as show_lessons_id", "ft.f_forums_ID=ff.id AND fm.f_topics_ID=ft.id AND ff.lessons_ID = '" . $lesson . "'", "fm.timestamp desc LIMIT 100");
} else {
$result = eF_getTableData("f_messages fm JOIN f_topics ft JOIN f_forums ff LEFT OUTER JOIN lessons l ON ff.lessons_ID = l.id", "ff.title as forum_name, fm.body, fm.title, fm.id, ft.id as topic_id, ft.title as topic_title, fm.users_LOGIN, fm.timestamp, l.name as lessons_name, lessons_id as show_lessons_id", "ft.f_forums_ID=ff.id AND fm.f_topics_ID=ft.id AND ff.lessons_ID != 0", "fm.timestamp desc LIMIT 100");
}
}
foreach ($result as $value) {
$value['title'] = $value['forum_name'] . ' >> ' . $value['topic_title'] . ' >> ' . $value['title'];
if ($mode == 'system' && $value['lessons_name'] || $mode == 'lesson' && !$lesson) {
$value['title'] = $value['lessons_name'] . ': ' . $value['title'];
}
$data[] = array('title' => $value['title'], 'link' => G_SERVERNAME . 'userpage.php?ctg=forum&topic=' . $value['topic_id'], 'description' => $value['body']);
}
break;
default:
break;
}
return $data;
}
//Assign this form to the renderer, so that corresponding template code is created
$smarty->assign('T_IMPORT_COURSE_FORM', $renderer->toArray());
//Assign the form to the template
/** Calculate and display course ajax lists*/
$sortedColumns = array('name', 'location', 'num_students', 'num_skills', 'start_date', 'end_date', 'price', 'created', 'active', 'operations');
$smarty->assign("T_DATASOURCE_SORT_BY", array_search('active', $sortedColumns));
$smarty->assign("T_DATASOURCE_SORT_ORDER", 'desc');
$smarty->assign("T_DATASOURCE_OPERATIONS", array('statistics', 'settings', 'delete'));
$smarty->assign("T_DATASOURCE_COLUMNS", $sortedColumns);
if ($_GET['ajax'] == 'coursesTable' || $_GET['ajax'] == 'instancesTable') {
try {
if ($_GET['ajax'] == 'coursesTable') {
$constraints = createConstraintsFromSortedTable() + array('archive' => false, 'instance' => false);
}
if ($_GET['ajax'] == 'instancesTable' && eF_checkParameter($_GET['instancesTable_source'], 'id')) {
$constraints = createConstraintsFromSortedTable() + array('archive' => false, 'instance' => $_GET['instancesTable_source']);
}
$constraints['required_fields'] = array('has_instances', 'location', 'num_students', 'num_lessons', 'num_skills');
$courses = EfrontCourse::getAllCourses($constraints);
$totalEntries = EfrontCourse::countAllCourses($constraints);
$dataSource = EfrontCourse::convertCourseObjectsToArrays($courses);
$smarty->assign("T_TABLE_SIZE", $totalEntries);
$tableName = $_GET['ajax'];
$alreadySorted = 1;
include "sorted_table.php";
} catch (Exception $e) {
handleAjaxExceptions($e);
}
}
}
}
echo "<currency>" . $GLOBALS['configuration']['currency'] . "</currency>";
echo "</price>";
echo "</lesson>";
}
echo "</lessons>";
echo "</xml>";
} else {
echo "<xml>";
echo "<status>error</status>";
echo "<message>Invalid token</message>";
echo "</xml>";
}
break;
case 'courses':
if (isset($_GET['token']) && checkToken($_GET['token'])) {
$courses = EfrontCourse::getAllCourses();
echo "<xml>";
echo "<courses>";
foreach ($courses as $key => $course) {
echo "<course>";
echo "<id>" . $course->course['id'] . "</id>";
echo "<name>" . $course->course['name'] . "</name>";
echo "<active>" . $course->course['active'] . "</active>";
echo "<show_catalog>" . $course->course['show_catalog'] . "</show_catalog>";
echo "<language>" . $course->course['languages_NAME'] . "</language>";
echo "<direction>" . $course->course['directions_ID'] . "</direction>";
echo "<price>";
echo "<value>" . $course->course['price'] . "</value>";
echo "<currency>" . $GLOBALS['configuration']['currency'] . "</currency>";
echo "</price>";
echo "<reset>" . $course->course['reset'] . "</reset>";
