bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
ini_set("display_errors",1);
include('includes/application_includes.php');		
$accessToken= '1000.3d5a6f5df9adb647671c282a7957afd0.f8e69731871916b7a282f981c4f1b54b';

$recordCount = $db->getOne('SELECT count(*) FROM `bmse_zoho_tk_records` WHERE `itemtype`="ticket" and `updated`="no"');

echo $recordCount;

echo "<br/>";

#getRecords

$records = $db->getRows('SELECT `id`, `itemtype`, `itempkid`, `zoho_tags`, `email`, `company` from `bmse_zoho_tk_records` WHERE `itemtype`="ticket" and `updated`="no" order by `id` DESC limit 10');

/*$records = $db->getRows('SELECT `id`, `itemtype`, `itempkid`, `zoho_tags`, `email`, `company` from `bmse_zoho_tk_records` WHERE `id` in (68,95)'); */

ArrayDisplay($records);

//exit;

if (!empty($records)) {
	$data['Event_Ticket_Purchased']='';
	$searchResponse['data']='';
	foreach ($records as $record) {
		echo $record['id'];
		echo "<br/>";
		/*$comp=str_replace(" ","%20",$record['company']);
		$comp1=str_replace("&","%26",$comp);
		$comp2=str_replace("|","%7C",$comp1);
		$comp3=str_replace("-","%2D",$comp2);*/
		
		$compa = urlencode($record['email']);
		
		
	$itempkid=$compa;
echo 'https://www.zohoapis.com/crm/v2/Accounts/search?criteria=(Account_Name:equals:'.$itempkid.')';
	$searchRecord = callAPI('GET', 'https://www.zohoapis.com/crm/v2/Contacts/search?criteria=(Email:equals:'.$itempkid.')', '', $accessToken);

$searchResponse = json_decode($searchRecord, true);
			echo "yes";
			ArrayDisplay($searchResponse);
		//ArrayDisplay($searchResponse['data']);
			//$record_id=$searchResponse['data'][0]['id'];
			echo "hi";
		//	echo $record_id;
			if (!empty($searchResponse['data'])) {
				foreach($searchResponse['data'] as $data) {
			ArrayDisplay($data);
				if (!empty($data['Event_Ticket_Purchased'])) {
					$record_idSports = array_push($data['Event_Ticket_Purchased'], $record['zoho_tags']);
				} else {
					$data['Event_Ticket_Purchased']=array($record['zoho_tags']);
				}
				echo $data['id'];
				echo "<br/>";
				ArrayDisplay($data['Event_Ticket_Purchased']);
				if ($data['id']) {

$dataArray = array(
														"data" => array(
															 array(
																"id" => $data['id'],
																"Event_Ticket_Purchased" => $data['Event_Ticket_Purchased']
																
															)), 
														 
														"trigger" =>array(
																   "approval"
																)
					);

$updateRecord = callAPI('PUT', 'https://www.zohoapis.com/crm/v2/Contacts/'.$data['id'].'', json_encode($dataArray), $accessToken);
					$updateRecordresp = json_decode($updateRecord, true);

//ArrayDisplay($updateRecordresp);

}
				
				}
				
			}
			
		$db->query('UPDATE `bmse_zoho_tk_records` SET `updated`="yes" WHERE `id`='.$record['id'].'');

}
}