<?php

require('include/initalizedb.php');

//print_r($_POST);

//print_r($_POST);//die;

//fill empty head start
if(isset($_POST['experience_head']) && empty($_POST['experience_head'])){ $_POST['experience_head'] = 'RENTAL HISTORY';}
if(!isset($_POST['eduaction']) || empty($_POST['eduaction'])){ $_POST['eduaction'] = 'WORK HISTORY';}
if(!isset($_POST['achievements']) || empty($_POST['achievements'])){ $_POST['achievements'] = 'SUMMERY';}
if(!isset($_POST['finance_head']) || empty($_POST['finance_head'])){ $_POST['finance_head'] = 'FINANCE';}
if(!isset($_POST['rental_head']) || empty($_POST['rental_head'])){ $_POST['rental_head'] = 'RENTAL READINESS';}
//fill empty head ends

$resume_id			= $_POST['resume_id'];
$user_id			= $_POST['user_id'];
$person_name		= $_POST['person_name'];
$person_sub_detail	= $_POST['person_sub_detail'];
$phone				= $_POST['phone'];
$Location			= $_POST['location'];
$email				= $_POST['email'];
$Link				= $_POST['link'];



$dataArray = array(
	'user_id'			=> $user_id,
	'person_name'		=> $person_name,
	'person_sub_detail'	=> $person_sub_detail,
	'phone'				=> $phone,
	'location'			=> $Location,
	'email'				=> $email,
	'link'				=> $Link,
);

// $response['dataArray'] = $dataArray;


//Saving image starts

