123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205 |
- <?php
- // $Id: class.php 9119 2006-08-18 07:10:23Z bmol $
- /*
- ==============================================================================
- Dokeos - elearning and course management software
- Copyright (c) 2004-2005 Dokeos S.A.
- Copyright (c) Bart Mollet, Hogeschool Gent
- 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 address: Dokeos, 44 rue des palais, B-1030 Brussels, Belgium
- Mail: info@dokeos.com
- ==============================================================================
- */
- /**
- ==============================================================================
- * This script allows teachers to manage subscribed
- *classes in their course.
- * @package dokeos.user
- ==============================================================================
- */
- /*
- ==============================================================================
- INIT SECTION
- ==============================================================================
- */
- // name of the language file that needs to be included
- $language_file = array('registration','admin');
- include ('../inc/global.inc.php');
- $this_section = SECTION_COURSES;
- require_once (api_get_path(LIBRARY_PATH).'course.lib.php');
- require_once (api_get_path(LIBRARY_PATH).'sortabletable.class.php');
- require_once (api_get_path(LIBRARY_PATH).'classmanager.lib.php');
- require_once (api_get_path(LIBRARY_PATH).'formvalidator/FormValidator.class.php');
- /*
- ==============================================================================
- MAIN CODE
- ==============================================================================
- */
- api_protect_course_script();
- if(api_get_setting('use_session_mode')=='true')
- {
- api_not_allowed();
- }
- /*
- -----------------------------------------------------------
- Header
- -----------------------------------------------------------
- */
- $tool_name = get_lang("Classes");
- //extra entries in breadcrumb
- $interbreadcrumb[] = array ("url" => "user.php", "name" => get_lang("Users"));
- Display :: display_header($tool_name, "User");
- api_display_tool_title($tool_name);
- if (api_is_allowed_to_edit())
- {
- echo '<a href="subscribe_class.php?'.api_get_cidreq().'">'.get_lang("AddClassesToACourse").'</a><br /><br />';
- }
- /*
- ==============================================================================
- MAIN SECTION
- ==============================================================================
- */
- if(api_is_allowed_to_edit())
- {
- if (isset ($_GET['unsubscribe']))
- {
- ClassManager::unsubscribe_from_course($_GET['class_id'],$_course['sysCode']);
- Display::display_normal_message(get_lang('ClassesUnSubscribed'));
- }
- if (isset ($_POST['action']))
- {
- switch ($_POST['action'])
- {
- case 'unsubscribe' :
- if (is_array($_POST['class']))
- {
- foreach ($_POST['class'] as $index => $class_id)
- {
- ClassManager::unsubscribe_from_course($class_id,$_course['sysCode']);
- }
- Display::display_normal_message(get_lang('ClassesUnSubscribed'));
- }
- break;
- }
- }
- }
- /*
- -----------------------------------------------------------
- SHOW LIST OF CLASSES
- -----------------------------------------------------------
- */
- /**
- * * Get the number of classes to display on the current page.
- */
- function get_number_of_classes()
- {
- $class_table = Database :: get_main_table(TABLE_MAIN_CLASS);
- $course_class_table = Database :: get_main_table(TABLE_MAIN_COURSE_CLASS);
- $sql = "SELECT c.id FROM $class_table c, $course_class_table cc WHERE cc.class_id = c.id AND cc.course_code ='".$_SESSION['_course']['id']."'";
- if (isset ($_GET['keyword']))
- {
- $keyword = Database::escape_string($_GET['keyword']);
- $sql .= " AND (c.name LIKE '%".$keyword."%')";
- }
- $res = Database::query($sql, __FILE__, __LINE__);
- $result = Database::num_rows($res);
- return $result;
- }
- /**
- * Get the classes to display on the current page.
- */
- function get_class_data($from, $number_of_items, $column, $direction)
- {
- $class_table = Database :: get_main_table(TABLE_MAIN_CLASS);
- $course_class_table = Database :: get_main_table(TABLE_MAIN_COURSE_CLASS);
- $class_user_table = Database :: get_main_table(TABLE_MAIN_CLASS_USER);
- $sql = "SELECT
- c.id AS col0,
- c.name AS col1,
- COUNT(cu.user_id) AS col2";
- if (api_is_allowed_to_edit())
- {
- $sql .= " ,c.id AS col3";
- }
- // '(' and ')' in next query is necessary (see http://bugs.mysql.com/bug.php?id=19053)
- $sql .= " FROM ($class_table c, $course_class_table cc)";
- $sql .= " LEFT JOIN $class_user_table cu ON cu.class_id = c.id";
- $sql .= " WHERE c.id = cc.class_id AND cc.course_code = '".$_SESSION['_course']['id']."'";
- if (isset ($_GET['keyword']))
- {
- $keyword = Database::escape_string($_GET['keyword']);
- $sql .= " AND (c.name LIKE '%".$keyword."%')";
- }
- $sql .= " GROUP BY c.id, c.name ";
- $sql .= " ORDER BY col$column $direction ";
- $sql .= " LIMIT $from,$number_of_items";
- $res = Database::query($sql, __FILE__, __LINE__);
- $classes = array ();
- while ($class = Database::fetch_row($res))
- {
- $classes[] = $class;
- }
- return $classes;
- }
- /**
- * Build the reg-column of the table
- * @param int $class_id The class id
- * @return string Some HTML-code
- */
- function reg_filter($class_id)
- {
- global $charset;
- $result = '<a href="'.api_get_self().'?'.api_get_cidreq().'&unsubscribe=yes&class_id='.$class_id.'" onclick="javascript:if(!confirm(\''.addslashes(api_htmlentities(get_lang('ConfirmYourChoice'),ENT_QUOTES,$charset)).'\')) return false;"><img src="../img/delete.gif"/></a>';
- return $result;
- }
- // Build search-form
- $form = new FormValidator('search_class', 'get','','',null,false);
- $renderer = & $form->defaultRenderer();
- $renderer->setElementTemplate('<span>{element}</span> ');
- $form->add_textfield('keyword', '', false);
- $form->addElement('submit', 'submit', get_lang('SearchButton'));
- // Build table
- $table = new SortableTable('users', 'get_number_of_classes', 'get_class_data', 1);
- $parameters['keyword'] = $_GET['keyword'];
- $table->set_additional_parameters($parameters);
- $col = 0;
- $table->set_header($col ++, '', false);
- $table->set_header($col ++, get_lang('ClassName'));
- $table->set_header($col ++, get_lang('NumberOfUsers'));
- if (api_is_allowed_to_edit())
- {
- $table->set_header($col ++, '', false);
- $table->set_column_filter($col -1, 'reg_filter');
- $table->set_form_actions(array ('unsubscribe' => get_lang('Unreg')), 'class');
- }
- // Display form & table
- $form->display();
- echo '<br />';
- $table->display();
- /*
- ==============================================================================
- FOOTER
- ==============================================================================
- */
- Display :: display_footer();
- ?>
|