<?php
session_start();
if(!session_is_registered(myusername)){
header("location:../index.php");
}
 include '../conf/config.php';
 

 $pp=$_GET['p1'];
 
 $pl=$_GET['placeid'];
 $rating = $_GET['rating'];
 
 
 if($_REQUEST['des1'])
 $tickets = $_REQUEST['des1'];
 else
 $tickets=0;
 
 if($_REQUEST['des9'])
 $tours = $_REQUEST['des9'];
 else
 $tours=0;
 
 if($_REQUEST['des8'])
 $trans = $_REQUEST['des8'];
 else
 $trans=0;
 

 FUNCTION getOrder($arr)
 {
	if(count($arr)>0)
	{
		if(array_key_exists('Order', $arr[0]))
		{
			return $arr[0]['Order'];
		}
	}
	return 0;
 }
  FUNCTION CalcForAllHotels($hotelIDs,$fromDate,$toDate,$conn,$selected_tickets,$selected_tours,$selected_trans,$mid,$mealName,$toomType,$roomView)
 {
// $mealName = "SAI";
// $toomType = "STD";
 //$roomView = "GV";
 
	if($hotelIDs==null)
		return;
	$data = Array();
	foreach($hotelIDs as $hotelID)
	{
		$data1 = Array();
		$data1[] = CalcForHotel($hotelID,$fromDate,$toDate,$conn,$selected_tickets,$selected_tours,$selected_trans,$mid,$mealName,$toomType,$roomView);
		$data1['Order'] = getOrder($data1[0]);
		$data[] = $data1;
	}
	
	
	$data1 = Array();
	$order = Array();
	foreach ($data as $key => $row) {
        $order[$key]  = $row['Order'];
    }
    array_multisort($order, SORT_ASC, $data);
	
	$newData = Array();
	foreach($data as $key => $row)
	{
		$newData[] = $row[0];
	}
	
	$data = $newData;
	//print_r($data);
	//usort($data,"orderSort");
	//echo "---After Sort---";
	//print_r($data);
	
	return $data;
 }
 
