<?php 
session_start();
ob_start();
$idauto= $_SESSION['user_idd'];
include('../include/config.php');

?>

<!DOCTYPE html>
<html>
<head>
    <link rel="stylesheet" href="../plugins/sweetalert2-theme-bootstrap-4/bootstrap-4.min.css">
  <link rel="stylesheet" href="../plugins/datatables-bs4/css/dataTables.bootstrap4.min.css">
  <link rel="stylesheet" href="../plugins/datatables-responsive/css/responsive.bootstrap4.min.css">
  <link rel="stylesheet" href="../plugins/datatables-buttons/css/buttons.bootstrap4.min.css">
	<title>Testing</title>
</head>
<body>
    
    
    <p>Fee Paid on August</p>
    
   <table class="table">
   	  <head>
   	  	<tr>
   	  	    <th>#</th>
            <th>IDd</th>
   	  		<th>Month</th>
   	  		<th>Receipt No</th>
   	  		<th>Amount</th>
   	  		<th>Bank</th>
   	  		<th>Entry Date</th>
   	  	</tr>
   	  </head>
   	 <tbody>
                    <?php
                    $sql = "SELECT * from feestatement where Month='August' AND Year='2024'";
                    $result = $con->query($sql);
                    if ($result->num_rows > 0) 
                    {
                    $cnt='1';
                    while($row = $result->fetch_assoc()) 
                    {
                    ?>	
                    <tr style="border:1px solid gray">
                    <td style="border:1px solid gray"><?php echo $cnt; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["count"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["Voucherid"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["Month"].' '.$row["Year"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["count"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["PaidAmount"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["Bank"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["EntryDate"]; ?></td>
                    </tr>
                    <?php
                    $cnt=$cnt+1;
                    }
                    }
                    ?>
            </tbody>
   </table>  
    
    
    
    
    <p>Fee Paid on September</p>
    
 <table class="table">
   	  <head>
   	  	<tr>
   	  	    <th>#</th>
   	         <th>ID</th>
   	  		<th>Month</th>
   	  		<th>Receipt No</th>
   	  		<th>Amount</th>
   	  		<th>Bank</th>
   	  		<th>Entry Date</th>
   	  	</tr>
   	  </head>
   	 <tbody>
                    <?php
                    $sql = "SELECT * from feestatement where Month='September' AND Year='2024'";
                    $result = $con->query($sql);
                    if ($result->num_rows > 0) 
                    {
                    $cnt='1';
                    while($row = $result->fetch_assoc()) 
                    {
                    ?>	
                    <tr style="border:1px solid gray">
                    <td style="border:1px solid gray"><?php echo $cnt; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["count"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["Month"].' '.$row["Year"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["Voucherid"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["PaidAmount"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["Bank"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["EntryDate"]; ?></td>
                    </tr>
                    <?php
                    $cnt=$cnt+1;
                    }
                    }
                    ?>
            </tbody>
   </table>
    
    
    
    <p>Fee Paid on November 2024</p>
   <table class="table">
   	  <head>
   	  	<tr>
   	  	    <th>#</th>
   	        <th>ID</th>
   	  		<th>Month</th>
   	  		<th>Receipt No</th>
   	  		<th>Amount</th>
   	  		<th>Bank</th>
   	  		<th>Entry Date</th>
   	  	</tr>
   	  </head>
   	 <tbody>
                    <?php
                    $sql = "SELECT * from feestatement where Month='November' AND Year='2024'";
                    $result = $con->query($sql);
                    if ($result->num_rows > 0) 
                    {
                    $cnt='1';
                    while($row = $result->fetch_assoc()) 
                    {
                    ?>	
                    <tr style="border:1px solid gray">
                    <td style="border:1px solid gray"><?php echo $cnt; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["count"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["Month"].' '.$row["Year"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["Voucherid"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["PaidAmount"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["Bank"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["EntryDate"]; ?></td>
                    </tr>
                    <?php
                    $cnt=$cnt+1;
                    }
                    }
                    ?>
            </tbody>
   </table>
   
 <p>Fee Paid on December</p>
    
   <table class="table">
   	  <head>
   	  	<tr>
   	  	    <th>#</th>
             <th>ID</th>
   	  		<th>Month</th>
   	  		<th>Receipt No</th>
   	  		<th>Amount</th>
   	  		<th>Bank</th>
   	  		<th>Entry Date</th>
   	  	</tr>
   	  </head>
   	 <tbody>
                    <?php
                    $sql = "SELECT * from feestatement where Month='December' AND Year='2024'";
                    $result = $con->query($sql);
                    if ($result->num_rows > 0) 
                    {
                    $cnt='1';
                    while($row = $result->fetch_assoc()) 
                    {
                    ?>	
                    <tr style="border:1px solid gray">
                    <td style="border:1px solid gray"><?php echo $cnt; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["count"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["Month"].' '.$row["Year"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["Voucherid"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["PaidAmount"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["Bank"]; ?></td>
                    <td style="border:1px solid gray"><?php echo $row["EntryDate"]; ?></td>
                    </tr>
                    <?php
                    $cnt=$cnt+1;
                    }
                    }
                    ?>
            </tbody>
   </table>
      
   
   
</body>
</html>