Atenea
/
sgi


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056
							<?php
    require_once("../include/constantes.php");
    require_once("../include/util.php");
    require_once("../include/bd_pdo.php");
    require_once("../classes/ValidaSesion.php");
    require_once("../classes/MainMenu.php");

    $menu = 7;
    $submenu = 71;

    //--- Objeto para validar usuario. El id de usuario lo lee desde sesión
    $objSesion = new ValidaSesion($pdo, $submenu, APSA);
    if(!$objSesion->tieneAcceso()){
        $objSesion->terminaSesion();
    }
    
    $objSesion->validaPeriodoUsuario();//si no tiene periodo manda a main
    
    //Obtiene fechas de periodo
    $stmt = $pdo->prepare('Select * from fs_periodo(:periodo, NULL, NULL, true)');
    $stmt->bindParam(":periodo", $_SESSION["periodo_id"]);
    if(!$stmt->execute()){
        $errorDesc = "Ocurrió un error al cargar las fechas del periodo";
    }else{
        $periodo_rs = $stmt->fetch();
        $fecha_ini = fechaSlash($periodo_rs["Periodo_fecha_inicial"]);

    }
    $stmt->closeCursor();
?>

<!DOCTYPE html>
<html lang="es" prefix="og: http://ogp.me/ns#">
    <head>
	<title>APSA - Facultad de Ingeniería</title>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
        <link rel="icon" type="image/png" href="../img/favicon.png" />
        <link rel="stylesheet" href="../css/bootstrap-ulsa.min.css" type="text/css">
        <link rel="stylesheet" href="../css/indivisa.css" type="text/css">
        <link rel="stylesheet" href="../css/sgi.css?rand=<?php echo rand();?>" type="text/css">
        <link rel="stylesheet" href="../css/fa_all.css" type="text/css">
        <link rel="stylesheet" href="../css/jquery-ui.css" type="text/css">
        <link rel="stylesheet" href="../css/calendar.css" type="text/css">
        <script src="../js/util.js"></script>
    </head>
    <body>
        <div>
            <?php
                //--- Objeto que pinta menu
                $menuObj = new MainMenu($_SESSION["usuario_id"], $menu, $pdo, APSA, "Profesores del periodo");//usr, menu, pdo, sist
                $menuObj->printMenu();

                $tab = 1;
                if(isset($_GET["tab"])){
                    $tab = filter_input(INPUT_GET, "tab", FILTER_SANITIZE_NUMBER_INT);//limpia texto
                }

                if(!empty($_POST["desc"])){
                    $filter_desc = trim(filter_input(INPUT_POST, "desc", FILTER_SANITIZE_STRING,array('flags' => FILTER_FLAG_STRIP_LOW)));//limpia texto
                }
                if(!empty($_POST["clave"])){
                    $filter_clave = filter_input(INPUT_POST, "clave", FILTER_SANITIZE_NUMBER_INT);//limpia texto
                }
                if(!empty($_POST["area"])){
                    $filter_area = filter_input(INPUT_POST, "area", FILTER_SANITIZE_NUMBER_INT);//limpia texto
                }
                if(!empty($_POST["carrera"])){
                    $filter_carrera = filter_input(INPUT_POST, "carrera", FILTER_SANITIZE_NUMBER_INT);//limpia texto  
                }


                $query1 = "";
                if(isset($filter_desc)){
                    $query1 .= ":nom, ";
                    //$filter_desc = trim(filter_input(INPUT_POST, "desc", FILTER_SANITIZE_STRING,array('flags' => FILTER_FLAG_STRIP_LOW)));//limpia texto
                }else{
                    $query1 .= "NULL, ";
                }
                if(isset($filter_clave)){
                    $query1 .= ":clave, ";
                    $filter_clave = trim(filter_input(INPUT_POST, "clave", FILTER_SANITIZE_STRING,array('flags' => FILTER_FLAG_STRIP_LOW)));//limpia texto
                }else{
                    $query1 .= "NULL, ";
                }
                
                
                $stmt = $pdo->prepare('Select * from fs_profesoresperiodo_busca(:periodo, '.$query1.' 0, '.MAX_ROWS.')');
                $stmt->bindParam(":periodo", $_SESSION["periodo_id"]);
                if(isset($filter_desc)) $stmt->bindParam(":nom", $filter_desc);
                if(isset($filter_clave)) $stmt->bindParam(":clave", $filter_clave);
                
                if(!$stmt->execute()){
                    $errorDesc = "Ocurrió un error al cargar los usuarios.";
                    print_r($stmt->errorInfo());
                }else
                    $usuario1_rs = $stmt->fetchAll();
                $stmt->closeCursor();
                
                //Periodos
                $stmt = $pdo->prepare('Select * from fs_periodousuario(:usr)');
                $stmt->bindParam(":usr", $_SESSION["usuario_id"]);
                if(!$stmt->execute()){
                    $errorDesc = "Ocurrió un error al cargar los datos de los periodos.";
                }else
                    $periodo_rs = $stmt->fetchAll();
                $stmt->closeCursor();
                $stmt = null;
                //------------
                //Area
                $stmt = $pdo->prepare('Select * from fs_areaacademica(NULL, :nivel)');
                $stmt->bindParam(":nivel", $_SESSION["nivel_id"]);
                if(!$stmt->execute()){
                    $errorDesc = "Ocurrió un error al cargar las áreas académicas";
                }else{
                    $area_rs = $stmt->fetchAll();
                }
                $stmt->closeCursor();
                
                $query2 ="";
                if(isset($filter_area)){
                    $query2 .= ":area, ";
                    //$filter_area = filter_input(INPUT_POST, "area", FILTER_SANITIZE_NUMBER_INT);//limpia texto
                }else{
                    $query2 .= "NULL, ";
                }
                if(isset($filter_desc)){
                    $query2 .= ":nom, ";
                    //$filter_desc = trim(filter_input(INPUT_POST, "desc", FILTER_SANITIZE_STRING,array('flags' => FILTER_FLAG_STRIP_LOW)));//limpia texto
                }else{
                    $query2 .= "NULL, ";
                }
                if(isset($filter_clave)){
                    $query2 .= ":clave, ";
                    //$filter_clave = filter_input(INPUT_POST, "clave", FILTER_SANITIZE_NUMBER_INT);//limpia texto
                }else{
                    $query2 .= "'', ";
                }


                $stmt = $pdo->prepare('Select * from fs_profesoresarea('.$query2.' :periodo, 1, 0, NULL)');
                if(isset($filter_area)) $stmt->bindParam(":area", $filter_area);
                if(isset($filter_desc)) $stmt->bindParam(":nom", $filter_desc);
                if(isset($filter_clave)) $stmt->bindParam(":clave", $filter_clave);
                $stmt->bindParam(":periodo", $_SESSION["periodo_id"]);
                
                if(!$stmt->execute()){
                    $errorDesc = "Ocurrió un error al cargar los profesores.";
                    print_r($stmt->errorInfo());
                }else
                    $usuario2_rs = $stmt->fetchAll();
                $stmt->closeCursor();

                if(!empty($filter_area)){
                    $stmt = $pdo->prepare('Select * from fs_profesorescarrera_faltantes(:periodo, NULL, :area)');
                    $stmt->bindParam(":area", $filter_area);
                    $stmt->bindParam(":periodo", $_SESSION["periodo_id"]);
                    
                    if(!$stmt->execute()){
                        $errorDesc = "Ocurrió un error al cargar los profesores faltantes.";
                        print_r($stmt->errorInfo());
                    }else
                        $materia_rs = $stmt->fetchAll();
                    $stmt->closeCursor();
                }

                //------------

                //Carrera
                $stmt = $pdo->prepare('Select * from fs_carrera(NULL, :nivel, false)');
                $stmt->bindParam(":nivel", $_SESSION["nivel_id"]);
                if(!$stmt->execute()){
                    $errorDesc = "Ocurrió un error al cargar las áreas académicas";
                }else{
                    $carrera_rs = $stmt->fetchAll();
                }
                $stmt->closeCursor();

                if(!empty($filter_carrera)){
                    $filter_carrera = filter_input(INPUT_POST, "carrera", FILTER_SANITIZE_NUMBER_INT);//limpia texto                
                    $query3 ="";
                    if(isset($filter_desc)){
                        $query3 .= ":nom, ";
                        //$filter_desc = trim(filter_input(INPUT_POST, "desc", FILTER_SANITIZE_STRING,array('flags' => FILTER_FLAG_STRIP_LOW)));//limpia texto
                    }else{
                        $query3 .= "'', ";
                    }
                    if(isset($filter_clave)){
                        $query3 .= ":clave, ";
                        //$filter_clave = filter_input(INPUT_POST, "clave", FILTER_SANITIZE_NUMBER_INT);//limpia texto
                    }else{
                        $query3 .= "'', ";
                    }
                
                    //echo 'Select * from fs_profesorescarrera('.$query.$_SESSION["periodo_id"].', 1, 0, '.MAX_ROWS.')';
                    
                    $stmt = $pdo->prepare('Select * from fs_profesorescarrera(:carrera, '.$query3.' :periodo)');
                    $stmt->bindParam(":carrera", $filter_carrera);
                    if(isset($filter_desc)) $stmt->bindParam(":nom", $filter_desc);
                    if(isset($filter_clave)) $stmt->bindParam(":clave", $filter_clave);
                    $stmt->bindParam(":periodo", $_SESSION["periodo_id"]);
                    
                    if(!$stmt->execute()){
                        $errorDesc = "Ocurrió un error al cargar los profesores.";
                        print_r($stmt->errorInfo());
                    }else
                        $usuario3_rs = $stmt->fetchAll();
                    $stmt->closeCursor();

                    /*$stmt = $pdo->prepare('Select * from fs_profesorescarrera_faltantes(:periodo, :carrera, NULL)');
                    $stmt->bindParam(":carrera", $filter_carrera);
                    $stmt->bindParam(":periodo", $_SESSION["periodo_id"]);
                    
                    if(!$stmt->execute()){
                        $errorDesc = "Ocurrió un error al cargar los profesores faltantes.";
                        print_r($stmt->errorInfo());
                    }else
                        $materia_rs = $stmt->fetchAll();
                    $stmt->closeCursor();*/
                }
                //--------
                //Obtiene profesores
                
                $query4 = "";
                if(isset($filter_area)){
                    $query4 .= ":area,";
                }else{
                    $query4 .= "NULL,";
                }
                if(isset($filter_desc)){
                    $query4 .= ":desc,";
                }else{
                    $query4 .= "NULL,";
                }
                /*echo 'Select * from fs_profesoresareahoras('.$_SESSION["periodo_id"].', '.$query4.' 1, 0, '.MAX_ROWS.')';
                echo $filter_area;
                exit();*/
                $stmt = $pdo->prepare('Select * from fs_profesoresareahoras(:per, '.$query4.' 1, 0, '.MAX_ROWS.')');//sólo activos
                $stmt->bindParam(":per", $_SESSION["periodo_id"]);
                if(isset($filter_area)) $stmt->bindParam(":area", $filter_area);
                if(isset($filter_desc)) $stmt->bindParam(":desc", $filter_desc);
                if(!$stmt->execute()){
                    $errorDesc = "Ocurrió un error al cargar los profesores";
                    //print_r($stmt->errorInfo());
                }else{
                    $usuario4_rs = $stmt->fetchAll();
                }
                $stmt->closeCursor();

                //--------
                
                //--Manejo de errores y mensajes de exito
                if(isset($_GET["error"]) && is_numeric($_GET["error"])){
                    switch ($_GET["error"]){
                        case 0: $errorDesc = "No se reciberon los datos del usuario."; break;
                        case 1: $errorDesc = "No existe el usuario que buscas. Selecciona una del listado."; break;
                        case 2: $errorDesc = "Ocurrió un error al leer los datos del usuario."; break;
                        case 3: $errorDesc = "No tienes permisos para realizar esa acción."; break;
                    }
                }
                if(isset($_GET["ok"]) && is_numeric($_GET["ok"])){
                    switch ($_GET["ok"]){
                        case 0: $successDesc = "El usuario se guardó correctamente."; break;
                        case 1: $successDesc = "El usuario se actualizó correctamente."; break;
                    }
                }
            ?>
            <main class="container-fluid content marco">
                
                <?php include_once("../include/errorMessage.php");?>
                <?php $show_all=true; include("../include/periodoCambio.php");?>

                <!-- <form action="./export/xls_profesoresperiodo.php" method="post" target="_blank"> -->
                <form action="./export/xls_profesorarea.php" target="_blank" method="post" id="formaXls">
                    <input type="hidden" name="area" value="<?php if(isset($filter_area)){ echo $filter_area; }?>">
                    <input type="hidden" name="carrera" value="<?php if(isset($filter_carrera)){ echo $filter_carrera; }?>">
                    <input type="hidden" name="desc" value="<?php if(isset($filter_desc)){ echo $filter_desc; }?>">
                    <input type="hidden" name="clave" value="<?php if(isset($filter_clave)){ echo $filter_clave; }?>">
                </form>

                <!-- Filtro -->
                <form action="reporte_horarioprofesores.php" method="post" id="formaProf">
                    <input type="hidden" name="desc" id="desc">
                    <input type="hidden" name="clave" id="clave">
                    <input type="hidden" name="area" id="area">
                    <input type="hidden" name="carrera" id="carrera">
                </form>
                <!-- end Filtro -->
                    <ul class="nav nav-tabs d-print-none mb-4" id="myTab" role="tablist">
                        <li class="nav-item">
                            <a class="nav-link" id="tab1-tab" data-toggle="tab" href="#tab1" role="tab" aria-controls="calendario" aria-selected="true">Profesores del periodo</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" id="tab2-tab" data-toggle="tab" href="#tab2" role="tab" aria-controls="lista" aria-selected="false">Por área</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" id="tab3-tab" data-toggle="tab" href="#tab3" role="tab" aria-controls="lista" aria-selected="false">Por Carrera</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" id="tab4-tab" data-toggle="tab" href="#tab4" role="tab" aria-controls="lista" aria-selected="false">Por Materia</a>
                        </li>
                    </ul>
                    <div class="tab-content" id="TabContent">
                        <div class="tab-pane fade" id="tab1" role="tabpanel" aria-labelledby="tab1-tab">
                            <?php
                            if(isset($usuario1_rs) && count($usuario1_rs) > 0){
                            ?>
                            <p class="text-right"><button type="button" class="btn btn-outline-secondary btn-xls" data-xls="xls_profesoresperiodo.php"><?php echo $ICO["descargar"]; ?> Generar xls</button></p>
                            <?php } ?>
                            <?php // ---- Listado total ---- ?>
                            <div class="form-box form-box-info">
                                <div class="form-group row">
                                    <label for="filter_desc1" class="col-4 col-form-label text-right">Nombre</label> 
                                    <div class="col-8 col-sm-4">
                                        <input id="filter_desc1" type="text" class="form-control text-submit" <?php if(isset($filter_desc) ){echo 'value="'.$filter_desc.'"';}?>>
                                    </div>
                                </div>
                                <div class="form-group row">
                                    <label for="filter_clave1" class="col-4 col-form-label text-right">Clave ULSA</label> 
                                    <div class="col-8 col-sm-4">
                                        <input id="filter_clave1" type="text" class="form-control text-submit" <?php if(isset($filter_clave) ){echo 'value="'.$filter_clave.'"';}?>>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-12 text-center">
                                    <button type="button" class="btn btn-outline-primary btn-enviar" data-campo="1"><?php echo $ICO["buscar"]; ?> Filtrar</button>
                                    <button type="button" class="btn btn-outline-danger btn-reset"><?php echo $ICO["borrar"]?> Limpiar</button>
                                </div>
                            </div>
                            <?php
                            if(isset($usuario1_rs)){
                            ?>
                            <div class="row">
                                <div class="col-12 table-responsive">
                                    <p>Se muestran los primeros <strong><?php echo MAX_ROWS;?></strong> resultados. Utiliza los filtros para encontrar el usuario que buscas.</p>
                                    
                                    <table class="table table-sm table-striped table-white">
                                        <thead class="thead-dark">
                                            <tr >
                                                <th>Clave</th>
                                                <th>Grado</th>
                                                <th>Nombre</th>
                                                <th>Ver</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            foreach($usuario1_rs as $usuario){
                                            ?>
                                            <tr data-id="<?php echo $usuario["Usuario_id"]; ?>">
                                                <td class="text-center font-weight-bold"><?php echo $usuario["Usuario_claveULSA"] ?></td>
                                                <td class="text-center"><?php echo $usuario["Usuario_grado"] ?></td>
                                                <td><?php echo $usuario["Usuario_apellidos"]." ".$usuario["Usuario_nombre"]; ?></td>
                                                <td class="text-center icono-acciones">
                                                    <span class="pointer modal-open" title="Datos"><?php echo $ICO["buscar"];?></span>
                                                    <span class="pointer open-pdf" title="Horario de usuario" data-id="<?php echo $usuario["Usuario_id"]; ?>"><?php echo $ICO["calendario"];?></span>
                                                </td>
                                            </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                            <?php } ?>
                        </div>
                        <div class="tab-pane fade" id="tab2" role="tabpanel" aria-labelledby="tab2-tab">
                            <?php
                            if(isset($usuario2_rs) && count($usuario2_rs) > 0){
                            ?>
                            <p class="text-right"><button type="button" class="btn btn-outline-secondary btn-xls" data-xls="xls_profesorarea.php"><?php echo $ICO["descargar"]; ?> Generar xls</button></p>
                            <?php } ?>
                            <!-- Filtro -->
                
                            
                            <?php if(count($area_rs) > 1){ ?>
                            <div class="form-box form-box-info">
                                <div class="form-group row">
                                    <label for="filter_desc2" class="col-4 col-form-label text-right">Nombre</label> 
                                    <div class="col-8 col-sm-4">
                                        <input id="filter_desc2" type="text" class="form-control text-submit" <?php if(isset($filter_desc) ){echo 'value="'.$filter_desc.'"';}?>>
                                    </div>
                                </div>
                                <div class="form-group row">
                                    <label for="filter_clave2" class="col-4 col-form-label text-rightt">Clave ULSA</label> 
                                    <div class="col-8 col-sm-4">
                                        <input id="filter_clave2" type="text" class="form-control text-submit" <?php if(isset($filter_clave) ){echo 'value="'.$filter_clave.'"';}?>>
                                    </div>
                                </div>
                            
                                <div class="form-group row">
                                    <label for="filter_area2" class="col-4 col-form-label">Área *</label> 
                                    <div class="col-8 col-sm-4">
                                        <div class="datalist datalist-select mb-1 w-100">
                                            <div class="datalist-input">Selecciona un área</div>
                                            <span class="ing-buscar icono"></span>
                                            <ul style="display:none">
                                                <?php foreach($area_rs as $area) {?>
                                                <li data-id="<?php echo $area["Area_id"];?>" <?php if(isset($filter_area) && $filter_area == $area["Area_id"]){echo "class='selected'";}?>><?php echo $area["Area_desc"];?></li>
                                                <?php }?>
                                            </ul>
                                            <input type="hidden" id="filter_area2" value="0">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <?php } ?>
                            
                            <div class="form-group row">
                                <div class="col-12 text-center">
                                    <button type="button" class="btn btn-outline-primary btn-enviar" data-campo="2"><?php echo $ICO["buscar"]; ?> Filtrar</button>
                                    <button type="button" class="btn btn-outline-danger btn-reset"><?php echo $ICO["borrar"]?> Limpiar</button>
                                </div>
                            </div>
                                    
                            <!-- end Filtro -->
                            <?php
                            if(isset($usuario2_rs)){
                                if(count($usuario2_rs) > 0){
                            ?>
                            
                            <?php }?>
                            <div class="row">
                                <div class="col-12 table-responsive">
                                    <table class="table table-sm table-striped table-white">
                                        <thead class="thead-dark">
                                            <tr >
                                                <th>Clave</th>
                                                <th>Grado</th>
                                                <th>Nombre</th>
                                                <th>Área</th>
                                                <th>Ver</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            foreach($usuario2_rs as $usuario){
                                            ?>
                                            <tr data-id="<?php echo $usuario["Usuario_id"]; ?>">
                                                <td class="text-center font-weight-bold"><?php echo $usuario["Usuario_claveULSA"] ?></td>
                                                <td><?php echo $usuario["Usuario_grado"] ?></td>
                                                <td><?php echo $usuario["Usuario_apellidos"]." ".$usuario["Usuario_nombre"]; ?></td>
                                                <td><span style="color:<?php echo $usuario["Area_color"];?>"><?php echo $ICO["circulo"]; ?></span> <?php echo $usuario["Area_desc"]?></td>
                                                <td class="text-center icono-acciones">
                                                    <span class="pointer modal-open" title="Datos"><?php echo $ICO["buscar"];?></span>
                                                    <span class="pointer open-pdf" title="Horario de usuario" data-id="<?php echo $usuario["Usuario_id"]; ?>"><?php echo $ICO["calendario"];?></span>
                                                </td>
                                            </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                            <?php } ?>

                            <?php if (isset($materia_rs) && count($materia_rs) > 0){ ?>
                            <h4 class="mt-4 mb-3">Materias que faltan de profesor</h4>
                            <div class="row">
                                <div class="col-12 table-responsive">
                                    <table class="table table-sm table-striped table-white">
                                        <thead class="thead-dark">
                                            <tr >
                                                <th>Grupo</th>
                                                <th>Materia</th>                                    
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            foreach($materia_rs as $materia){
                                            ?>
                                            <tr data-id="<?php echo $materia["Materia_id"]; ?>">
                                                <td><?php echo $materia["Grupo_desc"]." ".$materia["Carrera_prefijo"]; ?></td>
                                                <td><?php echo $materia["Materia_desc"] ?></td>
                                            </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                            <?php } ?>
                        </div>
                        <div class="tab-pane fade" id="tab3" role="tabpanel" aria-labelledby="tab3-tab">
                            <?php
                            if(isset($usuario3_rs) && count($usuario3_rs) > 0){
                            ?>
                            <p class="text-right"><button type="button" class="btn btn-outline-secondary btn-xls" data-xls="xls_profesorcarrera.php"><?php echo $ICO["descargar"]; ?> Generar xls</button></p>
                            <?php } ?>
                            <!-- Filtro -->
                            
                            
                            <?php if(count($carrera_rs) > 1){ ?>
                            <div class="form-box form-box-info">
                                <div class="form-group row">
                                    <label for="filter_desc3" class="col-4 col-form-label text-right">Nombre</label> 
                                    <div class="col-8 col-sm-4">
                                        <input id="filter_desc3" type="text" class="form-control text-submit" <?php if(isset($filter_desc) ){echo 'value="'.$filter_desc.'"';}?>>
                                    </div>
                                </div>
                                <div class="form-group row">
                                    <label for="filter_clave3" class="col-4 col-form-label text-right">Clave ULSA</label> 
                                    <div class="col-8 col-sm-4">
                                        <input id="filter_clave3" type="text" class="form-control text-submit" <?php if(isset($filter_clave) ){echo 'value="'.$filter_clave.'"';}?>>
                                    </div>
                                </div>
                            
                                <div class="form-group row">
                                    <label for="filter_carrera" class="col-4 col-form-label">Carrera *</label> 
                                    <div class="col-8 col-sm-4">
                                        <div class="datalist datalist-select mb-1 w-100">
                                            <div class="datalist-input">Selecciona una carrera</div>
                                            <span class="ing-buscar icono"></span>
                                            <ul style="display:none">
                                                <?php foreach($carrera_rs as $carrera) {?>
                                                <li data-id="<?php echo $carrera["Carrera_id"];?>" <?php if(isset($filter_carrera) && $filter_carrera == $carrera["Carrera_id"]){echo "class='selected'";}?>><?php echo $carrera["Carrera_desc"];?></li>
                                                <?php }?>
                                            </ul>
                                            <input type="hidden" id="filter_carrera" name="carrera" value="0">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <?php } ?>
                             
                            <div class="form-group row">
                                <div class="col-12 text-center">
                                    <button type="button" class="btn btn-outline-primary btn-enviar" data-campo="3"><?php echo $ICO["buscar"]; ?> Filtrar</button>
                                    <button type="button" class="btn btn-outline-danger btn-reset"><?php echo $ICO["borrar"]?> Limpiar</button>
                                </div>
                            </div>
                                    
                            <!-- end Filtro -->
                            <?php
                            if(isset($usuario3_rs)){
                                if(count($usuario3_rs) > 0){
                            ?>
                            
                            <?php }?>
                            <div class="row">
                                <div class="col-12 table-responsive">
                                    <table class="table table-sm table-striped table-white">
                                        <thead class="thead-dark">
                                            <tr >
                                                <th>Clave</th>
                                                <th>Grado</th>
                                                <th>Nombre</th>
                                                <th>Materia</th>
                                                <th>Semestre</th>
                                                <th>Ver</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            foreach($usuario3_rs as $usuario){
                                            ?>
                                            <tr data-id="<?php echo $usuario["Usuario_id"]; ?>">
                                                <td class="text-center font-weight-bold"><?php echo $usuario["Usuario_claveULSA"] ?></td>
                                                <td ><?php echo $usuario["Usuario_grado"] ?></td>
                                                <td><?php echo $usuario["Usuario_apellidos"]." ".$usuario["Usuario_nombre"]; ?></td>
                                                <td><?php echo $usuario["Materia_desc"] ?></td>
                                                <td class="text-center "><?php echo $usuario["Materia_semestre"] ?></td>
                                                <td class="text-center icono-acciones text-nowrap">
                                                    <span class="pointer modal-open" title="Datos"><?php echo $ICO["buscar"];?></span>
                                                    <span class="pointer open-pdf" title="Horario de usuario" data-id="<?php echo $usuario["Usuario_id"]; ?>"><?php echo $ICO["calendario"];?></span>
                                                </td>
                                            </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                            <?php } ?>

                            <?php if (isset($materia_rs) && count($materia_rs) > 0){ ?>
                            <h4 class="mt-4 mb-3">Materias que faltan de profesor</h4>
                            <div class="row">
                                <div class="col-12 table-responsive">
                                    <table class="table table-sm table-striped table-white">
                                        <thead class="thead-dark">
                                            <tr >
                                                <th>Grupo</th>
                                                <th>Materia</th>                                    
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            foreach($materia_rs as $materia){
                                            ?>
                                            <tr data-id="<?php echo $materia["Materia_id"]; ?>">
                                                <td><?php echo $materia["Grupo_desc"]." ".$materia["Carrera_prefijo"]; ?></td>
                                                <td><?php echo $materia["Materia_desc"] ?></td>
                                            </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                            <?php } ?>
                        </div>
                        <div class="tab-pane fade" id="tab4" role="tabpanel" aria-labelledby="tab4-tab">
                        <?php
                        
                            if(isset($usuario4_rs) && count($usuario4_rs) > 0){
                            ?>
                            <p class="text-right"><button type="button" class="btn btn-outline-secondary btn-xls" data-xls="xls_materiasprofesor.php"><?php echo $ICO["descargar"]; ?> Generar xls</button></p>
                            <?php } ?>

                            <div class="row">
                                <div class="col-12">
                                    <form action="reporte_horarioprofesores.php" method="post">
                                        <div class="form-box form-box-info">
                                            <div class="form-group row">
                                                <label for="filter_desc4" class="col-4 col-form-label">Nombre</label> 
                                                <div class="col-8 col-sm-4">
                                                    <input id="filter_desc4" name="desc" type="text" class="form-control" <?php if(isset($filter_desc) ){echo 'value="'.$filter_desc.'"';}?>>
                                                </div>
                                            </div>
                                            <?php if(count($area_rs) > 1){ ?>
                                            <div class="form-group row">
                                                <label for="filter_area4" class="col-4 col-form-label">Área *</label> 
                                                <div class="col-8 col-sm-4">
                                                    <div class="datalist datalist-select mb-1 w-100">
                                                        <div class="datalist-input">Ver todas</div>
                                                        <span class="ing-buscar icono"></span>
                                                        <ul style="display:none">
                                                            <li data-id="">Ver todas</li>
                                                            <?php foreach($area_rs as $area) {?>
                                                            <li data-id="<?php echo $area["Area_id"];?>" <?php if(isset($filter_area) && $filter_area == $area["Area_id"]){echo "class='selected'";}?>><?php echo $area["Area_desc"];?></li>
                                                            <?php }?>
                                                        </ul>
                                                        <input type="hidden" id="filter_area4" value="0">
                                                    </div>
                                                </div>
                                            </div>
                                            <?php } ?>
                                        </div>
                                        <div class="form-group row">
                                            <div class="col-12 text-center">
                                                <button type="button" class="btn btn-outline-primary btn-enviar" data-campo="4"><?php echo $ICO["buscar"]; ?> Filtrar</button>
                                                <button type="button" class="btn btn-outline-danger btn-reset"><?php echo $ICO["borrar"]?> Limpiar</button>
                                            </div>
                                        </div>
                                    </form>
                                </div>
                            </div>


                            <div class="row">
                                <div class="col-12 table-responsive">
                                    <p>Se muestran los primeros <strong><?php echo MAX_ROWS;?></strong> resultados. Utiliza los filtros para encontrar el usuario que buscas.</p>
                                    <table class="table table-sm table-striped table-white">
                                        <thead class="thead-dark">
                                            <tr >
                                                <th>Clave ULSA</th>
                                                <th>Profesor</th>
                                                <th>
                                                    <div class="row">
                                                        <div class="col-8">Materias</div>
                                                        <div class="col-4 text-center">Horas</div>
                                                    </div>
                                                </th>
                                                <th>Total</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            //$i=0;
                                            $query = "";
                                            if(isset($filter_area)){
                                                $query .= ' AND "Area_id" = :area';
                                            }

                                            //Obtiene horario del usuario
                                            
                                            $stmt = $pdo->prepare('Select * from fs_mihorario(:usr, :per, 3) WHERE "TipoHorario_id" = 3 '.$query);//Obtiene calendario docente
                                            $stmt->bindParam(":per", $_SESSION["periodo_id"]);
                                            if($query != "") $stmt->bindParam(":area", $filter_area);
                                            foreach($usuario4_rs as $profesor){
            //                                    if($i >= MAX_ROWS) break;
                                                $stmt->bindParam(":usr", $profesor["Usuario_id"]);

                                                if(!$stmt->execute()){
                                                    //$t = $stmt->errorInfo();
                                                    echo "Ocurrió un error al obtener los horarios de los profesores";
                                                    //print_r($stmt->errorInfo());
                                                    break;
                                                }
                                                $horario_rs = $stmt->fetchAll();
                                                $materiasArr = array();
                                                
                                                if(count($horario_rs) > 0){
                                                    //$i++;

                                                    for($rs_i = 0; $rs_i < count($horario_rs);){
                                                        if((!isset($filter_area) || $filter_area=="" ) || (isset($filter_area) && $filter_area == $horario_rs[$rs_i]["Area_id"])){
                                                            $horas = $horario_rs[$rs_i]["Duracion"]/60;
                                                            $nombreArr = array();
                                                            $key = "";//lave para guardar cuáles se agruparán
                                                            do{
                                                                $nombreArr[] = $horario_rs[$rs_i]["Materia_desc"]." (".$horario_rs[$rs_i]["Carrera_prefijo"].")";
                                                                $key .= $horario_rs[$rs_i]["Materia_desc"].$horario_rs[$rs_i]["Carrera_prefijo"];
                                                                $rs_i++;
                                                            }while($rs_i < count($horario_rs) && date('H:i', strtotime($horario_rs[$rs_i-1]["Hora_inicio"])) == date('H:i', strtotime($horario_rs[$rs_i]["Hora_inicio"])) && $horario_rs[$rs_i]["Dia_id"] == $horario_rs[$rs_i-1]["Dia_id"]);

                                                            $materiasArr[] = array("key"=>md5($key), "nombreArr" => $nombreArr, "horas"=>$horas);
                                                        }
                                                    }
                                                    
                                                    //fusiona horarios por llaves iguales
                                                    for($ii = 0; $ii < count($materiasArr)-1; $ii++){
                                                        for($jj = $ii+1; $jj < count($materiasArr); ){
                                                            if($materiasArr[$ii]["key"] == $materiasArr[$jj]["key"]){
                                                                $materiasArr[$ii]["horas"] += $materiasArr[$jj]["horas"];
                                                                array_splice($materiasArr, $jj, 1);
                                                            }else
                                                                $jj++;
                                                        }
                                                    }
                                                ?>
                                            <tr>
                                                <td class="text-center font-weight-bold"><?php echo $profesor["Usuario_claveULSA"];?></td>
                                                <td><?php echo $profesor["Usuario_apellidos"]." ".$profesor["Usuario_nombre"]; ?></td>
                                                <td>
                                                    <?php 
                                                    $sumMat = 0;
                                                    foreach($materiasArr as $materia){ ?>
                                                    <div class="row border-mid">
                                                        <div class="col-8">
                                                            <?php
                                                            foreach($materia["nombreArr"] as $nombre){
                                                                echo $nombre."<br>";
                                                            }
                                                            $sumMat+=$materia["horas"];
                                                            ?>
                                                        </div>
                                                        <div class="col-4 text-center">
                                                            <?php echo sprintf('%0.2f', $materia["horas"]);?> hrs.
                                                        </div>
                                                    </div>
                                                    <?php } ?>
                                                </td>
                                                <td class="text-center">
                                                    <?php echo sprintf('%0.2f', $sumMat);?> hrs.
                                                </td>
                                            </tr>
                                                <?php
                                                }
                                            }//foreach prof
                                            $stmt->closeCursor();
                                            //---------------
                                            
                                            
                                            ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>

                        </div>
                    </div>

                
            </main>
            <!--- FOOTER--->
            <?php require_once("../include/footer.php"); ?>
            
            <form id="pdfForm" action="./export/pdf_horariousuario.php" target="_blank" method="post">
                <input type="hidden" id="usr_id" name="id" value="">
                <input type="hidden" id="fecha_pdf" name="fecha" value="">
                <input type="hidden" id="tipo_pdf" name="tipo" value="">
            </form>
            
            <!-- Modal -->
            <div class="modal fade" id="modal" tabindex="-1" role="dialog" aria-labelledby="modal" aria-hidden="true">
                <div class="modal-dialog modal-dialog-centered modal-lg" role="document">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h4 class="col-12 modal-title text-center" id="modalLabel"><span class="usuario-nombre">Datos de usuario</span>
                                <button type="button" class="close text-white" data-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </h4>
                        </div>
                        <div class="modal-body pb-0">
                            <div class="row">
                                <div class="col-12 col-sm-5 col-md-3">
                                    <img src="" alt="Foto" class="img-fluid usr-foto">
                                </div>
                                <div class="col-12 col-sm-7 col-md-9">
                                    <!-- <div class="row">
                                        <div class="col-12 text-center mb-2">
                                            <h4><span class="font-weight-bold text-primary usuario-nombre"></span></h4>
                                        </div>
                                    </div> -->
                                    <div class="row">
                                        <div class="col-12">
                                            <p class="text-center"><b>Clave ULSA:</b> <span class="usuario-clave"></span> |
                                            <b>Fecha de ingeso:</b> <span class="usuario-ingreso"></span> |
                                            <b>Estado:</b> <span class="usuario-estado"></span></p>
                                        </div>
                                        <div class="col-12">
                                            <p id="contacto_list">
                                            </p>
                                        </div>
                                    </div>

                                    <div class="usuario-profesor-block mt-4">
                                        <div class="row">
                                            <div class="col-12">
                                                <p><i class="ing-cuadrado text-primary mr-3"></i> <span class="font-weight-bold usuario-categoria"></span> </p>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="bg-primary text-white py-2 px-4 mt-4" style="margin-left: -16px; margin-right: -16px;">
                                <div class="row">
                                    <div class="col-6">
                                        <h5 id="usuario-tipo"></h5>
                                    </div>
                                    <div class="col-6 text-right">
                                        <!--<a href="#" class="open-pdf btn btn-outline-primary" title="Horario final" data-id="" id="btn-horario">Ver horario</a>-->
                                    </div>
                                </div>
                            </div>
                            
                            
                        </div><!-- body -->
                    </div>
                </div>
            </div>
            
            <!-- Modal fecha Horario -->
            <div class="modal fade" id="modalFecha" tabindex="-1" role="dialog" aria-labelledby="modal" aria-hidden="true">
                <div class="modal-dialog modal-dialog-centered" role="document">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h4 class="col-12 modal-title text-center" id="modalLabel">Abrir horario
                                <button type="button" class="close text-white" data-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </h4>
                        </div>
                        <div class="modal-body pb-0">
                            <form action="" method="post">
                                <div class="form-box">
                                    <div class="form-group row">
                                        <label for="filter_fecha" class="col-4 col-form-label text-right">Fecha *</label> 
                                        <div class="col-8">
                                            <input id="filter_fecha" name="fecha" type="text" class="form-control date-picker" placeholder="dd/mm/aaaa" maxlength="10" required="required" readonly="readonly" value="<?php if(isset($filter_fecha)){ echo fechaSlash($filter_fecha);}else{ echo $fecha_ini;}?>">
                                        </div>
                                    </div>
                                    <div class="form-group row align-items-center">
                                        <label class="col-4 col-form-label">Tipo horarios</label> 
                                        <div class="col-4 ">
                                            <div class="form-check form-check-inline">
                                                <input class="form-check-input radio-lg" type="radio" id="tipo_todos" name="tipo" value="0" checked="true">
                                                <label for="tipo_todos" class="col-form-label">Todos</label> 
                                            </div>
                                        </div>
                                        <div class="col-4 ">
                                            <div class="form-check form-check-inline">
                                                <input class="form-check-input radio-lg" type="radio" id="tipo_docencia" name="tipo" value="1">
                                                <label for="tipo_docencia" class="col-form-label">Docencia</label> 
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="form-group row">
                                    <div class="col-12 text-center">
                                        <button type="button" class="btn btn-outline-primary btn-fecha"><?php echo $ICO["calendario"];?> Abrir horario</button>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        
        <script src="../js/jquery.min.js"></script>
        <script src="../js/jquery-ui.js"></script>
        <script src="../js/datepicker-es.js"></script>
        <script src="../js/bootstrap/popper.min.js"></script>
        <script src="../js/bootstrap/bootstrap.min.js"></script>
        <script src="../js/sidebarmenu.js"></script>
        <script src="../js/datalist.js"></script>
        <script>
            var n = 1;
            $(document).on( "click", ".btn-reset", function(event){
                var forma = $(this).parents("form");
                forma.find("input[type=text]").val("");
                forma.find("select").prop("selectedIndex",0);
                //forma.submit();
                forma.prop("action", "reporte_horarioprofesores.php?tab="+n);
                forma.submit();
            });

            $(document).on( "click", ".btn-enviar", function(event){
                n = $(this).data("campo");
                console.log("N:"+n);
                switch(n){
                    case 1:
                        $("#desc").val($("#filter_desc1").val());
                        $("#clave").val($("#filter_clave1").val());
                        $("#area").val("");
                        $("#carrera").val("");
                    break;
                    case 2:
                        if($("#filter_area2").val()==0){
                            invalidDatalist("#filter_area2", true);
                            return;
                        }
                        $("#desc").val($("#filter_desc2").val());
                        $("#clave").val($("#filter_clave2").val());
                        $("#area").val($("#filter_area2").val());
                        $("#carrera").val("");
                    break;
                    case 3:
                        if($("#filter_carrera").val()==0){
                            invalidDatalist("#filter_carrera", true);
                            return;
                        }
                        $("#desc").val($("#filter_desc3").val());
                        $("#clave").val($("#filter_clave3").val());
                        $("#area").val($("#filter_area3").val());
                        $("#carrera").val($("#filter_carrera").val());
                    break;
                    case 4:
                        /*if($("#filter_carrera4").val()!=0 && $("#filter_carrera4").val()!=""){
                            $("#area").val($("#filter_area4").val());
                            return;
                        }*/
                        $("#desc").val($("#filter_desc4").val());
                        $("#clave").val("");
                        $("#area").val($("#filter_area4").val());
                        $("#carrera").val("");
                    break;
                }
                
                $("#formaProf").prop("action", "reporte_horarioprofesores.php?tab="+n);
                $("#formaProf").submit();
            });


            $('.text-submit').keydown(function(event) {
                var btn = $(this).parents(".tab-pane").find(".btn-enviar");
                
                // enter has keyCode = 13, change it if you want to use another button
                if (event.keyCode == 13) {
                    btn.click()
                }
            });

            $('#myTab a').on('click', function (e) {
                invalidDatalist("#filter_carrera", false);
                invalidDatalist("#filter_area", false);
            })

            $(document).on( "click", ".btn-xls", function(event){
                var pag = $(this).data("xls");
                $("#formaXls").prop("action", "./export/"+pag);
                $("#formaXls").submit();
            });

            $(document).on( "click", ".open-pdf", function(event){
                $("#usr_id").val($(this).data("id"));
                $('#modalFecha').modal("show");
                //$("#pdfForm").submit();
            });
            
            $(document).on( "click", ".btn-fecha", function(event){
                $("#fecha_pdf").val($("#filter_fecha").val());
                $("#tipo_pdf").val( $('#modalFecha input[name="tipo"]:checked').val()  );
                $("#pdfForm").submit();
            });
            
            
            $(document).ready(function(){
                setDatalist("#periodo", <?php echo $_SESSION["periodo_id"]; ?>);

                $('#tab<?php echo $tab;?>-tab').tab('show');

                $(document).on('click', '#dlPeriodo ul li' ,function(){
                    $("#formaPeriodo").submit();
                });
                
                $(".date-picker" ).datepicker({ dateFormat: "dd/mm/yy" });
                $(".date-picker" ).datepicker( $.datepicker.regional[ "es" ] );
                
                $(".modal-open").click(function(){
                    
                    $("#errorBox").collapse('hide');
                    $("#errorBox_text").html("");
                    
                    var id =  $(this).parents("tr").data("id");
                    $.ajax({
                        url:  './action/usuario_select.php',
                        type: 'POST', 
                        dataType: 'json',
                        data: { id: id },
                        success: function(result) {
                            if(result["error"]!= "" &&  result["error"] !== undefined){
                                $("#errorBox").collapse('show');
                                $("#errorBox_text").html(result["error"]);
                                $('#messageBox')[0].scrollIntoView({ block: "end" });
                            }else{
                                $("#modal .usuario-nombre").text(result["apellidos"]+" "+result["nombre"]);
                                $("#modal .usuario-clave").text(result["clave"]);
                                $("#modal .usuario-ingreso").text(result["ingreso"]);
                                $("#modal .usuario-estado").text(result["estado"]);
                                $("#modal .usr-foto").prop("src", "../img/fotos/"+result["foto"]);
                                $("#modal #btn-horario").data("id", id);
                                
                                var contactoHTML ="<ul type='square'>";
                                for(var i=0; i < result["contacto"].length; i++){
                                    //if(contactoHTML != "") contactoHTML+= " | ";
                                    contactoHTML += "<li class='text-nowrap'><b>"+result["contacto"][i]["desc"]+": </b> "+result["contacto"][i]["valor"]+"</li>";
                                }
                                contactoHTML +="</ul>";
                                $("#modal #contacto_list").html(contactoHTML);
                                if(result["contacto"].length == 0){
                                    $("#contacto_list").hide();
                                }else{
                                    $("#contacto_list").show();
                                }
                                
                                if(result["esProfesor"] == 1){
                                    $("#modal .usuario-profesor-block").removeClass("d-none");
                                    $("#modal .usuario-categoria").text(result["categoria"]);
                                }else{
                                    $("#modal .usuario-profesor-block").addClass("d-none");
                                }
                                
                                if(result["esProfesor"] == 1 && result["esAdministrativo"] == 1){
                                    $('#usuario-tipo').text("Profesor | Administrativo");
                                }else if(result["esProfesor"] == 1){
                                    $('#usuario-tipo').text("Profesor");
                                }else if(result["esAdministrativo"] == 1){
                                    $('#usuario-tipo').text("Administrativo");
                                }
                                $('#modal').modal("show");
                            }
                        },
                        error: function(jqXHR, textStatus, errorThrown ){
                            $("#errorBox").collapse('show');
                            $("#errorBox_text").html(errorThrown);
                        }
                    });//ajax
                });//click
            });
        </script>
    </body>
</html>