<?
   date_default_timezone_set('Asia/Kolkata');
$caller="active";
$caller1="open";
$oc_appointment_detil="active";

require_once '../template/superadmin/action_connection.php' ;
include("../settings/adminsession.php");
include "../../include/conf.php";
session_start();
$today = date('Y-m-d');


$get_tod_direct = mysqli_query($conn, "SELECT * from tbl_appointment_office where status in (1,2,3,4) and DATE(appointment_date) = '$today'");
$get_tod_direct_count = mysqli_num_rows($get_tod_direct);


$get_tod_direct = mysqli_query($conn, "SELECT * from tbl_appointment_office where status='2' and DATE(appointment_date) = '$today'");
$get_tod_direct_completed_count = mysqli_num_rows($get_tod_direct);

$get_pen =   mysqli_query($conn, "SELECT * from tbl_appointment_office where status='1' and DATE(appointment_date) = '$today'");

$get_pending = mysqli_num_rows($get_pen);

$get_can =   mysqli_query($conn, "SELECT * from tbl_appointment_office where status in (3,4) and DATE(appointment_date) = '$today'");

$get_cancelled = mysqli_num_rows($get_can);

$dates = date('Y-m-d');
$get_on_con = mysqli_query($conn, "SELECT * from tbl_appointment where status = 1 and DATE(appointment_date) < '$dates'");
$get_on_con_count = mysqli_num_rows($get_on_con);

$get_oc =   mysqli_query($conn, "SELECT * from tbl_appointment where status='1' and DATE(appointment_date) = '$today'");
$get_oc_pending = mysqli_num_rows($get_oc);
?>
<?
if(isset($_POST['sumbit1_para'])){//to run PHP script on submit
 $v_id_order=$_REQUEST["v_id_order"];
 
   $cour=$_REQUEST["courier_status_".$v_id_order.""];
	

   
   
   $date_ss = date('Y-m-d H:i:s ', time());
   $Query="UPDATE `tbl_appointment_office` SET `status`='$cour' WHERE  `id`='$v_id_order'";
	   $DB->query($Query);
	    //$ids=$_REQUEST['ids'];
	  
	header("location:appointment_details.php");
	  

 //$cour="courier_status".$v_id_order."";

 //header("location:view_order.php?ids=15");
}

?>

<?
if(isset($_POST['sumbit_note_para'])){//to run PHP script on submit
 $v_id_order=$_REQUEST["v_id_order"];
 
   $cour=$_REQUEST["c_note_".$v_id_order.""];
   date_default_timezone_set('Asia/Kolkata');
   
   $date_ss = date('Y-m-d H:i:s ', time());
   
   
   $Query="UPDATE tbl_appointment SET status='". $cour."',comp_time_da='". $date_ss."' WHERE `id`='".$v_id_order."'";

	   $DB->query($Query);
   
   
   $date_ss = date('Y-m-d H:i:s ', time());
   
	  
	    //$ids=$_REQUEST['ids'];
	  
	  header("location:appointment_details.php");
	  

 //$cour="courier_status".$v_id_order."";

 //header("location:view_order.php?ids=15");
}

?>
<?

