<?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"); ?>"/> 
            <table id="example1" class="table table-bordered table-striped" style="margin-top:30px;">
			 
              <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">CL</th>
				  <th scope="col">EL</th>
				    <th scope="col">Leave</th>
					<th>Entry User</th>
				 
                </tr> 
              </thead>
              <tbody>
			   <form method="post" action="action2.php" name="addcategory" id="addcategory" enctype="multipart/form-data"  role="form">
              <input type="hidden"  name="do" value="<?php echo $dovalue;?>" />
                <input type="hidden"  name="doid" value="<?php echo $doid;?>" />
				<input type="hidden" name="attdates"  
				class="form-control" value="<?php echo date("Y-m-d"); ?>"/> 
                <input type="hidden"  name="UserID" value="<?php echo $_SESSION["ecomid"];?>" />
              <?php
			  
 

 $holi=mysqli_query($con,"SELECT holiday.* FROM holiday WHERE '".date('Y-m-d')."' between `holiday_date` and `holiday_end`"); 
			   $holi=mysqli_num_rows($holi);
			
			   if($holi==0){


			   $Query2=mysqli_query($con,"select * from employeeattendese where attendancedate='".date('Y-m-d')."'"); 
			   $Query2=mysqli_num_rows($Query2);
			
			   if($Query2==0){
			
			   
			  $Query=mysqli_query($con,"select * from employeeentryform left 
			  JOIN admin ON employeeentryform.user_id=admin.id  
			  	  where  employeeentryform.resign='1'
			  ");
			  
			 
			  
			 
			  		$i = 1;	
	  				  while($Row=mysqli_fetch_array($Query)){ 
    $leave=mysqli_query($con,"SELECT leaveemployee.* FROM leaveemployee WHERE '".date('Y-m-d')."' between `start` and `end`
   and empid='".$Row['empid']."'"); 
			   $leave=mysqli_num_rows($leave);

			   if($leave==0){					 
					  ?>
                    <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"><input type="radio" name="aorb[<?php echo $i; ?>]" value="P"  /></span></td>
                       <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelMobile_0"><input type="radio" name="aorb[<?php echo $i; ?>]" value="A" /></span></td>
					  <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelMobile_0"><input type="checkbox" name="late[<?php echo $i; ?>]" value="L" /></span></td>
                      <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelLastQualification_0"> <input type="time" name="intime[<?php echo $i; ?>]"></span></td>
                      <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelApplicationTypeName_0"><input type="time" name="outime[<?php echo $i; ?>]"></span></td>
					     <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelApplicationTypeName_0"><?=$Row['CL'];?></span></td>
                      <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0"><?=$Row['ML'];?></span></td>
					  
					    <td></td>

					  		  <td><?=$Row['username'];?></td>			  		  
					 
                    </tr>                
			   <?php }$i++;}}else{
			   echo "<center><h3 style='color:red;'>Attendense Allready Exits !</h3></center>"; }
			   
			   }else {
				   
				   echo "<center><h3 style='color:red;'>Today is Holiday Thanks !</h3></center>";
			   }?> 
				
				
              </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="https://cdn.datatables.net/buttons/1.5.1/js/dataTables.buttons.min.js"  type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.flash.min.js"  type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"  type="text/javascript"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/pdfmake.min.js"  type="text/javascript"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/vfs_fonts.js"  type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.html5.min.js"  type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.print.min.js"  type="text/javascript"></script>
<script  type="text/javascript">
	$(function () {
	$("#example1").DataTable({
	
	});
</script>