function crear_asignacion($id_tuto) { include "conexion.php"; ?> <!DOCTYPE html> <html lang="es"> <?php all_head(); ?> <body> <div id="wrapper"> <!-- Navigation --> <?php navegacion($_SESSION['id_usua'], $_SESSION['tipo_usuario']); $query = "call nombre_periodo('" . $_SESSION['id_peri'] . "')"; $result = $conexion->query($query); $periodo = array(); while ($row = mysqli_fetch_row($result)) { $periodo = $row; } mysqli_free_result($result); $conexion->next_result(); $query = "call nombre_tutor('" . $id_tuto . "')"; $result = $conexion->query($query); $tutor = array(); while ($row = mysqli_fetch_row($result)) { $tutor = $row; } mysqli_free_result($result); $conexion->next_result(); ?> <div id="page-wrapper"> <div class="container-fluid"> <!-- Page Heading --> <div class="container"> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Asignaciones <small>Sistema de tutoría</small> </h1> </div> </div> <div class="row"> <div class="modal-content"> <div class="close-modal" data-dismiss="modal"> <div class="lr"> <div class="rl"> </div> </div> </div> <div class="row text-center"> <div class="col-lg-10 col-lg-offset-1"> <h4>Nueva Asignación: <?php echo $tutor[0]; ?> </h4> <h3>Periodo: <?php echo $periodo[0]; ?> </h3> <hr class="small"> </div> </div> <div class="container"> <form action='asignacion.php' method='post' id='formid_'> <input type="hidden" name='accion' value='create_asignacion' > <input type="hidden" name='id_tuto' <?php echo "value='" . $id_tuto . "'"; ?> > <div class="row"> <div class="col-sm-12"> <div class='panel panel-info' > <div class="panel-heading"> <h1 class="panel-title">Alumnos sin Tutor asignado</h1> </div> <div class="panel-body"> <br> <br> <table class="responsive table table-striped table-bordered table-hover table-condensed"> <tr class="info"> <th>Check</th> <th>Código</th> <th>Apellidos y Nombres</th> <th>Nro Matricula Mayor</th> </tr> <?php $query = "call estudiantes_no_asignados('" . $_SESSION['id_peri'] . "')"; $result = $conexion->query($query); $alumnos = array(); while ($row = mysqli_fetch_row($result)) { $alumnos[] = $row; } mysqli_free_result($result); $conexion->next_result(); for ($j = 0; $j < count($alumnos); $j++) { if ($alumnos[$j][3] == '1') { $trclass = 'success'; } elseif ($alumnos[$j][3] == '2') { $trclass = 'warning'; } else { $trclass = 'danger'; } ?> <tr <?php echo "class='" . $trclass . "'"; ?> > <td> <input type="hidden" name= <?php echo "item[] "; ?> value=<?php echo $alumnos[$j][0]; ?> > <input type="checkbox" value="S" <?php echo "name='respuesta[" . $alumnos[$j][0] . "]'"; ?> > </td> <td><?php echo $alumnos[$j][1]; ?> </td> <td><?php echo $alumnos[$j][2]; ?> </td> <td><?php echo $alumnos[$j][3]; ?> </td> </tr> <?php } ?> </table> </div> </div> </div> </div> <div class="row text-center"> <div class="col-lg-4"> </div> <div class="col-lg-4"> <div class="service-box text-center"> <input type="submit" class="btn btn-primary btn-block btn-md text-center" role="button" form='formid_'> </div> </div> <div class="col-lg-4"> </div> </div> </form> <br> </div> </div> </div> </div> </div> <!-- /.container-fluid --> <br> </div> <!-- /#page-wrapper --> </div> <!-- /#wrapper --> <!-- jQuery --> <script src="js/jquery.js"></script> <!-- Bootstrap Core JavaScript --> <script src="js/bootstrap.min.js"></script> <!-- Morris Charts JavaScript --> <script src="js/plugins/morris/raphael.min.js"></script> <script src="js/plugins/morris/morris.min.js"></script> <script src="js/plugins/morris/morris-data.js"></script> </body> </html> <?php }
function ver_consejeria($id_cons) { include "conexion.php"; ?> <!DOCTYPE html> <html lang="es"> <?php all_head(); ?> <body> <div id="wrapper"> <!-- Navigation --> <?php navegacion($_SESSION['id_usua'], $_SESSION['tipo_usuario']); $query = "call ver_consejeria('" . $id_cons . "')"; $result = $conexion->query($query); $consejeria = array(); while ($row = mysqli_fetch_row($result)) { $consejeria = $row; } mysqli_free_result($result); $conexion->next_result(); $query = "call nombres_consejeria('" . $id_cons . "')"; $result = $conexion->query($query); $nombres = array(); while ($row = mysqli_fetch_row($result)) { $nombres = $row; } mysqli_free_result($result); $conexion->next_result(); $query = "call listar_cuestionarios(" . $id_cons . ")"; $result = $conexion->query($query); $cuestionario = array(); while ($row = mysqli_fetch_row($result)) { $cuestionario[] = $row; } mysqli_free_result($result); $conexion->next_result(); ?> <div id="page-wrapper"> <div class="container-fluid"> <!-- Page Heading --> <div class="container"> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Consejería <small>Sistema de tutoría</small> </h1> </div> </div> <div class="row"> <div class="modal-content"> <div class="close-modal" data-dismiss="modal"> <div class="lr"> <div class="rl"> </div> </div> </div> <div class="row text-center"> <div class="col-lg-10 col-lg-offset-1"> <h3><?php echo $nombres[2]; ?> </h3> <h4>Alumno(a)</h4> <hr class="small"> </div> </div> <div class="container"> <!--inicio panel--> <div class="row" id='#collapse_alumno_1'> <div class="col-sm-12"> <div class="panel panel-info"> <div class="panel-heading"> <h1 class="panel-title"><a data-toggle="collapse" data-target="#collapse_alumno" href="#collapse_alumno_1">Formatos</a></h1> </div> <div id="collapse_alumno" class="panel-collapse collapse in"> <!-- in --> <div class="panel-body"> <br> <table class="responsive table table-striped table-bordered table-hover table-condensed"> <tr class="info"> <th>Nombre </th> <th>Estado </th> <th>Acciones</th> </tr> <?php for ($i = 0; $i < count($cuestionario); $i++) { if ($cuestionario[$i][2] == 1) { if ($cuestionario[$i][3] == 0) { $trclass = 'warning'; $estado = 'Vacio'; } elseif ($cuestionario[$i][3] == $cuestionario[$i][4]) { $trclass = 'success'; $estado = 'Completo'; } else { $trclass = 'danger'; $estado = 'Incompleto'; } ?> <form <?php echo "id='alumno_cuestionario_ver" . $cuestionario[$i][0] . "'"; ?> action="cuestionario.php" method="POST"> <input type="hidden" name='accion' value='ver_cuestionario' > <input type="hidden" name='id_cues' <?php echo "value='" . $cuestionario[$i][0] . "'"; ?> > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <?php if ($_SESSION['tipo_usuario'] == 'estudiante') { ?> <form <?php echo "id='alumno_cuestionario_editar" . $cuestionario[$i][0] . "'"; ?> action="cuestionario.php" method="POST"> <input type="hidden" name='accion' value='editar_cuestionario' > <input type="hidden" name='id_cues' <?php echo "value='" . $cuestionario[$i][0] . "'"; ?> > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <?php } ?> <tr <?php echo "class='" . $trclass . "'"; ?> > <td><?php echo $cuestionario[$i][1]; ?> </td> <td><?php echo $estado; ?> </td> <td> <a href='#' <?php echo "onclick='alumno_cuestionario_ver" . $cuestionario[$i][0] . ".submit(); return false'"; ?> ><i class="fa fa-eye"></i>Ver</a> <?php if ($_SESSION['tipo_usuario'] == 'estudiante') { ?> <a href='#' <?php echo "onclick='alumno_cuestionario_editar" . $cuestionario[$i][0] . ".submit(); return false'"; ?> ><i class="fa fa-pencil"></i>Editar</a> <?php } ?> </td> </tr> <?php } } ?> </table> </div> </div> </div> </div> </div> <!-- fin panel--> <!--inicio panel --> <form id='ver_metas' action="meta.php" method="POST"> <input type="hidden" name='accion' value='ver_metas' > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <div class="row"> <div class="col-sm-12"> <div class="panel panel-success"> <div class="panel-heading"> <h3 class="panel-title"><a href='#' onclick='ver_metas.submit(); return false'><i class="fa fa-file-text-o"></i> Ver Reporte de metas</a></h3> </div> </div> </div> </div> <!-- fin panel--> <!-- </form> --> </div> <div class="row text-center"> <div class="col-lg-10 col-lg-offset-1"> <h3><?php echo $nombres[3]; ?> </h3> <h4>Consejero(a) - Tutor(a)</h4> <hr class="small"> </div> </div> <div class="container"> <!--inicio panel--> <div class="row" id='#collapse_docente_1'> <div class="col-sm-12"> <div class="panel panel-info"> <div class="panel-heading"> <h1 class="panel-title"><a data-toggle="collapse" data-target="#collapse_docente" href="#collapse_docente_1">Formatos</a></h1> </div> <div id="collapse_docente" class="panel-collapse collapse in"> <!-- in --> <div class="panel-body"> <br> <table class="responsive table table-striped table-bordered table-hover table-condensed"> <tr class="info"> <th>Nombre </th> <th>Estado </th> <th>Acciones</th> </tr> <?php for ($i = 0; $i < count($cuestionario); $i++) { if ($cuestionario[$i][2] == 2) { if ($cuestionario[$i][3] == 0) { $trclass = 'warning'; $estado = 'Vacio'; } elseif ($cuestionario[$i][3] == $cuestionario[$i][4]) { $trclass = 'success'; $estado = 'Completo'; } else { $trclass = 'danger'; $estado = 'Incompleto'; } ?> <form <?php echo "id='alumno_cuestionario_ver" . $cuestionario[$i][0] . "'"; ?> action="cuestionario.php" method="POST"> <input type="hidden" name='accion' value='ver_cuestionario' > <input type="hidden" name='id_cues' <?php echo "value='" . $cuestionario[$i][0] . "'"; ?> > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <?php if ($_SESSION['tipo_usuario'] == 'docente') { ?> <form <?php echo "id='alumno_cuestionario_editar" . $cuestionario[$i][0] . "'"; ?> action="cuestionario.php" method="POST"> <input type="hidden" name='accion' value='editar_cuestionario' > <input type="hidden" name='id_cues' <?php echo "value='" . $cuestionario[$i][0] . "'"; ?> > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <?php } ?> <tr <?php echo "class='" . $trclass . "'"; ?> > <td><?php echo $cuestionario[$i][1]; ?> </td> <td><?php echo $estado; ?> </td> <td> <a href='#' <?php echo "onclick='alumno_cuestionario_ver" . $cuestionario[$i][0] . ".submit(); return false'"; ?> ><i class="fa fa-eye"></i>Ver</a> <?php if ($_SESSION['tipo_usuario'] == 'docente') { ?> <a href='#' <?php echo "onclick='alumno_cuestionario_editar" . $cuestionario[$i][0] . ".submit(); return false'"; ?> ><i class="fa fa-pencil"></i>Editar</a> <?php } ?> </td> </tr> <?php } } ?> </table> </div> </div> </div> </div> </div> <!-- fin panel--> <!--inicio panel --> <?php $query = "call consejeria_2_tutor(" . $id_cons . ")"; $result = $conexion->query($query); $tutor = array(); while ($row = mysqli_fetch_row($result)) { $tutor = $row; } mysqli_free_result($result); $conexion->close(); ?> <?php if ($_SESSION['tipo_usuario'] != 'estudiante') { ?> <form id='ver_informe' action="informe.php" method="POST"> <input type="hidden" name='accion' value='ver_informe' > <input type="hidden" name='id_tuto' <?php echo "value='" . $tutor[0] . "'"; ?> > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <div class="row"> <div class="col-sm-12"> <div class="panel panel-success"> <div class="panel-heading"> <h3 class="panel-title"><a href='#' onclick='ver_informe.submit(); return false'><i class="fa fa-file-text-o"></i> Ver Informe Semestral de Labor de Consejería - Tutoría Académica</a></h3> </div> </div> </div> </div> <?php if ($_SESSION['tipo_usuario'] == 'docente') { ?> <form id='editar_informe' action="informe.php" method="POST"> <input type="hidden" name='accion' value='editar_informe' > <input type="hidden" name='id_tuto' <?php echo "value='" . $tutor[0] . "'"; ?> > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <div class="row"> <div class="col-sm-12"> <div class="panel panel-info"> <div class="panel-heading"> <h3 class="panel-title"><a href='#' onclick='editar_informe.submit(); return false'><i class="fa fa-file-text-o"></i> Editar Informe Semestral de Labor de Consejería - Tutoría Académica</a></h3> </div> </div> </div> </div> <?php } ?> <?php } ?> <!-- fin panel--> <!-- </form> --> </div> <div class="row text-center"> <div class="col-lg-10 col-lg-offset-1"> <h3>Reuniones</h3> <hr class="small"> </div> </div> <div class="container"> <!--inicio panel--> <!-- fin panel--> <!--inicio panel--> <form id='ver_reuniones' action="reunion.php" method="POST"> <input type="hidden" name='accion' value='ver_reuniones' > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <div class="row"> <div class="col-sm-12"> <div class="panel panel-success"> <div class="panel-heading"> <h3 class="panel-title"><a href='#' onclick='ver_reuniones.submit(); return false'><i class="fa fa-file-text-o"></i> Ver Registro de la Consejería - Tutoría Académica</a></h3> </div> </div> </div> </div> <!-- fin panel--> <!-- </form> --> </div> </div> </div> </div> </div> <!-- /.container-fluid --> </div> <!-- /#page-wrapper --> </div> <!-- /#wrapper --> <!-- jQuery --> <script src="js/jquery.js"></script> <!-- Bootstrap Core JavaScript --> <script src="js/bootstrap.min.js"></script> <!-- Morris Charts JavaScript --> <script src="js/plugins/morris/raphael.min.js"></script> <script src="js/plugins/morris/morris.min.js"></script> <script src="js/plugins/morris/morris-data.js"></script> </body> </html> <?php }
function ver_reuniones($id_cons) { include "conexion.php"; ?> <!DOCTYPE html> <html lang="es"> <?php all_head(); ?> <body> <div id="wrapper"> <!-- Navigation --> <?php navegacion($_SESSION['id_usua'], $_SESSION['tipo_usuario']); $query = "call cabecera_cuestionario('" . $id_cons . "')"; $result = $conexion->query($query); $cabecera = array(); while ($row = mysqli_fetch_row($result)) { $cabecera = $row; } mysqli_free_result($result); $conexion->next_result(); $query = "call ver_individual_reuniones('" . $id_cons . "')"; $result = $conexion->query($query); $reunioni = array(); while ($row = mysqli_fetch_row($result)) { $reunioni[] = $row; } mysqli_free_result($result); $conexion->next_result(); $query = "call ver_grupal_reuniones('" . $id_cons . "')"; $result = $conexion->query($query); $reuniong = array(); while ($row = mysqli_fetch_row($result)) { $reuniong[] = $row; } mysqli_free_result($result); $conexion->next_result(); ?> <div id="page-wrapper"> <div class="container-fluid"> <!-- Page Heading --> <div class="container"> <br> <form id='volver' action="consejeria.php" method="POST"> <input type="hidden" name='accion' value='ver_consejeria' > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <div class="row"> <div class="col-lg-12"> <h1 class="page-header"><a href='#' onclick='volver.submit(); return false'><i class="fa fa-chevron-circle-left "></i></a> Registro de Reuniones <small>Sistema de tutoría</small> </h1> </div> </div> <div class="row"> <div class="modal-content"> <div class="close-modal" data-dismiss="modal"> <div class="lr"> <div class="rl"> </div> </div> </div> <div class="row text-center"> <div class="col-lg-10 col-lg-offset-1"> <h3>Registro de la Consejería - Tutoría Académica</h3> <hr class="small"> </div> </div> <div class="col-sm-6" > <div class="form-group"> <label for="fecha">Facultad:</label> Ingeniería </div> <div class="form-group"> <label for="fecha">Estudiante:</label> <?php echo $cabecera[2]; ?> </div> <div class="form-group"> <label for="fecha">Docente:</label> <?php echo $cabecera[4]; ?> </div> </div> <div class="col-sm-6" > <div class="form-group"> <label for="fecha">Escuela:</label> Ingeniería en Informática y Sistemas </div> <div class="form-group"> <label for="fecha">Código:</label> <?php echo $cabecera[3]; ?> </div> <div class="form-group"> <label for="fecha">Semestre:</label> <?php echo $cabecera[5]; ?> </div> </div> <div class="container"> <form <?php echo "id='crear_reunion_individual'"; ?> action="reunion.php" method="POST"> <input type="hidden" name='accion' value='crear_reunion' > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > <input type="hidden" name='modalidad' value='I' > </form> <form <?php echo "id='crear_reunion_grupal'"; ?> action="reunion.php" method="POST"> <input type="hidden" name='accion' value='crear_reunion' > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > <input type="hidden" name='modalidad' value='G' > </form> <div class="row" id="collapse_asistidos_2"> <div class='col-sm-12'> <div class='panel panel-info'> <div class="panel-heading"> <h1 class="panel-title"><a data-toggle="collapse" data-target='#collapse_reunion_individual' href='#collapse_asistidos_2'>Reuniones Individuales</a></h1> </div> <div id='collapse_reunion_individual' class="panel-collapse collapse in"> <!-- in --> <div class="panel-body"> <?php if ($_SESSION['tipo_usuario'] == 'docente') { ?> <a href='#' onclick='crear_reunion_individual.submit(); return false'><i class="fa fa-plus"></i> Crear Reunión Individual</a> <?php } ?> <br> <?php if (count($reunioni) > 0) { ?> <br> <table class="responsive table table-striped table-bordered table-hover table-condensed"> <tr class="info"> <th>Fecha y Hora</th> <th>Motivo</th> <th>Asunto</th> <?php if ($_SESSION['tipo_usuario'] == 'docente') { ?> <th>Acciones</th> <?php } ?> </tr> <?php for ($i = 0; $i < count($reunioni); $i++) { ?> <?php if ($_SESSION['tipo_usuario'] == 'docente') { ?> <form <?php echo "id='editar_reunioni_" . $reunioni[$i][0] . "'"; ?> action="reunion.php" method="POST"> <input type="hidden" name='accion' value='editar_reunion' > <input type="hidden" name='id_reun' <?php echo "value='" . $reunioni[$i][0] . "'"; ?> > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <form <?php echo "id='delete_reunioni_" . $reunioni[$i][0] . "'"; ?> action="reunion.php" method="POST"> <input type="hidden" name='accion' value='delete_reunion' > <input type="hidden" name='id_reun' <?php echo "value='" . $reunioni[$i][0] . "'"; ?> > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <?php } ?> <tr class='success'> <td><?php echo $reunioni[$i][1]; ?> </td> <td><?php echo $reunioni[$i][2]; ?> </td> <td><?php echo $reunioni[$i][3]; ?> </td> <?php if ($_SESSION['tipo_usuario'] == 'docente') { ?> <td> <a href='#' <?php echo "onclick='editar_reunioni_" . $reunioni[$i][0] . ".submit(); return false'"; ?> ><i class="fa fa-pencil"></i> Editar</a> <a href='#' <?php echo "onclick='delete_reunioni_" . $reunioni[$i][0] . ".submit(); return false'"; ?> ><i class="fa fa-eraser"></i> Eliminar</a> </td> <?php } ?> </tr> <?php } ?> </table> <?php } ?> </div> </div> </div> </div> </div> <div class="row" id="collapse_asistidos_4"> <div class='col-sm-12'> <div class='panel panel-info'> <div class="panel-heading"> <h1 class="panel-title"><a data-toggle="collapse" data-target='#collapse_reunion_grupal' href='#collapse_asistidos_4'>Reuniones Grupales</a></h1> </div> <div id='collapse_reunion_grupal' class="panel-collapse collapse in"> <!-- in --> <div class="panel-body"> <?php if ($_SESSION['tipo_usuario'] == 'docente') { ?> <a href='#' onclick='crear_reunion_grupal.submit(); return false'><i class="fa fa-plus"></i> Crear Reunión Grupal</a> <?php } ?> <br> <?php if (count($reuniong) > 0) { ?> <br> <table class="responsive table table-striped table-bordered table-hover table-condensed"> <tr class="info"> <th>Fecha y Hora</th> <th>Motivo</th> <th>Asunto</th> <?php if ($_SESSION['tipo_usuario'] == 'docente') { ?> <th>Acciones</th> <?php } ?> </tr> <?php for ($i = 0; $i < count($reuniong); $i++) { ?> <?php if ($_SESSION['tipo_usuario'] == 'docente') { ?> <form <?php echo "id='editar_reuniong_" . $reuniong[$i][0] . "'"; ?> action="reunion.php" method="POST"> <input type="hidden" name='accion' value='editar_reunion' > <input type="hidden" name='id_reun' <?php echo "value='" . $reuniong[$i][0] . "'"; ?> > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <form <?php echo "id='delete_reuniong_" . $reuniong[$i][0] . "'"; ?> action="reunion.php" method="POST"> <input type="hidden" name='accion' value='delete_reunion' > <input type="hidden" name='id_reun' <?php echo "value='" . $reuniong[$i][0] . "'"; ?> > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <?php } ?> <tr class='warning'> <td><?php echo $reuniong[$i][1]; ?> </td> <td><?php echo $reuniong[$i][2]; ?> </td> <td><?php echo $reuniong[$i][3]; ?> </td> <?php if ($_SESSION['tipo_usuario'] == 'docente') { ?> <td> <a href='#' <?php echo "onclick='editar_reuniong_" . $reuniong[$i][0] . ".submit(); return false'"; ?> ><i class="fa fa-pencil"></i> Editar</a> <a href='#' <?php echo "onclick='delete_reuniong_" . $reuniong[$i][0] . ".submit(); return false'"; ?> ><i class="fa fa-eraser"></i> Eliminar</a> </td> <?php } ?> </tr> <?php } ?> </table> <?php } ?> </div> </div> </div> </div> </div> <div class="text-right"> <p>Tacna, <?php echo date('d'); ?> de <?php mes(date('F')); ?> de <?php echo date('Y'); ?> </p> </div> <br> <!-- </form> --> <div class="row text-center"> <div class="col-lg-4"> </div> <div class="col-lg-4"> <div class="service-box text-center"> <input name="Imprimir" class="btn btn-primary btn-block btn-md text-center" id="imprimir" onclick="DescargarPDF('page-wrapper','registro')" value="Descargar PDF"> </div> </div> <div class="col-lg-4"> </div> </div> <br><br> </div> </div> </div> </div> </div> <!-- /.container-fluid --> </div> <!-- /#page-wrapper --> </div> <!-- /#wrapper --> <!-- jQuery --> <script src="js/jquery.js"></script> <script src="js/jspdf.debug.js"></script> <script> function DescargarPDF(ContenidoID,nombre){ var pdf = new jsPDF('p','pt','letter'); html = $('#'+ContenidoID).html(); specialElementHandlers = {}; margins = {top: 10, bottom: 20, left: 20, width:522}; pdf.fromHTML(html, margins.left, margins.top, {'width': margins.width},function(dispose) {pdf.save(nombre+'.pdf')},margins); } </script> <!-- Bootstrap Core JavaScript --> <script src="js/bootstrap.min.js"></script> <!-- Morris Charts JavaScript --> <script src="js/plugins/morris/raphael.min.js"></script> <script src="js/plugins/morris/morris.min.js"></script> <script src="js/plugins/morris/morris-data.js"></script> </body> </html> <?php }
function ver_informe($accion, $id_tuto, $id_cons) { include "conexion.php"; ?> <!DOCTYPE html> <html lang="es"> <?php all_head(); ?> <body> <div id="wrapper"> <!-- Navigation --> <?php navegacion($_SESSION['id_usua'], $_SESSION['tipo_usuario']); $query = "call cabecera_informe('" . $id_tuto . "')"; $result = $conexion->query($query); $cabecera = array(); while ($row = mysqli_fetch_row($result)) { $cabecera = $row; } mysqli_free_result($result); $conexion->next_result(); $query = "call ver_asistidos_informe('" . $id_tuto . "')"; $result = $conexion->query($query); $asistidos = array(); while ($row = mysqli_fetch_row($result)) { $asistidos[] = $row; } mysqli_free_result($result); $conexion->next_result(); ?> <div id="page-wrapper"> <div class="container-fluid"> <!-- Page Heading --> <div class="container"> <div class="row"> <div class="col-lg-12"> <form id='volver' action="consejeria.php" method="POST"> <input type="hidden" name='accion' value='ver_consejeria' > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <h1 class="page-header"><a href='#' onclick='volver.submit(); return false'><i class="fa fa-chevron-circle-left "></i></a> Informe Semestral <small>Sistema de tutoría</small> </h1> </div> </div> <div class="row"> <div class="modal-content"> <div class="close-modal" data-dismiss="modal"> <div class="lr"> <div class="rl"> </div> </div> </div> <div class="row text-center"> <div class="col-lg-10 col-lg-offset-1"> <h3>Informe Semestral de Labor de Consejería - Tutoría Académica</h3> <hr class="small"> </div> </div> <div class="col-sm-6" > <div class="form-group"> <label for="fecha">Facultad:</label> Ingeniería </div> <div class="form-group"> <label for="fecha">Docente:</label> <?php echo $cabecera[0]; ?> </div> </div> <div class="col-sm-6" > <div class="form-group"> <label for="fecha">Escuela:</label> Ingeniería en Informática y Sistemas </div> <div class="form-group"> <label for="fecha">Semestre:</label> <?php echo $cabecera[1]; ?> </div> </div> <div class="container"> <?php if ($_SESSION['tipo_usuario'] == 'docente' and $accion == 'editar_informe') { ?> <form id='editar_asistidos' action="consejeria.php" method="POST"> <input type="hidden" name='consejeria' value=<?php echo $id_cons; ?> > <?php } ?> <div class="row" id="collapse_asistidos_2"> <div class='col-sm-12'> <div class='panel panel-info'> <div class="panel-heading"> <h1 class="panel-title"><a data-toggle="collapse" data-target='#collapse_asistidos' href='#collapse_asistidos_2'>Estudiantes Asistidos</a></h1> </div> <div id='collapse_asistidos' class="panel-collapse collapse in"> <!-- in --> <div class="panel-body"> <br> <table class="responsive table table-striped table-bordered table-hover table-condensed"> <tr class="info"> <th>Código</th> <th>Nombre del Estudiante</th> <th>Tema</th> <th>Situación Académica</th> </tr> <?php for ($i = 0; $i < count($asistidos); $i++) { ?> <?php if ($_SESSION['tipo_usuario'] == 'docente' and $accion == 'editar_informe') { ?> <input type="hidden" name= <?php echo "id_cons[] "; ?> value=<?php echo $asistidos[$i][0]; ?> > <?php } ?> <tr> <td><?php echo $asistidos[$i][2]; ?> </td> <td><?php echo $asistidos[$i][3]; ?> </td> <td> <?php if ($_SESSION['tipo_usuario'] == 'docente' and $accion == 'editar_informe') { ?> <input class="form-control" type="text" <?php echo "name='tema[" . $asistidos[$i][0] . "]'"; ?> <?php echo "value='" . $asistidos[$i][4] . "'"; ?> > <?php } else { ?> <?php echo $asistidos[$i][4]; ?> <?php } ?> </td> <td> <?php if ($_SESSION['tipo_usuario'] == 'docente' and $accion == 'editar_informe') { ?> <input class="form-control" type="text" <?php echo "name='situacion[" . $asistidos[$i][0] . "]'"; ?> <?php echo "value='" . $asistidos[$i][5] . "'"; ?> > <?php } else { ?> <?php echo $asistidos[$i][5]; ?> <?php } ?> </td> </tr> <?php } ?> </table> </div> </div> </div> </div> </div> <div class="row" id="collapse_asistidos_4"> <div class='col-sm-12'> <div class='panel panel-info'> <div class="panel-heading"> <h1 class="panel-title"><a data-toggle="collapse" data-target='#collapse_asistidos_3' href='#collapse_asistidos_4'>Estudiantes Asistidos</a></h1> </div> <div id='collapse_asistidos_3' class="panel-collapse collapse in"> <!-- in --> <div class="panel-body"> <br> <?php $modificable = 'readonly'; if ($_SESSION['tipo_usuario'] == 'docente' and $accion == 'editar_informe') { $modificable = ''; } ?> <div class="col-sm-6" > <div class="form-group"> <label for="fecha">Motivos comunes de visita al Docente Consejero - Tutor:</label> <div class="input-group"> <span class="input-group-addon"><span class=""></span></span> <input class="form-control" name='motivos' type="text" <?php echo "value='" . $cabecera[2] . "'"; ?> <?php echo $modificable; ?> > </div> </div> <div class="form-group"> <label for="fecha">Los estudiantes tutorados fueron derivados mayormente a:</label> <div class="input-group"> <span class="input-group-addon"><span class=""></span></span> <textarea class="form-control" name='derivados' <?php echo $modificable; ?> ><?php echo $cabecera[4]; ?> </textarea> </div> </div> </div> <div class="col-sm-6" > <div class="form-group"> <label for="fecha">Principales obstáculos encontrados para orientar adecuadamente:</label> <div class="input-group"> <span class="input-group-addon"><span class=""></span></span> <input class="form-control" name='obstaculos' type="text" <?php echo "value='" . $cabecera[3] . "'"; ?> <?php echo $modificable; ?> > </div> </div> </div> </div> </div> </div> </div> </div> <div class="text-right"> <p>Tacna, <?php echo date('d'); ?> de <?php mes(date('F')); ?> de <?php echo date('Y'); ?> </p> </div> <div class="row text-center"> <?php switch ($accion) { case 'editar_informe': ?> <div class="col-lg-4"> </div> <div class="col-lg-4"> <div class="service-box text-center"> <input type="submit" class="btn btn-primary btn-block btn-md text-center" role="button"> </div> </div> <div class="col-lg-4"> </div> <?php break; case 'ver_informe': ?> <div class="col-lg-4"> </div> <div class="col-lg-4"> <div class="service-box text-center"> <input name="Imprimir" class="btn btn-primary btn-block btn-md text-center" id="imprimir" onclick="DescargarPDF('page-wrapper','informe')" value="DescargarPDF"> </div> </div> <div class="col-lg-4"> </div> <?php default: # code... break; } ?> </div> <br> <?php if ($_SESSION['tipo_usuario'] == 'docente' and $accion == 'editar_informe') { ?> <input type="hidden" name='accion' value='update_informe' > <input type="hidden" name='id_tuto' <?php echo "value='" . $id_tuto . "'"; ?> > </form> <?php } ?> <!-- </form> --> </div> </div> </div> </div> </div> <!-- /.container-fluid --> </div> <!-- /#page-wrapper --> </div> <!-- /#wrapper --> <!-- jQuery --> <script src="js/jquery.js"></script> <script src="js/jspdf.debug.js"></script> <script> function DescargarPDF(ContenidoID,nombre){ var pdf = new jsPDF('p','pt','letter'); html = $('#'+ContenidoID).html(); specialElementHandlers = {}; margins = {top: 10, bottom: 20, left: 20, width:522}; pdf.fromHTML(html, margins.left, margins.top, {'width': margins.width},function(dispose) {pdf.save(nombre+'.pdf')},margins); } </script> <!-- Bootstrap Core JavaScript --> <script src="js/bootstrap.min.js"></script> <!-- Morris Charts JavaScript --> <script src="js/plugins/morris/raphael.min.js"></script> <script src="js/plugins/morris/morris.min.js"></script> <script src="js/plugins/morris/morris-data.js"></script> </body> </html> <?php }
session_start(); if (isset($_SESSION['loggedin']) && $_SESSION['loggedin'] == true) { } else { header('Location: login.php'); exit; } header('Content-Type: text/html; charset=ISO-8859-1'); include "frontend.php"; ?> <!DOCTYPE html> <html lang="es"> <?php all_head(); ?> <body> <div id="wrapper"> <!-- Navigation --> <?php navegacion($_SESSION['id_usua'], $_SESSION['tipo_usuario']); ?> <div id="page-wrapper"> <div class="container-fluid">
function ver_cuestionario($accion, $id_cons, $id_cues) { include "conexion.php"; ?> <!DOCTYPE html> <html lang="es"> <?php all_head(); ?> <body> <div id="wrapper"> <!-- Navigation --> <?php navegacion($_SESSION['id_usua'], $_SESSION['tipo_usuario']); $query = "call ver_cuestionario('" . $id_cues . "')"; $result = $conexion->query($query); $cuestionario = array(); while ($row = mysqli_fetch_row($result)) { $cuestionario = $row; } mysqli_free_result($result); $conexion->next_result(); $query = "call cabecera_cuestionario('" . $id_cons . "')"; $result = $conexion->query($query); $cabecera = array(); while ($row = mysqli_fetch_row($result)) { $cabecera = $row; } mysqli_free_result($result); $conexion->next_result(); ?> <div id="page-wrapper"> <div class="container-fluid"> <!-- Page Heading --> <div class="container"> <div class="row"> <div class="col-lg-12"> <form id='volver' action="consejeria.php" method="POST"> <input type="hidden" name='accion' value='ver_consejeria' > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <h1 class="page-header"><a href='#' onclick='volver.submit(); return false'><i class="fa fa-chevron-circle-left "></i></a> Formatos <small>Sistema de tutoría</small></h1> </div> </div> <br> <div class="row"> <div class=" modal-content"> <div class="close-modal" data-dismiss="modal"> <div class="lr"> <div class="rl"> </div> </div> </div> <div class="row text-center"> <div class="col-lg-10 col-lg-offset-1"> <h3><?php echo $cuestionario[0]; ?> </h3> <hr class="small"> </div> </div> <div class="col-sm-6" > <div class="form-group"> <label for="fecha">Facultad:</label> <!--<div class="input-group"> <span class="input-group-addon"><span class=""></span></span> <input class="form-control" type="text" value='Ingeniería' readonly> </div>--> Ingeniería </div> <div class="form-group"> <label for="fecha">Estudiante:</label> <?php echo $cabecera[2]; ?> </div> <div class="form-group"> <label for="fecha">Docente:</label> <?php echo $cabecera[4]; ?> </div> </div> <div class="col-sm-6" > <div class="form-group"> <label for="fecha">Escuela:</label> Ingeniería en Informática y Sistemas </div> <div class="form-group"> <label for="fecha">Código:</label> <?php echo $cabecera[3]; ?> </div> <div class="form-group"> <label for="fecha">Semestre:</label> <?php echo $cabecera[5]; ?> </div> </div> <?php echo $cuestionario[1]; ?> <div class="container"> <!--formulario simple--> <form action='consejeria.php' method='post' id='editar'> <?php $query = "call ver_secciones('" . $id_cues . "')"; $result = $conexion->query($query); $secciones = array(); while ($row = mysqli_fetch_row($result)) { $secciones[] = $row; } mysqli_free_result($result); $conexion->next_result(); for ($i = 0; $i < count($secciones); $i++) { ?> <!--textos largos--> <div class="row"> <div class="col-sm-12"> <div class="panel panel-info"> <div class="panel-heading"> <h3 class="panel-title"><?php echo $secciones[$i][1]; ?> </h3> </div> <div class="panel-body"> <?php $query = "call ver_items('" . $id_cons . "','" . $secciones[$i][0] . "')"; $result = $conexion->query($query); $items = array(); while ($row = mysqli_fetch_row($result)) { $items[] = $row; } mysqli_free_result($result); $conexion->next_result(); ?> <div class="col-sm-6" > <?php for ($j = 0; $j < count($items); $j = $j + 2) { ?> <div class="form-group"> <label for="fecha"> <?php echo $items[$j][1]; ?> :</label> <?php switch ($accion) { case 'ver_cuestionario': echo $items[$j][3]; break; case 'editar_cuestionario': item($items[$j][0], $items[$j][2], $items[$j][3]); break; default: # code... break; } ?> </div> <?php } ?> </div> <div class="col-sm-6" > <?php for ($j = 1; $j < count($items); $j = $j + 2) { ?> <div class="form-group"> <label for="fecha"> <?php echo $items[$j][1]; ?> :</label> <?php switch ($accion) { case 'ver_cuestionario': echo $items[$j][3]; ?> <!--<div class="input-group"> <span class="input-group-addon"><span class=""></span></span> <input class="form-control" type="text" value='' readonly> </div>--> <?php break; case 'editar_cuestionario': item($items[$j][0], $items[$j][2], $items[$j][3]); break; default: # code... break; } ?> </div> <?php } ?> </div> </div> </div> </div> </div> <?php } $conexion->close(); ?> <div class="text-right"> <p>Tacna, <?php echo date('d'); ?> de <?php mes(date('F')); ?> de <?php echo date('Y'); ?> </p> </div> <div class="row text-center"> <?php switch ($accion) { case 'editar_cuestionario': ?> <input type="hidden" name='id_cons' value=<?php echo $id_cons; ?> > <input type="hidden" name='accion' value='update_cuestionario' > <div class="col-lg-4"> </div> <div class="col-lg-4"> <div class="service-box text-center"> <input type="submit" class="btn btn-primary btn-block btn-md text-center" role="button"> </div> </div> <div class="col-lg-4"> </div> <?php break; case 'ver_cuestionario': ?> <div class="col-lg-4"> </div> <div class="col-lg-4"> <div class="service-box text-center"> <input name="Imprimir" class="btn btn-primary btn-block btn-md text-center" id="imprimir" onclick="DescargarPDF('page-wrapper','cuestionario')" value="DescargarPDF"> </div> </div> <div class="col-lg-4"> </div> <?php break; default: # code... break; } ?> </div> <br> </form> </div> </div> </div> </div> </div> <!-- /.container-fluid --> </div> <!-- /#page-wrapper --> </div> <!-- /#wrapper --> <!-- <script src="js/jquery-2.1.4.min.js" ></script> --> <script src="js/jspdf.debug.js"></script> <script> function DescargarPDF(ContenidoID,nombre){ var pdf = new jsPDF('p','pt','letter'); html = $('#'+ContenidoID).html(); specialElementHandlers = {}; margins = {top: 10, bottom: 20, left: 20, width:522}; pdf.fromHTML(html, margins.left, margins.top, {'width': margins.width},function(dispose) {pdf.save(nombre+'.pdf')},margins); } </script> <!-- jQuery --> <script src="js/jquery.js"></script> <!-- Bootstrap Core JavaScript --> <script src="js/bootstrap.min.js"></script> <!-- Morris Charts JavaScript --> <script src="js/plugins/morris/raphael.min.js"></script> <script src="js/plugins/morris/morris.min.js"></script> <script src="js/plugins/morris/morris-data.js"></script> </body> </html> <?php }
function ver_metas($id_cons) { include "conexion.php"; ?> <!DOCTYPE html> <html lang="es"> <?php all_head(); ?> <body> <div id="wrapper"> <!-- Navigation --> <?php navegacion($_SESSION['id_usua'], $_SESSION['tipo_usuario']); $query = "call ver_cursos('" . $id_cons . "')"; $result = $conexion->query($query); $cursos = array(); while ($row = mysqli_fetch_row($result)) { $cursos[] = $row; } mysqli_free_result($result); $conexion->next_result(); $query = "call nombres_consejeria('" . $id_cons . "')"; $result = $conexion->query($query); $nombres = array(); while ($row = mysqli_fetch_row($result)) { $nombres = $row; } mysqli_free_result($result); $conexion->next_result(); ?> <div id="page-wrapper" class='print'> <div class="container-fluid"> <!-- Page Heading --> <div class="container"> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Asignaciones <small>Sistema de tutoría</small> </h1> </div> </div> <br> <div class="row"> <div class="modal-content"> <div class="close-modal" data-dismiss="modal"> <div class="lr"> <div class="rl"> </div> </div> </div> <div class="row text-center"> <div class="col-lg-10 col-lg-offset-1"> <h3><?php echo $nombres[2]; ?> </h3> <h4>Alumno(a)</h4> <hr class="small"> </div> </div> <div class="container"> <?php for ($i = 0; $i < count($cursos); $i++) { if ($cursos[$i][3] == '0') { $colorpanel = 'warning'; } else { $colorpanel = 'info'; } ?> <form <?php echo "id='crear_meta_" . $cursos[$i][0] . "'"; ?> action="meta.php" method="POST"> <input type="hidden" name='accion' value='crear_meta' > <input type="hidden" name='id_matr' <?php echo "value='" . $cursos[$i][0] . "'"; ?> > </form> <div class="row" <?php echo "id='#collapse_2_" . $cursos[$i][0] . "'"; ?> > <div class="col-sm-12"> <div <?php echo "class='panel panel-" . $colorpanel . "'"; ?> > <div class="panel-heading"> <h1 class="panel-title"><a data-toggle="collapse" <?php echo "data-target='#collapse_" . $cursos[$i][0] . "'"; ?> <?php echo "href='#collapse_2_" . $cursos[$i][0] . "'"; ?> ><?php echo $cursos[$i][1] . ": " . $cursos[$i][3] . " metas"; ?> </a></h1> </div> <div <?php echo "id='collapse_" . $cursos[$i][0] . "'"; ?> class="panel-collapse collapse"> <!-- in --> <div class="panel-body"> <?php if ($_SESSION['tipo_usuario'] == 'estudiante') { ?> <a href='#' <?php echo "onclick='crear_meta_" . $cursos[$i][0] . ".submit(); return false'"; ?> ><i class="fa fa-plus"></i> Añadir meta</a> <?php } ?> <br> <?php if ($cursos[$i][3] != '0') { ?> <br> <table class="responsive table table-striped table-bordered table-hover table-condensed"> <tr class="info"> <th>Fecha</th> <th>Meta Promedio</th> <th>Promedio Actual</th> <th>¿En riesgo?</th> <th>¿Qué hice?</th> <th>¿Qué no hice?</th> <th>¿Qué debo hacer?</th> <?php if ($_SESSION['tipo_usuario'] == 'estudiante') { ?> <th>Acciones</th> <?php } ?> </tr> <?php $query = "call ver_metas('" . $cursos[$i][0] . "')"; $result = $conexion->query($query); $metas = array(); while ($row = mysqli_fetch_row($result)) { $metas[] = $row; } mysqli_free_result($result); $conexion->next_result(); for ($j = 0; $j < count($metas); $j++) { if ($metas[$j][4] == "S") { $trclass = 'danger'; $riesgo = 'Si'; } else { $trclass = 'success'; $riesgo = 'No'; } if ($_SESSION['tipo_usuario'] == 'estudiante') { ?> <form <?php echo "id='editar_meta_" . $metas[$j][1] . "'"; ?> action="meta.php" method="POST"> <input type="hidden" name='accion' value='editar_meta' > <input type="hidden" name='id_meta' <?php echo "value='" . $metas[$j][1] . "'"; ?> > </form> <form <?php echo "id='delete_meta_" . $metas[$j][1] . "'"; ?> action="meta.php" method="POST"> <input type="hidden" name='accion' value='delete_meta' > <input type="hidden" name='id_meta' <?php echo "value='" . $metas[$j][1] . "'"; ?> > <input type="hidden" name='id_cons' <?php echo "value='" . $id_cons . "'"; ?> > </form> <?php } ?> <tr <?php echo "class='" . $trclass . "'"; ?> > <td><?php echo $metas[$j][0]; ?> </td> <td><?php echo $metas[$j][2]; ?> </td> <td><?php echo $metas[$j][3]; ?> </td> <td><?php echo $riesgo; ?> </td> <td><?php echo $metas[$j][5]; ?> </td> <td><?php echo $metas[$j][6]; ?> </td> <td><?php echo $metas[$j][7]; ?> </td> <?php if ($_SESSION['tipo_usuario'] == 'estudiante') { ?> <td> <a href='#' <?php echo "onclick='editar_meta_" . $metas[$j][1] . ".submit(); return false'"; ?> ><i class="fa fa-pencil"></i> Editar</a> <a href='#' <?php echo "onclick='delete_meta_" . $metas[$j][1] . ".submit(); return false'"; ?> ><i class="fa fa-eraser"></i> Eliminar</a> </td> <?php } ?> </tr> <?php } ?> </table> <?php } ?> </div> </div> </div> </div> </div> <?php } ?> <br> <div class="row text-center"> <div class="col-lg-4"> </div> <div class="col-lg-4"> <div class="service-box text-center"> <input name="Imprimir" class="btn btn-primary btn-block btn-md text-center" id="imprimir" onclick="DescargarPDF('page-wrapper','metas')" value="Descargar PDF"> </div> </div> <div class="col-lg-4"> </div> </div> <br><br> <!-- </form> --> </div> </div> </div> </div> </div> <!-- /.container-fluid --> </div> <!-- /#page-wrapper --> </div> <!-- /#wrapper --> <!-- jQuery --> <script src="js/jquery.js"></script> <script src="js/jspdf.debug.js"></script> <script> function DescargarPDF(ContenidoID,nombre){ var pdf = new jsPDF('p','pt','letter'); html = $('#'+ContenidoID).html(); specialElementHandlers = {}; margins = {top: 10, bottom: 20, left: 20, width:522}; pdf.fromHTML(html, margins.left, margins.top, {'width': margins.width},function(dispose) {pdf.save(nombre+'.pdf')},margins); } </script> <!-- Bootstrap Core JavaScript --> <script src="js/bootstrap.min.js"></script> <!-- Morris Charts JavaScript --> <script src="js/plugins/morris/raphael.min.js"></script> <script src="js/plugins/morris/morris.min.js"></script> <script src="js/plugins/morris/morris-data.js"></script> </body> </html> <?php }