123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106 |
- <?php //$id:$
- /**
- * File containing the declaration of the learnpathList class.
- * @package dokeos.learnpath
- * @author Yannick Warnier <ywarnier@beeznest.org>
- */
- /**
- * This class is only a learning path list container with several practical methods for sorting the list and
- * provide links to specific paths
- * @uses Database.lib.php to use the database
- * @uses learnpath.class.php to generate learnpath objects to get in the list
- */
- class learnpathList {
- var $list = array(); //holds a flat list of learnpaths data from the database
- var $ref_list = array(); //holds a list of references to the learnpaths objects (only filled by get_refs())
- var $alpha_list = array(); //holds a flat list of learnpaths sorted by alphabetical name order
- var $course_code;
- var $user_id;
- var $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 Optional course code (otherwise we use api_get_course_id())
- * @return void
- */
- function learnpathList($user_id,$course_code='') {
- if(!empty($course_code)){
- //proceed with course code given
- }else{
- $course_code = api_get_course_id();
- $lp_table = Database::get_course_table('lp');
- }
- $this->course_code = $course_code;
- $this->user_id = $user_id;
- $sql = "SELECT * FROM $lp_table ORDER BY display_order ASC, name ASC";
- $res = api_sql_query($sql);
- $names = array();
- while ($row = Database::fetch_array($res))
- {
- //check if published
- $pub = '';
- $tbl_tool = Database::get_course_table(TABLE_TOOL_LIST);
- //use domesticate here instead of mysql_real_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'];
- $sql2="SELECT * FROM $tbl_tool where (name='$myname' and image='scormbuilder.gif' and link LIKE '$mylink%')";
- //error_log('New LP - learnpathList::learnpathList - getting visibility - '.$sql2,0);
- $res2 = api_sql_query($sql2,__FILE__,__LINE__);
- 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']);
-
- $this->list[$row['id']] = array(
- 'lp_type' => $row['lp_type'],
- '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' => $row['default_encoding'],
- 'lp_visibility' => $vis,
- 'lp_published' => $pub,
- 'lp_prevent_reinit' => $row['prevent_reinit'],
- 'lp_scorm_debug' => $row['debug'],
- 'lp_display_order' => $row['display_order'],
- 'lp_preview_image' => stripslashes($row['preview_image'])
- );
- $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
- */
- 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]=>...)
- */
- function get_flat_list()
- {
- return $this->list;
- }
- }
- ?>
|