Example #1
0
session_start();
include_once "basic.php";
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'];
                        }