chamilo-lms2/main/admin/ldap_import_students.php

<?php
/* For licensing terms, see /license.txt */
/**
 * Script to import students from LDAP
 * @package chamilo.admin
 * Copyright (c) 2007 Mustapha Alouani (supervised by Michel Moreau-Belliard)
 */
/**
 * Code
 */
// name of the language file that needs to be included
$language_file[] = 'admin';
$language_file[] = 'registration';
// resetting the course id
$cidReset = true;
require_once('../inc/global.inc.php');
// setting the section (for the tabs)
$this_section = SECTION_PLATFORM_ADMIN;
require_once(api_get_path(LIBRARY_PATH).'course.lib.php');
require_once(api_get_path(LIBRARY_PATH).'usermanager.lib.php');
// Access restrictions
api_protect_admin_script();
require('../auth/ldap/authldap.php');

$annee_base = date('Y');

$tool_name = get_lang('LDAPImport');
// setting breadcrumbs
$interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('PlatformAdmin'));

$htmlHeadXtra[] = '<script language="JavaScript" type="text/javascript">
var buttoncheck = 1;
function checkAll() {
	//var boxes = document.form.elements[\'checkboxes[]\'];
	var boxes = document.getElementsByName(\'checkboxes[]\');
	if (buttoncheck == 0) {
		for (i = 0; i < boxes.length; i++) {
			boxes[i].checked = true;
		}
		buttoncheck = 1;
		return "'.get_lang('None').'";
	}
	else {
		for (i = 0; i < boxes.length; i++) {
			boxes[i].checked = false;
		}
		buttoncheck = 0;
		return " '.get_lang('All').' ";
	}
}
</script>';

$annee = $_GET['annee'];
$composante = $_GET['composante'];
$etape = $_GET['etape'];
$course = $_POST['course'];


// form1 annee = 0; composante= 0 etape = 0
//if ($annee == "" && $composante == "" && $etape == "") {
if (empty($annee) && empty($course)) {
    Display::display_header($tool_name);
    echo '<div style="align:center">';
    Display::display_icon('group.gif', get_lang('LDAPSelectFilterOnUsersOU'));
    echo get_lang('LDAPSelectFilterOnUsersOU');
    //echo '<em>'.get_lang('ToDoThisYouMustEnterYearComponentAndComponentStep').'</em><br />';
    ///echo get_lang('FollowEachOfTheseStepsStepByStep').'<br />';

    echo '<form method="get" action="'.api_get_self().'"><br />';
    echo '<em>'.get_lang('LDAPOUAttributeFilter').' :</em> ';
    echo '<input  type="text" name="annee" size="4" maxlength="30" value="'.$annee_base.'"><br />';
    echo '<input type="submit" value="'.get_lang('Submit').'">';
    echo '</form>';
    echo '</div>';

} /*
elseif ($annee <> "" && $composante == "" && $etape == "") // form 2 annee != 0; composante= 0 etape = 0
{
		Display::display_header($tool_name);

	$ds = ldap_connect($ldap_host, $ldap_port) or die(get_lang('LDAPConnectionError'));
	ldap_set_version($ds);

	if ($ds) {
		$r = false;
		$res = ldap_handle_bind($ds, $r);

		//$sr = @ ldap_search($ds, "o=groups,$ldap_basedn", "(&(description=etape*)(cn=*$annee))", array ('cn'));
		//$sr = @ ldap_search($ds, "ou=$annee, ou=diploma, o=paris1, $ldap_basedn", "ou=02*", array ('description'));
		//$sr = @ ldap_search($ds, "ou=structures, o=paris1, $ldap_basedn", "businessCategory=pedagogy", array ('ou','description'));
		$sr = ldap_search($ds, $ldap_basedn, "(ou=*$annee)", array ('ou','description'));
		// "ou=2006,ou=diploma,o=Paris1,dc=univ-paris1,dc=fr

		$info = ldap_get_entries($ds, $sr);
		$composante = array();
		for($i = 0; $i < $info['count']; $i ++)
		{
			//presupose LDAP server is UTF-8
			$composante[$info[$i]['ou'][0]] = api_utf8_decode($info[$i]['description'][0], api_get_system_encoding());
		}
		$oucompotab3=$composante;

		echo '<div style="align: center">';
		echo '<br />';
		echo '<h3>'.Display::return_icon('group.gif', get_lang('SelectComponent')).' '.get_lang('SelectComponent').'</h3>';
		echo '<form method="get" action="'.api_get_self().'">';
		echo '<b>'.get_lang('RegistrationYear').'</b> : ';
		echo '<input type="text" name="annee" size="4" maxlength="30" value="'.$annee.'">';
		echo '<b>'.get_lang('Component').' : </b> ';
		echo '<select name="composante" size="1">';
		while (list ($key, $val) = each($oucompotab3)) {
			echo '<option value="'.$key.'">'.$oucompotab3[$key].'</option>';
		}
		echo '</select>';
		echo '<br />';
		echo '<br />';
		echo '<input type="submit" name="valider" value="'.get_lang('Submit').'">';
		echo '</form>';
		ldap_close($ds);

	}
	echo '<br />';
	echo '<br />';
	echo '<br />';
	echo '<a href="ldap_import_students.php?annee=&composante=&etape=">'.get_lang('BackToNewSearch').'</a>';
	echo '<br />';
	echo '</div>';
}
elseif ($annee <> "" && $composante <> "" && $etape == "") // form3 :annee!=0composante=0etape=0
{

		Display::display_header($tool_name);
	echo '<div style="align: center">';
	echo '<h3>'.Display::return_icon('group.gif', get_lang('SearchResults')).' '.get_lang('SearchResults').'</h3>';
	$ds = ldap_connect($ldap_host, $ldap_port);
	ldap_set_version($ds);

	if ($ds) {

		$r = false;
		$res = ldap_handle_bind($ds, $r);

		// $sr = @ ldap_search($ds, "ou=groups, $LDAPbasedn", "(&(cn=*$annee*)(cn=*$composante*))");

		$sr = @ ldap_search($ds, $ldap_basedn, "ou=$composante", array ('ou','description'));

		//echo "Le nombre de resultats est : ".ldap_count_entries($ds,$sr)."<p>";
		$info = ldap_get_entries($ds, $sr);

		for ($i = 0; $i <= $info['count']; $i ++) {

			$description = $info[$i]['description'];
			$ouetapetab[$i] = $description[0];
			$description2 = $info[$i]['ou'];
			$ouetapetab2[$i] = $description2[0];

		}

		asort($ouetapetab);
		reset($ouetapetab);

		echo '<form method="get" action="'.api_get_self().'">';

		echo '<b>'.get_lang('RegistrationYear').':</b><input type="text"  name="annee" size="4" maxlength="30" value="'.$annee.'">';
		echo '<br /><br />';
		echo '<b>'.get_lang('Component').' :</b><input type="text" name="composante" size="4" maxlength="30" value="'.$composante.'">';
		echo '<br />';
		echo '<h4>'.get_lang('SelectStepAcademicYear').'</h4>';
		echo '<br />';

		echo '<b>'.get_lang('Step').': </b>';
		echo '<select name="etape" size="1">';
		$tempcomp = "";

		while (list ($key, $val) = each($ouetapetab)) {
			if ($ouetapetab[$key] != $tempcomp) {
				$etape = $ouetapetab2[$key];
				$tempcomp = '"'.$ouetapetab[$key].'"';
				$tempcomp = api_utf8_decode($tempcomp, api_get_system_encoding());

				$annee = str_word_count($etape, 1);
				echo '<option value="'.$etape.'">'.$tempcomp.'</option>';
			}
		}
		echo '</select>';
		echo '<input type="hidden" name="displayname" value="'.$displayname.'">';

		echo '<br />';
		echo '<input type="submit" name="envoi" value="'.get_lang('Submit').'">';
		echo '</form>';

		ldap_close($ds);

	} else {
		//    echo "<h4>Unable to connect to LDAP server</h4>";
	}
	echo '<br />';
	echo '<br />';
    echo '<a href="ldap_import_students.php?annee=&composante=&etape=">'.get_lang('BackToNewSearch').'</a>';
	echo '</div>';
}
*/
elseif (!empty($annee) && empty($course)) {
    Display::display_header($tool_name);
    echo '<div style="align:center">';
    echo Display::return_icon('course.gif', get_lang('SelectCourseToImportUsersTo')).' '.get_lang(
        'SelectCourseToImportUsersTo'
    ).'<br />';
    echo '<form method="post" action="'.api_get_self().'?annee='.Security::remove_XSS($annee).'"><br />';
    echo '<select name="course">';
    $courses = CourseManager::get_courses_list();
    foreach ($courses as $row) {
        echo '<option value="'.$row['code'].'">'.api_htmlentities(
            $row['title'],
            ENT_COMPAT,
            api_get_system_encoding()
        ).'</option>';
    }
    echo '</select>';
    echo '<input type="submit" value="'.get_lang('Submit').'">';
    echo '</form>';
    echo '</div>';
} // form4  annee != 0; composante != 0 etape != 0
//elseif ($annee <> "" && $composante <> "" && $etape <> "" && $listeok != 'yes') {
elseif (!empty($annee) && !empty($course) && empty($_POST['confirmed'])) {
    Display::display_header($tool_name);
    echo '<div style="align: center;">';
    echo '<br />';
    echo '<br />';
    echo '<h3>'.Display::return_icon('group.gif', get_lang('SelectStudents')).' '.get_lang('SelectStudents').'</h3>';
    //echo "Connection ...";
    $ds = ldap_connect($ldap_host, $ldap_port) or die(get_lang('LDAPConnectionError'));
    ldap_set_version($ds);

    if ($ds) {

        $r   = false;
        $res = ldap_handle_bind($ds, $r);

        //$sr = @ ldap_search($ds, "ou=people,$LDAPbasedn", "(|(edupersonprimaryorgunitdn=ou=$etape,ou=$annee,ou=diploma,o=Paris1,$LDAPbasedn)(edupersonprimaryorgunitdn=ou=02PEL,ou=$annee,ou=diploma,o=Paris1,$LDAPbasedn))");
        //echo "(ou=*$annee,ou=$composante)";
        $sr = @ ldap_search($ds, $ldap_basedn, "(ou=*$annee)");

        $info = ldap_get_entries($ds, $sr);

        for ($key = 0; $key < $info["count"]; $key++) {
            $nom_form[]    = $info[$key]["sn"][0]; //api_utf8_decode($info[$key]["sn"][0], api_get_system_encoding());
            $prenom_form[] = $info[$key]["givenname"][0]; //api_utf8_decode($info[$key]["givenname"][0], api_get_system_encoding());
            $email_form[]  = $info[$key]["mail"][0];
            // Get uid from dn
            //$dn_array=ldap_explode_dn($info[$key]["dn"],1);
            //$username_form[] = $dn_array[0]; // uid is first key
            $username_form[] = $info[$key]['uid'][0];
            $outab[]         = $info[$key]["eduPersonPrimaryAffiliation"][0]; // Ici "student"
            //$val = ldap_get_values_len($ds, $entry, "userPassword");
            //$password_form[] = $val[0];
            $password_form[] = $info[$key]['userPassword'][0];
        }
        ldap_unbind($ds);
        asort($nom_form);
        reset($nom_form);

        $statut = 5;
        include('ldap_form_add_users_group.php');
    } else {
        echo '<h4>'.get_lang('UnableToConnectTo').' '.$host.'</h4>';
    }
    echo '<br /><br />';
    echo '<a href="ldap_import_students.php?annee=&composante=&etape=">'.get_lang('BackToNewSearch').'</a>';
    echo '<br /><br />';
    echo '</div>';

} elseif (!empty($annee) && !empty($course) && ($_POST['confirmed'] == 'yes')) {
    $id                 = $_POST['username_form'];
    $UserList           = array();
    $userid_match_login = array();
    foreach ($id as $form_index => $user_id) {
        if (is_array($_POST['checkboxes']) && in_array($form_index, array_values($_POST['checkboxes']))) {
            $tmp                      = ldap_add_user($user_id);
            $UserList[]               = $tmp;
            $userid_match_login[$tmp] = $user_id;
        }
    }
    $courseInfo = api_get_course_info($_POST['course']);
    if (!empty($courseInfo)) {
        foreach ($UserList as $user_id) {
            CourseManager::add_user_to_course($user_id, $courseInfo['real_id']);
        }
        header('Location: course_information.php?code='.Security::remove_XSS($_POST['course']));
        exit;
    } /*
	else
	{
		Display :: display_header($tool_name);
		if(count($userid_match_login)>0)
		{
			$message=get_lang('LDAPUsersAddedOrUpdated').':<br />';
			foreach($userid_match_login as $user_id => $login)
			{
				$message .= '- '.$login.'<br />';
			}
		}
		else
		{
			$message=get_lang('NoUserAdded');
		}
		Display :: display_normal_message($message,false);
	}
	*/
    else {
        Display::display_header($tool_name);
        $message = get_lang('NoUserAdded');
        Display :: display_normal_message($message, false);
    }
    echo '<br /><br />';
    echo '<a href="ldap_import_students.php?annee=&composante=&etape=">'.get_lang('BackToNewSearch').'</a>';
    echo '<br /><br />';
}
Display::display_footer();