Community Company Search Contact

subscribe_class2course.php from pointcarre at Krugle

Show subscribe_class2course.php syntax highlighted

<?php // $Id: subscribe_class2course.php 483 2006-10-10 11:48:15Z evie_em $
/*
==============================================================================
	Dokeos - elearning and course management software

	Copyright (c) 2004 Dokeos S.A.
	Copyright (c) 2003 University of Ghent (UGent)
	Copyright (c) 2001 Universite catholique de Louvain (UCL)
	Copyright (c) Olivier Brouckaert

	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.admin
============================================================================== 
*/

$langFile='admin';

$cidReset=true;

require('../inc/claro_init_global.inc.php');
api_protect_admin_script();
$classes=$_GET['classes'];
$formSent=0;
$errorMsg=$firstLetterClass=$firstLetterCourse='';
$courses=array();

//$tbl_cours=$mysqlMainDb."`.`cours";
//$tbl_cours_class=$mysqlMainDb."`.`cours_class";
//$tbl_cours_user=$mysqlMainDb."`.`cours_user";
//updated for 1.6 - YW
$tbl_course       = Database::get_main_table(MAIN_COURSE_TABLE); 
$tbl_course_user  = Database::get_main_table(MAIN_COURSE_USER_TABLE);
$tbl_course_class = Database::get_main_table(MAIN_COURSE_CLASS_TABLE);
$tbl_class=$mysqlMainDb."`.`class";
$tbl_class_user=$mysqlMainDb."`.`class_user";

$tool_name = get_lang('AddClassesToACourse');

$interbredcrump[]=array("url" => "index.php","name" => get_lang('AdministrationTools'));

if($_POST['formSent'] )
{
	$formSent=$_POST['formSent'];
	$ClassList=$_POST['ClassList'];
	$CourseList=$_POST['CourseList'];
	$firstLetterClass=$_POST['firstLetterClass'];
	$firstLetterCourse=$_POST['firstLetterCourse'];

	if(!is_array($ClassList))
	{
		$ClassList=array();
	}

	if(!is_array($CourseList))
	{
		$CourseList=array();
	}

	if($formSent == 1)
	{
		if(!sizeof($ClassList) || !sizeof($CourseList)) $errorMsg=get_lang('AtLeastOneClassAndOneCourse');
		else
		{
			$query1="INSERT IGNORE INTO $tbl_course_class(course_code,class_id) VALUES";
			$query2="INSERT IGNORE INTO $tbl_course_user(course_code,user_id,status) VALUES";

			$ok_query2=false;

			foreach($CourseList as $enreg_cours)
			{
				$already_added='0';

				foreach($ClassList as $enreg_class)
				{
					$query1.="('$enreg_cours','$enreg_class'),";

					$result=api_sql_query("SELECT user_id FROM `$tbl_class_user` WHERE class_id='$enreg_class' AND user_id NOT IN($already_added)",__FILE__,__LINE__);

					while($row=mysql_fetch_row($result))
					{
						$query2.="('$enreg_cours','$row[0]','5'),";

						$already_added.=",$row[0]";

						$ok_query2=true;
					}
				}
			}

			$query1=substr($query1,0,-1);

			api_sql_query($query1,__FILE__,__LINE__);

			if($ok_query2)
			{
				$query2=substr($query2,0,-1);

				api_sql_query($query2,__FILE__,__LINE__);
			}

			header('Location: class_list.php');
			exit();
		}
	}

	if(sizeof($ClassList))
	{
		$classes=$ClassList;
	}

	if(sizeof($CourseList))
	{
		$courses=$CourseList;
	}
}

Display::display_header($tool_name);

api_display_tool_title($tool_name);


if(empty($classes))
{
	$classes=array();
}
elseif(!is_array($classes))
{
	$classes=explode(',',$classes);

	foreach($classes as $key=>$enreg)
	{
		$classes[$key]=intval($enreg);
	}
}
else
{
	foreach($classes as $key=>$enreg)
	{
		$classes[$key]=intval($enreg);
	}
}

foreach($courses as $key=>$enreg)
{
	$courses[$key]="'$enreg'";
}

$result=api_sql_query("SELECT id,name FROM `$tbl_class` WHERE name LIKE '".$firstLetterClass."%' ORDER BY ".(sizeof($classes)?"(id IN(".implode(',',$classes).")) DESC,":"")." name ",__FILE__,__LINE__);

$Classes=api_store_result($result);

$result=api_sql_query("SELECT code,visual_code,title FROM $tbl_course WHERE visibility IN(1,2) AND visual_code LIKE '".$firstLetterCourse."%' ORDER BY ".(sizeof($courses)?"(code IN(".implode(',',$courses).")) DESC,":"")." visual_code ",__FILE__,__LINE__);

$Courses=api_store_result($result);
?>

<form name="formulaire" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" style="margin:0px;">
<input type="hidden" name="formSent" value="1">

<?php
if(!empty($errorMsg))
{
	Display::display_normal_message($errorMsg); //main API
}
?>

