<?	

	global $database;
		$id = intval($_POST['id']);
		$status = intval($_POST['status']);
		$quote_id = intval($_POST['quote_id']);
		$task = mysql_real_escape_string($_POST['task']);
		$task_value = mysql_real_escape_string($_POST['task_value']);
		$current_date_time = date('Y-m-d G:i:s');
		 
		 $database->StartTrans();
 
		//update
		  $sql = "
				UPDATE quote_current_status
				SET  
				status = '$status',
				date_submitted = '$current_date_time' 
				WHERE id = '$id'
		 
		 
		 	   ";
		 
		 $database->query($sql);
		
 		logs::submit_logs(array("table" => "quote_current_status", "action_type" => 2,"foreign_id" => $id, "description" => "Modified"));
 
		if($task == "Client Payment" && $status==1){ //move to jobs
		
		
						//add to jobs table, this request is now a job!!!
					  $sql ="
								INSERT INTO jobs   (SELECT * FROM quotes WHERE id = '$quote_id')
								  
						";
						 $database->query($sql);
						 
						 logs::submit_logs(array("table" => "jobs", "action_type" => 1,"foreign_id" => $quote_id, "description" => "Created"));
						
						$update = "UPDATE jobs SET department_id='4' WHERE id='$quote_id'";
						$database->query($update);
						 
						 logs::submit_logs(array("table" => "jobs", "action_type" => 2,"foreign_id" => $quote_id, "description" => "Modified"));
						
						
						
						 //update request to tag it as job
						$update = "
									UPDATE quotes SET job_tag='1' ,status= '3', department_id ='4' WHERE id='$quote_id'
									";
						$database->query($update);	
								
						logs::submit_logs(array("table" => "quotes", "action_type" => 2,"foreign_id" => $id, "description" => "Modified"));
						
						// this job will now be monitored in departments_jobs table
						//$insert = "INSERT into departments_jobs (user_id,department_id,job_id,status,action_id,date_submitted)
									//VALUES('$user_id','$status_dept[0]','$id','$status_dept[1]','$action','$current_date_time')
									//";

						//$database->query($sql);
						
						//logs::submit_logs(array("table" => "departments_jobs", "action_type" => 1,"foreign_id" => $id, "description" => "Created"));
						
		
		}elseif($task == "Client Payment" && $status==0){ //revert back  to quotes
		
		
						 //update request to tag it as job
						$update = "
									UPDATE quotes SET job_tag='0', status='1', department_id='1' WHERE id='$quote_id'
									";
						$database->query($update);	
								
						logs::submit_logs(array("table" => "quotes", "action_type" => 2,"foreign_id" => $quote_id, "description" => "Modified"));
						
						$delete = "
									DELETE FROM jobs WHERE id = '$quote_id'
									";
						$database->query($delete);	
								
						logs::submit_logs(array("table" => "jobs", "action_type" => 3,"foreign_id" => $quote_id, "description" => "Deleted"));
									
		
		
		}elseif($task == 'Client Approval' && $status == 2){ //client cancels
		
						
						$update = "
									UPDATE quotes SET status='3', job_tag='2', department_id='1' WHERE id='$quote_id'
									";
						$database->query($update);
						logs::submit_logs(array("table" => "quotes", "action_type" => 2,"foreign_id" => $quote_id, "description" => "Modified"));
						
		
		}elseif($task == 'Client Approval' && $status == 0 || $task == 'Client Approval' && $status == 1){ //client cancels
		
						
						$update = "
									UPDATE quotes SET status='1', job_tag='0', department_id='1' WHERE id='$quote_id'
									";
						$database->query($update);
						logs::submit_logs(array("table" => "quotes", "action_type" => 2,"foreign_id" => $quote_id, "description" => "Modified"));
						
		}
		
		/* switch ($task){
		
		
			case 'Artwork':
			case 'Visual Art Mockup':
				$field = 'visualmockup_notes';
			break;
			case 'Costing':
				$field = 'production_notes'; 
			break;
			case 'Site Survey':
				$field = 'sitesurvey_notes'; 
			break;
			case 'Quote':
				$field = 'qualification_notes';
			break;
			case 'Site Inspection':
				$field = 'sitesurvey_notes';
			break;
			case 'Client Payment':
			case 'Deposit Invoice':
				$field = 'finance_notes';
			break;
			
		}
	 	 
		 if(!empty($field)){
					 $sql = "
					 UPDATE quotes set `".$field."` = '$task_value' 
					 WHERE id = '$quote_id'
					 ";
					
					$database->query($sql);
					logs::submit_logs(array("table" => "quotes", "action_type" => 2,"foreign_id" => $quote_id, "description" => "Modified"));
							
		 }*/
		$result = $database->CompleteTrans();
		  

	//$result = $result_arr['status'];
	$reasons = $result_arr['reasons'];	
//	$database->debug = true;
	
	//$results = false;
//	$results = true;
	
	if($result)
		$status = true;
	else
		$status = false;

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