<?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'];
 $tickets = $_GET['tickets'];
 $tours = $_GET['tours'];
 $trans = $_GET['trans'];


  FUNCTION CalcForAllHotels($hotelIDs,$fromDate,$toDate,$conn,$selected_tickets,$selected_tours,$selected_trans)
 {
	if($hotelIDs==null)
		return;
	$data = Array();
	foreach($hotelIDs as $hotelID)
	{
		$data[] = CalcForHotel($hotelID,$fromDate,$toDate,$conn,$selected_tickets,$selected_tours,$selected_trans);
	}
	
	//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 
			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)
 {
	$roomData = getHotelRoomData($hotelID,$fromDate,$toDate,$conn);
	
	$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'];
	}
	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);
	$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'];
								
								$Margion = getMargionFromMargions($Margions,$nDays,$colName,$newRoom['rating']);
								$MargionType = getMargionTypeFromMargions($Margions,$nDays,$colName,$newRoom['rating']);
								
								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'];
								
								$Margion = getMargionFromMargions($Margions,$nDays,$colName,$newRoom['rating']);
								$MargionType = getMargionTypeFromMargions($Margions,$nDays,$colName,$newRoom['rating']);
								
								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;
								}
								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;
								}
								
							}
							else
							{
								$newRoom['Single']=0;
								$newRoom['Double']=0;
								$newRoom['Triple']=0;
								$newRoom['child_2_12_with_bed']=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)
{
	$sql = "SELECT 
				h.hotel_id,
				h.hotel_name,
				h.website,
				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',
				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;
}
 
 
 ?>
 
 
<html lang="en">
<head>

  <meta charset="utf-8" />
  
  <link rel="stylesheet" href="http://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css" />
    <link rel="stylesheet" href="stylec.css" />
  <script src="http://code.jquery.com/jquery-1.9.1.js"></script>
  <script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"></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>
  
  
  <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); 

$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];

?>
 
 
 <form method="post" id="form1" name="form1"  onSubmit="return ValidateForm()" action="cpackages.php?tickets=<?php echo $tickets; ?>&trans=<?php echo $trans; ?>&tours=<?php echo $tours; ?>&placeid=<?php echo $pl; ?>&hotelsstring=<?php echo $hotelsstring;  ?>&fromdate=<?php echo $fromdates3; ?>&todate=<?php echo $todates3; ?>">
 
<font size="2">Select Place</font>
<select name="places" id="places"  OnChange="location.href=form1.places.options[selectedIndex].value" >
	<option>none</option>
<?php
$sqls="select * from Places order by place_name";
	
	$results = mysql_query($sqls,$conn);
while($rows = mysql_fetch_array($results))
  {
  
  if ($pl == $rows['place_id'])
echo "<option selected value=cpackages.php?placeid=".$rows['place_id'].">" . $rows['place_name']."</option>";
else
echo "<option value=cpackages.php?placeid=".$rows['place_id'].">" . $rows['place_name']."</option>";

  }
?>
</select>
<br><br>


<font size="2">Select Ticket</font>
<select name="tickets" id="tickets"  OnChange="location.href=form1.tickets.options[selectedIndex].value" >
	<option>none</option>
<?php
 $today = Date('Y-m-d');
$sqls1="select * from Tickets where place_id_f='$pl' and end_date > '$today'";
	
	$results1 = mysql_query($sqls1,$conn);
while($rows1 = mysql_fetch_array($results1))
  {
  
  if ($tickets == $rows1['ticket_id'])
echo "<option selected value=cpackages.php?placeid=".$pl."&tickets=".$rows1['ticket_id'].">" . $rows1['ticket_name']."</option>";
else
echo "<option value=cpackages.php?placeid=".$pl."&tickets=".$rows1['ticket_id'].">" . $rows1['ticket_name']."</option>";

  }
?>
</select>

<font size="2">Select Tours</font>
<select name="tours" id="tours"  OnChange="location.href=form1.tours.options[selectedIndex].value" >
	<option>none</option>
<?php
$sqls2="select * from Tours where place_id_f='$pl'";
	
	$results2 = mysql_query($sqls2,$conn);
while($rows2 = mysql_fetch_array($results2))
  {
  
  if ($tours == $rows2['tour_id'])
echo "<option selected  value=cpackages.php?placeid=".$pl."&tickets=".$tickets."&tours=".$rows2['tour_id'].">" . $rows2['tour_name']."</option>";
else
echo "<option value=cpackages.php?placeid=".$pl."&tickets=".$tickets."&tours=".$rows2['tour_id'].">" . $rows2['tour_name']."</option>";

  }
?>
</select>


<font size="2">Select Transportations</font>
<select name="trans" id="trans"  OnChange="location.href=form1.trans.options[selectedIndex].value" >
	<option>none</option>
<?php
$sqls3="select * from 	Transportations where place_id_f='$pl'";
	
	$results3 = mysql_query($sqls3,$conn);
