<?php
include '../../../cfg/connhr.php';
$mykey = $_GET['keyID'];
 
 
if($mykey == "TOKEN6e59e008b5348b452X615a3033729daae383"){
   $employee_id = $_GET['employee_id'];
   $dateStart = $_GET['date_start'];
   $dateEnd = $_GET['date_end'];
   $timeStart = $_GET['time_start'];
   $timeEnd = $_GET['time_end'];
   $purpose = $_GET['purpose'];
   $distination = $_GET['distination'];
   
    $sql = "INSERT INTO employee_obs (`employee_id`,`date_from`,`date_to`,`from_time`,`to_time`,`description`,`destination`)
    	VALUES (
    	    '$employee_id',
    	    '$dateStart',
    	    '$dateEnd',
    	    '$timeStart',
    	    '$timeEnd',
    	    '$purpose',
    	    '$distination'
    	    )";
    	
    if ($connhr->query($sql) === TRUE) {
    	$stat="Record has been saved.";
    } else {
    	$stat="Error, unable to save record. Please contact us via Live Chat Support.  Thank you!";
    }


    header('Content-Type: application/json');
    echo json_encode(["status"=>"$stat"]);
} 
// Close connection
$conn->close();

?>