function myStudentsEval($nivel)
{
include 'includes/db_connect.php';
$idMaestro = teacherSet();
$query = "SELECT * FROM student S, academic_info A, classes C, naatik_course N, groups_nc G, teacher T WHERE \n\t\t\t\t\t\t\t\t\tS.status = 'activo' AND\n\t\t\t\t\t\t\t\t\tS.id_student = A.id_student AND\n\t\t\t\t\t\t\t\t\tA.id_classes = C.id_class AND\n\t\t\t\t\t\t\t\t\tC.id_course = N.id_course AND\n\t\t\t\t\t\t\t\t\tN.id_course = '{$nivel}' AND\n\t\t\t\t\t\t\t\t\tC.id_group = G.id_group AND\n\t\t\t\t\t\t\t\t\tC.teacher = T.id_teacher AND\n\t\t\t\t\t\t\t\t\tT.id_teacher = '{$idMaestro}' ORDER BY S.surname1_s ASC;";
$made = mysqli_query($db_connect, $query) or die(mysqli_error());
$i = 1;
if ($made) {
while ($row = mysqli_fetch_array($made)) {
if ($row['id_course'] == 1) {
$link = "?menu_p=EvalClub&idst=" . $row['id_student'] . "";
} else {
$link = "?menu_p=EvalPAA&idst=" . $row['id_student'] . "";
}
$edad = calcular($row['birthday']);
echo "<tr>";
echo "<td>" . $i++ . "</td>";
echo "<th>" . "<img src='img/fotos/student/" . $row['photo_s'] . "' class='img-circle' width=50px height=50px>" . "</th>";
echo "<td>" . $row['surname1_s'] . " " . $row['surname2_s'] . " " . $row['name_s'] . "</td>";
echo "<td>" . $row['course'] . "</td>";
echo "<td>" . $row['group'] . "</td>";
echo "<td><a href='" . $link . "' class='label label-primary' data-toggle='tooltip' data-placement='bottom' data-trigger='hover' title='Evaluar.'>Evaluar <span class='glyphicon glyphicon-edit'></span></a></td>";
echo "</tr>";
}
}
}
function myStudents($nivel)
{
include 'includes/db_connect.php';
$idMaestro = teacherSet();
$query = "SELECT * FROM student S, academic_info A, classes C, naatik_course N, groups_nc G, teacher T WHERE \n\t\t\t\t\t\t\t\t\tS.status = 'activo' AND\n\t\t\t\t\t\t\t\t\tS.id_student = A.id_student AND\n\t\t\t\t\t\t\t\t\tA.id_classes = C.id_class AND\n\t\t\t\t\t\t\t\t\tC.id_course = N.id_course AND\n\t\t\t\t\t\t\t\t\tN.id_course = '{$nivel}' AND\n\t\t\t\t\t\t\t\t\tC.id_group = G.id_group AND\n\t\t\t\t\t\t\t\t\tC.teacher = T.id_teacher AND\n\t\t\t\t\t\t\t\t\tT.id_teacher = '{$idMaestro}' ORDER BY S.surname1_s ASC;";
$made = mysqli_query($db_connect, $query) or die(mysqli_error());
$i = 1;
if ($made) {
while ($row = mysqli_fetch_array($made)) {
$edad = calcular($row['birthday']);
echo "<tr>";
echo "<td>" . $i++ . "</td>";
echo "<th>" . "<img src='img/fotos/student/" . $row['photo_s'] . "' class='img-circle' width=50px height=50px>" . "</th>";
echo "<td>" . $row['surname1_s'] . "</td>";
echo "<td>" . $row['surname2_s'] . "</td>";
echo "<td>" . $row['name_s'] . "</td>";
echo "<td>" . $edad . "</td>";
echo "<td>" . $row['course'] . "</td>";
echo "<td>" . $row['group'] . "</td>";
echo "<td data-toggle='tooltip' data-placement='bottom' data-trigger='hover' title='Más...'><a href='#' data-toggle='modal' data-target='.bs-example-modal-alumno' class='btn btn-primary btn-fab btn-raised mdi-action-launch'></a></td>";
echo "</tr>";
}
}
}
<?php
include 'app/profiles/maestro/actions/issetTeacher.php';
$idMaestro = teacherSet();
//-- <-------------------------- ******************************* ------------------------------->
#-- Consulta para obtener las clases, con sus respectivos maestros.
$query = "SELECT * FROM classes C, naatik_course N, groups_nc G, schedule S, teacher T \n WHERE C.id_course=N.id_course\n \tAND C.teacher = '{$idMaestro}' \n \tAND C.id_group = G.id_group\n AND C.id_schedule = S.id_schedule\n AND C.teacher = T.id_teacher ORDER BY id_class;";
$echo = mysqli_query($db_connect, $query) or die(mysqli_error());
$numero = 1;
$nameTe = "";
if ($echo) {
while ($fila = mysqli_fetch_array($echo)) {
if ($numero % 2 != 0) {
$str = 'warning';
} else {
$str = 'active';
}
$nameTe = $fila['name_te'] . " " . $fila['surname_te'];
echo "<tr class='" . $str . "'>";
echo "<th>" . $numero++ . "</th>";
echo "<td>" . $fila['course'] . "</td>";
echo "<td>" . $fila['group'] . "</td>";
echo "<td>" . $fila['date_init'] . "</td>";
echo "<td>" . $fila['days'] . "</td>";
echo "<td>" . $fila['hour_init'] . " - " . $fila['hour_end'] . "</td>";
echo "<td>" . $nameTe . "</td>";
echo "</tr>";
}
} else {
echo "<h3 class='text text-center text-warning'>Upss!! error inesperado de conexión con la Base de Datos.</h3>\n <h6 class='text text-center text-warning'>Por favor reporte este Error a su administrador.</h6>";
}