function orderSort($item1,$item2)
{
    if ($item1['Order'] == $item2['Order']) return 0;
    return ($item1['Order'] < $item2['Order']) ? 1 : -1;
}

  
 FUNCTION getTicketData($selected_tickets,$conn)
{
	$sql = "SELECT additional_price,child_price,intant_price 
			FROM  Tickets
			where ticket_id=" . $selected_tickets;

	$result = mysql_query($sql,$conn);

	$rows = array();
	while(($row = mysql_fetch_array($result))) {
		$rows[] = $row;
	}
	return $rows;
}
 
 FUNCTION getTourData($selected_tours,$conn)
{
	$sql = "SELECT additional_price
			FROM  Tours
			where tour_id=" . $selected_tours;

	$result = mysql_query($sql,$conn);

	$rows = array();
	
	
	while(($row = mysql_fetch_array($result))) {
		$rows[] = $row;
	}

	return $rows;		

}
 
 FUNCTION getTransData($selected_trans,$conn)
{
	$sql = "SELECT additional_price
			FROM  Transportations
			where transportation_id=" . $selected_trans;

	$result = mysql_query($sql,$conn);

	$rows = array();
	
	while(($row = mysql_fetch_array($result))) {
		$rows[] = $row;
	}

	return $rows;		

}
FUNCTION aLength($var)
{
	$counter = 0;
	if($var==0)
	{
		return 0;
	}
	
	foreach($var AS $value) {
		$counter++;
	}
	return $counter;
}
 FUNCTION CalcForHotel($hotelID,$fromDate,$toDate,$conn,$selected_tickets,$selected_tours,$selected_trans,$mid,$mealName,$toomType,$roomView)
 {
	$roomData = getHotelRoomData($hotelID,$fromDate,$toDate,$conn,$mealName,$toomType,$roomView);
	//$mid = 36;
	

	$minTotal = 1000000;
	$additions = 0;
	$ticketPrice = 0;
	$chiledPrice = 0;
	if($selected_tickets!=null)
	{
		$ticketData = getTicketData($selected_tickets,$conn);
		//$additions = $additions + $ticketData[0][0];
		$ticketPrice = $ticketData[0][0];
		$childPrice = $ticketData[0]['child_price'];
		$intantPrice = $ticketData[0]['intant_price'];
	}
	if($selected_tours!=null)
	{
		$tourData = getTourData($selected_tours,$conn);
		$additions = $additions + $tourData[0][0];
	}
	if($selected_trans!=null)
	{
		$transData = getTransData($selected_trans,$conn);
		$additions = $additions + $transData[0][0];
	}
	
	
	//echo "additions=";
	//echo $additions;
	
	//return 0;
	$Margions = getMargions($conn);
	$MargionsData = getMargin($mid,$conn);
	
	$newRoomData = Array();
	$zeroOutput = false;
	$startTime = strtotime($fromDate . ' 12:00');
	$endTime = strtotime($toDate . ' 12:00');

	//$endTime = strtotime('-1 day',$toDate . ' 12:00');
	$endTime = strtotime($toDate . ' 12:00') - 86400;
	$nDays = 0;
	// Loop between timestamps, 24 hours at a time
	$totalDays = 0;
	for ($i = $startTime; $i <= $endTime; $i = $i + 86400) 
	{
	  $thisDate = date('Y-m-d', $i); // 2010-05-01, 2010-05-02, etc
	  $found = false;
	  //echo "This Date" . $thisDate;
	  $nDays++;
	  foreach($roomData as &$room )
	  {
		if($thisDate <= $room['end_date'] && $thisDate >= $room['start_date'])
		{
			$room['Count']++;
			$found = true;
		}
	  }
	  
	  if(!$found)
	  {
		$zeroOutput = true;
	  }
	  
	}
	
	$colName = null;
	if($nDays>0 && $nDays<=3)
		$colName = 3;// "1_3_margin";
	elseif($nDays>=4 && $nDays<=6)
		$colName = 4;// "4_6_margin";
	elseif($nDays>=7 && $nDays<=10)
		$colName = 5;//"7_10_margin";
	elseif($nDays>10)
		$colName = 6;//"10_more_margin";
	
	//-------------------------------------------------------------------------------
	$newRoomData = $roomData;
	$uniqueHids = getUniqueCombination("hotel_id",$newRoomData);
	//$uniqueRTids = getUniqueCombination("general_room_type_id",$newRoomData);
	$uniqueRVids = getUniqueCombination("general_room_view_id",$newRoomData);
	$uniqueMids = getUniqueCombination("general_meal_id",$newRoomData);
	$uniqueRoomTypes = getUniqueRoomTypes($conn);
	
	$newRoomData2 = Array();
	
	foreach($uniqueHids as $h )
	  {
		//foreach($uniqueRTids as $rt )
		//{
			foreach($uniqueRVids as $rv )
			{
				foreach($uniqueMids as $m )
				{
					foreach($uniqueRoomTypes as $roomType )
					{
						$newRoom = Array();
						$newRoom['hotel_id'] = $h;
						//$newRoom['general_room_type_id'] = $rt;
						$newRoom['general_room_view_id'] = $rv;
						$newRoom['general_meal_id'] = $m;
						$newRoom['type'] = $roomType['type'];
						$in = 0;
						
						$fixedMargionAddedInSingle = false;
						$fixedMargionAddedInDouble = false;
						
						foreach($newRoomData as &$room )
						{
							if(($room['hotel_id'] == $h) AND ($room['general_room_view_id'] == $rv) AND ($room['general_meal_id'] == $m) AND ($room['type'] == $roomType['type']) 
								AND $room['number_of_people'] == 1)
							{
								$in = 1;
								$newRoom['hotel_name'] = $room['hotel_name'];
								$newRoom['hotel_name_ar'] = $room['hotel_name_ar'];
								$newRoom['rating'] = $room['rating'];
								$newRoom['meal_name'] = $room['meal_name'];
								$newRoom['area_name'] = $room['area_name'];
								$newRoom['area_name_en'] = $room['area_name_en'];
								$newRoom['website'] = $room['website'];
								$newRoom['room_view_name'] = $room['room_view_name'];
								$newRoom['child_2_5_without_bed'] = $room['child_2_5_without_bed'] * $room['Count'];
								$newRoom['intant'] = $room['intant'] * $room['Count'];
								
								//$Margion = getMargionFromMargions($Margions,$nDays,$colName,$newRoom['rating']);
								//$MargionType = getMargionTypeFromMargions($Margions,$nDays,$colName,$newRoom['rating']);

								if($newRoom['rating'] == "5")
									$colName = "starts5";
								elseif($newRoom['rating'] == "5DLX")
									$colName = "starts5DLX";
								elseif($newRoom['rating'] == "4")
									$colName = "starts4";
								elseif($newRoom['rating'] == "4DLX")
									$colName = "starts4DLX";
								elseif($newRoom['rating'] == "3")
									$colName = "starts3";
								elseif($newRoom['rating'] == "5DLX")
									$colName = "starts3DLX";
									
								$Margion = $MargionsData[0][$colName];
								$MargionType = $MargionsData[0][$type];
								
								
								if($room['number_of_people'] == 1 )//'Single'
								{
									if(strtoupper($MargionType)=="PERCENT")
									{
										$locTotal = $room['Total'] * $room['Count'];
										$locTotal = $locTotal + ($locTotal * $Margion/100);
										$newRoom['Single'] = $newRoom['Single'] + $locTotal;
									}
									else
									{
										$locTotal = $room['Total'] * $room['Count'];
										if(!$fixedMargionAddedInSingle)
										{
											$locTotal = $locTotal + ($Margion * 2);
										}
										$newRoom['Single'] = $newRoom['Single'] + $locTotal ; 
										$fixedMargionAddedInSingle = true;
									}
								}
								
							}
						}
						foreach($newRoomData as &$room )
						{
							if(($room['hotel_id'] == $h) AND ($room['general_room_view_id'] == $rv) AND ($room['general_meal_id'] == $m) AND ($room['type'] == $roomType['type']) 
								AND $room['number_of_people'] == 2)
							{
								$in = 1;
								$newRoom['hotel_name'] = $room['hotel_name'];
								$newRoom['hotel_name_ar'] = $room['hotel_name_ar'];
								$newRoom['rating'] = $room['rating'];
								$newRoom['meal_name'] = $room['meal_name'];
								$newRoom['area_name'] = $room['area_name'];
								$newRoom['area_name_en'] = $room['area_name_en'];
								$newRoom['website'] = $room['website'];
								$newRoom['room_view_name'] = $room['room_view_name'];
								$newRoom['map'] = $room['map'];
								$newRoom['child_2_5_without_bed'] = $room['child_2_5_without_bed'] * $room['Count'];
								$newRoom['intant'] = $room['intant'] * $room['Count'];
								
								if($newRoom['rating'] == "5")
									$colName = "starts5";
								elseif($newRoom['rating'] == "5DLX")
									$colName = "starts5DLX";
								elseif($newRoom['rating'] == "4")
									$colName = "starts4";
								elseif($newRoom['rating'] == "4DLX")
									$colName = "starts4DLX";
								elseif($newRoom['rating'] == "3")
									$colName = "starts3";
								elseif($newRoom['rating'] == "5DLX")
									$colName = "starts3DLX";
									
								$Margion = $MargionsData[0][$colName];
								$MargionType = $MargionsData[0][$type];
								
								if ($room['number_of_people'] == 2 ) //Double
								{
									if(strtoupper($MargionType)=="PERCENT")
									{
										$locTotal = $room['Total'] * $room['Count'];
										$locTotal = $locTotal + ($locTotal * $Margion/100);
										$newRoom['Double'] = $newRoom['Double'] + $locTotal;
										
										$locTotal = $room['child_2_12_with_bed'] * $room['Count'];
										$locTotal = $locTotal + ($locTotal * $Margion/100);
										$newRoom['child_2_12_with_bed'] = $newRoom['child_2_12_with_bed'] + $locTotal;
									}
									else
									{
										$locTotal = $room['Total'] * $room['Count'];
										if(!$fixedMargionAddedInDouble)
										{
											$locTotal = $locTotal + $Margion;
										}
										$newRoom['Double'] = $newRoom['Double'] + $locTotal ; 
										
										$locTotal = $room['child_2_12_with_bed'] * $room['Count'];
										if(!$fixedMargionAddedInDouble)
										{
											$locTotal = $locTotal + $Margion/2;
										}
										$newRoom['child_2_12_with_bed'] = $newRoom['child_2_12_with_bed'] + $locTotal ;
										$fixedMargionAddedInDouble = true;
									}
								}
								
							}
						}
	
						if($in==1)
						{	
							if(!$zeroOutput)
							{
								if(strtoupper($MargionType)=="PERCENT")
								{
									$additions2 = $additions + ($additions * $Margion/100);
									$ticketPrice2 = $ticketPrice + ($ticketPrice * $Margion/100);
									$childPrice2 = $childPrice + ($childPrice * $Margion/100);
									$newRoom['Single'] = $newRoom['Single'] + $additions2 + $ticketPrice2;
									$newRoom['Double'] = $newRoom['Double'] + $additions2 + $ticketPrice2;
									$newRoom['child_2_12_with_bed'] = $newRoom['child_2_12_with_bed'] + $additions2 + $childPrice2;
									$newRoom['child_2_5_without_bed'] = $newRoom['child_2_5_without_bed'] + $childPrice;
									$newRoom['intant'] = $newRoom['intant'] + $intantPrice;
								
								}
								else
								{
									$newRoom['Single'] = $newRoom['Single'] + $additions + $ticketPrice;
									$newRoom['Double'] = $newRoom['Double'] + $additions + $ticketPrice;
									$newRoom['child_2_12_with_bed'] = $newRoom['child_2_12_with_bed'] + $additions + $childPrice;
									$newRoom['child_2_5_without_bed'] = $newRoom['child_2_5_without_bed'] + $childPrice;
									$newRoom['intant'] = $newRoom['intant'] + $intantPrice;
								}
								
							}
							else
							{
								$newRoom['Single']=0;
								$newRoom['Double']=0;
								$newRoom['Triple']=0;
								$newRoom['child_2_12_with_bed']=0;
								$newRoom['child_2_5_without_bed'] = 0;
								$newRoom['intant'] = 0;
							}
							
							if($newRoom['Double'] < $minTotal)
							{
								$minTotal = $newRoom['Double'];
							}
						$newRoomData2[] = $newRoom;
						}
					}
					
				}
			}
		//}
		
	  }
	
	//echo "-------------------------------------------------------------------------------------------------------------------";
	//print_r($newRoomData2); 
	$newRoomData3 = Array();
	foreach($newRoomData2 as &$room3 )
	{
		$newRoom = Array();
		$newRoom = $room3;
		$newRoom['Order'] = $minTotal;
		$newRoomData3[] = $newRoom;
	}
	
	//echo "-------------------------------------------------------------------------------------------------------------------";
	//print_r($newRoomData2);
	//echo "==================";
	//print_r($newRoomData3);
	//echo "-------------------------------------------------------------------------------------------------------------------";
	return $newRoomData3;
 }
