Пример #1
0
     $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);
Пример #2
0
 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);
                         }