<?php
session_start();
if(!session_is_registered(myusername)){
header("location:../index.php");
}
 include '../conf/config.php';
 
 mysql_query("SET NAMES 'utf8'", $conn);
 
 $pp=$_GET['p1'];
 

 $pl=$_GET['placeid'];
 $rating = $_GET['rating'];
 
 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)
 {
	if($hotelIDs==null)
		return;
	
	$data = Array();
	foreach($hotelIDs as $hotelID)
	{
		$data1 = Array();
		$data1[] = CalcForHotel($hotelID,$fromDate,$toDate,$conn);
		$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;
	
	
	return $data;
 }
 
 FUNCTION CalcForHotel($hotelID,$fromDate,$toDate,$conn)
 {
	$roomData = getHotelRoomData($hotelID,$fromDate,$toDate,$conn);
	//$mid = 36;
	
	$totalDays =  (strtotime($toDate . ' 12:00')  - strtotime($fromDate . ' 12:00') )/86400;
	
	$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
	
	
	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'] * $totalDays;
								
								//alaa 
								//echo " ChildRoom:" . $room['child_2_5_without_bed'];
								//echo " RoomCount:" . $totalDays;
								//echo " childPrice:" . $childPrice;
								
								
								$newRoom['intant'] = $room['intant'] * $totalDays;
								
								//$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'] == "3DLX")
									$colName = "starts3DLX";
									
								$Margion = 0;
								$MargionType = "FIXED";
								
								
								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
									{
									//echo "Single:";
									//echo "Room Total:" . $room['Total'];
									//echo "Margion:" . $Margion;
									//echo "Room Count:" . $room['Count'];
									
										$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'] * $totalDays;
								$newRoom['intant'] = $room['intant'] * $totalDays;
								
								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'] == "3DLX")
									$colName = "starts3DLX";
									
								$Margion = 0;
								$MargionType = "FIXED";
								
								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;
									if($childPrice=="0")
									{
										$newRoom['child_2_5_without_bed'] = 0;
									}
									else
									{
										$newRoom['child_2_5_without_bed'] = $newRoom['child_2_5_without_bed'] + $childPrice;
									}
									
									if($intantPrice=="0")
									{
										$newRoom['intant'] = 0;
									}
									else
									{
										$newRoom['intant'] = $newRoom['intant'] + $intantPrice;
									}
									
								}
								else
								{
								//echo "Additions:" . $additions;
								//echo "TicketPrice:" . $ticketPrice;
								
									$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;
									
									if($childPrice==0)
									{
										$newRoom['child_2_5_without_bed'] = 0;
									}
									else
									{
										$newRoom['child_2_5_without_bed'] = $newRoom['child_2_5_without_bed'] + $childPrice;
									}
									
									if($intantPrice=="0")
									{
										$newRoom['intant'] = 0;
									}
									else
									{
										$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 36;
	elseif($rating=="5")
		return 35;
	elseif($rating=="4DLX")
		return 38;
	elseif($rating=="4")
		return 37;
	elseif($rating=="3DLX")
		return 40;
	elseif($rating=="3")
		return 39;
}
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 getUniqueCombination($val,$newRoomData)
 {
	$hids = array();
	foreach ($newRoomData as $x) {
		$hids[] = $x[$val];
	}
	$uniqueHids = array_unique($hids);
	return $uniqueHids;
}
 
 FUNCTION getHotelRoomData($hotelID,$fromDate,$toDate,$conn)
{
	$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 * if(number_of_people=1,2,1) + rv.additional_price * 1.5 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,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 
				(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 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;
}

 ?>
 
 
<!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()
{


$(".des2").change(function()
{
var id=$(this).val();
var rat=$(".des3").val();
var dataString = 'id='+ id + '&rat=' + rat;
var idd = 'id='+id;

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


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


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


});
});
});
</script>

   <script>
  $(function() {
    $( "#datepicker" ).datepicker({
      defaultDate: "+1w",
      changeMonth: true,
      numberOfMonths: 1,
      onClose: function( selectedDate ) {
        $( "#datepicker1" ).datepicker( "option", "minDate", selectedDate );
      }
    });
    $( "#datepicker1" ).datepicker({
      defaultDate: "+1w",
      changeMonth: true,
      numberOfMonths: 1,
      onClose: function( selectedDate ) {
        $( "#datepicker" ).datepicker( "option", "maxDate", selectedDate );
      }
    });
  });
  </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: 12px;
}
.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>

<?php 
//------------- hussein here you need to play --------------


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

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;	

}


}


$fromdates=$_REQUEST['datepicker'];

$todates=$_REQUEST['datepicker1'];

// 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];
?>
 <br>
<div class="hotels">
	        
	        
 <form method="post" action="chotels.php" id="form3" name="form3"  onSubmit="return ValidateForm3()">
            <table width="97%" cellspacing="0" cellpadding="0">
	        <tr>
	        <td class="style1" style="height: 30px">
	        <strong>Select Destination	        
	        </strong>	        
	        </td>
	        </tr>
	  
	        <tr>
	        <td style="height: 30px">
	        <select class="des2" name="des2" 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
