<?
   date_default_timezone_set('Asia/Kolkata');
$caller="active";
$caller1="open";
$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);
?>
<?
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">
                                <div class="form-group">
                                    <span class = "label label-primary" style="font-size: 150%">TODAY PATIENT COUNT: <?= $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%;">ONLINE CONSULTATION PENDING: <?= $get_on_con_count;?>  </span>
              </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>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'];
											   
											    $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;" <? } ?>
			
			>
			
			<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>
			<td><? echo $rowsss['appointment_date'];?> <? echo sprintf("%02d",$rowsss['hour_date']);?>:<? echo sprintf("%02d",$rowsss['min_date']);?> <? echo $rowsss['am_date'];?>
                </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);
	

											   
					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'];

 $pun_id=$row_job_move_free_job['mem_id'];
 
  $cur_1_dt2_man=date('Y-m-d');
							
											    $new_appointment_date_man=$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;

$veh=$row_job_move_free_job['razid'];

	?>
			
            <tr class="gradeX" <? if($cur_1_dt2_man==$new_appointment_date_man) { ?> style=" color:#0000FF;" <? } ?>>
			<td><? echo $si=$si+1;?></td>
			<!--<td>Direct</td>-->
			<!--<td>Direct</td>-->
<!--			<td><?= $row_job_move_free_job['razid'] ?></td>-->
			<td><?= $row_job_move_free_job['payment'] ?></td>
				<td>
			
				<a href="" data-toggle="modal" data-id="" id="<?= $row_job_move_free_job['id']?>" data-target="#myModal7" class="btn btn-success tbl_member_direct"><i class="fa fa-upload"></i></a>
				
<!--				<a href="phpaction/delete_form_2.php?mem_direct_id=<?= $row_job_move_free_job['id']?>"  id="<?= $row_job_move_free_job['id']?>" data-target="#myModal7" class="btn btn-danger tbl_member_direct"><i class="fa fa-trash"></i></a></td>-->
			<td>
				<?php
		if($row_job_move_free_job['upload_photo'] != NULL || $row_job_move_free_job['upload_photo'] != ''){
			?>
			<img src="<?= 'uploads/'.$row_job_move_free_job['upload_photo'] ?>" alt="<?= $row_job_move_free_job['name'] ?>" width="128" height="128" />
			<?php
		}
		?><? echo $row_job_move_free_job['name'];?> (<? echo $row_job_move_free_job['amount'];?>)</td>
		<td >
				
				<? echo $row_job_move_free_job['des'];?>
				
				
				
                </td>
							 <td>
				 <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.php">
      <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>
	   
	  
   
                                </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="sumbit1_para" 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><? echo $row_job_move_free_job['mobile_no'];?></td>
			<td><? echo $row_job_move_free_job['added_date'];?></td>
			
			<td><? echo $row_job_move_free_job['appointment_date'];?> <? //echo sprintf("%02d",$row_job_move_free_job['hour_date']);?>:<? //echo sprintf("%02d",$row_job_move_free_job['min_date']);?> <? //echo $row_job_move_free_job['am_date'];?>
				</td>
               <!-- <td><? echo $rowsss['consulting_for'];?></td>
				
                <td><? echo $row['language'];?></td>-->
				<td><? echo $row_job_move_free_job['location'];?></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>-->
				
				
				<!--<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></td>-->
				 <td>
				<?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>WIP</td>-->
			<!--	<td>WIP</td>-->
				
				
               <!-- <td>Win 95+</td>
                <td class="center">4</td>
                <td class="center">X</td>-->
            </tr>
			
			
			
			<?
			$nsssss=$nsssss-1;
			}
				} //track here
			?>
			
			
			
            
            </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>