$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>";
for ($i = 0; $i < count($dis); $i++) {
echo "<tr style='font-size:8pt;'>";
for ($j = 1; $j < count($dis[0]); $j++) {
echo "<td><center>" . $dis[$i][$j] . "</td>";
}
if (count($dis[0]) != 0) {
echo "<td><a href='moodle2cont.php?" . $_SERVER['QUERY_STRING'] . "&del=" . $dis[$i][0] . "'><center>Делете</td></tr>";
if ($_POST['put'] || $_POST['var']) {
$year_v = array();
$sem_v = array();
$s = 0;
$y = 0;
for ($i = 0; $i < count($year) + count($sem) + 1; $i++) {
if ($_POST["year" . $i]) {
$year_v[$y] = $year[$i][1];
$y++;
}
if ($_POST["sem" . $i]) {
$sem_v[$s] = $sem[$i][0];
$s++;
}
}
$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] . "';");