while($rows3 = mysql_fetch_array($results3))
  {
  
  if ($trans == $rows3['transportation_id'])
echo "<option selected value=cpackages.php?placeid=".$pl."&tickets=".$tickets."&tours=".$tours."&trans=".$rows3['transportation_id'].">" . $rows3['transportation_name']."</option>";
else
echo "<option value=cpackages.php?placeid=".$pl."&tickets=".$tickets."&tours=".$tours."&trans=".$rows3['transportation_id'].">" . $rows3['transportation_name']."</option>";

  }
?>
</select>


<br><br>

<font size="2">Select Rating</font>
<select name="rating" id="rating"  style="width: 100px;" OnChange="location.href=form1.rating.options[selectedIndex].value">
		<option>none</option>
	
<option <?php if ($rating == "All") echo "Selected";  ?> value="cpackages.php?placeid=<?php echo $pl; ?>&tickets=<?php echo $tickets; ?>&tours=<?php echo $tours; ?>&trans=<?php echo $trans; ?>&rating=All">All</option>
<option <?php if ($rating == "5DLX") echo "Selected";  ?> value="cpackages.php?placeid=<?php echo $pl; ?>&tickets=<?php echo $tickets; ?>&tours=<?php echo $tours; ?>&trans=<?php echo $trans; ?>&rating=5DLX">5DLX</option>
<option <?php if ($rating == "5") echo "Selected";  ?> value="cpackages.php?placeid=<?php echo $pl; ?>&tickets=<?php echo $tickets; ?>&tours=<?php echo $tours; ?>&trans=<?php echo $trans; ?>&rating=5">5</option>
<option <?php if ($rating == "4DLX") echo "Selected";  ?> value="cpackages.php?placeid=<?php echo $pl; ?>&tickets=<?php echo $tickets; ?>&tours=<?php echo $tours; ?>&trans=<?php echo $trans; ?>&rating=4DLX">4DLX</option>
<option <?php if ($rating == "4") echo "Selected";  ?> value="cpackages.php?placeid=<?php echo $pl; ?>&tickets=<?php echo $tickets; ?>&tours=<?php echo $tours; ?>&trans=<?php echo $trans; ?>&rating=4">4</option>
<option <?php if ($rating == "3DLX") echo "Selected";  ?> value="cpackages.php?placeid=<?php echo $pl; ?>&tickets=<?php echo $tickets; ?>&tours=<?php echo $tours; ?>&trans=<?php echo $trans; ?>&rating=3DLX">3DLX</option>
<option <?php if ($rating == "3") echo "Selected";  ?> value="cpackages.php?placeid=<?php echo $pl; ?>&tickets=<?php echo $tickets; ?>&tours=<?php echo $tours; ?>&trans=<?php echo $trans; ?>&rating=3">3</option>


</select>
<br><br>
<font size="2">Select hotel</font><br>


<select name="hotels[]" id="hotels" multiple="multiple" style="width: 250px;" size="10">
<?php


if ($rating == "All")
 
  $rating1 = '';
  
  else 
    $rating1 = " and rating="."'".$rating."'";


$sql2="Select * From Hotels where place_id_f = '$pl' $rating1 ORDER BY hotel_name";
$result2 = mysql_query($sql2,$conn);

while($row2 = mysql_fetch_array($result2))
  {
  
echo "<option value=".$row2['hotel_id'].">" . $row2['hotel_name']."</option>";
  

  }
 

?>
 
 
</select>

<br><br>


<font size="2">
From Date </font>

<input type="text" id="datepicker" name="datepicker" />


<font size="2">
To Date </font>

<input type="text" id="datepicker1" name="datepicker1" />
 
 <br><br>


<input type="submit" value="Calculate Package Prices">

</form>

<br>

<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">
	<option>none</option>

	
	<?php
	$b=$_SESSION['branch'];
	 $pl=$_GET['placeid'];
	$sqll="select * from Headers_Footers where branch='$b' AND place_id_f='$pl'";
	
	$resultl = mysql_query($sqll,$conn);
while($rowl = mysql_fetch_array($resultl))
  {
echo "<option value=".$rowl['id'].">" . $rowl['name']."</option>";

  }
	
	
	?>
	</select>
	
	<input name="Submit1" type="submit" value="PDF/Print Arabic" onclick="show()"/>
	</form>
	</div>
	
	
	<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;  ?>";
}
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;  ?>";
}


function ValidateForm(){


    var k=document.form1.tickets
    var n=document.form1.hotels
    var c=document.form1.datepicker
    var t=document.form1.datepicker1
    
if(k.selectedIndex == 0)
    {
    alert("Please Select Ticket")
    k.focus()
    return false
  }
 
   
   if ((n.value==null)||(n.value=="")){
    alert("Please select at least one hotel")
   n.focus()
    return false
  }

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

   if ((t.value)<=(c.value)){
    alert("Invalid Period")
   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>

</tr>

<?php
$FinalData = CalcForAllHotels($hotelsids,$fromdates3,$todates3,$conn,$tickets,$tours,$trans);
$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'];

		$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; color:#bf0505"><font size="2"><font size="2"><b><?php echo $hotel_location_en; ?></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>
</body>
</html>