<?php
  session_start();
  if(empty($_SESSION['branch']) || $_SESSION['branch'] == ''){
    header("Location: index.php");
    die();
  }
    require_once 'system/conn.php';
?>
<!doctype html>
<html lang="en" class="semi-dark">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
	<link href="assets/css/pace.min.css" rel="stylesheet" />
	<script src="assets/js/pace.min.js"></script>
    <link href="assets/plugins/perfect-scrollbar/css/perfect-scrollbar.css" rel="stylesheet" />
    <link href="assets/plugins/simplebar/css/simplebar.css" rel="stylesheet" />
    <link href="assets/plugins/metismenu/css/metisMenu.min.css" rel="stylesheet" />
    <link href="assets/plugins/datatable/css/dataTables.bootstrap5.min.css" rel="stylesheet" />
    <link href="assets/css/bootstrap.min.css" rel="stylesheet">
    <link href="assets/css/bootstrap-extended.css" rel="stylesheet">
    <link href="assets/css/style.css" rel="stylesheet">
    <link href="assets/css/icons.css" rel="stylesheet">
	<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.7.2/font/bootstrap-icons.css">
    <link href="https://fonts.googleapis.com/css2?family=Roboto:wght@400;500&display=swap" rel="stylesheet">
    <link href="assets/css/dark-theme.css" rel="stylesheet" />
    <link href="assets/css/semi-dark.css" rel="stylesheet" />
    <link href="assets/css/header-colors.css" rel="stylesheet" />
    <title>Employment history</title>
  </head>
  <body>
  <div class="wrapper">
  <?php include'system/header.php'?>
	<div class="page-content-wrapper">
      <div class="page-content">
        <!--start breadcrumb-->
        <div class="page-breadcrumb d-none d-sm-flex align-items-center mb-3">
          <div class="breadcrumb-title pe-3">Employment history</div>
          <div class="ms-auto">
            <!--<a href="excel-employeement-history.php"><button type="button" class="btn btn-primary px-5">Excel Download</button></a>-->
          </div>
        </div>
		<hr/>
		<div class="card">
		  <div class="card-body">
			<div class="table-responsive">
	    
			  <table id="example2" class="table table-striped table-bordered">
				<thead>
					<tr>
						<th>SR No</th>
            			<th>Id No</th>
            			<th>Left Date</th>
            			<th>Join Date</th>
                        <th>Employee Name</th>
                        <th>Father Name</th>
                        <th>Mobile</th>
                        <th>Adhar Number</th>
                        <th>Pan Number</th>
                        <th>Designation</th>
                        <th>Salary</th>
                        <th>Account</th>
                        <th>Status</th>
					</tr>
				</thead>
				<tbody>
					<?php 
                        $cnt = 1;
                        $stmt1 = $conn->prepare(" SELECT * from left_employee where branch='".$_SESSION['branch']."' order by id asc ");
                        $stmt1->execute();
                        $sql = $stmt1->fetchAll(); 
                        foreach($sql as $row) 
                    { ?>
                    <tr>
                        <?php
                            $stmt2 = $conn->prepare("SELECT * from emp_details where e_id='".$row['emp_id']."' ");
                            //print_r($stmt2);exit;
                            $stmt2->execute();
                            $sql2 = $stmt2->fetchAll(); 
                            foreach($sql2 as $row2) 
                        { ?>
                        <td><?php echo $cnt;?></td>
                        <td>
                          <a href="employee-details.php?id=<?php echo $row2['sn'];?>"><?php echo $row['emp_id'];?></a>
                        </td>
                        <td><?php echo $row['d_o_l'];?></td>
                        <td><?php echo $row['entry_date'];?></td>
                        <td><?php echo $row2['e_name'];?></td> 
                        <td><?php echo $row2['fname'];?></td> 
                        <td><?php echo $row2['mobile_num'];?></td> 
                        <td><?php echo $row2['aadhar_num'];?></td> 
                        <td><?php echo $row2['pan_card'];?></td> 
                        <td><?php echo $row2['designation'];?></td>
                        <td><?php echo $row2['salary'];?></td>
                        <td><?php echo $row2['bank_ac_no'];?></td> 
                        <td>
                            <?php 
                              $a=$row['status'];
                              if ($a==1){
                                echo "Left Employee";
                              }elseif ($a==0){
                                echo "Rejoin Employee";   
                              } else {
                                echo " ";
                              }
                            ?> 
                        </td> 
                        
                    </tr>
                    <?php   $cnt=$cnt+1; } }?>
				</tbody>
				<tfoot>
					<tr>
						<th>SR No</th>
            			<th>Id No</th>
            			<th>Left Date</th>
            			<th>Join Date</th>
                        <th>Employee Name</th>
                        <th>Father Name</th>
                        <th>Mobile</th>
                        <th>Adhar Number</th>
                        <th>Pan Number</th>
                        <th>Designation</th>
                        <th>Salary</th>
                        <th>Account</th>
                        <th>Status</th>
					</tr>
				</tfoot>
			 </table>
			</div>
		  </div>
		</div>
             

          </div>
          <!-- end page content-->
         </div>
<?php include'system/footer.php'?>