if(!empty($resume_id) && isset($_POST['pic']) && !empty($_POST['pic'])) {
	$data = $_POST['pic'];

	list($type, $data) = explode(';', $data);
	list(, $data)      = explode(',', $data);
	$data = base64_decode($data);
	if (!file_exists('profile-image/'.$user_id.'/'.$resume_id)) {
	    mkdir('profile-image/'.$user_id.'/'.$resume_id, 0777, true);
	}
	file_put_contents('profile-image/'.$user_id.'/'.$resume_id.'/profile-pic.png', $data);
	//file_put_contents('profile-image/'.$user_id.'/3/profile-pic.png', $data);
	$response['type']		= 'Success';
	$response['message']	= 'Resume Saved';
	$response['update']		= 'yes';
	$response['resume_id']	= $resume_id;
}
else{
//Saving image ends



// print_r($dataArray);
if(!empty($user_id)) {
	if(!empty($resume_id)) {

		$where = array(
			'id' => $resume_id
		);

		$update_resume = $db->update("cv_user_resumes", $dataArray, $where);

		if($update_resume != null) {
			$response['type']		= 'Success';
			$response['message']	= 'Resume Saved';
			$response['update']		= 'yes';
			$response['resume_id']	= $resume_id;
		} else {
			$response['type']		= 'Failed';
			$response['message']	= 'Oops! Error Occured';
			$response['return']		= $resume_id;
		}

	} else {

		$insert_resumes = $db->insert("cv_user_resumes", $dataArray);
		if (!file_exists('profile-image/'.$user_id.'/'.$insert_resumes)) {
		    mkdir('profile-image/'.$user_id.'/'.$insert_resumes, 0777, true);
		}
		$path = 'profile-image/'.$user_id.'/'.$insert_resumes.'/profile-pic.png';
        $path2 = 'profile-image/profile-pic.png';
        copy($path2, $path);

		if($insert_resumes != null) {
			$response['type']		= 'Success';
			$response['message']	= 'Resume Saved';
			$response['resume_id']	= $insert_resumes;
		} else {
			$response['type'] = 'Failed';
			$response['message'] = 'Oops! Error Occured';
			$response['return']		= $insert_resumes;
		}

	}
} else {
	$response['type'] = 'Failed';
	$response['message'] = 'Please login first.';
}

//Saving Experience Starts
if(!empty($resume_id) && $resume_id != 0) {
	$experience_length = count($_POST['expirience_title']);
	$dataArrayExperience = array(
		'user_id' 	=> $user_id,
		'resume_id' => $resume_id,
		'experience_head' => $_POST['experience_head'],
		'title' 	=> json_encode($_POST['expirience_title']),
		'company' 	=> json_encode($_POST['company']),
		'exp_date' 	=> json_encode($_POST['Exp_Date']),
		'exp_location' 		=> json_encode($_POST['Expirience_location']),
		'company_heading' 	=> json_encode($_POST['company_discription_heading']),
		'company_desc' 		=> json_encode($_POST['company_discription'])
	);

	$res = $db->select("select * from cv_user_resumes_expirience where user_id = '$user_id' and resume_id = $resume_id");
	// $response['update'] = $res;
	if(empty($res)) {
		$insert_resumes_experience = $db->insert("cv_user_resumes_expirience", $dataArrayExperience);
		
	} else {
		$where = array(
			'user_id'	=> $user_id,
			'resume_id' => $resume_id
		);
		// $response['dataA'] = $dataArrayExperience;
		$update_resumes_experience = $db->update("cv_user_resumes_expirience", $dataArrayExperience, $where);
		// $response['updateResult'] = $update_resumes_experience;
	}
}
//Saving Experience Ends




//Saving Education Starts
if($resume_id != 0) {

	$dataArrayExperience = array(
		'user_id' 	=> $user_id,
		'resume_id' => $resume_id,
		'eduaction' => $_POST['eduaction'],
		'degree' 	=> json_encode($_POST['study']),
		'school' 	=> json_encode($_POST['school']),
		'edu_date' 	=> json_encode($_POST['edu_date']),
		'edu_location' 	=> json_encode($_POST['edu_location']),
		'edu_heading' 	=> json_encode($_POST['edu_heading']),
		'edu_detail' 	=> json_encode($_POST['edu_detail'])
	);

	$res = $db->select("select * from cv_user_resumes_education where user_id = '$user_id' and resume_id = $resume_id");
	// $response['update'] = $res;
	if(empty($res)) {
		$insert_resumes_experience = $db->insert("cv_user_resumes_education", $dataArrayExperience);
	} else {
		$where = array(
			'user_id'	=> $user_id,
			'resume_id' => $resume_id
		);
		// $response['dataA'] = $dataArrayExperience;
		$update_resumes_experience = $db->update("cv_user_resumes_education", $dataArrayExperience, $where);
		// $response['updateResult'] = $update_resumes_experience;
	}
}
//Saving Education Ends

//Saving Achievements Starts
if($resume_id != 0) {

	$dataArrayAchiv = array(
		'user_id' 	=> $user_id,
		'resume_id' => $resume_id,
		'achievements' => $_POST['achievements'],
		'achievements_detailes' 	=> json_encode($_POST['achievements_detailes'])
	);

	$AchRes = $db->select("select * from cv_user_resumes_achievements where user_id = '$user_id' and resume_id = $resume_id");
	// $response['update'] = $res;
	if(empty($AchRes)) {
		$insert_resumes_experience = $db->insert("cv_user_resumes_achievements", $dataArrayAchiv);
	} else {
		$where = array(
			'user_id'	=> $user_id,
			'resume_id' => $resume_id
		);
		// $response['dataA'] = $dataArrayExperience;
		$update_resumes_experience = $db->update("cv_user_resumes_achievements", $dataArrayAchiv, $where);
		// $response['updateResult'] = $update_resumes_experience;
	}
}
//Saving Achievements Ends


//Saving Finance Starts
if(!empty($resume_id) && $resume_id != 0) {
	$finance_length = count($_POST['annual_salary']);
	$dataArrayFinance = array(
		'user_id' 	=> $user_id,
		'resume_id' => $resume_id,
		'annual_salary' => json_encode($_POST['annual_salary']),
		'rental_range' 	=> json_encode($_POST['rental_range']),
		'credit_score' 	=> json_encode($_POST['credit_score']),
		'liquid_assets' 	=> json_encode($_POST['liquid_assets']),
		'finance_head' 		=> $_POST['finance_head']
		
	);

	$res = $db->select("select * from cv_user_resumes_finance where user_id = '$user_id' and resume_id = $resume_id");
	// $response['update'] = $res;
	if(empty($res)) {
		$insert_resumes_finance = $db->insert("cv_user_resumes_finance", $dataArrayFinance);
	} else {
		$where = array(
			'user_id'	=> $user_id,
			'resume_id' => $resume_id
		);
		// $response['dataA'] = $dataArrayExperience;
		$update_resumes_finance = $db->update("cv_user_resumes_finance", $dataArrayFinance, $where);
		// $response['updateResult'] = $update_resumes_experience;
	}
}
//Saving Finance Ends

//Saving Rentat Starts
if(!empty($resume_id) && $resume_id != 0) {
	$rental_length = count($_POST['rental_rule1']);
	$dataArrayRental = array(
		'user_id' 	=> $user_id,
		'resume_id' => $resume_id,
		'rental_rule1' => json_encode($_POST['rental_rule1']),
		'rental_rule2' 	=> json_encode($_POST['rental_rule2']),
		'rental_rule3' 	=> json_encode($_POST['rental_rule3']),
		'rental_head' 		=> $_POST['rental_head']
		
	);

	$res = $db->select("select * from cv_user_resumes_rental where user_id = '$user_id' and resume_id = $resume_id");
	// $response['update'] = $res;
	if(empty($res)) {
		$insert_resumes_rental = $db->insert("cv_user_resumes_rental", $dataArrayRental);
	} else {
		$where = array(
			'user_id'	=> $user_id,
			'resume_id' => $resume_id
		);
		// $response['dataA'] = $dataArrayExperience;
		$insert_resumes_rental = $db->update("cv_user_resumes_rental", $dataArrayRental, $where);
		// $response['updateResult'] = $update_resumes_experience;
	}
}
//Saving Rentat Ends
/*
//Saving Language Starts
if($resume_id != 0) {

	$dataArrayExperience = array(
		'user_id'		=> $user_id,
		'resume_id'		=> $resume_id,
		'language_head'	=> $_POST['language_head'],
		'languages' 	=> json_encode($_POST['languages']),
		'level'			=> json_encode($_POST['rating'])
	);

	$res = $db->select("select * from cv_user_resumes_languages where user_id = '$user_id' and resume_id = $resume_id");
	if(empty($res)) {
		$insert_resumes_experience = $db->insert("cv_user_resumes_languages", $dataArrayExperience);
	} else {
		$where = array(
			'user_id'	=> $user_id,
			'resume_id' => $resume_id
		);
		$update_resumes_experience = $db->update("cv_user_resumes_languages", $dataArrayExperience, $where);
	}

}
//Saving Language Ends

//Saving Projects Starts
if($resume_id != 0) {

	$dataArrayExperience = array(
		'user_id' 			=> $user_id,
		'resume_id' 		=> $resume_id,
		'project_head' 		=> $_POST['project_head'],
		'project' 			=> json_encode($_POST['projects']),
		'project_date'		=> json_encode($_POST['project_date']),
		'project_location'	=> json_encode($_POST['project_location']),
		'work_summary' 		=> json_encode($_POST['work_summary']),
		'work_description' 	=> json_encode($_POST['work_discription'])
	);
	// $response['pro_work_description'] = $dataArrayExperience;
	$res = $db->select("select * from cv_user_resumes_projects where user_id = '$user_id' and resume_id = $resume_id");
	// $response['update'] = $res;
	if(empty($res)) {
		$insert_resumes_experience = $db->insert("cv_user_resumes_projects", $dataArrayExperience);
	} else {
		$where = array(
			'user_id'	=> $user_id,
			'resume_id' => $resume_id
		);
		// $response['dataA'] = $dataArrayExperience;
		$update_resumes_experience = $db->update("cv_user_resumes_projects", $dataArrayExperience, $where);
		// $response['updateResult'] = $update_resumes_experience;
	}
}
}
//Saving Projects Ends
*/
}
print json_encode($response);