<?php

require_once '../../include/conf.php';
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);

?>
<?php
if(isset($_POST['sumbit'])){//to run PHP script on submit
 $v_id_order=$_REQUEST["v_id_order"];
 
   $cour=$_REQUEST["courier_status_".$v_id_order.""];
   date_default_timezone_set('Asia/Kolkata');
   
   
   $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_direct.php");
	  

 //$cour="courier_status".$v_id_order."";

 //header("location:view_order.php?ids=15");
}

?>


<?php
if(isset($_POST['sumbit1_para'])){
  $v_id_order=$_REQUEST["v_id_order"];



$cour=$_REQUEST["courier_status_".$v_id_order.""];

date_default_timezone_set('Asia/Kolkata');
 $date = date('Y-m-d H:i:s ', time());

 $Query="UPDATE tbl_appointment SET status='". $cour."',comp_time_da='". $date."' WHERE `id`='".$v_id_order."'";

	   $DB->query($Query);
	   
	    header("location:appointment_details_direct.php");
	   
	   }
	   
	   ?>


<?php

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_direct.php?msg=sucess");
}
?>

 <?php 
 $caller_direct="active";
 $appointment_detil1="active";
 include("header.php"); 
 

 ?>
 <style>
    .myclass{
        background-color: #f8bc0b;
    }
    </style>
            <div class="row wrapper border-bottom white-bg page-heading">
                <div class="col-lg-10">
                    <!-- <h2>Doctor Availability </h2> -->
                    <ol class="breadcrumb">
                       <li>
                            <a>Direct Consultation</a>
                        </li> 
                        
                        <li class="active">
                            <strong>Appointment Details</strong>
                        </li>
                    </ol>
                </div>
                <div class="col-lg-2">

                </div>
				
				
            </div>
			<?php if($_REQUEST['msg']=="sucess")
{

?>
<div class="alert alert-success">
  <strong>Success!</strong> Data Deleted Sucessfully.
</div>
<?php
}
?>
       <?php if($_REQUEST['msg2']=="success")
{

?>
<div class="alert alert-success">
  <strong>Success!</strong> Consultation reopened Sucessfully.
</div>
<?php
}
?>
       <?php if($_REQUEST['msg2']=="failure")
{

?>
<div class="alert alert-danger">
  <strong>Failure!</strong> Consultation Not reopened Sucessfully.
</div>
<?php
}
?>
        <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>-->
                 <form name="cyclone" 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
					 }
						 ?>
				</form>
            <div class="ibox-content">
            <!--<div class="">
            <a  href="add_available_time.php" class="btn btn-primary ">Add a new row</a>
			
			

            </div>-->
			<div class="dataTable_wrapper table-responsive">
            <table class="table table-striped table-bordered table-hover "  >
            <thead>
            <tr>
			 <th>S.No</th>
            
			 <th>Receipt No</th>
			 <th>Reference</th>
                <th>Name</th>
				
				<th>Booked Date</th>
				<th>Mobile No</th>
                <th> Appointment Date </th>
                
				
				<!--<th>Consulting For</th>
				<th>language</th>-->
				<th>Location</th>
				<!--<th>Description</th>
				<th>Document</th>-->
				<!--<th>Call</th>
-->				<!--<th>Whatsapp call</th>-->
				<th>Problem</th>
				<!--<th>Status</th>-->
				<!--<th>View </th>-->
				<th>Status </th>
				<th>Edit </th>
				                
            </tr>
            </thead>
            <tbody>
			
			<?php
$si=0;
									
									$table_name="tbl_appointment ";
									
									// $Query = "SELECT * from tbl_appointment where status='1'  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);
				
				
                                              
