<?php 
ob_start();
include("header1.php"); ?>

<?
$_SESSION["userid"];
 session_start();
 if($_SESSION["userid"]=="")
 {
 header("location:index.php");
 }
  $ses_ma_id=$_SESSION["userid"];
 $browsessionid=session_id();
 
 
 ?>
    <!--breadcrumbs area end-->
    <? if(isset($_POST['Submit']))

{
date_default_timezone_set('Asia/Kolkata');
 $date = date('Y-m-d H:i:s ', time());
$name=trim(addslashes($_POST['name']));
 $id_gender=trim(addslashes($_POST['id_gender']));
$phone=trim(addslashes($_POST['phone']));
$email=trim(addslashes($_POST['email']));
$password=trim(addslashes($_POST['p_word']));
 $message=trim(addslashes($_POST['message']));
 $address=trim(addslashes($_POST['address']));
 $country=trim(addslashes($_POST['country']));
 $consulting_for=trim(addslashes($_POST['con_for']));
  $pincode=trim(addslashes($_POST['pincode']));
 $city=trim(addslashes($_POST['city']));
 
 
 $state=trim(addslashes($_POST['state']));
 $id_lang=trim(addslashes($_POST['id_lang']));
				$skypeid=trim(addslashes($_POST['skypeid']));
 
$dob1=trim(addslashes($_POST['dob']));

  $ses_user_id=$_SESSION["userid"];


 //$time=strtotime($dob1);
 
   $dob=date('Y-m-d', strtotime($dob));

 $time_id=trim(addslashes($_POST['time_id']));
$time_id_1=strtotime($time_id);
  $date_id=trim(addslashes($_POST['date_id']));
 $date_id_1=strtotime($date_id);
  $appointment_time=date('h:i a', $time_id_1);
 
  $appointment_date=date('Y-m-d', $date_id_1);
  
  
  $appointment_time_1=date('h', $time_id_1);
  $appointment_time_2=date('i', $time_id_1);
  $appointment_time_3=date('a', $time_id_1);

   //$time_t=date('h:i a', $time_id);
  //$date_t=date('Y-m-d', $date_id);
  
  
  $query_pag_num = "SELECT * FROM  tbl_member where email='$email' ";

 $result_pag_num = mysql_query($query_pag_num);

 $rows = mysql_num_rows($result_pag_num);

$Query_delete =  mysql_query("DELETE from   tbl_appointment where session_id='$browsessionid' and status='0'");

	
$Insert_Qry    = "INSERT INTO tbl_member (`name`,`gender`,`phone`,`email`,`dob`,`password`,`language`,`skypeid`,`country`) VALUES ('$name','$id_gender','$phone','$email','$dob1','$password','$id_lang','$skypeid','$country')";

$Insert_Run    = mysql_query($Insert_Qry) or die("Insert query error".mysql_error());

$attachmentfileid = mysql_insert_id();
if($ses_user_id!='')
{


}


if($ses_user_id!='')
{
 $ses_user_idassas=$_SESSION["userid"];


 $upload_img = mysql_query("UPDATE  shop_user SET name='".$name."',gender='".$id_gender."',phone='".$phone."',email='".$email."',dob='".$dob1."',language='".$id_lang."',skypeid='".$skypeid."',postcode='".$pincode."',address='".$address."',state='".$state."',city='".$city."',country='".$country."' WHERE user_id='".$ses_user_id."'");


}

if($ses_user_id=='')
{

$Insert_Qry_12    = "INSERT INTO shop_user (`name`,`gender`,`phone`,`email`,`dob`,`password`,`language`,`skypeid`,`state`,`city`,`country`,`address`,`status`) VALUES ('$name','$id_gender','$phone','$email','$dob1','$password','$id_lang','$skypeid','$state','$city','$country','$address','1')";

$Insert_Run_12    = mysql_query($Insert_Qry_12) or die("Insert query error".mysql_error());


}

  $query_pag_mem = "SELECT * FROM  tbl_appointment where email_id='$email' and status='1' ";

 $result_pag_mem = mysql_query($query_pag_mem);

 $rows_page_mem = mysql_num_rows($result_pag_mem);
 
 if($rows_page_mem==0)
 {
 $amount=400;
 }
 if($rows_page_mem==1)
 {
 $amount=200;
 }
 if($rows_page_mem>1)
 {
 $amount=100;
 }

$Insert_Qry_1    = "INSERT INTO tbl_appointment (`mem_id`,`appointment_date`,`hour_date`,`min_date`,`am_date`,`des`,`email_id`,`session_id`,`status`,`consulting_for`,`amount`) VALUES ('$attachmentfileid','$appointment_date','$appointment_time_1','$appointment_time_2','$appointment_time_3','$message','$email','$browsessionid','0','$consulting_for','$amount')";

$Insert_Run_1    = mysql_query($Insert_Qry_1) or die("Insert query error".mysql_error());


$attachmentfileid_1 = mysql_insert_id();


if($_FILES['file']['name']!="")

  {
  
  $size = 190; // the thumbnail height


	$filedir = 'uploads/'; // the directory for the original image

	$thumbdir = 'uploads/';          // the directory for the thumbnail image

	$maxfile = '200000000000';

	$mode = '0666';

	
	  $userfile_name = $_FILES['file']['name'];


	 $userfile_tmp = $_FILES['file']['tmp_name'];


	//$userfile_name = $_FILES['uploadFile']['name'];


	//$userfile_tmp = $_FILES['uploadFile']['tmp_name'];


	$getExt = explode ('.', $userfile_name);

	 $rand_name = md5(rand(000,999));

	/* $prod_img = $filedir.$mysql_insert_id.$i.$getExt[0].".".$getExt[1];*/

	
	 $new_file_name = $userfile_name;

	
		//exit();

		 $new_file_name = str_replace('&','and',$new_file_name);

		 $new_file_name = str_replace('#','',$new_file_name);

		 $new_file_name = str_replace('+','',$new_file_name);

		  $new_file_name=($attachmentfileid.$new_file_name);

		   $prod_img = $filedir.$new_file_name; // original_images/456546565465465464jhh.jpg

		$items[] = $prod_img;

		$prod_img_thumb = $thumbdir.$getExt[0].".".$getExt[1];

		 
		move_uploaded_file($userfile_tmp, $prod_img);

		
		$upload_img = mysql_query("UPDATE  tbl_appointment SET document_name='".$new_file_name."' WHERE id='".$attachmentfileid_1."'");
		

  }
  $id=$_REQUEST['id'];
		$m_id=$_REQUEST['m_id'];
 header("location:appointment-confirmation.php?id=".$id ."&m_id=".$m_id);
 
 
}
?>


