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']) {