bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
ini_set("display_errors",1);
include('includes/application_includes.php');

# zoho api - inserting ticket member - starts here
/*
$tokenInfoticket = "refresh_token=".$refresh_token."&client_id=".$client_id."&client_secret=".$client_secret."&grant_type=refresh_token";

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

$tickeTokenResponse = json_decode($gettingTickettoken, true);*/
						
ArrayDisplay($tickeTokenResponse);	
//exit;
 $accessToken= '1000.baec2ed1fefad0bfe6815e05106816a0.c6fbfc890f0a1b3bbf97011597e76cb4';

//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;

$rows= $db->getRows("SELECT `id`, `email`, `name`, `companyname`, `phone`, `referred_by`  from `bmse_members` where id in (916306006,916305539,916306767,916306775)");

ArrayDisplay($rows);
//exit;

if (!empty($rows)) {
	$tag='';
	$rowVal=0;
	foreach ($rows as $row) {
		$itempkid=strtolower($row['email']);
		
		
			
			$memberData = $db->getRow('SELECT * FROM `bmse_members` WHERE `id`='.$row['id'].'');
			$member_id = $memberData['id'];
			# inserting exhibitor values in to zoho - starts here
			
			
			
			$insertxhibitordata = array(
									"data" => array(
										 array(
											"itempkid" => "exhi".$member_id,
											"Last_Name" => $memberData['name'], 
											"Company_Name" => $memberData['companyname'],
											"Email" => $memberData['email'],
											"Website_URL" => $memberData['website'], 
											"Mailing_Street" => $memberData['address'],
											"Mailing_City" => $memberData['city'] ,
											"Mailing_State" => $memberData['state'], 
											"Mailing_Zip" => $memberData['zip'],
											"Mailing_Country" => $country['countries_name'],											
											"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);
			
			$db->query('UPDATE `bmse_members` SET `updated_to_zoho`="YES"  WHERE `id`='.$row['id'].'');
			
			$rowVal++;
		}
	}

echo "Total Records Update ". $rowVal;