<?
	$context['id'] = $project_workflow_id;
	$context['main_status'] = 1;		
								
	$database->startTrans();
	
	$is_processed_sql = "SELECT * FROM project_tasks WHERE status = '1' AND main_status = '0' AND id='$project_workflow_id'";
	$result=$database->getRow($is_processed_sql);
	
	if(!$result){
		$status = "false";
		$reason ="This task has been processed.";
	}else{
	
		common_triggers::update_task($context);
	
		$submitter = $_SESSION['user']['id'];
		$date_submitted = date('Y-m-d G:i:s');	
						
		$get_task_id = "
		SELECT workflow_task_id,project_workflow_id
		FROM project_tasks
		WHERE id = '$project_workflow_id'
		";
		list($task_id,$project_workflow_id) = $database->getRow($get_task_id);
		
		if($task_id == 14 || $task_id == 567||$task_id == 675||$task_id == 757)	//close quote
		{
			$status_ref = common_ref_status::get_status("quotes");				
	
			$get_quote_id = "
			SELECT foreign_id 
			FROM project_workflow
			WHERE id = '$project_workflow_id'
			";
			$quote_id = $database->getOne($get_quote_id);
			
			$close_quote = "
			UPDATE quotes
			SET 
			`status` = '5',
			submitter = '$submitter',
			date_submitted = '$date_submitted'		
			WHERE id = '$quote_id'
			";
			$database->query($close_quote);
			
			logs::submit_logs(array("table" => "quotes", "action_type" => 5,"foreign_id" => $quote_id, "description" => "Changed Status from <b>".$status_ref[1]['name']."</b> to <b>".$status_ref[3]['name']."</b>"));										
			
		}
		else if(($task_id == 54) || ($task_id == 719) || ($task_id == 614) || ($task_id == 748))
		{
			$status_ref = common_ref_status::get_status("jobs");				
	
			$get_quote_id = "
			SELECT foreign_id 
			FROM project_workflow
			WHERE id = '$project_workflow_id'
			";
			$foreign_id = $database->getOne($get_quote_id);
			
			$close_quote = "
			UPDATE jobs
			SET 
			`status` = '52',
			submitter = '$submitter',
			date_submitted = '$date_submitted'		
			WHERE id = '$foreign_id'
			";
			$database->query($close_quote);
			
			logs::submit_logs(array(
				"table" => "jobs", 
				"action_type" => 52,
				"foreign_id" => $foreign_id, 
				"description" => "Changed Status from <b>".$status_ref[1]['name']."</b> to <b>".$status_ref[52]['name']."</b>"));		
		}	
		
		$result = $database->completeTrans();
		
		$status = "false";
		
		if($result)
			$status = "true";
		$reason ="Unknown error";
	}
	
	$results = array("status" => $status,"reasons"=>$reason);
	
	$json =  json_encode($results);	
	echo $json;
			
?>