if($_REQUEST['id']!='')
{
$id=$_REQUEST['id'];
$datemal = date_default_timezone_set('Asia/Kolkata');
    $dt2=date('Y-m-d H:i:s');

 $Query="UPDATE tbl_appointment SET status='4',cancel_time='$dt2' WHERE `id`='".$_REQUEST['id']."'";

	   $DB->query($Query);
	   
	   
	    $Query_m = "SELECT * from tbl_appointment where id='".$_REQUEST['id']."'";
                                               $namesss_m=$DB->query($Query_m);
											   
						$rowsss_m = mysql_fetch_array($namesss_m);
						$email_id=$rowsss_m['email_id'];
						
						
						$mailcopy=$rowsss_m['email_id'];
	
	$date=$rowsss['date'];
												
												 $me_id=$rowsss_m['mem_id'];
												 $order_id=$rowsss_m['id'];
												 $ap_date= $rowsss_m['appointment_date'];
												 
												 $ap_hour= sprintf("%02d",$rowsss_m['hour_date']);
												 $ap_min=  sprintf("%02d",$rowsss_m['min_date']); 
												  $ap_sec=  $rowsss_m['am_date'];
												  
									
										 	     $Query_m_a = "SELECT * from `tbl_member` where id='$me_id'   ";
												  $namesss_m_a=$DB->query($Query_m_a);
                                              
											     $no_m_a=mysql_num_rows($namesss_m_a);
											   $row_m_a = mysql_fetch_array($namesss_m_a);
											   $firstname= $row_m_a['name'];
											$skypeid=$row_m_a['skypeid'];
											
											
											  
											     $mobss= $row_m_a['phone'];  	   
					sprintf("%02d", $to_hour);	
					
					 /*  -----------------------------------*/
	
					 $message = "Hi ".$firstname." your appointment with Dr. G.ANBUGANAPATHI on ".$ap_date." ".$ap_hour.":".$ap_min.":".$ap_sec." is Cancelled.Sorry For the inconvenience."; //enter Your Message 
					 $message = urlencode($message);
					 $curl = curl_init();
				 
				 curl_setopt_array($curl, array(
				   CURLOPT_URL => 'http://sms.dial4sms.com/api/v2/SendSMS?SenderId=DRANBU&Message='.$message.'&MobileNumbers='.$mobss.'&ApiKey=eYfIWFmiAMhbL6JDTfOb3kzGzQr+eimy6prshuD8qLo=&ClientId=b45d4e3d-cb26-4856-8cbf-93a02a7b9eeb',
				   CURLOPT_RETURNTRANSFER => true,
				   CURLOPT_ENCODING => '',
				   CURLOPT_MAXREDIRS => 10,
				   CURLOPT_TIMEOUT => 0,
				   CURLOPT_FOLLOWLOCATION => true,
				   CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
				   CURLOPT_CUSTOMREQUEST => 'GET',
				 ));
				 
				 $response = curl_exec($curl);
				 
				 curl_close($curl);
		
		//$mobilenumbers1='$res_owner_mobile';	
						
						
						
						 $Msg1 = '
 <style type="text/css">
	
		
	
		.white_link{
	
		font-family:Verdana;
	
		font-size:12px;
	
		color:#666666;
	
		line-height:18px;
	
		font-weight:normal;
	
		text-decoration:none;
	
		}
		.copy_txt{
	
		font-family:Arial, Helvetica, sans-serif;
	
		font-size:11px;
	
		color:#666666;
	
		text-decoration:none;
	
		}
	
		</style>
		<body>
  <table width="65%" border="1" align="center" cellpadding="15" cellspacing="0" class="border_blak" bgcolor="">
	
		<tr>
	
		<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFF">
	
		<tr>
	
		<td style="background-color:#6AAC00;"  align="center" valign="middle" bgcolor="#FFF">Dr. G.ANBUGANAPATHI</td>
	
		</tr>
	
		<tr>
	
		<td height="200">
		<table width="600">
		 <tr>
			<td height="8"></td>
			<td height="8" colspan="2"></td>
		</tr>
		
		<tr>
	
		
	
		<td align="center" valign="middle">Cancelled Appointment Details</td>
		</tr>
		<tr>
	
		<td colspan="3">Hi '.$firstname.' your appointment with Dr. G.ANBUGANAPATHI on <strong>'.$ap_date.' '.$ap_hour.':'.$ap_min.':'.$ap_sec.'(Indian Standard Time (IST))</strong> is Cancelled.Sorry For the inconvenience. <br />
		<span style="color:#FF0000">*  Consultation fees will be refunded with in 3-4 bank working days.</soan>
		   </td>
		</tr>
		 
		
		
		
        <tr>
		<td class="white_link" colspan="2">Thanks & Regards<br /><strong>Dr. G.ANBUGANAPATHI
		
</strong></td>
		</tr>
	</table>	
		
		</td>
	
		</tr>
	
		<tr>
	
		<td height="3" align="center" bgcolor="#454545"></td>
	
		</tr>
	
		<tr>
	
		<td height="30" align="center"><span class="copy_txt"> Copyright &copy; 2020 - dranbuganapathi.com, All Rights Reserved.</span></td>
	
		</tr>
	
		</table></td>
	
		</tr>
	
		</table>
		</body>';


$job_name14357="Appointment Cancellation in Dr. G.ANBUGANAPATHI";



$Subjectnew123    = "$job_name14357-$order_id";
$Subject1="Appointment Cancellation in Dr. G.ANBUGANAPATHI";
//echo $mailformat;

//$mailheaders = "Content-type: text/html; charset=iso-8859-1\r\n";

$useremail="drganbuganapathi@gmail.com";
$headers1    = "From: dranbuganapathi.com\r\n"."Content-Type: text/html; charset=iso-8859-1\r\n";

  $Msg1;
//@mail($useremail,$Subjectnew123,$Msg1,$headers1);
@mail($mailcopy,$Subject1,$Msg1,$headers1);
//$Delete_Question	=	"DELETE FROM tbl_appointment WHERE `id`='$id'";

//$Result_Question	=	mysql_query($Delete_Question);

 ////$Query_delete = "DELETE from   tbl_appointment where id='$id'";

	//$name_delete=$DB->query($Query_delete);

header("location:appointment_details.php?msg=sucess");
}
?>

 <?php include("header.php"); 
