move_uploaded_file($_FILES["filename"]["tmp_name"], "xls/" . $temp_file . $_FILES["filename"]["name"]); $data = new XLSToDB($temp_file . $_FILES["filename"]["name"], 'UTF-8'); $fileXLS = $temp_file . $_FILES["filename"]["name"]; $links = "xls/" . $temp_file . $_FILES["filename"]["name"]; //-----формування масивів листів $table[0] = $ocinku_styd = $data->get($fileXLS, 0, 10); $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++) {
echo "<center><h2>Звязок дисциплін контингенту та мудлу по кафедрам</h2></center><b>"; $contingent = new class_ibase(); $base_local = new class_mysql_base_local(); $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();