Atenea
/
sgi


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

    $menu = 6;
    $submenu = 65;

    //--- Objeto para validar usuario. El id de usuario lo lee desde sesión
    $objSesion = new ValidaSesion($pdo, $submenu, APSA);
    if(!$objSesion->tieneAcceso() || !$objSesion->puedeEditar()){
        header("Location: main.php");
        exit;
    }
    if(!isset($_GET["id"]) || trim($_GET["id"]) == ""){
        header("Location: materias.php?error=0");
        exit;
    }
    $id = filter_input(INPUT_GET, "id", FILTER_SANITIZE_NUMBER_INT);//limpia texto
    
    //Datos de materia
    $stmt = $pdo->prepare('Select * from fs_materia(:id, NULL, NULL, NULL, NULL, 0, 1)');
    $stmt->bindParam(":id", $id);
    if(!$stmt->execute()){
        header("Location: materias.php?error=2");
        exit();
    }else{
        $materia_rs = $stmt->fetch();
    }
    $stmt->closeCursor();
    if(!is_array($materia_rs) || count($materia_rs) == 0){
        header("Location: materias.php?error=1");
        exit();
    }
    
?>

<!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">
        <link rel="stylesheet" href="../css/toggle.css" type="text/css">
    </head>
    <body>
        <div>
            <?php
                //--- Objeto que pinta menu
                $menuObj = new MainMenu($_SESSION["usuario_id"], $menu, $pdo, APSA, "Editar Materia");//usr, menu, pdo, sist
                $menuObj->printMenu();
                
                
                $stmt = $pdo->prepare('Select * from fs_submateria(:id, NULL)');
                $stmt->bindParam(":id", $id);
                if(!$stmt->execute()){
                    $errorDesc = "Ocurrió un error al leer los datos de las submaterias.";
                }else{
                    $submateria_rs = $stmt->fetchAll();
                }
                $stmt->closeCursor();
                
                $stmt = $pdo->prepare('Select * from fs_materiarelacionada(:id)');
                $stmt->bindParam(":id", $id);
                if(!$stmt->execute()){
                    $errorDesc = "Ocurrió un error al leer los datos de las materias relacionadas.";
                }else{
                    $relacionada_rs = $stmt->fetchAll();
                }
                $stmt->closeCursor();
                
                
                //Area
                $stmt = $pdo->prepare('Select * from fs_areaacademica(NULL, NULL)');
                if(!$stmt->execute()){
                    $errorDesc = "Ocurrió un error al cargar las áreas académicas";
                }else{
                    $area_rs = $stmt->fetchAll();
                }
                $stmt->closeCursor();
                
                //Plan
                $stmt = $pdo->prepare('Select * from fs_planestudio(NULL, NULL, NULL, true, 0, NULL)');
                if(!$stmt->execute()){
                    $errorDesc = "Ocurrió un error al cargar los planes de estudio";
                }else{
                    $plan_rs = $stmt->fetchAll();
                }
                $stmt->closeCursor();
                
                //Tipo Submateria
                $stmt = $pdo->prepare('Select * from fs_tiposubmateria(NULL)');
                if(!$stmt->execute()){
                    $errorDesc = "Ocurrió un error al cargar el tipo de submateria";
                }else{
                    $tiposub_rs = $stmt->fetchAll();
                }
                $stmt->closeCursor();

                //Atributos
                $stmt = $pdo->prepare('Select * from fs_materia_atributoegreso(NULL, :mat)');
                $stmt->bindParam(":mat", $id);
                if(!$stmt->execute()){
                    $errorDesc = "Ocurrió un error al cargar los atributos de egreso";
                }else{
                    $atributos_rs = $stmt->fetchAll();
                }
                $stmt->closeCursor();
                $stmt = null;

                //Tipo ODS
                $stmt = $pdo->prepare('Select * from fs_ods(NULL)');
                if(!$stmt->execute()){
                    $errorDesc = "Ocurrió un error al cargar los ODS";
                }else{
                    $ods_rs = $stmt->fetchAll();
                }
                $stmt->closeCursor();
                $stmt = null;

                //ODS
                $stmt = $pdo->prepare('Select * from fs_materia_ods(NULL, :mat)');
                $stmt->bindParam(":mat", $id);
                if(!$stmt->execute()){
                    $errorDesc = "Ocurrió un error al cargar los ODS";
                }else{
                    $atributoMat_rs = $stmt->fetch();
                }
                $stmt->closeCursor();
                $stmt = null;

                
                //--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 de la materia."; break;
                        case 1: $errorDesc = "Ocurrió un error al actualizar los datos de la materia. Los prámetros pueden ser incorrectos"; break;
                        case 2: $errorDesc = "Ocurrió un error al actualizar los datos de la materia."; break;
                        case 3: $errorDesc = "No tienes permisos para realizar esa acción."; break;
                        case 4: $errorDesc = "Seleccionaste electivas para la materia, pero no agregaste ninguna."; break;
                        case 5: $errorDesc = "Ocurrió un error al actualizar los datos de la submateria."; break;
                        case 6: $errorDesc = "Ocurrió un error al actualizar los datos de las materias relacionadas."; break;
                        case 7: $errorDesc = "Ocurrió un error al insertar los atributos de egreso."; break;
                        case 8: $errorDesc = "Ocurrió un error al actualizar los atributos de egreso."; break;
                        case 9: $errorDesc = "Ocurrió un error al actualizar el ODS."; break;
                    }
                }
                if(isset($_GET["ok"]) && is_numeric($_GET["ok"])){
                    switch ($_GET["ok"]){
                        case 1: $successDesc = "La materia se actualizó correctamente."; break;
                    }
                }
            ?>
            <main class="container-fluid content marco">
                <?php include_once("../include/errorMessage.php");?>
                
                <?php if(isset($plan_rs) && isset($area_rs) && isset($tiposub_rs)){
                ?>
                <div class="row">
                    <div class="col-12">
                        <form action="./action/materia_update.php" method="post" id="formaModal" onsubmit="submitForm()">
                            <input type="hidden" value="<?php echo $id;?>" name="id" />
                            <div class="form-box">
                                <div class="form-group row">
                                    <label for="desc" class="col-4 col-form-label">Nombre *</label> 
                                    <div class="col-8 col-sm-4">
                                        <input id="desc" name="desc" type="text" class="form-control" required="required" maxlength="100" value="<?php echo $materia_rs["Materia_desc"]; ?>">
                                    </div>
                                </div>
                                <div class="form-group row">
                                    <label for="clave" class="col-4 col-form-label">Clave *</label> 
                                    <div class="col-8 col-sm-4">
                                        <input id="clave" name="clave" type="text" class="form-control" required="required" maxlength="15" value="<?php echo $materia_rs["Materia_clave"]; ?>">
                                    </div>
                                </div>

                                <div class="form-group row">
                                    <label for="area" class="col-4 col-form-label">Área *</label> 
                                    <div class="col-8 col-sm-4">
                                        <!--<select name="area" id="area" class="form-control" required="required">
                                        <?php foreach($area_rs as $area) {?>
                                            <option value="<?php echo $area["Area_id"];?>" <?php if($materia_rs["Area_id"] == $area["Area_id"]){echo "selected='selected'";}?>><?php echo $area["Area_desc"];?></option>
                                        <?php } ?>
                                        </select>-->
                                        <div class="datalist datalist-select mb-1 w-100">
                                            <div class="datalist-input">&nbsp;</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($materia_rs["Area_id"] == $area["Area_id"]){echo "class='selected'";}?>><?php echo $area["Area_desc"]?></li>
                                                <?php }?>
                                            </ul>
                                            <input type="hidden" id="area" name="area" value="">
                                        </div>
                                    </div>
                                </div>
                                <div class="form-group row">
                                    <label for="plan" class="col-4 col-form-label">Plan de estudios *</label> 
                                    <div class="col-8 col-sm-4">
                                        <!--<select name="plan" id="plan" class="form-control" required="required">
                                        <?php foreach($plan_rs as $plan) {?>
                                            <option value="<?php echo $plan["PlanEstudio_id"];?>" data-nivel="<?php echo $plan["Nivel_id"]; ?>" <?php if($materia_rs["PlanEstudio_id"] == $plan["PlanEstudio_id"]){echo "selected='selected'";}?> ><?php echo $plan["Carrera_desc"]." - ".$plan["PlanEstudio_desc"];?></option>
                                        <?php } ?>
                                        </select>-->
                                        <div class="datalist datalist-select mb-1 w-100 disabled" id="dlPlan">
                                            <div class="datalist-input">&nbsp;</div>
                                            <span class="ing-buscar icono"></span>
                                            <ul style="display:none">
                                                <?php
                                                $last_nivel = -1;
                                                foreach($plan_rs as $plan){
                                                    if($last_nivel != intval($plan["Nivel_id"])){
                                                        $last_nivel = intval($plan["Nivel_id"]);
                                                ?>
                                                <li data-id="" class="not-selectable"><?php echo $plan["Nivel_desc"]; ?></li>
                                                <?php } ?>
                                                <li  data-nivel="<?php echo $plan["Nivel_id"];?>" data-id="<?php echo $plan["PlanEstudio_id"];?>" class="pl-4 <?php if($materia_rs["PlanEstudio_id"] == $plan["PlanEstudio_id"]){echo "selected";}?>"><?php echo $plan["Carrera_desc"]." - ".$plan["PlanEstudio_desc"];?></li>
                                                <?php }?>
                                            </ul>
                                            <input type="hidden" id="plan" name="plan" value="">
                                        </div>
                                    </div>
                                </div>

                                <div class="form-group row">
                                    <label for="gpo" class="col-4 col-form-label">Grupo de posgrado</label> 
                                    <div class="col-8 col-sm-4">
                                        <input id="gpo" name="gpo" type="text" class="form-control" maxlength="10" value="<?php echo $materia_rs["Materia_grupo_posgrado"]; ?>">
                                    </div>
                                </div>

                                <div class="form-group row">
                                    <label for="sem" class="col-4 col-form-label"><span id="sem_texto">Semestre</span> *</label> 
                                    <div class="col-8 col-sm-4">
                                        <select name="sem" id="sem" class="form-control" required="required">
                                            <option value="0">-Indistinto-</option>
                                            <option value="-1">Propedéutico</option>
                                        </select>
                                    </div>
                                </div>

                                <div class="form-group row">
                                    <label for="horas_clase" class="col-4 col-form-label">Horas de clase</label> 
                                    <div class="col-8 col-sm-4">
                                        <input id="horas_clase" name="horas_clase" type="text" class="form-control" maxlength="4" value="<?php echo $materia_rs["Materia_horasClase"]; ?>">
                                    </div>
                                </div>
                                <!--<div class="form-group row">
                                    <label for="horas_lab" class="col-4 col-form-label">Horas de laboratorio</label> 
                                    <div class="col-4">
                                        <input id="horas_lab" name="horas_lab" type="text" class="form-control" required="required" maxlength="4" value="<?php echo $materia_rs["Materia_horasLab"]; ?>">
                                    </div>
                                </div>-->
                                <div class="form-group row">
                                    <label for="creditos" class="col-4 col-form-label">Créditos</label> 
                                    <div class="col-8 col-sm-4">
                                        <input id="creditos" name="creditos" type="text" class="form-control" required="required" maxlength="5" value="<?php echo $materia_rs["Materia_creditos"]; ?>">
                                    </div>
                                </div>
                            </div>
                            
                            <h3>Electivas</h3>
                            <div class="form-group row">
                                <label for="tiposub" class="col-4 col-form-label">Tipo de submaterias</label> 
                                <!-- <div class="col-8">
                                    <select name="tiposub" id="tiposub" class="form-control" required="required">
                                        <option value="0">Sin submaterias</option>
                                        <option value="2" <?php if(count($submateria_rs)>0){ echo 'selected="selected"'; } ?>>Electiva</option>
                                    </select>
                                </div>-->
                                <div class="col-8 col-sm-4">
                                    <input type="checkbox" <?php if(count($submateria_rs)>0){ echo 'checked="checked"'; } ?> data-toggle="toggle" data-onstyle="success" data-offstyle="light" data-on="Electivas" data-off="Sin electivas" id="tiposub" name="tiposub" value="2">
                                </div>
                            </div>
                            
                            <div class="row">
                                <div class="col">
                                    <div <?php if(!isset($submateria_rs) || count($submateria_rs) == 0){?> class="collapse" <?php } ?> id="submateria">
                                        <p>Selecciona las electivas para la materia:</p>
                                        <div class="form-group row">
                                            <div class="col-10">
                                                <select name="electiva[]" id="electiva" class="form-control" multiple="multiple" size="5">
                                                    <?php foreach($submateria_rs as $sub){ ?>
                                                    <option value="<?php echo $sub["Submateria_id"];?>"><?php echo $sub["Submateria_desc"];?></option>
                                                    <?php } ?>
                                                </select>
                                            </div>
                                            <div class="col-2">
                                                <p>
                                                    <button type="button" class="btn btn-outline-primary modal-open-electiva"electiva><?php echo $ICO["buscar"]?> Buscar</button>
                                                </p>
                                                <p>
                                                    <button type="button" class="btn btn-outline-danger btn-quita-electiva"><?php echo $ICO["borrar2"]?> Quitar</button>
                                                </p>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>


                            <hr/>
                            <h3>Atributos de egreso</h3>
                            <p>Elige los principales atributos de egreso con los que colabora la materia.</p>
                            <div class="form-group row">
                                <div class="col-10">
                                    <select name="atributos[]" id="atributos" class="form-control" multiple="multiple" size="3">
                                    <?php foreach($atributos_rs as $atr){ ?>
                                    <option data-id="<?php echo $atr["AtributoEgreso_id"];?>" value="<?php echo $atr["AtributoEgreso_id"]."|".$atr["AtributoNivel_id"];?>">Atributo <?php echo $atr["AtributoEgreso_id"].": ".(strlen($atr["AtributoEgreso_desc"])>60? substr($atr["AtributoEgreso_desc"], 0, 60)."...": $atr["AtributoEgreso_desc"] );?></option>
                                    <?php } ?>
                                    </select>
                                </div>
                                <div class="col-2">
                                    <p>
                                        <button type="button" class="btn btn-outline-primary modal-open-atributos"><?php echo $ICO["buscar"]?> Buscar</button>
                                    </p>
                                    <p>
                                        <button type="button" class="btn btn-outline-danger btn-quita-atributos"><?php echo $ICO["menos"]?> Quitar</button>
                                    </p>
                                </div>
                            </div>

                            <?php if(isset($ods_rs)){ ?>
                            <hr/>
                            <h3>ODS</h3>
                            <p>Elige el principal Objetivo de Desarrollo Sostenible que busca solucionar la materia.</p>
                            <div class="form-group row">
                                <div class="col-10">
                                    <select name="ods" id="ods" class="form-control">
                                        <option value="">- Sin ODS -</option>
                                        <?php foreach($ods_rs as $ods){?>
                                            <option value="<?php echo $ods["ODs_id"];?>" <?php if($atributoMat_rs["ODs_id"] == $ods["ODs_id"]){ echo "selected='selected'";}?>><?php echo $ods["ODs_num"].") ".$ods["ODs_desc"];?></option>
                                        <?php } ?>
                                    </select>
                                </div>
                            </div>
                            <?php } ?>

                            
                            <hr/>
                            <h3>Materias relacionadas</h3>
                            <p>Agrega materias de otros planes que se relacionen con ésta materia.</p>
                            <p>Las materias relacionadas pueden compartir profesores y salones, además se pueden vincular con los horarios de otros grupos.</p>
                            <div class="form-group row">
                                <div class="col-10">
                                    <select name="relacionada[]" id="relacionada" class="form-control" multiple="multiple" size="5">
                                        <?php foreach($relacionada_rs as $rel){ ?>
                                        <option value="<?php echo $rel["Materia_id"];?>"><?php echo $rel["Materia_desc"]." [ ".$rel["Carrera_desc"]." - ".$rel["PlanEstudio_desc"]." ]";?></option>
                                        <?php } ?>
                                    </select>
                                </div>
                                <div class="col-2">
                                    <p>
                                        <button type="button" class="btn btn-outline-primary modal-open"><?php echo $ICO["buscar"]?> Buscar</button>
                                    </p>
                                    <p>
                                        <button type="button" class="btn btn-outline-danger btn-quita-materia"><?php echo $ICO["borrar2"]?> Quitar</button>
                                    </p>
                                </div>
                            </div>
                            
                            <div class="form-group row">
                                <div class="offset-4 col-8">
                                    <button type="submit" class="btn btn-outline-primary" id="submitBtn" data-tipo="1"><?php echo $ICO["aceptar"];?> Guardar</button>
                                    <a href="materias.php" class="btn btn-outline-danger"><?php echo $ICO["cancelar"];?> Cancelar</a>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>
                <?php } ?>
            </main>
            <!--- FOOTER--->
            <?php require_once("../include/footer.php"); ?>
            
            <?php if($objSesion->puedeEditar()){ ?>
            <!-- Modal -->
            <div class="modal fade" id="modal" tabindex="-1" role="dialog" aria-labelledby="modal" aria-hidden="true" data-backdrop="static" data-keyboard="false">
                <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">Busca Materia
                            <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">
                            <form id="forma_buscar" onsubmit="return false">
                                <div class="form-group row">
                                    <label for="filter_desc" class="col-4 col-form-label text-right">Nombre</label> 
                                    <div class="col-8">
                                        <input id="filter_desc" name="desc" type="text" class="form-control">
                                    </div>
                                </div>
                                <div class="form-group row">
                                    <label for="filter_area" class="col-4 col-form-label text-right">Área</label> 
                                    <div class="col-8">
                                        <!--<select id="filter_area" name="area" class="form-control">
                                            <option value="">Mostrar todas</option>
                                            <?php foreach($area_rs as $area) {?>
                                            <option value="<?php echo $area["Area_id"];?>" ><?php echo $area["Area_desc"]?></option>
                                            <?php } ?>
                                        </select>-->
                                        <div class="datalist datalist-select mb-1 w-100">
                                            <div class="datalist-input">Mostrar todas</div>
                                            <span class="ing-buscar icono"></span>
                                            <ul style="display:none">
                                                <li data-id="">Mostrar todas</li>
                                                <?php foreach($area_rs as $area) { ?>
                                                <li data-id="<?php echo $area["Area_id"];?>" ><?php echo $area["Area_desc"]?></li>
                                                <?php }?>
                                            </ul>
                                            <input type="hidden" id="filter_area" name="area" value="">
                                        </div>
                                    </div>
                                </div>
                                <div class="form-group row">
                                    <label for="filter_plan" class="col-4 col-form-label text-right">Plan de estudios</label> 
                                    <div class="col-8">
                                        <!--<select id="filter_plan" name="plan" class="form-control">
                                            <option value="">Mostrar todos</option>
                                            <?php foreach($plan_rs as $plan) {?>
                                            <option value="<?php echo $plan["PlanEstudio_id"];?>" ><?php echo $plan["Carrera_desc"]." - ".$plan["PlanEstudio_desc"];?></option>
                                            <?php } ?>
                                        </select>-->
                                        <div class="datalist datalist-select mb-1 w-100">
                                                <div class="datalist-input">Mostrar todos</div>
                                                <span class="ing-buscar icono"></span>
                                                <ul style="display:none">
                                                    <li data-id="">Mostrar todos</li>
                                                    <?php
                                                    $last_nivel = -1;
                                                    foreach($plan_rs as $plan){
                                                        if($last_nivel != intval($plan["Nivel_id"])){
                                                            $last_nivel = intval($plan["Nivel_id"]);
                                                    ?>
                                                    <li data-id="" class="not-selectable"><?php echo $plan["Nivel_desc"]; ?></li>
                                                    <?php } ?>
                                                    <li data-id="<?php echo $plan["PlanEstudio_id"];?>" class="pl-4"><?php echo $plan["Carrera_desc"]." - ".$plan["PlanEstudio_desc"];?></li>
                                                    <?php }?>
                                                </ul>
                                                <input type="hidden" id="filter_plan" name="plan" value="">
                                            </div>
                                    </div>
                                </div>
                                <div class="form-group row">
                                    <div class="offset-4">
                                        <button type="submit" class="btn btn-outline-primary" id="btn-busca"><?php echo $ICO["buscar"]; ?> Buscar</button>
                                        <button type="button" class="btn btn-outline-danger" data-dismiss="modal" aria-label="Close"><?php echo $ICO["cancelar"]; ?> Cerrar</button>
                                    </div>
                                </div>
                             </form>
                            <p>Se mostrarán los primeros <strong><?php echo MAX_ROWS;?></strong> resultados.</p>
                            <table class="table table-sm">
                                <thead class="thead-dark">
                                    <tr>
                                        <th>Materia</th>
                                        <th>Área</th>
                                        <th>Plan</th>
                                        <th>Semestre</th>
                                        <th></th>
                                    </tr>
                                </thead>
                                <tbody id="table-result">
                                    <tr class="materia-row">
                                        <td class="mat-desc"></td>
                                        <td class="mat-area"></td>
                                        <td class="mat-plan"></td>
                                        <td class="mat-sem"></td>
                                        <td class="mat-agrega"><button type="button" class="btn btn-outline-primary btn-sm d-none btn-agrega-materia"><?php echo $ICO["mas"]; ?></button></td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
            
            
            <div class="modal fade" id="modal-electiva" tabindex="-1" role="dialog" aria-labelledby="modal" aria-hidden="true" data-backdrop="static" data-keyboard="false">
                <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">Busca Electiva
                            <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">
                            <form id="forma_buscar-electiva" onsubmit="return false">
                                <div class="form-group row">
                                    <label for="filter_desc-electiva" class="col-4 col-form-label text-right">Nombre</label> 
                                    <div class="col-8">
                                        <input id="filter_desc-electiva" name="desc" type="text" class="form-control">
                                    </div>
                                </div>
                                
                                <div class="form-group row">
                                    <div class="offset-4">
                                        <button type="submit" class="btn btn-outline-primary" id="btn-busca-electiva"><?php echo $ICO["buscar"]; ?> Buscar</button>
                                        <button type="button" class="btn btn-outline-danger" data-dismiss="modal" aria-label="Close"><?php echo $ICO["cancelar"]; ?> Cerrar</button>
                                    </div>
                                </div>
                             </form>
                            <p>Se mostrarán los primeros <strong><?php echo MAX_ROWS;?></strong> resultados.</p>
                            <table class="table table-sm">
                                <thead class="thead-dark">
                                    <tr>
                                        <th>Electiva</th>
                                        <th></th>
                                    </tr>
                                </thead>
                                <tbody id="table-result-electiva">
                                    <tr class="materia-row">
                                        <td class="mat-desc"></td>
                                        <td class="mat-agrega"><button type="button" class="btn btn-outline-primary btn-sm d-none btn-agrega-electiva"><?php echo $ICO["mas"]; ?></button></td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
            <div class="modal fade" id="modal-atributos" tabindex="-1" role="dialog" aria-labelledby="modal" aria-hidden="true" data-backdrop="static" data-keyboard="false">
                <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">Atributos de egreso
                            <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">
                            <div id="sinatributos_block">
                                <h4 class="text-danger text-center"><span class="ing-importante"></span> El plan de estudios no tiene atributos de egreso registrados</h4>
                            </div>
                            <div id="conatributos_block">
                                <table class="table table-sm table-striped table-white">
                                    <thead class="thead-dark">
                                        <tr>
                                            <th>Atributo</th>
                                            <th style="width:165px">Nivel de logro</th>
                                        </tr>
                                    </thead>
                                    <tbody id="table-result-atributos">
                                        <tr class="atributo-row">
                                            <td class="atributo-desc"></td>
                                            <td class="atributo-agrega text-center align-middle">
                                                <div class="input-group mb-3">
                                                <?php
                                                //Obtiene niveles de  atributos de egreso
                                                    $stmt = $pdo->prepare('Select * from fs_atributoegreso_nivel(NULL)');
                                                    if(!$stmt->execute()){
                                                        //print_r($stmt->errorInfo());
                                                        $errorDesc = "Ocurrió un error al cargar los atribuos de egreso";
                                                    }else{
                                                        $nivel_rs = $stmt->fetchAll();
                                                    }
                                                    $stmt->closeCursor();
                                                    $stmt = null;
                                                ?>
                                                    <select class="custom-select contribuye">
                                                        <?php foreach($nivel_rs as $nivel){?>
                                                        <option value="<?php echo $nivel["AtributoNivel_id"];?>"><?php echo $nivel["AtributoNivel_desc"];?></option>
                                                        <?php } ?>
                                                    </select>
                                                    <div class="input-group-append">
                                                        <button type="button" class="btn btn-outline-primary btn-sm d-none btn-agrega-atributo"><?php echo $ICO["mas"]; ?></button>
                                                    </div>
                                                </div>
                                            </td>
                                        </tr>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <?php } ?>
        </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/fechas.js"></script>
        <script src="../js/sidebarmenu.js"></script>
        <script src="../js/toggle.js"></script>
        <script src="../js/datalist.js"></script>
        <script src="./js/materias.js"></script>
        <script>
            function showGrupo(){
                if($("#dlPlan ul li.selected").data("nivel") == 1){//licenciatura
                    $("#gpo").parents(".form-group:first").hide();
                    $("#gpo").val("");
                    $("#sem_texto").text("Semestres");
                }else{
                    $("#gpo").parents(".form-group:first").show();
                    $("#sem_texto").text("Cuatrimestres");
                }
            }
            
            $(document).ready(function(){
                
                loadSemestre(<?php echo $materia_rs["Materia_semestre"]; ?>);
                showGrupo();
                
                /*if($('#tiposub').val() == "0"){
                    $('#submateria').collapse('hide');
                }else{
                    $('#submateria').collapse('show');
                }*/
                if($('#tiposub').prop("checked")){
                    $('#submateria').collapse('show');
                }else{
                    $('#submateria').collapse('hide');
                }
                
                
                $('#tiposub').change(function(){
                    /*if($(this).val() == "0"){
                        $('#submateria').collapse('hide');
                    }else{
                        $('#submateria').collapse('show');
                    }*/
                    if($(this).prop("checked")){
                        $('#submateria').collapse('show');
                    }else{
                        $('#submateria').collapse('hide');
                    }
                });
                
                $(".modal-open").click(function(){
                    $("#filter_desc").val("");
                    $('#filter_area').get(0).selectedIndex = 0;
                    $('#filter_plan').get(0).selectedIndex = 0;
                    
                    $("#table-result").find(".mat-desc").html("");
                    $("#table-result").find(".mat-area").html("");
                    $("#table-result").find(".mat-plan").html("");
                    $("#table-result").find(".mat-sem").html("");
                    $("#table-result").find(".mat-agrega button").addClass("d-none");
                    var rows = $("#table-result > tr").length;//limpia tabla actual

                    //borrar renglones extra (rows - result.length) pero dejar al menos 1
                    while(rows > 1){
                        $(".materia-row:last-child").remove();
                        rows--;
                    }
                    
                    $('#modal').modal("show");
                });
                
                $("#btn-busca").click(function(){
                    var data = $("#forma_buscar").serialize();
                    $("#table-result tr").show();
                    $.ajax({
                        url:  './action/materiarelacionada_find.php',
                        type: 'POST', 
                        dataType: 'json',
                        data: data,
                        success: function(result) {
                            if(result["error"]!= "" &&  result["error"] !== undefined){
                                $('#modal').modal('hide');
                                $("#errorBox").collapse('show');
                                $("#errorBox_text").html(result["error"]);
                            }else{
                                //Crea tabla con resultado
                                //$("#table-result").find("td").html("");//limpia tabla actual
                                $("#table-result").find(".mat-desc").html("");
                                $("#table-result").find(".mat-area").html("");
                                $("#table-result").find(".mat-plan").html("");
                                $("#table-result").find(".mat-sem").html("");
                                $("#table-result").find(".mat-agrega button").addClass("d-none");
                                var rows = $("#table-result > tr").length;//limpia tabla actual
                                
                                if(rows > result["materiaArr"].length){//sobran
                                    //borrar renglones extra (rows - result.length) pero dejar al menos 1
                                    while(rows > result["materiaArr"].length && rows > 1){
                                            $("#table-result .materia-row:last-child").remove();
                                            rows--;
                                    }
                                }else{//faltan, clonar
                                    for(var i=rows; i<result["materiaArr"].length; i++){
                                        $("#table-result .materia-row:first-child").clone(true).appendTo("#table-result");
                                    }
                                }
                                if(result["materiaArr"].length != 0){//hay elementos?
                                    $("#table-result").children().each(function(index) {
                                        if(index < result["materiaArr"].length){//llenar info
                                            $(this).find(".mat-desc").html(result["materiaArr"][index]["Materia_desc"]);
                                            $(this).find(".mat-area").html(result["materiaArr"][index]["Area_desc"]);
                                            $(this).find(".mat-plan").html(result["materiaArr"][index]["PlanEstudio_desc"]);
                                            $(this).find(".mat-sem").html(result["materiaArr"][index]["Materia_semestre"]);
                                            $(this).find(".mat-agrega button").data("id", result["materiaArr"][index]["Materia_id"]);
                                            $(this).find(".mat-agrega button").data("text", result["materiaArr"][index]["Materia_desc"]+" [ "+result["materiaArr"][index]["PlanEstudio_desc"]+" ]");
                                            $(this).find(".mat-agrega button").removeClass("d-none");
                                        }
                                    });
                                }/*else{
                                    $("#table-result").find(".mat-desc").html("No hay materias que coincidan con la búsqueda");
                                    $(this).find(".hora").html("");
                                }*/
                            }
                        },
                        error: function(jqXHR, textStatus, errorThrown ){
                            $('#modal').modal('hide');
                            $("#errorBox").collapse('show');
                            $("#errorBox_text").html(errorThrown);
                        }
                    });//ajax
                });
                
                /*$("#plan").change(function(){
                    loadSemestre();
                    showGrupo();
                });*/
                $('#dlPlan ul li').click(function(){
                    if(parseInt($(this).data("nivel")) == 1){
                        $("#sem_texto").text("Semestres");
                    }else{
                        $("#sem_texto").text("Cuatrimestres");
                    }
                    loadSemestre();
                    showGrupo();
                });
                
                $(".btn-agrega-materia").click(function(){
                    var id = $(this).data("id");
                    var text = $(this).data("text");
                    var rows = $("#table-result > tr").length;//limpia tabla actual
                    
                    if($('#relacionada option[value="' + id + '"]').length == 0 && id != <?php echo $id; ?>){
                        $("#relacionada").append($("<option></option>").attr("value",id).text(text));
                    }
                    if(rows > 1)
                        $(this).parents("tr").remove();
                    else{
                        $(this).parents("tr").hide();
                    }
                });
                
                $(".btn-quita-materia").click(function(){
                    $("#relacionada option:selected").remove();
                });
                
                //----
                
                $(".modal-open-electiva").click(function(){
                    $("#filter_desc").val("");
                    
                    $("#table-result-electiva").find(".mat-desc").html("");
                    $("#table-result-electiva").find(".mat-agrega button").addClass("d-none");
                    var rows = $("#table-result-electiva > tr").length;//limpia tabla actual

                    //borrar renglones extra (rows - result.length) pero dejar al menos 1
                    while(rows > 1){
                        $(".materia-row:last-child").remove();
                        rows--;
                    }
                    
                    $('#modal-electiva').modal("show");
                });
                
                $("#btn-busca-electiva").click(function(){
                    var data = $("#forma_buscar-electiva").serialize();
                    $("#table-result-electiva tr").show();
                    $.ajax({
                        url:  './action/electiva_find.php',
                        type: 'POST', 
                        dataType: 'json',
                        data: data,
                        success: function(result) {
                            if(result["error"]!= "" &&  result["error"] !== undefined){
                                $('#modal-electiva').modal('hide');
                                $("#errorBox").collapse('show');
                                $("#errorBox_text").html(result["error"]);
                            }else{
                                //Crea tabla con resultado
                                //$("#table-result").find("td").html("");//limpia tabla actual
                                $("#table-result-electiva").find(".mat-desc").html("");
                                $("#table-result-electiva").find(".mat-agrega button").addClass("d-none");
                                var rows = $("#table-result-electiva > tr").length;//limpia tabla actual
                                
                                if(rows > result["electivaArr"].length){//sobran
                                    //borrar renglones extra (rows - result.length) pero dejar al menos 1
                                    while(rows > result["electivaArr"].length && rows > 1){
                                            $("#table-result-electiva .materia-row:last-child").remove();
                                            rows--;
                                    }
                                }else{//faltan, clonar
                                    for(var i=rows; i<result["electivaArr"].length; i++){
                                        $("#table-result-electiva .materia-row:first-child").clone(true).appendTo("#table-result-electiva");
                                    }
                                }
                                if(result["electivaArr"].length != 0){//hay elementos?
                                    $("#table-result-electiva").children().each(function(index) {
                                        if(index < result["electivaArr"].length){//llenar info
                                            $(this).find(".mat-desc").html(result["electivaArr"][index]["Submateria_desc"]);
                                            $(this).find(".mat-agrega button").data("id", result["electivaArr"][index]["Submateria_id"]);
                                            $(this).find(".mat-agrega button").data("text", result["electivaArr"][index]["Submateria_desc"]);
                                            $(this).find(".mat-agrega button").removeClass("d-none");
                                        }
                                    });
                                }/*else{
                                    $("#table-result").find(".mat-desc").html("No hay materias que coincidan con la búsqueda");
                                    $(this).find(".hora").html("");
                                }*/
                            }
                        },
                        error: function(jqXHR, textStatus, errorThrown ){
                            $('#modal-electiva').modal('hide');
                            $("#errorBox").collapse('show');
                            $("#errorBox_text").html(errorThrown);
                        }
                    });//ajax
                });

                $(".btn-agrega-electiva").click(function(){
                    var id = $(this).data("id");
                    var text = $(this).data("text");
                    var rows = $("#table-result-electiva > tr").length;//limpia tabla actual
                    
                    if($('#electiva option[value="' + id + '"]').length == 0){
                        $("#electiva").append($("<option></option>").attr("value",id).text(text));
                    }
                     if(rows > 1)
                        $(this).parents("tr").remove();
                    else{
                        $(this).parents("tr").hide();
                        $("#filter_desc-electiva").val("");
                    }
                });
                
                $(".btn-quita-electiva").click(function(){
                    $("#electiva option:selected").remove();
                });

            // ------
            $(".modal-open-atributos").click(function(){
                    var plan = $("#plan").val();
                    $.ajax({
                        url:  './action/atributo_select.php',
                        type: 'POST', 
                        dataType: 'json',
                        data: {"plan":plan},
                        success: function(result) {
                            if(result["error"]!= "" &&  result["error"] !== undefined){
                                $("#errorBox").collapse('show');
                                $("#errorBox_text").html(result["error"]);
                            }else{
                                //Crea tabla con resultado
                                //$("#table-result").find("td").html("");//limpia tabla actual
                                
                                if(result["atributoArr"].length != 0){//hay elementos?
                                    $("#sinatributos_block").hide();
                                    $("#conatributos_block").show();

                                    $("#table-result-atributos").find(".atributo-desc").html("");
                                    $("#table-result-atributos").find(".atributo-agrega button").addClass("d-none");
                                    var rows = $("#table-result-atributos > tr").length;//limpia tabla actual
                                
                                    if(rows > result["atributoArr"].length){//sobran
                                        //borrar renglones extra (rows - result.length) pero dejar al menos 1
                                        while(rows > result["atributoArr"].length && rows > 1){
                                                $("#table-result-atributos .atributo-row:last-child").remove();
                                                rows--;
                                        }
                                    }else{//faltan, clonar
                                        for(var i=rows; i<result["atributoArr"].length; i++){
                                            $("#table-result-atributos .atributo-row:first-child").clone(true).appendTo("#table-result-atributos");
                                        }
                                    }

                                    $("#table-result-atributos").children().each(function(index) {
                                        if(index < result["atributoArr"].length){//llenar info
                                            $(this).find(".atributo-desc").html(result["atributoArr"][index]["id"]+" "+result["atributoArr"][index]["desc"]);
                                            $(this).find(".btn-agrega-atributo").data("id", result["atributoArr"][index]["id"]);
                                            $(this).find(".btn-agrega-atributo").data("text", result["atributoArr"][index]["desc"]);
                                            $(this).find(".btn-agrega-atributo").removeClass("d-none");
                                        }
                                    });
                                }else{
                                    $("#sinatributos_block").show();
                                    $("#conatributos_block").hide();
                                }
                                $('#modal-atributos').modal("show");
                            }
                        },
                        error: function(jqXHR, textStatus, errorThrown ){
                            $("#errorBox").collapse('show');
                            $("#errorBox_text").html(errorThrown);
                        }
                    });//ajax                    
                });
                
                
                $(".btn-agrega-atributo").click(function(){
                    var id = $(this).data("id");
                    var contribuye = $(this).parents(".input-group").find(".contribuye").val();
                    var text = $(this).data("text");
                    var rows = $("#table-result-atributos > tr").length;//limpia tabla actual
                    var size = 60;
                    
                    if(text.length > size){
                        text = text.substring(0,size)+"...";
                    }
                    text = "Atributo "+id+": "+text;
                    var full_id = id+"|"+contribuye;

                    if(!existeAtributo(id)){
                        $("#atributos").append($("<option></option>").attr("value",full_id).text(text));
                    }
                     if(rows > 1)
                        $(this).parents("tr").remove();
                    else{
                        $(this).parents("tr").hide();
                    }
                });
                
                $(".btn-quita-atributos").click(function(){
                    $("#atributos option:selected").remove();
                });
            });
            function existeAtributo(id){
                var existe =false;
                $("#atributos option").each(function(index) {
                    if($(this).data("id") == id ){//llenar info
                        existe = true;
                    }
                });
                return existe;
            }
        </script>
    </body>
</html>