<? 
   
  	include "includes/dbconnect.php"; 
  	include "includes/functions.php"; 
  	 
  	$name = (!empty($_REQUEST["name"]))?strip_tags(str_replace("'","`",$_REQUEST["name"])):''; 
  	$phone = (!empty($_REQUEST["phone"]))?strip_tags(str_replace("'","`",$_REQUEST["phone"])):''; 
  	$email = (!empty($_REQUEST["email"]))?strip_tags(str_replace("'","`",$_REQUEST["email"])):''; 
  	$comments = (!empty($_REQUEST["comments"]))?strip_tags(str_replace("'","`",$_REQUEST["comments"])):''; 
  	$date = (!empty($_REQUEST["date"]))?strip_tags(str_replace("'","`",$_REQUEST["date"])):''; 
  	$captcha_sum = (!empty($_POST["captcha_sum"]))?strip_tags(str_replace("'","`",$_POST["captcha_sum"])):''; 
  	$captcha = (!empty($_POST["captcha"]))?strip_tags(str_replace("'","`",$_POST["captcha"])):''; 
  	 
  	$msg2 = (!empty($_REQUEST["msg2"]))?strip_tags(str_replace("'","`",$_REQUEST["msg2"])):''; 
  	 
  	####################################### PREPARE AVAILABILITY TABLE ############################################## 
  	$reservedArray=array(); 
  	$seconds = 0; 
  	$availability = ""; 
  	$query="SELECT * FROM bs_reserved_time WHERE reserveDateFrom LIKE '".$date."%' ORDER BY reserveDateFrom ASC "; 
  					$result=mysql_query($query); 
  					if(mysql_num_rows($result)>0){ 
  						while($rr=mysql_fetch_assoc($result)){ 
  							list($hours, $minutes) = split(':', date("H:m", strtotime($rr["reserveDateFrom"]))); 
  							$startTime = date("g", strtotime($rr["reserveDateFrom"])); 
  							$startTimestamp = mktime($hours, $minutes); 
  							list($hours, $minutes) = split(':', date("H:m", strtotime($rr["reserveDateTo"]))); 
  							$endTimestamp = mktime($hours, $minutes); 
  							$seconds += $endTimestamp - $startTimestamp; 
  							$hours = round($seconds / (60 * 60));  
  							for($i=$startTime;$i<($startTime+$hours);$i++){ 
  								$reservedArray[] =  $i; 
  							} 
  						}				 
  					} 
  					 
  					$seconds = 0; 
  					 
  					$query="SELECT bs_reservations_items.* FROM `bs_reservations_items` INNER JOIN bs_reservations on bs_reservations_items.reservationID = bs_reservations.id WHERE bs_reservations.status='1' AND bs_reservations_items.reserveDateFrom LIKE '".$date."%' ORDER BY bs_reservations_items.reserveDateFrom ASC "; 
  					$result=mysql_query($query); 
  					if(mysql_num_rows($result)>0){ 
  						while($rr=mysql_fetch_assoc($result)){ 
  							list($hours, $minutes) = split(':', date("H:m", strtotime($rr["reserveDateFrom"]))); 
  							$startTime = date("G", strtotime($rr["reserveDateFrom"])); 
  							$startTimestamp = mktime($hours, $minutes); 
  							list($hours, $minutes) = split(':', date("H:m", strtotime($rr["reserveDateTo"]))); 
  							$endTimestamp = mktime($hours, $minutes); 
  							$seconds += $endTimestamp - $startTimestamp; 
  							$hours = round($seconds / (60 * 60));  
  								$reservedArray[] =$startTime;					 
  						}				 
  					} 
  					//var_dump($reservedArray); 
  					 
  				 
  					$ww= date("w",strtotime($date)); 
  					$tt = getStartEndTime($ww); 
  					$startTime = $tt[0]; 
  					$endTime = $tt[1]; 
  					$n = $endTime - $startTime; 
  									 
  					$tempVar = $n ; 
  					$tempVar2 = ($tempVar - ($tempVar%2))/2; 
  					 
  					 
  					$availability .= "<table width=\"400\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\"><tr><td valign='top'>"; 
  					 
  					$count=0; 
  					for($b=$startTime;$b<$endTime;$b++){ 
  						if($count==$tempVar2){ $availability .= "</td><td align='left' valign='top'>"; }	 
  						if(in_array($b,$reservedArray)){  
  							$availability .= $b.":00 ".($b<12?"am":"pm")." - ".($b+1).":00 ".($b+1<12?"am":"pm")." - Booked.<br>"; 
  						} else {  
  						$availability .=$b.":00 ".($b<12?"am":"pm")." - ".($b+1).":00 ".($b+1<12?"am":"pm")."- <input type=\"checkbox\" value=\"".$b."\" name=\"time[]\" ><br>";  
  						} 
  						$count++; 
  					} 
  					 
  					$availability .="</td></tr></table>"; 
  					 
  					 
  					$maximumBookings = getMaxBooking(); 
  					if($maximumBookings =0 && $maximumBookings =2){ 
  						$maximumBookingsText = ", ".$maximumBookings." hours maximum."; 
  					} else { 
  						$maximumBookingsText = "dolmuştur"; 
  					} 
  		 
  		 
  		if(!empty($msg2) && $msg2=="captcha"){ 
  			$msg = "<div class='error_msg'>Captcha error! Please try again</div>"; 
  		} 
  ?> 
  <link rel="stylesheet" type="text/css" href="css/bs-admin.css" /> 
  <noscript> 
      <div class="js_error">Please enable JavaScript or upgrade to better <a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=45062424&url=http://www.mozilla.com/en-US/firefox/upgrade.html" target="_blank" data-href="http://www.mozilla.com/en-US/firefox/upgrade.html" target="_blank">browser</a></div> 
  </noscript> 
  <?php echo $msg; ?> 
  <div class="internal_booking_form"> 
  <script type="text/JavaScript"> 
  <!-- 
     
  function checkForm() { 
  	var maximumBookings = <?php echo $maximumBookings?>; 
  	var err=0; 
  	var msg2=""; 
  <? 
  $reqFields=array( 
  	"name", 
  	"phone", 
  	"email", 
  	"comments", 
  	"captcha" 
  	 
  ); 
   
  foreach ($reqFields as $v) { ?> 
   
  	if (document.getElementById('<?=$v?>').value==0 || document.getElementById('<?=$v?>').value=="00") { 
  		if (err==0) { 
  			document.getElementById('<?=$v?>').focus(); 
  		} 
  		document.getElementById('<?=$v?>').style.backgroundColor='#ffa5a5'; 
  		err=1; 
  	}<? 
   
  } 
  ?> 
  	 
  	var reg1 = /(@.*@)|(\.\.)|(@\.)|(\.@)|(^\.)/; // not valid 
  	var reg2 = /^.+\@(\[?)[a-zA-Z0-9\-\.]+\.([a-zA-Z]{2,3}|[0-9]{1,3})(\]?)$/; // valid    
  	if (document.getElementById('email').value==0 || !reg2.test(document.getElementById('email').value)) { 
  	if (err==0) { 
  		document.getElementById('email').focus(); 
  	} 
  	document.getElementById('email').style.backgroundColor='#ffa5a5'; 
  	err=1; 
  	} 
  	 
  	//check checkboxes, must be at least 1, and not more than 3 
    var checks = document.getElementsByName('time[]'); 
    var boxLength = checks.length; 
    var totalChecked = 0; 
       
      for ( i=0; i < boxLength; i++ ) { 
        if ( checks[i].checked == true ) { 
  		totalChecked++; 
        } 
  	} 
   
  		 
   
   
  if (err==0) { 
  		 if(totalChecked>0 && totalChecked<=maximumBookings){ 
  			 return true; 
  		 } else {  
  		 	alert("Minimum booking time 1 hour, maximum "+maximumBookings+" hours. Please adjust your booking!"); 
  		 	return false; 
  		 } 
  	} else { 
  		alert("Please complete all highlited fields to continue."); 
  		return false; 
  	} 
  	 
  } 
   
   
  function checkFieldBack(fieldObj) { 
  	if (fieldObj.value!=0) { 
  		fieldObj.style.backgroundColor='#EAEAEA'; 
  	} 
  } 
   
  function checkNumeric(value){ 
  		var anum=/(^\d+$)|(^\d+\.\d+$)/ 
  		if (anum.test(value)) 
  			return true; 
  		return false; 
      } 
   
  function noAlpha(obj){ 
  	reg = /[^0-9.,]/g; 
  	obj.value =  obj.value.replace(reg,""); 
   } 
   
  //--> 
  </script>  
  <form name="ff1" enctype="multipart/form-data" method="post" action="booking.processing.php" onsubmit="return checkForm();">   
  <input type="hidden" value="<?=$date?>" name="date"> 
   
  <h2>Service Reservation for <br /> 
  <?=date("d F Y", strtotime($date))?></h2> 
   
   
   
  <p>Please select desired time. 1 hour minimum <?php echo $maximumBookingsText?></p> 
   
  <?php echo $availability?> 
   
  <table width="250" border="0" align="center" cellpadding="0" cellspacing="0"> 
                 
                <tr> 
                  <td height="30" align="right" class="align_right">Your Name*: </td> 
                  <td> 
                    <input type="text" name="name" id="name" value="<?=$name?>"  onchange="checkFieldBack(this)"/> 
                  </td> 
                </tr> 
                <tr> 
                  <td height="30" align="right" class="align_right">Phone*: </td> 
                  <td><input type="text" name="phone" id="phone" value="<?=$phone?>"  onchange="checkFieldBack(this)" onkeyup="noAlpha(this)"/></td> 
                </tr> 
                <tr> 
                  <td height="30" align="right" class="align_right">E-mail*: </td> 
                  <td><input type="text" name="email" id="email"  value="<?=$email?>" onchange="checkFieldBack(this);"/></td> 
                </tr> 
               
                <tr> 
                  <td align="right"  valign="top" class="align_right">Comments*: </td> 
                  <td><textarea name="comments" id="comments" cols="15" rows="5" onchange="checkFieldBack(this)"><?=$comments?></textarea></td> 
                </tr> 
                 
                 
                <?php 
  			  $num1 = rand(1,9); 
  			  $num2 = rand(1,9); 
  			  $sum = $num1 + $num2; 
  			  ?> 
                 <tr> 
                  <td height="30" align="right" class="align_right"><?php echo $num1." + ".$num2." = "?></td> 
                  <td align="left">   <input type="text" name="captcha" id="captcha"  value="" style="width:30px;" onchange="checkFieldBack(this);"/> 
                  <input type="hidden" name="captcha_sum" value="<?php echo md5($sum);?>" /> 
                  </td> 
                </tr> 
                 
                <tr> 
              	<td height="15"> </td> 
              	<td> </td> 
            	  </tr> 
                <tr> 
                  <td colspan="2" align="center" class="align_center"><input type="image" src="images/reserve_btn.jpg"  /></td> 
                </tr> 
                <tr> 
              	<td> </td> 
              	<td> </td> 
            	  </tr> 
  </table> 
   
                </form> 
                </div>

 
  for($b=$startTime;$b<$endTime;$b++){ 
  	if($count==$tempVar2){ $availability .= "</td><td align='left' valign='top'>"; }	 
  	if(in_array($b,$reservedArray)){  
  		$availability .= $b.":00 ".($b<12?"am":"pm")." - ".($b+1).":00 ".($b+1<12?"am":"pm")." - Booked.<br>"; 
  	} 
          else { 
  		$availability .=$b.":00 ".($b<12?"am":"pm")." - ".($b+1).":00 ".($b+1<12?"am":"pm")."- <input type=\"checkbox\" value=\"".$b."\" name=\"time[]\" ><br>"; 
  	} 
  	$count++; 
  } 
  

 
  for($b=$startTime;$b<$endTime;$b++){ 
  	if($count==$tempVar2){ $availability .= "</td><td align='left' valign='top'>"; }	 
  	if(in_array($b,$reservedArray)){  
  		$availability .= $b.":00 ".($b<12?"am":"pm")." - ".($b+1).":00 ".($b+1<12?"am":"pm")." - Booked.<br>"; 
  	} 
          else { 
  		if (($b<12 && $b+1<=12) || ($b>=13 && $b+1>13)) { 
  			$availability .=$b.":00 ".($b<12?"am":"pm")." - ".($b+1).":00 ".($b+1<12?"am":"pm")."- <input type=\"checkbox\" value=\"".$b."\" name=\"time[]\" ><br>"; 
  		} 
  	} 
  	$count++; 
  }