<?php /* For licensing terms, see /license.txt */ $config = new \Doctrine\ORM\Configuration(); $config->setMetadataCacheImpl(new \Doctrine\Common\Cache\ArrayCache()); use Doctrine\Common\Annotations\AnnotationReader; use Doctrine\Common\Annotations\AnnotationRegistry; use Symfony\Component\Yaml\Parser; AnnotationRegistry::registerFile(api_get_path(SYS_PATH) . "vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/DoctrineAnnotations.php"); $reader = new AnnotationReader(); $driverImpl = new \Doctrine\ORM\Mapping\Driver\AnnotationDriver($reader, array(api_get_path(SYS_PATH) . "tests/doctrine_console/mapping")); $config->setMetadataDriverImpl($driverImpl); $config->setProxyDir(__DIR__ . '/Proxies'); $config->setProxyNamespace('Proxies'); $courseList = CourseManager::get_real_course_list(); //$courseList = array(); $configurationPath = api_get_path(SYS_PATH) . 'main/inc/conf/'; $newConfigurationFile = $configurationPath . 'configuration.yml'; if (is_file($newConfigurationFile) && file_exists($newConfigurationFile)) { $yaml = new Parser(); $_configuration = $yaml->parse(file_get_contents($newConfigurationFile)); } $connectionOptions = array(); if (!empty($courseList)) { $dbPrefix = isset($_configuration['db_prefix']) && !empty($_configuration['db_prefix']) ? $_configuration['db_prefix'] . Database::get_database_glue() : null; foreach ($courseList as $course) { $connectionOptions['_chamilo_course_' . $course['db_name']] = array('driver' => 'pdo_mysql', 'dbname' => $dbPrefix . $course['db_name'], 'user' => $_configuration['db_user'], 'password' => $_configuration['db_password'], 'host' => $_configuration['db_host']); } } if (isset($_configuration['main_database'])) { $connectionOptions['main_database'] = array('driver' => 'pdo_mysql', 'dbname' => $_configuration['main_database'], 'user' => $_configuration['db_user'], 'password' => $_configuration['db_password'], 'host' => $_configuration['db_host']);
function reports_template_CourseArticulate_getSQL() { // settings // Nom, prenom $query = 'select u.lastname as "Last name", u.firstname as "First name" '; $query .= 'from ' . Database::get_main_table(TABLE_MAIN_USER) . ' u '; $query .= ' where u.user_id in (' . reports_getVisibilitySQL() . ') '; $query .= ' order by u.user_id '; $queries[0] = $query; // Custom Field foreach (array("tags" => "tags") as $k => $v) { // FIXME $query = 'select ufv.field_value as "' . $v . '" '; $query .= 'from ' . Database::get_main_table(TABLE_MAIN_USER) . ' u '; $query .= 'left join' . Database::get_main_table(TABLE_MAIN_USER_FIELD) . ' uf '; $query .= ' on uf.field_variable="' . $k . '" '; $query .= 'left outer join ' . Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES) . ' ufv '; $query .= ' on ufv.user_id = u.user_id and ufv.field_id = uf.id '; $query .= 'where u.user_id in (' . reports_getVisibilitySQL() . ') '; $query .= ' order by u.user_id '; $queries[] = $query; } // Stored Value $sv = array(); foreach ($sv as $k => $v) { if (!isset($v['sql'])) { $v['sql'] = 'FIELD'; } $sqlField = str_replace('FIELD', 'sv.sv_value', $v['sql']); $query = 'select ' . $sqlField . ' as "' . $v['title'] . '" '; // $query = 'select sec_to_time(sv.sv_value) as "'.$v.'" '; $query .= 'from ' . Database::get_main_table(TABLE_MAIN_USER) . ' u '; $query .= ' left outer join ' . Database::get_main_table(TABLE_TRACK_STORED_VALUES) . ' sv '; $query .= 'on sv.user_id = u.user_id and sv_key = "' . $k . '" '; $query .= ' where u.user_id in (' . reports_getVisibilitySQL() . ') '; $query .= ' group by u.user_id '; $query .= ' order by u.user_id '; $queries[] = $query; } // first and last connection $query = 'select min(tel.login_date) as "First connection", max(tel.logout_date) as "Latest connection" '; $query .= 'from ' . Database::get_main_table(TABLE_MAIN_USER) . ' u '; $query .= 'left outer join ' . Database::get_main_table(TABLE_STATISTIC_TRACK_E_LOGIN) . ' tel '; $query .= ' on tel.login_user_id = u.user_id '; $query .= ' where u.user_id in (' . reports_getVisibilitySQL() . ') '; $query .= ' group by u.user_id '; $query .= ' order by u.user_id '; $queries[] = $query; // SCORM Data $scormData = array(); $course_list = CourseManager::get_real_course_list(); foreach ($course_list as $code => $details) { $list = Database::query('SELECT l.id as lid, l.name as lname, li.id as liid, li.title as lititle ' . ' FROM ' . Database::get_course_table(TABLE_LP_MAIN) . ' l, ' . Database::get_course_table(TABLE_LP_ITEM) . ' li ' . ' WHERE l.c_id = ' . $details['real_id'] . ' AND li.c_id = ' . $details['real_id'] . ' AND l.id = li.lp_id'); while ($lpItem = Database::fetch_assoc($list)) { $scormData[] = array('coursedb' => $details['db_name'], 'lid' => $lpItem['lid'], 'liid' => $lpItem['liid'], 'target_view_count' => 1, 'target_indicator' => 'score', 'title' => $details['title'] . '/' . $lpItem['lname'] . '/' . $lpItem['lititle'] . '/1/score', 'sql' => 'FIELD'); $scormData[] = array('coursedb' => $details['db_name'], 'lid' => $lpItem['lid'], 'liid' => $lpItem['liid'], 'target_view_count' => 2, 'target_indicator' => 'score', 'title' => $details['title'] . '/' . $lpItem['lname'] . '/' . $lpItem['lititle'] . '/2/score', 'sql' => 'FIELD'); $scormData[] = array('coursedb' => $details['db_name'], 'lid' => $lpItem['lid'], 'liid' => $lpItem['liid'], 'target_view_count' => null, 'target_indicator' => 'score', 'title' => $details['title'] . '/' . $lpItem['lname'] . '/' . $lpItem['lititle'] . '/all/score', 'sql' => 'avg(FIELD)'); } } foreach ($scormData as $v) { if (!isset($v['sql'])) { $v['sql'] = 'FIELD'; } $sqlField = str_replace('FIELD', $v['target_indicator'], $v['sql']); $query = 'select ' . $sqlField . ' as "' . $v['title'] . '" '; $query .= 'from ' . Database::get_main_table(TABLE_MAIN_USER) . ' u '; $query .= 'left outer join ' . Database::get_course_table(TABLE_LP_VIEW, $details['db_name']) . ' lv '; $query .= ' on u.user_id = lv.user_id and lv.lp_id = ' . $v['lid']; $query .= ' left outer join ' . Database::get_course_table(TABLE_LP_ITEM_VIEW, $details['db_name']) . ' liv '; $query .= ' on lv.id = liv.lp_view_id '; if ($v['target_view_count']) { $query .= ' and liv.view_count = ' . $v['target_view_count']; } $query .= ' and liv.lp_item_id = ' . $v['liid'] . ' '; $query .= ' where u.user_id in (' . reports_getVisibilitySQL() . ') '; $query .= ' group by u.user_id '; $query .= ' order by u.user_id '; $queries[] = $query; } return $queries; }
/** * This code creates a select form element to let the user * choose a real course to link to. * * We display the course code, but internally store the course id. */ function display_real_course_code_select($element_name) { $real_course_list = CourseManager::get_real_course_list(); echo "<select name=\"{$element_name}\" size=\"" . SELECT_BOX_SIZE . "\" >\n"; foreach ($real_course_list as $real_course) { $course_code = $real_course["code"]; echo "<option value=\"" . $course_code . "\">"; echo $course_code; echo "</option>\n"; } echo "</select>\n"; }
foreach ($courses_by_teacher as $course) { $students_by_course = array_keys(CourseManager::get_student_list_from_course_code($course['real_id'])); if (count($students_by_course) > 0) { foreach ($students_by_course as $student_by_course) { $students[] = $student_by_course; } } } } if (!empty($students)) { $students = array_unique($students); } } else { $students = array_keys(UserManager::get_users_followed_by_drh(api_get_user_id(), STUDENT)); } $courses_of_the_platform = CourseManager::get_real_course_list(); foreach ($courses_of_the_platform as $course) { $courses[$course['code']] = $course['code']; } } } else { if (empty($session_id)) { //Getting courses $courses = CourseManager::get_course_list_as_coach($coach_id, false); if (isset($courses[0])) { $courses = $courses[0]; } //Getting students $students = CourseManager::get_user_list_from_courses_as_coach($coach_id); } else { $students = Tracking::get_student_followed_by_coach_in_a_session($session_id, $coach_id);