<script type="text/javascript">
	function isNumber(evt) {
    evt = (evt) ? evt : window.event;
    var charCode = (evt.which) ? evt.which : evt.keyCode;
    if (charCode > 31 && (charCode < 48 || charCode > 57)) {
        return false;
    }
    return true;
}
				 function validateForm() {
				 
				 
				 //alert('validateForm');
				 
				 
				 if(document.register.name.value == "")
	{
       alert("Please Enter The Patient Name ");
	   document.register.name.focus();
        return false;
    }
	
	 if(document.register.phone.value == "")
	{
       alert("Please Enter The Phone Number");
	   document.register.phone.focus();
        return false;
    }
	
	var option=document.getElementsByName('id_gender');

if (!(option[0].checked || option[1].checked)) {
    alert("Please Select Your Gender");
    return false;
}


if(document.register.id_lang.value == "")
{
alert("Please Select The Language:");
document.register.id_lang.focus();
return false;
}

	if(document.register.email.value == "")
	{
       alert("Please Enter The Email Address");
	   document.register.email.focus();
        return false;
    }
	
	if(document.register.dob.value == "")
	{
       alert("Please Enter The Age");
	   document.register.dob.focus();
        return false;
    }
	
	if(document.register.skypeid.value == "")
	{
       alert("Please Enter The WhatsApp Number");
	   document.register.skypeid.focus();
        return false;
    }
	
	/*var option=document.getElementsByName('id_lang');

if (!(option[0].checked || option[1].checked || option[2].checked)) {
    alert("Please Select Your Language");
    return false;
}*/


	if(document.register.con_for.value == "")
{
alert("Please Enter the Consulting For:");
document.register.con_for.focus();
return false;
}

	if(document.register.address.value == "")
{
alert("Please Enter the Address:");
document.register.address.focus();
return false;
}
	
	
	if(document.register.p_word.value == "")

{


alert("Please enter the Password");

document.register.p_word.focus();

return false;

}

if(document.register.c_passwprd.value == "")

{


alert("Please enter the Confirm Password");

document.register.c_passwprd.focus();

return false;

}

if(document.register.p_word.value != document.register.c_passwprd.value)

{


alert("Please enter the Password and Confirm Password should be same");

document.register.p_word.focus();

return false;

}


if(document.register.city.value == "")
{
alert("Please Enter the City:");
document.register.city.focus();
return false;
}
if(document.register.state.value == "")
{
alert("Please Enter the State:");
document.register.state.focus();
return false;
}

if(document.register.country.value == "")
{
alert("Please Select the Country:");
document.register.country.focus();
return false;
}
	if(document.register.message.value == "")
	{
       alert("Please Enter The Description");
	   document.register.message.focus();
        return false;
    }	
				 
				 }
				 </script>
    
        <div class="container"> 
		
            <!--product details start-->
           
                <div class='row'>
				
				<div class="d-details col-lg-8 col-md-offset-2 ">
				
				<?  
				$new_time_ma_1=$_REQUEST['id'];
				
				$new_time_ma_2=$_REQUEST['m_id'];
				$appointment_time=date('h:i a', $new_time_ma_1);
				$appointment_date=date('Y-m-d', $new_time_ma_2);
				$new_ap_date=date('l', strtotime($appointment_date));
				$new_date_m=date('M', strtotime($appointment_date));
				$new_date_m_da=date('d', strtotime($appointment_date));
				
				
				?>
				
