<?
$caller="active";
$caller1="open";
$add_caller="active";

require_once '../template/superadmin/action_connection.php' ;
include("../settings/adminsession.php");
session_start();
?>



<?
	if($_REQUEST['id']!='')
	{
	$update_option =1;
	}	
	
							
								
								
if(isset($_POST['sumbit']))

{

 date_default_timezone_set('Asia/Kolkata');

  $date_ss = date('Y-m-d H:i:s ', time());


 $tablename = "`tbl_doctor_appointment`";
 
 
 

 
$date=trim(addslashes($_REQUEST['date']));

 $date = date("Y-m-d", strtotime($date));
 
 $app_agg=$_REQUEST['app_agg'];
 $app_name=$_REQUEST['app_name'];
 
 $app_age=$_REQUEST['app_age'];
 $app_phone=$_REQUEST['app_phone'];
 
 
 
 
 $dob=date('Y-m-d', strtotime($date));
 $upd_date = $_REQUEST['upd_date'];
 $upd_sta_1 = $_REQUEST['upd_sta'];

 if($upd_date != $dob && $upd_sta_1 !="1"){
    $update_status = "1";
 }else{
    $update_status = "0";
 }
 $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);
  
  
  
 
 

 /*$reason_from_hour=trim(addslashes($_REQUEST['reason_from_hour']));
$reason_from_min=trim(addslashes($_REQUEST['reason_from_min']));
$reason_from_am=trim(addslashes($_REQUEST['reason_from_am']));
$reason_to_hour=trim(addslashes($_REQUEST['reason_to_hour']));
$reason_to_min=trim(addslashes($_REQUEST['reason_to_min']));
$reason_to_am=trim(addslashes($_REQUEST['reason_to_am']));*/

 
 if ($_REQUEST["form_action"] == "Update") {
 $new_id_client=$_REQUEST['new_id_client'];
 
 
   $Query_last_data = "SELECT * from  tbl_appointment where  mem_id='$new_id_client'  ";

	$name_last_data=$DB->query($Query_last_data);
	$row_12_123_maddd=mysql_fetch_array($name_last_data);
	$app_phone=$_REQUEST['app_phone'];
	
	
	 $app_age=$_REQUEST['app_age'];
 $app_name=$_REQUEST['app_name'];
 $location = $_REQUEST['location'];
	
	 $Query_1="UPDATE `tbl_member` SET `phone`='" .$app_phone. "',`skypeid`='" .$app_phone. "',`name`='" .$app_name. "',`dob`='" .$app_age. "', `location_city`= '".$location."' WHERE  `id`='".$_REQUEST['new_id_client']."'";
	   $DB->query($Query_1);
	
	
	
 
 
 
    $Query="UPDATE `tbl_appointment` SET `appointment_date`='" .$dob. "',`hour_date`='" .$appointment_time_1. "',`min_date`='" .$appointment_time_2. "',`am_date`='" .$appointment_time_3 ."', `update_status`='".$update_status."' WHERE  `id`='".$_REQUEST['id']."'";
	   $DB->query($Query);
	   
	  
	  
	  
	  if($_FILES['mast_1']['name']!="")

  {
  
  $size = 190; // the thumbnail height



	$filedir = '../../default/uploads/'; // the directory for the original image

	$thumbdir = '../../default/uploads/';          // the directory for the thumbnail image

	$maxfile = '200000000000';

	$mode = '0666';
	
	echo $userfile_name = $_FILES['mast_1']['name'];
    $mysql_insert_id=$_REQUEST['id'];
    $files = array_filter($_FILES['mast_1']['name']); //Use something similar before processing files.
    // Count the number of uploaded files in array
    $total_count = count($_FILES['mast_1']['name']);
    // Loop through every file
    for( $i=0 ; $i < $total_count ; $i++ ) {
       //The temp file path is obtained
       $tmpFilePath = $_FILES['mast_1']['tmp_name'][$i];
       //A file path needs to be present
       if ($tmpFilePath != ""){
          //Setup our new file path
          $new_file_names.=$mysql_insert_id.$_FILES['mast_1']['name'][$i].'$$$';
          $newFilePath = $filedir.$mysql_insert_id.$_FILES['mast_1']['name'][$i];
          //File is uploaded to temp dir
          if(move_uploaded_file($tmpFilePath, $newFilePath)) {
             //Other code goes here
          }
       }
    }
		$new_iii=$_REQUEST['id'];
		
		

		 $upload_img = "UPDATE  tbl_appointment SET document_name='".$new_file_names."' WHERE id='".$new_iii."'";
	    $DB->query($upload_img);

		// $upload_img = mysql_query("UPDATE  shop_product SET image='".$new_file_name."' WHERE id='".$mysql_insert_id."'");
  
  
  }
  
   if($_FILES['mast_2']['name']!="")

  {
  
  $size = 190; // the thumbnail height



	$filedir = '../../default/uploads/'; // the directory for the original image

	$thumbdir = '../../default/uploads/';          // the directory for the thumbnail image

	$maxfile = '200000000000';

	$mode = '0666';
	
	echo $userfile_name = $_FILES['mast_2']['name'];



	 $userfile_tmp = $_FILES['mast_2']['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();
$mysql_insert_id=$_REQUEST['id'];
		 $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 = str_replace("'", '', $new_file_name);
				   $new_file_name = str_replace(' ','',$new_file_name);
$new_file_name_3730=$new_file_name;

		  $new_file_name=($mysql_insert_id.$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);
		
		$new_iii=$_REQUEST['id'];
		
		

		 $upload_img = "UPDATE  tbl_appointment SET document_name_1='".$new_file_name."' WHERE id='".$new_iii."'";
	    $DB->query($upload_img);

		// $upload_img = mysql_query("UPDATE  shop_product SET image='".$new_file_name."' WHERE id='".$mysql_insert_id."'");
  
  
  }
  
   if($_FILES['mast_3']['name']!="")

  {
  
  $size = 190; // the thumbnail height



	$filedir = '../../default/uploads/'; // the directory for the original image

	$thumbdir = '../../default/uploads/';          // the directory for the thumbnail image

	$maxfile = '200000000000';

	$mode = '0666';
	
	 $userfile_name = $_FILES['mast_3']['name'];



	 $userfile_tmp = $_FILES['mast_3']['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();
$mysql_insert_id=$_REQUEST['id'];
		 $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 = str_replace("'", '', $new_file_name);
				   $new_file_name = str_replace(' ','',$new_file_name);
$new_file_name_3730=$new_file_name;

		  $new_file_name=($mysql_insert_id.$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);
		
		$new_iii=$_REQUEST['id'];
		
		

		 $upload_img = "UPDATE  tbl_appointment SET document_name_2='".$new_file_name."' WHERE id='".$new_iii."'";
	    $DB->query($upload_img);

		// $upload_img = mysql_query("UPDATE  shop_product SET image='".$new_file_name."' WHERE id='".$mysql_insert_id."'");
  
  
  }
  
  
   if($_FILES['mast_4']['name']!="")

  {
  
  $size = 190; // the thumbnail height



	$filedir = '../../default/uploads/'; // the directory for the original image

	$thumbdir = '../../default/uploads/';          // the directory for the thumbnail image

	$maxfile = '200000000000';

	$mode = '0666';
	
	 $userfile_name = $_FILES['mast_4']['name'];



	 $userfile_tmp = $_FILES['mast_4']['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();
$mysql_insert_id=$_REQUEST['id'];
		 $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 = str_replace("'", '', $new_file_name);
				   $new_file_name = str_replace(' ','',$new_file_name);
$new_file_name_3730=$new_file_name;

		  $new_file_name=($mysql_insert_id.$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);
		
		$new_iii=$_REQUEST['id'];
		
		

		 $upload_img = "UPDATE  tbl_appointment SET document_name_3='".$new_file_name."' WHERE id='".$new_iii."'";
	    $DB->query($upload_img);

		// $upload_img = mysql_query("UPDATE  shop_product SET image='".$new_file_name."' WHERE id='".$mysql_insert_id."'");
  
  
  }
  
  
   if($_FILES['mast_5']['name']!="")

  {
  
  $size = 190; // the thumbnail height



	$filedir = '../../default/uploads/'; // the directory for the original image

	$thumbdir = '../../default/uploads/';          // the directory for the thumbnail image

	$maxfile = '200000000000';

	$mode = '0666';
	
	 $userfile_name = $_FILES['mast_5']['name'];



	 $userfile_tmp = $_FILES['mast_5']['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();
$mysql_insert_id=$_REQUEST['id'];
		 $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 = str_replace("'", '', $new_file_name);
				   $new_file_name = str_replace(' ','',$new_file_name);
$new_file_name_3730=$new_file_name;

		  $new_file_name=($mysql_insert_id.$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);
		
		$new_iii=$_REQUEST['id'];
		
		

		 $upload_img = "UPDATE  tbl_appointment SET document_name_4='".$new_file_name."' WHERE id='".$new_iii."'";
	    $DB->query($upload_img);

		// $upload_img = mysql_query("UPDATE  shop_product SET image='".$new_file_name."' WHERE id='".$mysql_insert_id."'");
  
  
  }
  
  
   if($_FILES['mast_6']['name']!="")

  {
  
  $size = 190; // the thumbnail height



	$filedir = '../../default/uploads/'; // the directory for the original image

	$thumbdir = '../../default/uploads/';          // the directory for the thumbnail image

	$maxfile = '200000000000';

	$mode = '0666';
	
	 $userfile_name = $_FILES['mast_6']['name'];



	 $userfile_tmp = $_FILES['mast_6']['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();
$mysql_insert_id=$_REQUEST['id'];
		 $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 = str_replace("'", '', $new_file_name);
				   $new_file_name = str_replace(' ','',$new_file_name);
$new_file_name_3730=$new_file_name;

		  $new_file_name=($mysql_insert_id.$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);
		
		$new_iii=$_REQUEST['id'];
		
		

		 $upload_img = "UPDATE  tbl_appointment SET document_name_5='".$new_file_name."' WHERE id='".$new_iii."'";
	    $DB->query($upload_img);

		// $upload_img = mysql_query("UPDATE  shop_product SET image='".$new_file_name."' WHERE id='".$mysql_insert_id."'");
  
  
  }
  
  
 header("location:appointment_details.php?msg=sucess");
  
	   //$flag="sucess";
 
 }
if ($_REQUEST["form_action"] == "Insert") {





 $Query_last_invoice = "SELECT date from  tbl_doctor_appointment where  (date='".$date."'  )  ";

	$name_last_invoice=$DB->query($Query_last_invoice);

	  $noo=mysql_num_rows($name_last_invoice);
	  
	  if($noo==0)
	  {

    $Query = "insert into $tablename values( NULL,'". $date . "','". $reason_from_hour . "','". $reason_from_min . "','". $reason_from_am . "','". $reason_to_hour . "','" . $reason_to_min . "','" . $reason_to_am."', '".$date_ss	."')";
				$DB->query($Query);
				
				$flag="sucess";
				}
				
				
				 else
	  {

   
				
				$flag="failure";
				}
				
				
				
}


}

 date_default_timezone_set("Asia/Kolkata"); 
$tablename='tbl_job_details';
if ($update_option == 1) {
$id=$_REQUEST['id'];

   $Query_last_data = "SELECT * from  tbl_appointment where  id='$id'  ";

	$name_last_data=$DB->query($Query_last_data);
	$row_12_123=mysql_fetch_array($name_last_data);
	 $new_id=$row_12_123['id'];
	 
	 $new_id_new=$row_12_123['mem_id'];
	 $appointment_date=$row_12_123['appointment_date'];
	 
	 $app_date = date("m/d/Y", strtotime($appointment_date));
     $update_sta = $row_12_123['update_status'];
	 
	 
 $mas_date_sss=date('Y-m-d', strtotime($appointment_date));
 
 
 $from_hour_1_s=$row_12_123['hour_date'];
 
 $from_min_1_s=$row_12_123['min_date'];
 
  $from_min_1_s=$row_12_123['min_date'];
 
 $from_min_1_s = sprintf("%02d", $from_min_1_s);
 
 $from_sta_s=$row_12_123['am_date'];
 
 
 
 
 
 $new_time_ma_sss = ''.$from_hour_1_s.':'.$from_min_1_s.' '.$from_sta_s.'';

$new_time_ma_1_ssss=strtotime($new_time_ma_sss);

  $malath_ch=date('h:i a', $new_time_ma_1_ssss);
	 
	 
	 
	 
	  $Query_last_data_1 = "SELECT * from  tbl_member where  id='$new_id'  ";

	$name_last_data_1=$DB->query($Query_last_data_1);
	$row_12_123_1=mysql_fetch_array($name_last_data_1);
	
	$name_app=$row_12_123_1['name'];
	
	 $phone_app=$row_12_123_1['skypeid'];
     $location_city = $row_12_123_1['location_city'];
	$age_app=$row_12_123_1['dob'];
	
	
	 

}
?>

<?

  $Query_last_data_1 = "SELECT * from  tbl_member where  id='$new_id_new'  ";

	$name_last_data_1=$DB->query($Query_last_data_1);
	$row_12_123_1=mysql_fetch_array($name_last_data_1);
	
	$name_app=$row_12_123_1['name'];
	
	 $phone_app=$row_12_123_1['skypeid'];
	$age_app=$row_12_123_1['dob'];
	$location_city = $row_12_123_1['location_city'];
	
	 $app_phone=$row_12_123_1['phone'];
	 
	 
	  $app_name=$row_12_123_1['name'];
	
	
	?>
      
	  <?php include("header.php"); ?>

	  
	        <div class="row wrapper border-bottom white-bg page-heading">
			
			<? if($flag=="sucess")
{

?>
<div class="alert alert-success">
  <strong>Success!</strong> Data Added Sucessfully.
</div>
<?
}
?>
<? if($flag=="failure")
{

?>
<div class="alert alert-danger">
  <strong>Danger!</strong> Already Exists.
</div>

<?
}
?>
			
                <div class="col-lg-10">
                    <h2>Add Doctor Appointment Time</h2>
                    <ol class="breadcrumb">
                        <li>
                            <a href="index.html">Home</a>
                        </li>
                        <li>
                            <a>Appointment Time</a>
                        </li>
                        <li class="active">
                            <strong>Add Doctor Availablity</strong>
                        </li>
                    </ol>
                </div>
                <div class="col-lg-2">

                </div>
            </div>
        <div class="wrapper wrapper-content animated fadeInRight">
            
            
            <div class="row">
			
			<div class="ibox-content">
			
			<script language="JavaScript" type="text/JavaScript">
function  validation(){
	
	

if(document.register.date.value == "")
{
alert("Please Select the Date");
document.register.date.focus();
return false;
}






}
	//print($row1['file_path']);
	
	
	function getXMLHTTP() 
{ 
	//fuction to return the xml http object
	var xmlhttp=false;	
	try
	{
		xmlhttp=new XMLHttpRequest();
	}
	catch(e)	
	{		
		try
		{			
			xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
		}
		catch(e)
		{
			try
			{
				xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
			}
			catch(e1)
			{
				xmlhttp=false;
			}
		}
	}
		 	
	return xmlhttp;
}



	
function shippingcountry(mystr)
 {
 var totamo=document.getElementById("totamo").value;
 
 
 
 
 var strURL="ajax_date_ap.php?prodid="+totamo;
 //alert(strURL);
	var req=getXMLHTTP();
	if(req)
	{
		req.onreadystatechange = function() 
		{
			if(req.readyState==4) 
			{	
				if (req.status == 200)
				{		//alert(req.responseText);		
					document.getElementById('innershopping_dis').innerHTML=req.responseText;	
					
				}
				else
				{
					alert("There was a Problem while using XMLHTTP:\n" + req.statusText);
				}
			}
		}
	}
	req.open("GET", strURL, true);
			
	req.send(null);

 
}


</script>
			
			
                            <form name="register" method="post" onSubmit="return validation();" class="form-horizontal" enctype="multipart/form-data">
                                
								
								
								
								<div class="form-group" id="data_1"><label class="col-sm-2 control-label">Date</label>
                               
                                <div class="input-group date">
                                    <span class="input-group-addon"><i class="fa fa-calendar"></i></span>
									
									
									<input name="date" type="text" id="totamo" class="form-control" value="<? echo $app_date;?>" autocomplete="off"  onchange="shippingcountry()" >
                                    <input name="upd_date" type="hidden" value="<? echo date('Y-m-d', strtotime($app_date));?>"/>
                                    <input name="upd_sta" type="hidden" value="<? echo $update_sta;?>"/>

									
									
									
                                </div>
                            </div>
							 <div class="hr-line-dashed"></div>	
                                
                                
                               <div id="innershopping_dis">
							   
							   <div class="form-group"><label class="col-sm-2 control-label">Select  Time</label>

                                    <div class="col-sm-10">
								<select class="form-control m-b" name="time_id">
									<option value="<? echo $malath_ch;?>"><? echo $malath_ch;?></option>
								<?
	
	
	  $new_date=date('Y-m-d',$id);
	  
	  $new_date_mal=date('Y-m-d H:i:s',$id);
	  
	   "SELECT *  from tbl_doctor_appointment_office where date='$new_date' and  date  >'$new_cur'   order by id asc ";
	 $Query_job_move_free_job = mysql_query("SELECT *  from tbl_doctor_appointment where date='$mas_date_sss' and  date  >='$new_cur'  order by id asc ");
	  $num_rows_mal = mysql_num_rows($Query_job_move_free_job);
	  if($num_rows_mal>0)
	 {
$si=0;
	while($row_job_move_free_job = mysql_fetch_array($Query_job_move_free_job))
	{
	?>
	<?
	
	$new_id=$row_job_move_free_job['id'];
   
   $from_hour=$row_job_move_free_job['from_hour'];
   
   $from_hour_1 = sprintf("%02d", $from_hour);
   
   

   

   $from_min=$row_job_move_free_job['from_min'];
   
   $from_min_1 = sprintf("%02d", $from_min);
   
   
   $from_sta=$row_job_move_free_job['from_sta'];
   
   
    
   
   
   $to_hour=$row_job_move_free_job['to_hour'];
   $to_hour_1 = sprintf("%02d", $to_hour);
   
   $to_min=$row_job_move_free_job['to_min'];
   
   $to_min_1 = sprintf("%02d", $to_min);
   
   $to_sta=$row_job_move_free_job['to_sta'];
   
  $new_date=$row_job_move_free_job['date'];
  
  $time=strtotime($new_date);
$month=date("F",$time);
$year=date("Y",$time);

   
   $new_date_1=date('D', strtotime($new_date));
$new_date_m=date('M', strtotime($new_date));

$new_date_m_mas=date('d', strtotime($new_date));

 $selectedTime = ''.$from_hour_1.':'.$from_min_1.' '.$from_sta.'';

 $selectedTime2 = ''.$to_hour_1.':'.$to_min_1.' '.$to_sta.'';

$endTime = strtotime("+10 minutes", strtotime($selectedTime));


/*echo $newtime1=date('h:i a', $selectedTime);
$newtime2=date('h:i a', $selectedTime2);*/

 $loginTime = strtotime($selectedTime);

  $checkTime = strtotime($selectedTime2);
 $diff = $checkTime - $loginTime;
 
  $newdif=round($diff/600);



$new_time_ma=$selectedTime = ''.$from_hour_1.':'.$from_min_1.' '.$from_sta.'';

$new_time_ma_1=strtotime($new_time_ma);


	 
	 ?>
	
	
	
	
	
	 
	 <? 
	 
	 	 
	 for($i=0;$i<=$newdif;$i++)
			   {
			   
			    $new_1=date('Y-m-d', strtotime($new_date));
			   $iy_h= date('h', $new_time_ma_1);
			   $iy_m= date('i', $new_time_ma_1);
			   $iy_am= date('a', $new_time_ma_1);
			   ?>
      
	  <?
	  
	 
	    $obj_1   = mysql_query("SELECT id from tbl_appointment where appointment_date='$new_1' and hour_date='$iy_h' and min_date='$iy_m' and am_date='$iy_am' and status='1' ");
                 $num_1 = mysql_num_rows($obj_1);
				 
				  $malath_ch=date('h:i a', $new_time_ma_1_ssss);
				  
				   $malath_ch_1=date('h:i a', $new_time_ma_1);
			   
			   
			   ?>
	  
	  
	  
			   <option class="form-control" value="<? echo date('h:i a', $new_time_ma_1);?>"><? echo date('h:i a', $new_time_ma_1);?></option>
			   
			   
			  
			    
			                            
   
	<? 
	$new_time_ma_1 = strtotime("+10 minutes", $new_time_ma_1);
	} 
	
	?> 
	
  
  
 
  
  <?
  $si=$si+1;
  }
	}
	
	?> 
	
	</select>
  </div>
  </div>
							   
							   
							   </div>
							   
							   
							    <div class="hr-line-dashed"></div>	
                                
								 
								 
	
								
							 
							 <div class="form-group" ><label class="col-sm-2 control-label">Name</label>
                               
                                <div class="input-group date">
                                  <input name="app_name" type="text" class="form-control" value="<? echo $app_name;?>" autocomplete="off" style="width:800%" />
                                </div>
                            </div>
							 <div class="hr-line-dashed"></div>	
                                
								
								
								
								 
                                
								 
								 
	
								
							 
							 <div class="form-group" ><label class="col-sm-2 control-label">Age</label>
                               
                                <div class="input-group date">
                                  <input name="app_age" type="text" class="form-control" value="<? echo $age_app;?>" autocomplete="off" style="width:800%" />
                                </div>
                            </div>
							 <div class="hr-line-dashed"></div>	
                                
							   
							   
							   
							   
							 <div class="hr-line-dashed"></div>	
                                
								 
								 
	
								
							 
							 <div class="form-group" ><label class="col-sm-2 control-label">Phone</label>
                               
                                <div class="input-group date">
                                  <input name="app_phone" type="text" class="form-control" value="<? echo $phone_app;?>" autocomplete="off" style="width:800%" />
                                </div>
                            </div>
                            <div class="hr-line-dashed"></div>	
                                
								 
								 
	
								
							 
                                <div class="form-group" ><label class="col-sm-2 control-label">Location</label>
                                  
                                   <div class="input-group date">
                                     <input name="location" type="text" class="form-control" value="<? echo $location_city;?>" autocomplete="off" style="width:800%" />
                                   </div>
                               </div>
							 <div class="hr-line-dashed"></div>	
                                
								
								
							 
							 
							 
							 <div class="form-group"><label class="col-sm-2 control-label">Upload Reports</label>

                                    <div class="col-sm-10"><input type="file" name="mast_1[]" class="form-control" multiple><br />
									<? echo $row_12_123['document_name'];?>
									</div>
									
									
                                </div>
                                <div class="hr-line-dashed"></div>
								
								<!-- <div class="form-group"><label class="col-sm-2 control-label">Upload Reports</label>

                                    <div class="col-sm-10"><input type="file" name="mast_2" class="form-control"><br />
									<? echo $row_12_123['document_name_1'];?>
									</div>
									
									
                                </div>
                                <div class="hr-line-dashed"></div>
								
								
								 <div class="form-group"><label class="col-sm-2 control-label">Upload Reports</label>

                                    <div class="col-sm-10"><input type="file" name="mast_3" class="form-control"><br />
									<? echo $row_12_123['document_name_2'];?>
									</div>
									
									
                                </div>
                                <div class="hr-line-dashed"></div>
								
								 <div class="form-group"><label class="col-sm-2 control-label">Upload Reports</label>

                                    <div class="col-sm-10"><input type="file" name="mast_4" class="form-control"><br />
									<? echo $row_12_123['document_name_3'];?>
									</div>
									
									
                                </div>
                                <div class="hr-line-dashed"></div>
								
								 <div class="form-group"><label class="col-sm-2 control-label">Upload Reports</label>

                                    <div class="col-sm-10"><input type="file" name="mast_5" class="form-control"><br />
									<? echo $row_12_123['document_name_4'];?>
									</div>
									
									
                                </div>
                                <div class="hr-line-dashed"></div>
								
								 <div class="form-group"><label class="col-sm-2 control-label">Upload Reports</label>

                                    <div class="col-sm-10"><input type="file" name="mast_6" class="form-control"><br />
									<? echo $row_12_123['document_name_5'];?>
									</div>
									
									
                                </div>-->
                                <div class="hr-line-dashed"></div>
                                
                                
                                
                                <div class="form-group">
                                  <div class="col-sm-4 col-sm-offset-2">
                                        <button class="btn btn-white" type="submit">Cancel</button>
                                     <!-- <button class="btn btn-primary" type="submit">Save changes</button>-->
									 <input type="hidden" name="new_id_client" value="<? echo $row_12_123['mem_id'];?>"/>
                                     <?php
									 
                        if ($update_option == 1) {
						echo'<input type="submit" class="btn btn-primary" name="sumbit" id="login"  value="Update" >';
                            echo'<input type="hidden" name="form_action" value="Update"/>';
							
                            echo'<input type="hidden" name="id" value="' . $id . '"/>';
							
                        } else {
						 echo'<input type="hidden" name="form_action" value="Insert"/>';
                            echo'<input type="submit" class="btn btn-primary" name="sumbit" id="login"  value="Submit" >';
                        }
                        ?>
                                  </div>
                                </div>
                            </form>
                        </div>

                
                
                    </div>
        
            
        </div>
        <div class="footer">
            <div class="pull-right">
                10GB of <strong>250GB</strong> Free.
            </div>
            <div>
                <strong>Copyright</strong> dranbuganapathi.com  &copy; 2019-2020
            </div>
        </div>

        </div>
                    </div>

    <!-- Mainly scripts -->
    <script src="js/jquery-2.1.1.js"></script>
    <script src="js/bootstrap.min.js"></script>

    <!-- Custom and plugin javascript -->
    <script src="js/inspinia.js"></script>
    <script src="js/plugins/pace/pace.min.js"></script>
    <script src="js/plugins/slimscroll/jquery.slimscroll.min.js"></script>

    <!-- Chosen -->
    <script src="js/plugins/chosen/chosen.jquery.js"></script>

   <!-- JSKnob -->
   <script src="js/plugins/jsKnob/jquery.knob.js"></script>

   <!-- Input Mask-->
    <script src="js/plugins/jasny/jasny-bootstrap.min.js"></script>

   <!-- Data picker -->
   <script src="js/plugins/datapicker/bootstrap-datepicker.js"></script>

   <!-- NouSlider -->
   <script src="js/plugins/nouslider/jquery.nouislider.min.js"></script>

   <!-- Switchery -->
   <script src="js/plugins/switchery/switchery.js"></script>

    <!-- IonRangeSlider -->
    <script src="js/plugins/ionRangeSlider/ion.rangeSlider.min.js"></script>

    <!-- iCheck -->
    <script src="js/plugins/iCheck/icheck.min.js"></script>

    <!-- MENU -->
    <script src="js/plugins/metisMenu/jquery.metisMenu.js"></script>

    <!-- Color picker -->
    <script src="js/plugins/colorpicker/bootstrap-colorpicker.min.js"></script>

    <!-- Clock picker -->
    <script src="js/plugins/clockpicker/clockpicker.js"></script>

    <!-- Image cropper -->
    <script src="js/plugins/cropper/cropper.min.js"></script>

    <!-- Date range use moment.js same as full calendar plugin -->
    <script src="js/plugins/fullcalendar/moment.min.js"></script>

    <!-- Date range picker -->
    <script src="js/plugins/daterangepicker/daterangepicker.js"></script>

    <script>
        $(document).ready(function(){

            var $image = $(".image-crop > img")
            $($image).cropper({
                aspectRatio: 1.618,
                preview: ".img-preview",
                done: function(data) {
                    // Output the result data for cropping image.
                }
            });

            var $inputImage = $("#inputImage");
            if (window.FileReader) {
                $inputImage.change(function() {
                    var fileReader = new FileReader(),
                            files = this.files,
                            file;

                    if (!files.length) {
                        return;
                    }

                    file = files[0];

                    if (/^image\/\w+$/.test(file.type)) {
                        fileReader.readAsDataURL(file);
                        fileReader.onload = function () {
                            $inputImage.val("");
                            $image.cropper("reset", true).cropper("replace", this.result);
                        };
                    } else {
                        showMessage("Please choose an image file.");
                    }
                });
            } else {
                $inputImage.addClass("hide");
            }

            $("#download").click(function() {
                window.open($image.cropper("getDataURL"));
            });

            $("#zoomIn").click(function() {
                $image.cropper("zoom", 0.1);
            });

            $("#zoomOut").click(function() {
                $image.cropper("zoom", -0.1);
            });

            $("#rotateLeft").click(function() {
                $image.cropper("rotate", 45);
            });

            $("#rotateRight").click(function() {
                $image.cropper("rotate", -45);
            });

            $("#setDrag").click(function() {
                $image.cropper("setDragMode", "crop");
            });

            $('#data_1 .input-group.date').datepicker({
                todayBtn: "linked",
                keyboardNavigation: false,
                forceParse: false,
                calendarWeeks: true,
                autoclose: true
            });

            $('#data_2 .input-group.date').datepicker({
                startView: 1,
                todayBtn: "linked",
                keyboardNavigation: false,
                forceParse: false,
                autoclose: true,
                format: "dd/mm/yyyy"
            });

            $('#data_3 .input-group.date').datepicker({
                startView: 2,
                todayBtn: "linked",
                keyboardNavigation: false,
                forceParse: false,
                autoclose: true
            });

            $('#data_4 .input-group.date').datepicker({
                minViewMode: 1,
                keyboardNavigation: false,
                forceParse: false,
                autoclose: true,
                todayHighlight: true
            });

            $('#data_5 .input-daterange').datepicker({
                keyboardNavigation: false,
                forceParse: false,
                autoclose: true
            });

            var elem = document.querySelector('.js-switch');
            var switchery = new Switchery(elem, { color: '#1AB394' });

            var elem_2 = document.querySelector('.js-switch_2');
            var switchery_2 = new Switchery(elem_2, { color: '#ED5565' });

            var elem_3 = document.querySelector('.js-switch_3');
            var switchery_3 = new Switchery(elem_3, { color: '#1AB394' });

            $('.i-checks').iCheck({
                checkboxClass: 'icheckbox_square-green',
                radioClass: 'iradio_square-green'
            });

            $('.demo1').colorpicker();

            var divStyle = $('.back-change')[0].style;
            $('#demo_apidemo').colorpicker({
                color: divStyle.backgroundColor
            }).on('changeColor', function(ev) {
                        divStyle.backgroundColor = ev.color.toHex();
                    });

            $('.clockpicker').clockpicker();

            $('input[name="daterange"]').daterangepicker();

            $('#reportrange span').html(moment().subtract(29, 'days').format('MMMM D, YYYY') + ' - ' + moment().format('MMMM D, YYYY'));

            $('#reportrange').daterangepicker({
                format: 'MM-DD-YYYY',
                startDate: moment().subtract(29, 'days'),
                endDate: moment(),
                minDate: '01-01-2012',
                maxDate: '12-31-2015',
                dateLimit: { days: 60 },
                showDropdowns: true,
                showWeekNumbers: true,
                timePicker: false,
                timePickerIncrement: 1,
                timePicker12Hour: true,
                ranges: {
                    'Today': [moment(), moment()],
                    'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
                    'Last 7 Days': [moment().subtract(6, 'days'), moment()],
                    'Last 30 Days': [moment().subtract(29, 'days'), moment()],
                    'This Month': [moment().startOf('month'), moment().endOf('month')],
                    'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
                },
                opens: 'right',
                drops: 'down',
                buttonClasses: ['btn', 'btn-sm'],
                applyClass: 'btn-primary',
                cancelClass: 'btn-default',
                separator: ' to ',
                locale: {
                    applyLabel: 'Submit',
                    cancelLabel: 'Cancel',
                    fromLabel: 'From',
                    toLabel: 'To',
                    customRangeLabel: 'Custom',
                    daysOfWeek: ['Su', 'Mo', 'Tu', 'We', 'Th', 'Fr','Sa'],
                    monthNames: ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'],
                    firstDay: 1
                }
            }, function(start, end, label) {
                console.log(start.toISOString(), end.toISOString(), label);
                $('#reportrange span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
            });


        });
        var config = {
                '.chosen-select'           : {},
                '.chosen-select-deselect'  : {allow_single_deselect:true},
                '.chosen-select-no-single' : {disable_search_threshold:10},
                '.chosen-select-no-results': {no_results_text:'Oops, nothing found!'},
                '.chosen-select-width'     : {width:"95%"}
                }
            for (var selector in config) {
                $(selector).chosen(config[selector]);
            }

        $("#ionrange_1").ionRangeSlider({
            min: 0,
            max: 5000,
            type: 'double',
            prefix: "$",
            maxPostfix: "+",
            prettify: false,
            hasGrid: true
        });

        $("#ionrange_2").ionRangeSlider({
            min: 0,
            max: 10,
            type: 'single',
            step: 0.1,
            postfix: " carats",
            prettify: false,
            hasGrid: true
        });

        $("#ionrange_3").ionRangeSlider({
            min: -50,
            max: 50,
            from: 0,
            postfix: "°",
            prettify: false,
            hasGrid: true
        });

        $("#ionrange_4").ionRangeSlider({
            values: [
                "January", "February", "March",
                "April", "May", "June",
                "July", "August", "September",
                "October", "November", "December"
            ],
            type: 'single',
            hasGrid: true
        });

        $("#ionrange_5").ionRangeSlider({
            min: 10000,
            max: 100000,
            step: 100,
            postfix: " km",
            from: 55000,
            hideMinMax: true,
            hideFromTo: false
        });

        $(".dial").knob();

        $("#basic_slider").noUiSlider({
            start: 40,
            behaviour: 'tap',
            connect: 'upper',
            range: {
                'min':  20,
                'max':  80
            }
        });

        $("#range_slider").noUiSlider({
            start: [ 40, 60 ],

            behaviour: 'drag',
            connect: true,
            range: {
                'min':  20,
                'max':  80
            }
        });

        $("#drag-fixed").noUiSlider({
            start: [ 40, 60 ],
            behaviour: 'drag-fixed',
            connect: true,
            range: {
                'min':  20,
                'max':  80
            }
        });


    </script>

</body>

</html>