<?
	$current_date_time = date('Y-m-d G:i:s');

	$database->StartTrans();
	
	$insert_start_time = "
	INSERT INTO job_trackings
	SET
		user_id = '$user_id',
		job_id = '$job_id',
		department = '$department',
		start_time = '$current_date_time',
		status = '1',
		creator = '$user_id',
		date_created = '$current_date_time',
		submitter = '$user_id',
		date_submitted = '$current_date_time'
	";
	$database->getRow($insert_start_time);
	
	$tracking_id = $database->insert_ID();
	
	logs::submit_logs(array("table" => "job_trackings", "action_type" => 1,"foreign_id" => $tracking_id, "description" => "Job Tracking started at $current_date_time"));
	
	$result = $database->CompleteTrans(); 
	
	$status = false;
	
	if($result)
		$status = true;
	else
		$status = false;

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