$groups = $test->select_table_ocinka("SELECT DISTINCT `group` FROM `table_ocinka` WHERE (`excel_id`='" . $excel[0]['id'] . "' " . $parameter_excel . ");");
echo "<tr><td> Виберіть групу </td><td style='float:right;'><select name='group' class='group'>\n <option value='' selected='selected'>------Пусто-----</option>\n ";
for ($i = 0; $i < count($groups); $i++) {
if ($_GET['group'] == $groups[$i]['group']) {
echo "<option value='" . $groups[$i]['group'] . "' selected='selected'>" . $groups[$i]['group'] . "</option>";
} else {
echo "<option value='" . $groups[$i]['group'] . "'>" . $groups[$i]['group'] . "</option>";
}
}
echo "\n\t</select> </td></tr>";
}
if ($_GET['special'] && $_GET['faculty'] && $_GET['lang'] && $_GET['course'] && $_GET['group']) {
$student = $test->select_table_ocinka("SELECT DISTINCT table_ocinka.student_id FROM table_ocinka,excel WHERE excel.semester='" . $_GET['course'] . "' AND table_ocinka.group='" . $_GET['group'] . "' AND excel.speciality_id=" . $_GET['special'] . " AND excel.id=table_ocinka.excel_id;");
echo "<table width='70%' id='t'>";
for ($i = 0; $i < count($student); $i++) {
$student_contingent = $fac->select_idstyd_tocontingent($student[$i]['student_id']);
echo "<tr><td style='border:solid 1px black;'><a style='float:right;color:black;display:block;width:100%;' href='students.php?student_id=" . $student[$i]['student_id'] . "&faculty=" . $_GET['faculty'] . "&year=" . $_GET['year'] . "&special=" . $_GET['special'] . "&lang=" . $_GET['lang'] . "&course=" . $_GET['course'] . "&group=" . $_GET['group'] . "'>" . $student_contingent['FIO'] . "</a></td></tr>";
}
echo "</table>";
}
if ($_GET['student_id']) {
$student_contingent = $fac->select_idstyd_tocontingent($_GET['student_id']);
echo "<br><b>Успішність студента<br><CENTER><h2>" . $student_contingent['FIO'] . "</h2></CENTER></b>";
$get_ocinku_excel = $test->select_table_ocinka("SELECT DISTINCT excel_id FROM `table_ocinka`WHERE `student_id` ='" . $_GET['student_id'] . "';");
echo "<table width='100%' bgcolor='#c5d9e5' font-color='white' id='table0' style='border: 1px solid blue;' >";
for ($i = 0; $i < count($get_ocinku_excel); $i++) {
$excel_stud = $test->select_excel2("SELECT * FROM excel WHERE id='" . $get_ocinku_excel[$i]['excel_id'] . "';");
$type_session = $test->select_type_session("id=" . $excel_stud[0]['type_sesion']);
echo "<tr><td><b>Тип здачі " . $type_session[0]['type'] . "</td><td><b>Семестер " . $excel_stud[0]['semester'] . "</td><td><b> Частина " . $excel_stud[0]['chastuna'] . "</td><td><b> Дата " . $excel_stud[0]['date'] . "</td></tr>";
$predmet = $test->select_module("SELECT * FROM module WHERE id_excel=" . $excel_stud[0]['id'] . ";");
echo "<tbody><tr><td colspan='4'>\n <table width='100%' bgcolor='white'><tr><td>";
$ocinku[$g][1] = $j - 1;
}
if ($ocinku_styd[$i][0] == 2) {
$ocinku[$g][1] = $j - 1 + $kilk - 2;
}
if ($ocinku_styd[$i][0] == 3) {
$ocinku[$g][1] = $j - 1 + $kilk * 2 - 4;
}
$ocinku[$g][2] = $ocinku_styd[$i][$j + 1];
$ocinku[$g][0] = $ocinku_styd[$i][2];
$g++;
}
}
}
//Звязок оцінок з розкодуванням
$student_contingent = $ibase->select_idstyd_tocontingent($zvjaz_styd[0][1]);
$last_id_excel = $test->insert_excel($student_contingent['SEMESTER'], $student_contingent['DEPARTMENTID'], $student_contingent['SPECIALITYID'], $_POST['zdacha'], $_POST['potik'], $_POST['chastuna'], $_POST['date'], $_POST['lang'], count($module_styd) - 1, $_POST['year']);
$test->insert_log_excel($_POST['title'], $_POST['date'], $links, 'MILKA', $last_id_excel);
for ($m = 0; $m < count($module_styd) - 1; $m++) {
if ($module_styd[$m][1] != null) {
$test->insert_module($last_id_excel, $module_styd[$m][3], $module_styd[$m][4], $module_styd[$m][2], $module_styd[$m][1], $module_styd[$m][0]);
}
}
echo "<table border='1' id='t'><tr><td>Прізвище</td><td>Дисципліни</td><td>За тест</td><td>Поточна</td><td>Остаточна</td></tr>";
for ($j = 0; $j < count($zvjaz_styd); $j++) {
$m = 0;
for ($i = 0; $i < count($ocinku); $i++) {
if ($zvjaz_styd[$j][2] == $ocinku[$i][0]) {
for ($x = 0; $x < count($potochna_styd); $x++) {
if ($zvjaz_styd[$j][1] == $potochna_styd[$x][1]) {
for ($o = 0; $o < count($ostatochna_styd); $o++) {
