Source for file add_users_to_session.php

 

 

 

 

 

 

$language_file='admin';

 

$cidReset=true;

 

require('../inc/global.inc.php');

 

$xajax = new xajax();

 

$this_section = SECTION_PLATFORM_ADMIN;

 

 

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

$interbreadcrumb[]=array('url' => "session_list.php","name" => "Liste des sessions");

 

$tbl_session                        = Database::get_main_table(TABLE_MAIN_SESSION);

$tbl_session_rel_class                = Database::get_main_table(TABLE_MAIN_SESSION_CLASS);

$tbl_session_rel_course                = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);

$tbl_session_rel_course_rel_user    = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);

$tbl_course                            = Database::get_main_table(TABLE_MAIN_COURSE);

$tbl_user                            = Database::get_main_table(TABLE_MAIN_USER);

$tbl_session_rel_user                = Database::get_main_table(TABLE_MAIN_SESSION_USER);

$tbl_class                            = Database::get_main_table(TABLE_MAIN_CLASS);

$tbl_class_user                        = Database::get_main_table(TABLE_MAIN_CLASS_USER);

 

$tool_name=get_lang('SubscribeUsersToSession');

 

$id_session=intval($_GET['id_session']);

 

    $sql = 'SELECT session_admin_id FROM '.Database :: get_main_table(TABLE_MAIN_SESSION).' WHERE id='.$id_session;

    $rs = api_sql_query($sql,__FILE__,__LINE__);

    if(mysql_result($rs,0,0)!=$_user['user_id'])

    {

        api_not_allowed(true);

    }

 

 

    global $tbl_user;

    

    $xajax_response = new XajaxResponse();

    $return = '';

    if(!empty($needle))

    {

        // search users where username or firstname or lastname begins likes $needle

        $sql = 'SELECT user_id, username, lastname, firstname FROM '.$tbl_user.' user

                WHERE (username LIKE "'.$needle.'%"

                OR firstname LIKE "'.$needle.'%"

                OR lastname LIKE "'.$needle.'%")

                

        $rs = api_sql_query($sql, __FILE__, __LINE__);

        

        while($user = Database :: fetch_array($rs))

        {

            $return .= '<a href="#" onclick="add_user_to_session(\''.$user['user_id'].'\',\''.$user['firstname'].' '.$user['lastname'].' ('.$user['username'].')'.'\')">'.$user['firstname'].' '.$user['lastname'].' ('.$user['username'].')</a><br />';

        }

    }

    $xajax_response -> addAssign('ajax_list_users','innerHTML',utf8_encode($return));

    return $xajax_response;

 

$htmlHeadXtra[] = $xajax->getJavascript('../inc/lib/xajax/');

$htmlHeadXtra[] = '

 

    

    

    

 

 

$formSent=0;

$errorMsg=$firstLetterUser=$firstLetterSession='';

$UserList=$SessionList=array();

$users=$sessions=array();