<table border="0" cellpadding="5" cellspacing="0" width="100%">
<tr>
  <td width="40%" align="center"><b><?php echo get_lang('ClassList'); ?> :</b><br><br>
  <?php echo get_lang('FirstLetterClass'); ?> : <select name="firstLetterClass" onchange="javascript:document.formulaire.formSent.value='2'; document.formulaire.submit();">
  <option value="">--</option>
  <option value="A" <?php if($formSent && $firstLetterClass == 'A') echo 'selected="selected"'; ?>>A</option>
  <option value="B" <?php if($formSent && $firstLetterClass == 'B') echo 'selected="selected"'; ?>>B</option>
  <option value="C" <?php if($formSent && $firstLetterClass == 'C') echo 'selected="selected"'; ?>>C</option>
  <option value="D" <?php if($formSent && $firstLetterClass == 'D') echo 'selected="selected"'; ?>>D</option>
  <option value="E" <?php if($formSent && $firstLetterClass == 'E') echo 'selected="selected"'; ?>>E</option>
  <option value="F" <?php if($formSent && $firstLetterClass == 'F') echo 'selected="selected"'; ?>>F</option>
  <option value="G" <?php if($formSent && $firstLetterClass == 'G') echo 'selected="selected"'; ?>>G</option>
  <option value="H" <?php if($formSent && $firstLetterClass == 'H') echo 'selected="selected"'; ?>>H</option>
  <option value="I" <?php if($formSent && $firstLetterClass == 'I') echo 'selected="selected"'; ?>>I</option>
  <option value="J" <?php if($formSent && $firstLetterClass == 'J') echo 'selected="selected"'; ?>>J</option>
  <option value="K" <?php if($formSent && $firstLetterClass == 'K') echo 'selected="selected"'; ?>>K</option>
  <option value="L" <?php if($formSent && $firstLetterClass == 'L') echo 'selected="selected"'; ?>>L</option>
  <option value="M" <?php if($formSent && $firstLetterClass == 'M') echo 'selected="selected"'; ?>>M</option>
  <option value="N" <?php if($formSent && $firstLetterClass == 'N') echo 'selected="selected"'; ?>>N</option>
  <option value="O" <?php if($formSent && $firstLetterClass == 'O') echo 'selected="selected"'; ?>>O</option>
  <option value="P" <?php if($formSent && $firstLetterClass == 'P') echo 'selected="selected"'; ?>>P</option>
  <option value="Q" <?php if($formSent && $firstLetterClass == 'Q') echo 'selected="selected"'; ?>>Q</option>
  <option value="R" <?php if($formSent && $firstLetterClass == 'R') echo 'selected="selected"'; ?>>R</option>
  <option value="S" <?php if($formSent && $firstLetterClass == 'S') echo 'selected="selected"'; ?>>S</option>
  <option value="T" <?php if($formSent && $firstLetterClass == 'T') echo 'selected="selected"'; ?>>T</option>
  <option value="U" <?php if($formSent && $firstLetterClass == 'U') echo 'selected="selected"'; ?>>U</option>
  <option value="V" <?php if($formSent && $firstLetterClass == 'V') echo 'selected="selected"'; ?>>V</option>
  <option value="W" <?php if($formSent && $firstLetterClass == 'W') echo 'selected="selected"'; ?>>W</option>
  <option value="X" <?php if($formSent && $firstLetterClass == 'X') echo 'selected="selected"'; ?>>X</option>
  <option value="Y" <?php if($formSent && $firstLetterClass == 'Y') echo 'selected="selected"'; ?>>Y</option>
  <option value="Z" <?php if($formSent && $firstLetterClass == 'Z') echo 'selected="selected"'; ?>>Z</option>
  </select></td>
  <td width="20%">&nbsp;</td>
  <td width="40%" align="center"><b><?php echo get_lang('CourseList'); ?> :</b><br><br>
  <?php echo get_lang('FirstLetterCourse'); ?> : <select name="firstLetterCourse" onchange="javascript:document.formulaire.formSent.value='2'; document.formulaire.submit();">
  <option value="">--</option>
  <option value="A" <?php if($formSent && $firstLetterCourse == 'A') echo 'selected="selected"'; ?>>A</option>
  <option value="B" <?php if($formSent && $firstLetterCourse == 'B') echo 'selected="selected"'; ?>>B</option>
  <option value="C" <?php if($formSent && $firstLetterCourse == 'C') echo 'selected="selected"'; ?>>C</option>
  <option value="D" <?php if($formSent && $firstLetterCourse == 'D') echo 'selected="selected"'; ?>>D</option>
  <option value="E" <?php if($formSent && $firstLetterCourse == 'E') echo 'selected="selected"'; ?>>E</option>
  <option value="F" <?php if($formSent && $firstLetterCourse == 'F') echo 'selected="selected"'; ?>>F</option>
  <option value="G" <?php if($formSent && $firstLetterCourse == 'G') echo 'selected="selected"'; ?>>G</option>
  <option value="H" <?php if($formSent && $firstLetterCourse == 'H') echo 'selected="selected"'; ?>>H</option>
  <option value="I" <?php if($formSent && $firstLetterCourse == 'I') echo 'selected="selected"'; ?>>I</option>
  <option value="J" <?php if($formSent && $firstLetterCourse == 'J') echo 'selected="selected"'; ?>>J</option>
  <option value="K" <?php if($formSent && $firstLetterCourse == 'K') echo 'selected="selected"'; ?>>K</option>
  <option value="L" <?php if($formSent && $firstLetterCourse == 'L') echo 'selected="selected"'; ?>>L</option>
  <option value="M" <?php if($formSent && $firstLetterCourse == 'M') echo 'selected="selected"'; ?>>M</option>
  <option value="N" <?php if($formSent && $firstLetterCourse == 'N') echo 'selected="selected"'; ?>>N</option>
  <option value="O" <?php if($formSent && $firstLetterCourse == 'O') echo 'selected="selected"'; ?>>O</option>
  <option value="P" <?php if($formSent && $firstLetterCourse == 'P') echo 'selected="selected"'; ?>>P</option>
  <option value="Q" <?php if($formSent && $firstLetterCourse == 'Q') echo 'selected="selected"'; ?>>Q</option>
  <option value="R" <?php if($formSent && $firstLetterCourse == 'R') echo 'selected="selected"'; ?>>R</option>
  <option value="S" <?php if($formSent && $firstLetterCourse == 'S') echo 'selected="selected"'; ?>>S</option>
  <option value="T" <?php if($formSent && $firstLetterCourse == 'T') echo 'selected="selected"'; ?>>T</option>
  <option value="U" <?php if($formSent && $firstLetterCourse == 'U') echo 'selected="selected"'; ?>>U</option>
  <option value="V" <?php if($formSent && $firstLetterCourse == 'V') echo 'selected="selected"'; ?>>V</option>
  <option value="W" <?php if($formSent && $firstLetterCourse == 'W') echo 'selected="selected"'; ?>>W</option>
  <option value="X" <?php if($formSent && $firstLetterCourse == 'X') echo 'selected="selected"'; ?>>X</option>
  <option value="Y" <?php if($formSent && $firstLetterCourse == 'Y') echo 'selected="selected"'; ?>>Y</option>
  <option value="Z" <?php if($formSent && $firstLetterCourse == 'Z') echo 'selected="selected"'; ?>>Z</option>
  </select></td>
