<?
	$current_date_time = date('Y-m-d G:i:s');
	$submitter = $_SESSION['user']['id'];
	   
	$job_id = (int)$_POST['jobid'];
	$dept_id = (int)$_POST['department'];
	$hours=mysql_real_escape_string($_POST['hours']);
	$start=mysql_real_escape_string($_POST['start']);
	$end=mysql_real_escape_string($_POST['end']);
	$users=mysql_real_escape_string($_POST['users']);
	
	$start_date = explode('-',$start);
	$mysql_start = $start_date[2].'-'.$start_date[1].'-'.$start_date[0];
	
	$end_date = explode('-',$end);
	$mysql_end = $end_date[2].'-'.$end_date[1].'-'.$end_date[0];
	
	
	/*add validation here on the succession of workflow:
		1. Steel/Sheetmetal
		2. Vinyl Application
		3. Vinyl Printing
		4. Plastic/Moulding
		5. Electrical
		6. Paint
		7. Routing
		8. Assembly
		9. Packing 
		10. Loading
		
	 - check if the preceding id already exist, then compare the start date
	 - check the succeding id as well if already exist then compare the start date
	 ex. department_id =3,
	 	if department_id < 3 exists, compare start_date field with department_id=3
		if department_id > 3 exists, compare start_date field with department_id=3
	 
	 */
	 
	 $error = common_schedules::validate_precedence($job_id,$mysql_start,$dept_id);
	 
	 
	 if(strlen($error) == 0)
	 {
			
			$context = array(
					"job_id"		=> $job_id,
					"department_id"	=> $dept_id,
					"start_date"	=> $mysql_start,
					"end_date"		=> $mysql_end,
					"hours"			=> $hours,
					"users"			=> $users
					
						
						);
						
			$result=common_schedules::create_schedule($context);
							 
			logs::submit_logs(array("table" => "job_schedules", "action_type" => 1,"foreign_id" => $result, "description" => "Created"));
					
			  
	
	}
	$status = false;
	
	if($result)
		$status = true;
	else
		$status = false;

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