<?php 
ob_start();
include("header1.php"); ?>

<?
$_SESSION["userid"];
 session_start();
 
  $ses_u_id=$_SESSION["mobile"];
   //$browsessionid=session_id();
  
   //$browsessionid;
 

 /*if($_SESSION["mobile"]=="")
 {
 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['phone']));
 
$dob1=trim(addslashes($_POST['dob']));

  



 //$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);




$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!='')
{


 
}




//$sessionid_free=$cust_id;
 $ses_u_id=$_SESSION["mobile"];
   
   //$objqrynewsubee    = "SELECT * FROM shop_user where phone='$ses_u_id'";
   
   date_default_timezone_set('Asia/Kolkata');
 $date = date('Y-m-d H:i:s ', time());

 $login = "SELECT * from shop_user WHERE  phone= '$ses_u_id' ";

$resqry = mysql_query($login) or die("ERROR:".mysql_error());



     $numrows = mysql_num_rows($resqry);
	
	if($numrows==0)
	{
	

$Insert_Qry_12    = "INSERT INTO shop_user (`name`,`gender`,`phone`,`email`,`dob`,`password`,`language`,`skypeid`,`state`,`city`,`country`,`address`,`status`,`postcode`,`date`) VALUES ('$name','$id_gender','$phone','$email','$dob1','123456','$id_lang','$phone','$state','$city','$country','$address','1','$pincode','$date')";

$Insert_Run_12    = mysql_query($Insert_Qry_12) or die("Insert query error".mysql_error());


}



$login_devi = "SELECT * from shop_user WHERE  phone= '$ses_u_id' ";

$resqry_devi = mysql_query($login_devi) or die("ERROR:".mysql_error());

$Fetitem_divi      = mysql_fetch_array($resqry_devi);

$ses_user_id=$Fetitem_divi["user_id"];


$country;
  $country=trim(addslashes($_POST['country']));
 
 
if($country=="India")
{
$amo=399;
}
else
{

$country;

if($country=="Malaysia")
{
$amo=899;
}
else
{
$amo=1999;
}



}
 $amo;
 



$upload_img = mysql_query("UPDATE  tbl_appointment SET session_id='' WHERE session_id='".$browsessionid."'");
		

$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','$amo')";

$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");
 
  




}
?>

<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;
}


$('#con_for').keypress(function(e) {
   var foo = $(this).val()
   if (foo.length >= 20) { //specify text limit
     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;
    }
	
	


	
	if(document.register.dob.value == "")
	{
       alert("Please Enter The Age");
	   document.register.dob.focus();
        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.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;
}

}
	
				 </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 align="center" style="color:#FF0000"><? echo $new_ap_date;?>, <? echo $new_date_m;?> <? echo $new_date_m_da;?> ( <? echo $appointment_time;?> )</h4>

				 
				 </div>
				
				 <div class="col-lg-8 col-md-offset-2  ">
				 
				 <? 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"];
   
    $ses_u_id=$_SESSION["mobile"];
   
   $objqrynewsubee    = "SELECT * FROM shop_user where phone='$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="contact_message form">
	
	
	<div class="row">
                                <div class="col-lg-6 ">  
                                   <label> Patient Name <?  $_SESSION["mobile"];?><?  $_SESSION["userid"];?></label>
                                    <input name="name"  value="<? if($ses_u_id!='') { echo $Fetchnewww['name']; } ?>" type="text"> 
                                </div> 
								
								<div class="col-lg-6 ">
                                            <label> Email Address (Optional)   </label>
                                              <input type="text" name="email" value="<? if($ses_u_id!='') { echo $Fetchnewww['email']; } ?>"> 

            </div>
			
			
			
								
								<div class="col-lg-3 ">
                                            <label>Whatsapp Number</label>
                                            <input  name="phone" value="<? echo $_SESSION["mobile"];?>" placeholder="ENTER INDIAN MOBILE NUMBER ONLY"  maxlength="10" type="text" onKeyPress="return isNumber(event)"> 

            </div>   
										
										
										<div class="col-lg-3 ">
                                            <label>Alternate Mobile Number (Optional)</label>
                                            <input  name="phone_p" value="" placeholder=""  maxlength="10" type="text" onKeyPress="return isNumber(event)"> 

                                        </div>   
										
										<div class="col-lg-3 ">
                                            <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 "> 
								   <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="contact_textarea col-lg-4 ">
                                    <label>  Consulting for ( e.g. diabetic ).</label>
                                    <input type="text" name="con_for" id="con_for"  maxlength="20" value=""  >   
                                </div>
										
										
 <div class="contact_textarea col-lg-4 ">
                                    <label>  Briefly describe your health problems.</label>
                                    <textarea placeholder="" name="message" class="form-control2"></textarea>     
            </div>  										
										
										
										
										
										
										
										
										
										
										<div class="col-lg-4 ">
                                            <label> Address  </label>
                                             <?php /*?> <input type="text" name="address" value="<? if($ses_u_id!='') { echo $Fetchnewww['address']; } ?>"> <?php */?>
											  
											  <textarea name="address"><? if($ses_u_id!='') { echo $Fetchnewww['address']; } ?></textarea>

                                        </div>
										
										<div class="col-lg-4 ">
                                            <label> City  </label>
                                              <input type="text" name="city" value="<? if($ses_u_id!='') { echo $Fetchnewww['city']; } ?>"> 

                                        </div>
										
										<div class="col-lg-4 ">
                                            <label> State  <?  $Fetchnewww['state'];?></label>
											
											<?
										$country123333333=$_SESSION["country"];
										
										?>
										
										<? if($country123333333!="India")
										{
										?>
											
											
                                              <input type="text" name="state" value="<? if($ses_u_id!='') { echo $Fetchnewww['state']; } ?>"> 
											  
											  <?
											  }
											  else
											  {
											  ?>
											  
											  
											  <select   name="state" id="state"  >
									<option value="">Select</option>
                                        <?


  $Query_sp_in = mysql_query("SELECT * from tbl_state     ");

                                              

											    $num_max_job_sp_in=mysql_num_rows($Query_sp_in);

												

											    while ($name_j_sp_in = mysql_fetch_array($Query_sp_in)) {
												
												$cat_id=$name_j_sp_in['id'];
												
												
												$name_sta=$name_j_sp_in['state'];
												
												$state=$Fetchnewww['state'];
												
												if($state=="")
												{
 
 
 $state=$Fetchnewww['state'];
 
 }
 
 {
 
 $state=$Fetchnewww['state'];
 
 }
												
												?>


 
									
 <option  <? if($state==$name_j_sp_in["state"]){ ?>  selected="selected" <? } ?>   value="<? echo $name_j_sp_in["state"];?>"><? echo $name_j_sp_in["state"];?></option>
   
   <?
                                        
									
									
								}
								
							
									
									?>
                                    </select>
									
									<?
									}
									?>

                                        </div>
										
										<?
										$country123333333=$_SESSION["country"];
										
										?>
										
										 <?  $country=$Fetchnewww['country'];?>
										
										<input type="hidden" name="country" id="country" value="<? echo $country123333333;?>" />
										
										<!--<div class="col-lg-4 "> 
										<?
										$country123333333=$_SESSION["country"];
										
										?>
										
										 <?  $country=$Fetchnewww['country'];?>
										
										<input type="hidden" name="country" id="country" value="<? echo $country123333333;?>" />
										
										
										
										<label> Select Country   <?  $country=$Fetchnewww['country'];?></label>
										<select class="niceselect_option" name="country" id="country"> 
											
                                                <option value="<? echo $country123333333;?>" ><? echo $country123333333;?></option>      
                                                
                                                

                                          </select>
											
											
											
										</div>-->
										
										
										<div class="col-lg-4 ">
                                            <label><div class="pull-left"> Pin Code </div>  
											</label>
                                              <input type="text" maxlength="6" type="text" onKeyPress="return isNumber(event)" name="pincode" value="<? if($ses_u_id!='') { echo $Fetchnewww['postcode']; } ?>"> 

                                        </div>
										
										<!--<div class="col-lg-6 ">
                                            <label><div class="pull-left"> Whats up No </div> &nbsp;&nbsp; 
											<div class="pull-right" style=" color:#FF0000"  align="left"></div></label>
                                              <input type="text" name="skypeid" value="<? if($ses_u_id!='') { echo $Fetchnewww['phone']; } ?>"> 

                                        </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 ">
										
                                   <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>-->
								
								
								
										
										
										
										
										
										
										
										
								
								<!--<div class="col-lg-12 ">
                                            <label>Password<span>*</span></label>
                                            <input type="password" name="p_word" value=""> 

                                        </div>
										
										<div class="col-lg-12 ">
                                            <label> Confirm Password   <span>*</span></label>
                                              <input type="text" name="con_pword" value=""> 

                                        </div>	-->	
													
                                  
                               
								
								<div class="default-file-upload col-lg-12 " >