?>
			
			<?php

									
									 date_default_timezone_set('Asia/Kolkata');
  $date = date('Y-m-d', time());
 
 
			  
		

				  $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);
	while($get_split = mysql_fetch_array($get_arr)){
		$si=0;

      
			?>
	<tr><th class="text-center" colspan = "11"><?= date('d-m-Y', strtotime($get_split['app_date'])).' - '.date('l', strtotime($get_split['app_date']))?></th></tr>
	<?php
		
		$Query_job_move_free_job = mysql_query("SELECT *  from tbl_appointment_office where 1=1 and  status='1' and appointment_date = '$get_split[app_date]'  order by appointment_date,hour_date,min_date asc ");
			  //$Query_job_move_free_job = mysql_query("SELECT *  from shop_product where stock_status_id='0' and and appointment_date >= '$date' order by product_id desc ");
    $nsssss=mysql_num_rows($Query_job_move_free_job);
				   
											 $qty=1;
				
$si=0;
		
while($row_job_move_free_job = mysql_fetch_array($Query_job_move_free_job))

{
$pundai_order_id=$row_job_move_free_job['id'];
$upd_sta = $row_job_move_free_job['update_status'];
 $pun_id=$row_job_move_free_job['mem_id'];
 
  $cur_1_dt2_man=date('Y-m-d');
	
	$phone_check = mysql_query("select * from tbl_appointment_office where status = 1 and mobile_no = '".$row_job_move_free_job['mobile_no']."'");
	$num_check = mysql_num_rows($phone_check);
	if($num_check > 1){
		$highlight = 1;
	}else{
		$highlight = 0;
	}
							
											   // $new_appointment_date_man=$row_job_move_free_job['appointment_date'];
												
												
												$new_appointment_date_man=date('Y-m-d', strtotime($row_job_move_free_job["appointment_date"]));
												
												
   
   $Query_pu = mysql_query("SELECT *  from tbl_staff where 1=1 and  id='$pun_id'   ");
			 
   
	$row_pu = mysql_fetch_array($Query_pu);
											   
											   
											   $num_padded = sprintf("%02d", $day);
   
   $nnnn_year=$row_job_move_free_job['appointment_date'];

			 $tod_day = $nnnn_year;

 $n_t_d=strtotime($tod_day);
 
 $from_hour=$row_job_move_free_job['hour_date'];
   
   $from_hour_1 = sprintf("%02d", $from_hour);
   
   
   
   
   

   

   $from_min=$row_job_move_free_job['min_date'];
   
   $from_min_1 = sprintf("%02d", $from_min);
   
   
   $from_sta=$row_job_move_free_job['am_date'];
   
   
 $new_time_ma = ''.$from_hour_1.':'.$from_min_1.' '.$from_sta.'';

$new_time_ma_1=strtotime($new_time_ma);

$id=$new_time_ma_1;

$m_id=$n_t_d;

	?>
			
            <tr class="gradeX <?php if($row_job_move_free_job['quoted_by'] =='admin') { echo 'myclass'; } ?>"  <?php if($cur_1_dt2_man==$new_appointment_date_man) { ?> style=" color:#0000FF;" <?php } ?> 
			
			<?php if($cur_1_dt2_man<$new_appointment_date_man) { ?>  <?php } ?>
			
			<?php if($cur_1_dt2_man>$new_appointment_date_man) { ?> style=" color:#FF0000"   <?php } ?>
			
			<?php if($highlight ==1) { ?> style=" color:#F75F11"   <?php } ?>
            
            >
<td <?php if($upd_sta == 1) { ?>  style="background-color:#AAFF00;" <?php } ?>>
			<?php echo $si=$si+1;?></td>
<!--			<td>Direct</td>-->
			<td <?php if($upd_sta == 1) { ?>  style="background-color:#AAFF00;" <?php } ?>><?= strtoupper($row_job_move_free_job['payment']); ?></td>
			<td <?php if($upd_sta == 1) { ?>  style="background-color:#AAFF00;" <?php } ?>><?= strtoupper($row_job_move_free_job['razid']); ?></td>
			<td <?php if($upd_sta == 1) { ?>  style="background-color:#AAFF00;" <?php } ?>><a href="save_direct_invoice.php?id=<?= $row_job_move_free_job['id']; ?>"><?php echo strtoupper($row_job_move_free_job['name']);?> (<?php echo $row_job_move_free_job['amount'];?>)</a></td>
			<td <?php if($upd_sta == 1) { ?>  style="background-color:#AAFF00;" <?php } ?>><?php echo $row_job_move_free_job['added_date'];?></td>
			<td <?php if($upd_sta == 1) { ?>  style="background-color:#AAFF00;" <?php } ?>><?php echo $row_job_move_free_job['mobile_no'];?></td>
			<td <?php if($upd_sta == 1) { ?>  style="background-color:#AAFF00;" <?php } ?>><a href="edit_order_date.php?id=<?php echo $pundai_order_id?>"><?php echo $row_job_move_free_job['appointment_date'];?> <?php echo sprintf("%02d",$row_job_move_free_job['hour_date']);?>:<?php echo sprintf("%02d",$row_job_move_free_job['min_date']);?> <?php echo $row_job_move_free_job['am_date'];?>
				</a></td>
               <!-- <td><?php echo $rowsss['consulting_for'];?></td>
				
                <td><?php echo $row['language'];?></td>-->
				<td <?php if($upd_sta == 1) { ?>  style="background-color:#AAFF00;" <?php } ?>><?php echo strtoupper($row_job_move_free_job['location']);?></td>
				<!--<td><?php echo $rowsss['des'];?></td>-->
				
				<!--<td><?php if($docname!='') { ?><a href="../../download_document.php?filename=<?php echo $rowsss['document_name'];?>">Download Document</a> <?php } ?></td>
				
				
				<td><a href="https://api.whatsapp.com/send?phone=91<?php echo $row['skypeid'];?>" target="_blank">Call</a>
                </td>-->
				<td <?php if($upd_sta == 1) { ?>  style="background-color:#AAFF00;" <?php } ?>>
				
				<?php echo strtoupper($row_job_move_free_job['des']);?>
				
				
				
                </td>
				
				<!--<td> <?php if($status==2)
				 {
				 ?>
				 <a href="#"><span class="label label-primary">Cancelled By Admin</span></a>
				 <?php
				 }
				 ?>
				 
				 <?php
				 if($status==3)
				 {
				 ?>
				 <a href="#"><span class="label label-success"> Cancelled By User</span></a>
				 <?php
				 }
				 ?>
                </td>-->
				
				 
				 <td <?php if($upd_sta == 1) { ?>  style="background-color:#AAFF00;" <?php } ?>>
				 <button style="font-size:12px;" type="button" class="btn-primary" data-toggle="modal" data-target="#exampleModal<?php echo $pundai_order_id;?>">

		
  Update
</button>

<div class="modal fade" id="exampleModal<?php echo $pundai_order_id;?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">Status</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
	  
	  <script type="text/javascript">
	  function  validation_<?php echo $pundai_order_id;?>(){
	
	
//alert(document.register_<?php echo $pundai_order_id;?>.product_name_<?php echo $pundai_order_id;?>.value);

if(document.register_<?php echo $pundai_order_id;?>.courier_status_<?php echo $pundai_order_id;?>.value == "")
{
alert("Please Select Status");
document.register_<?php echo $pundai_order_id;?>.courier_status_<?php echo $pundai_order_id;?>.focus();
return false;
}


}
</script>
	 
	  <form name="register_<?php echo $pundai_order_id;?>" method="post" onSubmit="return validation_<?php echo $pundai_order_id;?>();" class="form-horizontal" enctype="multipart/form-data" action="appointment_details_direct.php?ids=5">
      <div class="modal-body">
	  
        <div class="form-group"><label class="col-sm-2 control-label">Status</label>

                                    <div class="col-sm-10">
									
									
									<select class="form-control m-b" name="courier_status_<?php echo $pundai_order_id;?>" >
									<option value="">Select</option>
                                        



 
									
 
									<option class="form-control"     value="2">Completed</option>
	   <!-- <option class="form-control"     value="3">Not Reachable</option>-->
	    <option class="form-control"     value="4">Cancelled</option>
        <option class="form-control"     value="20">Delete</option>
	   
	  
   
                                </select>
								
									<!--<input type="text" name="product_name_<?php echo $kkkasss;?>" value=""  class="form-control">-->
									
																		</div>
                                </div>
                               
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
        <!--<button type="button" class="btn btn-primary">Save changes</button>-->
		

		<input type="submit" class="btn btn-primary" name="sumbit" id="login"  value="Submit" />
		
		<input type="hidden" name="v_id_order" value="<?php echo $pundai_order_id;?>"/>
      </div>
	  
	  </form>
    </div>
  </div>
</div>
				
				<!--<div class="btn-group">
				
				
				
                                           
                                            <a href="appointment_details.php?id=<?php echo $rowsss['id'];?>"><div class="glyphicon glyphicon-trash"></div></a>
                                        </div>-->
				 </td>
				 
				 
				<td <?php if($upd_sta == 1) { ?>  style="background-color:#AAFF00;" <?php } ?>> 
				<?php
				if($row_job_move_free_job['token_no']!=null){

					?>
					 <button type="button" class="btn-info token" id="<?= $row_job_move_free_job['id'] ?>" disabled>Given: <?= $row_job_move_free_job['token_no'] ?></button></td>
					<?php
				}else{
					?>
<button type="button" class="btn-danger token" id="<?= $row_job_move_free_job['id'] ?>">Given</button></td>
					<?php
				}
	?>
               <!-- <td>Win 95+</td>
                <td class="center">4</td>
                <td class="center">X</td>-->
            </tr>
			
			
			
			<?php
			$nsssss=$nsssss-1;
			}
				} //click here to go
			?>
			
			
			
            
            </tbody>
            <!--<tfoot>
            <tr>
                <th>Rendering engine</th>
                <th>Browser</th>
                <th>Platform(s)</th>
                
            </tr>
            </tfoot>-->
            </table>
			
			
			<div align="center">
			
			<a href="total_appointment_print_1.php?id=<?php echo $_REQUEST['id'];?>&from=<?php echo $_REQUEST['from'];?>&to=<?php echo $_REQUEST['to'];?>" target="_blank" class="btn btn-primary "> Print </a></div>
</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>
<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>
</body>

</html>