$local->ins("DELETE FROM `zv` WHERE name_user='******'role'] . "';");
$local->ins("DELETE FROM `to` WHERE name_user='******'role'] . "';");
//INSERT OC таблиці оцінок
for ($i = 0; $i < count($ocinku); $i++) {
if ($ocinku[$i][0] != NULL) {
$local->ins("INSERT INTO `vidomosti`.`oc` (`kod` ,`num` ,`oc`,`name_user`)VALUES ('" . $ocinku[$i][0] . "', '" . $ocinku[$i][1] . "', '" . $ocinku[$i][2] . "', '" . $_SESSION['role'] . "');");
}
}
/*for ($i=0;$i<count($module_styd);$i++)
{
if ($module_styd[$i][0]!=NULL){
$local->ins("INSERT INTO `vidomosti`.`pr` (`num` ,`idvar`,`name_user`)VALUES ('".$module_styd[$i][0]."', '".$module_styd[$i][5]."', '".$_SESSION['role']."');");
}}*/
for ($i = 0; $i < count($zvjaz_styd); $i++) {
if ($zvjaz_styd[$i][0] != NULL) {
$gr = $contingent->select("SELECT groupnum FROM students WHERE studentid='" . $zvjaz_styd[$i][1] . "'");
$local->ins("INSERT INTO `vidomosti`.`zv` (`idstyd`, `kod`, `gr`,`name_user`) VALUES ('" . $zvjaz_styd[$i][1] . "', '" . $zvjaz_styd[$i][2] . "', '" . $gr[0][0] . "', '" . $_SESSION['role'] . "');");
}
}
for ($i = 0; $i < count($ostatochna_styd); $i++) {
for ($j = 2; $j < $kilk - 1; $j++) {
if ($ostatochna_styd[$i][0] != NULL) {
if ($ostatochna_styd[$i][$j] == '0') {
$ostatochna_styd[$i][$j] = 'true';
} else {
if ($ostatochna_styd[$i][$j] == '') {
$ostatochna_styd[$i][$j] = 'false';
}
}
$local->ins("INSERT INTO `vidomosti`.`to` (`idstyd`, `num`, `value`,`name_user`) VALUES ('" . $ostatochna_styd[$i][1] . "', '" . ($j - 1) . "', '" . $ostatochna_styd[$i][$j] . "', '" . $_SESSION['role'] . "');");
}
<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;");
$plan_semester = $contingent->select("select distinct BT.SEMESTER,BT.SEMESTER from STUDENT2TESTLIST S2T\ninner 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_ITEMS BVI_V\n on (BVI_V.VARIANTID = BVI_M.PARENTVARIANTID) where S2T.STUDENTID=" . $student[0][0] . " ");
$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']) {
$dis_cont = $contingent->select("SELECT DISTINCT guide_discipline.DISCIPLINEID,guide_discipline.DISCIPLINE FROM guide_discipline WHERE guide_discipline.DISCIPLINEID=" . (int) $_POST['dis_cont'] . " order by guide_discipline.DISCIPLINE");
$dis = $base_local->ins("INSERT INTO `dis_for_kaf`.`discipline` (`id_moodle` , `name_moodle` , `id_kontingent` , `name_kontingent` , `id_kaf_moodle`)VALUES ('1000000', '<font color=red><b>Предмет добавлений на пряму з контингенту</b></font>', '" . $_POST['dis_cont'] . "', '<font color=red><b>" . $dis_cont[0][1] . "</b></font>', '" . $_GET['kaf'] . "');");
}
if ($_POST['ins']) {
$dis_moodle = $base_moodle->select("SELECT id,fullname FROM `mdl_course` WHERE `id`='" . (int) $_POST['dis_moodle'] . "';");
$dis_cont = $contingent->select("SELECT DISTINCT guide_discipline.DISCIPLINEID,guide_discipline.DISCIPLINE FROM guide_discipline WHERE guide_discipline.DISCIPLINEID=" . (int) $_POST['dis_cont'] . " order by guide_discipline.DISCIPLINE");
$dis = $base_local->ins("INSERT INTO `dis_for_kaf`.`discipline` (`id_moodle` , `name_moodle` , `id_kontingent` , `name_kontingent` , `id_kaf_moodle`)VALUES ('" . $_POST['dis_moodle'] . "', '" . $dis_moodle[0][1] . "', '" . $_POST['dis_cont'] . "', '" . $dis_cont[0][1] . "', '" . $_GET['kaf'] . "');");
}
$dis_cont = $contingent->select("SELECT DISTINCT guide_discipline.DISCIPLINEID,guide_discipline.DISCIPLINE FROM guide_discipline , B_VARIANT_ITEMS WHERE B_VARIANT_ITEMS.DISCIPLINEID=guide_discipline.DISCIPLINEID order by guide_discipline.DISCIPLINE");
$dis = $base_local->select("SELECT id,name_kontingent,name_moodle,id_kaf_moodle FROM discipline WHERE id_kaf_moodle='" . (int) $_GET['kaf'] . "' order by id,id_kontingent DESC;");
$dis_k = $base_local->select("SELECT id,name_kontingent,id_kaf_moodle FROM discipline WHERE id_moodle='1000000' order by id_kaf_moodle DESC;");
$disid = $base_local->select("SELECT DISTINCT id_moodle FROM discipline WHERE id_kaf_moodle='" . (int) $_GET['kaf'] . "';");
$mas = array();
for ($d = 0; $d < count($disid); $d++) {
$mas[$d] = $disid[$d][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);
$x[$i][$j + 1] = json_decode(json_encode($value3->moduletheme), 1);
$i++;
}
}
}
echo "<form action='xls_out.php?" . $_SERVER['QUERY_STRING'] . "' method='post' enctype='multipart/form-data'><div class='well'>\n<font color=green><b>Виберіть дисципліни які будуть експортовані у формат XLS </b></font><table border=1><tr bgcolor=gray><td></td><td>Назва дисципліни</td><td>Модуль</td><td>№ модуля</td><td></td><td></td><td></td><td></td>";
for ($i = 0; $i < count($x); $i++) {
$testlist = $contingent->select("select distinct S2T.TESTLISTID from STUDENT2TESTLIST S2T\n\t\tinner 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 \n\t\ton (BVI_M.VARIANTID = bvm.VARIANTID) inner join B_VARIANT_ITEMS BVI_V on (BVI_V.VARIANTID = BVI_M.PARENTVARIANTID) inner join guide_discipline gd\n\t\ton (BVI_V.disciplineid = gd.disciplineid) where BVI_M.PARENTVARIANTID=" . $x[$i][4][0] . " AND BVI_M.VARIANTID=" . $x[$i][5][0] . " AND BT.SEMESTER=" . $sem . " AND BT.EDUYEAR=" . $year . " AND BT.DEPARTMENTID=" . $dep . " AND S2T.STUDENTID=" . $student . " ");
$x[$i][6][0] = $testlist[0][0];
echo "<tr><td><input type='checkbox' name='id" . $i . "' class='id_vid' value='" . $i . "' CHECKED=CHECKED></td>";
for ($j = 0; $j < count($x[0]); $j++) {
echo "<td><center>" . $x[$i][$j][0] . "</td>";
}
echo "</tr>";
}
echo "</table></div>";
$_SESSION['mas'] = $x;
echo "<input type='submit' value='Скачати у форматі XLS'></form>";
}
}
/*$testlist = $contingent->select("select distinct S2T.TESTLISTID 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
<?
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> Фільтр";