if($_GET['msg1']=='success'){
	?>
	  <script src="https://cdnjs.cloudflare.com/ajax/libs/limonte-sweetalert2/11.6.15/sweetalert2.min.js"></script>
	<script>
Swal.fire({
icon: 'success',
title: '',
text: 'File Uploaded Successfully',

}).then((result) => {
  if (result.isConfirmed) {
    $(location).prop('href', 'appointment_details.php')
  }
})
	
</script>
	<?
}elseif($_GET['msg1']=='failure'){
	?>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/limonte-sweetalert2/11.6.15/sweetalert2.min.js"></script>
	<script>
Swal.fire({
icon: 'error',
title: '',
text: 'There is some error in uploading the file, contact admin',

}).then((result) => {
  if (result.isConfirmed) {
    $(location).prop('href', 'appointment_details.php')
  }
})
	
</script>
	
	<?
	
}

?>
        <?
         if($_GET['msg2']=='success'){
	?>
	  <script src="https://cdnjs.cloudflare.com/ajax/libs/limonte-sweetalert2/11.6.15/sweetalert2.min.js"></script>
	<script>
Swal.fire({
icon: 'success',
title: '',
text: 'File Deleted Successfully',

}).then((result) => {
  if (result.isConfirmed) {
    $(location).prop('href', 'appointment_details.php')
  }
})
	
</script>
	<?
}elseif($_GET['msg2']=='failure'){
	?>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/limonte-sweetalert2/11.6.15/sweetalert2.min.js"></script>
	<script>
Swal.fire({
icon: 'error',
title: '',
text: 'There is some error in deleting the file, contact admin',

}).then((result) => {
  if (result.isConfirmed) {
    $(location).prop('href', 'appointment_details.php')
  }
})
	
</script>
	
	<?
	
}

