<?
	$current_date_time = date('Y-m-d G:i:s');
	
	//$database->debug = true;
	
	$get_start_time = "
	SELECT start_time
	FROM job_trackings
	WHERE id = '$job_tracking_id'
	";
	$start_time = $database->getOne($get_start_time);
	
	$get_last_job_tracking = "
	SELECT *
	FROM job_trackings 
	WHERE user_id = '$user_id'
	ORDER BY id DESC LIMIT 1
	";
	$last_job_tracking=$database->getRow($get_last_job_tracking);

	$to_time=strtotime($current_date_time);
	$from_time=strtotime($start_time);
	$shift_minutes =round(abs($to_time - $from_time) / 60);

	$shift = "Your last shift was: ".floor($shift_minutes/60)." hours and ".($shift_minutes%60) ." minutes";

	$alert = ($shift_minutes > 520) ? 1 : 0 ;
	
	$database->StartTrans();

	if($last_job_tracking['end_time'] == "0000-00-00 00:00:00")
	{
		$insert_end_time = "
		UPDATE job_trackings
		SET
			end_time = '$current_date_time',
			alert = '$alert',
			submitter = '$user_id',
			date_submitted = '$current_date_time'
		WHERE
			id = '$job_tracking_id'
		";
		$database->getRow($insert_end_time);
	}
	
	logs::submit_logs(array("table" => "job_trackings", "action_type" => 2,"foreign_id" => $job_tracking_id, "description" => "Job Tracking stopped at $current_date_time"));
	
	$result= $database->CompleteTrans();
	
	$status = false;
	
	if($result)
		$status = true;
	else
		$status = false;

	$results = array("status" => $status, "shift_time" => $shift);
	
	$json =  json_encode($results);	
	echo $json;
?>