<?
	$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']);
	$sched_id=(int)($_POST['cal_id']);
	$action=(int)($_POST['action']);
	$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
	 
	 */
	 
	
	$database->StartTrans();
	
	if($action==1)
	{
	
	
		$error = common_schedules::validate_precedence($jobid,$mysql_start,$department);
	
		if(strlen($error)== 0 )
		{
			
			$context = array(
					"job_id"		=> $jobid,
					"dept_id"		=> $department,
					"mysql_start"	=> $mysql_start,
					"mysql_end"		=> $mysql_end,
					"hours"			=> $hours,
					"users"			=> $users,
					"id"			=> $cal_id
			);
			
			common_schedules::update_schedule($context);
					
		}
	}
	elseif($action==3)
	{
		
		$error = common_schedules::validate_precedence($jobid,$mysql_start,$department);
	
		if(strlen($error)== 0 )
		{
		
			$context = array(
					"job_id"		=> $jobid,
					"mysql_start"	=> $mysql_start,
					"mysql_end"		=> $mysql_end,
					"id"			=> $cal_id,
					"move"			=> $moveall,
					"delta"			=> $dayDelta
			);
			
			common_schedules::update_schedule_from_drag($context);
					
		}
		
		common_schedules::validate_succession($jobid,$mysql_start,$department);
		
	}
	else
	{
		common_schedules::remove_schedule($cal_id);
			
	}			
	
	logs::submit_logs(array("table" => "job_schedules", "action_type" => 2,"foreign_id" => $last_user_id, "description" => "Modified"));
	
	$result = $database->CompleteTrans(); 
		
	$status = false;
	
	if($result && strlen($error) == 0)
	$status = true;
	else
	$status = false;
	
	$results = array("status" => $status, "reasons" => $error );
	
	$json =  json_encode($results);	
	echo $json;
?>