<?php
include ("include/makeSession.php"); 

$installment_id=mysqli_query($con,"select * from admin where id='".$_SESSION["ecomid"]."'");
	  $installment_id=mysqli_fetch_array($installment_id); 
$installment_id=$installment_id['menuper'];
	  $menuper=explode(',',$installment_id);
	   
	   if(in_array('Manage Payrool',$menuper)){
		  
	   }else{
		 
	header("location:index.php");
		   
		}
$_SESSION['page_name']="Payroll Master";
include('include/function.php');
include("include/header.php");
include("include/sidebar.php"); 
if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
	$dovalue="";
	$doid=$_REQUEST['did'];
	mysqli_query($con,"delete from studentenquiry where StudenEnquiryID='$doid'");
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=Communication.php">';
	exit;
}
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
	  $dovalue="EmployeeAttendense";
	  $doid=$_REQUEST['upid'];
	  $upuserresult=mysqli_query($con,"select * from student_enqury_form where id='".$_REQUEST['upid']."'");
	  $upuserarr=mysqli_fetch_array($upuserresult);
}else{
 	  $dovalue="EmployeeAttendense";
	  $doid='';
} 
?>
<div class="content-wrapper">
  <section class="content-header">
    <h1> Faculty Attendense</h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Faculty Attendense</a></li>
    </ol>
  </section>
  <!-- Main content -->
  <section class="content">
    <div class="row">
      <div class="col-xs-12">
        <div class="box">
          <div class="box-header">
            <h3 class="box-title">Faculty Attendense  :</h3>
		
          </div><!-- /.box-header -->
          <div class="box-body">
		
		  		<!---Today:<input type="text" name="attdate" style="width:300px;" 
				class="form-control" value="<?php //echo date("Y-m-d"); ?>"/>    -->
			
			<div class='col-md-12 pull-right' style='margin-bottom:14px;'>
			<input 
    type="text" 
    id="min-date"
    class="date-range-filter form-control col-md-3  pull-right"
    placeholder="From: yyyy-mm-dd"  style='width:200px;'>

