<?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 CalcForAllHotels($hotelIDs,$fromDate,$toDate,$conn)
 {
	if($hotelIDs==null)
		return;
	$data = Array();
	foreach($hotelIDs as $hotelID)
	{
		$data[] = CalcForHotel($hotelID,$fromDate,$toDate,$conn);
	}
	
	
	return $data;
 }
 
 FUNCTION CalcForHotel($hotelID,$fromDate,$toDate,$conn)
 {
	$roomData = getHotelRoomData($hotelID,$fromDate,$toDate,$conn);
	$Margions = getMargions($conn);
	$newRoomData = Array();

	$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['room_view_name'] = $room['room_view_name'];
								$newRoom['website'] = $room['website'];

								$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['room_view_name'] = $room['room_view_name'];
								$newRoom['website'] = $room['website'];

								$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)
								{
									$newRoom['Single']=0;
									$newRoom['Double']=0;
									$newRoom['Triple']=0;
									$newRoom['child_2_12_with_bed']=0;
								}
							$newRoomData2[] = $newRoom;
							$in = 0;
						}
						
					}

				}
			}
		//}
		
	  }
	
	//echo "-------------------------------------------------------------------------------------------------------------------";
	//print_r($newRoomData2); 
	return $newRoomData2;
 }
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.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;
}
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;
}

 ?>
 
 
<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>

<?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 align=left>
 
 
 <form onSubmit="return ValidateForm()" method="post" id="form1" name="form1" action="chotels.php?placeid=<?php echo $pl;?>&hotelsstring=<?php echo $hotelsstring;  ?>" >
 
<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=chotels.php?placeid=".$rows['place_id'].">" . $rows['place_name']."</option>";
else
echo "<option value=chotels.php?placeid=".$rows['place_id'].">" . $rows['place_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>

	<?php if ($rating == "All") echo "Selected";  ?>
<option <?php if ($rating == "All") echo "Selected";  ?> value="chotels.php?placeid=<?php echo $pl; ?>&rating=All">All</option>
<option <?php if ($rating == "5DLX") echo "Selected";  ?> value="chotels.php?placeid=<?php echo $pl; ?>&rating=5DLX">5DLX</option>
<option <?php if ($rating == "5") echo "Selected";  ?> value="chotels.php?placeid=<?php echo $pl; ?>&rating=5">5</option>
<option <?php if ($rating == "4DLX") echo "Selected";  ?> value="chotels.php?placeid=<?php echo $pl; ?>&rating=4DLX">4DLX</option>
<option <?php if ($rating == "4") echo "Selected";  ?> value="chotels.php?placeid=<?php echo $pl; ?>&rating=4">4</option>
<option <?php if ($rating == "3DLX") echo "Selected";  ?> value="chotels.php?placeid=<?php echo $pl; ?>&rating=3DLX">3DLX</option>
<option <?php if ($rating == "3") echo "Selected";  ?> value="chotels.php?placeid=<?php echo $pl; ?>&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 Hotel 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/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 ValidateForm(){


    var n=document.form1.hotels
    var c=document.form1.datepicker
    var t=document.form1.datepicker1
    

   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);
$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'];
		$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><?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>