PAAD
/
paad


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

$user = Login::get_user();

$user->access('Avisos');
if ($user->acceso == null) {
    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 = $today < $fs_aviso['aviso_fecha_inicial'];
?>
<!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) { ?>
                                    <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');
            <?php } 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>