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