<!DOCTYPE html> 
<html lang="en"> 

<head>
<?php ob_start(); ?>
<?php   require_once 'head_link.php'; ?>

</head>

<body>
 
<?php   require_once 'header1.php'; ?> 

<?php  require_once 'sidebar.php'; ?>


  <main id="main" class="main"> 

    <div class="pagetitle bg-light rounded p-2">
      <h1><i class="bi bi-people"></i> <i class="bi bi-files"></i> Batch Wise Dues Report </h1>
        
    </div> 

<section class="section">
      <div class="row">
	  
        <div class="col-lg-6">

          <div class="card">
            <div class="card-body p-5">
				
				<form class="form-horizontal" action="php_action/batch-wise-due-report.php" method="post" id="getOrderReportForm">
				
				<div class="row mb-3 mt-5">
                  <label for="CustId1" class="col-sm-3 control-label">Batch Name</label>
                  <div class="col-sm-9">
        <select style="width:100%;" class="form-control chosen-select" Id="BatchNo" name="BatchNo" required="">
							<option value="#">Select Batch</option>

							<?php
							$sql = "SELECT id,batch_name FROM batch where user_id='".$_SESSION['id']."'  order by id asc ";
							$result = $con->query($sql);

							while ($row = $result->fetch_array()) {
								echo "<option value='" . $row[0] . "'>" . $row[1] . "</option>";
							}
							?>
						</select> 
				  </div>
                </div>
			 
				  
				  <div class="text-center">
				  <button type="submit" class="btn btn-primary" id="generateReportBtn1"> <i class="bi bi-file-earmark-text"></i> Open Report</button>
                </div>
				  
				  
				</form>

		
			</div>
          </div>

        </div>

	  
        <div class="col-lg-6 d-none">

          <div class="card">
            <div class="card-body p-5">
				
				<form class="form-horizontal" action="php_action/sales_report_by_single_cust.php" method="post" id="getOrderReportForm1">
				
				<div class="row mb-3 mt-5">
                  <label for="CustId2" class="col-sm-3 control-label">Customer Phone</label>
                  <div class="col-sm-9">
                 <select style="width:85%;" class="form-control chosen-select" Id="CustId" name="CustId" required>
		<option value="" required>Select Customer Phone</option>
		
				      	<?php 
				      	$sql = "SELECT  customer_id,contact_info FROM customer  ";
								$result = $con->query($sql);

								while($row = $result->fetch_array()) {
									echo "<option value='".$row[0]."'>".$row[1]."</option>";
								} 
				      	?>
						
		</select>
				  </div>
                </div>
				
				 <div class="text-center">
				  <button type="submit" class="btn btn-primary" id="generateReportBtn1"> <i class="bi bi-file-earmark-text"></i> Open Report</button>
                </div>
				  
				
				 
				</form>

		
			</div>
          </div>

        </div>
      </div>
    </section>

 
	
	 </main>
	
 

<?php  require_once 'footer1.php'; ?>


<script src="custom/js/report.js"></script>
<script src = "js/chosen.js"></script>
<script type = "text/javascript">
	$('.chosen-select').chosen({width: "100%"});
</script>
 