PAAD
/
paad


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431
							<?php
require_once 'class/c_login.php';
require_once 'include/bd_pdo.php';

if(!isset($_SESSION['user'])){
    header('Location: index.php');
    exit;
}
else
    $user = unserialize($_SESSION['user']);
$user->access('Avisos');
if(!$user->admin && $user->acceso == 'n'){
    header('Location: main.php?error=1');
}else{
    $user->print_to_log('Avisos Editar');
}
$fac = $user->facultad['facultad_id'];
if($user->admin){
    $fac = null;
}
$fs_aviso = query('SELECT * FROM fs_aviso(:aviso_id, null, :facultad_id, null, 0, null)', [':aviso_id' => $_GET['id'], ':facultad_id' => $fac], true);
$fs_carreras = query('SELECT * FROM fs_carreras(:fac, null, null)', [':fac' => $fs_aviso['facultad_id']], false);
$fs_usr = query('SELECT * FROM fs_profesor_aviso(:aviso_id)', [':aviso_id' => $_GET['id']], false);
$today = date('Y-m-d');
$edit = true;
if($today >= $fs_aviso['aviso_fecha_inicial']){
    $edit = false;
}
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Avisos Crear</title>
    <link rel="stylesheet" href="css/jquery-ui.css">
    <link rel="stylesheet" href="css/calendar.css">
    <link rel="stylesheet" href="css/richtext.css" type="text/css">
    <link rel="stylesheet" href="css/fa_all.css" type="text/css">
    <?php
    include 'import/html_css_files.php';
    ?>
</head>

