* */ class LearnpathList { // Holds a flat list of learnpaths data from the database. public $list = array(); // Holds a list of references to the learnpaths objects (only filled by get_refs()). public $ref_list = array(); // Holds a flat list of learnpaths sorted by alphabetical name order. public $alpha_list = array(); public $course_code; public $user_id; public $refs_active = false; /** * This method is the constructor for the learnpathList. It gets a list of available learning paths from * the database and creates the learnpath objects. This list depends on the user that is connected * (only displays) items if he has enough permissions to view them. * @param integer $user_id * @param string $course_code Optional course code (otherwise we use api_get_course_id()) * @param int $session_id Optional session id (otherwise we use api_get_session_id()) * @param string $order_by * @param string $check_publication_dates * @param int $categoryId * @param bool $ignoreCategoryFilte * * @return void */ public function __construct( $user_id, $course_code = '', $session_id = null, $order_by = null, $check_publication_dates = false, $categoryId = null, $ignoreCategoryFilter = false ) { $course_info = api_get_course_info($course_code); $lp_table = Database::get_course_table(TABLE_LP_MAIN); $tbl_tool = Database::get_course_table(TABLE_TOOL_LIST); $this->course_code = $course_code; $this->user_id = $user_id; $course_id = $course_info['real_id']; if (empty($course_id)) { return false; } // Condition for the session. if (isset($session_id)) { $session_id = intval($session_id); } else { $session_id = api_get_session_id(); } $condition_session = api_get_session_condition($session_id, true, true); $order = "ORDER BY display_order ASC, name ASC"; if (isset($order_by)) { $order = Database::parse_conditions(array('order' => $order_by)); } $now = api_get_utc_datetime(); $time_conditions = ''; if ($check_publication_dates) { $time_conditions = " AND ( (publicated_on <> '0000-00-00 00:00:00' AND publicated_on < '$now' AND expired_on <> '0000-00-00 00:00:00' AND expired_on > '$now' ) OR (publicated_on <> '0000-00-00 00:00:00' AND publicated_on < '$now' AND expired_on = '0000-00-00 00:00:00') OR (publicated_on = '0000-00-00 00:00:00' AND expired_on <> '0000-00-00 00:00:00' AND expired_on > '$now') OR (publicated_on = '0000-00-00 00:00:00' AND expired_on = '0000-00-00 00:00:00' )) "; } $categoryFilter = ''; if ($ignoreCategoryFilter == false) { if (!empty($categoryId)) { $categoryId = intval($categoryId); $categoryFilter = " AND category_id = $categoryId"; } else { $categoryFilter = " AND (category_id = 0 OR category_id IS NULL) "; } } $sql = "SELECT * FROM $lp_table WHERE c_id = $course_id $time_conditions $condition_session $categoryFilter $order "; $res = Database::query($sql); $names = array(); while ($row = Database::fetch_array($res,'ASSOC')) { // Use domesticate here instead of Database::escape_string because // it prevents ' to be slashed and the input (done by learnpath.class.php::toggle_visibility()) // is done using domesticate() $myname = domesticate($row['name']); $mylink = 'newscorm/lp_controller.php?action=view&lp_id='.$row['id'].'&id_session='.$session_id; $sql2 = "SELECT * FROM $tbl_tool WHERE c_id = $course_id AND ( name='$myname' AND image='scormbuilder.gif' AND link LIKE '$mylink%' )"; $res2 = Database::query($sql2); if (Database::num_rows($res2) > 0) { $row2 = Database::fetch_array($res2); $pub = $row2['visibility']; } else { $pub = 'i'; } // Check if visible. $vis = api_get_item_visibility( api_get_course_info($course_code), 'learnpath', $row['id'], $session_id ); if (!empty($row['created_on']) && $row['created_on'] != '0000-00-00 00:00:00') { $row['created_on'] = $row['created_on']; } else { $row['created_on'] = ''; } if (!empty($row['modified_on']) && $row['modified_on'] != '0000-00-00 00:00:00') { $row['modified_on'] = $row['modified_on']; } else { $row['modified_on'] = ''; } if (!empty($row['publicated_on']) && $row['publicated_on'] != '0000-00-00 00:00:00') { $row['publicated_on'] = $row['publicated_on']; } else { $row['publicated_on'] = ''; } if (!empty($row['expired_on']) && $row['expired_on'] != '0000-00-00 00:00:00') { $row['expired_on'] = $row['expired_on']; } else { $row['expired_on'] = ''; } $this->list[$row['id']] = array( 'lp_type' => $row['lp_type'], 'lp_session' => $row['session_id'], 'lp_name' => stripslashes($row['name']), 'lp_desc' => stripslashes($row['description']), 'lp_path' => $row['path'], 'lp_view_mode' => $row['default_view_mod'], 'lp_force_commit' => $row['force_commit'], 'lp_maker' => stripslashes($row['content_maker']), 'lp_proximity' => $row['content_local'], 'lp_encoding' => api_get_system_encoding(), 'lp_visibility' => $vis, 'lp_published' => $pub, 'lp_prevent_reinit' => $row['prevent_reinit'], 'seriousgame_mode' => $row['seriousgame_mode'], 'lp_scorm_debug' => $row['debug'], 'lp_display_order' => $row['display_order'], 'lp_preview_image' => stripslashes($row['preview_image']), 'autolaunch' => $row['autolaunch'], 'session_id' => $row['session_id'], 'created_on' => $row['created_on'], 'modified_on' => $row['modified_on'], 'publicated_on' => $row['publicated_on'], 'expired_on' => $row['expired_on'], //'category_id' => $row['category_id'], 'subscribe_users' => $row['subscribe_users'], ); $names[$row['name']] = $row['id']; } $this->alpha_list = asort($names); } /** * Gets references to learnpaths for all learnpaths IDs kept in the local list. * This applies a transformation internally on list and ref_list and returns a copy of the refs list * @return array List of references to learnpath objects */ public function get_refs() { foreach ($this->list as $id => $dummy) { $this->ref_list[$id] = new learnpath($this->course_code, $id, $this->user_id); } $this->refs_active = true; return $this->ref_list; } /** * Gets a table of the different learnpaths we have at the moment * @return array Learnpath info as [lp_id] => ([lp_type]=> ..., [lp_name]=>...,[lp_desc]=>...,[lp_path]=>...) */ public function get_flat_list() { return $this->list; } /** * Gets a list of lessons of the given course_code and session_id * This functions doesn't need user_id * @param string $course_code Text code of the course * @param int $session_id Id of session * @return array List of lessons with lessons id as keys */ public static function get_course_lessons($course_code, $session_id) { $tbl_course_lp = Database::get_course_table(TABLE_LP_MAIN); $course = api_get_course_info($course_code); // @todo AND session_id = %s ? $sql = "SELECT * FROM $tbl_course_lp WHERE c_id = %s "; $sql_query = sprintf($sql, $course['real_id']); $result = Database::query($sql_query); $lessons = array(); while ($row = Database::fetch_array($result)) { if (api_get_item_visibility($course, 'learnpath', $row['id'], $session_id)) { $lessons[$row['id']] = $row; } } return $lessons; } }