function impCursos($link, $curso)
{
$sql = "SELECT CONCAT(p.nombre, ' ', p.apellido) AS nombreCompleto, c.idCurso\n\t\t\t\tFROM tb_cursos_preceptores AS c\n\t\t\t\tINNER JOIN tb_personas AS p ON c.dniPreceptor=p.dni\n\t\t\t\tWHERE c.idCurso LIKE '" . $curso . "%' ";
$cursos = $link->query($sql);
while ($row = $cursos->fetch(PDO::FETCH_ASSOC)) {
echo '
<div class="tab-pane fade" id="div' . $row['idCurso'] . '">
<div class="col-sm-12 note">
<div class="col-sm-12">
<br>
<div class="table-responsive">
<p><h4>Preceptor: ' . $row["nombreCompleto"] . '</h4></p>
<form method="get" action="" id="form' . $row['idCurso'] . '" onsubmit="target_popup(this)">
<table class="table table-hover">
<thead>
<tr>
<th class="text-center"></th>
<th class="text-center">Alumnos</th>
<th class="text-center">Inas. totales</th>
<th class="text-center">Promedio general</th>
</tr>
</thead>
<tbody>';
impAlumnos($link, $row['idCurso']);
echo '
</tbody>
</table>
</form>
</div>
</div>
</div>
</div>';
}
}
function impCursos($link)
{
if (isset($_SESSION['materiaActual'])) {
$sqlCur = "SELECT idCurso FROM tb_cursos_materias WHERE idMateria='" . $_SESSION['materiaActual'] . "' ";
$resultCur = $link->query($sqlCur);
while ($row = $resultCur->fetch(PDO::FETCH_ASSOC)) {
echo " <div class='tab-pane fade' id='div" . $row['idCurso'] . "'>\n\t\t\t \t\t\t\t<div class='col-sm-12 note'>\n\t\t\t\t\t\t\t\t<div class='col-sm-12'>\n\t\t\t\t\t\t\t\t<br>\n\t\t\t\t\t\t\t\t\t<div class='table-responsive'>\n\t\t\t\t\t\t\t\t\t\t<table class='table table-bordered table-hover text-center'>\n\t\t\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<th rowspan ='2'>Alumno</th>\n\t\t\t\t\t\t\t\t\t\t\t\t<th colspan ='6'>Trimestre 1</th>\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>N1</th>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>N2</th>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>N3</th>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>N4</th>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>N5</th>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>Prom</th>\n\t\t\t\t\t\t\t\t\t\t\t</tr>";
impAlumnos($link, $row['idCurso']);
echo "\t\t\t\t</table>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>";
}
}
}
function impCursos($link, $cursos)
{
//echo ("holasdsad");
$sql = "SELECT idCurso FROM tb_cursos_preceptores WHERE dniPreceptor='" . $_SESSION['usuario'] . "'";
$cursos = $link->query($sql);
$i = 1;
while ($row = $cursos->fetch(PDO::FETCH_ASSOC)) {
$query = "SELECT descripcion FROM TB_Cursos WHERE idCurso='" . $row['idCurso'] . "' ";
$resDesc = $link->query($query);
$resDesc = $resDesc->fetch(PDO::FETCH_ASSOC);
echo "\n\t\t\t\t\t<div id='div" . $i . "' class='table-responsive text-center' style='display:none'>\n\t\t\t\t\t\t<h4>" . $resDesc['descripcion'] . "</h4>\n\t\t\t\t\t\t<form method='get' action='' id='form" . $i . "' onsubmit='target_popup(this)'>\n\t\t\t\t\t\t\t<table id='' class='table table-hover table-condensed'>\n\t\t\t\t\t\t\t\t<thead>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t<th>#</th>\n\t\t\t\t\t\t\t\t\t\t<th>Alumnos</th>\n\t\t\t\t\t\t\t\t\t\t<th>Inasistencias</th>\n\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t</thead>\n\t\t\t\t\t\t\t\t<tbody>\n\t\t\t\t\t\t\t\t";
impAlumnos($link, $row['idCurso']);
echo "\t\n\t\t\t\t\t\t\t\t</tbody>\n\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t</form>\n\t\t\t\t\t</div>";
$i++;
}
}
</button> <a class="navbar-brand"> <span class="glyphicon glyphicon-user"></span> <label> <?php echo "" . $_SESSION['nombre'] . " " . $_SESSION['apellido'] . ""; ?> </label> </a> </div> <div class="collapse navbar-collapse" id="barra"> <div> <ul class="nav navbar-nav"> <li class="dropdown active"><a class="dropdown-toggle" data-toggle="dropdown" href="#">Ver<span class="caret"></span></a> <ul class="dropdown-menu"> <?php impAlumnos($link); ?> </ul> </li> </ul> </div> <div> <ul class="nav navbar-nav navbar-right"> <li><a data-toggle="modal" data-target="#contacto"><span class="glyphicon glyphicon-envelope"></span> Realizar consulta</a></li> <li><a href='cerrarSesion.php'><span class="glyphicon glyphicon-log-out"></span> Salir</a></li> </ul> </div> </div> </div> </nav>
