<? 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> Фільтр";