bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
echo 'yes';
error_reporting(E_ALL);
ini_set('display_errors', '1');
include('includes/application_includes.php');

echo displayDate($current_date,'Y-m-d');
		//echo "tags here";
#zoho lead search starts here 
$tokenData = "refresh_token=".$refresh_token."&client_id=".$client_id."&client_secret=".$client_secret."&grant_type=refresh_token";

#getting access token
$getTokendata = callAPIP('POST', 'https://accounts.zoho.com/oauth/v2/token?', ($tokenData));

$tokenResponse = json_decode($getTokendata, true);
//echo "first";
//ArrayDisplay($tokenResponse);

/*
$rows = $db->getRows("SELECT `id`, `itempkid` , `zoho_tags`, `itemtype` , `email`, `company` FROM `bmse_zoho_records` WHERE  `email` in ('nalcantarx3@gmail.com','randallpaa@gmail.com','boop9359@gmail.com','katro2501@gmail.com')");*/

/*
$rows = $db->getRows('SELECT `id`, `itempkid` , `zoho_tags`, `itemtype` , `email`, `company` FROM `bmse_zoho_records` WHERE   `zoho_tags`!=" " and date(`insert_dttm`)>= "2024-11-06" and `itemtype`="ticket" and `status`= "update" order by rand() limit 100'); */
/*
$rows = $db->getRows('SELECT `id`, `itempkid` , `zoho_tags`, `itemtype` , `email`, `company` FROM `bmse_zoho_records` WHERE   `zoho_tags`!=" " and    `itemtype`="ticket" and `status`= "update" order by rand() limit 10');*/
/*
$rows = $db->getRows('SELECT `id`, `itempkid` , `zoho_tags`, `itemtype` , `email`, `company`, `expo_id` FROM `bmse_zoho_records` WHERE `itemtype`="ticket"  and date(`insert_dttm`)>="2025-01-04" and `status`="update" order by rand() limit 10');*/

$rows = $db->getRows('SELECT `id`, `itempkid` , `zoho_tags`, `itemtype` , `email`, `company`, `expo_id` FROM `bmse_zoho_records` WHERE `itemtype`="ticket"  and `id` in (11399)');
// 11228
//11399
ArrayDisplay($rows);
//exit;

/*
$rows = $db->getRows('SELECT `id`, `itempkid` , `zoho_tags`, `itemtype` , `email`, `company` FROM `bmse_zoho_records` WHERE   `zoho_tags`!=" " and  `itemtype`="ticket" and `id` in (10907,10908)');*/

//ArrayDisplay($rows);

//exit;
$sponsorrow = 0;
	$speakerrow = 0;
	$exhibitorrow = 0;
	$ticketrow=0;