?>
          
           
            <div class="row wrapper border-bottom white-bg page-heading">
                <div class="col-lg-10">
                    <h2>Doctor Availability </h2>
                    <ol class="breadcrumb">
                       <li>
                            <a>Doctor Availability</a>
                        </li> 
                        
                        <li class="active">
                            <strong>Appointment Details</strong>
                        </li>
                    </ol>
                </div>
                <div class="col-lg-2">

                </div>
				
				
            </div>
			<? if($_REQUEST['msg']=="sucess")
{

?>
<div class="alert alert-success">
  <strong>Success!</strong> Data Deleted Sucessfully.
</div>
<?
}
?>
        <div class="wrapper wrapper-content animated fadeInRight">
            
            <div class="row">
            <div class="col-lg-12">
            <div class="ibox float-e-margins">
            <!--<div class="ibox-title">
                <h5>Editable Table in- combination with jEditable</h5>
                <div class="ibox-tools">
                    <a class="collapse-link">
                        <i class="fa fa-chevron-up"></i>
                    </a>
                    <a class="dropdown-toggle" data-toggle="dropdown" href="#">
                        <i class="fa fa-wrench"></i>
                    </a>
                    <ul class="dropdown-menu dropdown-user">
                        <li><a href="#">Config option 1</a>
                        </li>
                        <li><a href="#">Config option 2</a>
                        </li>
                    </ul>
                    <a class="close-link">
                        <i class="fa fa-times"></i>
                    </a>
                </div>
            </div>-->
            <div class="ibox-content">
            <!--<div class="">
            <a  href="add_available_time.php" class="btn btn-primary ">Add a new row</a>
			
			

            </div>-->
          <form role="form" class="form-inline">
                        <?php
					 if(strstr(strtolower($_SERVER['HTTP_USER_AGENT']), 'mobile') || strstr(strtolower($_SERVER['HTTP_USER_AGENT']), 'android') || strstr(strtolower($_SERVER['HTTP_USER_AGENT']), 'iphone')) {
					 ?>
                                <div class="form-group">
                                    <span class = "label label-primary" style="font-size: 150%">TODAY PATIENT'S: <?= $get_tod_direct_count;?> / CANCELLED: <?= $get_cancelled;?> / COMPLETED: <?= $get_tod_direct_completed_count;?> / PENDING: <?= $get_pending;?>  </span>
                                    &nbsp;   &nbsp; &nbsp;   &nbsp; &nbsp;   &nbsp; &nbsp;   &nbsp; &nbsp;   &nbsp;
                                                                        &nbsp;   &nbsp; &nbsp;   &nbsp; &nbsp;   &nbsp; &nbsp;   &nbsp; &nbsp;   &nbsp;

                                 
                                     
                                     <span class = "label label-success" style="font-size: 150%;">OC PENDING (CURRENT : <?= $get_oc_pending;?> + PREVIOUS <?= $get_on_con_count;?> = TOTAL <?= $get_oc_pending + $get_on_con_count; ?>  ) </span>
              </div>
              <?php
					 }else{
						 ?>
						 
					                        <div class="form-group">
                                    <span class = "label label-primary" style="font-size: 150%">TODAY PATIENT'S: <?= $get_tod_direct_count;?> / CANCELLED: <?= $get_cancelled;?> / COMPLETED: <?= $get_tod_direct_completed_count;?> / PENDING: <?= $get_pending;?>  </span>
                                    <br/>
                                      <br/>

                                 
                                     
                                     <span class = "label label-success" style="font-size: 150%;">OC PENDING (CURRENT : <?= $get_oc_pending;?> + PREVIOUS <?= $get_on_con_count;?> = TOTAL <?= $get_oc_pending + $get_on_con_count; ?>  ) </span>
              </div>	 
						 <?php
					 }
						 ?>
              </div>     
            </div>
            <br/>
			<div class="dataTable_wrapper table-responsive">
            <table class="table table-striped table-bordered table-hover text-uppercase"  >
            <thead>
            <tr>
			 <th>S.No</th>
			<!-- <th>Receipt No</th>-->
                <th>Reference</th>
                 <!-- <th>Photo / Details</th> -->
				 <th>Reports</th>
                <th>Name</th>
				<th>Problem</th>
				<!-- <th>Status</th> -->
				<th>Mobile No</th>
				<th>Booked Date</th>
                <th>Appt Date</th>
				<!--<th>Consulting For</th>
				<th>language</th>-->
				<th>City</th>
				<!--<th>Description</th>
				<th>Document</th>-->
				<!--<th>Call</th>
