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