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

	 
	
	$formtag = (int)$_POST['formtag'];
	$submitter = $_SESSION['user']['id'];
	if($formtag == 1)
	{
	
		$department_name	=	mysql_real_escape_string($_POST['department_name']);
		$department			=	mysql_real_escape_string($_POST['department']);
		$manual_entry 		=	(int)$_POST['manual_entry'];
		
		$status 			=	(int)$_POST['status'];
		
		$insert  = "
				INSERT INTO production_departments
					SET
				department = '$department',
				department_name = '$department_name',
				 
				manual_entry = '$manual_entry',
				status = '1',
				creator = '$user_id',
				date_created = '$current_date_time',
				submitter = '$submitter',
				date_submitted = '$current_date_time'
			";
		$table='production_departments';
			
	
	}
	else
	{
	
		$labour_name			=	mysql_real_escape_string($_POST['labour_name']);
		$rate 					=	(float)$_POST['rate'];
		$fieldtype 				=	mysql_real_escape_string($_POST['fieldtype']);
		$production_departments_id =	(int)$_POST['production_departments_id'];
		$status 				=	(int)$_POST['status'];
		
		$insert  = "
				INSERT INTO production_departments_sub
					SET
				labour_name = '$labour_name',
				rate = '$rate',
				production_departments_id = '$production_departments_id',
				fieldtype = '$fieldtype',
				status = '1',
				creator = '$user_id',
				date_created = '$current_date_time',
				submitter = '$submitter',
				date_submitted = '$current_date_time'
			";
		$table='production_departments_sub';
	
	}
	$database->StartTrans();
	
	
	$database->getRow($insert);
	$last_user_id = $database->insert_ID();
			 
	logs::submit_logs(array("table" => $table, "action_type" => 1,"foreign_id" => $last_user_id, "description" => "Created"));
			
	$result = $database->CompleteTrans(); 
	
	$status = false;
	
	if($result)
		$status = true;
	else
		$status = false;

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