<?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>Combined OT Bank Statement</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">
            <?php
              $arr = $_POST['branch'];
              $branch = implode(" OR `branch` =  ",$arr); 
              
              $sth = $conn->prepare("SELECT name FROM `branch` where id='".$_POST['branch']."' ");
              $sth->execute();
              $rows = $sth->fetch(PDO::FETCH_ASSOC);
            ?>
            <div class="breadcrumb-title pe-3">Combined OT Bank Statement</div>
            <div class="ms-auto">
               <a href="excel-comb-ot-bank-stmt-data.php?b=<?php echo $branch; ?>"><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>Employee Id</th>
            							<th>Employee Name</th>
            							<th>Branch</th>
            							<th>Designation</th>
                                        <th>Account No.</th>
                                        <th>Net Pay</th>
									</tr>
								</thead>
								<tbody>
								    <?php
								        $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];
                                        //$branch = $_POST['branch'];

                                        $cnt = 1;
                                        $stmt = $conn->prepare(" SELECT `emp_name`, `emp_id`, `branch`, `Designation`, `ac_no`, `amount` FROM ot_details where `month`='$month' and `year`='$year' and  ( `branch` = $branch ) and `Hold`='' and `cheque`='' and `ac_no`!='' UNION Select 'z','','','','TOTAL',SUM(amount)from ot_details where `month`='$month' and `year`='$year' and ( `branch` = $branch ) and `Hold`='' and `cheque`='' and `ac_no`!='' ORDER BY emp_name ASC ");
                                        //print_r($stmt);exit;
                                        $stmt->execute();
                                        $sql = $stmt->fetchAll();
                                        foreach($sql as $row) 
                                        { 
                                    ?>
                                    <tr>
                                        <td><?php echo $cnt;?></td>
                                        <td><?php echo $row['emp_name']; ?></td>
                                        <td><?php echo $row['emp_id']; ?></td>
                                        <td>
                                        <?php
                                          $sth1 = $conn->prepare("SELECT * FROM `branch` where id='".$row['branch']."' ");
                                          $sth1->execute();
                                          $row2 = $sth1->fetch(PDO::FETCH_ASSOC);
                                          echo $row2['name']; ?>
                                        </td>
                                        <td><?php echo $row['Designation']?></td>
                                        <td><?php echo $row['ac_no'];?></td>
                                        <td><?php echo $row['amount'];?></td> 
                                    </tr>
                                    <?php $cnt=$cnt+1;} ?>
								</tbody>
								

								
								<tfoot>
									<tr>
										<th>SR No</th>
            							<th>Employee Id</th>
            							<th>Employee Name</th>
            							<th>Branch</th>
            							<th>Designation</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'?>