bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

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

# getting exhibitor

/*$futureExpos = $db->getRows('SELECT `id` FROM `bmse_expos` WHERE DATE(`start_dttm`) > "2023-12-30" and `status`=1 and `remove`=1 and `zohostatus`="update" order by `id`  ASC limit 1 ');*/

$futureExpos = $db->getRows('SELECT `id` FROM `bmse_expos` WHERE  `status`=1 and `remove`=1 and id="535" order by `id`  ASC limit 1 ');
ArrayDisplay($futureExpos);

$rowVal = 0;
if (!empty($futureExpos)) {
	foreach($futureExpos as $futureExpo){
		# Getting exhibitors and booths
		
		$rows = $db->getRows("SELECT  BER.expo_id,BER.id as boothid,BM.id as exhibitorid,BM.email, BE.zoho_tag,BM.companyname
                                                    FROM
                                                        `bmse_orders` BO
                                                        LEFT JOIN `bmse_order_details` BOD ON BO.id=BOD.order_id
                                                        LEFT JOIN `bmse_expo_rooms` BER ON BER.id=BOD.item_id
                                                        LEFT JOIN `bmse_booth_configs` BBC on BBC.boothid=BOD.item_id
                                                        LEFT JOIN `bmse_expos` BE on BER.expo_id=BE.id
														LEFT JOIN `bmse_members` BM ON BO.member_id=BM.id
                                                    WHERE
                                                        BER.expo_id=".$futureExpo['id']."
                                                        AND BOD.item_type_id=1
                                                        AND BER.order_status!=0
																												AND BE.status=1
																												AND BE.remove=1 "); 
		ArrayDisplay($rows);		
	//	exit;
		if(!empty($rows)) {
			
			foreach($rows as $row) {
					$zohoValues = array(
								"itempkid" => "exhi".$row['exhibitorid'],
								"email" => $row['email'], 
								"account_name" => $row['email'],
								"itemtype" => "becomeexhibitor",
								"booth_id" => $row['boothid'],
								"expo_id" => $row['expo_id'],
								"expoids" => $row['expo_id'],
								"insert_dttm" => $current_date,
								"zoho_tags" => $row['zoho_tag'],
								"record_type" => "contact",
								"sourcefrom" => "2024expo-exhibitor-migration",
								"company" => $row['companyname'],
								"user_name" => $row['contactname']
					);
											
					$db->insert('bmse_zoho_ex_records', $zohoValues);	
				
				$rowVal++;
			}
		}
//exit;	
$db->query('update `bmse_expos` set `zohostatus`="updated"  WHERE `id`='.$futureExpo['id'].'');		
	}
}

echo "Total Records Updated " . $rowVal;