<?
require_once "class_firebird.php";
$base = new class_ibase();
$base->sql_connect();
$sql="SELECT PHOTO FROM STUDENTS WHERE STUDENTID='".$_GET['id_photo']."'";
$base->sql_query=$sql;
$base->sql_execute();
if ($row = ibase_fetch_row($base->sql_result))
{
header("Content-Type: image/jpeg");
ibase_blob_echo($row[0]);
}
?>
<script type="text/javascript" src="http://www.eyecon.ro/datepicker/js/jquery.js"></script>
<link href="styles/datepicker.css" rel="stylesheet">
<script src="script/bootstrap-datepicker.js"></script>
<?php
include "auth.php";
if ($_SESSION['name_sesion_a'] == "admin") {
include "menu.php";
include "navigate.php";
include "class/function.php";
include "class/pclzip.lib.php";
include "class/potochna.php";
require_once "class/class_firebird.php";
require_once "class/mysql_class_local.php";
include_once "class/class reader.php";
$contingent = new class_ibase();
$local = new class_mysql_base_local();
echo "<div class='well'><center><h2>Створення відомостей</h2><form action='vidomist_old.php?" . $_SERVER['QUERY_STRING'] . "' method='post' enctype='multipart/form-data'>\n Виберіть файл <input type='file' name='filename' value='Огляд'> <input type='submit' value='Завантажити дані'></div></form>";
echo "<br></b><center>";
if (isset($_FILES["filename"]["tmp_name"])) {
if (is_uploaded_file($_FILES["filename"]["tmp_name"])) {
$table = array();
$name_table = array('Оцінки', 'Звязок', 'Предмети', 'Поточна успішність', 'Таблиця точності');
$table_id = array('1', '2', '3', '4', '5');
$temp_file = date("d-m-i-s");
move_uploaded_file($_FILES["filename"]["tmp_name"], "xls/" . $temp_file . $_FILES["filename"]["name"]);
$data = new XLSToDB($temp_file . $_FILES["filename"]["name"], 'UTF-8');
$fileXLS = $temp_file . $_FILES["filename"]["name"];
$links = "xls/" . $temp_file . $_FILES["filename"]["name"];
//-----формування масивів листів
$table[0] = $ocinku_styd = $data->get($fileXLS, 0, 10);
$table[1] = $zvjaz_styd = $data->get($fileXLS, 1, 3);
<script type="text/javascript" src="datepicker/jquery.js"></script>
<?php
require "auth.php";
if ($_SESSION['login_name'] && $_SESSION['role'] == "admin") {
require "header.php";
require "menu.php";
require "class/class_firebird.php";
require "class/mysql-class.php";
$fac = new class_ibase();
$test = new class_mysql_base();
//$department_kil = $test->select_excel_faculty();
/*$department = $fac->select_faculty();
$special = $fac->select_speciality();*/
echo "<br> \n <h3><center>Вибір груп здачі для проведення статистики </h3>\n <form action='stat.php' method='post' enctype='multipart/form-data'>\n <center>";
include "navigate/navigate.php";
//------------------------------------------------------------------------------------------------
//
//000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
//
//------------------------------------------------------------------------------------------------
if ($_GET['special'] && $_GET['faculty'] && $_GET['lang'] && $_GET['year']) {
if ($_GET['special']) {
$parameter = " AND speciality_id=" . $_GET['special'] . "";
}
if ($_GET['lang']) {
$parameter = $parameter . " AND lang='" . $_GET['lang'] . "'";
}
if ($_GET['course']) {
$parameter = $parameter . " AND semester='" . $_GET['course'] . "'";
}
if ($_GET['year']) {
<script type="text/javascript" src="http://www.eyecon.ro/datepicker/js/jquery.js"></script>
<link href="styles/datepicker.css" rel="stylesheet">
<script src="script/bootstrap-datepicker.js"></script>
<?php
include "class/function.php";
include "auth.php";
if ($_SESSION['name_sesion_a'] == "admin") {
include "menu.php";
include "navigate.php";
require_once "class/class_firebird.php";
$contingent = new class_ibase();
echo "<div class='well'><center><h2>Відомості</h2>";
echo "<form action='vidomist.php?" . $_SERVER['QUERY_STRING'] . "' method='post' enctype='multipart/form-data'>\n";
echo "Введіть Ім'я студента для пошуку в базі <input type='text' name='name_styd' value='" . $_POST['name_styd'] . "'>";
echo "<input type='submit' name='put' value='Пошук'></div>";
if ($_POST['name_styd'] != '') {
$student = $contingent->select("SELECT STUDENTS.STUDENTID, STUDENTS.FIO,GUIDE_SPECIALITY.SPECIALITY,GUIDE_DEPARTMENT.DEPARTMENT,STUDENTS.SEMESTER, STUDENTS.GROUPNUM, STUDENTS.PHOTO FROM STUDENTS,GUIDE_SPECIALITY,GUIDE_DEPARTMENT WHERE STUDENTS.FIO LIKE '%" . $_POST['name_styd'] . "%' AND STUDENTS.STATUS='С' AND GUIDE_SPECIALITY.SPECIALITYID=STUDENTS.SPECIALITYID AND GUIDE_DEPARTMENT.DEPARTMENTID=STUDENTS.DEPARTMENTID;");
echo "<br>Виберіть студента<br><table bgcolor='white' width='100%' border='1'><tr bgcolor='gray'><td></td><td>ФІО</td><td>Спеціальність</td><td>Факультет</td><td>Семестер</td><td>Група</td></tr>";
for ($i = 0; $i < count($student); $i++) {
echo "<tr name='" . $student[$i][0] . "' class='id_vid_tr'>";
echo "<td><input type='radio' name='id' class='id_vid' value='" . $student[$i][0] . "'></td><td>" . $student[$i][1] . "</td><td>" . $student[$i][2] . "</td><td>" . $student[$i][3] . "</td><td>" . $student[$i][4] . "</td><td>" . $student[$i][5] . "</td>";
echo "</tr>";
}
echo "</table>";
}
if ($_GET['student'] != '') {
if (!file_exists("arhiv/students/" . $_GET['student'])) {
mkdir("arhiv/students/" . $_GET['student']);
}
echo "<script>var id_styd=" . $_GET['student'] . "</script>";
$student = $contingent->select("SELECT STUDENTS.STUDENTID, STUDENTS.FIO,GUIDE_SPECIALITY.SPECIALITY,GUIDE_DEPARTMENT.DEPARTMENT,STUDENTS.SEMESTER, STUDENTS.GROUPNUM,STUDENTS.RECORDBOOKNUM FROM STUDENTS,GUIDE_SPECIALITY,GUIDE_DEPARTMENT WHERE STUDENTS.STUDENTID='" . $_GET['student'] . "' AND GUIDE_SPECIALITY.SPECIALITYID=STUDENTS.SPECIALITYID AND GUIDE_DEPARTMENT.DEPARTMENTID=STUDENTS.DEPARTMENTID;");
<script type="text/javascript" src="../testcenter/datepicker/jquery.js"></script>
<?php
include "menu.php";
include "navigate.php";
require_once "class/class_firebird.php";
$contingent = new class_ibase();
$sql = $_GET['sort'] . " " . $_GET['s'] . " " . $_GET['type'];
echo "<table><tr><td width=50%><form action='sql.php' method='GET' enctype='multipart/form-data'>";
echo "<TEXTAREA NAME=sort id='text' ROWS=10 COLS=100>" . $sql . "</TEXTAREA>";
echo "<br><input type='submit' name='put' value='ќбробити'>";
echo "</form></td><td valign=top>";
echo "\n<input type='submit' id='select' value='SELECT'><br><br>\n<input type='submit' id='clear' value='ќчистити'>\n</td></tr><tr><td colspan=2>";
if ($_GET['put'] || $_GET['sort']) {
if ($_SESSION['name_sesion_a'] == "admin") {
$zag_mas = $contingent->select_sql($sql);
} else {
header("Location: index.php");
}
echo "<table bgcolor='white' border=1>";
for ($i = 0; $i < count($zag_mas); $i++) {
echo "<tr>";
for ($j = 0; $j < count($zag_mas[0]); $j++) {
if ($i == 0 && $_GET['type'] == 'DESC') {
echo "<td><center><a href='sql.php?sort=" . $_GET['sort'] . "&s=order by " . $zag_mas[$i][$j] . " &type=ASC'>" . $zag_mas[$i][$j] . "</a></td>";
} else {
if ($i == 0 && $_GET['type'] == 'ASC') {
echo "<td><center><a href='sql.php?sort=" . $_GET['sort'] . "&s=order by " . $zag_mas[$i][$j] . " &type=DESC'>" . $zag_mas[$i][$j] . "</a></td>";
} else {
if ($i == 0) {
echo "<td><center><a href='sql.php?sort=" . $_GET['sort'] . " &s=order by " . $zag_mas[$i][$j] . "&type=DESC'>" . $zag_mas[$i][$j] . "</a></td>";
} else {
<?php
require "auth.php";
echo "<script type='text/javascript' src='datepicker/jquery.tcollapse.js'></script>";
if ($_SESSION['login_name'] && $_SESSION['role'] == "admin") {
require "header.php";
require "menu.php";
require "class/class_firebird.php";
require "class/mysql-class.php";
$fac = new class_ibase();
$test = new class_mysql_base();
echo "<br><CENTER><h3>Архів здач студентів</h3></CENTER>";
echo "<form action='students.php' method='post' enctype='multipart/form-data'>";
include "navigate/navigate.php";
if ($_GET['special'] && $_GET['faculty'] && $_GET['lang'] && $_GET['course'] && $_GET['year']) {
if ($_GET['special']) {
$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'] . "'";
<link rel='stylesheet' href='datepicker/datepicker.css' type='text/css' />
<?php
require "auth.php";
echo "\n<script type='text/javascript' src='datepicker/jquery.js'></script>\n<script type='text/javascript' src='datepicker/date.js'></script>\n<script type='text/javascript' src='datepicker/jquery.datePicker-2.1.2.js'></script>\n \n<script type='text/javascript'>\n\$(function()\n{\n\$('#inputDate4').datePicker({\ncreateButton:false,\nclickInput:true,\nendDate: (new Date()).addDays(365).asString()\n});\n});\n</script>";
if ($_SESSION['login_name'] && $_SESSION['role'] == "admin") {
require "header.php";
require "menu.php";
require "class/potochna.php";
require "class/mysql-class.php";
require "class/class_firebird.php";
$test = new class_mysql_base();
$ibase = new class_ibase();
$type_session = $test->select_type_session("1");
$year = $test->select_year("SELECT DISTINCT date,name,id FROM yearplan WHERE 1 ORDER BY id DESC;");
echo " <br><center><h3>Завантажити файл з EXCEL </h3><br></center>\n <form action='up_stat.php' method='post' enctype='multipart/form-data'>\n \t\n \n <div class='kvadrant'><br>\n\tКороткий опис\n\t<input name='title' value='' />\n\t<br><br>\n\t</div> \n\n <div class='kvadrant'><br>\n\tТип здачі \n\t<select name='year'>\n ";
for ($i = 0; $i < count($year); $i++) {
echo "<option value='" . $year[$i]['id'] . "'>" . $year[$i]['date'] . "/" . $year[$i]['name'] . "</option>";
}
echo "\n\t</select>\n\t<br><br>\n\t</div>\n\n <div class='kvadrant'><br>\n\tМова здачі \n\t<select name='lang'>\n <option value='UA'>Українська</option>\n <option value='ENG'>Іноземна</option>\n\t</select>\n\t<br><br>\n\t</div>\n \n <div class='kvadrant'><br> \n\tДата здачі\n\t<input id='inputDate4' name='date' value='" . Date("Y-m-d") . "' />\n\t<br><br>\n\t</div>\n \n\t<div class='kvadrant'><br>\n\tТип здачі \n\t<select name='zdacha'>\n ";
for ($i = 0; $i < count($type_session); $i++) {
echo "<option value='" . $type_session[$i]['id'] . "'>" . $type_session[$i]['type'] . "</option>";
}
echo "\n\t</select>\n\t<br><br>\n\t</div>\n\t\n\t<div class='kvadrant'><br>\n\tПотік \n\t<select name='potik'>\n\t\t<option value='0' name=''>Без потоку</option>\n\t\t<option value='1' name=''>І потік</option>\n\t\t<option value='2' name=''>ІІ потік</option>\n\t</select>\n\t<br><br>\n\t</div>\n\t\n\t<div class='kvadrant'><br>\n\tЧастина\n\t<select name='chastuna'>\n\t\t<option value='1' name=''>І частина</option>\n\t\t<option value='2' name=''>ІІ частина</option>\n\t</select>\n\t<br><br>\n\t</div>\n\t<div class='kvadrant'><br>\n\tВиберіть файл \n <input type='file' name='filename' value='Огляд'>\n <br><br></div><br><br>\n <input type='submit' value='Експортувати дані'><br></form>";
if (isset($_FILES["filename"]["tmp_name"])) {
if (is_uploaded_file($_FILES["filename"]["tmp_name"])) {
$temp_file = date("d-m-i-s");
move_uploaded_file($_FILES["filename"]["tmp_name"], "sheets/" . $temp_file . $_FILES["filename"]["name"]);
include_once "Class/class reader.php";
$data = new XLSToDB($temp_file . $_FILES["filename"]["name"], 'CP1251');
$fileXLS = $temp_file . $_FILES["filename"]["name"];
<script type="text/javascript" src="datepicker/jquery.js"></script>
<?php
require "auth.php";
if ($_SESSION['login_name'] && $_SESSION['role'] == "admin") {
require "header.php";
require "menu.php";
require "class/class_firebird.php";
require "class/mysql-class.php";
$fac = new class_ibase();
$test = new class_mysql_base();
if ($_POST['zdacha']) {
$test->update_excel("UPDATE excel SET type_atemp = '" . $_POST['year'] . "',date = '" . $_POST['date'] . "',lang = '" . $_POST['lang'] . "'\n ,chastuna = '" . $_POST['chastuna'] . "',potik = '" . $_POST['potik'] . "',type_sesion = '" . $_POST['zdacha'] . "' WHERE id = '" . $_GET['id'] . "'");
}
//$department_kil = $test->select_excel_faculty();
/*$department = $fac->select_faculty();
$special = $fac->select_speciality();*/
echo "<br> \n <h3><center>Редагування бази Excel </h3>";
if ($_GET['id_excel']) {
$log = $test->select_log("SELECT * FROM log_excel WHERE id_export_table='" . $_GET['id_excel'] . "'");
unlink($log[0]['file_path']);
$test->delete_log_excel($_GET['id_excel']);
}
include "navigate/navigate.php";
if ($_GET['faculty'] != '' && $_GET['year'] != '') {
if ($_GET['special']) {
$parameter = " AND speciality_id=" . $_GET['special'] . "";
}
if ($_GET['lang']) {
$parameter = $parameter . " AND lang='" . $_GET['lang'] . "'";
}
if ($_GET['course']) {
<script type="text/javascript" src="../testcenter/datepicker/jquery.js"></script>
<style>
#active_d:hover {}
</style>
<?php
include "class/function.php";
include "auth.php";
if ($_SESSION['name_sesion_a'] == "admin") {
include "menu.php";
include "navigate.php";
require_once "class/class_firebird.php";
require_once "class/mysql_class_local.php";
require_once "class/mysql_class_moodle2.php";
echo "<center><h2>Звязок дисциплін контингенту та мудлу по кафедрам</h2></center><b>";
$contingent = new class_ibase();
$base_local = new class_mysql_base_local();
$base_moodle = new class_mysql_base_moodle();
$zagalne = $base_moodle->select("SELECT id,name FROM mdl_course_categories WHERE id NOT IN (65,66,67,68,38,45,58);");
//------------Відрізати після "(" у назвах кафедр -----------------------------
for ($i = 0; $i < count($zagalne); $i++) {
$parts = explode("(", strip_tags($zagalne[$i][1]));
$zagalne[$i][1] = $parts[0];
}
navigate('Виберіть кафедру', $zagalne, 'kaf');
//------------Якщо вибрана кафедра получити звязки дисциплін ----------------------------
if ($_GET['kaf']) {
echo "<br><img id='active_d' act='Y' src='http://market.auto.ria.ua/img/plus.gif'>Показати прикріплені дисципліни до кафедри та мудла";
if ($_GET['del']) {
$dis = $base_local->ins("DELETE FROM `dis_for_kaf`.`discipline` WHERE id=" . (int) $_GET['del'] . ";");
}
if ($_POST['ins_old']) {
<link href="styles/datepicker.css" rel="stylesheet">
<?php
session_start();
include "auth.php";
if ($_SESSION['name_sesion_a'] == "admin") {
include "menu.php";
include "navigate.php";
require_once "class/class_firebird.php";
$contingent = new class_ibase();
echo "<div class='well'><center><h2>Робота з XML</h2><font color=green><b>Файл для загрузки береться з контингенту список навчального плану </b></font><form action='XML_dis.php?" . $_SERVER['QUERY_STRING'] . "' method='post' enctype='multipart/form-data'>\n Виберіть файл <input type='file' name='filename' value='Огляд'> <input type='submit' value='Завантажити дані'></div></form>";
echo "<br></b><center>";
if (isset($_FILES["filename"]["tmp_name"])) {
if (is_uploaded_file($_FILES["filename"]["tmp_name"])) {
$xml = simplexml_load_file($_FILES["filename"]["tmp_name"]);
$year = $xml->params->eduyear;
$sem = $xml->params->semester;
$dep = $xml->params->departmentid;
$student = $xml->params->studentid;
$x = array(array());
$i = 0;
foreach ($xml->disciplines as $key0 => $value) {
foreach ($value->discipline as $key1 => $value2) {
$j = 0;
foreach ($value2->modules->module as $key2 => $value3) {
$x[$i][$j + 4] = json_decode(json_encode($value2->variantid), 1);
//----
$x[$i][$j + 3] = json_decode(json_encode($value2->disciplineid), 1);
$x[$i][$j] = json_decode(json_encode($value2->dmtitle), 1);
$x[$i][$j + 5] = json_decode(json_encode($value3->variantid), 1);
//----
$x[$i][$j + 2] = json_decode(json_encode($value3->modulenum), 1);
<?
require_once "class/class_firebird.php";
require_once "class/function.php";
$contingent = new class_ibase();
$student = $contingent->select("SELECT STUDENTS.STUDENTID, STUDENTS.FIO,GUIDE_SPECIALITY.SPECIALITY,GUIDE_DEPARTMENT.DEPARTMENT,STUDENTS.SEMESTER, STUDENTS.GROUPNUM,STUDENTS.RECORDBOOKNUM FROM STUDENTS,GUIDE_SPECIALITY,GUIDE_DEPARTMENT WHERE STUDENTS.STUDENTID='".$_GET['student']."' AND GUIDE_SPECIALITY.SPECIALITYID=STUDENTS.SPECIALITYID AND GUIDE_DEPARTMENT.DEPARTMENTID=STUDENTS.DEPARTMENTID;");
$plan = $contingent->select("select bvm.modulenum,gd.discipline,bvm.moduletheme,S2T.TESTLISTID,S2T.CREDITS_CUR from STUDENT2TESTLIST S2T
inner join B_TESTLIST BT on (BT.TESTLISTID = S2T.TESTLISTID) inner join B_VARIANT_ITEMS BVI_M on (BVI_M.VARIANTID = BT.VARIANTID) inner join b_variant_module bvm
on (BVI_M.VARIANTID = bvm.VARIANTID) inner join B_VARIANT_ITEMS BVI_V on (BVI_V.VARIANTID = BVI_M.PARENTVARIANTID) inner join guide_discipline gd
on (BVI_V.disciplineid = gd.disciplineid) where BT.TESTLISTID=".$_GET['modul']." AND S2T.STUDENTID=".$_GET['student']."");
if ($_GET['ocinka']==0){$ex='0(не склав)';$ost='(не склав)';}else{$ex=$_GET['ocinka'];$ost=potochna($plan[0][4])*0.6+$ex*0.4;}
$stream="<html>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>
<style>
body {font-size:14px;}
</style>
</head>
<body>
<p align=center>МІНІСТЕРСТВО ОХОРОНИ ЗДОРОВЯ УКРАЇНИ </p>
<p align=center><b><u>Тернопільський державний медичний університет імені І.Я. Горбачевського</u></b></p>
<span align=left> Факультет <u>".$student[0][3]."</u></span><br>
<span align=left> Спеціальність <u>".$student[0][2]."</u></span>
<span align=right> Група_<u>".$student[0][5]."</u>___</span>
2012/2013 навчальний рік
Курс _<u>".course($student[0][4])."</u>___<br />
<p align=center>ЕКЗАМЕНАЦІЙНА ВІДОМІСТЬ №____ </p>
<p>З <u>".$plan[0][0].".".$plan[0][2]."</u> - <u>".$plan[0][1]."</u></p>
<script type="text/javascript" src="../testcenter/datepicker/jquery.js"></script>
<?php
include "class/function.php";
include "auth.php";
if ($_SESSION['name_sesion_a'] == "admin") {
include "menu.php";
include "navigate.php";
require_once "class/class_firebird.php";
require_once "class/mysql_class_local.php";
require_once "class/mysql_class_moodle2.php";
$contingent = new class_ibase();
$base_local = new class_mysql_base_local();
$base_moodle = new class_mysql_base_moodle();
$department = $contingent->select("select DISTINCT GUIDE_DEPARTMENT.DEPARTMENTID,GUIDE_DEPARTMENT.DEPARTMENT from B_TESTLIST, GUIDE_DEPARTMENT WHERE B_TESTLIST.DEPARTMENTID=GUIDE_DEPARTMENT.DEPARTMENTID ORDER by GUIDE_DEPARTMENT.DEPARTMENTID DESC;");
echo "<center><h2>Збір статистики з бази Контингент\n<table width=100%><tr><td width=70% valign=top>";
navigate('Факультет', $department, 'DEPARTMENT');
if ($_GET['DEPARTMENT']) {
$speciality = $contingent->select("select DISTINCT BVI_V.SPECIALITYID,GS.CODE|| '-' ||GS.SPECIALITY from B_TESTLIST BT inner join B_VARIANT_ITEMS BVI_M on (BVI_M.VARIANTID = BT.VARIANTID) inner join B_VARIANT_ITEMS BVI_V on (BVI_V.VARIANTID = BVI_M.PARENTVARIANTID) inner join GUIDE_SPECIALITY GS on (BVI_V.SPECIALITYID = GS.SPECIALITYID) where BT.DEPARTMENTID = " . $_GET['DEPARTMENT'] . "");
navigate('Спеціальність', $speciality, 'SPECIALITY');
}
if ($_GET['SPECIALITY']) {
$discipline = $contingent->select("select DISTINCT gd.disciplineid,gd.discipline from B_TESTLIST BT inner join B_VARIANT_ITEMS BVI_M on (BVI_M.VARIANTID = BT.VARIANTID) inner join B_VARIANT_ITEMS BVI_V on (BVI_V.VARIANTID = BVI_M.PARENTVARIANTID) inner join GUIDE_SPECIALITY GS on (BVI_V.SPECIALITYID = GS.SPECIALITYID) inner join guide_discipline gd on (BVI_V.disciplineid = gd.disciplineid) where BT.DEPARTMENTID = " . $_GET['DEPARTMENT'] . " AND BVI_V.SPECIALITYID = " . $_GET['SPECIALITY'] . " order by gd.discipline");
navigate('Дисципліна', $discipline, 'DISCIPLINE');
}
if ($_GET['DISCIPLINE']) {
$_POST['ekzam0'] = 'on';
$ekzam = array(array('Більше 0'));
$year = $contingent->select("select DISTINCT GE.EDUYEARSTR,GE.EDUYEAR from B_TESTLIST BT inner join B_VARIANT_ITEMS BVI_M on (BVI_M.VARIANTID = BT.VARIANTID) inner join B_VARIANT_ITEMS BVI_V on (BVI_V.VARIANTID = BVI_M.PARENTVARIANTID) inner join GUIDE_EDUYEAR GE on (BT.EDUYEAR = GE.EDUYEAR) where BVI_V.DISCIPLINEID = " . $_GET['DISCIPLINE'] . " and BVI_V.SPECIALITYID = " . $_GET['SPECIALITY'] . " and BT.DEPARTMENTID = " . $_GET['DEPARTMENT'] . "");
$sem = $contingent->select("select DISTINCT BT.SEMESTER from B_TESTLIST BT inner join B_VARIANT_ITEMS BVI_M on (BVI_M.VARIANTID = BT.VARIANTID) inner join B_VARIANT_ITEMS BVI_V on (BVI_V.VARIANTID = BVI_M.PARENTVARIANTID) where BVI_V.DISCIPLINEID = " . $_GET['DISCIPLINE'] . " and BVI_V.SPECIALITYID = " . $_GET['SPECIALITY'] . " and BT.DEPARTMENTID = " . $_GET['DEPARTMENT'] . "");
echo "</td><td bgcolor=gray valign=top><center> Фільтр";