-->				<!--<th>Whatsapp call</th>-->
			
				<!--<th>Reports </th>-->
				<!--<th>Details </th>-->
				<!-- <th>Token No.</th> -->
				<!--<th>Update Token</th>-->
				
				<!--<th>View </th>-->
			<!--	<th>Status </th>-->
				                
            </tr>
            </thead>
            <tbody>
			
			<?php

									
									$table_name="tbl_appointment ";
									
									// $Query = "SELECT * from tbl_appointment where status='1' and appointment_date >= CURDATE() order by appointment_date asc ";
									
 $get_split = "SELECT distinct(appointment_date) as app_date from tbl_appointment where status='1'  order by appointment_date asc ";
				$get_arr = $DB->query($get_split);
while($get_split_date = mysql_fetch_array($get_arr)){
	$si=0;
		?>
	<tr><th class="text-center" colspan = "11"><?= date('d-m-Y', strtotime($get_split_date['app_date'])).' - '.date('l', strtotime($get_split_date['app_date']))?></th></tr>
	<?php
			$Query = "SELECT * from tbl_appointment where status='1'  and appointment_date = '$get_split_date[app_date]' order by appointment_date asc ";
	 $namesss=$DB->query($Query);
											   
											   while ($rowsss = mysql_fetch_array($namesss)) {
											   
											   $pundai_order_id=$rowsss['id'];
											   $upd_sta=$rowsss['update_status'];
											    $date=$rowsss['date'];
												
												 $me_id=$rowsss['mem_id'];
												 $status=$rowsss['status'];
												 
												 $des=$rowsss['des'];
												 $docname=$rowsss['document_name'];
												  
									$document_name=$rowsss['document_name'];
										 	     $Query = "SELECT * from `tbl_member` where id='$me_id'   ";
                                               $name=$DB->query($Query);
											     $no=mysql_num_rows($name);
											   $row = mysql_fetch_array($name);
											$skypeid=$row['skypeid'];  	
											
											$men_country=$row['country'];   
					sprintf("%02d", $to_hour);						  
	
$docname=$rowsss['document_name'];

$new_email=$row['phone'];



$Query_user = "SELECT * from `shop_user` where phone='$new_email'    ";
                                               $name_user=$DB->query($Query_user);
											     $no_user=mysql_num_rows($name_user);
											   $row_user = mysql_fetch_array($name_user);
											     $cur_1_dt2=date('Y-m-d');
							
											    $new_appointment_date=$rowsss['appointment_date'];
												
												$country=$row_user['country'];

$Query_c= "SELECT * from `shop_country` where name='$country'   ";
                                               $name_c=$DB->query($Query_c);
											    
											   $row_c = mysql_fetch_array($name_c);
											   
											   $veh=$rowsss['vehicle'];
											   
											   $aaaaaaaa=$rowsss['amount'];
											   
										   
											   
	?>
			
            
            
                  <tr class="gradeX"  <? if($cur_1_dt2==$new_appointment_date) { ?> style=" color:#0000FF;" <? } ?> 
			
			<? if($cur_1_dt2<$new_appointment_date) { ?>     <? } ?>
			
			<? if($cur_1_dt2>$new_appointment_date) { ?>  style=" color:#FF0000;" <? } ?>
			
			<?php if($upd_sta == "1") {  ?>  style="background-color:#AAFF00;" <?php } ?>>
			
			<td><? echo $si=$si+1;?></td>
	<!--		<td><a href="#">OC-<? echo $rowsss['order_id'];?> 

			</a></td>-->
			<td><?= $rowsss['vehicle'] ?></td>
			<td>
			<?php
		//if($row['upload_photo'] != NULL || $row['upload_photo'] != ''){
			?>
			<!--<img src="<?= 'uploads/'.$row['upload_photo'] ?>" title="<?= $row['name'] ?>" width="128" height="128" />-->
			<?php
		//}
		?>
			
		<!--	<a href="" data-toggle="modal" data-id="" id="<?= $row['id'] ?>" data-target="#myModal6" class="btn btn-success tbl_member_id"><i class="fa fa-upload"></i></a>-->
			<? 
		 $des=$rowsss['des'];
												 $docname=$rowsss['document_name'];
		if($des!='')
				{
			?>
			
			<!-- <a href="appointment_details_view.php?id=<? echo $rowsss['id'];?>"><img src="123_y.png" width="20" height="20" /></a> -->
			<?
				}
				
				else
				{
				?>
				<a href="#"><img src="123_x.png" width="20" height="20" /></a>
				<?
				}
												   
				?>	
			</td>
			<td><? echo $row['name'];?> (<? echo $row['dob'];?>)</td>
			<td >
				
				<? echo $rowsss['consulting_for'];?>
				
				
				
				
                </td>
				
			<!-- <td></td> -->
			<td><a class="btn btn-primary btn-sm" href="https://api.whatsapp.com/send?phone=<? echo $row_c['iso_code_2'];?><? echo $row['skypeid'];?>"  target="_blank">
   <? echo $row['phone'];?> <!--<span class="glyphicon glyphicon-earphone" style="padding-left:10px; padding-right:10px;"></span>-->
			<td><? echo $rowsss['added_date'];?></td>
			
</a></td>
<?php
$mod_date = sprintf("%02d",$rowsss['hour_date']).':'.sprintf("%02d",$rowsss['min_date']).' '.$rowsss['am_date'];

// Create a DateTime object
$dateTime = new DateTime($mod_date);

// Format the time to 24-hour format
$time24Hour = $dateTime->format('H:i');

$dateTime = new DateTime($time24Hour);

// Subtract 10 minutes
$dateTime->modify('-10 minutes');

// Format the resulting time

?>
			<td><? echo $rowsss['appointment_date'].' '.$dateTime->format('h:i A');?>
                </td>
               <!-- <td><? echo $rowsss['consulting_for'];?></td>
				
                <td><? echo $row['language'];?></td>-->
				<td>
				<?  $new_city_pundai=$row_user['city'];
				
				$new_c_p=$row['medical_report'];
				
				if($men_country=="India")
				{
				
				if($new_city_pundai=="")
				{
				echo $new_city_pundai= ucwords($new_c_p);
				}
				else
				{
				
				echo $new_city_pundai= ucwords($new_city_pundai);
				}
				
				}
				
				else
				{
				echo $men_country;
				}
				
				
				?>
				<?php /*?><? $r_p_ar=$rowsss['id'];
				
				?>
				
				<? if($r_p_ar==3304)
				{
				?>
				
				USA
				
				<?
				}
				else
				{
				?>
				<? echo $connn=$row['country'];?>
				
				<?
				}
				?><?php */?>
				
				</td>
				<!--<td><? echo $rowsss['des'];?></td>-->
				
				<!--<td><? if($docname!='') { ?><a href="../../download_document.php?filename=<? echo $rowsss['document_name'];?>">Download Document</a> <? } ?></td>
				
				
				<td><a href="
				https://api.whatsapp.com/send?phone=91<? echo $row['skypeid'];?>" target="_blank">Call</a>
                </td>-->
				
				<?
				 $des=$rowsss['des'];
												 $docname=$rowsss['document_name'];
												 ?>
												 
												 
			
				<?
				                                  $des=$rowsss['des'];
												  $docname=$rowsss['document_name'];
												 
												 ?>
			<!--	<td>
			reports
												
				</td>
				-->
<!--				<td>
				<? if(des!='')
				{
			?>
			
			<a href="appointment_details_view.php?id=<? echo $rowsss['id'];?>"><img src="123_y.png" width="20" height="20" /></a>
			<?
				}
				
				else
				{
				?>
				<a href="#"><img src="123_x.png" width="20" height="20" /></a>
				<?
				}
												   
				?>
				</td>-->
				<!-- <td><? if($docname=='')
				{
			?>
			
			<a href="#"><img src="123_x.png" width="20" height="20" /></a>
			<?
				}
				
				else
				{
				?>
				<a href="appointment_details_view.php?id=<? echo $rowsss['id'];?>"><img src="123_y.png" width="20" height="20" /></a>
				<?
				}
				?></td> -->
	<!--			<td>
				<button type="button" id="delete" title="Delete"><i class="fa fa-trash" aria-hidden="true"></i></button>
					<input type = "text" id="token_no<?= $rowsss['order_id'];?>" style="max-width: 24px" value="" />
				<button type="button" id="update" title="Update"><i class="fa fa-refresh" aria-hidden="true" onclick="process_token(<?= $rowsss['order_id'];?>, <? echo "token_no".$rowsss['order_id'];?>)"></i></button></td>-->
				<!--<td> <? if($status==2)
				 {
				 ?>
				 <a href="#"><span class="label label-primary">Cancelled By Admin</span></a>
				 <?
				 }
				 ?>
				 
				 <?
				 if($status==3)
				 {
				 ?>
				 <a href="#"><span class="label label-success"> Cancelled By User</span></a>
				 <?
				 }
				 ?>
                </td>
				
				 
				 
               <!-- <td>Win 95+</td>
                <td class="center">4</td>
                <td class="center">X</td>-->
				<!-- <td></td> -->
            </tr>
			
			
			
			<?
			$nsssss=$nsssss-1;
			}
				} //track here
			?>
			
			
			<?php
