bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

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

# getting exhibitor

$ticketSales = $db->getRows('SELECT `expo_id`, `id`, `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) AND `zohostatus`="update" order by `expo_id`	 ASC');

//ArrayDisplay($ticketSales);

$rowVal = 0;

if (!empty($ticketSales)) {
	foreach($ticketSales as $ticketSale){
		
		$row = $db->getRow('SELECT `id`,  `member_name`, `member_email`, `streetAddress`, `shipToCity`, `shipToState`, `shipToCountry`, `shipToZip` FROM `mall_vendorstore_orders` where `id`='.$ticketSale['order_id'].'');
		
		#getting expo tag
		$expoTag = $db->getRow('SELECT `zoho_tag` FROM `bmse_expos` WHERE `id`='.$ticketSale['expo_id'].'');
			
					$zohoValues = array(
								"itempkid" => "tkt".$row['id'],
								"email" => $row['member_email'], 
								"account_name" => $row['member_email'],
								"itemtype" => "ticket",
								"expo_id" => $ticketSale['expo_id'],
								"insert_dttm" => $current_date,
								"zoho_tags" => $expoTag['zoho_tag'],
								"record_type" => "contact",
								"sourcefrom" => "2024expo-ticket-migration",
								"company" => $row['member_name'],
								"user_name" => $row['member_name']
					);
											
					$db->insert('bmse_zoho_tk_records', $zohoValues);	
				ArrayDisplay($zohoValues);
				$rowVal++;

$db->query('update `expo_ticket_sales` set `zohostatus`="updated"  WHERE `id`='.$ticketSale['id'].'');		
	}
}

echo "Total Records Updated " . $rowVal;