function process_fmfi_credits()
{
global $userrole;
if ($userrole === "admin") {
print '<b>Travel FMFI 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_fmfi_courses_for_an_exchange($filter_exchange, TRUE);
edit_fmfi_travel_course($tcdata);
} else {
if ($_POST['Add'] === 'add') {
add_fmfi_travel_course($filter_exchange);
} else {
if ($_POST['Save'] === 'save') {
save_fmfi_travel_course($filter_exchange);
} else {
if ($_POST['Remove'] === 'remove') {
$tcdata = db_fmfi_courses_for_an_exchange($filter_exchange, TRUE);
remove_record($tcdata);
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_fmfi_travel_courses();
}
}
}
}
}
}
logmsg("retr");
if ($tcdata == NULL) {
$tcdata = db_fmfi_courses_for_an_exchange($filter_exchange, TRUE);
}
logmsg("ieve {$filter_exchange}");
$tcf = format_travel_fmfi_courses($tcdata);
show_table(array('ID', 'FMFI course', 'Grade'), $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;
}