$si=0;
									
									 date_default_timezone_set('Asia/Kolkata');
  $date = date('Y-m-d', time());
 
 
			  
		
//$Query_job_move_free_job = mysql_query("SELECT *  from tbl_appointment_office where 1=1 and  status='1'  and appointment_date >= '2021-12-17' order by appointment_date,hour_date,min_date asc ");
				
			  $get_split = "SELECT distinct(appointment_date) as app_date from tbl_appointment_office where status='1'   and appointment_date >= '2021-12-17' order by appointment_date asc ";
				$get_arr = $DB->query($get_split);
	

											   
					?>
			
            
            </tbody>
            <!--<tfoot>
            <tr>
                <th>Rendering engine</th>
                <th>Browser</th>
                <th>Platform(s)</th>
                
            </tr>
            </tfoot>-->
            </table>
			      <div class="modal inmodal fade" id="myModal6" tabindex="-1" role="dialog"  aria-hidden="true">
                                <div class="modal-dialog modal-sm">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>
                                            <h4 class="modal-title"></h4>
                                        </div>
                                           <form name="magamuni" action="phpaction/submit_form_1.php" method="POST" enctype="multipart/form-data">
                                              <div class="modal-body">
                                        <div class="mod_1_form">
                                          
                                        </div>
											   </div>
                                        <div class="modal-footer">
                                          
                                            <button type="submit" name="save" class="btn btn-primary">Save</button>
                                                <button type="submit" name="delete" class="btn btn-danger">Delete</button>
                                              <button type="button" class="btn btn-white" data-dismiss="modal">Close</button>
                                        </div>
										</form>
                                    </div>
                                </div>
                            </div>
			    <div class="modal inmodal fade" id="myModal7" tabindex="-1" role="dialog"  aria-hidden="true">
                                <div class="modal-dialog modal-sm">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>
                                            <h4 class="modal-title"></h4>
                                        </div>
                                        <form name="sandimuni" action="phpaction/submit_form_2.php" method="POST" enctype="multipart/form-data">
                                           <div class="modal-body">
                                        <div class="mod_2_form">
                                          
                                        </div>
											</div>
                                        <div class="modal-footer">
                                          
                                           <button type="submit" name="save" class="btn btn-primary">Save</button>
                                                <button type="submit" name="delete" class="btn btn-danger">Delete</button>
                                              <button type="button" class="btn btn-white" data-dismiss="modal">Close</button>
                                        </div>
										</form>
                                    </div>
                                </div>
                            </div>
			<div align="center">
			
			<a href="total_appointment_print_1.php?id=<? echo $_REQUEST['id'];?>&from=<? echo $_REQUEST['from'];?>&to=<? echo $_REQUEST['to'];?>" target="_blank" class="btn btn-primary "> Print </a></div>