<label>  Upload Latest Medical Reports Only (Optional)</label>

<!--<input id="file-upload1" type="file" name="file"/>-->

<div class="field_wrapper">

									<link href="css_upload/jquery.filer.css" rel="stylesheet">
	<link href="css_upload/themes/jquery.filer-dragdropbox-theme.css" rel="stylesheet">

	<!-- Jvascript -->
	<script src="js_upload4/jquery-3.1.0.min.js" crossorigin="anonymous"></script>
	<script src="js_upload4/jquery.filer.min.js" type="text/javascript"></script>
	<script src="js_upload4/custom.js" type="text/javascript"></script>

    <input type="file" name="file[]" id="filer_input2" multiple/> 
					

											 <!--<input  type="file" name="file[]" id="file"  onchange="readURL1(this);" >



	



                    <a href="javascript:void(0);" class="add_button" title="Add field"><img src="img/add-icon.png"/></a>



 

	

                    <span class="add-on"><i class="icon-remove"></i></span>





					<span class="add-on"><i class="icon-th"></i></span>-->



                    </div>



</div>



	
								

 						
								
								
								
								
								
								
								
		  </div>
								
								
								
		</div>
								
								
								
								<?php
if(strstr(strtolower($_SERVER['HTTP_USER_AGENT']), 'mobile') || strstr(strtolower($_SERVER['HTTP_USER_AGENT']), 'android')) {

?>

 

								
								
								<div align="center" >								
                               <!-- <button type="submit"> Send</button>-->
                               <input style="font-weight: 400;
    height: 42px;
    line-height: 42px;
    padding: 0 30px;
    text-transform: capitalize;
    border: none;
    background: #000080;
    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>
								<br />
								
								
		<?
		}
		else
		{
		?> 



								
<div align="center" >								
                               <!-- <button type="submit"> Send</button>-->  
								<input style="font-weight: 400;
    height: 42px;
    line-height: 42px;
    padding: 0 30px;
    text-transform: capitalize;
    border: none;
    background: #000080;
    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>
								
								<br />
								
	<?
	}
	?>	
								
								
                                <!--<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-->
    
    <!-- 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://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>