<?php 
session_start();
include 'header.php'; 
$msg = "";

if(isset($_POST['delete'])){
    $uid = trim($_POST['userId']);
    
    mysqli_query($link, "DELETE FROM users WHERE id = '$uid' ");
    echo '<script>alert("User Account was deleted successfully");window.location.href = "users.php" </script>';
}


if (isset($_GET['apps'])) {
    // Validate input is numeric
    if (!is_numeric($_GET['apps'])) {
        die("Invalid user ID");
    }
    
    $tid = (int)$_GET['apps']; // Force integer type
    
    // Use transaction for atomic operation
    mysqli_begin_transaction($link);
    
    try {
        // Select user
        $stmt = mysqli_prepare($link, "SELECT * FROM users WHERE id = ? FOR UPDATE");
        mysqli_stmt_bind_param($stmt, "i", $tid);
        mysqli_stmt_execute($stmt);
        $result = mysqli_stmt_get_result($stmt);
        
        if (mysqli_num_rows($result) > 0) {
            $rowss = mysqli_fetch_assoc($result); 
            $username = $rowss['fname'];
            $email = $rowss['email'];
            
            // Update status
            $update_stmt = mysqli_prepare($link, "UPDATE users SET status = 'active' WHERE id = ?");
            mysqli_stmt_bind_param($update_stmt, "i", $tid);
            mysqli_stmt_execute($update_stmt);
            
            mysqli_commit($link);
            // echo "User activated successfully";
            
             echo "<script>alert('User activated successfully');window.location.href = 'kyc.php'</script>";
        } else {
            mysqli_rollback($link);
            echo "User not found";
        }
    } catch (Exception $e) {
        mysqli_rollback($link);
        error_log("Error activating user: " . $e->getMessage());
        echo "An error occurred";
    }
}

?>

<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>
<?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="page-content">
    <div class="container-fluid">

			<div class="row">
			    <div class="col-lg-12">
			        <div class="card">
			            <div class="card-header">
			                <h4 class="card-title mb-0">KYC</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>
            <th>Full Name</th>
            <th>Email</th>
            <th>ID Type</th>
            <th>ID Front</th>
            <th>ID Back</th>
            <th>Selfie</th> 
            <th>ACTION</th>
            <th>ACTION</th> 
        </tr>
        
    </thead>
    <tbody>  
        <?php 
        $sql = "SELECT * FROM users WHERE status = 'submitted'  ORDER BY id DESC ";
        $result = mysqli_query($link, $sql);
        if($result && mysqli_num_rows($result) > 0) {
            while($row = mysqli_fetch_assoc($result)) {  
        ?>
        <tr>
            <form method="post">
                <input type="hidden" name="userId" value="<?php echo $row['id'];?>">
                <input type="hidden" name="email" value="<?php echo $row['email'] ?>">
                
                <td><?php echo $row['first_name'].' '.$row['last_name']; ?></td>
                <td id="email"><?php echo $row['email']; ?></td>
                <td><?php echo $row['id_type']; ?></td>
                <td><img width='100' src='<?php echo $row['id_front'] ?>'></td>
                <td><img width='100' src='<?php echo $row['id_back'] ?>'></td>
                <td><img width='100' src='<?php echo $row['selfie'] ?>'></td>
                
               <td>
                            
                            <a onclick="return confirm('Carry out action')" href="?apps=<?php echo $row['id']; ?>" class="btn btn-success">Approve</a>
                            </td>
                <td>
                    <button type="submit" onclick="return confirm('Do you want to delete this account')" name="delete" style="width:100%" class="btn btn-danger">
                        <span class="fas fa-trash">-Delete</span>
                    </button>
                </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'; ?>