<body>
    <?php
    include "import/html_header.php";
    html_header(
        "EDITAR AVISO",
        "Gestión de Checador "
    );
    $user->access('Avisos');
    ?>
    <main class="content marco">
        <div class="row">
            <div class="col-12">
                <form action="./action/action_avisos_update.php" method="post" id="formaModal" onsubmit="return validaCampos()">
                    <input type="hidden" name="aviso_id" id="aviso_id" value="<?= $fs_aviso['aviso_id'] ?>">
                    <div class="form-box">
                        <div class="form-group row">
                            <label for="fecha_inicial" class="col-4 col-form-label">Fecha inicial</label>
                            <div class="col-8 col-sm-4">
                                <?php if($edit == true){ ?>
                                    <input id="fecha_inicial" name="fecha_inicial" type="text" class="form-control date-picker" placeholder="dd/mm/aaaa" maxlength="10" required="required" readonly="readonly" value="<?php $day = explode("-", $fs_aviso['aviso_fecha_inicial']); $dia_inicial = $day['2'].'/'.$day['1'].'/'.$day[0]; echo $dia_inicial;?>">
                                    <div class="invalid-feedback">No es una fecha valida</div>
                                <?php }else{ ?>
                                    <div>
                                        <?php $day = explode("-", $fs_aviso['aviso_fecha_inicial']); $dia_inicial = $day['2'].'/'.$day['1'].'/'.$day[0]; echo $dia_inicial;?>
                                    </div>
                                <?php } ?>
                            </div>
                        </div>
                        <div class="form-group row">
                            <label for="fecha_final" class="col-4 col-form-label">Fecha Final *</label>
                            <div class="col-8 col-sm-4">
                                <input id="fecha_final" name="fecha_final" type="text" class="form-control date-picker" placeholder="dd/mm/aaaa" maxlength="10" required="required" readonly="readonly" value="<?php $day = explode("-", $fs_aviso['aviso_fecha_final']); $dia_final = $day['2'].'/'.$day['1'].'/'.$day[0]; echo $dia_final;?>">
                                <div class="invalid-feedback">No es una fecha valida</div>
                            </div>
                        </div>
                        <div class="form-group row">
                            <label for="texto" class="col-4 col-form-label">Aviso *</label>
                            <div class="col-8">
                            <?php if($edit == true){ ?>
                                <textarea name="texto" id="texto" class="richtext" rows="10" readonly="readonly"><?= $fs_aviso['aviso_texto'] ?></textarea>
                            <?php }else{ ?>
                                <p><?= $fs_aviso['aviso_texto'] ?></p>
                            <?php } ?>
                            </div>
                        </div>
                        <?php if($edit){ ?>
                            <div class="form-group row tipo_aviso">
                                <label class="col-4 col-form-label">Enviar aviso:</label>
                                <div class="col-4 pt-2">
                                    <div class="custom-control custom-switch">
                                        <input type="checkbox" class="custom-control-input tipo-switch" name="bloque_tipo" id="bloque_tipo" value="1" data-box="profesorBox" data-select="tipo_box">
                                        <label class="custom-control-label" for="bloque_tipo">Por carrera</label>
                                    </div>
                                </div>
                                <div class="col-4 pt-2">
                                    <div class="custom-control custom-switch">
                                        <input type="checkbox" class="custom-control-input tipo-switch"  name="bloque_usr" id="bloque_usr" value="1" data-box="administrativoBox" data-select="usuario_box">
                                        <label class="custom-control-label" for="bloque_usr">Por nombre</label>
                                    </div>
                                </div>
                            </div>
                            <div class="invalid-feedback offset-4">No hay profesores para mandar el aviso</div>
                            <div class="collapse" id="profesorBox">
                                <h3>Carreras</h3>
                                <p>Utiliza el botón para asignar las carreras que recibirán el aviso.</p>
                                <div class="form-group row">
                                    <div class="col-10">
                                        <select name="tipo[]" id="tipo_box" class="form-control" multiple="multiple" size="5">
                                        </select>
                                    </div>
                                    <div class="col-2">
                                        <p><button type="button" class="btn btn-outline-primary"  data-toggle="modal" data-target="#modal_carrera"><span class="ing-mas ing-fw"></span> Asignar</button></p>
                                        <p><button type="button" class="btn btn-outline-danger btn-quita-tipo"><span class="ing-menos ing-fw"></span> Quitar</button></p>
                                    </div>
                                </div>
                            </div>
                            
                            <div class="collapse" id="administrativoBox">
                                <h3>Nombre de profesores</h3>
                                <p>Utiliza el botón para asignar los profesores que recibirán el aviso.</p>
                                <div class="form-group row">
                                    <div class="col-10">
                                    <select name="usuario[]" id="usuario_box" class="form-control" multiple="multiple" size="5">
                                    <?php
                                    foreach($fs_usr as $usuario){
                                        echo "<option value='".$usuario['profesor_id']."'>".$usuario['profesor_nombre']."</option>";
                                    }
                                    ?>    
                                    </select>
                                        </div>
                                        <div class="col-2">
                                            <p><button type="button" class="btn btn-outline-primary"  data-toggle="modal" data-target="#modal_usr"><span class="ing-mas ing-fw"></span> Asignar</button></p>
                                            <p><button type="button" class="btn btn-outline-danger btn-quita-usr"><span class="ing-menos ing-fw"></span> Quitar</button></p>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        <?php }else{
                            $num_prof = round(count($fs_usr)/2);
                            ?>
                            <h3>Profesores que recibirán el aviso</h3>
                            <div class="row" style="max-height:400px; overflow-y:auto; overflow-x:hidden;">
                                <div class="col-5">
                                    <div>
                                        <ul>
                                            <?php for($i = 0; $i < $num_prof; $i++){
                                                echo "<li>".$fs_usr[$i]['profesor_nombre']."</li>";
                                            } ?>
                                        </ul>
                                    </div>
                                </div>
                                <div class="col-5">
                                    <div>
                                        <ul>
                                            <?php for($i = $i; $i < count($fs_usr); $i++){
                                                echo "<li>".$fs_usr[$i]['profesor_nombre']."</li>";
                                            } ?>
                                        </ul>
                                    </div>
                                </div>
                            </div>
                        <?php } ?>
                        <div class="form-group row mt-2">
                            <div class="col-12 text-center">
                                <button type="submit" class="btn btn-outline-primary" id="submitBtn" data-tipo="1"><span class="ing-aceptar"></span> Guardar</button>
                                <a href="avisos.php" class="btn btn-outline-danger"><span class="ing-cancelar"></span> Cancelar</a>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </main>
        <!-- Footer -->
    <?php
    include "import/html_footer.php";
    ?>

    <!-- Modal -->
    <div class="modal fade" id="modal_carrera" tabindex="-1" role="dialog" aria-labelledby="modal" aria-hidden="true" data-backdrop="static" data-keyboard="false">
        <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">Carreras
                        <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">
                    <table class="table table-sm table-striped table-white">
                        <thead class="thead-dark">
                            <tr>
                                <th>Carrera</th>
                                <th>Asignar</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php $count = 1;
                            foreach($fs_carreras as $carrera){ ?>
                            <tr class="tipo-row" id="arow_<?= $carrera['carrera_id'] ?>">
                                <td><?= $carrera['carrera_nombre'] ?></td>
                                <td class="text-center"><button type="button" class="btn btn-outline-primary btn-sm btn-agrega-tipo" data-id="<?= $carrera['carrera_id'] ?>" data-text="<?= $carrera['carrera_nombre'] ?>"><span class="ing-mas"></span></button></td>
                            </tr>    
                            <?php $count++;
                            } ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="modal_usr" 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 Usuarios
                        <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-usr" onsubmit="return false">
                    <input type="hidden" id="facultad" name="facultad" value="<?= $fac ?>">
                        <div class="form-box">
                            <div class="form-group row">
                                <label for="filter_desc" class="col-4 col-form-label">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_clave" class="col-4 col-form-label">Clave ULSA</label>
                                <div class="col-8">
                                    <input id="filter_clave" name="clave" type="text" class="form-control">
                                </div>
                            </div>
                        </div>
                        <div class="for-group row">
                            <div class="col-12 text-center">
                                <button type="submit" class="btn btn-outline-primary" id="btn-busca-usr"><span class="ing-buscar"></span> Buscar</button>
                                <button type="button" class="btn btn-outline-danger" data-dismiss="modal" aria-label="Close"><span class="ing-cancelar"></span> Cerrar</button>
                            </div>
                        </div>
                    </form>
                    <div style="max-height:400px; overflow-y:auto; overflow-x:hidden;">
                        <table class="table table-sm table-striped table-white mt-3">
                            <thead class="thead-dark">
                                <tr>
                                    <th>Usuario</th>
                                    <th style="width: 20%;">Asignar</th>
                                </tr>
                            </thead>
                            <tbody id="table-result-usr">
                                <tr class="usr-row">
                                    <td class="usr-nombre"></td>
                                    <td class="usr-agrega text-center"><button type="button" class="btn btn-outline-primary btn-sm invisible btn-agrega-usr"><span class="ing-mas"></span></button></td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <script src="js/jquery.min.js"></script>
    <script src="js/jquery-ui.js"></script>
    <script src="js/bootstrap/bootstrap.min.js"></script>
    <script src="js/datalist.js"></script>
    <script src="js/datepicker-es.js"></script>
    <script src="./js/richtext.js"></script>
    <?php
        require_once 'js/messages.php';
    ?>
    <script>
        var today = new Date();
        $(".date-picker").datepicker($.datepicker.regional["es"]);
        $(".date-picker").datepicker({
            dateFormat: "dd/mm/yyyy",
            changeMonth: true,
        });
        $(document).ready(function(){
            $('.richtext').richText();
            $("#fecha_final").datepicker("option", "minDate", today);
            $("#fecha_inicial").datepicker("option", "minDate", today);
            <?php
            if(count($fs_usr) > 0){ ?>
                $('#bloque_usr').prop("checked", true);
                $('#administrativoBox').collapse('show');
            <? }
            if($edit == false){ ?>
                $('.richText-editor').removeAttr("contentEditable");
            <?php }
            ?>
            
        });

        $(document).on( "change", ".tipo-switch", function(event){
            if($(this).data("box") !== undefined){
                if($(this).prop('checked')){
                    $('#'+$(this).data("box")).collapse('show');
                }else{
                    $('#'+$(this).data("box")).collapse('hide');
                }
            }
            $('#bloque_tipo').removeClass("is-invalid");
            $('#bloque_usr').removeClass("is-invalid");
        });

        $(document).on( "click", ".btn-agrega-tipo", function(event){
            var id = $(this).data("id");
            var text = $(this).data("text");
            if($('#tipo_box option[value="' + id + '"]').length == 0){
                $("#tipo_box").append($("<option></option>").attr("value",id).text(text));
            }
            $(this).parents("tr").addClass("d-none");
        });

        $(document).on( "click", ".btn-quita-tipo", function(event){
            var id = $("#tipo_box option:selected").val();
            $("#arow_"+id).removeClass("d-none");
            $("#tipo_box option:selected").remove();
        });

        $(document).on( "click", ".modal-open", function(event){
            $(".area-row").removeClass("d-none");
            $('#area > option').each(function() {
                $("#row_"+$(this).val()).addClass("d-none");
            });
            $('#modal').modal("show");
        });

        $(document).on('click', '#btn-busca-usr', function(event){
            var nombre = $('#filter_desc').val();
            var clave = $('#filter_clave').val();
            var fac = $('#facultad').val();
            $('#table-result-usr').show();
            $.ajax({
                url: 'action/usuario_find.php',
                type: 'POST',
                dataType: 'json',
                data: {nombre: nombre, clave: clave, facultad: fac},
                success: function(result){
                    console.log(result.length);
                    $("#table-result-usr").find(".usr-nombre").html("");
                    $("#table-result-usr").find(".usr-agrega button").addClass("invisible");
                    var rows = $("#table-result-usr > tr").length;//limpia tabla actual
                    if(rows > result.length){
                        while(rows > result.length && rows > 1){
                            $("#table-result-usr .usr-row:last-child").remove();
                            rows--;
                        }
                    }else{
                        for(var i=rows; i<result.length; i++){
                            $("#table-result-usr .usr-row:first-child").clone(true).appendTo("#table-result-usr");
                        }
                    }
                    if(result.length != 0){
                        $('#table-result-usr').children().each(function(index){
                            if(index < result.length){
                                $(this).find('.usr-nombre').html(result[index]['profesor_nombre']);
                                $(this).find('.usr-agrega button').data("id", result[index]['profesor_id']);
                                $(this).find('.usr-agrega button').data("text", result[index]['profesor_nombre']);
                                $(this).show();
                                $(this).find(".usr-agrega button").removeClass("invisible");
                            }
                        })
                    }
                },
                error: function(){
                    console.log('error');
                }
            });
        });

        $(document).on( "click", ".btn-agrega-usr", function(event){
            var id = $(this).data("id");
            var text = $(this).data("text");
            var rows = $("#table-result-usr > tr").length;//limpia tabla actual

            if($('#usuario_box option[value="' + id + '"]').length == 0){
                $("#usuario_box").append($("<option></option>").attr("value",id).text(text));
            }
            if(rows > 1)
                $(this).parents("tr").remove();
            else{
                $(this).parents("tr").hide();
                $("#filter_desc-usr").val("");
            }
        });

        $(document).on( "click", ".btn-quita-usr", function(event){
            $("#usuario_box option:selected").remove();
        });

        function validaCampos(){
            var error = false;
            var inicio = $('#fecha_inicial').val();
            var fin = $('#fecha_final').val();
            var aux = inicio.split('/');
            inicio = aux[2]+'-'+aux[1]+'-'+aux[0];
            aux = fin.split('/');
            fin = aux[2]+'-'+aux[1]+'-'+aux[0];
            if(fin < inicio){
                $('#fecha_final').addClass('is-invalid');
                error = true;
            }
            if($('select').find('option').length == 0){
                error = true;
                $('.tipo_aviso').addClass('is-invalid');
            }else{
                $('.tipo_aviso').removeClass('is-invalid');
            }
            if(error){
                return false;
            }else{
                $('#tipo_box option').prop('selected', true);
                $('#usuario_box option').prop('selected', true);
                $('#formaModal').prp('action', './action/action_avisos_update.php');
            }
        }
    </script>
</body>
</html>