bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
ob_start();
session_start();
header('Content-Type: application/json');
//CONFIGARATIONS - /////////////////////////////////////
//ini_set('display_errors',1);
define("SITE_PATH","https://www.bmse.net/");
define("DOCUMENT_ROOT","/home/w0yxy4bjb020/public_html/bmse.net/bmseweb/");

define("DB_SERVER","localhost");
define("DB_USER","bmsebro");
define("DB_PASSWORD","4rfvbhu8");
define("DB_NAME","bmse");
define("DB_NAME2","bmsemall");
require_once("includes/classes/mysql.class.php");
$db = new Database(DB_SERVER,DB_USER,DB_PASSWORD,DB_NAME);
//include ("fpconfig.php");
$name1 = mysqli_connect('localhost','bmsebro','4rfvbhu8','bmse');

$valuelist=array();
$_REQUEST['eid']=412;

# Getting hero images
	$query1 = mysqli_query($name1,"SELECT `convertedname` as 'image'  FROM `bmse_hero_files_manage` where status=1  and `expo_id`=".$_REQUEST['eid']."   limit 4");
		while($row1 = mysqli_fetch_assoc($query1)){
			if ($row1['image']!='' AND file_exists(DOCUMENT_ROOT.'hfm/'.$row1['image'])) {
				$row1['image']=SITE_PATH.'hfm/'.$row1['image'];
			} else {
				$row1['image']='';
			}
			$images[]=$row1;
		}
	$valuelist['headerimages']=$images;

