<?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)
 {
	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);
		$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)
 {
	$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'] == "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
									{
									//echo "Single:";
									//echo "Room Total:" . $room['Total'];
									//echo "Margion:" . $Margion;
									
										$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'] == "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)
{
	$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 * 1.5 + 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.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 
				(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: "gethotels.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);
} 
});
});
});


</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); 

 $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="cpackages.php" id="form3" name="form3"  onSubmit="return ValidateForm2()">
	        
            <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="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 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>
	        
	        
	        <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 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>        
	        
	        
<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>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 style="height: 40px" class="style2">
	        <input name="ff2" 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['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
    
    
    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 ((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>

</tr>

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