FUNCTION getRatingNum($rating)
{
	if($rating=="5DLX")
		return 30;
	elseif($rating=="5")
		return 29;
	elseif($rating=="4DLX")
		return 31;
	elseif($rating=="4")
		return 32;
	elseif($rating=="3DLX")
		return 34;
	elseif($rating=="3")
		return 33;
}
FUNCTION getMargionFromMargions($Margions,$nDays,$colName,$rating)
{
	$rating = getRatingNum($rating);
	
	foreach($Margions as $margionRow)
	{
		if($margionRow['id'] == $rating)
		{	
			return $margionRow[$colName];
		}
	}
}
FUNCTION getMargionTypeFromMargions($Margions,$nDays,$colName,$rating)
{
	$rating = getRatingNum($rating);
	foreach($Margions as $margionRow)
	{
		if($margionRow['id'] == $rating)
		{	
			return $margionRow['margin_type'];
		}
	}
}
FUNCTION getUniqueRoomTypes($conn)
{
	$sql = "SELECT DISTINCT type FROM General_Room_Types";
		
		$result = mysql_query($sql,$conn);

		$rows = array();

		while(($row = mysql_fetch_array($result))) {
			$rows[] = $row;
		}

	return $rows;
}

 FUNCTION getUniqueCombination($val,$newRoomData)
 {
	$hids = array();
	foreach ($newRoomData as $x) {
		$hids[] = $x[$val];
	}
	$uniqueHids = array_unique($hids);
	return $uniqueHids;
}
 
 FUNCTION getHotelRoomData($hotelID,$fromDate,$toDate,$conn,$mealName,$toomType,$roomView)
{
	$sql = "SELECT 
				h.hotel_id,
				h.hotel_name,
				h.website,
				h.map,
				h.hotel_name_ar,
				h.rating,
				gm.general_meal_id,
				gm.meal_name,
				h.area_name,
				h.area_name_en,
				grv.general_room_view_id,
				grv.room_view_name,
				grt.general_room_type_id,
				grt.number_of_people,
				grt.room_type_name,
				grt.type,
				if(hp.spatial_price>0,hp.spatial_price,hp.base_price) + m.additional_price + rv.additional_price as 'Total',
				if(number_of_people=2,if(hp.spatial_price>0,hp.spatial_price,hp.base_price) /2 + rv.additional_price * 1.5 + m.additional_price * 1.5,0) as 'child_2_12_with_bed',
				5 as 'child_2_5_without_bed',
				5 as 'intant',
				hp.start_date,
				hp.end_date,
				0 as 'Count'
				
			FROM
				Hotels h,
				Meals m,
				General_Meals gm,
				General_Room_Views grv,
				General_Room_Types grt,
				Room_Type rt,
				Room_View rv,
				Hotel_Prices hp

			WHERE
				h.hotel_id = ". $hotelID ." and 
				m.hotel_id_f = ". $hotelID ." and 
				gm.general_meal_id = m.general_meal_id_f and 
				rt.hotel_id_f = ". $hotelID ." and 
				rv.room_type_id_f = rt.room_type_id and 
				grt.general_room_type_id = rt.general_room_type_id_f and 
				grv.general_room_view_id = rv.general_room_view_id_f and 
				hp.room_type_id_f = rt.room_type_id and 
				gm.meal_name = '" . $mealName . "' and 
				grt.type = '" . $toomType . "' and 
				grv.room_view_name = '" . $roomView . "' and 
				(hp.end_date >= '" . $fromDate . "' AND " . " hp.start_date <= '". $toDate . "')  
				
			";
		
		//echo $sql;
		
		$result = mysql_query($sql,$conn);

		$rows = array();

		while(($row = mysql_fetch_array($result))) {
			$rows[] = $row;
		}

	return $rows;
}
 FUNCTION getMargions($conn)
{
	$sql = "SELECT * from setting";
		
		$result = mysql_query($sql,$conn);

		$rows = array();

		while(($row = mysql_fetch_array($result))) {
			$rows[] = $row;
		}

	return $rows;
}

