$dbConn->updateEmployment($_POST['personID'], $_POST['year'], $data); echo date("Y-m-d H:i:s"); break; case 'extra_hours': $data = array("hours" => $_POST['newValue']); $dbConn->updateHoursExtra($_POST['id'], $data); echo date("Y-m-d H:i:s"); break; case 'extra_note': $data = array("description" => $_POST['newValue']); $dbConn->updateHoursExtra($_POST['id'], $data); echo date("Y-m-d H:i:s"); break; case 'work_hours': $data = array("hours" => $_POST['newValue']); $dbConn->updateHoursWork($_POST['course_period_id'], $_POST['personID'], $data); echo date("Y-m-d H:i:s"); break; case 'work_note': $data = array("description" => $_POST['newValue']); $dbConn->updateHoursWork($_POST['course_period_id'], $_POST['personID'], $data); echo date("Y-m-d H:i:s"); break; case 'employment_percent': $data = array("percent" => $_POST['newValue']); $dbConn->updateEmployment($_POST['personID'], $_POST['year'], $data); echo date("Y-m-d H:i:s"); break; case 'employment_note': $data = array("notification" => $_POST['newValue']); $dbConn->updateEmployment($_POST['personID'], $_POST['year'], $data);
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) { if ($mainfield['mainfield'] == $_POST['mainField']) { echo json_encode($mainfield); }