<?php
$caller="active";
$caller1="open";
$appointment_detil="active";
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 = 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.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.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.php?msg=sucess");
}
?>

 <?php include("header.php"); ?>
            <div class="row wrapper border-bottom white-bg page-heading">
                <div class="col-lg-10">
                    <!-- <h2>Doctor Availability </h2> -->
                    <ol class="breadcrumb">
                       <li>
                            <a>Online 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);
				
				
                                              
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);
											   
											   $nsssss=mysql_num_rows($namesss);
												$manssss='0';
											   
											   while ($rowsss = mysql_fetch_array($namesss)) {
												   
											   
											   $pundai_order_id=$rowsss['id'];
											   
											    $date=$rowsss['date'];
												
												 $me_id=$rowsss['mem_id'];
												 $status=$rowsss['status'];
												  
									$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);
											  
											   $name_mal=$row['name'];
											$skypeid=$row['skypeid'];  	   
					sprintf("%02d", $to_hour);						  
	
$docname=$rowsss['document_name'];

$new_email=$row['email'];

$men_country=$row['country'];

$new_phone=$row['phone'];

												  

$Query_user = "SELECT * from `shop_user` where phone = '$new_phone'";
												   
                                               $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=date('Y-m-d', strtotime($rowsss["appointment_date"]));
												
												

												
						 $veh=$rowsss['vehicle'];
											   
											   $aaaaaaaa=$rowsss['amount'];						
												
												
												
												
	?>
	<?php if($name_mal!="aqrybwli")
	{
	?>
	
			
            <tr class="gradeX"  <?php if($cur_1_dt2==$new_appointment_date) { ?> style=" color:#0000FF;" <?php } ?> 
			
			<?php if($cur_1_dt2<$new_appointment_date) { ?>     <?php } ?>
			
			<?php if($cur_1_dt2>$new_appointment_date) { ?>  style=" color:#FF0000;" <?php } ?>
			
			>
			<td><?php echo $si=$si+1;?></td>
			<td><a href="appointment_details_view.php?id=<?php echo $rowsss['id'];?>">OC-<?php echo $rowsss['order_id'];?> </a></td>
			<td><?= strtoupper($rowsss['vehicle']); ?></td>
			<td><?php echo strtoupper($row['name']);?> (<?php echo $row['dob'];?>)</td>
			<td><?php echo $rowsss['added_date'];?></td>
			<td><?php echo $row['phone'];?></td>
			<td><?php echo $rowsss['appointment_date'];?> <?php echo sprintf("%02d",$rowsss['hour_date']);?>:<?php echo sprintf("%02d",$rowsss['min_date']);?> <?php echo $rowsss['am_date'];?>
                </td>
               <!-- <td><?php echo strtoupper($rowsss['consulting_for']);?></td>
				
                <td><?php echo $row['language'];?></td>-->
				<td>
				<?php  
				// $new_city_pundai=$row_user['city'];
				
				// $new_c_p=$row['medical_report'];
				
				// if($men_country=="India")
				// {
				
				// if($new_city_pundai=="")
				// {
				// echo $new_city_pundai= strtoupper($new_c_p);
				// }
				// else
				// {
				
				// echo $new_city_pundai= strtoupper($new_city_pundai);
				// }
				
				// }
				
				// else
				// {
				// echo strtoupper($men_country);
				// }
				echo strtoupper($row['location_city']);
				
				?>	
				<?php /*?><?php $r_p_ar=$rowsss['id'];
				
				?>
				
				<?php if($r_p_ar==3304)
				{
				?>
				
				USA
				
				<?php
				}
				else
				{
				?>
				<?php echo $connn=$row['country'];?>
				
				<?php
				}
				?><?php */?>
				
				</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 echo strtoupper($rowsss['consulting_for']);?>
				
				<?php /*?><?php $r_p_ar=$rowsss['id'];
				
				?>
				
				<?php if($r_p_ar==3304)
				{
				?>
				Rs3500
				<?php
				
				}
				else
				{
				?>
				
				<?php if($connn=="India")
				{
				$sss="Rs";
				}
				else
				{
				$sss="$";
				}
				?>
				<?php echo $sss;?><?php echo $rowsss ['amount'];?>
				
				<?php
				}
				?><?php */?>
				
				
				
                </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>
				 <!-- <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?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>
	   
	  
   
                                </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> <a href="appointment_details_edit.php?id=<?php echo $rowsss['id'];?>">Edit</a></td> -->
				
               <!-- <td>Win 95+</td>
                <td class="center">4</td>
                <td class="center">X</td>-->
            </tr>
			
			
			
			<?php
			$nsssss=$nsssss-1;
			}
			?>
			
			<?php
			}
				
} // mark date while here
			?>

			
			
			
            
            </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>