<?php 
    session_start();
    if(!$_SESSION['id']){
        header('location:index.php');
    }
      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>All Advance</title>
    
  </head>
  <body>
    <div class="wrapper">
    <?php include 'system/header.php'?>
	  <div class="page-content-wrapper">
        <div class="page-content">
          <div class="page-breadcrumb d-none d-sm-flex align-items-center mb-3">
            <div class="breadcrumb-title pe-3">All Advance</div>
            <div class="ms-auto"></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>Emp Id</th>
                        <th>Employee Name</th>
            			<th>Branch</th>
                        <th>Date</th>
                        <th>Advance Taken</th>
                        <th>Amount Deduct</th>
                        <th>Amount Left</th>
					</tr>
				  </thead>
				  <tbody>
					<?php
                        $cnt = 1;
                        $stmt1 = $conn->prepare(" SELECT * FROM `advance` WHERE status= 1 ");
                        $stmt1->execute();
                        $sql = $stmt1->fetchAll(); 
                        //print_r($stmt1);exit;
                        foreach($sql as $row) 
                    { ?>
                    <tr>
                        <td><?php echo $cnt;?></td>
                        <td>
                            <a href="#"><?php echo $row['e_id'];?></a>
                        </td>
                        <td>
                            <?php 
                              $sth = $conn->prepare("SELECT * FROM `emp_details` where e_id='".$row['e_id']."' ");
                             $sth->execute();
                             $row1 = $sth->fetch(PDO::FETCH_ASSOC);
                              
                                echo $row1['e_name']; 
                            ?>
                        </td>
                        <td>
                            <?php
                                $stmt = $conn->prepare(" SELECT name FROM `branch` where id='".$row['branch']."' ");
                                $stmt->execute();
                                $sql2 = $stmt->fetchAll(); 
                                foreach($sql2 as $row2) 
                                { 
                                    echo $row2['name']."<br>";  
                                }
                            ?>
                        </td>
                        
                        <td><?php echo $row['date']; ?></td>
                        <td><?php 
                          $manual_balance=$row['manual_balance'];
                          if($manual_balance==0){
                             echo $row['amount']; 
                          }else{
                              echo '0';
                          }
                        
                        ?></td>
                        <td><?php echo $row['manual_balance']; ?></td>
                        <td><?php echo $row['remaining_amount']; ?></td>
                    </tr>
                    <?php  $cnt=$cnt+1; }?>
				  </tbody>
				  <tfoot>
				    <tr>
						<th>SR No</th>
            			<th>Emp Id</th>
                        <th>Employee Name</th>
            			<th>Branch</th>
                        <th>Date</th>
                        <th>Advance Taken</th>
                        <th>Amount Deduct</th>
                        <th>Amount Left</th>
					</tr>
				  </tfoot>
							</table>
						</div>
					</div>
				</div>
             

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