<?php 
include 'header.php';
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);

$msg = "";
$err = "";


if (isset($_GET['app'])) {
    $tid = $_GET['app'];

    // Fetch transaction details
    $sq = mysqli_query($link, "SELECT * FROM user_loans   WHERE id = '$tid'");
    if (mysqli_num_rows($sq) > 0) {
        $rw = mysqli_fetch_assoc($sq);
        $userId = $rw['user_id'];
        $amount = $rw['amount'];  // Amount in USD
        $status = $rw['status'];
    }

    $querys = mysqli_query($link, "SELECT * FROM users WHERE id = '$userId'");
    if (mysqli_num_rows($querys) > 0) {
        $rowss = mysqli_fetch_assoc($querys); 
        $username = $rowss['first_name'].' '.$rowss['last_name'];
        $email = $rowss['email'];
    }

    if (isset($status) && $status == "completed") {
        $msg = "This transaction has been Approved already";
    } else {
        $query = mysqli_query($link, "UPDATE user_loans SET status = 'unpaid' WHERE id = '$tid'");

             echo "<script>alert('Transaction approved');window.location.href = 'loanhistory.php'</script>";
    }
}



if (isset($_GET['del'])) {
    $tid = $_GET['del'];
    $del = mysqli_query($link, "DELETE FROM withdrawals  WHERE id = '$tid'");
    if ($del) {
        echo "<script>alert('Transaction deleted successfully');window.location.href = 'withdraw.php'</script>";
    } else {
        echo "Error deleting transaction: " . mysqli_error($link);
    }
}

?>


<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.css">
  
  

  <link rel="stylesheet" href=" https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
  <link rel="stylesheet" href=" https://cdn.datatables.net/1.10.19/css/dataTables.jqueryui.min.css">
  <link rel="stylesheet" href=" https://cdn.datatables.net/buttons/1.5.6/css/buttons.jqueryui.min.css">



  

  <link rel="stylesheet" href=" https://cdn.datatables.net/1.10.19/css/dataTables.bootstrap.min.css">
  <link rel="stylesheet" href=" https://cdn.datatables.net/buttons/1.5.6/css/buttons.bootstrap.min.css">
  <link rel="stylesheet" href="">
 
  

  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.js"></script>
 

  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.10.19/js/dataTables.jqueryui.min.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/buttons/1.5.6/js/dataTables.buttons.min.js"></script>

  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.jqueryui.min.js"></script>
   
  <script type="text/javascript" charset="utf8" src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.html5.min.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.print.min.js"></script>
  <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.colVis.min.js"></script>
<style>
.table-responsive {
overflow-x: hidden;
}
@media (max-width: 8000px) {
.table-responsive {
overflow-x: auto;
}
</style>
<div class="page-content">
    <div class="container-fluid">
<?php 
    if ($msg != "") {
        echo "<div style='padding:20px;background-color:#dce8f7;color:black'> $msg</div class='btn btn-success'>" ."</br></br>"; 
    }
    if ($err != "") {
        echo customAlert("error", $err);
    }

 ?>
			<div class="row">
			    <div class="col-lg-12">
			        <div class="card">
			            <div class="card-header">
			                <h4 class="card-title mb-0">All Pending Loan</h4>
			            </div><!-- end card header -->

			            <div class="card-body">
			                <div id="customerList">
			                    

			                    <div class="table-responsive table-card mt-3 mb-1">
			                    	<table id="myTable" class="table-responsive" >  
								        <thead class="table-light">
			                                <tr class="info">
			                                  
												<th>Name</th>
												<th>Email</th>
												<th>Amount(USD)</th>
												<th>Status</th>
												<th>Date</th>
						                        <th>Action</th>						                        
						                        <th>Action</th>
								
											</tr>
			                            </thead>
								        <tbody>
									<?php 
									$sql= "SELECT * FROM user_loans   WHERE status = 'pending'  ORDER BY id DESC ";
									  $result = mysqli_query($link,$sql);
									  if(mysqli_num_rows($result) > 0){
										  while($row = mysqli_fetch_assoc($result)){   
										  	$userId = $row['user_id'];
										  	$user = mysqli_query($link, "SELECT * FROM users WHERE id = '$userId' ");
											$user_r = mysqli_fetch_assoc($user);
				  						?>
				  		
						<tr class="primary">
						<form method="post">
                            <input type="hidden" name="name" value="<?php echo $row['fullname'] ?>">
							<input type="hidden" name="email" value="<?php echo $user_r['email'] ?>">
                        	<input type="hidden" name="status" value="<?php echo $row['status'] ?>">
                        	<input type="hidden" name="amount" value="<?php echo $row['amount'] ?>">
                        	
                        	
                        	<input type="hidden" name="userId" value="<?php echo $row['user_id'] ?>">
                        	
                        	
                        
							<td><?php echo $user_r['first_name']." ".$user_r['last_name'] ?></td>
							<td><?php echo $user_r['email'] ?></td>
							<td>$<?php echo $row['amount'] ?></td>
							<td><?php echo $row['status'] ?></td>
						
							<td><?php echo $row['created_at'] ?></td>
						
                            <td>
                            
                            <a onclick="return confirm('Carry out action')" href="?app=<?php echo $row['id']; ?>" class="btn btn-success">Approve</a>
                            </td>

							<td><a href="?del=<?php echo $row['id']; ?>" class="btn btn-danger">Delete</a></td>
							
   
						</form>
						</tr>
						
					  <?php
 }
			  }
			  ?>
					</tbody>

								      </table>  

			                        
			                    </div>


			                </div>
			            </div><!-- end card -->
			        </div>
			        <!-- end col -->
			    </div>
			    <!-- end col -->
			</div>
			<!-- end row -->


	</div>
</div>
<script>
$(document).ready(function(){
    $('#myTable').dataTable();
});
</script>

<?php include 'footer.php'; ?>