<h4><? echo $new_ap_date;?>, <? echo $new_date_m;?> <? echo $new_date_m_da;?> <? echo $appointment_time;?></h4>

				 
				 </div>
				
				 <div class="product_details contact_message form">
				 
				 <? if($_REQUEST['error']!='')
				 {
				 ?>
				<div class="alert alert-danger" role="alert">
 Email Id Already Register <a href="#" class="alert-link">Login and continue  </a>
</div>
<?
}
?>
				
   <!--<form  method="POST" action="">-->
   
   <?
   $ses_u_id=$_SESSION["userid"];
   
   $objqrynewsubee    = "SELECT * FROM shop_user where user_id='$ses_u_id'";
 $objResultnewsubee    = mysql_query($objqrynewsubee);
 $Fetchnewww        = mysql_fetch_array($objResultnewsubee);
 $gender=$Fetchnewww['gender'];
  $language=$Fetchnewww['language'];
   $dob=$Fetchnewww['dob'];
  $id_lang=$Fetchnewww['language'];
 // $time=strtotime($dob);
 
    //$dob=date('m/d/Y', strtotime($dob));
	  $country=$Fetchnewww['country'];
   ?>
    <form role="form"  class="form-horizontal" name="register"  method="post"  onsubmit="return validateForm()"   enctype="multipart/form-data">
	
	
	<div class="row">
                                <div class="col-lg-6 mb-20">  
                                   <label> Patient Name (required)<?  $_SESSION["userid"];?></label>
                                    <input name="name" placeholder="Name *" value="<? if($ses_u_id!='') { echo $Fetchnewww['name']; } ?>" type="text"> 
                                </div> 
								
								<div class="col-lg-6 mb-20">
                                            <label> Email Address   </label>
                                              <input type="text" name="email" value="<? if($ses_u_id!='') { echo $Fetchnewww['email']; } ?>"> 

                                        </div>
								
								<div class="col-lg-3 mb-20">
                                            <label>Mobile</label>
                                            <input  name="phone" value="<? if($ses_u_id!='') { echo $Fetchnewww['phone']; } ?>" maxlength="10" type="text" onkeypress="return isNumber(event)"> 

                                        </div>   
										
										<div class="col-lg-3 mb-20">
                                            <label> Age in Years   </label>
                                              <input type="text" name="dob" value="<? if($ses_u_id!='') { echo $Fetchnewww['dob']; } ?>" maxlength="3"  onkeypress="return isNumber(event)"> 

                                        </div>                            
                                       
                                  <div class="col-lg-3 mb-20"> 
								   <label> Gender</label>
								   <div class="input-radio">
                                                        <span class="custom-radio">
														<input type="radio" <? if($gender=='male') {  ?>  checked="checked" <? } ?> value="male" name="id_gender"> Male</span>
                                                        <span class="custom-radio"><input type="radio" <? if($gender=='female') {  ?>  checked="checked" <? } ?> value="female" name="id_gender"> Female</span>
                                                    </div>
										</div>  
										
										
										<div class="col-lg-3 mb-20"> 
										<label> Select Language </label>
										<select class="niceselect_option" name="id_lang" id="id_lang"> 
											 <option value="">Select</option>  
                                                <option value="Tamil" <? if($id_lang=='Tamil') {  ?>   selected="selected" <? } ?>>Tamil</option>      
                                                <option value="English" <? if($id_lang=='English') {  ?>   selected="selected" <? } ?>>English</option> 
												 <option value="Telugu" <? if($id_lang=='Telugu') {  ?>   selected="selected" <? } ?>>Telugu</option> 
                                                

                                            </select></p>
										</div>
										
										
										<div class="contact_textarea col-lg-6 mb-20">
                                    <label>  Consulting for ( e.g. diabetic ).</label>
                                    <input type="text" name="con_for" value="">   
                                </div>
										
										
										<div class="col-lg-6 mb-20">
                                            <label> Address  </label>
                                              <input type="text" name="address" value="<? if($ses_u_id!='') { echo $Fetchnewww['address']; } ?>"> 

                                        </div>
										
										<div class="col-lg-4 mb-20">
                                            <label> City  </label>
                                              <input type="text" name="city" value="<? if($ses_u_id!='') { echo $Fetchnewww['city']; } ?>"> 

                                        </div>
										
										<div class="col-lg-4 mb-20">
                                            <label> State  </label>
                                              <input type="text" name="state" value="<? if($ses_u_id!='') { echo $Fetchnewww['state']; } ?>"> 

                                        </div>
										
										<div class="col-lg-4 mb-20"> 
										<label> Select Country </label>
										<select class="niceselect_option" name="country" id="country"> 
											
                                                <option value="India" <? if($country=='India') {  ?>   selected="selected" <? } ?>>India</option>      
                                                <option value="Malayasia" <? if($country=='Malayasia') {  ?>  selected="selected" <? } ?>>Malayasia</option> 
                                                

                                            </select>
										</div>
										
										
										<div class="col-lg-6 mb-20">
                                            <label><div class="pull-left"> Pin Code </div>  
											</label>
                                              <input type="text" name="pincode" value="<? if($ses_u_id!='') { echo $Fetchnewww['postcode']; } ?>"> 

                                        </div>
										
										<div class="col-lg-6 mb-20">
                                            <label><div class="pull-left"> Whatsapp No </div> &nbsp;&nbsp; 
											</label>
                                              <input type="text" name="skypeid" value="<? if($ses_u_id!='') { echo $Fetchnewww['skypeid']; } ?>"> 

                                        </div>
										
										