</div>
            </div>
            </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>
    <script src="js/plugins/metisMenu/jquery.metisMenu.js"></script>
    <script src="js/plugins/slimscroll/jquery.slimscroll.min.js"></script>
    <script src="js/plugins/jeditable/jquery.jeditable.js"></script>

    <!-- Data Tables -->
    <script src="js/plugins/dataTables/jquery.dataTables.js"></script>
    <script src="js/plugins/dataTables/dataTables.bootstrap.js"></script>
    <script src="js/plugins/dataTables/dataTables.responsive.js"></script>
    <script src="js/plugins/dataTables/dataTables.tableTools.min.js"></script>

    <!-- Custom and plugin javascript -->
    <script src="js/inspinia.js"></script>
    <script src="js/plugins/pace/pace.min.js"></script>
  

    <!-- Page-Level Scripts -->
    <script>
        $(document).ready(function() {
            $('.dataTables-example').dataTable({
                responsive: true,
                "dom": 'T<"clear">lfrtip',
                "tableTools": {
                    "sSwfPath": "js/plugins/dataTables/swf/copy_csv_xls_pdf.swf"
                }
            });

            /* Init DataTables */
            var oTable = $('#editable').dataTable();

            /* Apply the jEditable handlers to the table */
            oTable.$('td').editable( '../example_ajax.php', {
                "callback": function( sValue, y ) {
                    var aPos = oTable.fnGetPosition( this );
                    oTable.fnUpdate( sValue, aPos[0], aPos[1] );
                },
                "submitdata": function ( value, settings ) {
                    return {
                        "row_id": this.parentNode.getAttribute('id'),
                        "column": oTable.fnGetPosition( this )[2]
                    };
                },

                "width": "90%",
                "height": "100%"
            } );


        });

        function fnClickAddRow() {
            $('#editable').dataTable().fnAddData( [
                "Custom row",
                "New row",
                "New row",
                "New row",
                "New row" ] );

        }
    </script>
    <script>
