function gotDTMF($text)
{
global $state;
global $mailbox;
global $collect_user;
global $collect_pass;
Yate::Debug("gotDTMF('{$text}') state: {$state}");
switch ($state) {
case "user":
if ($text == "*") {
promptUser();
return;
}
if ($text == "#") {
checkUser();
} else {
$collect_user .= $text;
}
return;
case "pass":
if ($text == "*") {
promptPass();
return;
}
if ($text == "#") {
checkPass();
} else {
$collect_pass .= $text;
}
return;
}
if ($mailbox == "") {
return;
}
navigate($text);
}
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] . " ");
//---------навчальний план
if ($_GET['semester']) {
$plan = $contingent->select("select bvm.modulenum,gd.discipline,bvm.moduletheme,S2T.TESTLISTID 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_module bvm \n 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\n on (BVI_V.disciplineid = gd.disciplineid) where S2T.STUDENTID=" . $student[0][0] . " AND BT.SEMESTER=" . $_GET['semester'] . " ORDER BY discipline");
}
echo "<br><div class='well'><table bgcolor='white' width='100%'>";
echo "<tr><td width=10%><b>Студент </td><td width=50%>" . $student[0][1] . "</td><td width=40% valign=top rowspan=6><img width='100' src='class/photo.php?id_photo=" . $student[0][0] . "'></td>\n\t<td rowspan=6 ><center><b>Навчальний план<br>";
navigate('Фільтр по семестру', $plan_semester, 'semester');
echo "<div style='width: 700px; height: 300px; overflow: auto; ' id='over'><div class='well'><table bgcolor='#cecece' id='t' width='100%'>";
for ($i = 0; $i < count($plan); $i++) {
echo "<tr style='font-size:8pt;' name='" . $plan[$i][3] . "' class='id_mod'>";
echo "<td><input type='checkbox' name='mod' class='mod' value='" . $plan[$i][3] . "'></td><td><center>" . $plan[$i][1] . "</td><td>" . $plan[$i][0] . "." . $plan[$i][2] . "</td>";
echo "</tr>";
}
echo "</table></div></div>";
//---------навчальний план
echo "</td></tr>";
echo "<tr><td><b>Спеціальність </td><td>" . $student[0][2] . "</tr>";
echo "<tr><td><b>Факультет </td><td>" . $student[0][3] . "</tr>";
echo "<tr><td><b>Семестер </td><td>" . $student[0][4] . "</tr>";
echo "<tr><td><b>Група </td><td>" . $student[0][5] . "</tr>";
echo "<tr class='vidomist' style='display:none;'><td colspan=4 valign=bottom><center>\n\tВведіть дату <input type='text' class='span2' name='date' value='" . date("d.m.Y") . "' id='dp1'> \n\tВведіть оцінку <input type='text' id='ocinka' name='ocinka' value='" . $_POST['ocinka'] . "'></td>";
echo "<tr class='vidomist' style='display:none;'><td colspan=4 valign=bottom><center>\n\t<input type='button' name='formy' class='formy' value='Зформувати відомість' onClick='vido()'></td></tr></table></div>";
$recordoffset = 0;
}
}
}
if($id == '' and $query = mysql_query("SELECT *, DATE_FORMAT(`date`, '%d.%m.%Y') AS `date` FROM news ORDER BY UNIX_TIMESTAMP(`date`) DESC LIMIT $recordoffset,".$perpage) and mysql_fetch_assoc($query)!=''){
mysql_data_seek($query, 0);
while($row = mysql_fetch_assoc($query))
{
$content .= $row['date'] . '<br>
<a href="/news/' .$row['id']. '" style="color:#000; line-height:20px;">' .
$row['name'] . '</a><p><span>' . $row['announce'] . '</p></span><hr>';
}
//блок навигации
$navigate = navigate('http://'.$_SERVER['HTTP_HOST'].'/'.$page, $cur_page, $numpages);
$content .= $navigate;
}
elseif($id != '' and $query = mysql_query("SELECT *, DATE_FORMAT(`date`, '%d.%m.%Y') AS `date` FROM news WHERE id='".$id."'") and mysql_fetch_assoc($query)!=''){
mysql_data_seek($query, 0);
$row = mysql_fetch_assoc($query);
$newsName = $row['name'];
$content .= '
<h2>
'.$row['date'].'
</h2>
'.$row['text'];
$bread = breadcrumbs($page_id, 'news', $row['id']);
}
else{
echo '<script>location="/404/";</script>';
function navigate($nodeid)
{
$GLOBALS['tree_st'][$nodeid]['left'] = $GLOBALS['count'];
$GLOBALS['count']++;
if (empty($GLOBALS['tree_st'][$nodeid]['sons'])) {
$GLOBALS['tree_st'][$nodeid]['right'] = $GLOBALS['count'];
$GLOBALS['count']++;
return;
} else {
foreach ($GLOBALS['tree_st'][$nodeid]['sons'] as $id) {
navigate($id);
}
$GLOBALS['tree_st'][$nodeid]['right'] = $GLOBALS['count'];
$GLOBALS['count']++;
}
}
$sql = "SELECT * FROM {$usedb}.{$usetable} WHERE {$editdelwhere}";
$result = mysql_query($sql);
include "err_msg.inc";
$norcd = mysql_num_rows($result);
echo "{$sql}<br><br>";
if ($norcd > 1) {
echo "<b>{$norcd}</b> records found. Only the first record is shown below. " . "Please select right fields from left frame, try again.<br>";
}
include "show_record_for_edit_del.inc";
lastnavigate();
exit;
}
include "rcd_nav.inc";
include "query_mysql_db.inc";
include "rcd_nav.inc";
navigate();
echo "<form method=post>";
echo "<input type=\"hidden\" value=\"{$usedb}\" name=\"usedb\">";
echo "<input type=\"hidden\" value=\"{$usetable}\" name=\"usetable\">";
echo "<input type=\"hidden\" value=\"{$fldeditconst}\" name=\"fldeditconst\">";
echo "<input type=\"hidden\" value=\"{$editfldno}\" name=\"editfldno\">";
echo "<{$h}>Customise Query Statement</{$h}>";
echo "<b>Current</b><br>";
$sql = ereg_replace("FROM", "<br> FROM", $sql);
$sql = ereg_replace("ORDER BY", "<br> ORDER BY", $sql);
$sql = ereg_replace("LIMIT", "<br> LIMIT", $sql);
echo "<br>{$sql}<br><br>";
echo "<b>Edit</b><br>";
echo "<table border={$border}>";
$fldselectall = $fldproplist[0][0];
$wstr = $fldproplist[0][0] . "=''";
<div id = "price_filter">Цена от:
<input class = "input_price" id = "from_price" type = text pattern="[0-9]"> до:
<input class = "input_price" id = "between_price" type = text>
</div>
<div id = "button_filter">Применить</div>
<div class = "clear"></div>
</div>
';
if($query = mysql_query("SELECT * FROM catalog_items WHERE pid='".$_POST['pid']."' ORDER BY pos ASC LIMIT $recordoffset, $perpage")
and mysql_fetch_assoc($query)!='')
{
//$out .= $catalog_filter;
$out .= '<div id = "all_goods_list">';
$navigate = navigate($cur_page, $numpages);
$out .= $navigate;
mysql_data_seek($query, 0);
while ($row = mysql_fetch_assoc($query))
{
if (is_file($_SERVER['DOCUMENT_ROOT'].'/img/'.$row['photo']))
{
$img = '<img src="/img/'.$row['photo'].'" width="150" border="0">';
}
else
{
$img = '';
}
//Get select controls data
$base_tdmu = new class_mysql_base_tdmu();
$ratingindex = $base_tdmu->select("SELECT DISTINCT index_id, index_text FROM tr_teacher_indices;");
//$base_tdmu = new class_mysql_base_tdmu();
$department = $base_tdmu->select("SELECT kaf_id, kaf_name FROM tbl_tech_kaf_folder ORDER BY kaf_name;");
//print_r($ratingindex);
//print_r($department);
echo "<center><h2>Дані рейтингу викладачів</h2>";
echo "<form action='ratinginfo.php?" . $_SERVER['QUERY_STRING'] . "' method='POST' enctype='multipart/form-data'>";
//Draw indices selector
echo "<table width=100%><tr><td bgcolor=gray valign=top><center>";
navigate('Виберіть показник:', $ratingindex, 'INDEXID');
echo "</td></tr>";
//Draw departmnet selector
echo "<tr><td bgcolor=gray valign=top><center>";
navigate('Кафедра (чи всі):', $department, 'DEPARTMENT');
echo "</td></tr>";
//Draw options checkboxes
echo "<tr><td bgcolor=gray valign=top><center>";
if ($_POST['DETAIL'] == "on") {
echo "<input type='checkbox' class='DETAIL' name='DETAIL' CHECKED> " . " - Детальна інформація" . "<br>";
} else {
echo "<input type='checkbox' class='DETAIL' name='DETAIL'> " . " - Детальна інформація" . "<br>";
}
if ($_POST['SUMMARY'] == "on") {
echo "<input type='checkbox' class='SUMMARY' name='SUMMARY' CHECKED> " . " - Сумарна інформація" . "<br>";
} else {
echo "<input type='checkbox' class='SUMMARY' name='SUMMARY'> " . " - Сумарна інформація" . "<br>";
}
echo "</td></tr></table>";
echo "<br><center><input type='submit' name='var' value='Вибрати'><br></form>";
<meta name=Generator content=\"Microsoft Word 11\">
</head>
<body>";
//new
echo "<center><form action='all72.php' method='post' enctype='multipart/form-data'>
<table width=90% style='border: 1px solid blue;margin-top:20px;background-color:white;'><tr><td>
</td><td><center><h2><p><b>Завантажити файл з 72 питаннями </b></p></h2></center>
<b>Записати до БД дані</b><br>
Відмітьте для запису<input type='checkbox' name='bd'><br>
<b>Виберіть спеціальність</b>";
navigate("Спеціальність",$speciality,"spec");
echo "<br><b>Виберіть рік здачі</b>";
navigate("Рік",$year,"year");
echo "<br>
<b>Виберіть файл для обробки</b> <br><input type='file' name='filename' value='Огляд'>
<input type='submit' value='Завантажити файл'><br></table></form>";
//Перевірка на тип файлу
$allowed = array('application/vnd.ms-excel','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
if ((!in_array($_FILES["filename"]["type"], $allowed))) {
if (!empty($_FILES["filename"]["type"])){
echo "<FONT COLOR=red><B>Файл не підтримується</B></FONT>";}
} else {
cleanDir('report');
cleanDir('report/var');
//Перенесення файлу в папку на сервері
//echo "file/".$_FILES["filename"]["name"];
if (isset($_FILES["filename"]["tmp_name"])) {
for ($g = 0; $g < count($zagalne); $g++) {
if ($zagalne[$g][0] == $dis_k[$i][2]) {
echo $zagalne[$g][1];
}
}
echo "</td><td><a href='moodle2cont.php?" . $_SERVER['QUERY_STRING'] . "&del=" . $dis_k[$i][0] . "'><center>Делете</td></tr>";
}
}
echo "</table></div>";
} else {
echo "<br> <div id='disciplin_k' style='display:none;background-color:white;'><center style='color:red;'>Незнайдено прикріплених дисциплін</center></div>";
}
echo "<br><form action='moodle2cont.php?" . $_SERVER['QUERY_STRING'] . "' method='post' enctype='multipart/form-data'>";
echo "<table width=99% bgcolor='white'><tr><td colspan=2>\n<center><b>Створення звязку дисциплін з кафедрою</b></center>";
navigate('Дисципліна з контингенту ', $dis_cont, 'dis_cont');
navigate('Дисципліна з мудла на кафедрі ', $dis_moodle, 'dis_moodle');
echo "<br></tr><tr><td><div style='display:block;'><input type='submit' name='ins' value='Створити звязок'></td><td width=45%>";
echo " <font color=red style='font-size:10pt;'><b>Звязок дисципліни з кафедрою без привязки до мудла </b></font><input type='submit' name='ins_old' value='Звязати'></div></td></tr>";
echo "</table></form>";
}
} else {
header("Location: index.php");
}
?>
<script>
$('.kaf').change(function() {window.location.href='moodle2cont.php?kaf='+ encodeURIComponent($('select[name=\'kaf\']').val());});
$('#active_d').click(function() {
if ($(this).attr('act')=='Y'){
$('#disciplin').slideDown(500);
$(this).attr('act','N');
$(this).attr('src','http://market.auto.ria.ua/img/minus.gif');
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> Фільтр";
echo "<br><br><form action='ser.php?" . $_SERVER['QUERY_STRING'] . "' method='post' enctype='multipart/form-data'><table bgcolor='white'><tr><td valign=top>";
check('Рік', $year, 'year');
echo "</td><td valign=top>";
check('Семестер', $sem, 'sem');
echo "</td><td valign=top>";
check('Екзамен', $ekzam, 'ekzam');
echo "</td></tr><tr><td></td><td><input type='submit' name='put' value='Вибрати'></td></tr></table>";
if ($_POST['put'] || $_POST['var']) {
