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]; } $sql_disc = $contingent->for_sql($mas); if ($sql_disc == '') { $sql_dis = ''; } else { $sql_dis = " AND id NOT IN (" . $sql_disc . ")"; } $dis_moodle = $base_moodle->select("SELECT id,fullname FROM `mdl_course` WHERE `category`='" . (int) $_GET['kaf'] . "' " . $sql_dis . ";"); if (count($dis[0]) != '') { echo "<br><div id='disciplin' style='display:none;'><table border=1 width=99% bgcolor='white'><tr><td>Назва дисципліни у контингенті</td><td>Назва дисципліни у мудлі</td><td>ID Кафедри</td><td></td></tr>";
$table[1] = $zvjaz_styd = $data->get($fileXLS, 1, 3); $table[2] = $module_styd = $data->get($fileXLS, 2, 6); $table[3] = $potochna_styd = $data->get($fileXLS, 3, 12); $table[4] = $ostatochna_styd = $data->get($fileXLS, 4, 12); $kilk = 0; $g = 0; $l1 = 0; //----------------таблиці ---------------------------- table($name_table, $table, $table_id); $local->ins("DELETE FROM `pr` WHERE name_user='******'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'] . "');"); } } $kilk_mod = $local->select("SELECT * FROM pr WHERE name_user='******'role'] . "';"); for ($i = 0; $i < 10; $i++) { if ($ocinku_styd[0][$i] != NULL) { $kilk++; } } //Оброблення таблиці оцінок for ($i = 0; $i < count($ocinku_styd) + 1; $i++) { if ($ocinku_styd[$i][0] != "") { for ($j = 2; $j < $kilk - 1; $j++) { if ($ocinku_styd[$i][0] == 1) { $ocinku[$g][1] = $j - 1; } if ($ocinku_styd[$i][0] == 2 && $j - 1 + $kilk - 3 <= count($kilk_mod)) { $ocinku[$g][1] = $j - 1 + $kilk - 3; }
} $sem_sql = $contingent->for_sql($sem_v); $year_sql = $contingent->for_sql($year_v); if ($sem_sql != '') { $sem_sql = "AND BT.SEMESTER in (" . $sem_sql . ")"; } if ($year_sql != '') { $year_sql = "and BT.EDUYEAR in (" . $year_sql . ")"; } } else { $sem_sql = ''; $year_sql = ''; } $zag_mas = $contingent->select("select DISTINCT BVI_V.VARIANTID,\n(select count (iBVI_M.VARIANTID)\nfrom B_VARIANT_ITEMS iBVI_M\ninner join B_VARIANT_MODULE iBVM\n on (iBVM.VARIANTID = iBVI_M.VARIANTID)\ninner join B_VARIANT_ITEMS iBVI_V\n on (iBVI_V.VARIANTID = iBVI_M.PARENTVARIANTID)\nwhere iBVI_V.VARIANTID = BVI_V.VARIANTID\n group by iBVI_M.PARENTVARIANTID) total_modules,GE.EDUYEARSTR,BT.SEMESTER,bvm.modulenum,bvm.moduletheme from B_TESTLIST BT 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_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_sql . " " . $year_sql . " order by BVI_V.VARIANTID,GE.EDUYEARSTR,BT.SEMESTER,bvm.modulenum"); echo "</td></tr><tr><td colspan=2><br>"; $discipl = $base_local->select("SELECT DISTINCT id_kaf_moodle FROM discipline WHERE id_kontingent='" . (int) $_GET['DISCIPLINE'] . "';"); $kaf = $base_moodle->select("SELECT id,name FROM mdl_course_categories WHERE id = '" . (int) $discipl[0][0] . "';"); $parts = explode("(", strip_tags($kaf[0][1])); if ($parts[0] != '') { echo "<center style='background-color:white;'>Кафедра (<font color=green >" . $parts[0] . "</font>)</center>"; } else { echo "<center style='background-color:white;'><font color=red>Ця дисципліна не зв'язана з кафедрою, зверніться до адміністратора!</font></center>"; } echo "\n <table bgcolor='white' border=1 width=100% class='ser2'><tr style='text-align:center' bgcolor=gray><td width=3%>\n <input type='checkbox' id='toggle' value='S' onClick='do_this()' /></td><td>Номер варіанту</td><td>Сум</td><td>Рік</td><td>Семестер</td><td>Номер<br>модуля</td><td>Назва модуля</td>"; //prepare variables to the paint row with different eduplanid by different colors $prev_eduplanid = $zag_mas[0][0]; $first_row_bgcolor = "pink"; $second_row_bgcolor = "yellow"; $row_bgcolor = $first_row_bgcolor; for ($i = 0; $i < count($zag_mas); $i++) { //repaint row with different eduplanid by different colors