$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 Hotel Rating	        
	        </strong>	        
	        </td>
	        </tr>
	  
	        <tr>
	        <td style="height: 30px">
	        <select  class="des3" name="des3" 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" multiple="multiple" size="10" style=" background-image:url('images/w1.png'); width:300px; 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>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 style="height: 40px" class="style2" align="left">
	        <input name="ff22" type="image" src="images/b1.png" class="style3" /></td>
	        </tr>

	        
	        </table>
</form>

	        
	        </div>
<div style="position: absolute; right:5px;top:20px;">

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

<tr>

<td colspan=9 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['des2'];
$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>
	</div>
	
	
	<script language="javascript">
function show(){
        document.form2.action="tcpdf/pdf/harpdf.php?fromdate=<?php echo $fromdates3; ?>&todate=<?php echo $todates3; ?>&hotelids=<?php echo $hotelsstring;  ?>";
}
function pdf(){
        document.form2.action="tcpdf/pdf/harpdf.php?fromdate=<?php echo $fromdates3; ?>&todate=<?php echo $todates3; ?>&hotelids=<?php echo $hotelsstring;  ?>";
}

      
      function ValidateForm2(){


    var n=document.form2.des
    var c=document.form2.des0
    var t=document.form2.des1
    

   if ((n.value==null)||(n.value=="Select")){
    alert("Please select Destination")
   n.focus()
    return false
  }
  
  if ((c.value==null)||(c.value=="Select")){
    alert("Please select Hotel Rating")
   c.focus()
    return false
  }

if ((t.value==null)||(t.value=="Select")){
    alert("Please select Number of Nights")
   t.focus()
    return false
  }


   return true

  
 }


function ValidateForm3(){


    var n=document.form3.des2
    var c=document.form3.des3
    var t=document.form3.des4
    var a=document.form3.datepicker
    var b=document.form3.datepicker1

    
   if ((n.value==null)||(n.value=="Select")){
    alert("Please select Destenation")
   n.focus()
    return false
  }
  
  if ((c.value==null)||(c.value=="Select")){
    alert("Please select Hotel Rating")
   c.focus()
    return false
  }


  if ((a.value==null)||(a.value=="")){
    alert("Please Enter Start Date")
   a.focus()
    return false
  }
  
  if ((b.value==null)||(b.value=="")){
    alert("Please Enter End Date")
   b.focus()
    return false
  }

   
   return true

  
 }


function echeck(str) {
 
    var at="@"
    var dot="."
    var lat=str.indexOf(at)
    var lstr=str.length
    var ldot=str.indexOf(dot)
    if (str.indexOf(at)==-1){
       alert("Invalid E-mail address")
       return false
    }
 
    if (str.indexOf(at)==-1 || str.indexOf(at)==0 || str.indexOf(at)==lstr){
       alert("Invalid E-mail address")
       return false
    }
 
    if (str.indexOf(dot)==-1 || str.indexOf(dot)==0 || str.indexOf(dot)==lstr){
        alert("Invalid E-mail address")
        return false
    }
 
     if (str.indexOf(at,(lat+1))!=-1){
        alert("Invalid E-mail address")
        return false
     }
 
     if (str.substring(lat-1,lat)==dot || str.substring(lat+1,lat+2)==dot){
        alert("Invalid E-mail address")
        return false
     }
 
     if (str.indexOf(dot,(lat+2))==-1){
        alert("Invalid E-mail address")
        return false
     }
    
     if (str.indexOf(" ")!=-1){
        alert("Invalid E-mail address")
        return false
     }
 
     return true          
  }
 
function ValidateForm(){


    var n=document.form1.cus_name
    var e=document.form1.cus_email
        var c=document.form1.cus_cell


     if ((n.value==null)||(n.value=="")){
    alert("Please Enter your name")
    n.focus()
    return false
  }
    if ((e.value==null)||(e.value=="")){
    alert("Please Enter your email")
    e.focus()
    return false
  }
   if (echeck(e.value)==false){
    e.value=""
    e.focus()
    return false
  }

    if ((c.value==null)||(c.value=="")){
    alert("Please Enter your Mobile No.")
   c.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>

</tr>

<?php
$FinalData = CalcForAllHotels($hotelsids,$fromdates3,$todates3,$conn);
$total_nights=  (strtotime($todates3 . ' 12:00')  - strtotime($fromdates3 . ' 12:00') )/86400;


if($FinalData == null)
	return;
foreach($FinalData as $Hotel)
{
	foreach($Hotel as $row)
	{
		$hotel_name_ar =$row['hotel_name_ar'];
		$hotel_name =$row['hotel_name'];
		$hotel_rating=$row['rating'];
		$hotel_meal=$row['meal_name'];
		$hotel_location_en=$row['area_name_en'];
		$hotel_location=$row['area_name'];
		$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;
		
		
		?>
			<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;><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; ?></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; ?></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; ?></font></td>

			</tr>
		<?php 
		
		
	}
}

?>


<tr>

<td colspan=9 height="40px"><p align=center>
<font size="3" color="#bf0505"><b>

<?php 

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

?>


</font></b></p>
</td>
</tr>


</table>

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