bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
include('includes/application_includes.php');
ini_set('display_errors',1);
$orderdetailsinfo = $db->getRows('SELECT `item_id`, count(*) as `bcount` FROM `bmse_order_details` WHERE `item_type_id`=1 group by `item_id` HAVING count(*) > 1');
$currendate=date('Y-m-d');

if (!empty($orderdetailsinfo)) {
	$i=0;
	foreach($orderdetailsinfo as $orderdetailsin) {
		
		# Getting expo name, id and room number
		$roominfo = $db->getRow('SELECT `id`, `expo_id`, `room_number` FROM `bmse_expo_rooms` WHERE `id`='.$orderdetailsin['item_id'].' and `expo_id` not in (311,361)');
		//$roominfo = $db->getRow('SELECT `id`, `expo_id`, `room_number` FROM `bmse_expo_rooms` WHERE `id`='.$orderdetailsin['item_id'].' ');
		
			if ($roominfo['expo_id']) {
				$expoinfo = $db->getRow('SELECT `id`, `name`, `start_dttm` FROM `bmse_expos` WHERE `id`='.$roominfo['expo_id'].' and date(`start_dttm`) > "'.$currendate.'"');
				//$expoinfo = $db->getRow('SELECT `id`, `name`, `start_dttm` FROM `bmse_expos` WHERE `id`='.$roominfo['expo_id'].' ');
				
			}
			if ($expoinfo) {
				echo 'Booth ('.$orderdetailsin['bcount'].') =>'.$roominfo['room_number'].', Expo Name =>'. $expoinfo['name'].', Expo Id => '. $expoinfo['id'].', Expo Start Date => '. displayDate($expoinfo['start_dttm']).'';
				echo ' ';
				$i++;
			}
	
		
		
		
	}
	
}

echo 'Booths ';
echo ' '.$i. ' Records Found';
echo ' '. displayDateTime(date('Y-m-d H:i'));

$orderdetailsinfol = $db->getRows('SELECT `item_id`, count(*) as `lcount` FROM `bmse_order_details` WHERE `item_type_id`=2 group by `item_id` HAVING count(*) > 1');
echo ' ';

if (!empty($orderdetailsinfol)) {
	$i=0;
	foreach($orderdetailsinfol as $orderdetailsinl) {
		
		# Getting expo name, id and room number
		$slotinfol = $db->getRow('SELECT `id`, `expo_id` FROM `bmse_expo_lecture_slots` WHERE `id`='.$orderdetailsinl['item_id'].' and `expo_id` not in (311,361)');
		//$roominfo = $db->getRow('SELECT `id`, `expo_id`, `room_number` FROM `bmse_expo_rooms` WHERE `id`='.$orderdetailsin['item_id'].' ');
		
			if ($slotinfol['expo_id']) {
				$expoinfol = $db->getRow('SELECT `id`, `name`, `start_dttm` FROM `bmse_expos` WHERE `id`='.$slotinfol['expo_id'].' and date(`start_dttm`) > "'.$currendate.'"');
				//$expoinfol = $db->getRow('SELECT `id`, `name`, `start_dttm` FROM `bmse_expos` WHERE `id`='.$slotinfol['expo_id'].' ');
				
			}
			if ($expoinfol) {
				echo 'Slot Id ('.$orderdetailsinl['lcount'].') =>#'.$slotinfol['id'].', Expo Name =>'. $expoinfol['name'].', Expo Id => '. $expoinfol['id'].', Expo Start Date => '. displayDate($expoinfol['start_dttm']).'';
				echo ' ';
				$i++;
			}
	
		
		
		
	}
	
}

echo 'Lectures ';
echo ' '.$i. ' Records Found';
echo ' '. displayDateTime(date('Y-m-d H:i'));