<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1>EFD Update Status</h1>
          </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="#">Home</a></li>
              <li class="breadcrumb-item active">EFD List</li>
            </ol>
          </div>
        </div>
      </div><!-- /.container-fluid -->
    </section>

    <!-- Main content -->	
	<section class="content">
      <div class="container-fluid">
        <div class="row">
          <!-- left column -->
          <div class="col-md-12">
            
            <div class="card card-info">
              <div class="card-header">
                <h3 class="card-title">EFD List</h3>
              </div>
              <!-- /.card-header -->
              <!-- form start -->
           
           
		   
		   
		   
		     <div class="card">
             
              <!-- /.card-header -->
              <div class="card-body">
                <table id="example1" class="table table-bordered table-striped">
                  <thead>
                 <tr height='50'>
                    <th>Customer Name
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					
					</th>
                   
                    <th>Problem</th>
                    <th>SubmissionDate</th>
					<th>Underdiagnosis<th>
					<th>FixedOn</th>
					<th>DischargeDate</th>
					<th>RepairStatus</th>
					<th>ServiceCharge</th>
					<th>Model</th>
					<th>Description</th>
					<th>S/N Number</th>
					<th>Tag Number</th>
                   	<th>View File</th>
					 <th >Action</th>
                  </tr>
                  </thead>
                  <tbody>
                 
<?php				
				include"config.php";

//$sql="select * from defd where EfdPurchaseDate > '2025-06-20'";
$sql="select * from repair WHERE RepairStatus !='Discharge'";
$result=mysqli_query($conn,$sql);

if(mysqli_num_rows($result)>0)
{
	while($row=mysqli_fetch_assoc($result))
	{
		
	echo"
   <tr>
                     <td>". $row['CustomerName']."</td>
                    <td>". $row['Problem']."</td>
                    <td>". $row['SubmissionDate']."</td>
					<td>". $row['UnderDiagonosis']."</td>
					<td>". $row['FixedOn']."</td>
					<td>". $row['DischargeDate']."</td>
					<td>". $row['RepairStatus']."</td>
					<td>". $row['ServiceCharge']."</td>
					<td>". $row['Model']."</td>
					<td>". $row['Description']."</td>
					<td>". $row['SerialNumber']."</td>
					<td>". $row['TagNumber']."</td>
					<td>". $row['TagNumber']."</td>
					<td>". $row['File']."</td>
                 
                  
					<td>
					<form action='RepairStatusDetails.php' method='post'>
					<input type='submit' class='btn btn-info' value='Change Status' >
					<input type='hidden' name='hidden' value='".$row['RepairId']."'>
					</form>
				
					</button>
                
					</td>
                   
</tr>
						";
}}
						?>
				 
				 
				 
				 
               
                     <tfoot>
                
					 <tr height='50'>
                    <th>Customer Name
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					
					</th>
                   
                    <th>Problem</th>
                    <th>SubmissionDate</th>
					<th>Underdiagnosis<th>
					<th>FixedOn</th>
					<th>DischargeDate</th>
					<th>RepairStatus</th>
					<th>ServiceCharge</th>
					<th>Model</th>
					<th>Description</th>
					<th>S/N Number</th>
					<th>Tag Number</th>
                   	<th>View File</th>
					 <th >Action</th>
                  </tr>
                  </tfoot>
                </table>
              </div>
              <!-- /.card-body -->
            </div>
            <!-- /.card -->
          </div>
          <!-- /.col -->
        </div>
        <!-- /.row -->
      </div>
      <!-- /.container-fluid -->
    </section>
    <!-- /.content -->
  </div>
		   
		   
		   
		   
		   
		   
		   
		   
		   
                <!-- /.card-body -->
              
                <!-- /.card-footer -->
         
            </div>
            <!-- /.card -->

          </div>
          <!--/.col (left) -->
          <!-- right column -->
         
          <!--/.col (right) -->
        </div>
        <!-- /.row -->
      </div><!-- /.container-fluid -->
    </section>
	    <!-- /.content -->
  </div>    