<?
//header("Access-Control-Allow-Origin: *");

### DO THIS FIRST:
require_once("/BANGK!/master_config.php");
require_once($master_config_root_path . "shared/functions.shared");
$active_user_session_timeout = "OFF"; // no session timeout on this page
require_once($master_config_root_path . "shared/session.shared");

//logger3("_SESSION['template']['company']",$_SESSION['template']['company']);
//logger3("0_SESSION['support_action']",$_SESSION['support_action']);
//logger3("_GET['password']",$_GET['password']);
//logger3("_SESSION['template']['company']['file_path']",$_SESSION['template']['company']['file_path']);

### START SESSION VERIFICATION (ALWAYS LAST B4 REST OF PAGES):
$verified_member = "no";
$verified_business = "no";
$verified_transaction = "no";
$verified_banned = "no";
$verified_acccess = "no";
$secured_server = "no";
include($_SESSION['template']['company']['file_path'] . "shared/start_verified_session.shared");
#
#
#
log_traffic_stats();


$incoming_vars = "";
$incoming_vars = array();
if($_POST) $incoming_vars = $_POST;
if(empty($incoming_vars)) $incoming_vars = $_GET;


logger3("


########################################################################################
########################################################################################
########################################################################################
########################################################################################
########################################################################################
########################################################################################
########################################################################################
########################################################################################
### NEW SESSION:  [" . $_SERVER['SCRIPT_NAME'] . "]
########################################################################################
########################################################################################

",$incoming_vars);
#
#
#
### START: SESSIONS & STUFF:


/*
	
	
https://gateway.intelitruth.com/get_report.api?BUSINESS_ACCOUNT_ID=3a6da00835cdabdf8a8cf86139cfaa1b&API_KEY=03ee1dbe64d313f5e3d8c4cb54a0a773&MEMBER_ID=fa066b928167eae2dfa39b10540f27f1
	
	
*/


########################################################################################
########################################################################################
### BUSINESS ACCOUNT

$incoming_vars['BUSINESS_ACCOUNT_ID'] = '0159985267bebdf90d22c242941cd8bb';
$incoming_vars['API_KEY'] = 'e37c6909baf009a0ff85e4ad7f8597f8';
//$incoming_vars['MEMBER_ID'] = '0d00f1a6775b0a55c370bf552114370a';

if(!$incoming_vars['BUSINESS_ACCOUNT_ID']) {
	$response = "";
	$response = array();
	$response['ERROR'] = "Missing BUSINESS_ACCOUNT_ID";
	echo json_encode($response);
	exit;
}


if(!$incoming_vars['API_KEY']) {	
	$response = "";
	$response = array();
	$response['ERROR'] = "Missing API_KEY";
	echo json_encode($response);
	exit;
}

$whitelabel_business_account_details = "";
$tmp_sql = "SELECT *
			FROM accounts
			WHERE hash = '". trim($incoming_vars['BUSINESS_ACCOUNT_ID']) ."'
			;";
//logger3("tmp_sql",$tmp_sql);
$whitelabel_business_account_details = object_to_array_v2(readTHECASHIER($tmp_sql));
//logger3("whitelabel_business_account_details",$whitelabel_business_account_details);

if(!$whitelabel_business_account_details['hash']) {
	$response = "";
	$response = array();
	$response['ERROR'] = "Invalid BUSINESS_ACCOUNT_ID";
	echo json_encode($response);
	exit;
}


$whitelabel_business_account_details = "";
$tmp_sql = "SELECT *
			FROM accounts
			WHERE hash = '". trim($incoming_vars['BUSINESS_ACCOUNT_ID']) ."'
			AND intelitruth_service_api_key = '". trim($incoming_vars['API_KEY']) ."'
			;";
$whitelabel_business_account_details = object_to_array_v2(readTHECASHIER($tmp_sql));
logger3("whitelabel_business_account_details",$whitelabel_business_account_details);

if(!$whitelabel_business_account_details['hash']) {
	$response = "";
	$response = array();
	$response['ERROR'] = "Invalid API_KEY";
	echo json_encode($response);
	exit;
}


if(!stristr($whitelabel_business_account_details['intelitruth_service_api'],"ON")) {
	$response = "";
	$response = array();
	$response['ERROR'] = "API service is currently disabled for this account.  Please enable this service in your administrative on-boarding settings and/or contact customer support for additional assistance: api.support@inteliteuth.com";
	echo json_encode($response);
	exit;
}


########################################################################################
########################################################################################
### MEMBER

//logger3("incoming_vars",$incoming_vars,"OFF");
//logger3("whitelabel_business_account_details",$whitelabel_business_account_details,"OFF");

$member_details = "";
$tmp_sql = "SELECT *
			FROM members
			WHERE firstname!=''
			ORDER BY memberid DESC
			LIMIT 5
			;";
//logger3("tmp_sql",$tmp_sql,"OFF");

$member_details_array = object_to_array_v2(readarrayTHECASHIER($tmp_sql));
//logger3("member_details",$member_details,"OFF");
logger3('', $member_details);


if(!$member_details_array) {
	$response = "";
	$response = array();
	$response['ERROR'] = "No data found";
	echo json_encode($response);
	exit;
}


$final_response_array = [];
$final_response_array['STATUS'] = "SUCCESS";
$final_response_array['MESSAGE'] = "MEMBER REPORT";

foreach($member_details_array as $member_details){


	$master_datetime = datetime_v2();
	logger3("master_datetime",$master_datetime);
	
	
	$whitelabel_business_account_hash = addslashes($incoming_vars['BUSINESS_ACCOUNT_ID']);
	$member_hash = addslashes($member_details['hash']);
	
	
	$tmp_sql = "SELECT *
				FROM accounts
				WHERE creator_member_hash = '". $member_hash ."'
				AND accounttype = 'PERSONAL'
				ORDER BY created DESC
				LIMIT 1
				;";
	$personal_acount_details_array = object_to_array_v2(readTHECASHIER($tmp_sql));
	
	
	$tmp_sql = "SELECT *
				FROM accounts
				WHERE creator_member_hash = '". $member_hash ."'
				AND accounttype = 'BUSINESS'
				ORDER BY created DESC
				LIMIT 1
				;";
	$busines_acount_details_array = object_to_array_v2(readTHECASHIER($tmp_sql));
	
	
	$onboarding_preferences_form_name = "DEFAULT";
	if($busines_acount_details_array['business_subcategory']) $onboarding_preferences_form_name = $busines_acount_details_array['business_subcategory'];
	
	
	$onboarding_preferences_form_name = decode_business_subcategory($onboarding_preferences_form_name);
	
	$tmp_sql = "SELECT * 
				FROM onboarding_preferences
				WHERE whitelabel_business_account_hash = '". $whitelabel_business_account_hash ."'
				AND form_name = '". addslashes($onboarding_preferences_form_name) ."'
				;";
	$whitelabel_business_onboarding_preferences_array = object_to_array_v2(readTHECASHIER($tmp_sql,"intelitruth"));
	
	
	/// DETERMINE IF THE PROFILE IS a FIRST-TIME SUBMISSION, and STILL PENDING:
	
	$_XXXXX_end_realtime_process_stage = "OFAC_SDN_XML";
	$tmp_sql = "SELECT hash
				FROM AML_scan_results
				WHERE member_hash = '". $member_hash ."'
				AND status = 'COMPLETE'
				AND process_stage = '". $_XXXXX_end_realtime_process_stage ."'
				;";
	logger3("tmp_sql",$tmp_sql,"OFF");
	$profile_is_pending = getTHECASHIER($tmp_sql,"intelitruth");
	logger3("profile_is_pending",$profile_is_pending,"OFF");
	
	
	############################################################################
	############################################################################
	############################################################################
	############################################################################
	############################################################################
	############################################################################
	############################################################################
	############################################################################
	############################################################################
	### GENERATE REPORT:
	############################################################################
	############################################################################
	############################################################################
	############################################################################
	############################################################################
	############################################################################
	############################################################################
	############################################################################
	############################################################################
	
	
	unset($response);
	$response = array();
	
	
	$_XXXXX_RUNNING_TOTAL_RISK_SCORE = 0;
	$_XXXXX_MINIMUM_OCR_MATCHES = 2;
	
	
	############################################################################
	############################################################################
	############################################################################
	### GLOBAL•KYC:
	
	$response['global_kyc'] = "";
	
	
	/*
	$response['global_kyc']['verified_phone_number'] = "N/A"; // TRUE  // NA
	if(stristr($whitelabel_business_onboarding_preferences_array['onboarding_account_registration_process'],"verified_sms")) {
		$response['global_kyc']['verified_phone_number'] = "TRUE";
	}
	
	
	$tmp_sql = "SELECT *
				FROM phone_numbers
				WHERE member_hash = '". $member_details['hash'] ."'
				AND status = 'VERIFIED'
				ORDER BY created DESC
				LIMIT 1
				;";
	$phone_numbers_details = object_to_array_v2(readTHECASHIER($tmp_sql));
	
	$whitepages_data = json_decode($phone_numbers_details['whitepages_data']);
	$whitepages_data_array = object_to_array_v2($whitepages_data);
	
	
	//////////////////////
	
	$response['global_kyc']['first_name_matches_phone_records'] = "N/A"; // TRUE / FALSE / UNKNOWN  // NA
	
	if(stristr($member_details['firstname'],$phone_numbers_details['whitepages_data'])) {
		$response['global_kyc']['first_name_matches_phone_records'] = "TRUE";
	} else if($response['global_kyc']['verified_phone_number'] == "TRUE") {
		$response['global_kyc']['first_name_matches_phone_records'] = "FALSE";
	}
	
	
	//////////////////////
	
	$response['global_kyc']['last_name_matches_phone_records'] = "N/A"; // TRUE / FALSE / UNKNOWN // NA
	
	if(stristr($member_details['lastname'],$phone_numbers_details['whitepages_data'])) {
		$response['global_kyc']['last_name_matches_phone_records'] = "TRUE";
	} else if($response['global_kyc']['verified_phone_number'] == "TRUE") {
		$response['global_kyc']['last_name_matches_phone_records'] = "FALSE";
	}
	
	
	//////////////////////
	$response['global_kyc']['birthdate_matches_phone_records'] = "N/A";
	foreach($whitepages_data_array['belongs_to'] as $KEY => $belongs_to_details) {
		
		if($belongs_to_details['age_range']) {
			$age_range = explode("-",$belongs_to_details['age_range']);
			$years_ago = time_ago($member_details['birthdate']);
			
			if($years_ago >= $age_range[0] && $years_ago <= $age_range[0]) {
				$response['global_kyc']['birthdate_matches_phone_records'] = "TRUE";
				break;
			} else {
				$response['global_kyc']['birthdate_matches_phone_records'] = "FALSE";
			}
		}
	}
	
	
	//////////////////////
	$response['global_kyc']['selfie_face_biometric_detected'] = "N/A"; // TRUE / FALSE / NA
	$tmp_sql = "SELECT *
				FROM ids_personal
				WHERE selfie_filename != ''
				AND member_hash = '". $member_details['hash'] ."'
				ORDER BY datetime_created DESC
				LIMIT 1
				;";
	$selfie_filename_details = object_to_array_v2(readTHECASHIER($tmp_sql));
	if($selfie_filename_details['selfie_azure_face_biometric_id']) {
		$response['global_kyc']['selfie_face_biometric_detected'] = "TRUE";
	} else {
		$response['global_kyc']['selfie_face_biometric_detected'] = "FALSE";
	}
	
	
	//////////////////////
	$response['global_kyc']['photo_id_face_biometric_detected'] = "N/A"; // TRUE / FALSE / NA
	$tmp_sql = "SELECT *
				FROM ids_personal
				WHERE photo_id_filename != ''
				AND member_hash = '". $member_details['hash'] ."'
				ORDER BY datetime_created DESC
				LIMIT 1
				;";
	$photo_id_filename_details = object_to_array_v2(readTHECASHIER($tmp_sql));
	if($photo_id_filename_details['selfie_azure_face_biometric_id']) {
		$response['global_kyc']['photo_id_azure_face_biometric_id'] = "TRUE";
	} else {
		$response['global_kyc']['photo_id_azure_face_biometric_id'] = "FALSE";
	}
	
	
	$response['global_kyc']['selfie_face_biometric_matches_photo_id_face_biometric'] = "N/A"; // NA
	$tmp_sql = "SELECT *
				FROM face_biometric_matches
				WHERE ids_personal_hash_1 = '". $selfie_filename_details['hash'] ."'
				AND ids_personal_hash_2 = '". $photo_id_filename_details['hash'] ."'
				LIMIT 1
				;";
	$photo_id_filename_details = object_to_array_v2(readTHECASHIER($tmp_sql,"intelitruth"));
	if($photo_id_filename_details['hash']) {
		$response['global_kyc']['selfie_face_biometric_matches_photo_id_face_biometric'] = $photo_id_filename_details['match_score'];
	}
	
	
	if(!$photo_id_filename_details['hash']) {
		$tmp_sql = "SELECT *
					FROM face_biometric_matches
					WHERE ids_personal_hash_2 = '". $selfie_filename_details['hash'] ."'
					AND ids_personal_hash_1 = '". $photo_id_filename_details['hash'] ."'
					LIMIT 1
					;";
		$photo_id_filename_details = object_to_array_v2(readTHECASHIER($tmp_sql,"intelitruth"));
		if($photo_id_filename_details['hash']) {
			$response['global_kyc']['selfie_face_biometric_matches_photo_id_face_biometric'] = $photo_id_filename_details['match_score'];
		}
	}
	
	
	$response['global_kyc']['firstname_found_on_photo_id'] = "N/A"; // TRUE / FALSE / NA
	$response['global_kyc']['lastname_found_on_photo_id'] = "N/A"; // TRUE / FALSE / NA
	
	$response['global_kyc']['firstname_found_on_proof_of_residence'] = "N/A"; // TRUE / FALSE / NA
	$response['global_kyc']['lastname_found_on_proof_of_residence'] = "N/A"; // TRUE / FALSE / NA
	
	
	$response['global_kyc']['business_name_found_on_proof_of_business_registration'] = "N/A"; // TRUE / FALSE / NA
	$response['global_kyc']['first_name_found_on_proof_of_business_registration'] = "N/A"; // TRUE / FALSE / NA
	$response['global_kyc']['last_name_found_on_proof_of_business_registration'] = "N/A"; // TRUE / FALSE / NA
	
	$response['global_kyc']['business_name_found_on_proof_of_business_banking'] = "N/A"; // TRUE / FALSE / NA
	$response['global_kyc']['first_name_found_on_proof_of_business_banking'] = "N/A"; // TRUE / FALSE / NA
	$response['global_kyc']['last_name_found_on_proof_of_business_banking'] = "N/A"; // TRUE / FALSE / NA
	
	$response['global_kyc']['business_name_found_on_proof_of_business_taxes'] = "N/A"; // TRUE / FALSE / NA
	$response['global_kyc']['first_name_found_on_proof_of_business_taxes'] = "N/A"; // TRUE / FALSE / NA
	$response['global_kyc']['last_name_found_on_proof_of_business_taxes'] = "N/A"; // TRUE / FALSE / NA
	*/
	
	$response['global_kyc'] = "";
	$response['global_kyc'] = "";
	$response['global_kyc']['risk_score'] = "PENDING";
	$response['global_kyc']['flag_list'] = "--";
	
	
	$ADD_STATUS = "AND (status = '' OR status = 'PENDING')";
	$tmp_sql = "SELECT hash
				FROM api_search_engine_results
				WHERE member_hash = '". $member_details['hash'] . "'
				AND api_service_name = 'BING Search Engine API' 
				$ADD_STATUS
				LIMIT 1
				;";
	//logger3("tmp_sql",$tmp_sql,"OFF");
	$member_incomplete_scan_hash = getTHECASHIER($tmp_sql,"intelitruth");
	logger3("member_incomplete_scan_hash",$member_incomplete_scan_hash,"OFF");
	
	if($member_incomplete_scan_hash) {
	
		$response['global_kyc']['risk_score'] = "PENDING";
		$response['global_kyc']['flag_list'] = "N/A";
	
	} else {	
	
		$ADD_STATUS = "AND status = 'COMPLETE'";
		$tmp_sql = "SELECT *
					FROM api_search_engine_results
					WHERE member_hash = '". $member_details['hash'] . "'
					AND api_service_name = 'BING Search Engine API' 
					$ADD_STATUS
					ORDER BY datetime_created 
					DESC
					;";
		//logger3("tmp_sql",$tmp_sql,"OFF");
		$api_search_engine_results_array = readarrayTHECASHIER($tmp_sql,"intelitruth");
		logger3("api_search_engine_results_array",$api_search_engine_results_array,"OFF");
		
		
		$final_search_results = "";
		//logger3("0-final_search_results",$final_search_results,"OFF");
		
		
		$flag_details_key = 0;
		foreach($api_search_engine_results_array AS $flag_key => $row_details) {
			
			
			//logger3("row_details",$row_details,"OFF");
			
			//if(stristr($row_details['status'],"COMPLETE")) {
			
			
			$serialized_search_results = unserialize($row_details['serialized_search_results']);
			
			//logger3("serialized_search_results",$serialized_search_results,"OFF");
			
			//$serialized_search_results_json_decode = json_decode($serialized_search_results);
			
			//logger3("serialized_search_results_json_decode",$serialized_search_results_json_decode,"OFF");
			
			//$count = count($serialized_search_results_json_decode['results']);
			//logger3("count",$count,"OFF");
			
			
			logger3("response",$response,"OFF");
			
			if(stristr($serialized_search_results,"no flags found")) {
				
				// $response['global_kyc']['risk_score'] = "0";
				// $response['global_kyc']['flag_list'] = "NONE";
			
			
			} else {
			
			
				$serialized_search_results_json_decode = object_to_array_v2(json_decode());
				
				//logger3("serialized_search_results_json_decode",$serialized_search_results_json_decode,"OFF");
				
				
				$api_search_engine_results_loop = $serialized_search_results_json_decode['api_search_engine_results']['api_search_engine_results'];
				if(!$api_search_engine_results_loop) $api_search_engine_results_loop = $serialized_search_results_json_decode['api_search_engine_results'];
				if(!$api_search_engine_results_loop) $api_search_engine_results_loop = $serialized_search_results_json_decode;
				
				
				//logger3("api_search_engine_results_loop",$api_search_engine_results_loop,"OFF");
				
				
				foreach($api_search_engine_results_loop AS $global_kyc_key => $global_kyc_details) {
					
					//logger3("global_kyc_details",$global_kyc_details,"OFF");
					
					$global_kyc_details = object_to_array_v2($global_kyc_details);
					
					$global_kyc_flag_list[$flag_details_key]['source'] = $global_kyc_details['url'];
					
					$global_kyc_details_name_stripped = strip_tags($global_kyc_details['name']);
					$global_kyc_flag_list[$flag_details_key]['text'] = substr($global_kyc_details_name_stripped,0,150);
					
					$flag_details_key = $flag_details_key + 1;
				}
				
				$response['global_kyc']['risk_score'] = count($global_kyc_flag_list);
				$response['global_kyc']['flag_list'] = $global_kyc_flag_list;
		
		
			}	
		}
	}	
	
	
	//logger3("response",$response,"OFF");
	
	
	############################################################################
	############################################################################
	############################################################################
	### BIOMETRIC•AML:
	
	/// runs the OFAC REPORT
	//require_once($master_config_root_path . "gateway/intelitrith_aml_scan_basket_CRON_realtime.gate");
	
	
	$response['biometric_aml'] = "";
	
	
	$tmp_sql = "SELECT *
				FROM AML_scan_results
				WHERE member_hash = '". $member_details['hash'] ."'
				AND results_list_name != ''
				AND status = 'COMPLETE'
				;";
	logger3("tmp_sql",$tmp_sql,"OFF");
	$list_of_watchlists_found = object_to_array_v2(readarrayTHECASHIER($tmp_sql,"intelitruth"));
	
	logger3("list_of_watchlists_found",$list_of_watchlists_found,"OFF");
	
	
	//if(!$list_of_watchlists_found) $response['biometric_aml']['risk_score'] = 0;
	
	$response['biometric_aml']['risk_score'] = 0;
	
	//$response['biometric_aml']['risk_score'] = count($list_of_watchlists_found);
	
	foreach($list_of_watchlists_found AS $key_watchlists => $list_details) {
		
		//logger3("1-list_details['results_list_name']",$list_details['results_list_name'],"OFF");
		
		//logger3("1-list_details['results_list_name']",$list_details['results_list_name'],"OFF");
		
		$response['biometric_aml']['flag_list'][$key_watchlists] = $list_details['results_list_name'];
		
		//logger3("2-response['biometric_aml']['flag_list'][$key_watchlists]",$response['biometric_aml']['flag_list'][$key_watchlists],"OFF");
		
		$_XXXXX_RUNNING_TOTAL_RISK_SCORE = $_XXXXX_RUNNING_TOTAL_RISK_SCORE + $list_details['risk_score'];
		
		$response['biometric_aml']['risk_score'] = $response['biometric_aml']['risk_score'] + $list_details['risk_score'];
		
	}
	
	if(!$response['biometric_aml']['flag_list'][0]) $response['biometric_aml']['flag_list'] = 0;
	
	$AML_COMPLETE = "TRUE";
	
	
	//$response['biometric_aml']['target_found'] = "FALSE";
	
	//$response['biometric_aml']['OFAC_SDN']['first_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['OFAC_SDN']['last_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['OFAC_SDN']['first_last_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['OFAC_SDN']['business_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['OFAC_SDN'] = "N/A"; // 1 / 0 / NA
	
	//$response['biometric_aml']['OFAC_CONSOLODATED']['first_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['OFAC_CONSOLODATED']['last_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['OFAC_CONSOLODATED']['first_last_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['OFAC_CONSOLODATED']['business_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['OFAC_CONSOLODATED'] = "N/A"; // 1 / 0 / NA
	
	//$response['biometric_aml']['FBI_FEDERAL_BUREAU_OF_INVESTIGATION']['first_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['FBI_FEDERAL_BUREAU_OF_INVESTIGATION']['last_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['FBI_FEDERAL_BUREAU_OF_INVESTIGATION']['first_last_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['FBI_FEDERAL_BUREAU_OF_INVESTIGATION']['business_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['FBI_FEDERAL_BUREAU_OF_INVESTIGATION'] = "N/A"; // 1 / 0 / NA
	
	//$response['biometric_aml']['PEP_POLITICALLY_EXPOSED_PEOPLE']['first_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['PEP_POLITICALLY_EXPOSED_PEOPLE']['last_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['PEP_POLITICALLY_EXPOSED_PEOPLE']['first_last_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['PEP_POLITICALLY_EXPOSED_PEOPLE']['business_name'] = "TRUE"; // TRUE / FALSE / NA
	///$response['biometric_aml']['PEP_POLITICALLY_EXPOSED_PEOPLE'] = "N/A"; // 1 / 0 / NA
	
	//$response['biometric_aml']['INTERPOL']['first_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['INTERPOL']['last_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['INTERPOL']['first_last_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['INTERPOL']['business_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['biometric_aml']['INTERPOL'] = "N/A"; // 1 / 0 / NA
	
	
	//$response['biometric_aml']['target_found_in_these_lists'][0] = "NOT FOUND";
	//$response['biometric_aml']['list_name'][0] = "PEP";
	//$response['biometric_aml']['list_name'][1] = "OFAC";
	
	
	/*
	$tmp_sql = "SELECT *
				FROM AML_scan_results
				WHERE whitelabel_business_account_hash = '". $_SESSION['intelitruth']['whitelabel_business_account_details']['hash'] . "'
				AND search_term != ''
				AND results_list_name = '". $_XXXXX_results_list_name ."'
				ORDER BY datetime_created 
				DESC
				;";
	*/
	
	//logger3("response",$response,"OFF");	
	
	if($AML_COMPLETE != "TRUE") {
	
	//$ADD_STATUS = "AND status = 'COMPLETE'";
	$ADD_STATUS = "AND (status = '' OR status = 'PENDING')";
	$tmp_sql = "SELECT hash
				FROM api_search_engine_results
				WHERE member_hash = '". $member_details['hash'] . "'
				AND api_service_name != 'BING Search Engine API' 
				AND api_service_name != 'ibm_watson_news'
				AND api_service_name != 'SPIDER'
				$ADD_STATUS
				LIMIT 1
				;";
	//logger3("tmp_sql",$tmp_sql,"OFF");
	$member_incomplete_scan_hash = getTHECASHIER($tmp_sql,"intelitruth");
	//logger3("member_incomplete_scan_hash",$member_incomplete_scan_hash,"OFF");
	
	
	if($member_incomplete_scan_hash) {
	
		logger3("1-member_incomplete_scan_hash",$member_incomplete_scan_hash,"OFF");
		
		$response['biometric_aml']['risk_score'] = "PENDING";
		$response['biometric_aml']['flag_list'] = "N/A";
	
	
	} else {	
		
		
		logger3("2-member_incomplete_scan_hash",$member_incomplete_scan_hash,"OFF");
		
	
		$_XXXXX_results_list_name = ""; // blank because these are targets.  target results / DETAILS will have results_list_name != "";
		//$ADD_results_list_name = "AND results_list_name = '". $_XXXXX_results_list_name ."'";
		$ADD_search_term = "AND search_term != ''";
		
		$tmp_sql = "SELECT *
					FROM api_search_engine_results
					WHERE member_hash = '". $member_details['hash'] . "'
					AND api_service_name != 'BING Search Engine API' 
					AND api_service_name != 'ibm_watson_news'
					AND api_service_name != 'SPIDER'
					$ADD_STATUS
					$ADD_results_list_name
					$ADD_search_term
					ORDER BY datetime_created 
					DESC
					;";
		//logger3("tmp_sql",$tmp_sql,"OFF");
			
		$api_search_engine_results_array = object_to_array_v2(readarrayTHECASHIER($tmp_sql,"intelitruth"));
		//logger3("api_search_engine_results_array",$api_search_engine_results_array,"OFF");
		
		
		$api_search_engine_results_array = json_decode($api_search_engine_results_array);
		//logger3("api_search_engine_results_array",$api_search_engine_results_array,"OFF");
		
		
		if(!$api_search_engine_results_array[0]) {
			$api_search_engine_results_array[0]['search_term'] = "[no targets]"; // when no URLS are set
			$INTELITRUTH_REPORT_URL_DISABLED = "style='display:none;'";
		}
			
			
		# if($incoming_vars['download_INTELITRUTH_REPORT'] == "TRUE") {
		# 	include($_SESSION['template']['company']['file_path'] . "shared/XLSX_CREATOR/INTELITRUTH_REPORT_START.php");
		# }
		
		$complete_INTELITRUTH_REPORT = "";
		
		foreach($api_search_engine_results_array AS $key => $api_search_engine_results_row_details) {
			
			
			//logger3("api_search_engine_results_row_details",$api_search_engine_results_row_details,"OFF");
			
			//exit;
			
			//logger3("api_search_engine_results_row_details['whitelabel_business_account_hash']",$api_search_engine_results_row_details['whitelabel_business_account_hash'],"OFF");
			
			//logger3("api_search_engine_results_row_details['search_term']",$api_search_engine_results_row_details['search_term'],"OFF");
			
			$consolodate_aml_searches_results = consolodate_aml_searches_into_one_array_for_display($api_search_engine_results_row_details['whitelabel_business_account_hash'],$api_search_engine_results_row_details['search_term']);
		
			logger3("consolodate_aml_searches_results",$consolodate_aml_searches_results,"OFF");
			
			
			$consolodate_aml_searches_results = array_filter($consolodate_aml_searches_results);
			//logger3("consolodate_aml_searches_results",$consolodate_aml_searches_results,"OFF"); 
			$number_of_flags = count($consolodate_aml_searches_results);
			
				
		}
		
		
		//logger3("number_of_flags",$number_of_flags,"OFF"); 
		
		//logger3("consolodate_aml_searches_results",$consolodate_aml_searches_results,"OFF"); 
			
		$response['biometric_aml']['risk_score'] = 0;
		if($number_of_flags > 0) $response['biometric_aml']['risk_score'] = $number_of_flags;
		
		
		foreach($consolodate_aml_searches_results AS $aml_lists_key => $consolodate_aml_searches_results_details) {
			
			
			//logger3("consolodate_aml_searches_results_details",$consolodate_aml_searches_results_details,"OFF");
			//exit;
			//logger3("aml_lists_key",$aml_lists_key,"OFF");
			//if($aml_lists_key == 0) $aml_lists_key = "0";
			
		
			//logger3("consolodate_aml_searches_results_details",$consolodate_aml_searches_results_details,"OFF");
			
		
			//$flag_list[$aml_lists_key['source'] = $response['biometric_aml']['flag_list'][$aml_lists_key]['source']);
			//$flag_list[$aml_lists_key]['text'] = object_to_array_v2($response['biometric_aml']['flag_list'][$aml_lists_key]['text']);
			
		
			$biometric_aml_flag_list[$aml_lists_key]['source'] = $consolodate_aml_searches_results_details['results_list_name'];
			$biometric_aml_flag_list[$aml_lists_key]['text'] = $consolodate_aml_searches_results_details['results_list_text'];
		}
		
		//logger3("0-biometric_aml_flag_list",$biometric_aml_flag_list,"OFF");
		
		
		$response['biometric_aml']['flag_list'] = 0;
		$response['biometric_aml']['flag_list'] = array();
		$response['biometric_aml']['flag_list'] = object_to_array_v2($biometric_aml_flag_list);
			
		//logger3("2-response['biometric_aml']['flag_list']",$response['biometric_aml']['flag_list'],"OFF");
			
	
	} #END PENDING		
	
	if(!$response['biometric_aml']['flag_list'][0])
	$response['biometric_aml']['flag_list'] = 0;
	
	//logger3("response['biometric_aml']",$response['biometric_aml'],"OFF");		
			
	
	} // VERSION 2	
			
			
	logger3("response",$response,"OFF");	
			
	
	############################################################################
	############################################################################
	############################################################################
	### NEGAGIVE•NEWS:
	
	$response['negative_news'] = "";
	//$response['negative_news']['LICENSED_NEWS'] = "N/A";
	//$response['negative_news']['SEARCH_ENGINES'] = "N/A";
	
	
	//$response['negative_news']['CREDENTIALED_NEWS']['first_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['negative_news']['CREDENTIALED_NEWS']['last_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['negative_news']['CREDENTIALED_NEWS']['first_last_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['negative_news']['CREDENTIALED_NEWS']['business_name'] = "TRUE"; // TRUE / FALSE / NA
	
	//$response['negative_news']['SEARCH_ENGINES']['first_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['negative_news']['SEARCH_ENGINES']['last_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['negative_news']['SEARCH_ENGINES']['first_last_name'] = "TRUE"; // TRUE / FALSE / NA
	//$response['negative_news']['SEARCH_ENGINES']['business_name'] = "TRUE"; // TRUE / FALSE / NA
	
	
	### V2:
	
	$ADD_STATUS = "AND (status = '' OR status = 'PENDING')";
	$tmp_sql = "SELECT hash
				FROM api_search_engine_results
				WHERE member_hash = '". $member_details['hash'] . "'
				AND api_service_name = 'ibm_watson_news' 
				$ADD_STATUS
				LIMIT 1
				;";
	//logger3("tmp_sql",$tmp_sql,"OFF");
	$member_incomplete_scan_hash = getTHECASHIER($tmp_sql,"intelitruth");
	//logger3("member_incomplete_scan_hash",$member_incomplete_scan_hash,"OFF");
	
	
	if($member_incomplete_scan_hash) {
	
		$response['negative_news']['risk_score'] = "PENDING";
		$response['negative_news']['flag_list'] = "N/A";
	
	} else {
	
	
		$tmp_sql = "SELECT *
					FROM api_search_engine_results
					WHERE api_service_name = 'ibm_watson_news'
					AND member_hash = '". $member_details['hash'] . "'
					AND status = 'COMPLETE'
					ORDER BY datetime_created 
					DESC
					;";
		//logger3("tmp_sql",$tmp_sql,"OFF");
		$api_search_engine_results_array = readarrayTHECASHIER($tmp_sql,"intelitruth");
		//logger3("api_search_engine_results_array",$api_search_engine_results_array,"OFF");
		
		
		$final_search_results = "";
		//logger3("0-final_search_results",$final_search_results,"OFF");
		
		$flag_details_key = 0;
		foreach($api_search_engine_results_array AS $flag_key => $row_details) {
			
			
			//logger3("results_details",$results_details,"OFF");
			
			
			$serialized_search_results = $row_details['serialized_search_results'];
			
			//logger3("serialized_search_results",$serialized_search_results,"OFF");
		
			$serialized_search_results_json_decode = json_decode($serialized_search_results);
			
			//logger3("serialized_search_results_json_decode",$serialized_search_results_json_decode,"OFF");
			
			//$count = count($serialized_search_results_json_decode['results']);
			//logger3("count",$count,"OFF");
			
			$serialized_search_results_json_decode = object_to_array_v2($serialized_search_results_json_decode);
			
			//logger3("serialized_search_results_json_decode",$serialized_search_results_json_decode,"OFF");
			
			
			foreach($serialized_search_results_json_decode['results'] AS $news_key => $news_details) {
				
				//logger3("news_details",$news_details,"OFF");
				$news_details = object_to_array_v2($news_details);
				$tmp_response['negative_news']['flag_list'][$flag_details_key]['source'] = $news_details['url'];
				
				$letters_and_numbers_only = letters_and_numbers_only_v2($news_details['text']);
				$tmp_response['negative_news']['flag_list'][$flag_details_key]['text'] = substr($letters_and_numbers_only,0,150);
				$flag_details_key = $flag_details_key + 1;
			}
		
		}
			
		
		//logger3("1-final_search_results",$final_search_results,"OFF");
		
		
		$number_of_flags = count($tmp_response['negative_news']['flag_list']);
		$response['negative_news']['risk_score'] = 0;
		
		if($number_of_flags > 0) $response['negative_news']['risk_score'] = $number_of_flags;
		
		$response['negative_news']['flag_list'] = $tmp_response['negative_news']['flag_list'];
		if(!$response['negative_news']['flag_list']) $response['negative_news']['flag_list'] = 0;
		
		
	} /// end pending
	
	
	//logger3("response['negative_news']",$response['negative_news'],"OFF");		
	
	
	############################################################################
	############################################################################
	############################################################################
	### INTELI•SPIDER:
	
	$response['inteli_spider'] = "PENDING";
	$response['negative_news']['risk_score'] = 0;
	$response['negative_news']['flag_list'] = "N/A";
		
		
	/*
		
	//$response['inteli_spider']['URL'] = "N/A"; // 1 / 0 / NA
	
	//logger3("response['inteli_spider']",$response['inteli_spider'],"OFF");
	
	
	### V2:
	
	$ADD_STATUS = "AND (status = '' OR status = 'PENDING')";
	$tmp_sql = "SELECT hash
				FROM api_search_engine_results
				WHERE member_hash = '". $member_details['hash'] . "'
				AND api_service_name = 'SPIDER' 
				$ADD_STATUS
				LIMIT 1
				;";
	//logger3("tmp_sql",$tmp_sql,"OFF");
	$member_incomplete_scan_hash = getTHECASHIER($tmp_sql,"intelitruth");
	//logger3("member_incomplete_scan_hash",$member_incomplete_scan_hash,"OFF");
	
	
	if($member_incomplete_scan_hash) {
	
		$response['inteli_spider']['risk_score'] = "PENDING";
		$response['inteli_spider']['flag_list'] = "N/A";
	
	} else {
		
			
		// needs to be updated to business account;
		
		$tmp_sql = "SELECT *
					FROM api_search_engine_results
					WHERE api_service_name = 'SPIDER'
					AND member_hash = '". $member_details['hash'] . "'
					AND status = 'COMPLETE'
					ORDER BY datetime_created 
					DESC
					;";
		//logger3("tmp_sql",$tmp_sql,"OFF");
		$api_search_engine_results_array = readarrayTHECASHIER($tmp_sql,"intelitruth");
		//logger3("api_search_engine_results_array",$api_search_engine_results_array,"OFF");
		
		
		$final_search_results = "";
		//logger3("0-final_search_results",$final_search_results,"OFF");
		
		$flag_details_key = 0;
		
		
		$response['inteli_spider']['risk_score'] = 0;
		
		foreach($api_search_engine_results_array AS $flag_key => $row_details) {
			
			
			/// display the spider results;
			
			$response['inteli_spider']['flag_list'][$flag_key] = $row_details;
			
			
		}
		
		
		$response['inteli_spider']['risk_score'] = $flag_key + 1;
			
	
	//logger3("1-final_search_results",$final_search_results,"OFF");
	} // END PENDING
	
	
	//logger3("response['inteli_spider']",$response['inteli_spider'],"OFF");		
	
	
	*/
	
	
	//logger3("SUB_FINAL_response",$response,"OFF");		
	
	
	############################################################################
	############################################################################
	############################################################################
	### FACE-BIOMETRICS:
	
	$response['face_biometrics'] = "";
	$tmp_risk_score = 0;
	
	$tmp_sql = "SELECT *
				FROM ids_personal
				WHERE selfie_filename != ''
				AND member_hash = '". $member_details['hash'] ."'
				ORDER BY datetime_created DESC
				LIMIT 1
				;";
	logger3("tmp_sql",$tmp_sql,"OFF");
	$selfie_documents_exist = object_to_array_v2(readTHECASHIER($tmp_sql));
	logger3("selfie_documents_exist",$selfie_documents_exist,"OFF");
	
	
	$tmp_sql = "SELECT *
				FROM ids_personal
				WHERE selfie_filename != ''
				AND member_hash = '". $member_details['hash'] ."'
				ORDER BY datetime_created DESC
				LIMIT 1
				;";
	logger3("tmp_sql",$tmp_sql,"OFF");
	$selfie_record_details = object_to_array_v2(readTHECASHIER($tmp_sql));
	logger3("selfie_record_details",$selfie_record_details,"OFF");
	
	if(
		($selfie_documents_exist)
		&& ($selfie_record_details)
	) {
		$response['face_biometrics']['verified_selfie'] = "TRUE";
	
	} else if(
		($selfie_documents_exist)
		&& (!$selfie_record_details)
	) {
	
		$response['face_biometrics']['verified_selfie'] = "FALSE";
		$tmp_risk_score = $tmp_risk_score + 450;
	
	} else {
		
		$response['face_biometrics']['verified_selfie'] = "NO DOCUMENTS FOUND";
		$tmp_risk_score = $tmp_risk_score + 100;
		
	}
	
	logger3("2-response['face_biometrics']['verified_selfie']",$response['face_biometrics']['verified_selfie'],"OFF");
	
	
	$tmp_sql = "SELECT hash
				FROM ids_personal
				WHERE member_hash = '". $member_details['hash'] ."'
				AND photo_id_filename != ''
				ORDER BY datetime_created DESC
				LIMIT 1
				;";
	logger3("tmp_sql",$tmp_sql,"OFF");
	$photo_id_documents_exist = getTHECASHIER($tmp_sql);
	logger3("z-photo_id_documents_exist",$photo_id_documents_exist,"OFF");
	
	
	$tmp_sql = "SELECT hash
				FROM ids_personal
				WHERE member_hash = '". $member_details['hash'] ."'
				AND photo_id_filename != ''
				AND photo_id_azure_face_biometric_id != ''
				ORDER BY datetime_created DESC
				LIMIT 1
				;";
	logger3("tmp_sql",$tmp_sql,"OFF");
	$photo_id_record_details = getTHECASHIER($tmp_sql);
	logger3("zz-record_details",$record_details,"OFF");
	
	
	if(
		($photo_id_documents_exist)
		&& ($photo_id_record_details) 
	) {
		$response['face_biometrics']['verified_photo_id'] = "TRUE";
	
	} else if(
		($photo_id_documents_exist)
		&& (!$photo_id_record_details) 
	) {
	
		$response['face_biometrics']['verified_photo_id'] = "FALSE";
		$tmp_risk_score = $tmp_risk_score + 450;
	
	} else {
	
		$response['face_biometrics']['verified_photo_id'] = "NO DOCUMENTS FOUND";
		$tmp_risk_score = $tmp_risk_score + 100;
	}
	
	
	$_XXXXX_face_biometric_tolerance = "0.40";
	
	$tmp_sql = "SELECT hash
				FROM ids_personal
				WHERE member_hash = '". $member_details['hash'] ."'
				AND photo_id_filename != ''
				AND matching_selfie_azure_face_biometric_results >= '". $_XXXXX_face_biometric_tolerance ."' 
				ORDER BY datetime_created DESC
				LIMIT 1
				;";
	logger3("tmp_sql",$tmp_sql,"OFF");
	$phto_id_record_details = getTHECASHIER($tmp_sql);
	logger3("record_details",$record_details,"OFF");
	
	
	$tmp_sql = "SELECT hash
				FROM ids_personal
				WHERE member_hash = '". $member_details['hash'] ."'
				AND photo_id_filename != ''
				ORDER BY datetime_created DESC
				LIMIT 1
				;";
	logger3("tmp_sql",$tmp_sql,"OFF");
	$photo_id_documents_found = getTHECASHIER($tmp_sql);
	logger3("photo_id_documents_found",$photo_id_documents_found,"OFF");
	
	
	if(
		($photo_id_documents_found)
		&& ($phto_id_record_details)
	) {
		$response['face_biometrics']['photo_id_matches_selfie'] = "TRUE";
	
	} else if(
		($photo_id_documents_found)
		&& (!$phto_id_record_details)
	) {
		$response['face_biometrics']['photo_id_matches_selfie'] = "FALSE";
		$tmp_risk_score = $tmp_risk_score + 450;
	
	} else {
	
		$response['face_biometrics']['photo_id_matches_selfie'] = "NO DOCUMENTS FOUND";
		$tmp_risk_score = $tmp_risk_score + 100;
	
	}
	
	
	/// RISK SCORE:
	
	$tmp_face_biometrics = $response['face_biometrics'];
	$response['face_biometrics'] = "";
	$response['face_biometrics']['risk_score'] = $tmp_risk_score;
	$response['face_biometrics']['flag_list'] = $tmp_face_biometrics;
	
	
	############################################################################
	############################################################################
	############################################################################
	### OCR:
	
	
	$response['ocr'] = "";
	
	$tmp_photo_id_risk_score = 0;
	
	if($response['face_biometrics']['verified_photo_id'] == "NO DOCUMENTS FOUND") {
		
		$response['ocr'] = "";
		$response['ocr'] = "NO DOCUMENTS FOUND";
		
	} else {
	
		$field = "ocr_matches_firstname";
		$var = "first_name";
		$tmp_sql = "SELECT hash
					FROM ids_personal
					WHERE photo_id_filename != ''
					AND member_hash = '". $member_details['hash'] ."'
					AND ". $field ." != ''
					ORDER BY datetime_created DESC
					LIMIT 1
					;";
		$hash[$var] = getTHECASHIER($tmp_sql);
		if($hash[$var]) {
			$response['ocr'] = "";
			$response['ocr']['photo_id'][$var] = "TRUE";
			$tmp_photo_id_risk_score = $tmp_photo_id_risk_score + 1;
		} else {
			$response['ocr'] = "";
			$response['ocr']['photo_id'][$var] = "FALSE";
		}
		
		
		/////////
		$field = "ocr_matches_middlename";
		$var = "middle_name";
		$tmp_sql = "SELECT hash
					FROM ids_personal
					WHERE photo_id_filename != ''
					AND member_hash = '". $member_details['hash'] ."'
					AND ". $field ." != ''
					ORDER BY datetime_created DESC
					LIMIT 1
					;";
		$hash[$var] = getTHECASHIER($tmp_sql);
		if($hash[$var]) {
			$response['ocr']['photo_id'][$var] = "TRUE";
			$tmp_photo_id_risk_score = $tmp_photo_id_risk_score + 1;
		} else {
			$response['ocr']['photo_id'][$var] = "FALSE";
		}
		
		
		/////////
		$field = "ocr_matches_lastname";
		$var = "last_name";
		$tmp_sql = "SELECT hash
					FROM ids_personal
					WHERE photo_id_filename != ''
					AND member_hash = '". $member_details['hash'] ."'
					AND ". $field ." != ''
					ORDER BY datetime_created DESC
					LIMIT 1
					;";
		$hash[$var] = getTHECASHIER($tmp_sql);
		if($hash[$var]) {
			$response['ocr']['photo_id'][$var] = "TRUE";
			$tmp_photo_id_risk_score = $tmp_photo_id_risk_score + 1;
		} else {
			$response['ocr']['photo_id'][$var] = "FALSE";
		}
		
		
		/////////
		$field = "ocr_matches_street_name";
		$var = "street_name";
		$tmp_sql = "SELECT hash
					FROM ids_personal
					WHERE photo_id_filename != ''
					AND member_hash = '". $member_details['hash'] ."'
					AND ". $field ." != ''
					ORDER BY datetime_created DESC
					LIMIT 1
					;";
		$hash[$var] = getTHECASHIER($tmp_sql);
		if($hash[$var]) {
			$response['ocr']['photo_id'][$var] = "TRUE";
			$tmp_photo_id_risk_score = $tmp_photo_id_risk_score + 1;
		} else {
			$response['ocr']['photo_id'][$var] = "FALSE";
		}
		
		
		/////////
		$field = "ocr_matches_street_number";
		$var = "street_number";
		$tmp_sql = "SELECT hash
					FROM ids_personal
					WHERE photo_id_filename != ''
					AND member_hash = '". $member_details['hash'] ."'
					AND ". $field ." != ''
					ORDER BY datetime_created DESC
					LIMIT 1
					;";
		$hash[$var] = getTHECASHIER($tmp_sql);
		if($hash[$var]) {
			$response['ocr']['photo_id'][$var] = "TRUE";
			$tmp_photo_id_risk_score = $tmp_photo_id_risk_score + 1;
		} else {
			$response['ocr']['photo_id'][$var] = "FALSE";
		}
		
		
		/////////
		$field = "ocr_matches_postal_code";
		$var = "postal_code";
		$tmp_sql = "SELECT hash
					FROM ids_personal
					WHERE photo_id_filename != ''
					AND member_hash = '". $member_details['hash'] ."'
					AND ". $field ." != ''
					ORDER BY datetime_created DESC
					LIMIT 1
					;";
		$hash[$var] = getTHECASHIER($tmp_sql);
		if($hash[$var]) {
			$response['ocr']['photo_id'][$var] = "TRUE";
			$tmp_photo_id_risk_score = $tmp_photo_id_risk_score + 1;
		} else {
			$response['ocr']['photo_id'][$var] = "FALSE";
		}
		
		
		/////////
		$field = "ocr_matches_date_of_birth";
		$var = "date_of_birth";
		$tmp_sql = "SELECT hash
					FROM ids_personal
					WHERE photo_id_filename != ''
					AND member_hash = '". $member_details['hash'] ."'
					AND ". $field ." != ''
					ORDER BY datetime_created DESC
					LIMIT 1
					;";
		$hash[$var] = getTHECASHIER($tmp_sql);
		if($hash[$var]) {
			$response['ocr']['photo_id'][$var] = "TRUE";
			$tmp_photo_id_risk_score = $tmp_photo_id_risk_score + 1;
		} else {
			$response['ocr']['photo_id'][$var] = "FALSE";
		}
		
		
		/////////
		$field = "ocr_matches_city";
		$var = "city_name";
		$tmp_sql = "SELECT hash
					FROM ids_personal
					WHERE photo_id_filename != ''
					AND member_hash = '". $member_details['hash'] ."'
					AND ". $field ." != ''
					ORDER BY datetime_created DESC
					LIMIT 1
					;";
		$hash[$var] = getTHECASHIER($tmp_sql);
		if($hash[$var]) {
			$response['ocr']['photo_id'][$var] = "TRUE";
			$tmp_photo_id_risk_score = $tmp_photo_id_risk_score + 1;
		} else {
			$response['ocr']['photo_id'][$var] = "FALSE";
		}
		
		
		/////////
		$field = "ocr_matches_state";
		$var = "state_name";
		$tmp_sql = "SELECT hash
					FROM ids_personal
					WHERE photo_id_filename != ''
					AND member_hash = '". $member_details['hash'] ."'
					AND ". $field ." != ''
					ORDER BY datetime_created DESC
					LIMIT 1
					;";
		$hash[$var] = getTHECASHIER($tmp_sql);
		if($hash[$var]) {
			$response['ocr']['photo_id'][$var] = "TRUE";
			$tmp_photo_id_risk_score = $tmp_photo_id_risk_score + 1;
		} else {
			$response['ocr']['photo_id'][$var] = "FALSE";
		}
		
		
		/////////
		$field = "ocr_matches_region";
		$var = "region_name";
		$tmp_sql = "SELECT hash
					FROM ids_personal
					WHERE photo_id_filename != ''
					AND member_hash = '". $member_details['hash'] ."'
					AND ". $field ." != ''
					ORDER BY datetime_created DESC
					LIMIT 1
					;";
		$hash[$var] = getTHECASHIER($tmp_sql);
		if($hash[$var]) {
			$response['ocr']['photo_id'][$var] = "TRUE";
			$tmp_photo_id_risk_score = $tmp_photo_id_risk_score + 1;
		} else {
			$response['ocr']['photo_id'][$var] = "FALSE";
		}
		
		
		/////////
		$field = "ocr_matches_country_name";
		$var = "country_name";
		$tmp_sql = "SELECT hash
					FROM ids_personal
					WHERE photo_id_filename != ''
					AND member_hash = '". $member_details['hash'] ."'
					AND ". $field ." != ''
					ORDER BY datetime_created DESC
					LIMIT 1
					;";
		$hash[$var] = getTHECASHIER($tmp_sql);
		if($hash[$var]) {
			$response['ocr']['photo_id'][$var] = "TRUE";
			$tmp_photo_id_risk_score = $tmp_photo_id_risk_score + 1;
		} else {
			$response['ocr']['photo_id'][$var] = "FALSE";
		}
		
		
		/////////
		$field = "ocr_matches_country_iso3";
		$var = "country_iso3";
		$tmp_sql = "SELECT hash
					FROM ids_personal
					WHERE photo_id_filename != ''
					AND member_hash = '". $member_details['hash'] ."'
					AND ". $field ." != ''
					ORDER BY datetime_created DESC
					LIMIT 1
					;";
		$hash[$var] = getTHECASHIER($tmp_sql);
		if($hash[$var]) {
			$response['ocr']['photo_id'][$var] = "TRUE";
			$tmp_photo_id_risk_score = $tmp_photo_id_risk_score + 1;
		} else {
			$response['ocr']['photo_id'][$var] = "FALSE";
		}
		
		
		/////////
		$field = "ocr_matches_document_name";
		$var = "document_name";
		$tmp_sql = "SELECT hash
					FROM ids_personal
					WHERE photo_id_filename != ''
					AND member_hash = '". $member_details['hash'] ."'
					AND ". $field ." != ''
					ORDER BY datetime_created DESC
					LIMIT 1
					;";
		$hash[$var] = getTHECASHIER($tmp_sql);
		if($hash[$var]) {
			$response['ocr']['photo_id'][$var] = "TRUE";
			$tmp_photo_id_risk_score = $tmp_photo_id_risk_score + 1;
		} else {
			$response['ocr']['photo_id'][$var] = "FALSE";
		}
		
		
		if($tmp_photo_id_risk_score < $_XXXXX_MINIMUM_OCR_MATCHES) {
			$tmp_photo_id_risk_score = 450;
		} else {
			$tmp_photo_id_risk_score = 0;
		}
		
	
		logger3("tmp_photo_id_risk_score",$tmp_photo_id_risk_score,"OFF");
		logger3("_XXXXX_MINIMUM_OCR_MATCHES",$_XXXXX_MINIMUM_OCR_MATCHES,"OFF");
		
		$tmp_ocr = $response['ocr'];
		$response['ocr'] = "";
		$response['ocr']['risk_score'] = $tmp_photo_id_risk_score;
		$response['ocr']['flag_list'] = $tmp_ocr;
		
		
	} // END OCR
	
	
	############################################################################
	############################################################################
	############################################################################
	### THIRD PARTY SERVICES:
	
	//$response['premium_services'] = "N/A";
	//$response['premium_services']['EXPERIAN'] = "N/A"; // 1 / 0 / NA
	//$response['premium_services']['THOMSON_REUTERS'] = "N/A"; // 1 / 0 / NA
	//$response['premium_services']['IBM_FINANCIAL_CRIMES_ALERT_INSIGHT'] = "N/A"; // 1 / 0 / NA
	
	
	if($profile_is_pending) {
		
		//unset($response['global_kyc']);
		$response['global_kyc'] = "";
		$response['global_kyc']['risk_score'] = "PENDING";
		$response['global_kyc']['flag_list'] = "--";
		
		//unset($response['negative_news']);
		$response['negative_news'] = "";
		$response['negative_news']['risk_score'] = "PENDING";
		$response['negative_news']['flag_list'] = "--";
		
		//unset($response['inteli_spider']);
		$response['inteli_spider'] = "";
		$response['inteli_spider']['risk_score'] = "PENDING";
		$response['inteli_spider']['flag_list'] = "--";
		
	}
	
	
	$_XXXXX_RUNNING_TOTAL_FLAGS = 0;
	$_XXXXX_RUNNING_TOTAL_RISK_SCORE = 0;
	foreach($response AS $key_type => $type) {
		
		logger3("type",$type,"OFF");
		
		if($type['risk_score'] != "PENDING") {
			$_XXXXX_RUNNING_TOTAL_RISK_SCORE = $_XXXXX_RUNNING_TOTAL_RISK_SCORE + $type['risk_score'];
			if($type['risk_score'] != 0) {
				$_XXXXX_RUNNING_TOTAL_FLAGS = $_XXXXX_RUNNING_TOTAL_FLAGS + 1;
			}
		}
	
	}
	
	
	$final_response = array();
	
	$final_response['MEMBER_ID'] = $member_hash;
	$final_response['FIRST_NAME'] = $member_details['firstname'];
	$final_response['MIDDLE_NAME'] = $member_details['middlename'];
	$final_response['LAST_NAME'] = $member_details['lastname'];
	$final_response['EMAIL_ADDRESS'] = '';//$member_details['emailaddress'];
	$final_response['TOTAL_RISK_SCORE'] = $_XXXXX_RUNNING_TOTAL_RISK_SCORE;
	
	$final_response['TOTAL_FLAG_COUNT'] = number_format($_XXXXX_RUNNING_TOTAL_FLAGS,0);
														
	/*$final_response['TOTAL_FLAG_COUNT'] = number_format(
														$response['global_kyc']['risk_score'] 
														+ $response['biometric_aml']['risk_score'] 
														+ $response['negative_news']['risk_score'] 
														+ $response['inteli_spider']['risk_score'] 
														
														,0);
	*/
	
	$final_response['ACTION'] = "PASS";
	if($final_response['TOTAL_FLAG_COUNT'] > 0) $final_response['ACTION'] = "REVIEW";
	
	
	//logger3("final_response",$final_response,"OFF");
	$final_response['DETAILS'] = $response;
	//logger3("0-final_response",$final_response,"OFF");
	//exit;
	
	$final_response = object_to_array_v2($final_response);
	
	logger3("API_gateway_response",$final_response,"OFF");
	
	
	$final_response_array[] = $final_response;


} // foreach loop


$response_json_encoded = json_encode($final_response_array);

//logger3("response_json_encoded",$response_json_encoded,"OFF");
echo $response_json_encoded;


//echo "ERROR: 12";

//echo "YAY!";

### END: SESSIONS & STUFF.
#
#
#
include($_SESSION['template']['company']['file_path'] . "shared/end_verified_session.shared");

?>