<?php
	$user = "redmelon";
	$password = "7b&n)UYJt:4Qfpy2";
	$oldUserMetaData = array();
	$newUserMetaData = array();
	try {
		$db = new PDO('mysql:host=104.248.206.99;dbname=navacqs', $user, $password);
		$userQuery = $db->prepare('SELECT ID FROM cqs_users LIMIT 1');
		$userQuery->execute();
		$users = $userQuery->fetchAll();
		foreach($users as $user) {
			// print_r($user);
			$userMetaQuery = $db->prepare('SELECT umeta_id, meta_key, meta_value FROM cqs_usermeta WHERE user_id = :user_id');
			$userMetaQuery->execute(['user_id' => $user['ID']]);
			$userMetas = $userMetaQuery->fetchAll();
			foreach($userMetas as $userMeta) {
				$oldUserMetaData[$userMeta['meta_key']] = $userMeta['meta_value'];
				echo "<pre>";
				print_r($userMeta);
				echo "</pre>";
			}



			// GENERAL USER INFO
			if(array_key_exists('shipping_company', $oldUserMetaData)) {
			    $newUserBusinessOrPrivate = 'business';
			    $newUserMetaData['user_company'] 			= $oldUserMetaData['shipping_company'];
			}else{
				$newUserBusinessOrPrivate = 'private';
			}

			if($oldUserMetaData['shipping_title'] = 'De heer' || $oldUserMetaData['shipping_title'] = 'Herr'):
			    $newUserTitle = 'male';
			elseif($oldUserMetaData['shipping_title'] = 'Mevrouw' || $oldUserMetaData['shipping_title'] = 'Frau'):
			    $newUserTitle = 'female';
			else:
			    $newUserTitle = 'male';
			endif;

			$newUserMetaData['user_business_or_private']	= $newUserBusinessOrPrivate;
			$newUserMetaData['user_title']					= $newUserTitle;
			$newUserMetaData['user_first_name']				= $oldUserMetaData['shipping_first_name'];
			$newUserMetaData['user_last_name']				= $oldUserMetaData['shipping_last_name'];
			if(array_key_exists('shipping_phone', $oldUserMetaData)) {
			    $newUserMetaData['user_phone'] 				= $oldUserMetaData['shipping_phone'];
			}
			$newUserMetaData['user_email']					= $oldUserMetaData['shipping_email'];


			// BILLING
			if($oldUserMetaData['shipping_title'] = 'De heer' || $oldUserMetaData['shipping_title'] = 'Herr'):
			    $billingTitle = 'male';
			elseif($oldUserMetaData['shipping_title'] = 'Mevrouw' || $oldUserMetaData['shipping_title'] = 'Frau'):
			    $billingTitle = 'female';
			else:
			    $billingTitle = 'male';
			endif;

			if(array_key_exists('shipping_company', $oldUserMetaData)) {
			    $newUserMetaData['user_company'] 			= $oldUserMetaData['shipping_company'];
			}
			$newUserMetaData['billing_address_type']		= 'person';
			$newUserMetaData['billing_title']				= $billingTitle;
			$newUserMetaData['billing_first_name'] 			= $oldUserMetaData['shipping_first_name'];
			$newUserMetaData['billing_last_name'] 			= $oldUserMetaData['shipping_last_name'];
			$newUserMetaData['billing_email'] 				= $oldUserMetaData['shipping_email'];
			$newUserMetaData['billing_address_1'] 			= $oldUserMetaData['shipping_address_1'];
			if(array_key_exists('shipping_address_2', $oldUserMetaData)) {
				$newUserMetaData['billing_address_2'] 		= $oldUserMetaData['shipping_address_2'];
			}
			$newUserMetaData['billing_postcode'] 			= $oldUserMetaData['shipping_postcode'];
			$newUserMetaData['billing_city'] 				= $oldUserMetaData['shipping_city'];
			$newUserMetaData['billing_country'] 			= $oldUserMetaData['shipping_country'];
			if(array_key_exists('billing_btw_nummer', $oldUserMetaData)) {
				$newUserMetaData['billing_btw_nummer'] 		= $oldUserMetaData['billing_btw_nummer'];
			}
			if(array_key_exists('billing_referentie', $oldUserMetaData)) {
				$newUserMetaData['billing_reference'] 		= $oldUserMetaData['billing_referentie'];
			}



			// SHIPPING
			if($oldUserMetaData['billing_title'] = 'De heer' || $oldUserMetaData['billing_title'] = 'Herr'):
			    $shippingTitle = 'male';
			elseif($oldUserMetaData['billing_title'] = 'Mevrouw' || $oldUserMetaData['billing_title'] = 'Frau'):
			    $shippingTitle = 'female';
			else:
			    $shippingTitle = 'male';
			endif;

			if(array_key_exists('billing_company', $oldUserMetaData)) {
				$newUserMetaData['shipping_company'] 		= $oldUserMetaData['billing_company'];
			}
			$newUserMetaData['shipping_title']				= $shippingTitle;
			$newUserMetaData['shipping_first_name'] 		= $oldUserMetaData['billing_first_name'];
			$newUserMetaData['shipping_last_name'] 			= $oldUserMetaData['billing_last_name'];
			$newUserMetaData['shipping_address_1'] 			= $oldUserMetaData['billing_address_1'];
			if(array_key_exists('billing_address_2', $oldUserMetaData)) {
				$newUserMetaData['shipping_address_2'] 		= $oldUserMetaData['billing_address_2'];
			}
			$newUserMetaData['shipping_postcode']  			= $oldUserMetaData['billing_postcode'];
			$newUserMetaData['shipping_city']  				= $oldUserMetaData['billing_city'];
			$newUserMetaData['shipping_country']  			= $oldUserMetaData['billing_country'];

			// echo "<pre>";
			// print_r($oldUserMetaData);
			// print_r($newUserMetaData);
			// echo "</pre>";


			// foreach ($newUserMetaData as $key => $value) {
				// $updateUserMetaQuery = $db->prepare('INSERT INTO cqs_usermeta (meta_key, meta_value, user_id)');
				// $updateUserMetaQuery->execute([$key, $value, $user['ID']]);
			// }
		}

	} catch (PDOException $e) {
		print "Error!: " . $e->getMessage();
		die();
	}
 ?>