bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
ini_set("display_errors",1);
include('includes/application_includes.php');		
	
$accessToken= '1000.981de26aa4c31f2e5424bbd60df7be19.3037868e38be7178f50a1f0b270ace37';

$count = $db->getOne('SELECT count(*) from `mall_vendorstore_orders` where `member_email`!='' and `updated_to_zoho`="NO" ');
echo $count;
echo " ";
//echo "yes";
//exit;

$rows = $db->getRows('SELECT `id`, `member_email`  `mall_vendorstore_orders`  where `member_email`!='' and `zoho_itempkid_status`="NO" and `updated_to_zoho`="YES"  ORDER BY `id` ASC limit 5');

ArrayDisplay($rows);
if (!empty($rows)) {
	
	$rowVal=0;
	foreach ($rows as $row) {
		$itempkid=$row['member_email'];
		
echo $rowVal." ";
echo $row['id']." ";
echo $itempkid." ";

$searchRecord = callAPI('GET', 'https://www.zohoapis.com/crm/v2/Contacts/search?criteria=(Email:equals:'.$itempkid.')', '', $accessToken);
		$searchResponse = json_decode($searchRecord, true);
		//ArrayDisplay($searchResponse);
		# zoho tag insertion code ends here
		$record_id=$searchResponse['data'][0]['id'];
		 echo " ";
		echo $record_id; echo " ";
		echo " ";
		
		if ($record_id) {
			
			$dataArray = array(
												"data" => array(
													 array(
														"id" => $record_id,
														"itempkidtwo" => "tkt".$row['id'],
														"itemtype" => "ticket"
													)), 
												 
												"trigger" =>array(
														 "approval"
														)
		); 
			
			$updateRecord = callAPI('PUT', 'https://www.zohoapis.com/crm/v2/Contacts/'.$record_id.'', json_encode($dataArray), $accessToken);
			$updateRecordresp = json_decode($updateRecord, true);

//ArrayDisplay($updateRecordresp);

$db->query('UPDATE `mall_vendorstore_orders` SET `zoho_itempkid_status`="YES" WHERE `id`='.$row['id'].'');
			//echo $row['email']." ";
			$rowVal++;
		}
	}
}
echo "Total Records Updated are : ".$rowVal;
?>