예제 #1
0
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 
}
예제 #2
0
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 
}
예제 #3
0
파일: reunion.php 프로젝트: i51243l/tutoria
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 
}
예제 #4
0
파일: informe.php 프로젝트: i51243l/tutoria
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 
}
예제 #5
0
파일: inicio.php 프로젝트: i51243l/tutoria

<!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">

                <!-- Page Heading -->
                <div class="row">
                    <div class="col-lg-12">
                        <h1 class="page-header">
                            Inicio <small>Sistema de Tutoría</small>
                        </h1>
                        
                    </div>
                </div>
예제 #6
0
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 
}
예제 #7
0
파일: meta.php 프로젝트: i51243l/tutoria
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 
}