function process_token(orderid, table_name){
	console.log(table_name);
}
</script>
<style>
    body.DTTT_Print {
        background: #fff;

    }
    .DTTT_Print #page-wrapper {
        margin: 0;
        background:#fff;
    }

    button.DTTT_button, div.DTTT_button, a.DTTT_button {
        border: 1px solid #e7eaec;
        background: #fff;
        color: #676a6c;
        box-shadow: none;
        padding: 6px 8px;
    }
    button.DTTT_button:hover, div.DTTT_button:hover, a.DTTT_button:hover {
        border: 1px solid #d2d2d2;
        background: #fff;
        color: #676a6c;
        box-shadow: none;
        padding: 6px 8px;
    }

    .dataTables_filter label {
        margin-right: 5px;

    }
</style>
<script>
$('.tbl_member_id').on('click', function(){
	var tbl_member_id = $(this).attr("id");
	
$.ajax({
    url : "phpaction/mod_1_ajax.php",
    type: "POST",
    data : {tbl_member_id: tbl_member_id},
    success: function(data)
    {
	
      $('.mod_1_form').html(data);
    }
});
});
</script>
<script>
$('.tbl_member_direct').on('click', function(){
	var tbl_member_direct = $(this).attr("id");
	
$.ajax({
    url : "phpaction/mod_2_ajax.php",
    type: "POST",
    data : {tbl_member_direct: tbl_member_direct},
    success: function(data)
    {
	
 $('.mod_2_form').html(data);
    }
});
});
</script>
<script>
	$('.token').on('click', function(){

		var id = $(this).attr('id');
		console.log(id);
		$.ajax({
    url : "phpaction/token_ajax.php",
    type: "POST",
    data : {consult_id: id},
    success: function(data)
    {
		console.log(data);
	window.location = 'appointment_details.php';
    }
});
		
	});
	</script>
	
	<?php
function console_log($output, $with_script_tags = true) {
    $js_code = 'console.log(' . json_encode($output, JSON_HEX_TAG) . 
');';
    if ($with_script_tags) {
        $js_code = '<script>' . $js_code . '</script>';
    }
    echo $js_code;
}
?>
</body>

</html>