<input 
    type="text" 
    id="max-date" 
    class="date-range-filter form-control col-md-3  pull-right"
    placeholder="To: yyyy-mm-dd"  style='width:200px;'>
	</div>
	
            <table id="example1" class="table table-bordered table-striped" style="margin-top:30px;">
			  <?php if(!empty($_SESSION['msg'])){
			  $msg=$_SESSION["msg"];
           echo '<div class="col-md-8">
			<div class="alert alert-success alert-dismissible">
  <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
  '.$msg.'
		  </div>'; $_SESSION["msg"]='';} ?>
              <thead>
                <tr>
                  <th>Sr No</th>
                  <th scope="col">Faculty Code</th>
                  <th scope="col">Faculty Name</th>
				   <th scope="col">Persent</th>
                  <th scope="col">Absent</th>
                  <th scope="col">Late </th>
                  <th scope="col">InTime</th>
                  <th scope="col">Out Time</th>
				   <th scope="col">Date</th>
				    <th scope="col">CL</th>
				  <th scope="col">EL</th>
				    <th scope="col">Leave</th>
					<th>Entry User</th>
				 <th>Action</th>
                </tr>
              </thead>
              <tbody>
			  
              <?php $Query=mysqli_query($con,"select *,employeeattendese.created_at as created,
			  employeeattendese.id as aid from employeeentryform left 
			  JOIN admin ON employeeentryform.user_id=admin.id 
			 left JOIN employeeattendese ON employeeentryform.empid=employeeattendese.empid
			 
			 where employeeattendese.empid=employeeattendese.empid
			 and employeeentryform.resign='1'
			  ");
			 
			  		$i = 1;	
	  				  while($Row=mysqli_fetch_array($Query)){ 
					 // echo "<pre>";
					 // print_r($Row);
					 //   echo "</pre>";
					  ?>
                    <tr>
					  
                      <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelStudentFirstName_0"><?=$i;?></span></td>	  
                      	 <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelStudentFirstName_0"><?=$Row['empid'];?> <input type="hidden" name="empid[<?php echo $i; ?>]" value="<?php echo $Row['empid']; ?>" /></span></td>
                      <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelStudentFirstName_0"><?=$Row['EmployeeName'];?></span></td>
					                        <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelStudentFirstName_0"><?php echo $Row['persent']; ?></span></td>
                       <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelMobile_0"><?php echo $Row['absent']; ?></span></td>
					  <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelMobile_0"><?php echo $Row['late']; ?></span></td>
                      <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelLastQualification_0"> <?php echo $Row['intime']; ?></span></td>
                      <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelApplicationTypeName_0"> <?php echo $Row['outtime']; ?></span></td>
					     <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelApplicationTypeName_0"><?=$Row['attendancedate'];?></span></td>
                      <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0"><?=$Row['CL'];?></span></td>
					   <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0"><?=$Row['ML'];?></span></td>
					    <td></td>

					  		  <td><?=$Row['username'];?></td>			  		  
					 <?php if(!empty($_SESSION["ecomid"]) && $_SESSION["ecomid"]==1){ ?>
					  <td><a href="./editemployeeattendece.php?upid=<?php echo $Row["aid"]; ?>"><i class="fa fa-pencil text-yellow"></i></a> <?php }?>
                    </tr>                
                <?php $i++;} ?> 
				
				
              </tbody>
            </table>
			<div class="box-footer">
                  <input type="submit" class="btn btn-primary" name="ctl00$ContentPlaceHolder1$btnsave" value="Save"/>        <input type="reset" name="ctl00$ContentPlaceHolder1$btn_reset" value="Reset" id="ContentPlaceHolder1_btn_reset" class="btn btn-primary">           
                </div>
				</form>
          </div><!-- /.box-body -->
        </div><!-- /.box -->
      </div><!-- /.col -->
    </div><!-- /.row -->
  </section><!-- /.content -->
</div><!-- /.content-wrapper -->
<!-- footer start -->
<?php
include('include/footer.php');
?>
<!-- footer end -->
<!-- DataTables -->
<script src="plugins/datatables/jquery.dataTables.min.js"  type="text/javascript"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/dataTables.buttons.min.js"  type="text/javascript"></script>

<script src="bootstrap/js/jszip.min.js"  type="text/javascript"></script>

<script src="bootstrap/js/pdfmake.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/vfs_fonts.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.html5.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.print.min.js"  type="text/javascript"></script>

<script src="bootstrap/js/buttons.colVis.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.flash.min.js"  type="text/javascript"></script>
<script src="https://momentjs.com/downloads/moment.js"  type="text/javascript"></script>

<script  type="text/javascript">
$(document).ready(function() {
	
	//var tables= $('#example1').DataTable( {});
   var tables=  $('#example1').DataTable( {
        dom: 'Bfrtip',
        columnDefs: [
            {
                targets: 1,
                className: 'noVis'
            }
        ],
        buttons: [
            {
                extend: 'colvis',
                columns: ':not(.noVis)'
            }
        ],
		 buttons: [
		  { extend: 'colvis', text: 'COLOUMNS' },
		 { extend: 'csv', text: 'Export to CSV' },
		 { extend: 'excel', text: 'Export to Excel' },
           { extend: 'pdfHtml5', text: 'Create PDF', orientation: 'landscape', exportOptions: { columns: ':visible' } },
{ extend: 'print', text: 'Print', exportOptions:{columns: ':visible',autoPrint: true}}
        ],
		
    } );
	
	$.fn.dataTable.ext.search.push(
    function( settings, data, dataIndex ) {
        var min  = $('#min-date').val();
        var max  = $('#max-date').val();
        var createdAt = data[8] || 0; // Our date column in the table
console.log(createdAt);
        if  ( 
                ( min == "" || max == "" )
                || 
                ( moment(createdAt).isSameOrAfter(min) && moment(createdAt).isSameOrBefore(max) ) 
            )
        {
            return true;
        }
        return false;
    }
);

$('.date-range-filter').change( function() {
    tables.draw();
} );
} );
	//$(function () {
	//$("#example1").DataTable();
	
	//});
</script>