<?php
//@sucerman
//Funcion Principal
//ini_set('display_errors', 1);
//error_reporting(E_ALL);
require_once(dirname(__FILE__) . '/../config.php');
session_start();


//Funcion que devuelve la imagen del perfil de un usuario
function getImagenPerfil($userid,$size='f1'){
    global $DB,$CFG;
    $imagen=$CFG->wwwroot."/theme/image.php?theme=imaster&component=core&image=u%2F".$size;
    $sql = "
SELECT c.id as contextid,u.picture
FROM mdl_user u
JOIN mdl_context c ON (c.instanceid=u.id and c.contextlevel=30)
WHERE u.id = ".$userid."
";
    $result= $DB->get_records_sql($sql);
    if(!empty($result)){
        foreach($result as $res){
            if( $res->picture <> 0){
              $imagen=$CFG->wwwroot."/pluginfile.php/".$res->contextid."/user/icon/".$size;
            }
        }
    }
    return $imagen;
}

//PARAMETROS DE BUSQUEDA
$usuario=$_SESSION['USER']->username;

if(isloggedin() && isset($_REQUEST['id_curso'])){//si esta logeado
    $html="";
    $etiqueta_enlace="Enviar mensaje";
    #-----------------------------------------------------------------------------
    # Arma la instruccion para consultar los docentes del curso
    #-----------------------------------------------------------------------------
    $sql=" SELECT  DISTINCT u.username as usuario, u.firstname as nombre, u.lastname as apellidos, u.email as correo, u.id as userid, (select j.id from mdl_context j WHERE j.instanceid=u.id AND j.contextlevel=30) as contextid
FROM mdl_user u
JOIN mdl_role_assignments a ON (a.userid=u.id)
JOIN mdl_context t ON (t.id = a.contextid)
JOIN mdl_course c ON (c.id =t.instanceid)
WHERE c.id = ".$_REQUEST['id_curso']."
AND t.contextlevel= 50
AND a.roleid = 3";

    //Ejecuta la consulta en la BD
    $result = $DB->get_records_sql($sql);

    if(!empty($result)){
        foreach($result as $res){
            $userid=$res->userid;
            #-------------------------------------------------
            # Consulta la foto de perfil
            #-------------------------------------------------
            $url_foto = getImagenPerfil($res->userid,'f1');
            $url_perfil =$CFG->wwwroot."/user/profile.php?id=".$res->userid;
            //etiqueta enlace compañeros del grupo

            $html.='
            <section class="imaster-teacherBlock">
                <div class="row mx-0 mb-3 align-items-center">
                    <div class="col-auto px-0">
                        <a href="'.$CFG->wwwroot.'/message/index.php?id='.$res->userid.'">
                            <img class="img-responsive imaster-userImage imaster-teacherBlock__userImage" src="'.$url_foto.'" alt="Foto '.$res->nombre.' '.$res->apellidos.'" />
                        </a>
                    </div> 

                    <div class="col pr-0">
                        <a class="imaster-teacherBlock__userName" href="'.$CFG->wwwroot.'/message/index.php?id='.$res->userid.'">
                            '.$res->nombre.' '.$res->apellidos.'
                        </a> 
                    </div>
                </div>
                <div class="text-center">
                    <a class="btn" href="'.$CFG->wwwroot.'/message/index.php?id='.$res->userid.'"><i class="icon fa fa-comment fa-fw " title="Toggle messaging drawer" aria-label="Toggle messaging drawer"></i> Enviar mensaje</a> 
                </div>
            </section>
        ';
        }//Fin Foreach
    }
    echo $html;
}
?>