$parameter = " AND excel.speciality_id=" . $_GET['special'] . "";
}
if ($_GET['lang']) {
$parameter = $parameter . " AND excel.lang='" . $_GET['lang'] . "'";
}
if ($_GET['course']) {
$parameter = $parameter . " AND excel.semester='" . $_GET['course'] . "'";
}
if ($_GET['year']) {
$parameter = $parameter . " AND excel.type_atemp='" . $_GET['year'] . "'";
}
$excel = $test->select_excel($_GET['faculty'], $parameter);
for ($j = 1; $j < count($excel); $j++) {
$parameter_excel = $parameter_excel . " or `excel_id`='" . $excel[$j]['id'] . "'";
}
$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']);
$predmet = $test->select_module("SELECT DISTINCT name_discipline,name_module,sort FROM module WHERE id_excel=" . $excel[$i]['id'] . ";");
echo "<table width='100%'><tr><td width='4%'><input type='checkbox' name='" . $excel[$i]['id'] . "' value='" . $excel[$i]['id'] . "'></td><td width='30%' style='font-size:8pt;'>";
echo "Факультет: " . $department['DEPARTMENT'] . "<br>";
echo "Спеціальність: " . $speciality['SPECIALITY'] . "<br>";
echo "Мова: " . $excel[$i]['lang'] . "<br>";
echo "Семестер: " . $excel[$i]['semester'] . "<br>";
echo "Тип здачі: " . $type_session[0]['type'] . "<br>";
if ($excel[$i]['potik'] == '0') {
$potik = "Без потоку";
} else {
$potik = $excel[$i]['potik'];
}
echo "Потік: " . $potik . "<br>";
echo "Частина: " . $excel[$i]['chastuna'] . "<br>";
echo "</td><td width='30%' style='font-size:8pt;'>";
$ocinku = $test->select_table_ocinka("SELECT DISTINCT student_id FROM table_ocinka WHERE excel_id='" . $excel[$i]['id'] . "';");
echo "Кількість студентів: " . count($ocinku) . "<br>";
$kontr_butjet = $fac->butjetorkontrakt($ocinku);
echo "Кількість контрактних студентів: " . $kontr_butjet[0] . "<br>";
echo "Кількість бютжетних студентів: " . $kontr_butjet[1] . "<br>";
$ocinku_stud_null = $test->select_table_ocinka("SELECT DISTINCT student_id FROM `table_ocinka`WHERE `excel_id` ='" . $excel[$i]['id'] . "' AND `examen` =0");
echo "Кількість двієшників: " . count($ocinku_stud_null) . "<br>";
echo "Кількість предметів: " . count($predmet) . "<br>";
echo "</td><td width='30%' style='font-size:8pt;'>";
for ($j = 0; $j < count($predmet); $j++) {
echo $predmet[$j]['sort'] . ": " . $predmet[$j]['name_discipline'] . " <div style='padding-left:18px;'> " . $predmet[$j]['name_module'] . "</div>";
}
echo "</td></tr></table>";
echo "</td></tr>";
}
echo "</table>";
<?php
require "auth.php";
echo "<script type='text/javascript' src='datepicker/jquery.tcollapse.js'></script>";
if ($_SESSION['login_name'] && $_SESSION['role'] == "student") {
require "header.php";
require "menu_stud.php";
require "class/class_firebird.php";
require "class/mysql-class.php";
$fac = new class_ibase();
$test = new class_mysql_base();
echo "<CENTER><h3>Архів ваших здач</h3></CENTER>";
$get_ocinku_excel = $test->select_table_ocinka("SELECT DISTINCT excel_id FROM `table_ocinka`WHERE `student_id` ='" . $_SESSION['studentid'] . "';");
echo "<table width='100%' bgcolor='gray' font-color='white' id='table0'>";
for ($i = 0; $i < count($get_ocinku_excel); $i++) {
$excel = $test->select_excel2("SELECT * FROM excel WHERE id='" . $get_ocinku_excel[$i]['excel_id'] . "';");
$type_session = $test->select_type_session("id=" . $excel[0]['type_sesion']);
echo "<tr><td><b>Тип здачі " . $type_session[0]['type'] . "</td><td><b>Семестер " . $excel[0]['semester'] . "</td><td><b> Частина " . $excel[0]['chastuna'] . "</td><td><b> Дата " . $excel[0]['date'] . "</td></tr>";
$predmet = $test->select_module("SELECT * FROM module WHERE id_excel=" . $excel[0]['id'] . ";");
echo "<tbody><tr><td colspan='4'>\n <table width='100%' bgcolor='white'><tr><td>";
for ($j = 0; $j < count($predmet); $j++) {
$ocinku = $test->select_table_ocinka("SELECT DISTINCT potochna,examen,ostatochna FROM table_ocinka WHERE student_id='" . $_SESSION['studentid'] . "' AND excel_id='" . $excel[0]['id'] . "' AND discipline_id='" . $predmet[$j]['id_discipline'] . "' AND module_id='" . $predmet[$j]['id_module'] . "' AND sort='" . $predmet[$j]['sort'] . "';");
if ($ocinku[0]['examen'] || $ocinku[0]['examen'] == '0') {
if ($ocinku[0]['examen'] == '0') {
echo "<div style='border-bottom: solid 1px gray;background-color:#feddbf;'>" . $ocinku[0]['sort'] . ": " . $predmet[$j]['name_discipline'] . " <div style='padding-left:18px;'> " . $predmet[$j]['name_module'] . " <b style='float:right;'>Поточна : " . $ocinku[0]['potochna'] . " Екзамен : " . $ocinku[0]['examen'] . " Підсумкова : " . $ocinku[0]['ostatochna'] . " </b></div></div>";
} else {
echo "<div style='border-bottom: solid 1px gray;background-color:#bffec4;'>" . $ocinku[0]['sort'] . ": " . $predmet[$j]['name_discipline'] . " <div style='padding-left:18px;'> " . $predmet[$j]['name_module'] . " <b style='float:right;'>Поточна : " . $ocinku[0]['potochna'] . " Екзамен : " . $ocinku[0]['examen'] . " Підсумкова : " . $ocinku[0]['ostatochna'] . " </b></div></div>";
}
}
}
echo "</td></tr></table></td></tr></tbody>";