$noPHP_SELF=true;

 

 

 

 

    $formSent=$_POST['formSent'];

    $firstLetterUser=$_POST['firstLetterUser'];

    $firstLetterSession=$_POST['firstLetterSession'];

    $UserList=$_POST['sessionUsersList'];

    $ClassList=$_POST['sessionClassesList'];

    if(!is_array($UserList))

    {

        $UserList=array();

    }

 

    if($formSent == 1)

    {

        $result = api_sql_query("SELECT id_user FROM $tbl_session_rel_user WHERE id_session='$id_session'");

        $existingUsers = array();

        while($row = mysql_fetch_array($result)){

            $existingUsers[] = $row['id_user'];

        }

 

        $result=api_sql_query("SELECT course_code FROM $tbl_session_rel_course WHERE id_session='$id_session'",__FILE__,__LINE__);

 

        $CourseList=array();

 

        while($row=mysql_fetch_array($result))

        {

            $CourseList[]=$row['course_code'];

        }

 

        foreach($CourseList as $enreg_course)

        {

            $nbr_users=0;

            foreach($UserList as $enreg_user)

            {

                if(!in_array($enreg_user, $existingUsers)){

                    api_sql_query("INSERT IGNORE INTO $tbl_session_rel_course_rel_user(id_session,course_code,id_user) VALUES('$id_session','$enreg_course','$enreg_user')",__FILE__,__LINE__);

 

                    if(mysql_affected_rows())

                    {

                        $nbr_users++;

                    }

                }

            }

            foreach($existingUsers as $existing_user){

                if(!in_array($existing_user, $UserList)){

                    $sql = "DELETE FROM $tbl_session_rel_course_rel_user WHERE id_session='$id_session' AND course_code='$enreg_course' AND id_user='$existing_user'";

                    api_sql_query($sql);

 

                    if(mysql_affected_rows())

                    {

                        $nbr_users--;

                    }

                }

            }

            $sql = "SELECT COUNT(id_user) as nbUsers FROM $tbl_session_rel_course_rel_user WHERE id_session='$id_session' AND course_code='$enreg_course'";

            $rs = api_sql_query($sql, __FILE__, __LINE__);

            list($nbr_users) = mysql_fetch_array($rs);

            api_sql_query("UPDATE $tbl_session_rel_course SET nbr_users=$nbr_users WHERE id_session='$id_session' AND course_code='$enreg_course'",__FILE__,__LINE__);

 

        }

 

        api_sql_query("DELETE FROM $tbl_session_rel_user WHERE id_session = $id_session");

        $nbr_users = 0;

        foreach($UserList as $enreg_user){

            $nbr_users++;

            api_sql_query("INSERT IGNORE INTO $tbl_session_rel_user(id_session, id_user) VALUES('$id_session','$enreg_user')",__FILE__,__LINE__);

 

        }

        $nbr_users = count($UserList);

        api_sql_query("UPDATE $tbl_session SET nbr_users= $nbr_users WHERE id='$id_session' ",__FILE__,__LINE__);

 

        //if(empty($_GET['add']))

            //header('Location: '.$_GET['page'].'?id_session='.$id_session);

        //else

        header('Location: resume_session.php?id_session='.$id_session);

 

    }

 

 

 

$nosessionUsersList = $sessionUsersList = array();

$sql = 'SELECT COUNT(1) FROM '.$tbl_user;

$rs = api_sql_query($sql, __FILE__, __LINE__);

$count_courses = mysql_result($rs, 0, 0);

$ajax_search = $count_courses > 100 ? true : false;

 

    $sql="SELECT user_id, lastname, firstname, username, id_session

                AND $tbl_session_rel_user.id_session = ".intval($id_session)."

    

    $result=api_sql_query($sql,__FILE__,__LINE__);    

    $Users=api_store_result($result);

    

    foreach($Users as $user)

    {

        $sessionUsersList[$user['user_id']] = $user ;

    }

    $sql="SELECT user_id, lastname, firstname, username, id_session

    

    $result=api_sql_query($sql,__FILE__,__LINE__);    

    $Users=api_store_result($result);

    

    foreach($Users as $user)

    {

        if($user['id_session'] == $id_session)

            $sessionUsersList[$user['user_id']] = $user ;

        else

            $nosessionUsersList[$user['user_id']] = $user ;

    }

 

 

 

 

 

 

<form name="formulaire" method="post" action="<?php echo api_get_self(); ?>?page=<?php echo $_GET['page'] ?>&id_session=<?php echo $id_session; ?><?php if(!empty($_GET['add'])) echo '&add=true' ; ?>" style="margin:0px;">

<input type="hidden" name="formSent" value="1" />

 

    Display::display_normal_message($errorMsg); //main API

 

<table border="0" cellpadding="5" cellspacing="0" width="100%">

 

 

<!-- Users -->

<tr>

  <td align="center"><b><?php echo get_lang('UserListInPlatform') ?> :</b>

  </td>

  <td></td>

  <td align="center"><b><?php echo get_lang('UserListInSession') ?> :</b></td>

</tr>

 