<!--<script src="https://code.jquery.com/jquery-3.3.1.min.js"></script>

    <script src="https://unpkg.com/gijgo@1.9.13/js/gijgo.min.js" type="text/javascript"></script>
    <link href="https://unpkg.com/gijgo@1.9.13/css/gijgo.min.css" rel="stylesheet" type="text/css" />
										
										<div class="col-lg-12 mb-20">
										
                                   <label>  Date of Birth</label>
								   <input type="text" id="datepicker" name="dob" value="<? if($ses_u_id!='') { echo $dob; } ?>" />
    <script>
        $('#datepicker').datepicker({
            uiLibrary: 'bootstrap4',
			
        });
    </script>-->
								   <!--<input type="text" id="datepicker" name="dob"  placeholder="Choose">-->
                                   <!--<input type="text" placeholder="MM/DD/YYYY" value="" name="birthday">-->
                                <!--</div>	-->
								
								<!--<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>-->
								
								
										<? if($ses_u_id=='')
										{
										?>
										<div class="col-lg-6 mb-20">
                                            <label> Password   </label>
                                              <input type="password" name="p_word" value=""> 

                                        </div>
										
										<div class="col-lg-6 mb-20">
                                            <label> Confirm Password </label>
                                              <input type="password" name="c_password" value=""> 

                                        </div>
										<?
										}
										?>
										
										
								<!--<div class="col-lg-12 mb-20">
                                            <label>Password<span>*</span></label>
                                            <input type="password" name="p_word" value=""> 

                                        </div>
										
										<div class="col-lg-12 mb-20">
                                            <label> Confirm Password   <span>*</span></label>
                                              <input type="text" name="con_pword" value=""> 

                                        </div>	-->	
													
                                  
                                <div class="contact_textarea col-lg-6 mb-20">
                                    <label>  Briefly describe your health problems.</label>
                                    <textarea placeholder="Describe here.. *" name="message" class="form-control2"></textarea>     
                                </div>  
								
								<div class="default-file-upload col-lg-6 mb-20">
