123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110 |
- <?php // $Id: courses.php 9721 2006-10-25 08:23:18Z grayd0n $
- /*
- ==============================================================================
- Dokeos - elearning and course management software
- Copyright (c) 2004 Dokeos S.A.
- Copyright (c) 2003 Ghent University (UGent)
- Copyright (c) 2001 Universite catholique de Louvain (UCL)
- Copyright (c) various contributors
- For a full list of contributors, see "credits.txt".
- The full license can be read in "license.txt".
- This program is free software; you can redistribute it and/or
- modify it under the terms of the GNU General Public License
- as published by the Free Software Foundation; either version 2
- of the License, or (at your option) any later version.
- See the GNU General Public License for more details.
- Contact: Dokeos, 181 rue Royale, B-1000 Brussels, Belgium, info@dokeos.com
- ==============================================================================
- */
- /**
- ==============================================================================
- * @package dokeos.auth
- * @todo check if unsubscribing from a course WITH group memberships works as it should
- * @todo constants are in uppercase, variables aren't
- ==============================================================================
- */
- /*
- ==============================================================================
- INIT SECTION
- ==============================================================================
- */
- // including the relevant language file
- $langFile = 'courses';
- // including the global file
- include('../inc/global.inc.php');
- $this_section=SECTION_COURSES;
- api_block_anonymous_users();
- /*
- -----------------------------------------------------------
- Libraries
- -----------------------------------------------------------
- */
- include_once(api_get_path(LIBRARY_PATH) . 'debug.lib.inc.php');
- include_once(api_get_path(LIBRARY_PATH) . 'course.lib.php');
- /*
- -----------------------------------------------------------
- Variables
- -----------------------------------------------------------
- */
- $tbl_course = Database::get_main_table(MAIN_COURSE_TABLE);
- $tbl_courses_nodes = Database::get_main_table(MAIN_CATEGORY_TABLE);
- $tbl_courseUser = Database::get_main_table(MAIN_COURSE_USER_TABLE);
- $tbl_user = Database::get_main_table(MAIN_USER_TABLE);
- /*
- -----------------------------------------------------------
- Header
- -----------------------------------------------------------
- */
- // title of the page
- $nameTools= get_lang('CourseManagement');
- Display::display_header($nameTools);
- api_display_tool_title($nameTools);
- /*
- ==============================================================================
- COMMANDS SECTION
- ==============================================================================
- */
- $userId = $_uid;
- unset($message);
- // we are moving a course or category of the user up/down the list (=Sort My Courses)
- if (isset($_GET['move']))
- {
- if (isset($_GET['course']))
- {
- $message=move_course($_GET['move'], $_GET['course'],$_GET['category']);
- }
- if (isset($_GET['category']) and !$_GET['course'])
- {
- $message=move_category($_GET['move'], $_GET['category']);
- }
- }
- // we are moving the course of the user to a different user defined course category (=Sort My Courses)
- if (isset($_POST['submit_change_course_category']))
- {
- $message=store_changecoursecategory($_POST['course_2_edit_category'], $_POST['course_categories']);
- }
- // we are creating a new user defined course category (= Create Course Category)
- if (isset($_POST['create_course_category']) AND isset($_POST['title_course_category']) AND strlen(trim($_POST['title_course_category'])) > 0)
- {
- $message=store_course_category();
- }
- if (isset($_POST['submit_edit_course_category']) AND isset($_POST['title_course_category']) AND strlen(trim($_POST['title_course_category'])) > 0)
- {
- $message=store_edit_course_category();
- }
- // we are subcribing to a course (=Subscribe to course)
- if (isset($_POST['subscribe']))
- {
- $message = subscribe_user($_POST['subscribe']);
- }
- // we are unsubscribing from a course (=Unsubscribe from course)
- if (isset($_POST['unsubscribe']))
- {
- $message=remove_user_from_course($_uid, $_POST['unsubscribe']);
- }
- // we are deleting a course category
- if ($_GET['action']=='deletecoursecategory' AND isset($_GET['id']))
- {
- $message=delete_course_category($_GET['id']);
- }
- // we are displaying any result messages;
- if (isset($message))
- {
- Display::display_normal_message($message);
- }
- /*
- ==============================================================================
- DISPLAY SECTION
- ==============================================================================
- */
- // The menu with the different options in the course management
- echo "<div>\n";
- echo "\t<ul>\n";
- echo "\t\t<li><a href=\"".$_SERVER['PHP_SELF']."?action=sortmycourses\">".get_lang("SortMyCourses")."</a></li>\n";
- echo "\t\t<li><a href=\"".$_SERVER['PHP_SELF']."?action=createcoursecategory\">".get_lang("CreateCourseCategory")."</a></li>\n";
- echo "\t\t<li><a href=\"".$_SERVER['PHP_SELF']."?action=subscribe\">".get_lang("SubscribeToCourse")."</a></li>\n";
- echo "\t</ul>\n";
- echo "</div>";
- echo "<div>";
- switch ($_GET['action'])
- {
- case 'subscribe':
- api_display_tool_title(get_lang('SubscribeToCourse'));
- courses_subscribing();
- break;
- case 'unsubscribe':
- api_display_tool_title(get_lang('UnsubscribeFromCourse'));
- $user_courses=get_courses_of_user($_uid);
- display_courses($_uid, true, $user_courses);
- break;
- case 'createcoursecategory':
- api_display_tool_title(get_lang('CreateCourseCategory'));
- display_create_course_category_form();
- break;
- case 'deletecoursecategory':
- case 'sortmycourses':
- default:
- api_display_tool_title(get_lang('SortMyCourses'));
- $user_courses=get_courses_of_user($_uid);
- display_courses($_uid, true, $user_courses);
- break;
- }
- echo '</div>';
- Display :: display_footer();
- /*
- ==============================================================================
- FUNCTIONS
- ==============================================================================
- */
- /**
- * Subscribe the user to a given course
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param string $course_code the code of the course the user wants to subscribe to
- * @return string we return the message that is displayed when the action is succesfull
- */
- function subscribe_user($course_code)
- {
- global $_uid;
- $all_course_information = CourseManager::get_course_information($course_code);
- if ($all_course_information['registration_code']=='' OR $_POST['course_registration_code']==$all_course_information['registration_code'])
- {
- if (CourseManager::add_user_to_course($_uid, $course_code))
- {
- return get_lang('EnrollToCourseSuccessful');
- }
- else
- {
- return get_lang('ErrorContactPlatformAdmin');
- }
- }
- else
- {
- $return='';
- if (isset($_POST['course_registration_code']) AND $_POST['course_registration_code']<>$all_course_information['registration_code'])
- {
- Display::display_error_message(get_lang('CourseRegistrationCodeIncorrect'));
- }
- $return.=get_lang('CourseRequiresPassword').'<br/>';
- $return.=$all_course_information['visual_code'].' - '.$all_course_information['title'];
- $return.="<form action=\"".$_SERVER["REQUEST_URI"]."\" method=\"post\">";
- $return.="<input type=\"hidden\" name=\"subscribe\" value=\"".$all_course_information['code']."\" />";
- $return.="<input type=\"text\" name=\"course_registration_code\" value=\"".$_POST['course_registration_code']."\" />";
- $return.="<input type=\"Submit\" name=\"submit_course_registration_code\" value=\"OK\" alt=\"".get_lang("SubmitRegistrationCode")."\" /></form>";
- return $return;
- }
- }
- /**
- * unsubscribe the user from a given course
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param int $user_id The user id of the user that is performing the unsubscribe action
- * @param string $course_code the course code of the course the user wants to unsubscribe from
- * @return string we return the message that is displayed when the action is succesfull
- */
- function remove_user_from_course($user_id, $course_code)
- {
- $tbl_course_user = Database::get_main_table(MAIN_COURSE_USER_TABLE);
- // we check (once again) if the user is not course administrator
- // because the course administrator cannot unsubscribe himself
- // (s)he can only delete the course
- $sql_check="SELECT * FROM $tbl_course_user WHERE user_id='".$user_id."' AND course_code='".$course_code."' AND status='1'";
- $result_check=api_sql_query($sql_check);
- $number_of_rows=mysql_num_rows($result_check);
- if ($number_of_rows>0)
- {return false;}
- else
- {
- CourseManager::unsubscribe_user($user_id,$course_code);
- return get_lang("YouAreNowUnsubscribed");
- }
- }
- /**
- * handles the display of the courses to which the user can subscribe
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- */
- function courses_subscribing()
- {
- browse_courses();
- display_search_courses();
- }
- /**
- * allows you to browse through the course categories (faculties) and subscribe to the courses of
- * this category (faculty)
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- */
- function browse_courses()
- {
- browse_course_categories();
- if (!isset($_POST['search_course']))
- {
- browse_courses_in_category();
- }
- }
- /**
- * counts the number of courses in a given course category
- */
- function count_courses_in_category($category)
- {
- $tbl_course = Database::get_main_table(MAIN_COURSE_TABLE);
- $sql="SELECT * FROM $tbl_course WHERE category_code".(empty($category)?" IS NULL":"='".$category."'");
- $result=api_sql_query($sql);
- return mysql_num_rows($result);
- }
- /**
- * displays the browsing of the course categories (faculties)
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @return HTML code containing a list with all the categories and subcategories and the navigation to go one category up(if needed)
- */
- function browse_course_categories()
- {
- $tbl_courses_nodes = Database::get_main_table(MAIN_CATEGORY_TABLE);
- echo "<p><b>".get_lang('CourseCategories')."</b>";
- $sql= "SELECT * FROM $tbl_courses_nodes WHERE parent_id ".(empty($_GET['category'])?"IS NULL":"='".$_GET['category']."'")." GROUP BY code, parent_id ORDER BY tree_pos ASC";
- $result=mysql_query($sql);
- echo "<ul>";
- while ($row=mysql_fetch_array($result))
- {
- if ($row['children_count'] > 0 OR count_courses_in_category($row['code'])>0)
- {
- echo "<li><a href=\"".$_SERVER['PHP_SELF']."?action=subscribe&category=".$row['code']."&up=".$_GET['category']."\">".$row['name']."</a>".
- " (".count_courses_in_category($row['code']).")</li>";
- }
- elseif ($row['nbChilds'] > 0)
- {
- echo "<li><a href=\"".$_SERVER['PHP_SELF']."?action=subscribe&category=".$row['code']."&up=".$_GET['category']."\">".$row['name']."</a></li>";
- }
- else
- {
- echo "<li>".$row['name']."</li>";
- }
- }
- echo "</ul>";
- if ($_GET['category'])
- {
- echo "<a href=\"".$_SERVER['PHP_SELF']."?action=subscribe&category=".$_GET['up']."\">< ".get_lang('UpOneCategory')."</a>";
- }
- }
- /**
- * Display all the courses in the given course category. I could have used a parameter here
- * but instead I use the already available $_GET['category']
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @return HTML code: a table with all the courses in a given category (title, code, tutor) and a subscription icon if applicable)
- */
- function browse_courses_in_category()
- {
- $tbl_course = Database::get_main_table(MAIN_COURSE_TABLE);
- echo "<p><b>".get_lang('CoursesInCategory')."</b>";
- $sql="SELECT * FROM $tbl_course WHERE category_code".(empty($_GET['category'])?" IS NULL":"='".$_GET['category']."'");
- $result=api_sql_query($sql);
- while ($row=mysql_fetch_array($result))
- {
- if ($row['registration_code']=='')
- {
- $registration_code=false;
- }
- else
- {
- $registration_code=true;
- }
- $courses[]=array("code" => $row['code'], "directory" => $row['directory'], "db"=> $row['db_name'], "visual_code" => $row['visual_code'], "title" => $row['title'], "tutor" => $row['tutor_name'], "subscribe" => $row['subscribe'], "unsubscribe" => $row['unsubscribe'], 'registration_code'=> $registration_code);
- }
- display_subscribe_to_courses($courses);
- }
- /**
- * displays the form for searching for a course and the results if a query has been submitted.
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @return HTML code: the form for searching for a course
- */
- function display_search_courses()
- {
- global $_uid;
- echo "<p><b>".get_lang("SearchCourse")."</b><br />";
- echo "<form class=\"course_list\" method=\"post\" action=\"".$_SERVER['PHP_SELF']."?action=subscribe\">",
- "<input type=\"hidden\" name=\"search_course\" value=\"1\" />",
- "<input type=\"text\" name=\"search_term\" />",
- " <input type=\"submit\" value=\"",get_lang("_search"),"\" />",
- "</form>";
- if (isset($_POST['search_course']))
- {
- echo "<p><b>".get_lang("SearchResultsFor")." ".$_POST['search_term']."</b><br />";
- $result_search_courses_array=search_courses($_POST['search_term']);
- display_subscribe_to_courses($result_search_courses_array);
- }
- }
- /**
- * This function displays the list of course that can be subscribed to.
- * This list can come from the search results or from the browsing of the platform course categories
- */
- function display_subscribe_to_courses($courses)
- {
- global $_uid;
- // getting all the courses to which the user is subscribed to
- $user_courses=get_courses_of_user($_uid);
- $user_coursecodes=array();
- // we need only the course codes as these will be used to match against the courses of the category
- if ($user_courses<>"")
- {
- foreach ($user_courses as $key=>$value)
- {
- $user_coursecodes[]=$value['code'];
- }
- }
- if ($courses==0)
- {
- return false;
- }
- echo "<table cellpadding=\"4\">\n";
- foreach ($courses as $key=>$course)
- {
- // displaying the course title, visual code and teacher/teaching staff
- echo "\t<tr>\n";
- echo "\t\t<td>\n";
- echo "<b>".$course['title']."</b><br />";
- if (get_setting("display_coursecode_in_courselist") == "true")
- {
- echo $course['visual_code'];
- }
- if (get_setting("display_coursecode_in_courselist") == "true" AND get_setting("display_teacher_in_courselist") == "true")
- {
- echo " - ";
- }
- if (get_setting("display_teacher_in_courselist") == "true")
- {
- echo $course['tutor'];
- }
- echo "\t\t</td>\n";
- echo "\t\t<td>\n";
- if ($course['registration_code'])
- {
- Display::display_icon('passwordprotected.png','',array('style'=>'float:left;'));
- }
- display_subscribe_icon($course, $user_coursecodes);
- echo "\t\t</td>\n";
- echo "</tr>";
- }
- echo "</table>";
- }
- /**
- * This function filters dangerous stuff out. It does addslashes when the php.ini setting
- * magic_quotes is set to off.
- * @author Olivier Cauberghe <olivier.cauberghe@UGent.be>, Ghent University
- * @param string something that possibly needs addslashing
- * @return string the addslahed version of the input
- */
- function escape($s)
- {
- if(!get_magic_quotes_gpc())
- return addslashes($s);
- else return $s;
- }
- /**
- * Search the courses database for a course that matches the search term.
- * The search is done on the code, title and tutor field of the course table.
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param string $search_term: the string that the user submitted, what we are looking for
- * @return array an array containing a list of all the courses (the code, directory, dabase, visual_code, title, ... )
- * matching the the search term.
- */
- function search_courses($search_term)
- {
- $TABLECOURS = Database::get_main_table(MAIN_COURSE_TABLE);
- $search_term_safe=escape($search_term);
- $sql_find="SELECT * FROM $TABLECOURS WHERE code LIKE '%".$search_term_safe."%' OR title LIKE '%".$search_term_safe."%' OR tutor_name LIKE '%".$search_term_safe."%'";
- $result_find=mysql_query($sql_find) or die(mysql_error());
- while ($row=mysql_fetch_array($result_find))
- {
- $courses[]=array("code" => $row['code'], "directory" => $row['directory'], "db"=> $row['db_name'], "visual_code" => $row['visual_code'], "title" => $row['title'], "tutor" => $row['tutor_name'], "subscribe" => $row['subscribe'], "unsubscribe" => $row['unsubscribe']);
- }
- return $courses;
- }
- /**
- * deletes a course category and moves all the courses that were in this category to main category
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param int $id: the id of the user_course_category
- * @return string a language variable saying that the deletion went OK.
- */
- function delete_course_category($id)
- {
- global $_uid, $user_personal_database;
- $DATABASE_USER_TOOLS = $user_personal_database;
- $TABLE_USER_COURSE_CATEGORY = $DATABASE_USER_TOOLS."`.`user_course_category";
- $TABLECOURSUSER=Database::get_main_table(MAIN_COURSE_USER_TABLE);
- $sql_delete="DELETE FROM `$TABLE_USER_COURSE_CATEGORY` WHERE id='".$id."' and user_id='".$_uid."'";
- $sql_update="UPDATE $TABLECOURSUSER SET user_course_cat='0' WHERE user_course_cat='".$id."' AND user_id='".$_uid."'";
- mysql_query($sql_delete) or die(mysql_error());
- mysql_query($sql_update) or die(mysql_error());
- return get_lang("CourseCategoryDeleted");
- }
- /**
- * stores the user course category in the dokeos_user database
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @return string a language variable saying that the user course category was stored
- */
- function store_course_category()
- {
- global $_uid, $user_personal_database;
- $DATABASE_USER_TOOLS = $user_personal_database;
- $TABLE_USER_COURSE_CATEGORY = $DATABASE_USER_TOOLS."`.`user_course_category";
- // step 1: we determine the max value of the user defined course categories
- $sql="SELECT sort FROM `$TABLE_USER_COURSE_CATEGORY` WHERE user_id='".$_uid."' ORDER BY sort DESC";
- $result=api_sql_query($sql);
- $maxsort=mysql_fetch_array($result);
- $nextsort=$maxsort['sort']+1;
- $sql_insert="INSERT INTO `$TABLE_USER_COURSE_CATEGORY` (user_id, title,sort) VALUES ('".$_uid."', '".htmlentities($_POST['title_course_category'])."', '".$nextsort."')";
- api_sql_query($sql_insert);
- return get_lang("CourseCategoryStored");
- }
- /**
- * displays the form that is needed to create a course category.
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @return HTML the form (input field + submit button) to create a user course category
- */
- function display_create_course_category_form()
- {
- global $_uid, $user_personal_database;
- echo "<form name=\"create_course_category\" method=\"post\" action=\"".$_SERVER['PHP_SELF']."?action=sortmycourses\">\n";
- echo "<input type=\"text\" name=\"title_course_category\" />\n";
- echo "<input type=\"submit\" name=\"create_course_category\" value=\"".get_lang("Ok")."\" />\n";
- echo "</form>\n";
- echo get_lang("ExistingCourseCategories");
- $DATABASE_USER_TOOLS = $user_personal_database;
- $TABLE_USER_COURSE_CATEGORY = $DATABASE_USER_TOOLS."`.`user_course_category";
- $sql="SELECT * FROM `$TABLE_USER_COURSE_CATEGORY` WHERE user_id='".$_uid."'";
- $result=api_sql_query($sql, __LINE__, __FILE__);
- if (mysql_num_rows($result)>0)
- {
- echo "<ul>\n";
- while ($row=mysql_fetch_array($result))
- {
- echo "\t<li>".$row['title']."</li>\n";
- }
- echo "</ul>\n";
- }
- }
- // ***************************************************************************
- // this function stores the changes in a course category
- //
- // ***************************************************************************
- /**
- * stores the changes in a course category (moving a course to a different course category)
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param string $course_code : the course_code of the course we are moving
- * int $newcategory : the id of the user course category we are moving the course to.
- * @return string a language variable saying that the course was moved.
- */
- function store_changecoursecategory($course_code, $newcategory)
- {
- global $_uid;
- $TABLECOURSUSER = Database::get_main_table(MAIN_COURSE_USER_TABLE);
- $max_sort_value=api_max_sort_value($newcategory,$_uid); //max_sort_value($newcategory);
- $sql="UPDATE $TABLECOURSUSER SET user_course_cat='".$newcategory."', sort='".($max_sort_value+1)."' WHERE course_code='".$course_code."' AND user_id='".$_uid."'";
- $result=api_sql_query($sql);
- return get_lang("EditCourseCategorySucces");
- }
- /**
- * moves the course one place up or down
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param string $direction : the direction we are moving the course to (up or down)
- * string $course2move : the course we are moving
- * @return string a language variable saying that the course was moved.
- */
- function move_course($direction, $course2move, $category)
- {
- global $_uid;
- $TABLECOURSUSER = Database::get_main_table(MAIN_COURSE_USER_TABLE);
- $all_user_courses=get_courses_of_user($_uid);
- // we need only the courses of the category we are moving in
- foreach ($all_user_courses as $key=>$course)
- {
- if ($course['user_course_category']==$category)
- {
- $user_courses[]=$course;
- }
- }
- foreach ($user_courses as $key=>$course)
- {
- if ($course2move==$course['code'])
- {
- // source_course is the course where we clicked the up or down icon
- $source_course=$course;
- // target_course is the course before/after the source_course (depending on the up/down icon)
- if ($direction=="up")
- {$target_course=$user_courses[$key-1];}
- else
- {$target_course=$user_courses[$key+1];}
- } // if ($course2move==$course['code'])
- }
- $sql_update1="UPDATE $TABLECOURSUSER SET sort='".$target_course['sort']."' WHERE course_code='".$source_course['code']."' AND user_id='".$_uid."'";
- $sql_update2="UPDATE $TABLECOURSUSER SET sort='".$source_course['sort']."' WHERE course_code='".$target_course['code']."' AND user_id='".$_uid."'";
- mysql_query($sql_update2);
- mysql_query($sql_update1);
- return get_lang("CourseSortingDone");
- }
- /**
- * moves the course one place up or down
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param string $direction : the direction we are moving the course to (up or down)
- * string $course2move : the course we are moving
- * @return string a language variable saying that the course was moved.
- */
- function move_category($direction, $category2move)
- {
- global $_uid;
- // the database definition of the table that stores the user defined course categories
- $table_user_defined_category = Database::get_user_personal_table(USER_COURSE_CATEGORY_TABLE);
- $user_coursecategories=get_user_course_categories();
- foreach ($user_coursecategories as $key=>$categoryid)
- {
- if ($category2move==$categoryid)
- {
- // source_course is the course where we clicked the up or down icon
- $source_category=get_user_course_category($category2move);
- // target_course is the course before/after the source_course (depending on the up/down icon)
- if ($direction=="up")
- {$target_category=get_user_course_category($user_coursecategories[$key-1]);}
- else
- {$target_category=get_user_course_category($user_coursecategories[$key+1]);}
- } // if ($course2move==$course['code'])
- } // foreach ($user_courses as $key=>$course)
- $sql_update1="UPDATE $table_user_defined_category SET sort='".$target_category['sort']."' WHERE id='".$source_category['id']."' AND user_id='".$_uid."'";
- $sql_update2="UPDATE $table_user_defined_category SET sort='".$source_category['sort']."' WHERE id='".$target_category['id']."' AND user_id='".$_uid."'";
- mysql_query($sql_update2);
- mysql_query($sql_update1);
- return get_lang("CategorySortingDone");
- }
- /**
- * displays everything that is needed when the user wants to manage his current courses (sorting, subscribing, unsubscribing, ...)
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param int $user_id: the user_id of the current user
- * string $parameter: determines weither we are displaying for the sorting, subscribing or unsubscribin
- array $user_courses: the courses to which the user is subscribed
- * @return html a table containing courses and the appropriate icons (sub/unsub/move)
- */
- function display_courses($user_id, $show_course_icons, $user_courses)
- {
- global $_uid, $user_personal_database;
- echo "<table cellpadding=\"4\">\n";
- // building an array that contains all the id's of the user defined course categories
- // initially this was inside the display_courses_in_category function but when we do it here we have fewer
- // sql executions = performance increase.
- $all_user_categories=get_user_course_categories();
- // step 0: we display the course without a user category
- display_courses_in_category(0,'true');
- // Step 1: we get all the categories of the user
- $DATABASE_USER_TOOLS = $user_personal_database;
- $TABLE_USER_COURSE_CATEGORY = $DATABASE_USER_TOOLS."`.`user_course_category";
- $sql="SELECT * FROM `$TABLE_USER_COURSE_CATEGORY` WHERE user_id=$_uid ORDER BY sort ASC";
- $result=api_sql_query($sql);
- while ($row=mysql_fetch_array($result))
- {
- if ($show_course_icons=true)
- {
- // the edit link is clicked: we display the edit form for the category
- if (isset($_GET['categoryid']) AND $_GET['categoryid']==$row['id'])
- {
- echo "<tr><td colspan=\"2\" class=\"user_course_category\">";
- echo '<a name="category'.$row['id'].'"></a>'; // display an internal anchor.
- display_edit_course_category_form($row['id']);
- }
- // we simply display the title of the catgory
- else
- {
- $info_this_user_course_category=get_user_course_category($row['id']);
- echo "<tr><td colspan=\"2\" class=\"user_course_category\">";
- echo '<a name="category'.$row['id'].'"></a>'; // display an internal anchor.
- echo $info_this_user_course_category['title'];
- }
- echo "</td><td class=\"user_course_category\">";
- display_category_icons($row['id'],$all_user_categories);
- echo "</td></tr>";
- }
- // Step 2: show the courses inside this category
- display_courses_in_category($row['id'], $show_course_icons);
- }
- echo "</table>\n";
- }
- /**
- * This function displays all the courses in the particular user category;
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param int id: the id of the user defined course category
- * @return string: the name of the user defined course category
- */
- function display_courses_in_category($user_category_id, $showicons)
- {
- global $_uid;
- // table definitions
- $TABLECOURS=Database::get_main_table(MAIN_COURSE_TABLE);
- $TABLECOURSUSER=Database::get_main_table(MAIN_COURSE_USER_TABLE);
- $TABLE_USER_COURSE_CATEGORY = "`".Database::get_user_personal_database()."`.`user_course_category`";
- $sql_select_courses="SELECT course.code, course.visual_code, course.subscribe subscr, course.unsubscribe unsubscr,
- course.title title, course.tutor_name tutor, course.db_name, course.directory, course_rel_user.status status,
- course_rel_user.sort sort, course_rel_user.user_course_cat user_course_cat
- FROM $TABLECOURS course,
- $TABLECOURSUSER course_rel_user
- WHERE course.code = course_rel_user.course_code
- AND course_rel_user.user_id = '".$_uid."'
- AND course_rel_user.user_course_cat='".$user_category_id."'
- ORDER BY course_rel_user.user_course_cat, course_rel_user.sort ASC";
- $result = api_sql_query($sql_select_courses) or die(mysql_error());
- $number_of_courses=mysql_num_rows($result);
- $key=0;
- while ($course=mysql_fetch_array($result))
- {
- echo "\t<tr>\n";
- echo "\t\t<td>\n";
- echo '<a name="course'.$course['code'].'"></a>'; // display an internal anchor.
- echo "<b>".$course['title']."</b><br />";
- if (get_setting("display_coursecode_in_courselist") == "true")
- {
- echo $course['visual_code'];
- }
- if (get_setting("display_coursecode_in_courselist") == "true" AND get_setting("display_teacher_in_courselist") == "true")
- {
- echo " - ";
- }
- if (get_setting("display_teacher_in_courselist") == "true")
- {
- echo $course['tutor'];
- }
- echo "\t\t</td>\n";
- // displaying the up/down/edit icons when we are sorting courses
- echo "\t\t<td valign=\"top\">\n";
- //if ($parameter=="sorting")
- //{
- display_course_icons($key, $number_of_courses, $course, $user_courses);
- //}
- // displaying the delete icon when we are unsubscribing from courses
- //if($parameter=="deleting")
- //{
- // display_unsubscribe_icons($course);
- //}
- // display the subscribing icon when we are to courses.
- //if ($parameter=="subscribing")
- //{
- // display_subscribe_icon($course);
- //}
- echo "\t\t</td>\n";
- echo "\t</tr>\n";
- $key++;
- }
- }
- /**
- * gets the title of the user course category
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param int id: the id of the user defined course category
- * @return string: the name of the user defined course category
- */
- function get_user_course_category($id)
- {
- global $_uid, $user_personal_database;
- $DATABASE_USER_TOOLS = $user_personal_database;
- $TABLE_USER_COURSE_CATEGORY = $DATABASE_USER_TOOLS."`.`user_course_category";
- $sql="SELECT * FROM `".$TABLE_USER_COURSE_CATEGORY."` WHERE user_id='$_uid' AND id='$id'";
- $result=mysql_query($sql) or die(mysql_error());
- $row=mysql_fetch_array($result);
- return $row;
- }
- /**
- * displays the subscribe icon if the subscribing is allowed and if the user is not yet
- * subscribe to this course
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param string $current_course: the course code of the course we need to display the subscribe icon for
- * @return string a subscribe icon or the text that subscribing is not allowed or the user is already subscribed
- */
- function display_subscribe_icon($current_course, $user_coursecodes)
- {
- // we display the icon to subscribe or the text already subscribed
- if (in_array($current_course['code'],$user_coursecodes))
- {
- echo get_lang("AlreadySubscribed");
- }
- else
- {
- if ($current_course['subscribe'] == SUBSCRIBE_ALLOWED)
- {
- echo "<form action=\"".$_SERVER["REQUEST_URI"]."\" method=\"post\">";
- echo "<input type=\"hidden\" name=\"subscribe\" value=\"".$current_course['code']."\" />";
- echo "<input type=\"image\" name=\"unsub\" src=\"../img/enroll.gif\" alt=\"".get_lang("Subscribe")."\" />".get_lang("Subscribe")."</form>";
- }
- else
- {
- echo get_lang("SubscribingNotAllowed");
- }
- }
- }
- /**
- * displays the subscribe icon if the subscribing is allowed and if the user is not yet
- * subscribed to this course
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param $key:
- * $number_of_courses
- * $course
- * $user_courses
- * @return html a small table containing the up/down icons and the edit icon (for moving to a different user course category)
- * @todo complete the comments on this function: the parameter section
- */
- function display_course_icons($key, $number_of_courses, $course, $user_courses)
- {
- //print_r($course);
- echo "<table><tr><td>";
- // the up icon
- if ($key>0 AND $user_courses[$key-1]['user_course_category']==$course['user_course_category'])
- {
- echo "<a href=\"courses.php?action=".$_GET['action']."&move=up&course=".$course['code']."&category=".$course['user_course_cat']."\">";
- echo "<img src=\"../img/up.gif\" alt=\"".htmlentities(get_lang("Up"))."\"></a>";
- }
- echo "</td>";
- // the edit icon OR the edit dropdown list
- if (isset($_GET['edit']) and $course['code']==$_GET['edit'])
- {
- echo "<td rowspan=\"2\" valign=\"top\">".display_change_course_category_form($_GET['edit'])."</td>";
- }
- else
- {
- echo "<td rowspan=\"2\" valign=\"middle\"><a href=\"courses.php?action=".$_GET['action']."&edit=".$course['code']."\">";
- Display::display_icon('edit.gif',get_lang('Edit'));
- echo "</a></td>";
- }
- echo "<td rowspan=\"2\" valign=\"top\">";
- if ($course['status'] != 1)
- {
- if ($course['unsubscr'] == 1)
- { // changed link to submit to avoid action by the search tool indexer
- echo "<form action=\"".$_SERVER['PHP_SELF']."\" method=\"post\" onsubmit=\"javascript:if(!confirm('".addslashes(htmlentities(get_lang("ConfirmUnsubscribeFromCourse")))."')) return false;\">";
- echo "<input type=\"hidden\" name=\"unsubscribe\" value=\"".$course['code']."\" />";
- echo "<input type=\"image\" name=\"unsub\" src=\"../img/delete.gif\" alt=\"".get_lang("_unsubscribe")."\" /></form>";
- }
- else
- {display_info_text(get_lang("UnsubscribeNotAllowed"));}
- }
- else
- {
- display_info_text(get_lang("CourseAdminUnsubscribeNotAllowed"));
- }
- echo "</td>";
- echo "</tr><tr><td>";
- if ($key<$number_of_courses-1 AND $user_courses[$key+1]['user_course_category']==$course['user_course_category'])
- {
- echo "<a href=\"courses.php?action=".$_GET['action']."&move=down&course=".$course['code']."&category=".$course['user_course_cat']."\">";
- echo "<img src=\"../img/down.gif\" alt=\"".htmlentities(get_lang("Down"))."\"></a>";
- }
- echo "</td></tr></table>";
- }
- /**
- * displays the relevant icons for the category (if applicable):move up, move down, edit, delete
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param $current_category the id of the current category
- * $allcategories an associative array containing all the categories.
- * @return html: a small table containing the up/down icons and the edit icon (for moving to a different user course category)
- * @todo complete the comments on this function: the parameter section
- */
- function display_category_icons($current_category, $all_user_categories)
- {
- $max_category_key=count($all_user_categories);
- if ($_GET['action']<>'unsubscribe') // we are in the unsubscribe section then we do not show the icons.
- {
- echo "<table>";
- echo "<tr>";
- echo "<td>";
- if ($current_category<>$all_user_categories[0])
- {
- echo "<a href=\"courses.php?action=".$_GET['action']."&move=up&category=".$current_category."\">";
- echo "<img src=\"../img/up.gif\" alt=\"".htmlentities(get_lang("Up"))."\"></a>";
- }
- echo "</td>";
- echo " <td rowspan=\"2\">";
- echo " <a href=\"courses.php?action=sortmycourses&categoryid=".$current_category."#category".$current_category."\">";
- Display::display_icon('edit.gif',get_lang('Edit'));
- echo "</a>";
- echo "</td>";
- echo "<td rowspan=\"2\">";
- echo " <a href=\"courses.php?action=deletecoursecategory&id=".$current_category."\">";
- Display::display_icon('delete.gif',get_lang('Edit'),array('onclick'=>"javascript:if(!confirm('".addslashes(htmlentities(get_lang("CourseCategoryAbout2bedeleted")))."')) return false;"));
- echo "</a>";
- echo "</td>";
- echo "</tr>";
- echo "<tr>";
- echo " <td>";
- if ($current_category<>$all_user_categories[$max_category_key-1])
- {
- echo "<a href=\"courses.php?action=".$_GET['action']."&move=down&category=".$current_category."\">";
- echo "<img src=\"../img/down.gif\" alt=\"".htmlentities(get_lang("Down"))."\"></a>";
- }
- echo "</td>";
- echo " </tr>";
- echo "</table>";
- }
- }
- /**
- * This function displays the form (dropdown list) to move a course to a
- * different course_category (after the edit icon has been changed)
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param string $edit_course:
- * @return html a dropdown list containing all the user defined course categories and a submit button
- * @todo when editing (moving) a course inside a user defined course category to a different user defined category
- * the dropdown list should have the current course category selected.
- */
- function display_change_course_category_form($edit_course)
- {
- global $_uid, $user_personal_database;
- $DATABASE_USER_TOOLS = $user_personal_database;
- $TABLE_USER_COURSE_CATEGORY = $DATABASE_USER_TOOLS."`.`user_course_category";
- $sql="SELECT * FROM `$TABLE_USER_COURSE_CATEGORY` WHERE user_id='".$_uid."'";
- $result=api_sql_query($sql);
- $output="<form name=\"edit_course_category\" method=\"post\" action=\"courses.php?action=".$_GET['action']."\">\n";
- $output.="<input type=\"hidden\" name=\"course_2_edit_category\" value=\"".$edit_course."\" />";
- $output.="\t<select name=\"course_categories\">\n";
- $output.="\t\t<option value=\"0\">".get_lang("NoCourseCategory")."</option>";
- while ($row=mysql_fetch_array($result))
- {$output.="\t\t<option value=\"".$row['id']."\">".$row['title']."</option>";}
- $output.="\t</select>\n";
- $output.="\t<input type=\"submit\" name=\"submit_change_course_category\" value=\"".get_lang("Ok")."\" />\n";
- $output.="</form>";
- return $output;
- }
- /**
- * This function displays the unsubscribe part which can be
- * 1. the unsubscribe link
- * 2. text: you are course admin of this course (=> unsubscription is not possible
- * 3. text: you are not allowed to unsubscribe from this course
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param array $course: the array with all the course & course_rel_user information
- * @return html a delete icon or a text that unsubscribing is not possible (course admin) or not allowed.
- */
- function display_unsubscribe_icons($course)
- {
- if ($course['status'] != 1)
- {
- if ($course['unsubscribe'] == 1)
- { // changed link to submit to avoid action by the search tool indexer
- echo "<form action=\"".$_SERVER['PHP_SELF']."\" method=\"post\" onsubmit=\"javascript:if(!confirm('".addslashes(htmlentities(get_lang("ConfirmUnsubscribeFromCourse")))."')) return false;\">";
- echo "<input type=\"hidden\" name=\"unsubscribe\" value=\"".$course['code']."\" />";
- echo "<input type=\"image\" name=\"unsub\" src=\"../img/delete.gif\" alt=\"".get_lang("_unsubscribe")."\" /></form>";
- }
- else
- {display_info_text(get_lang("UnsubscribeNotAllowed"));}
- }
- else
- {
- display_info_text(get_lang("CourseAdminUnsubscribeNotAllowed"));
- }
- }
- /**
- * retrieves all the courses that the user has already subscribed to
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param int $user_id: the id of the user
- * @return array an array containing all the information of the courses of the given user
- */
- function get_courses_of_user($user_id)
- {
- $TABLECOURS=Database::get_main_table(MAIN_COURSE_TABLE);
- $TABLECOURSUSER=Database::get_main_table(MAIN_COURSE_USER_TABLE);
- // Secondly we select the courses that are in a category (user_course_cat<>0) and sort these according to the sort of the category
- $sql_select_courses="SELECT course.code k, course.visual_code vc, course.subscribe subscr, course.unsubscribe unsubscr,
- course.title i, course.tutor_name t, course.db_name db, course.directory dir, course_rel_user.status status,
- course_rel_user.sort sort, course_rel_user.user_course_cat user_course_cat
- FROM $TABLECOURS course,
- $TABLECOURSUSER course_rel_user
- WHERE course.code = course_rel_user.course_code
- AND course_rel_user.user_id = '".$user_id."'
- ORDER BY course_rel_user.sort ASC";
- $result = api_sql_query($sql_select_courses) or die(mysql_error());
- while ($row=mysql_fetch_array($result))
- {
- // we only need the database name of the course
- $courses[]=array("db"=> $row['db'], "code" => $row['k'], "visual_code" => $row['vc'], "title" => $row['i'], "directory" => $row['dir'], "status" => $row['status'], "tutor" => $row['t'], "subscribe" => $row['subscr'], "unsubscribe" => $row['unsubscr'], "sort" => $row['sort'], "user_course_category" => $row['user_course_cat']);
- }
- return $courses;
- }
- /**
- * retrieves the user defined course categories
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @return array containing all the titles of the user defined courses with the id as key of the array
- */
- function get_user_course_categories()
- {
- global $_uid;
- $table_category = Database::get_user_personal_table(USER_COURSE_CATEGORY_TABLE);
- $sql = "SELECT * FROM ".$table_category." WHERE user_id='".$_uid."' ORDER BY sort ASC";
- $result = api_sql_query($sql,__FILE__,__LINE__);
- while ($row = mysql_fetch_array($result))
- {
- $output[] = $row['id'];
- }
- return $output;
- }
- /**
- * @author unknown
- * @param string $text: the text that has to be written in grey
- * @return string: the text with the grey formatting
- * @todo move this to a stylesheet
- */
- function display_info_text($text)
- {
- echo "<font color=\"#808080\">" . $text . "</font>\n";
- }
- /**
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @param string $edit_course:
- * @return html output: the form
- */
- function display_edit_course_category_form($edit_course_category)
- {
- echo "<form name=\"edit_course_category\" method=\"post\" action=\"courses.php?action=".$_GET['action']."\">\n";
- echo "\t<input type=\"hidden\" name=\"edit_course_category\" value=\"".$edit_course_category."\" />\n";
- $info_this_user_course_category=get_user_course_category($edit_course_category);
- echo "\t<input type=\"text\" name=\"title_course_category\" value=\"".$info_this_user_course_category['title']."\" />";
- echo "\t<input type=\"submit\" name=\"submit_edit_course_category\" value=\"".get_lang("Ok")."\" />\n";
- echo "</form>";
- }
- /**
- * Updates the user course category in the dokeos_user database
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @return string a language variable saying that the user course category was stored
- */
- function store_edit_course_category()
- {
- global $_uid, $user_personal_database;
- $DATABASE_USER_TOOLS = $user_personal_database;
- $TABLE_USER_COURSE_CATEGORY = $DATABASE_USER_TOOLS."`.`user_course_category";
- $sql_update="UPDATE `$TABLE_USER_COURSE_CATEGORY` SET title='".htmlentities($_POST['title_course_category'])."' WHERE id='".(int)$_POST['edit_course_category']."'";
- mysql_query($sql_update) or die(mysql_error());
- //api_sql_query(sql_update);
- return get_lang("CourseCategoryEditStored");
- }
- ?>
|