<?
	$current_date_time = date('Y-m-d G:i:s');
	
	//$database->debug = true;
	
	$get_start_time = "
	SELECT start_time
	FROM timesheets
	WHERE id = '$timesheet'
	";
	$start_time = $database->getOne($get_start_time);

	$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 ;
	
	$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);
	
	$last_job_tracking_id = $last_job_tracking['id'];
	
	if($last_job_tracking['end_time'] == "0000-00-00 00:00:00")
	{
		$get_job_start_time = "
		SELECT start_time
		FROM job_trackings
		WHERE id = '$last_job_tracking_id'
		";
		$start_job_time = $database->getOne($get_job_start_time);
	
		$job_from_time=strtotime($start_job_time);
		$job_shift_minutes =round(abs($to_time - $job_from_time) / 60);
	
		$alert_job = ($job_shift_minutes > 520) ? 1 : 0 ;
	}

	$database->StartTrans();

	$insert_end_time = "
	UPDATE timesheets
	SET
		end_time = '$current_date_time',
		alert = '$alert',
		submitter = '$user_id',
		date_submitted = '$current_date_time'
	WHERE
		id = '$timesheet'
	";
	$database->getRow($insert_end_time);

	logs::submit_logs(array("table" => "timesheets", "action_type" => 2,"foreign_id" => $timesheet, "description" => "Time sheet stopped at $current_date_time"));
	
	if($last_job_tracking['end_time'] == "0000-00-00 00:00:00")
	{
		$insert_end_job_time = "
		UPDATE job_trackings
		SET
			end_time = '$current_date_time',
			alert = '$alert_job',
			submitter = '$user_id',
			date_submitted = '$current_date_time'
		WHERE
			id = '$last_job_tracking_id'
		";
		$database->getRow($insert_end_job_time);
	}
	logs::submit_logs(array("table" => "job_trackings", "action_type" => 2,"foreign_id" => $last_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;
?>