bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

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

$query2 = $db->getRows("
					   (SELECT `id`, `name` as 'eventname', `city` as 'eventcity', `state` as `eventstate`, `country` as `eventcountry`, `zip` as `eventzipcode`, DATE(`start_dttm`) as 'eventstartdate', DATE(`end_dttm`) as 'eventenddate', `event_custom_title` as 'eventcustomtitle', `lectureslot_start_time_sat` as `eventsaturdaytimingfrom`, `lectureslot_end_time_sat` as `eventsaturdaytimingto`, `time_interval_sat` as `satdaytimeinterval`, `lectureslot_start_time_sun` as `eventsundaytimingfrom`, `lectureslot_end_time_sun` as `eventsundaytimingto`, `time_interval_sun` as `sundaytimeinterval`, `eventheroimage`, `expo_hall_id` as `eventhallname`,`lectureslot_start_time`, `lectureslot_end_time` FROM bmse_expos as A where A.status=1 and A.remove=1 and A.`force_display`='ON')
						UNION
						(SELECT `id`, `name` as 'eventname', `city` as 'eventcity', `state` as `eventstate`, `country` as `eventcountry`, `zip` as `eventzipcode`, DATE(`start_dttm`) as 'eventstartdate', DATE(`end_dttm`) as 'eventenddate', `event_custom_title` as 'eventcustomtitle',`lectureslot_start_time_sat` as `eventsaturdaytimingfrom`, `lectureslot_end_time_sat` as `eventsaturdaytimingto`, `time_interval_sat` as `satdaytimeinterval`, `lectureslot_start_time_sun` as `eventsundaytimingfrom`, `lectureslot_end_time_sun` as `eventsundaytimingto`, `time_interval_sun` as `sundaytimeinterval`, `eventheroimage`, `expo_hall_id` as `eventhallname`,`lectureslot_start_time`, `lectureslot_end_time`  FROM bmse_expos as B where B.status=1 and B.remove=1 and B.`featured`='ON' and B.`end_dttm`>='".date('Y-m-d h:i:s') . "' and B.`force_display`='NORMAL' order by 'eventstartdate' ASC) limit 3
					   ");
ArrayDisplay($query2);
array_multisort(array_column($query2, 'eventstartdate'), SORT_ASC, $query2);					   
$feature_values = [];
$spotlightvalues = [];
ArrayDisplay($query2);
$rows2 = array();
foreach ($query2 as $row2) {
	# Getting hall name
	$expohallinfo = $db->getRow('select `name`, `city` as `eventcity`,  `state` as `eventstate`, `country` as `eventcountry`, `zip` as `eventzipcode`  FROM `bmse_halls` WHERE `id`=' . $row2['eventhallname'] . '');

if ($row2['eventheroimage'] != '' and file_exists(DOCUMENT_ROOT . 'hfm/' . $row2['eventheroimage'])) {
		$row2['eventheroimage'] = SITE_PATH . 'hfm/' . $row2['eventheroimage'];
	} else {
		$row2['eventheroimage'] = '';
	}
	$expostartdate = date('d', strtotime($row2['eventstartdate']));
	$expoenddate = date('d', strtotime($row2['eventenddate']));
	
	$eventDate = date('M j', strtotime($row2['eventstartdate'])).'-'. date('j', strtotime($row2['eventenddate']));
	
	# getting tickets count
	$ticketsCount = getExpoTicketsCount($row2['id']);
	
	
	
	$rows2['id'] = $row2['id'];
	$rows2['title'] = $row2['eventname'];
	$rows2['city'] = $expohallinfo['eventcity'];
	$rows2['state'] = $expohallinfo['eventstate'];
	$rows2['zip'] = $expohallinfo['eventzipcode'];
	$rows2['startDate'] = $row2['eventstartdate'];
	$rows2['endDate'] = $row2['eventenddate'];
	$rows2['picture'] = $row2['eventheroimage'];
	$rows2['place'] = $expohallinfo['name'];
	if ($ticketsCount > 1) {
		//echo "this is first";
		$rows2['buyTicketURL'] = SITE_PATH . 'event/vendor_tickets.php?eid=' . $row2['id'] . '';
	} else {
		//echo "this is second";
		$expoTicketInfoval = getexpoTicketInfoval($row2['id']);
		//ArrayDisplay($expoTicketInfoval);
		$rows2['buyTicketURL'] = SITE_PATH . 'event/ticket_details.php?eid=' . $expoTicketInfoval['expo_id'] . '&product_id='.$expoTicketInfoval['id'].'&vendor_id=""&workshopid=""';
	}
	$rows2['buyBoothURL'] = SITE_PATH . 'floorplan/index.php?eid=' . $row2['id'] . '';
	$rows2['eventurl'] = SITE_PATH . 'event/eventhome.php?eid=' . $row2['id'] . '';
	
	$rows2['eventDate'] = $eventDate;
	
	$feature_values[] = $rows2;
}
$valuelist['events'] = $feature_values;

# Getting list of spotlight events

$query1 = $db->getRows("SELECT `id`, `name` as 'eventname', `city` as 'eventcity', DATE(`start_dttm`) as 'eventstartdate', DATE(`end_dttm`) as 'eventenddate',`eventspotimage` FROM bmse_expos where status=1 and remove=1 and `spotlight`='ON' and `end_dttm`>='" . date('Y-m-d h:i:s') . "' order by start_dttm ASC limit 2");

$rows1 = array();
foreach ($query1 as $row1) {
	# Getting hall name

if ($row1['eventspotimage'] != '' and file_exists(DOCUMENT_ROOT . 'hfm/' . $row1['eventspotimage'])) {
		$row1['eventspotimage'] = SITE_PATH . 'hfm/' . $row1['eventspotimage'];
	} else {
		$row1['eventspotimage'] = '';
	}
	
	$expostartdate = date('d', strtotime($row1['eventstartdate']));
	$expoenddate = date('d', strtotime($row1['eventenddate']));
	
	$eventDate = date('M j', strtotime($row1['eventstartdate'])).'-'. date('j', strtotime($row1['eventenddate']));
	
	
	
	$rows1['id'] = $row1['id'];
	$rows1['title'] = $row1['eventname'];
	$rows1['city'] = $row1['eventcity'];
	$rows1['startDate'] = $row1['eventstartdate'];
	$rows1['endDate'] = $row1['eventenddate'];
	$rows1['picture'] = $row1['eventspotimage'];
	
	$rows1['eventDate'] = $eventDate;

$rows1['eventurl'] = SITE_PATH . 'event/eventhome.php?eid=' . $row1['id'] . '';
	$spotlightvalues[] = $rows1;
}
$valuelist['spotlight'] = $spotlightvalues;

//ArrayDisplay($spotlightvalues);

# Getting list of upcoming events

$query3 = $db->getRows("SELECT `id`, `name` as 'eventname', `city` as 'eventcity', DATE(`start_dttm`) as 'eventstartdate', DATE(`end_dttm`) as 'eventenddate' ,  
`expo_hall_id` as `eventhallname` FROM bmse_expos where status=1 and remove=1  and `end_dttm`>='" . date('Y-m-d h:i:s') . "' order by start_dttm ASC limit 2");

$rows3 = array();

foreach ($query3 as $row3) {
	# Getting hall name

$expohallinfo = $db->getRow('select `name`, `address_line_1` , `city` as `eventcity`,  `state` as `eventstate`, `country` as `eventcountry`, `zip` as `eventzipcode` FROM `bmse_halls` WHERE `id`=' . $row3['eventhallname'] . '');
	$row3['eventhallname'] = $expohallinfo['name'];
	$row3['eventurl'] = SITE_PATH . 'event/eventhome.php?eid=' . $row3['id'] . '';
	
	$expostartdate = date('d', strtotime($row3['eventstartdate']));
	$expoenddate = date('d', strtotime($row3['eventenddate']));
	
	$eventDate = date('M j', strtotime($row3['eventstartdate'])).'-'. date('j', strtotime($row3['eventenddate']));

$rows3['id'] = $row3['id'];
	$rows3['title'] = $row3['eventname'];
	$rows3['place'] = $row3['eventhallname'];
	$rows3['addess'] = $expohallinfo['address_line_1'];
	$rows3['city'] = $expohallinfo['eventcity'];
	$rows3['state'] = $expohallinfo['eventstate'];
	$rows3['zip'] = $expohallinfo['eventzipcode'];
	$rows3['startDate'] = $row3['eventstartdate'];
	$rows3['endDate'] = $row3['eventenddate'];
	$rows3['eventDate'] = $eventDate;
	
	$rows3['eventurl'] = $row3['eventurl'];
	$upcomingevents[] = $rows3;
}
$valuelist['upcomingEvents'] = $upcomingevents;

$smarty->assign('EVENTS_CONTENT',$feature_values);
$smarty->assign('EVENTS_SPOTCONTENT',$spotlightvalues);
$smarty->assign('UPCOMING_EVENTCONTENT',$upcomingevents);

$smarty->display(TEMPLATE_DOCROOT_PATH.'default/home.tpl');