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>"; }