bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
ini_set("display_errors",1);
include('includes/application_includes.php');		
	
#zoho lead search starts here 
//$tokenData = "refresh_token=".$refresh_token."&client_id=".$client_id."&client_secret=".$client_secret."&grant_type=refresh_token";

#getting access token
//$getTokendata = callAPIP('POST', 'https://accounts.zoho.com/oauth/v2/token?', ($tokenData));

//$tokenResponse = json_decode($getTokendata, true);

$accessToken= '1000.9d0872b2f124eb8b33e055ce6bf10a0f.2ac0bfe6602e985497010f10b57aeaa6';

//ArrayDisplay($tokenResponse);

$count =  $db->getOne('SELECT count(*) from `bmse_members` WHERE `status`=1 AND `remove_flag`=1 and  `updated_to_zoho`="NO"');

echo $count;

$val= $current_date;

//exit;
/*$rows = $db->getRows('SELECT `id`, `email`, `name`, `companyname`, `phone`, `referred_by`  from `bmse_members` WHERE `status`=1 AND `remove_flag`=1 AND `updated_to_zoho`="NO"  AND `zoho_comments`="" limit 5'); */
/*
$rows = $db->getRows('SELECT `id`, `email`, `name`, `companyname`, `phone`, `referred_by`  from `bmse_members` WHERE `status`=1 AND `remove_flag`=1 AND `updated_to_zoho`="NO"  limit 100'); */

$rows= $db->getRows("SELECT `id`, `email`, `name`, `companyname`, `phone`, `referred_by`  from `bmse_members` where id in (916302960,916303131,916303579,916303781,916305174,916305496,916305589)");

//ArrayDisplay($rows);
if (!empty($rows)) {
	$tag='';
	$rowVal=0;
	foreach ($rows as $row) {
		$itempkid=strtolower($row['email']);
		
		
		//echo 'https://www.zohoapis.com/crm/v2/Leads/search?criteria=(Email:equals:'.$itempkid.')';
	/* echo 'https://www.zohoapis.com/crm/v2/Contacts/search?criteria=(Email:equals:'.$itempkid.')';
		$searchRecord = callAPI('GET', 'https://www.zohoapis.com/crm/v2/Contacts/search?criteria=(Email:equals:'.$itempkid.')', '', $tokenResponse['access_token']);
		$searchResponse = json_decode($searchRecord, true);
		ArrayDisplay($searchRecord);
		# zoho tag insertion code ends here
		$record_id=$searchResponse['data'][0]['id'];
		//echo $record_id;
		//echo "<br/>";
		
		if ($record_id) {
			
			$dataArray = array(
												"data" => array(
													 array(
														"id" => $record_id,
														"itempkidtwo" => "exhi".$row['id']
													)), 
												 
												"trigger" =>array(
														   "approval"
														)
		); 
			
			$updateRecord = callAPI('PUT', 'https://www.zohoapis.com/crm/v2/Contacts/'.$record_id.'', json_encode($dataArray), $tokenResponse['access_token']);
		$updateRecordresp = json_decode($updateRecord, true);
		
		//ArrayDisplay($updateRecordresp);
		
		$db->query('UPDATE `bmse_members` SET `updated_to_zoho`="YES" WHERE `id`='.$row['id'].'');
		$rowVal++;
			exit;
		} else {
			*/
			$memberData = $db->getRow('SELECT * FROM `bmse_members` WHERE `id`='.$row['id'].'');
			$member_id = $memberData['id'];
			# inserting exhibitor values in to zoho - starts here
			
			//$tokenExhibitorinsert = "refresh_token=".$refresh_token."&client_id=".$client_id."&client_secret=".$client_secret."&grant_type=refresh_token";

//$tokentoinsertExhibitor = callAPIP('POST', 'https://accounts.zoho.com/oauth/v2/token?', ($tokenExhibitorinsert));

//$insetExhibitorVal = json_decode($tokentoinsertExhibitor, true);
			//ArrayDisplay($responsepe);
			
			$insertxhibitordata = array(
									"data" => array(
										 array(
											//"Exhibitor Name" => $_POST['company_name'], 
											"itempkid" => "exhi".$member_id,
											"itempkidtwo" =>  "exhi".$member_id,
											"Last_Name" => $memberData['name'], 
											"Company_Name" => $memberData['companyname'],
											"Email" => $memberData['email'],  
											"Phone" => $memberData['phone'], 
											"date" => displayDate($current_date,'M d, Y'),
											"Referred_By" => $memberData['referred_by'],
											"Account_Name" => $memberData['companyname'],
											"itemtype" => "becomeexhibitor"
											
										)), 
									 
									"trigger" =>array(
											   "approval", 
											   "workflow", 
											   "blueprint" 
											)
									/*"tag" =>array(
											   "2024event"
											),*/
									
									); 
			$insertExhibitor = callAPI('POST', 'https://www.zohoapis.com/crm/v2/Contacts', json_encode($insertxhibitordata), $accessToken);
			$insertexhibitorResponse = json_decode($insertExhibitor, true);
			ArrayDisplay($insertexhibitorResponse);
			# inserting exhibitor values in to zoho - ends here
			//$db->query('UPDATE `bmse_members` SET `updated_to_zoho`="YES", `zoho_comments`="Email Doest Not Exist"  WHERE `id`='.$row['id'].'');
			$db->query('UPDATE `bmse_members` SET `updated_to_zoho`="YES"  WHERE `id`='.$row['id'].'');
			//$db->query('UPDATE `bmse_members` SET `zoho_comments`="Email Doest Not Exist" WHERE `id`='.$row['id'].'');
			$rowVal++;
		}
	}

echo "Total Records Update ". $rowVal;