bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

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

$accessToken= '1000.f1ee20588d305c4d1148a71a95522794.0ff8cdd66b96b0b16d93e68f7598a6c1';

$count = $db->getOne('SELECT count(*) FROM `mall_vendorstore_orders` where `member_email`!="" and `updated_to_zoho`="NO" ORDER BY `id`');
echo $count;
echo "<br/>";
# getting exhibitor

//$futureExpos = $db->getRows('SELECT `id` FROM `bmse_expos` WHERE DATE(`start_dttm`) > "2023-12-30" and `status`=1 and `remove`=1  order by `id`  ASC  ');
/*$ticketSales = $db->getRows('SELECT DISTINCT `order_id` FROM `expo_ticket_sales` WHERE `expo_id` in (485,486,496,497,499,500,501,504,505,508,509,510,511,512,513,514,516,519,521,522,524,525,526,527)'); */

$rows = $db->getRows('SELECT `id`,  `member_name`, `member_email`, `streetAddress`, `shipToCity`, `shipToState`, `shipToCountry`, `shipToZip` FROM `mall_vendorstore_orders` where `member_email`!="" and `updated_to_zoho`="NO" ORDER BY `id` ASC limit 150 ');

ArrayDisplay($rows);

$rowVal = 0;

if (!empty($rows)) {
	foreach($rows as $row){
		# Getting ticket buyer info
		
					$ticketMemberData = array(
												"data" => array(
													 array(
														
														"itempkid" => "tkt".$row['id'],
														"itempkidtwo" => "tkt".$row['id'],
														"Last_Name" => $row['member_name'], 
														"Email" => $row['member_email'], 
														"Mailing_Street" => $row['streetAddress'] ,
														"Mailing_City" => $row['shipToCity'] ,
														"Mailing_State" => $row['shipToState'], 
														"Mailing_Zip" => $row['shipToZip'],
														"Mailing_Country" => $row['shipToCountry'],
														"date" => displayDate($current_date,'M d, Y'),
														"Account_Name" => $row['member_email'],
														"itemtype" => "ticket"
													)), 
												 
												"trigger" =>array(
														   "approval", 
														   "workflow", 
														   "blueprint" 
														)
												
												); 
						$ticketMemberInsert = callAPI('POST', 'https://www.zohoapis.com/crm/v2/Contacts', json_encode($ticketMemberData), $accessToken);
						$responseticketVal = json_decode($ticketMemberInsert, true);
						ArrayDisplay($responseticketVal);
				$db->query('UPDATE `mall_vendorstore_orders` SET `updated_to_zoho`="YES"  WHERE `id`='.$row['id'].'');
				$rowVal++;
			}
		}
//exit;	
//$db->query('update `bmse_expos` set `zohostatus`="updated"  WHERE `id`='.$futureExpo['id'].'');

echo "Total Records Updated " . $rowVal;