<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']) {
<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="../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> Фільтр";