FUNCTION getMargin($mid,$conn)
{

	$sql = " select margin_name,type,starts3,starts3DLX,starts4,starts4DLX,starts5,starts5DLX from Margins where margin_id = '$mid' ";
			
	$result = mysql_query($sql,$conn);

	$rows = array();

	while(($row = mysql_fetch_array($result))) {
		$rows[] = $row;
	}

	return $rows;		

}
 
 
 ?>
 
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<link rel="stylesheet" type="text/css" href="css/jquery.multiselect.css" />
<link rel="stylesheet" type="text/css" href="css/assets/style.css" />
<link rel="stylesheet" type="text/css" href="css/assets/prettify.css" />
<link rel="stylesheet" type="text/css" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1/themes/ui-lightness/jquery-ui.css" />
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1/jquery.js"></script>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jqueryui/1/jquery-ui.min.js"></script>
<script type="text/javascript" src="js/prettify.js"></script>
<script type="text/javascript" src="js/jquery.multiselect.js"></script>


<script type="text/javascript">
$(document).ready(function()
{


$(".des1").change(function()
{
var id=$(this).val();
var dataString = 'id='+ id;

$.ajax
({
type: "POST",
url: "getticketsdates.php",
data: dataString,
cache: false,
success: function(html)
{
$(".datepicker").html(html);
} 
});


});


$(".des").change(function()
{
var id=$(this).val();
var dataString = 'id='+ id;

$.ajax
({
type: "POST",
url: "gettic.php",
data: dataString,
cache: false,
success: function(html)
{
$(".des1").html(html);
} 
});

$.ajax
({
type: "POST",
url: "getmar.php",
data: dataString,
cache: false,
success: function(html)
{
$(".mar").html(html);
} 
});

$.ajax
({
type: "POST",
url: "gettour.php",
data: dataString,
cache: false,
success: function(html)
{
$(".des9").html(html);
} 
});

$.ajax
({
type: "POST",
url: "gettrans.php",
data: dataString,
cache: false,
success: function(html)
{
$(".des8").html(html);
} 
});


});
});


$(document).ready(function()
{

$(".des0").change(function()
{
var id=$(".des").val();
var rat=$(".des0").val();
var dataString = 'id='+ id + '&rat=' + rat;

$.ajax
({
type: "POST",
url: "gethotels1.php",
data: dataString,
cache: false,
success: function(html)
{
$(".des4").html(html);
} 
});
});
});


$(document).ready(function()
{

$(".datepicker").change(function()
{
var id=$(".des1").val();
var go=$(".datepicker").val();
var dataString = 'id='+ id + '&go=' + go;

$.ajax
({
type: "POST",
url: "getticketsdates1.php",
data: dataString,
cache: false,
success: function(html)
{
$(".datepicker1").html(html);
} 
});

});
});


$(document).ready(function()
{

$(".des4").change(function()
{
var id=$(".des4").val();
//var go=$(".datepicker").val();
var dataString = 'id='+ id;

$.ajax
({
type: "POST",
url: "rt.php",
data: dataString,
cache: false,
success: function(html)
{
$(".rt").html(html);
} 
});

$.ajax
({
type: "POST",
url: "rv.php",
data: dataString,
cache: false,
success: function(html)
{
$(".rv").html(html);
} 
});

$.ajax
({
type: "POST",
url: "ml.php",
data: dataString,
cache: false,
success: function(html)
{
$(".ml").html(html);
} 
});


});
});


</script>


<link rel="stylesheet" href="https://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css" />
  

 <link rel="stylesheet" href="css/craftyslide.css" />

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>FB View</title>
<meta name="keywords" content="FB View" />
<meta name="description" content="FB View" />
	<style type="text/css">
.style1 {
	font-family: Verdana;
	font-size: small;
}
.style2 {
	text-align: left;
}
.style3 {
	margin: 3px 20px;
}
.style4 {
	text-align: center;
}