</tr>
<tr>
  <td width="40%" align="center"><select name="ClassList[]" multiple="multiple" size="20" style="width:230px;">

<?php
foreach($Classes as $enreg)
{
?>

	<option value="<?php echo $enreg['id']; ?>" <?php if((!$formSent && in_array($enreg['id'],$classes)) || ($formSent && in_array($enreg['id'],$ClassList))) echo 'selected="selected"'; ?>><?php echo $enreg['name']; ?></option>

<?php
}

unset($Classes);
?>

  </select></td>
  <td width="20%" valign="middle" align="center"><input type="submit" value="<?php echo get_lang('AddToThatCourse'); ?> &gt;&gt;"></td>
  <td width="40%" align="center"><select name="CourseList[]" multiple="multiple" size="20" style="width:230px;">

<?php
foreach($Courses as $enreg)
{
?>

	<option value="<?php echo $enreg['code']; ?>" <?php if($formSent && in_array($enreg['code'],$CourseList)) echo 'selected="selected"'; ?>><?php echo '('.$enreg['visual_code'].') '.$enreg['title']; ?></option>

<?php
}

unset($Courses);
?>

  </select></td>
</tr>
</table>

</form>

<?php
/*
==============================================================================
		FOOTER 
==============================================================================
*/ 
Display::display_footer();
?>

See more files for this project here

pointcarre

Pointcarre - a learning management system based on the Dokeos community releases. No fork, but containing locally developed extensions, features not (yet) in the standard release, integrated plugins...

Project homepage: http://sourceforge.net/projects/pointcarre
Programming language(s): PHP
License: other

  nightly_update/
    nightly_update.php
  class_add.php
  class_edit.php
  class_information.php
  class_list.php
  configure_homepage.php
  course_add.php
  course_category.php
  course_create_content.php
  course_edit.php
  course_information.php
  course_list.php
  course_virtual.php
  curriculum_complete_update.php
  exemple.csv
  exemple.xml
  index.php
  languages.php
  manage_course_tools.php
  manage_official_classes.php
  manage_official_communities.php
  manage_official_personnel.php
  manage_official_students.php
  manage_official_teachers.php
  manage_special_options.php
  official_update_titles_teachers.php
  settings.php
  statistics.php
  subscribe_class2course.php
  subscribe_user2class.php
  subscribe_user2course.php
  system_announcements.php
  user_add.php
  user_edit.php
  user_export.php
  user_import.php
  user_information.php
  user_list.php
  veco_manage_official_data.php