function process_foreign_credits() { global $userrole; if ($userrole === "admin") { print '<b>Travel foreign courses</b><br /><br />'; $filter_exchange = retrieve_filter_exchange(); show_exchange_filter($filter_exchange); $tcdata = NULL; if (isset($_GET['act'])) { if ($_POST['Edit'] === 'edit') { $tcdata = db_foreign_courses_for_an_exchange($filter_exchange, TRUE); edit_travel_course($tcdata); } else { if ($_POST['Add'] === 'add') { add_travel_course($filter_exchange); } else { if ($_POST['Save'] === 'save') { save_travel_course($filter_exchange); } else { if ($_POST['Remove'] === 'remove') { $tcdata = db_foreign_courses_for_an_exchange($filter_exchange, TRUE); remove_record($tcdata); } else { if ($_POST['Remove'] === 'yes') { yes_remove_travel_courses(); } } } } } } logmsg("retr"); if ($tcdata == NULL) { $tcdata = db_foreign_courses_for_an_exchange($filter_exchange, TRUE); } logmsg("ieve"); $tcf = format_travel_foreign_courses($tcdata); show_table(array('ID', 'Foreign course code', 'Foreign course name', 'Credits', 'Grade', 'Course type'), $tcf); } else { return; } }
function db_retrieve_travel_byID($tvid, $as_array = FALSE) { global $link; mysqli_set_charset($link, "utf8"); $stmnt = $link->stmt_init(); $stmnt->prepare('SELECT STUDY_YEAR, AGREEMENT_ID, FROM_DATE, TO_DATE, SEMESTER, STUDENT_STUDY_PROGRAMS.ID_STUDENT, STUDENT_STUDY_PROGRAMS.ID_STUDYPROGRAM, ID_LANGUAGE, STUDENTLEVEL, REQUIREDLEVEL, SOCIALSTIPEND, HANDICAPPED, NOTES, CANCELLED, STUDENT_EXCHANGES.YEAR FROM STUDENT_EXCHANGES JOIN STUDENT_STUDY_PROGRAMS ON STUDENT_STUDY_PROGRAMS.ID=STUDENT_EXCHANGES.ID_STUDENT_STUDY_PROGRAM WHERE STUDENT_EXCHANGES.ID=?'); $stmnt->bind_param('i', $tvid); $stmnt->execute(); $stmnt->bind_result($year, $agid, $fromdate, $todate, $semester, $stid, $spid, $lang, $has, $expect, $sstip, $handic, $notes, $cancelled, $acyear); $stmnt->fetch(); $rw = array($tvid, $year, $agid, $fromdate, $todate, $stid, $spid, $semester, $lang, $has, $expect, $sstip, $handic); $stmnt->close(); $rw[] = db_list_files(7, $tvid); if ($as_array === FALSE) { $rw[] = db_foreign_courses_for_an_exchange($tvid, $as_array) . '---<br />' . db_fmfi_courses_for_an_exchange($tvid, $as_array); } else { $rw[] = array(db_foreign_courses_for_an_exchange($tvid, $as_array), db_fmfi_courses_for_an_exchange($tvid, $as_array)); } $rw[] = $notes; $rw[] = $cancelled; $rw[] = $acyear; return $rw; }