a:link {text-decoration:none;color:#338ddf;}
a:visited {text-decoration:none;color:#338ddf;}
a:hover {text-decoration:underline;color:#f6822d;}
a:active {text-decoration:underline;color:#338ddf;}

</style>

  <style>
  body {
	font-family: "Trebuchet MS", "Helvetica", "Arial",  "Verdana", "sans-serif";
	font-size: 62.5%;
}
</style>
</head>
<body>
 <br>
 <div align=left>
 
 
 <?php 
//------------- hussein here you need to play --------------


$place=$_REQUEST['places'];  // getting place id may you dont need 

$selected_tickets=$_REQUEST['tickets'];
$selected_tours=$_REQUEST['tours'];
$selected_trans=$_REQUEST['trans'];

/*

	if($_POST['hotels']){

		//  selected hotels ids as coma seperated string , you can use explode to get one by one 
		$hotelsids=Array();

		foreach ($_POST['hotels'] as $ids)
		{
			 $hotelsids[]=$ids;
			 $hotelsstring=$hotelsstring.",".$ids;	
		}
	}
//print_r($_REQUEST); 

*/
if($_REQUEST['des4'])
{

$hotelsids[]=$_REQUEST['des4'];
$hotelsstring=$hotelsstring.",".$_REQUEST['des4'];
}

 $mid = $_REQUEST['mar'];

$fromdates=$_REQUEST['datepicker'];
$fromdates2=explode("|",$fromdates);
$fromdates3=$fromdates2[1];

$todates=$_REQUEST['datepicker1'];

$todates2=explode("|",$todates);
$todates3=$todates2[1];


$flight_string = $_REQUEST['datepicker'];

$flight_string1 = explode("|", $flight_string);

$day=$flight_string1[0];

$flight_date=$flight_string1[1];

$flight_starttime=$flight_string1[2];

$flight_fromp=$flight_string1[3];

$flight_endtime =$flight_string1[4];

$flight_top=$flight_string1[5];

$flight_airline=$flight_string1[6];


$flight_start = explode(":",$flight_starttime);
$fstart = $flight_start[0].":".$flight_start[1];


$flight_end = explode(":",$flight_endtime);
$fend = $flight_end[0].":".$flight_end[1];

$dep = strtoupper($flight_airline) ." (".strtoupper($flight_fromp).") (". strtoupper($flight_top).") ".strtoupper($day)." ".$flight_date." ".$fstart . " - ".strtoupper($day)." ".$flight_date . " " . $fend;


$flight_string1 = $_REQUEST['datepicker1'];

$flight_string2 = explode("|", $flight_string1);

$day1=$flight_string2[0];

$flight_date1=$flight_string2[1];

$flight_starttime1=$flight_string2[2];

$flight_fromp1=$flight_string2[3];

$flight_endtime1 =$flight_string2[4];

$flight_top1=$flight_string2[5];

$flight_airline1=$flight_string2[6];


$flight_start1 = explode(":",$flight_starttime1);
$fstart1 = $flight_start1[0].":".$flight_start1[1];


$flight_end1 = explode(":",$flight_endtime1);
$fend1 = $flight_end1[0].":".$flight_end1[1];

$arv = " ".strtoupper($flight_airline1) ." (".strtoupper($flight_top1).") (". strtoupper($flight_fromp1).") ".strtoupper($day1)." ".$flight_date1." ".$fstart1 . " - ".strtoupper($day1)." ".$flight_date1 . " " . $fend1;


// swaping dates to the same format in data base if needed use the below values
//$fromdates1= str_replace("/","-",$fromdates);
//$fromdates2=explode("-",$fromdates1);
//$fromdates3=$fromdates2[2]."-".$fromdates2[0]."-".$fromdates2[1];

//$todates1= str_replace("/","-",$todates);
//$todates2=explode("-",$todates1);
//$todates3=$todates2[2]."-".$todates2[0]."-".$todates2[1];

?>
 
  <form method="post" action="orders.php" id="form3" name="form3"  onSubmit="return ValidateForm2()">
 <table width="1180" cellspacing="5">
 
 <tr>
 
 <td width="300px" valign="top">
 
 
 <table width="97%" cellspacing="0" cellpadding="0">
 
 
 <tr>
	        <td class="style1" style="height: 30px">
	        <strong>Select Customer	        
	        </strong>	        
	        </td>
	        </tr>
	        <tr>
	        <td style="height: 30px">
 <input placeholder="search customers" type="text" id="s" style="height:30px; background-image:url('images/w1.png'); width:200px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;">
 <br><br>
 <select size="10"  id="cust" style="width:200px;height:140px; color:#ffffff; background:#f2b02b;">
  
  			<option value="Select" selected="selected">--Select--</option>

  
  <?php
			
			
$sqls="SELECT * FROM Customers order by first_name";
	
	$results = mysql_query($sqls,$conn);
while($rows = mysql_fetch_array($results))
  {
  	echo "<option value='$rows[cus_id]'>$rows[first_name]</option>";

  
  }
?>
  
  
</select>
 </td>
	        </tr>
	        <tr>
	        <td class="style1" style="height: 30px">
	        <strong>Select Destination	        
	        </strong>	        
	        </td>
	        </tr>
	  
	        <tr>
	        <td style="height: 30px">
	       
	        <select class="des" name="des" style="height:30px; background-image:url('images/w1.png'); width:200px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;">
			<option value="Select" selected="selected">--Select--</option>
			
			<?php
			
			$today = Date('Y-m-d');
			
			
$sqls="SELECT place_id, place_name FROM Places order by place_name";
	
	$results = mysql_query($sqls,$conn);
while($rows = mysql_fetch_array($results))
  {
  	echo "<option value='$rows[place_id]'>$rows[place_name]</option>";

  
  }
?>
			
			
			</select>&nbsp;

			
			</td>
	        </tr>
	        
	        
<tr>
	        <td class="style1" style="height: 30px">
	        <strong>Select Tickets	        
	        </strong>	        
	        </td>
	        </tr>
	  
	        <tr>
	        <td style="height: 30px">
	        <select class="des1" name="des1" style="height:30px; background-image:url('images/w1.png'); width:200px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;">
			<option value="Select" selected="selected">--Select--</option>
			
			
			</select>&nbsp;
			
			
			</td>
	        </tr>
	        
	        
	        <tr>
	        <td class="style1" style="height: 30px">
	        <strong>Select Margin	        
	        </strong>	        
	        </td>
	        </tr>
	  
	        <tr>
	        <td style="height: 30px">
	        <select class="mar"  name="mar" style="height:30px; background-image:url('images/w1.png'); width:200px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;">
						<option value="Select">--Select--</option>


			</select>&nbsp;</td>
	        
	        
	        </tr>        
	        
	       </table>
 
 
 </td>
  <td width="300px" valign="top">
  
  
   <table width="97%" cellspacing="0" cellpadding="0">
   
   
<tr>
	        <td class="style1" style="height: 30px">
	        <strong>Select Hotel Rating	        
	        </strong>	        
	        </td>
	        </tr>
	  
	        <tr>
	        <td style="height: 30px">
	        <select class="des0"  name="des0" style="height:30px; background-image:url('images/w1.png'); width:200px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;">
			<option value="Select">--Select--</option>
						<option value="All">All</option>
						<option value="5DLX">5DLX</option>
						<option value="5">5</option>
						<option value="4DLX">4DLX</option>
						<option value="4">4</option>
						<option value="3DLX">3DLX</option>
						<option value="3">3</option>

		
			</select>&nbsp;</td>
	        
	        
	        </tr>

<tr>
	        <td class="style1" style="height: 30px">
	        <strong>Select Hotel Name	        
	        </strong>	        
	        </td>
	        </tr>
	  
	        <tr>
	        <td style="height: 30px">

	     	 
	        <select  class="des4" name="des4" id="des4" style="height:30px; background-image:url('images/w1.png'); width:200px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;">
            <option value="Select" selected="selected">--Select--</option></select>
			
		
		<!--
		  	
<div class="des4" name="des4" style=" font-size : 15px; font-family:verdana; overflow: auto; width: 200px; height: 180px; border: 1px solid #b0b0b1; padding-left: 5px; background:url('images/w2.png');">


</div>
-->
<!--
		<label class="cba">
         <a href="javascript:void();" onclick="javascript:checkAll('form3', true);">Check All</a> | 
         <a href="javascript:void();" onclick="javascript:checkAll('form3', false);">Uncheck All</a>
   </label>
    <script type="text/javascript">
function checkAll(formname, checktoggle)
{
     var checkboxes = new Array();
      checkboxes = document[formname].getElementsByTagName('input');
      for (var i = 0; i < checkboxes.length; i++) {
          if (checkboxes[i].type === 'checkbox') {
               checkboxes[i].checked = checktoggle;
          }
      }
}
</script>	
-->

			</td>
	        </tr>
	        
	        
	        <tr>
	        <td class="style1" style="height: 30px">
	        <strong>Select Room Type        
	        </strong>	        
	        </td>
	        </tr>
	  
	        <tr>
	        <td style="height: 30px">
	        <select class="rt"  name="rt" style="height:30px; background-image:url('images/w1.png'); width:200px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;">
			<option value="Select" selected="selected">--Select--</option></select>
		

			</select>&nbsp;</td>
	        
	        
	        </tr>
	        

<tr>
	        <td class="style1" style="height: 30px">
	        <strong>Select Room View	        
	        </strong>	        
	        </td>
	        </tr>
	  
	        <tr>
	        <td style="height: 30px">
	        <select class="rv"  name="rv" style="height:30px; background-image:url('images/w1.png'); width:200px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;">
			<option value="Select" selected="selected">--Select--</option></select>

			
			</select>&nbsp;</td>
	        
	        
	        </tr>
	        
	        
	        <tr>
	        <td class="style1" style="height: 30px">
	        <strong>Select Meal	        
	        </strong>	        
	        </td>
	        </tr>
	  
	        <tr>
	        <td style="height: 30px">
	        <select class="ml"  name="ml" style="height:30px; background-image:url('images/w1.png'); width:200px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;">
			<option value="Select" selected="selected">--Select--</option></select>
			
			
			</select>&nbsp;</td>
	        
	        
	        </tr>
    <tr>
	        <td class="style1" style="height: 30px">
	        <strong>Select Tours        
	        </strong>	        
	        </td>
	        </tr>
	  
	        <tr>
	        <td style="height: 30px">
	        <select class="des9" name="des9" style="height:30px; background-image:url('images/w1.png'); width:200px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;">
			<option value="Select" selected="selected">--Select--</option>
			
			</select>&nbsp;
			
			
			</td>
	        </tr>

<tr>


<tr>
	        <td class="style1" style="height: 30px">
	        <strong>Select Transportation	        
	        </strong>	        
	        </td>
	        </tr>
	  
	        <tr>
	        <td style="height: 30px">
	        <select class="des8" name="des8" style="height:30px; background-image:url('images/w1.png'); width:200px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;">
			<option value="Select" selected="selected">--Select--</option>
			
			</select>&nbsp;
			
			
			</td>
	        </tr>
   </table>
  
  
  </td>
 <td width="540px" valign="top">
 
  <table width="97%" cellspacing="0" cellpadding="0">
  

	        <tr>
	        <td class="style1" style="height: 30px">
	        
	        <strong>Going	        
	        </strong>	        
	        </td>
	        </tr>
<tr>
	        <td style="height: 30px">
<select class="datepicker" name="datepicker" style="height:30px; background-image:url('images/w1.png'); width:200px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;">
			<option value="Select" selected="selected">--Select--</option>
			
			</select>&nbsp;

</td>
	        </tr>
	        
	        
	    <tr>
	        <td class="style1" style="height: 30px">
	        
	        <strong> Return	        
	        </strong>	        
	        </td>
	        </tr>
<tr>
	        <td style="height: 30px">
<select class="datepicker1" name="datepicker1" style="height:30px; background-image:url('images/w1.png'); width:200px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;">
			<option value="Select" selected="selected">--Select--</option>
			
			</select>&nbsp;

</td>
	        </tr>    
	        
	        
	        <!--
<tr>
	        <td class="style1" style="height: 30px">
	        <strong>From Date	        
	        </strong>	        
	        </td>
	        </tr>
	  
	        <tr>
	        <td style="height: 30px">
	        <input id="datepicker" name="datepicker" type="text" style="width:200px; background:url('images/w2.png'); height:25px; border:1px #b0b0b1 solid;font-size:medium;" />&nbsp;</td>
	        </tr>

<tr>
	        <td class="style1" style="height: 30px">
	        <strong>To Date	        
	        </strong>	        
	        </td>
	        </tr>
	  
	        <tr>
	        <td style="height: 30px">
	        <input id="datepicker1" name="datepicker1" type="text" style="width:200px; background:url('images/w2.png'); height:25px; border:1px #b0b0b1 solid;font-size:medium;" />&nbsp;</td>
	        </tr>

-->
<tr>
	        <td class="style1" style="height: 30px">
	        
	        <strong>Airport Tax	        
	        </strong>	        
	        </td>
	        </tr>
<tr>
	        <td style="height: 30px">
	        <select class="tax"  name="tax" style="height:30px; background-image:url('images/w1.png'); width:200px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;">
			<option value="Select">--Select--</option>
						<option value="45">Full Tax 45 JD at Office</option>
						<option value="25">25 JD at Office and 20 at Airport</option>
						

			</select>&nbsp;</td>
	        
	        
	        </tr>

 <tr><td>
<br>

<font size="2">

<strong>No. of Single Rooms </strong>&nbsp;&nbsp;&nbsp;<input type='number' min="0" max="10" size='10' id='sr' name='sr' value='0' style="height:30px; background-image:url('images/w1.png'); width:40px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;" />
<br><br>
<strong>No. of Double Rooms</strong>&nbsp;&nbsp;&nbsp;<input type='number' min="0" max="10" size='10' id='dr' name='dr' value='0' style="height:30px; background-image:url('images/w1.png'); width:40px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;" />

&nbsp;&nbsp;&nbsp;<strong># Persons</strong>&nbsp;&nbsp;&nbsp;<input type='number' min="0" max="10" size='10' id='dp' name='dp' value='0' style="height:30px; background-image:url('images/w1.png'); width:40px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;" />
<br><br>

<strong>Child 6-12 with Bed</strong>&nbsp;&nbsp;&nbsp;<input type='number' size='10' min="0" max="10" id='cwb' name='cwb' value='0' style="height:30px; background-image:url('images/w1.png'); width:40px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;" />

&nbsp;&nbsp;&nbsp;<strong>Childs 2-5 Without Bed</strong>&nbsp;&nbsp;&nbsp; <input type='number' min="0" max="10" size='10' id='cob' name='cob' value='0' style="height:30px; background-image:url('images/w1.png'); width:40px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;" />
&nbsp;&nbsp;&nbsp;<strong>Intants</strong>&nbsp;&nbsp;&nbsp; <input type='number' size='10' min="0" max="10" id='in' name='in' value='0' style="height:30px; background-image:url('images/w1.png'); width:40px; background:#edf2f5; border:1px #b0b0b1 solid;font-size:medium;" />
</font>
</td></tr>
 

<tr>

<td style="height: 40px" class="style2">
<div align="left>">

<br><br><br>
	        <input name="ff2" type="image" src="images/b1.png" class="style3" />
	        
	        </div>
	        </td>
	        </tr>
	        
	        </table>

 
 </td>

 </tr>
 
 </table>
 
 	
<script type="text/javascript">
 
        function DoListBoxFilter(listBoxSelector, filter, keys, values) {
            var list = $(listBoxSelector);
            var selectBase = '<option value="{0}">{1}</option>';
 
            list.empty();
            for (i = 0; i < values.length; ++i) {
 
                var value = values[i];
 
                if (value == "" || value.toLowerCase().indexOf(filter.toLowerCase()) >= 0) {
                    var temp = '<option value="' + keys[i] + '">' + value + '</option>';
                    list.append(temp);
                }
            }
        }
        var keys = [];
        var values = [];
 
        var options = $('#cust option');
        $.each(options, function(index, item) {
            keys.push(item.value);
            values.push(item.innerHTML);
        });
        $('#s').keyup(function() {
            var filter = $(this).val();
            DoListBoxFilter('#cust', filter, keys, values);
        });
    </script>

	        
</form>
 
 
	</div>
	
	<div style="position: absolute; left:5px;top:500px;">

<table align="center" cellspacing="6" border="1" width="900px">


<tr>

<td colspan=10 height="40px">
<br>
<div align="right">
	<form method="post" action="" name="form2" target="_blank">
	Report Template
	<select name="Select1" class="Select1">
	<option value="Select">-- Select -- </option>

<?php 


$p2=$_REQUEST['des'];
$b=$_SESSION['branch'];

$today = Date('Y-m-d');

	$sqls="select * from Headers_Footers where branch='$b' AND place_id_f='$p2'";
	
	$results = mysql_query($sqls,$conn);
while($rows = mysql_fetch_array($results))
  {
//echo "<select>";
echo "<option value=".$rows['id'].">" . $rows['name']."</option>";
//echo "</select>";

  }


 ?>
	
	
	</select>
	
	<input name="Submit1" type="submit" value="PDF/Print Arabic" onclick="show()"/>
	</form>
	
	<script language="javascript">
function show(){
        document.form2.action="tcpdf/pdf/arpdf.php?tickets=<?php echo $tickets; ?>&trans=<?php echo $trans; ?>&tours=<?php echo $tours; ?>&placeid=<?php echo $pl; ?>&fromdate=<?php echo $fromdates3; ?>&todate=<?php echo $todates3; ?>&hotelids=<?php echo $hotelsstring;  ?>&f1=<?php echo $fromdates; ?>&f2=<?php echo $todates; ?>&mar=<?php echo $mid; ?>";
}
function pdf(){
        document.form2.action="tcpdf/pdf/enpdf.php?tickets=<?php echo $tickets; ?>&trans=<?php echo $trans; ?>&tours=<?php echo $tours; ?>&placeid=<?php echo $pl; ?>&fromdate=<?php echo $fromdates3; ?>&todate=<?php echo $todates3; ?>&hotelids=<?php echo $hotelsstring;  ?>&f1=<?php echo $fromdates; ?>&f2=<?php echo $todates; ?>";
}


function ValidateForm2(){

 var d=document.form3.des
    var k=document.form3.des1
    var r=document.form3.des8
    var n=document.form3.des9
    var c=document.form3.datepicker
    var t=document.form3.datepicker1
    var m=document.form3.mar
    var rt=document.form3.rt
    var rv=document.form3.rv
    var ml=document.form3.ml
    var cust=document.form3.cust
    
     if ((cust.value=="")||(cust.value=="Select")){
    alert("Please select customer")
   cust.focus()
    return false
  }
    
    if ((d.value==null)||(d.value=="Select")){
    alert("Please select Destination")
   d.focus()
    return false
  }
    
if ((k.value==null)||(k.value=="Select")){
    alert("Please select Tickets")
   k.focus()
    return false
  }
  
  
  if ((n.value==null)||(n.value=="Select")){
    alert("Please select Tours")
   n.focus()
    return false
  }
  
  
  if ((r.value==null)||(r.value=="Select")){
    alert("Please select Transportations")
   r.focus()
    return false
  }
 
 if ((m.value==null)||(m.value=="Select")){
    alert("Please select margin")
   m.focus()
    return false
  }
  
  if ((rt.value==null)||(rt.value=="Select")){
    alert("Please select room type")
   rt.focus()
    return false
  }
   
   if ((rv.value==null)||(rv.value=="Select")){
    alert("Please select room view")
   rv.focus()
    return false
  }
  
  if ((ml.value==null)||(ml.value=="Select")){
    alert("Please select meal")
   ml.focus()
    return false
  }
   

    if ((c.value==null)||(c.value=="Select")){
    alert("Please Enter From Date")
   c.focus()
    return false
  }
  
  if ((t.value==null)||(t.value=="Select")){
    alert("Please Enter To Date")
   t.focus()
    return false
  }

   
   return true

  
 }

</script>
	

</td>
</tr>


<tr>
<td align="center" valign="middle" height="30px" style="background-color: #1794d0; color:#FFF"><font size="2">Hotel Name<font size="2"></td>
<td align="center" valign="middle" height="30px" style="background-color: #1794d0; color:#FFF"><font size="2">Rating</font></td>
<td align="center" valign="middle" height="30px" style="background-color: #1794d0; color:#FFF"><font size="2">Meals</font></td>
<td align="center" valign="middle" height="30px" style="background-color: #1794d0; color:#FFF"><font size="2">Location</font></td>
<td align="center" valign="middle" height="30px" style="background-color: #1794d0; color:#FFF"><font size="2">Room View</font></td>
<td align="center" valign="middle" height="30px" style="background-color: #1794d0; color:#FFF"><font size="2">Room Type</font></td>
<td align="center" valign="middle" height="30px" style="background-color: #1794d0; color:#FFF"><font size="2">Double/Triple</font></td>
<td align="center" valign="middle" height="30px" style="background-color: #1794d0; color:#FFF"><font size="2">Single</font></td>
<td align="center" valign="middle" height="30px" style="background-color: #1794d0; color:#FFF"><font size="2">Child 2-12 with Bed</font></td>
<td align="center" valign="middle" height="30px" style="background-color: #1794d0; color:#FFF"><font size="2">Total</font></td>

</tr>

<?php

$mealName = $_REQUEST['ml'];
$toomType = $_REQUEST['rt'];
$roomView = $_REQUEST['rv'];
$sr = $_REQUEST['sr'];
$dr = $_REQUEST['dr'];
$dp = $_REQUEST['dp'];
$cwb = $_REQUEST['cwb'];
$cob = $_REQUEST['cob'];
$in = $_REQUEST['in'];

$FinalData = CalcForAllHotels($hotelsids,$fromdates3,$todates3,$conn,$tickets,$tours,$trans,$mid,$mealName,$toomType,$roomView);
$total_nights=  (strtotime($todates3 . ' 12:00')  - strtotime($fromdates3 . ' 12:00') )/86400;

// this row starting by <tr> and ending bu </tr> need to be looped depend on results values 

if($FinalData == null)
	return;
foreach($FinalData as $Hotel)
{
	foreach($Hotel as $row)
	{
		$hotel_name =$row['hotel_name'];
		$hotel_name_ar =$row['hotel_name_ar'];
		$hotel_rating=$row['rating'];
		$hotel_meal=$row['meal_name'];
		$hotel_location=$row['area_name'];
		$hotel_location_en=$row['area_name_en'];
		$room_view=$row['room_view_name'];
		$room_type=$row['type'];
		$website=$row['website'];
		$map=$row['map'];

		$double_price=round($row['Double']/5) * 5;
		$single_price=round($row['Single']/5) * 5;
		$child_2_12_price=round($row['child_2_12_with_bed']/5) * 5;
		
		$child_2_5_without_bed=round($row['child_2_5_without_bed']/5) * 5;
		$intant=round($row['intant']/5) * 5;
		
		?>
			<tr>
			<td align="center" valign="middle" height="30px" style="background-color: #ffffff; color:#000"><font size="2"><a href="http://<?php echo $website; ?>" target="_blank"><?php echo $hotel_name; ?></a></font></td>
			<td align="center" valign="middle" height="30px" style="background-color: #ffffff; color:#000"><font size="2"><font size="2"><?php echo $hotel_rating; ?></font></td>
			<td align="center" valign="middle" height="30px" style="background-color: #ffffff; color:#bf0505"><font size="2"><font size="2"><b><?php echo $hotel_meal; ?></b></font></td>
			<td align="center" valign="middle" height="30px" style="background-color: #ffffff; color:#bf0505"><font size="2"><font size="2"><b><a href="http://goo.gl/maps/<?php echo $map; ?>" target="_blank"><?php echo $hotel_location_en; ?></a></b></font></td>
			<td align="center" valign="middle" height="30px" style="background-color: #ffffff; color:#bf0505"><font size="2"><font size="2"><b><?php echo $room_view; ?></b></font></td>
			<td align="center" valign="middle" height="30px" style="background-color: #ffffff; color:#bf0505"><font size="2"><font size="2"><b><?php echo $room_type; ?></b></font></td>
			<td align="center" valign="middle" height="30px" style="background-color: #ffffff; color:#000"><font size="2"><font size="2"><?php echo $double_price . " * ".$dr; ?></font></td>
			<td align="center" valign="middle" height="30px" style="background-color: #ffffff; color:#000"><font size="2"><font size="2"><?php echo $single_price." * ".$sr; ?></font></td>
			<td align="center" valign="middle" height="30px" style="background-color: #ffffff; color:#000"><font size="2"><font size="2"><?php echo $child_2_12_price." * ".$cwb; ?></font></td>
			<td align="center" valign="middle" height="30px" style="background-color: #ffffff; color:#bf0505"><font size="2"><font size="2"><?php echo ($double_price * $dr) +($single_price * $sr)+($child_2_12_price * $cwb) ; ?></font></td>

			</tr>
			
			<tr>
			<td colspan="6" align="center" valign="middle" height="30px" style="background-color: #ffffff; color:#000"><font size="2">Total</td>
			
			<td align="center" valign="middle" height="30px" style="background-color: #ffffff; color:#000"><font size="2"><font size="2"><?php  ?></font></td>
			<td align="center" valign="middle" height="30px" style="background-color: #ffffff; color:#000"><font size="2"><font size="2"><?php  ?></font></td>
			<td align="center" valign="middle" height="30px" style="background-color: #ffffff; color:#000"><font size="2"><font size="2"><?php   ?></font></td>

			</tr>
			
		<?php 
		
		
	}
}


?>

<tr>

<td colspan=9 height="40px"><p align="left" style="margin:10px">
<font size="3" color="#bf0505"><b>

<?php 

echo "  Prices Above per person and for period from  ".$fromdates3."  to  ".$todates3."  :: Total Nights  ".intval($total_nights);

echo "<br><br>  Child Price 2-5 without bed in JD:  ". $child_2_5_without_bed."  <br><br>   Intant price in JD  :".$intant." ";

?>


</font></b></p>


<p align="left" style="margin:10px">

<font size="3"><br>
Going &nbsp;&nbsp; :: <?php echo  $dep;  ?><br>
Return :: <?php  echo $arv;  ?>
</font>

</p>
</td>
</tr>
</table>


 </div>
</body>
</html>