# Getting event details
	$query2 = mysqli_query($name1,"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', `eventheroimage`, `expo_hall_id` as `eventhallname`, `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`  FROM `bmse_expos` where status=1 and remove=1  and `id`=".$_REQUEST['eid']."  ");
		
		while($row2 = mysqli_fetch_assoc($query2)){
			# Getting hall name
			$expohall = mysqli_query($name1,'select `name` FROM `bmse_halls` WHERE `id`='.$row2['eventhallname'].'');
			$expohallinfo=mysqli_fetch_assoc($expohall);
			
			# Getting expo highlight content
			$expohighlight = mysqli_query($name1,'select `title` as `eventhighlighttitle`, `description` as `eventhighlightcontent` FROM `bmse_expo_highlights` WHERE `expo_id`='.$row2['id'].'');
			$expohighlightinfo=mysqli_fetch_assoc($expohighlight);
		
			#getting tickets for this event
			$expoticket = mysqli_query($name1,'select `price`  FROM `mall_vendorstore_products` WHERE `expo_id`='.$row2['id'].' order by `price` ASC limit 1');
			$expoticketinfo=mysqli_fetch_assoc($expoticket);
			if (!empty($expoticketinfo)) {
				$row2['ticketpricefrom']=$expoticketinfo['price'];
				$row2['buyticketurl']=SITE_PATH.'event/vendor_tickets.php?eid='.$row2['id'].'';
			} else {
				$row2['ticketpricefrom']='';
				$row2['buyticketurl']='';
			}
			$row2['eventhallname']=$expohallinfo['name'];
			$row2['buyboothurl']=SITE_PATH.'floorplan/index.php?eid='.$row2['id'].'';
			$row2['eventurl']=SITE_PATH.'event/eventhome.php?eid='.$row2['id'].'';
			
			$row2['eventsaturdaytimingfrom']= substr($row2['eventsaturdaytimingfrom'],0,2);
			$row2['eventsaturdaytimingto']= substr($row2['eventsaturdaytimingto'],0,2);
			$row2['satdaytimeinterval']= substr($row2['satdaytimeinterval'],0,2);
			
			$row2['eventsundaytimingfrom']= substr($row2['eventsundaytimingfrom'],0,2);
			$row2['eventsundaytimingto']= substr($row2['eventsundaytimingto'],0,2);
			$row2['sundaytimeinterval']= substr($row2['sundaytimeinterval'],0,2);
			
		$event_details[]=$row2;
	}
	$valuelist['eventdetails']=$event_details;
	
	# Getting event tickets
	$tickets=array();
	$ticketdetails=array();
	$query3 = mysqli_query($name1,"SELECT `id`, `category_name` as 'categoryname'  FROM `mall_vendorstore_categories` where status=1 and remove=1  and `expo_id`=".$_REQUEST['eid']."  ");
	while($row3 = mysqli_fetch_assoc($query3)){
		
		#Getting category tickets
		$expotickets = mysqli_query($name1,'select `productname` as `tickettitle`, `price` FROM `mall_vendorstore_products` WHERE `category_id`='.$row3['id'].'');
		
		
		while($row4=mysqli_fetch_assoc($expotickets)){
			$ticketdetails[]=$row4;
		}
		
		$tickets[$row3['categoryname']]=$ticketdetails;
		
	}
	$valuelist['tickets']=$tickets;
	
	# Getting event exhibitors
	$query5 = mysqli_query($name1,'SELECT
			M.companyname,M.company_logo as `boothlogo`,EB.title as `title`,EB.shortdescription as `shortdescription`, EB.booth_logo as `boothlogo`, M.image_name as `exhbitorimage`,M.name as `exhibitorname`, M.website as `exhibitorwebsite`,ER.room_number as `boothnumber`, M.id as memberid,M.city as `exhibitorcity`,M.state as `exhibitorstate`, `address` as `exhibitoraddress`, `country` as `exhibitorcountry`, `zip`,  M.email
		FROM `bmse_expo_rooms` ER
			LEFT JOIN `bmse_booth_configs` EB ON ER.id=EB.boothid
			LEFT JOIN `bmse_order_details` OD ON ER.id = OD.item_id
			LEFT JOIN `bmse_orders` O ON O.id = OD.order_id
			LEFT JOIN `bmse_members` M ON M.id = O.member_id
		WHERE
			ER.expo_id = ' . $_REQUEST['eid'] . '
			AND OD.item_type_id = 1
			AND ER.order_status != 0 AND ER.status=1 AND ER.remove=1');
		
		while($row5 = mysqli_fetch_assoc($query5)){
			# Getting exhibitor country
			$exhibitorcountry = mysqli_query($name1,'select `countries_name` FROM `bmse_countries` WHERE `countries_id`='.$row5['exhibitorcountry'].'');
			$exhibitorcountryinfo=mysqli_fetch_assoc($exhibitorcountry);
			
			# Getting exhibitor state
			$exhibitorstate = mysqli_query($name1,'select `state` FROM `bmse_states` WHERE `id`="'.$row5['exhibitorstate'].'"');
			$exhibitorstateinfo=mysqli_fetch_assoc($exhibitorstate);
			
			
			if ($row5['boothlogo']!='' AND file_exists(DOCUMENT_ROOT.'exhibitoradmin/images/boothlogos/'.$row5['boothlogo'])){
				$row5['boothlogo']=SITE_PATH.'exhibitoradmin/images/boothlogos/'.$row5['boothlogo'];
			} else {
				$row5['boothlogo']=SITE_PATH.'exhibitoradmin/images/boothlogos/default-company-logo.jpg';
			}
			if ($row5['exhbitorimage']!='' AND file_exists(DOCUMENT_ROOT.'exhibitoradmin/images/exhibitor_images/'.$row5['exhbitorimage'])){
				$row5['exhbitorimage']=SITE_PATH.'exhibitoradmin/images/exhibitor_images/'.$row5['exhbitorimage'];
			} else {
				$row5['exhbitorimage']=SITE_PATH.'exhibitoradmin/images/exhibitor_images/bmse_default_image.jpg';
			}
			$row5['exhibitorcountry']=$exhibitorcountryinfo['countries_name'];
			$row5['exhibitorstate']=$exhibitorstateinfo['state'];
			$exhibitors[]=$row5;
		
		}
	    $valuelist['exhibitors']=$exhibitors;
	
	
	# Getting event speakers
	$expo=$db->getRow('SELECT * FROM `bmse_expos` WHERE `id`='.$_REQUEST['eid'].'');
	
	$expostartdate=date('d',strtotime($expo['start_dttm']));
	$expoenddate=date('d',strtotime($expo['end_dttm']));
	if(date('m',strtotime($expo['start_dttm']))==date('m',strtotime($expo['end_dttm']))){
		$expodays=($expoenddate-$expostartdate)+1;
	}else{
		$noofdaysinmonth=date('t',strtotime($expo['start_dttm']));
		$expodays=($noofdaysinmonth-$expostartdate);
		$expodays+=$expoenddate+1;
	}
	$dates=array();
	for($i=0;$i<$expodays;$i++){
		$expodates  = mktime(0, 0, 0, date("m",strtotime($expo['start_dttm'])),date("d",strtotime($expo['start_dttm']))+$i, date("Y",strtotime($expo['start_dttm'])));
		$dates[]=date('Y-m-d',$expodates);
	}
	$lecture_rooms=$db->getRows("SELECT id,room_number FROM `bmse_expo_rooms` where expo_id='".$_REQUEST['eid']."' and type='2' and status='1' and remove='1' ORDER BY room_number ASC");
	//ArrayDisplay($lecture_rooms);
	foreach($dates as $key=>$lecture_dates){
		$lectureTime=$db->getRows("SELECT DISTINCT lectureslot_start_time,lectureslot_end_time FROM `bmse_expo_lecture_slots` where  expo_id='".$_REQUEST['eid']."' and status='1'
					  and remove='1' and slot_date='".$lecture_dates."' ORDER BY lectureslot_start_time ");
		foreach($lectureTime as $key=>$lecture_times){
			foreach($lecture_rooms as $room_num){
				$query='SELECT 
							BLC.presenter_name ,BLC.paid_workshop,BMLS.id,BLC.workshop_ticket,OD.booth_id,BLC.title ,BM.id as memberid, BLC.presenter_image,BM.companyname,BLC.description,BLC.slot_id
						FROM `bmse_expo_lecture_slots` BMLS 
								LEFT JOIN `bmse_lectureslot_configs` BLC on BMLS.id=BLC.slot_id 
								LEFT JOIN `bmse_order_details` OD ON BMLS.id = OD.item_id
								LEFT JOIN `bmse_orders` O ON OD.order_id = O.id
								LEFT JOIN `bmse_members` BM ON BM.id=O.member_id
						WHERE  BMLS.lectureslot_start_time="'.$lecture_times['lectureslot_start_time'].'"  
								AND BMLS.room_id='.$room_num['id'].' 
								AND BMLS.slot_date="'.$lecture_dates.'" ';
				$query.=' 	AND BMLS.expo_id='.$_REQUEST['eid'].'   
							AND BMLS.id IN(SELECT item_id FROM `bmse_order_details` where item_type_id=2 AND order_id=O.id) AND BMLS.status=1 AND BMLS.remove=1 
							
							ORDER BY BMLS.slot_date ';

//echo $query . "<br />";
                                $slot=$db->getRow($query);
								//ArrayDisplay($slot);
				if(!empty($slot)){
					
					 $slotarray['speakername']=$slot['presenter_name'];
                                        $slotarray['speakername']=$slot['presenter_name'];
									//	$slotarray['memberid']=$slot['memberid'];
					//$slotarray['companyname']=$slot['companyname'];                                      
					//$slotarray['date']=$lecture_dates;
					$slotarray['presentationtitle']=$slot['title'];
					//$slotarray['slot_id']=$slot['slot_id'];
					//$slotarray['workshop_ticket']=$slot['workshop_ticket'];
				//	$slotarray['paid_workshop']=$slot['paid_workshop'];
					//$slotarray['time']=date('g:i A',strtotime($lecture_times['lectureslot_start_time']))."-".date('g:i A',strtotime($lecture_times['lectureslot_end_time']));
				//	$slotarray['lectureslot_start_time']=strtotime($lecture_times['lectureslot_start_time']);
				//	$slotarray['room_number']="Room ".substr($room_num['room_number'],3);
				//	$slotarray['room']=substr($room_num['room_number'],3);
					# Getting exhibitor booth number for this slot - added on 16th Feb, 2022
					$boothno=$db->getRow('SELECT `room_number` FROM `bmse_expo_rooms` WHERE `id`='.$slot['booth_id'].'');
					//$slotarray['exporoom'] = $boothno['room_number'];
					//echo $exhibitorimage.'<br>';
					if($slot['presenter_image']){
						$exhibitorimage=SITE_PATH.'exhibitoradmin/images/presenters/'.$slot['presenter_image'].'';
					}else{
						$exhibitorimage=SITE_PATH.'exhibitoradmin/images/presenters/bmse_default_image_presenter.jpg';
						//$exhibitorimage=SITE_ADMIN_IMAGES_SITE_PRE_PATH.$producer_email['presenter_logo'];
					}
					$slotarray['speakerimage']=$exhibitorimage;
					
					//$slotarray['description']=wordwrap(substr($slot['description'],0,300), 70, "<br>\n");
                                       // $slotarray['description']=$slot['description'];
					$db = new Database(DB_SERVER,DB_USER,DB_PASSWORD,DB_NAME2);
					//$slotarray['vender_id'] = 0;
					if($slot['paid_workshop']==1){
						$getvendor_id=$db->getRow('select MVP.id as product, MVP.qty, MVP.product_status, MVC.vendor_id from mall_vendorstore_products MVP left join mall_vendorstore_categories MVC on MVP.category_id=MVC.id where MVP.id='.$slot['workshop_ticket'].'');
					//	$slotarray['vender_id']=$getvendor_id['vendor_id'];
					//	$slotarray['product_id']=$getvendor_id['product'];
					//	$slotarray['qty']=$getvendor_id['qty'];
					//	$slotarray['product_status']=$getvendor_id['product_status'];
					}
					$db = new Database(DB_SERVER,DB_USER,DB_PASSWORD,DB_NAME);
					$Expo_Speakers[$slot['id']]=$slotarray;
					if(isset($_REQUEST['day']) && $_REQUEST['day'] == date('l',strtotime($lecture_dates))){
						$Day_Speakers[$slot['id']]=$slotarray;
					}
					$LectureScheduleDataArray[date('l',strtotime($lecture_dates))][$slotarray['time']][substr($room_num['room_number'],3)]=$slotarray;
					$Records++;
				}
			}
		}
							
	}
		
		//print_r($Expo_Speakers);
		//exit;
	 $valuelist['speakers']=$Expo_Speakers;	
	
	
	
	
	
# Getting list of upcoming events

$query3 = mysqli_query($name1,"SELECT `id`, `name` as 'eventname', `city` as 'eventcity', DATE(`start_dttm`) as 'eventstartdate', DATE(`end_dttm`) as 'eventenddate' , `expo_hall_id` as `eventhallname`, `expo_logo` as 'expoimage' FROM bmse_expos where status=1 and remove=1  and `start_dttm`>='".date('Y-m-d  00:00:00')."' order by start_dttm ASC limit 2");
	
	
	
	while($row3 = mysqli_fetch_assoc($query3)){
		# Getting hall name
	
		$expohall = mysqli_query($name1,'select `name` FROM `bmse_halls` WHERE `id`='.$row3['eventhallname'].'');
		$expohallinfo=mysqli_fetch_assoc($expohall);
		
	
		
		$row3['eventhallname']=$expohallinfo['name'];
		$row3['buyticketurl']=SITE_PATH.'event/vendor_tickets.php?eid='.$row3['id'].'';
		$row3['buyboothurl']=SITE_PATH.'floorplan/index.php?eid='.$row3['id'].'';
		
		$row3['eventurl']=SITE_PATH.'event/eventhome.php?eid='.$row3['id'].'';
		
		if ($row3['expoimage']!='' AND file_exists(DOCUMENT_ROOT.'admin/images/expologos/'.$row3['expoimage'])) {
			$row3['expoimage']=SITE_PATH.'admin/images/expologos/'.$row3['expoimage'];
		} else {
			$row3['expoimage']='';
		}
		$row3['region']='Southern';
		
		
		$upcomingevents[]=$row3;
	}
	$valuelist['upcomingevents']=$upcomingevents;
	
	# Getting social media
	$query4 = mysqli_query($name1,"SELECT `id`, `community_name` as 'socialmedianame', `logo` as 'socialmedialogo', `website` as 'socialmediaurl' FROM `bmse_expo_social_networks` where status=1 and remove=1   limit 3");
    while($row4 = mysqli_fetch_assoc($query4)){
		
		if ($row4['socialmedialogo']!='' AND file_exists(DOCUMENT_ROOT.'admin/images/socialnetworks/'.$row4['socialmedialogo'])) {
			$row4['socialmedialogo']=SITE_PATH.'admin/images/socialnetworks/'.$row4['socialmedialogo'];
		} else {
			$row4['socialmedialogo']='';
		}
		
		
		$socialmedia[]=$row4;
	}
	$valuelist['socialmedia']=$socialmedia;
	
	# Getting sponsors
	$query5 = mysqli_query($name1,"SELECT `id`, `sponsor_name` as 'sponsorname', `filename` as 'sponsorlogo', `website` as 'sponsorwebsite' FROM `bmse_admin_level_sponsors` where status=1 and remove=1   limit 5");
    while($row5 = mysqli_fetch_assoc($query5)){
		
		if ($row5['sponsorlogo']!='' AND file_exists(DOCUMENT_ROOT.'admin/images/admin_sponsors/'.$row5['sponsorlogo'])) {
			$row5['sponsorlogo']=SITE_PATH.'admin/images/admin_sponsors/'.$row5['sponsorlogo'];
		} else {
			$row5['sponsorlogo']='';
		}
		
		
		$sponsorslist[]=$row5;
	}
	$valuelist['sponsors']=$sponsorslist;	
   
    # Getting join us text
    $query6 = mysqli_query($name1,"SELECT `joinustitle` , `joinustext`  FROM `bmse_site_preferences`");
    while($row6 = mysqli_fetch_assoc($query6)){
		$joinustext[]=$row6;
	}
	$valuelist['joinus']=$joinustext;	
  // echo '<pre>';
  // print_r($valuelist);

echo json_encode($valuelist);