<?php 
  session_start();
  if(empty($_SESSION['branch']) || $_SESSION['branch'] == ''){
    header("Location: index.php");
    die();
  }
    require_once 'system/conn.php';
?>
    <?php
        $date1=date('Y-m-d');
        $date=date('Y-m', strtotime(date('Y-m')." -1 month"));
        $date=explode('-',$date);
        $month=$date[1];
        $monthNum  = $month;
        $dateObj  = DateTime::createFromFormat('!m', $monthNum);
        $monthName = $dateObj->format('F');
        $year=$date[0];
        $id=$_SESSION['branch'];
    ?>
<!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>OT Bank Sheet (<?php echo $monthName;?>-<?php echo $year;?>)</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">
                OT Bank Sheet (<?php echo $monthName;?>-<?php echo $year;?>)
            </div>
            <div class="ms-auto">
                <a href="excel-ot-bank-sheet.php" class="btn btn-primary px-5" style="margin-top: 5px;">Excel download</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>Sl No.</th>
            			<th>Employee Name</th>
            			<th>Employee Id</th>
                        <th>Account No</th>
                        <th>Net Pay</th>
					</tr>
				  </thead>
				  <tbody>
					<?php
                    $cnt = 1;
                    
                    $stmt = $conn->prepare("
                        SELECT emp_name, emp_id, ac_no, amount
                        FROM ot_details
                        WHERE branch = ?
                          AND month = ?
                          AND year = ?
                          AND Hold = ''
                          AND cheque = ''
                          AND ac_no <> ''
                        ORDER BY emp_name ASC
                    ");
                    
                    $stmt->execute([
                        $_SESSION['branch'],
                        $month,
                        $year
                    ]);
                    
                    foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                    ?>
                    <tr>
                        <td><?php echo $cnt++;?></td>
                        <td><?php echo $row['emp_name']; ?></td>
                        <td><?php echo $row['emp_id']; ?></td>
                        <td><?php echo $row['ac_no']; ?></td>
                        <td><?php echo $row['amount']; ?></td>
                    </tr>
                    <?php } ?>
				  </tbody>
				  <tfoot>
					<tr>
						<th>Sl No.</th>
            			<th>Employee Name</th>
            			<th>Employee Id</th>
                        <th>Account No</th>
                        <th>Net Pay</th>
					</tr>
				  </tfoot>
				</table>
			  </div>
			</div>
		  </div>
        </div>
        <!-- end page content-->
    </div>
<?php include'system/footer.php'?>