function process_subject_areas()
{
global $userrole;
if ($userrole === "admin") {
print '<b>Subject Areas</b><br /><br />';
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$sa = db_subject_areas();
edit_subject_area($sa);
} else {
if ($_POST['Add'] === 'add') {
add_subject_area();
} else {
if ($_POST['Save'] === 'save') {
save_subject_area();
} else {
if ($_POST['Remove'] === 'remove') {
$sa = db_subject_areas();
remove_record($sa);
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_subject_area();
}
}
}
}
}
}
$sadata = db_subject_areas();
show_table(array('ID', 'Subject area CODE', 'Subject area NAME'), $sadata);
print '<br /><br />For a list of areas, see: <a href="http://egracons.eu/sites/default/files/APPLICATION_OF_ISCED_CODES_IN_EGRACONS_TOOL_2015%2004%2008_1.pdf" target="_blank">ISCED CODES</a><br />';
} else {
return;
}
}
function process_fmfi_courses()
{
global $userrole;
if ($userrole === "admin") {
print '<b>FMFI Courses</b><br /><br />';
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$fc = db_fmfi_courses();
edit_fmfi_course($fc);
} else {
if ($_POST['Add'] === 'add') {
add_fmfi_course();
} else {
if ($_POST['Save'] === 'save') {
save_fmfi_course();
} else {
if ($_POST['Remove'] === 'remove') {
$fc = db_fmfi_courses();
remove_record($fc);
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_fmfi_courses();
}
}
}
}
}
}
$fcdata = db_fmfi_courses();
show_table(array('ID', 'Course CODE', 'Course NAME', 'Credits'), $fcdata);
} else {
return;
}
}
function process_credits()
{
print '<b>Travel courses</b><br /><br />';
$tcdata = NULL;
if (isset($_GET['act'])) {
if (strcmp($_POST['Edit'], 'edit') === 0) {
$tcdata = db_travel_courses();
edit_travel_course($tcdata);
} else {
if (strcmp($_POST['Add'], 'add') === 0) {
add_travel_course();
} else {
if (strcmp($_POST['Save'], 'save') === 0) {
save_travel_course();
} else {
if (strcmp($_POST['Remove'], 'remove') === 0) {
$tcdata = db_travel_courses();
remove_record($tcdata);
} else {
if (strcmp($_POST['Remove'], 'yes') === 0) {
yes_remove_travel_courses();
}
}
}
}
}
}
if ($tcdata == NULL) {
$tcdata = db_travel_courses();
}
$tcf = format_travel_courses($tcdata);
show_table(array('ID', 'Associated travel', 'Foreign course code', 'Foreign course name', 'Credits', 'Grade', 'Course type', 'FMFI course'), $tcf);
}
function process_study_programs()
{
global $userrole;
if ($userrole === "admin") {
print '<b>Study Programs</b><br /><br />';
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$sp = db_study_programs();
edit_study_program($sp);
} else {
if ($_POST['Add'] === 'add') {
add_study_program();
} else {
if ($_POST['Save'] === 'save') {
save_study_program();
} else {
if ($_POST['Remove'] === 'remove') {
$sp = db_study_programs();
remove_record($sp);
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_study_program();
}
}
}
}
}
}
$spdata = db_study_programs();
show_table(array('ID', 'Study program CODE', 'Study program NAME'), $spdata);
} else {
return;
}
}
function process_universities()
{
global $userrole;
if ($userrole === "admin") {
print '<b>Universities</b><br /><br />';
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$uni = db_universities_without_countries();
edit_university($uni);
} else {
if ($_POST['Add'] === 'add') {
add_university();
} else {
if ($_POST['Save'] === 'save') {
save_university();
} else {
if ($_POST['Remove'] === 'remove') {
$uni = db_universities_with_countries();
remove_record($uni);
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_university();
}
}
}
}
}
}
$unidata = db_universities_with_countries();
show_table(array('ID', 'University name (country)', 'Erasmus code'), $unidata);
} else {
return;
}
}
function process_students()
{
global $userrole;
if ($userrole === "admin") {
print '<b>Students</b><br /><br />';
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$st = db_students();
edit_student($st);
} else {
if ($_POST['Add'] === 'add') {
add_student();
} else {
if ($_POST['Save'] === 'save') {
save_student();
} else {
if ($_POST['Remove'] === 'remove') {
$st = db_students();
remove_record($st);
} else {
if ($_POST['AddOption'] === 'add') {
add_study_program_to_student_and_edit_student();
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove();
} else {
if ($_POST['Remove'] === 'no') {
no_remove();
} else {
foreach ($_POST as $var => $val) {
if (strncmp($var, 'deletelist', 10) === 0) {
delete_sp_and_edit_student($var);
break;
}
}
}
}
}
}
}
}
}
}
$stdata = db_students();
$stfd = format_student_data($stdata);
show_table(array('ID', 'First name', 'Middle names', 'Last name', 'Born', 'StudentID', 'Gender', 'Citizenship', 'E-mail', 'Study programs', 'Year 1st participated'), $stfd);
} else {
return;
}
}
function process_agreements()
{
print '<b>Bilateral Agreements</b><br /><br />';
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$agg = db_retrieve_agreements_data();
edit_agreement($agg);
} else {
if ($_POST['Add'] === 'add') {
add_agreement();
} else {
if ($_POST['Save'] === 'save') {
save_agreement();
} else {
if ($_POST['Remove'] === 'remove') {
$agg = db_retrieve_agreements_data();
remove_record($agg);
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_agreement();
} else {
if (isset($_POST['upload10'])) {
upload_file_and_edit_agreement();
} else {
if ($_POST['DeleteFile'] === 'yes') {
yes_delete_file_and_edit_agreement();
} else {
if ($_POST['DeleteFile'] === 'no') {
no_delete_file_and_edit_agreement();
} else {
foreach ($_POST as $var => $val) {
if (strncmp($var, 'deletefile', 10) === 0) {
delete_file_and_edit_agreement($var);
break;
}
}
}
}
}
}
}
}
}
}
}
$columns = array('ID', 'University (country, code)', 'Valid FROM (YYYY/YYYY)', 'Valid TO (YYYY/YYYY)', 'Coordinator', 'Subject Area', 'Accepted levels', '# of students', 'Files');
$agg = db_retrieve_agreements_data();
$fagg = format_agreements_data($agg);
show_table($columns, $fagg);
}
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 process_travels()
{
global $userrole;
if ($userrole === "admin") {
print '<b>Travels</b><br /><br />';
list($filter_a, $filter_d1, $filter_d2) = configure_travel_filters();
show_travel_filters($filter_a, $filter_d1, $filter_d2);
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$ts = db_travels($filter_a, $filter_d1, $filter_d2);
edit_travel($ts);
} else {
if ($_POST['Add'] === 'add') {
add_travel();
} else {
if ($_POST['Print'] === 'print') {
$ts = db_travels($filter_a, $filter_d1, $filter_d2);
print_link_travel($ts);
} else {
if ($_POST['Save'] === 'save') {
save_travel();
} else {
if (isset($_POST['upload13'])) {
upload_file_and_edit_travel();
} else {
if ($_POST['Remove'] === 'remove') {
$ts = db_travels($filter_a, $filter_d1, $filter_d2);
remove_record($ts);
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_travels();
} else {
if ($_POST['DeleteFile'] === 'yes') {
yes_delete_file_and_edit_travel();
} else {
if ($_POST['DeleteFile'] === 'no') {
no_delete_file_and_edit_travel();
} else {
if ($_POST['AddOption'] === 'add') {
add_course_to_travel_and_edit_travel();
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_travels();
} else {
foreach ($_POST as $var => $val) {
if (strncmp($var, 'deletefile', 10) === 0) {
delete_file_and_edit_travel($var);
break;
}
}
}
}
}
}
}
}
}
}
}
}
}
}
$tsdata = db_travels($filter_a, $filter_d1, $filter_d2);
$fts = format_travel_data($tsdata);
show_table(array('ID', 'Level', 'Agreement', 'Semester', 'Date FROM (Y-m-d)', 'Date TO (Y-m-d)', 'Student', 'Study program', 'Language:', 'Has', 'Expected', 'Soc.stip.', 'Handicap', 'Files', 'Courses', 'Notes', 'Cancelled'), $fts, TRUE, TRUE);
} else {
return;
}
echo "\n <script>\n \$('table>tbody>tr>td:nth-child(15)>article').each(\n function(index){\n \$(this).readmore({\n collapsedHeight: 45, \n moreLink: '<a href=\"#\">More</a>',\n lessLink: '<a href=\"#\">Less</a>'\n })\n })\n </script>";
//oshitoshit
}
*/
$counter = 0;
// Load all webservice types
$service_types = kms_permissions_widget_type_options();
$type = 'geo';
$count1 = db_query('SELECT COUNT(entity_id) FROM field_data_field_bundle_webservices_' . $type . ' WHERE bundle =:bundle_type', array(':bundle_type' => 'user'))->fetchField();
print ' Total records in separate service table on start ' . $count1 . "\n";
// Webservices by type
foreach ($service_types as $type) {
$result = db_query('SELECT bundle.entity_id as userid, bundle.field_access_bundles_nid, webservices.entity_id, webservices.field_bundle_webservices_' . $type . '_value as serviceid FROM {field_data_field_access_bundles} as bundle
RIGHT JOIN field_data_field_bundle_webservices_' . $type . ' as webservices
ON bundle.field_access_bundles_nid = webservices.entity_id
WHERE webservices.bundle =:bundle_type', array(':bundle_type' => 'access_bundle'));
foreach ($result as $record) {
$counter++;
remove_record($record->userid, $type, $record->serviceid);
}
}
// Applications
$result_app = db_query('SELECT bundle.entity_id as userid, bundle.field_access_bundles_nid, applications.entity_id, applications.field_applications_value as serviceid FROM {field_data_field_access_bundles} as bundle
RIGHT JOIN field_data_field_applications as applications
ON bundle.field_access_bundles_nid = applications.entity_id
WHERE applications.bundle =:bundle_type', array(':bundle_type' => 'access_bundle'));
foreach ($result_app as $record) {
$counter++;
remove_record_application($record->userid, $record->serviceid);
}
// Predefined datacollections
$result_pre = db_query('SELECT bundle.entity_id as userid, bundle.field_access_bundles_nid, predefined.entity_id, predefined.field_predefined_datacollections_target_id as serviceid FROM {field_data_field_access_bundles} as bundle
RIGHT JOIN field_data_field_predefined_datacollections as predefined
ON bundle.field_access_bundles_nid = predefined.entity_id
