if (checkClearanceLevel(ORGANIZER)) { include_once "dbcredentialspath.php"; include_once DB_CREDENTIALS_PATH; include_once "DBInterface.php"; /*foreach ($_POST as $test) { echo $test . "\n"; }*/ $dbConn = new DBInterface(); if (isset($_POST['toUpdate'])) { switch ($_POST['toUpdate']) { case 'hoursWorkOnCourse': $data = array("hours" => $_POST['hours']); $hoursWorkForTheCourse = $dbConn->getHoursWorkPerCoursePerPeriod($_POST['coursePerPeriodID']); if (isset($hoursWorkForTheCourse[$_POST['personID']])) { if ($_POST['hours'] == -1) { $dbConn->removeHoursWork($_POST['coursePerPeriodID'], $_POST['personID']); exit; } $dbConn->updateHoursWork($_POST['coursePerPeriodID'], $_POST['personID'], $data); $coursePerPeriod = $dbConn->getCoursePerPeriod($_POST['coursePerPeriodID']); $hoursWork = $dbConn->getTotalHoursWork($_POST['personID'], $coursePerPeriod['year']); if ($_POST['mainField'] == "None") { $sumHours = 0; $sumNrOfCourses = 0; foreach ($hoursWork as $mainfield) { $sumHours += $mainfield['hours']; $sumNrOfCourses += $mainfield['nr_of_courses']; } echo json_encode(array('hours' => $sumHours, 'nr_of_courses' => $sumNrOfCourses)); } else { foreach ($hoursWork as $mainfield) {