<tr>

  <td align="center">

  <div id="content_source">

        <?php

        if($ajax_search)

        {

            ?>

        <input type="text" id="user_to_add" onkeyup="xajax_search_users(this.value)" />

        <div id="ajax_list_users"></div>

        <?php

        }

        else

        {

        ?>

        

      <select id="origin_users" name="nosessionUsersList[]" multiple="multiple" size="15" style="width:300px;">

 

        <?php

        foreach($nosessionUsersList as $enreg)

        {

        ?>

 

            <option value="<?php echo $enreg['user_id']; ?>"><?php echo $enreg['lastname'].' '.$enreg['firstname'].' ('.$enreg['username'].')'; ?></option>

 

        <?php

        }

 

        unset($nosessionUsersList);

        ?>

 

      </select>

    <?php

        }

       ?>

  </div>

  </td>

  <td width="10%" valign="middle" align="center">

  <?php

  if($ajax_search)

  {

  ?>

      <input type="button" onclick="remove_item(document.getElementById('destination_users'))" value="<<" />

  <?php

  }

  else

  {

  ?>

    <input type="button" onclick="moveItem(document.getElementById('origin_users'), document.getElementById('destination_users'))" value=">>" />

    <br /><br />

    <input type="button" onclick="moveItem(document.getElementById('destination_users'), document.getElementById('origin_users'))" value="<<" />

    <?php 

  } 

  ?>

    <br /><br /><br /><br /><br /><br />

  </td>

  <td align="center">

  <select id="destination_users" name="sessionUsersList[]" multiple="multiple" size="15" style="width:300px;">

 

 

    <option value="<?php echo $enreg['user_id']; ?>"><?php echo $enreg['lastname'].' '.$enreg['firstname'].' ('.$enreg['username'].')'; ?></option>

 

 

unset($sessionUsersList);

 

  </select></td>

</tr>

 

<tr>

    <td colspan="3" align="center">

        <br />

        <?php

        if(isset($_GET['add']))

            echo '<input type="button" value="'.get_lang("FinishSessionCreation").'" onclick="valide()" />';

        else

            echo '<input type="button" value="'.get_lang('Ok').'" onclick="valide()" />';

        ?>

    </td>

</tr>

 

 

 

 

</table>

 

</form>

<script type="text/javascript">

<!--

function moveItem(origin , destination){

 

    for(var i = 0 ; i<origin.options.length ; i++) {

        if(origin.options[i].selected) {

            destination.options[destination.length] = new Option(origin.options[i].text,origin.options[i].value);

            origin.options[i]=null;

            i = i-1;

        }

    }

    destination.selectedIndex = -1;

    sortOptions(destination.options);

 

}

 

function sortOptions(options) {

 

    newOptions = new Array();

    for (i = 0 ; i<options.length ; i++)

        newOptions[i] = options[i];

 

    newOptions = newOptions.sort(mysort);

    options.length = 0;

    for(i = 0 ; i < newOptions.length ; i++)

        options[i] = newOptions[i];

 

}

 

function mysort(a, b){

    if(a.text.toLowerCase() > b.text.toLowerCase()){

        return 1;

    }

    if(a.text.toLowerCase() < b.text.toLowerCase()){

        return -1;

    }

    return 0;

}

 

function valide(){

    var options = document.getElementById('destination_users').options;

    for (i = 0 ; i<options.length ; i++)

        options[i].selected = true;

    /*

    var options = document.getElementById('destination_classes').options;

    for (i = 0 ; i<options.length ; i++)

        options[i].selected = true;

        */

    document.forms.formulaire.submit();

}

 

 

function loadUsersInSelect(select){

 

    var xhr_object = null;

 

    if(window.XMLHttpRequest) // Firefox

        xhr_object = new XMLHttpRequest();

    else if(window.ActiveXObject) // Internet Explorer

        xhr_object = new ActiveXObject("Microsoft.XMLHTTP");

    else  // XMLHttpRequest non supporté par le navigateur

    alert("Votre navigateur ne supporte pas les objets XMLHTTPRequest...");

 

    //xhr_object.open("GET", "loadUsersInSelect.ajax.php?id_session=<?php echo $id_session ?>&letter="+select.options[select.selectedIndex].text, false);

    xhr_object.open("POST", "loadUsersInSelect.ajax.php");

 

    xhr_object.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");

 

 

    nosessionUsers = makepost(document.getElementById('origin_users'));

    sessionUsers = makepost(document.getElementById('destination_users'));

    nosessionClasses = makepost(document.getElementById('origin_classes'));

    sessionClasses = makepost(document.getElementById('destination_classes'));

    xhr_object.send("nosessionusers="+nosessionUsers+"&sessionusers="+sessionUsers+"&nosessionclasses="+nosessionClasses+"&sessionclasses="+sessionClasses);

 

    xhr_object.onreadystatechange = function() {

        if(xhr_object.readyState == 4) {

            document.getElementById('content_source').innerHTML = result = xhr_object.responseText;

            //alert(xhr_object.responseText);

        }

    }

}

 

function makepost(select){

 

    var options = select.options;

    var ret = "";

    for (i = 0 ; i<options.length ; i++)

        ret = ret + options[i].value +'::'+options[i].text+";;";

 

    return ret;

 

}

-->

 

</script>