<META http-equiv="Content-Type" Content="text/html; charset=windows-1251">
<script type="text/javascript" src="script/jquery.js"></script>
<script src="http://code.jquery.com/jquery-latest.js"></script>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script src="script/bootstrap-datepicker.js"></script>
<link rel="stylesheet" href="css/style.css" type="text/css">
<?php
include "class/function.php";
include "class/mysql-class.php";
$base = new class_mysql_base();
include "menu.php";
if ($_GET['variant']) {
$_POST['variant'] = $_GET['variant'];
$_POST['predmet'] = 1;
}
echo "<center><form action='variant.php' method='POST' enctype='multipart/form-data'>\n <table width=90% style='border: 1px solid blue;margin-top:20px;background-color:white;'><tr><td>\n </td><td><center><h2><p><b>Введіть варіант та предмет </b></p></h2></center>\n<b>Варіант <input type='text' name='variant' value='" . $_POST['variant'] . "'> <b>Предмет </b><input type='text' name='predmet' value='" . $_POST['predmet'] . "'>\n <input type='submit' value='Вибір'><br></table></form>";
if ($_POST['variant'] != '' && $_POST['predmet'] != '') {
$type_old_var[0] = $base->select("SELECT distinct(variant.variant),variant.sumstyd,type_validn.date,speciality.name,year.name,type_validn.type,variant.type FROM variant,type_validn,speciality,year WHERE variant='" . $_POST['variant'] . "' AND type_validn.id=variant.type AND type_validn.id_spec=speciality.id AND type_validn.id_year=year.id;");
$name_title_table[0] = array("Варіант", "Кількість студентів", "Дата", "Спеціальність", "Рік здачі", "Кількість питань", "--");
$name_table = array("Найдені групи варіантів (" . count($type_old_var[0]) . ")");
$table_id = array('1');
table($name_table, $type_old_var, $table_id, $name_title_table);
echo "<br>";
if ($_GET['type'] != '') {
$sql_variant = $_POST['variant'] . " AND type=" . $_GET['type'];
<?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'] . "'";
<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="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']) {
<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>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript" src="datepicker/graf.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();
$excel_kil = $test->select_excel2("SELECT id FROM excel WHERE 1;");
$kil = array();
for ($i = 0; $i < count($excel_kil); $i++) {
$kil[$i] = $excel_kil[$i]['id'];
}
$max = max($kil);
$exel = array();
$j = 0;
for ($i = 0; $i < 100; $i++) {
if ($_POST[$i] > 0) {
$exel[$j] = $_POST[$i];
$j++;
}
}
echo "<CENTER><h3>Виберіть тип статистики</h3></CENTER>";
//--------------------------------------------------------------------------------------------------------------------------------
// Загальна статистика
//--------------------------------------------------------------------------------------------------------------------------------
include "statistics/zag.php";
<script type="text/javascript" src="script/jquery.js"></script>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript" src="script/graf.js"></script>
<?php
include "menu.php";
if ($_SESSION['name_sesion_a']=="admin"){
include "class/function.php";
include "class/mysql-class.php";
include_once("XLSToDBNew.class.php");
$base = new class_mysql_base();
$data = new XLSToDB("test.xls", 'CP1251');
$speciality = $base-> select("select id,name from speciality where 1;");
$year = $base-> select("select id,name from year where 1;");
//new
//$a=$_POST['filename'];
//echo $a;
//new
?>
<HTML>
<HEAD><TITLE>Валідність тестових завдань</TITLE>
<META http-equiv="Content-Type" Content="text/html; charset=windows-1251">
<link rel="stylesheet" href="css/style.css" type="text/css">
</HEAD>
<BODY bgcolor="#94AAB5">
<?php
<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");
if ($_GET['id']) {
$excel_info = $test->select_excel2("SELECT * FROM excel WHERE id='" . (int) $_GET['id'] . "';");
$year = $test->select_year("SELECT DISTINCT date,name,id FROM yearplan WHERE 1 ORDER BY id DESC;");
echo " <center><h3>Редагування файла EXCEL </h3><br></center>\n <form action='reg_graf.php?id=" . $_GET['id'] . "&faculty=" . $_GET['faculty'] . "&special=" . $_GET['special'] . "&lang=" . $_GET['lang'] . "&year=" . $_GET['year'] . "&course=" . $_GET['course'] . "' method='post' enctype='multipart/form-data'>\n \t\n \n <div class='kvadrant'><br>\n\tКороткий опис\n\t<input name='title' value='" . $excel_info[0]['title'] . "' />\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++) {
if ($year[$i]['id'] == $excel_info[0]['type_atemp']) {
echo "<option value='" . $year[$i]['id'] . "' selected='SELECTED'>" . $year[$i]['date'] . "/" . $year[$i]['name'] . "</option>";
} else {
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'>";
if ($excel_info[0]['lang'] == 'UA') {
echo "<option value='UA' selected='SELECTED'>Українська</option>\n <option value='ENG'>Іноземна</option>\n ";
} else {
echo "<option value='UA'>Українська</option>\n <option value='ENG' selected='SELECTED'>Іноземна</option>\n ";
}
echo "</select>\n\t<br><br>\n\t</div>\n \n <div class='kvadrant'><br> \n\tДата здачі\n\t<input id='inputDate4' name='date' value='" . $excel_info[0]['date'] . "' />\n\t<br><br>\n\t</div>\n \n\t<div class='kvadrant'><br>\n\tТип здачі \n\t<select name='zdacha'>\n ";
<HTML>
<HEAD><TITLE>Архів тестових завдань</TITLE>
<META http-equiv="Content-Type" Content="text/html; charset=windows-1251">
<link rel="stylesheet" href="css/style.css" type="text/css">
</HEAD>
<BODY bgcolor="#94AAB5">
<?php
include "menu.php";
include "class/function.php";
include "class/mysql-class.php";
$base = new class_mysql_base();
if ($_SESSION['name_sesion_a'] == "admin") {
if ($_GET['id']) {
$var_del = $base->select_variant("SELECT id FROM variant WHERE type='" . $_GET['id'] . "';");
for ($v = 0; $v < count($var_del); $v++) {
$base->delete("DELETE FROM `group` WHERE `numvariant`='" . $var_del[$v]['id'] . "';");
}
$base->delete("DELETE FROM `variant` WHERE `type`='" . $_GET['id'] . "';");
$base->delete("DELETE FROM `type_validn` WHERE `id`='" . $_GET['id'] . "';");
}
}
echo "<center><form action='arh.php' method='POST' enctype='multipart/form-data'>\n <table width=90% style='border: 1px solid blue;margin-top:20px;background-color:white;'><tr><td>\n \n </td><td><center><h2><p><b>Архів груп варіантів</b></p></h2></center><br>\n ";
$speciality = $base->select("select id,name from speciality where 1;");
$year = $base->select("select id,name from year where 1;");
echo "<b><table><tr><td width='100px'><b>Фільтри</td><td><b>Виберіть спеціальність</b>";
navigate("Спеціальність", $speciality, "spec");
echo "</td><td><b>Виберіть рік здачі</b>";
navigate("Рік", $year, "year");
echo "</td><td><input type='submit' value='Задіяти'></td></tr></table>";
$sqls = '1';
if ($_POST['spec'] > 0) {
<?php
$questions = array(array());
require_once "class/mysql-class.php";
$base = new class_mysql_base();
$base->sql_connect();
$rs = $base->sql_query = "call `selectgroup`(16485,1)";
//$rs = $base->sql_query="select * from variant where 1; ";
$base->sql_execute();
while ($Mas = mysql_fetch_array($base->sql_result)) {
$questions[$i]['id'] = $Mas['id'];
$questions[$i]['numvariant'] = $Mas['numvariant'];
$questions[$i]['numquestion'] = $Mas['numquestion'];
$questions[$i]['gr1'] = $Mas['gr1'];
$questions[$i]['gr2'] = $Mas['gr2'];
$questions[$i]['gr3'] = $Mas['gr3'];
$questions[$i]['gr4'] = $Mas['gr4'];
$questions[$i]['gr5'] = $Mas['gr5'];
$questions[$i]['validn'] = $Mas['validn'];
$i++;
}
print_r($questions);
?>
<?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>";
<script src="http://shublog.ru/files/js/jquery-1.6.4.js"></script>
<script type="text/javascript" src="datepicker/jquery.tcollapse.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();
echo "<br><CENTER><h3>Опції налаштування</h3></CENTER>\n <form action='option.php' method='post' enctype='multipart/form-data' style='border: 1px solid blue;margin-top:20px;background-color:white;'>\n <div style='padding-left:50px;'>\n <b><h4>Ввести новий навчальний план</b></h4>\n \n\tРік здачі \n <input size='5' name='date' value='" . DATE("Y") . "' />\n\tТип \n\t<select name='name'>\n <option value='Зимова'>Зимова</option>\n <option value='Літня'>Літня</option>\n\t</select>\n \n <input type='submit' name='ok' value='Добавити'>\n </div><br>\n ";
if ($_POST['ok']) {
$test->update_excel("INSERT INTO `testcenter`.`yearplan` (`name` ,`date`)VALUES ('" . $_POST['name'] . "', '" . $_POST['date'] . "');");
echo "<FONT color='green'><b><center>Успішно добавленний навчальний план </b></center></FONT>";
}
echo "<br></form>\n <form action='option.php' method='post' enctype='multipart/form-data' style='border: 1px solid blue;margin-top:20px;background-color:white;'>\n <div style='padding-left:50px;'>\n <b><h4>Титульна сторінка</b></h4>\n Сторінка яка буде показуватись в пунткті 'Головна' , це може бути графік здач семестрового іспиту,<br>\n або інша інформація. Також вона буде видимою і для студентів.<br><br>\n\t \n Виберіть файл <input type='file' name='filename' value='Огляд'>\n <input type='submit' name='general' value='Добавити'>\n </div><br>\n ";
if (isset($_FILES["filename"]["tmp_name"])) {
if (is_uploaded_file($_FILES["filename"]["tmp_name"])) {
move_uploaded_file($_FILES["filename"]["tmp_name"], "graf/index.html");
}
$links = "graf/index.html";
$test->update_excel("UPDATE testcenter.option SET `value` = '" . $links . "' WHERE `id`='2';");
echo "<FONT color='green'><b><center>Успішно добавлена головна сторінка </b></center></FONT>";
}
echo "<br></form>";
}
include 'footer.php';