<label>  Upload Previous Medical Report.</label>

<input id="file-upload1" type="file" name="file"/>
</div>


<div class="col-lg-12 mb-20">								
                               <!-- <button type="submit"> Send</button>-->  
								<input style="font-weight: 400;
    height: 42px;
    line-height: 42px;
    padding: 0 30px;
    text-transform: capitalize;
    border: none;
    background: #222222;
    color: #ffffff;
    cursor: pointer;
    -webkit-transition: 0.3s;
    transition: 0.3s;
    border-radius: 4px;
}
   "  type="submit" value="Book Appointment" name="Submit">
   
   <input type="hidden" name="time_id" value="<? echo $appointment_time;?>">
   <input type="hidden" name="date_id" value="<? echo $appointment_date;?>">
    <input type="hidden" name="ses_user_id" value="<? echo $_SESSION["userid"];?>">
   
   
								</div>
								</div>
                                <!--<p class="form-messege"></p>-->
                            </form>
  </div>
            </div>
            <!--product details end-->

         
        </div>
    
    
     <!--newsletter area start-->
    
    <!--newsletter area end-->
    
    <!--footer area start-->
    <?php include("footer.php"); ?>
    <!--footer area end-->
    <!--footer area end-->
   
    <!-- modal area start-->
    <div class="modal fade" id="modal_box" tabindex="-1" role="dialog"  aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered" role="document">
            <div class="modal-content">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">&times;</span>
                </button>
                <div class="modal_body">
                    <div class="container">
                        <div class="row">
                            <div class="col-lg-5 col-md-5 col-sm-12">
                                <div class="modal_tab">  
                                    <div class="tab-content product-details-large">
                                        <div class="tab-pane fade show active" id="tab1" role="tabpanel" >
                                            <div class="modal_tab_img">
                                                <a href="#"><img src="assets/img/product/productbig1.jpg" alt=""></a>    
                                            </div>
                                        </div>
                                        <div class="tab-pane fade" id="tab2" role="tabpanel">
                                            <div class="modal_tab_img">
                                                <a href="#"><img src="assets/img/product/productbig2.jpg" alt=""></a>    
                                            </div>
                                        </div>
                                        <div class="tab-pane fade" id="tab3" role="tabpanel">
                                            <div class="modal_tab_img">
                                                <a href="#"><img src="assets/img/product/productbig3.jpg" alt=""></a>    
                                            </div>
                                        </div>
                                        <div class="tab-pane fade" id="tab4" role="tabpanel">
                                            <div class="modal_tab_img">
                                                <a href="#"><img src="assets/img/product/productbig4.jpg" alt=""></a>    
                                            </div>
                                        </div>
                                    </div>
                                    <div class="modal_tab_button">    
                                        <ul class="nav product_navactive owl-carousel" role="tablist">
                                            <li >
                                                <a class="nav-link active" data-toggle="tab" href="#tab1" role="tab" aria-controls="tab1" aria-selected="false"><img src="assets/img/product/product2.jpg" alt=""></a>
                                            </li>
                                            <li>
                                                 <a class="nav-link" data-toggle="tab" href="#tab2" role="tab" aria-controls="tab2" aria-selected="false"><img src="assets/img/product/product6.jpg" alt=""></a>
                                            </li>
                                            <li>
                                               <a class="nav-link button_three" data-toggle="tab" href="#tab3" role="tab" aria-controls="tab3" aria-selected="false"><img src="assets/img/product/product9.jpg" alt=""></a>
                                            </li>
                                            <li>
                                               <a class="nav-link" data-toggle="tab" href="#tab4" role="tab" aria-controls="tab4" aria-selected="false"><img src="assets/img/product/product3.jpg" alt=""></a>
                                            </li>

                                        </ul>
                                    </div>    
                                </div>  
                            </div> 
                            <div class="col-lg-7 col-md-7 col-sm-12">
                                <div class="modal_right">
                                    <div class="modal_title mb-10">
                                        <h2>Sit voluptatem rhoncus sem lectus</h2> 
                                    </div>
                                    <div class="modal_price mb-10">
                                        <span class="new_price">$64.99</span>    
                                        <span class="old_price" >$78.99</span>    
                                    </div>
                                    <div class="modal_description mb-15">
                                        <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Mollitia iste laborum ad impedit pariatur esse optio tempora sint ullam autem deleniti nam in quos qui nemo ipsum numquam, reiciendis maiores quidem aperiam, rerum vel recusandae </p>    
                                    </div> 
                                    <div class="variants_selects">
                                        <div class="variants_size">
                                           <h2>size</h2>
                                           <select class="select_option">
                                               <option selected value="1">s</option>
                                               <option value="1">m</option>
                                               <option value="1">l</option>
                                               <option value="1">xl</option>
                                               <option value="1">xxl</option>
                                           </select>
                                        </div>
                                        <div class="variants_color">
                                           <h2>color</h2>
                                           <select class="select_option">
                                               <option selected value="1">purple</option>
                                               <option value="1">violet</option>
                                               <option value="1">black</option>
                                               <option value="1">pink</option>
                                               <option value="1">orange</option>
                                           </select>
                                        </div>
                                        <div class="modal_add_to_cart">
                                            <form action="#">
                                                <input min="1" max="100" step="2" value="1" type="number">
                                                <button type="submit">add to cart</button>
                                            </form>
                                        </div>   
                                    </div>
                                    <div class="modal_social">
                                        <h2>Share this product</h2>
                                        <ul>
                                            <li class="facebook"><a href="#"><i class="fa fa-facebook"></i></a></li>
                                            <li class="twitter"><a href="#"><i class="fa fa-twitter"></i></a></li>
                                            <li class="pinterest"><a href="#"><i class="fa fa-pinterest"></i></a></li>
                                            <li class="google-plus"><a href="#"><i class="fa fa-google-plus"></i></a></li>
                                            <li class="linkedin"><a href="#"><i class="fa fa-linkedin"></i></a></li>
                                        </ul>    
                                    </div>      
                                </div>    
                            </div>    
                        </div>     
                    </div>
                </div>    
            </div>
        </div>
    </div>
    <!-- modal area end-->


<!-- JS
============================================ -->

<!-- Plugins JS -->
<!--<script src="assets/js/plugins.js"></script>-->

<!-- Main JS -->
<!--<script src="assets/js/main.js"></script>-->


<script type="text/javascript" charset="utf8" src="https://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.10.2.js"></script>
<script type="text/javascript" charset="utf8" src="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script type="text/javascript" charset="utf8" src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-3-typeahead/4.0.2/bootstrap3-typeahead.min.js"></script>


</body>


</html>