if (!empty($rows)) {
	$tag='';
	$data['Event_Booth_Purchases']='';
	$data['Event_Ticket_Purchased']='';
	$searchResponse['data']='';
	foreach ($rows as $row) {
		
		 if($row['itemtype']=='ticket'){ #case4 - ticket
		 
		
		 # getting ticket member details from mall store orders
		 $orderInfo = $db->getRow('SELECT  `id`, `streetAddress`, `shipToCity`, `shipToState`, `shipToCountry`, `shipToZip`, `phone_number`, `member_fname`, `member_lname` from   `mall_vendorstore_orders` where `member_email`="'.$row['email'].'" order by id desc');
		 ArrayDisplay($orderInfo);
		// exit;
		if ($row['expo_id']!='') {
			$cityhallInfo = $db->getRow('SELECT `id`, `expo_hall_id` FROM `bmse_expos` WHERE `id`='.$row['expo_id'].'');
			//ArrayDisplay($cityhallInfo);
			$cityInfo = $db->getRow('SELECT `id`, `city_new` FROM `bmse_halls` WHERE `id`='.$cityhallInfo['expo_hall_id'].'');
			//ArrayDisplay($cityInfo);
			$cityInfoname  = $db->getRow('SELECT `id`, `name` FROM `bmse_expo_cities` WHERE `id`='.$cityInfo['city_new'].'');
			//ArrayDisplay($cityInfoname);
		}
			
			$string = $row['zoho_tags'];
			$expo = $numbers = array();

if(preg_match_all('/([a-z ]+[0-9]+)/i', $string, $mt)) {
				$nrmt = count($mt[0]);
				for($i=0; $i<$nrmt; $i++) {
					if(preg_match('/([a-z ]+)([0-9]+)/i', $mt[0][$i], $mt2)) {
						$expo[$i] = trim($mt2[1]);
						$numbers[$i] = $mt2[2];
					}
				}
			}
	
	//echo $expo[0];

$compa = urlencode($row['email']);
			$itempkid=$compa;
			$searchRecord = callAPI('GET', 'https://www.zohoapis.com/crm/v2/Contacts/search?criteria=(Email:equals:'.$itempkid.')', '', $tokenResponse['access_token']);
			$searchResponse = json_decode($searchRecord, true);
			ArrayDisplay($searchResponse);
			if (!empty($searchResponse['data'])) {
				$eventInt = '';
				$eventIntu='';
				$eventInts='';
				$eventIntus='';
				$dataein='';
				foreach($searchResponse['data'] as $data) {
					//ArrayDisplay($data);
					if (!empty($data['Event_Ticket_Purchased'])) {
						//$data['Event_Ticket_Purchased'] = '';
						$record_idSports = array_push($data['Event_Ticket_Purchased'], $row['zoho_tags']);
					
					
					} else {
						$data['Event_Ticket_Purchased']=array($row['zoho_tags']);
					
					
					}
					$dataeins='';
					$datein='';
					$dateina = array();
					if ($data['Event_Interested_In']!='') {
						$dateina = explode(',',$data['Event_Interested_In']);
						//$record_idSports = array_push($data['Event_Interested_In'], $cityInfoname['name']);
						if(!in_array($cityInfoname['name'],$dateina)) {
							//$dataein.= $data['Event_Interested_In'].','.$cityInfoname['name'];
							 array_push($dateina, $cityInfoname['name']);
						}
						$dataein=implode(',',$dateina);
						//$dataeins='arvind';
					} else {
						$dataein=$cityInfoname['name'];
						//$dataeins='bhoom';
					}
					
					if ($data['id']) {
						$eventIntu = array_unique($data['Event_Ticket_Purchased']);
						$eventInt = implode(',',$eventIntu);
						
						//$eventIntus = array_unique($data['Event_Interested_In']);
						//$eventInts = implode(',',$eventIntus);
						
						$dataArray = array(
															"data" => array(
																 array(
																	"id" => $data['id'],
																	"Event_Ticket_Purchased" => $data['Event_Ticket_Purchased'],
																	//"Attendee" => "YES",
																	"Attendee" => "Attended",
																	"Mailing_Street" =>  $orderInfo['streetAddress'],
																	"Mailing_City" => $orderInfo['shipToCity'],
																	"Mailing_State" => $orderInfo['shipToState'],
																	"Mailing_Zip" => $orderInfo['shipToZip'],
																	"Phone" => $orderInfo['phone_number'],
																	"Mobile" => $orderInfo['phone_number'],
																	//"Date_entered" => displayDate($current_date,'m/d/Y'),
																	"Date_entered" => displayDate($current_date,'Y-m-d'),
																	"Mailing_Country" => "",
																	"First_Name" => $orderInfo['member_fname'],
																	"Last_Name" => $orderInfo['member_lname'],
																	"Event_Interested_In" => $dataein
																)), 
															 
															"trigger" =>array(
																	   "approval"
																	)
						); 
						$updateRecord = callAPI('PUT', 'https://www.zohoapis.com/crm/v2/Contacts/'.$data['id'].'', json_encode($dataArray), $tokenResponse['access_token']);
						$updateRecordresp = json_decode($updateRecord, true);
						echo "<pre>";
						print_r($updateRecordresp);
					}
				}
			}
			$db->query('update `bmse_zoho_records` set `status`="updated", `update_dttm`="'.$current_date.'" WHERE `id`='.$row['id'].'');
			$ticketrow++;
		 }
	}
}
echo "Sponsor Tags".":".$sponsorrow;
echo "<br/>";
echo "Speaker Tags".":".$speakerrow;
echo "<br/>";
echo "Exhibitor Tags".":".$exhibitorrow;
echo "<br/>";
echo "Ticket Tags".":".$ticketrow;

# Add tags for zoho lead - ends here