WP List Table Debugging

class Pending_User_Approval_List extends WP_List_Table {

// Constructor
public function __construct() {
parent::__construct( [
'singular' => 'user', // Singular name of the item
'plural' => 'users', // Plural name of the item
'ajax' => false, // Whether this table supports ajax
] );
}

// Define the columns for the table
public function get_columns() {
// Return an array of columns with the column name as the key and label as the value
return [
'username' => 'Username',
'actions' => 'Actions',
];
}

// Prepare the items for the table
public function prepare_items() {
global $wpdb;

$per_page = 10; // Number of items per page
$current_page = $this->get_pagenum();

// Get the users with 'aiowps_account_status' set to 'lock'
$args = [
'meta_key' => 'aiowps_account_status',
'meta_value' => 'pending',
'fields' => ['ID', 'user_login','user_email','user_registered'],
'number' => $per_page,
'offset' => ( $current_page – 1 ) * $per_page
];

$users = get_users($args);
$total_users = count(get_users([
'meta_key' => 'aiowps_account_status',
'meta_value' => 'pending',
'fields' => ['ID']
]));

// Prepare the data (rows)
$data = [];
foreach ( $users as $user ) {
$data[] = [
'username' => $user->user_login,
// 'email' => $user->user_email,
// 'signup' => date('F j, Y at g:i a', strtotime($user->user_registered)),
'actions' => sprintf(
'Approve',
admin_url('admin.php?action=userwp_approve_user&user_id=' . $user->ID)
)
];
}
print_r($data);
die;
// Set the data for the table
$this->items = $data;

// Pagination
$this->set_pagination_args([
'total_items' => $total_users, // Total number of items
'per_page' => $per_page, // Number of items per page
'total_pages' => ceil($total_users / $per_page) // Total number of pages
]);
}

// Column output
public function column_username( $item ) {
return esc_html( $item['username'] );
}

public function column_actions( $item ) {
return $item['actions'];
}
}

// Display the list table
function userwp_display_pending_users() {
$pending_users_table = new Pending_User_Approval_List();
$pending_users_table->prepare_items();
?>

Pending User Approvals

Pending User Approvals

### 1. **Ensure the Table is Rendered Correctly**
You might need to check if you're correctly calling the `prepare_items()` and `display()` methods of `WP_List_Table`. You are calling `prepare_items()` inside the `userwp_display_pending_users` function, but the `display()` method isn't invoked in the right place.

### 2. **Check the `data` Variable**
You’ve added a `print_r($data); die;` for debugging, but after that, the page will die, preventing the table from rendering. Try removing `die;` and `print_r` or only output them for debugging without halting execution:

// Inside prepare_items()
print_r($data);  // This will output the data to check if it’s being populated correctly

### 3. **Set `items` After Data Population**
Ensure that the `items` property is being set correctly. Right now, you are setting `$this->items` after preparing the data, which is the right approach. Double-check if this line executes properly:

$this->items = $data;

### 4. **Pagination Arguments**
Ensure that the pagination is set up correctly. You might want to check if the `$total_users` count is accurate and aligns with your query results.

$this->set_pagination_args([
    'total_items' => $total_users, // Total number of items
    'per_page'    => $per_page,    // Number of items per page
    'total_pages' => ceil($total_users / $per_page) // Total number of pages
]);

### 5. **Search Box and Form Elements**
You are calling the `search_box` method before rendering the table. This is correct for adding a search bar, but make sure you're also correctly handling the search functionality (if applicable).

Here’s a simplified version of the form part:

<form method="get">
    <?php 
        $pending_users_table->search_box('search', 'search_id'); 
        $pending_users_table->display();
    ?>
</form>

Make sure there are no issues with the search form and pagination links.

### Final Code Suggestion:

function userwp_display_pending_users() {
    $pending_users_table = new Pending_User_Approval_List();
    $pending_users_table->prepare_items();
    ?>
    <div class="wrap">
        <h2>Pending User Approvals</h2>
        <form method="get">
            <?php
                // You can add a search box if you want to filter
                $pending_users_table->search_box('search', 'search_id');
                // Render the table
                $pending_users_table->display();
            ?>
        </form>
    </div>
    <?php
}

Make sure you call `prepare_items()` once, and `display()` after that.

Here’s how you can clean up the code:

1. **Remove the Debugging Code:**
The `print_r($data); die;` is for debugging purposes, but it halts the execution of the script. Removing or commenting this out will allow the table to render.

2. **Correct the Table Setup:**
After populating the `$data` array, the `items` property should be set. Ensure that this is done before rendering the table.

### Updated `prepare_items` method:

public function prepare_items() {
    global $wpdb;

    $per_page = 10; // Number of items per page
    $current_page = $this->get_pagenum();

    // Get the users with 'aiowps_account_status' set to 'pending'
    $args = [
        'meta_key'   => 'aiowps_account_status',
        'meta_value' => 'pending',
        'fields'     => ['ID', 'user_login', 'user_email', 'user_registered'],
        'number'     => $per_page,
        'offset'     => ( $current_page - 1 ) * $per_page
    ];

    $users = get_users($args);
    $total_users = count(get_users([
        'meta_key'   => 'aiowps_account_status',
        'meta_value' => 'pending',
        'fields'     => ['ID']
    ]));

    // Prepare the data (rows)
    $data = [];
    foreach ( $users as $user ) {
        $data[] = [
            'username' => $user->user_login,
            'actions'  => sprintf(
                '<a href="%s">Approve</a>',
                admin_url('admin.php?action=userwp_approve_user&user_id=' . $user->ID)
            )
        ];
    }

    // Set the data for the table
    $this->items = $data;

    // Pagination
    $this->set_pagination_args([
        'total_items' => $total_users, // Total number of items
        'per_page'    => $per_page,    // Number of items per page
        'total_pages' => ceil($total_users / $per_page) // Total number of pages
    ]);
}

### Additional Improvements:
– **User approval and notices**: The `approve_user` function seems good, but you can ensure a cleaner redirect after the approval action:

function approve_user() {
      if (isset($_GET['action']) && $_GET['action'] === 'userwp_approve_user' && !empty($_GET['user_id'])) {
          $user_id = intval($_GET['user_id']);
          
          // Update 'aiowps_account_status' to 'active' (approved)
          update_user_meta($user_id, 'aiowps_account_status', 'active');
          
          // Add a success notice
          add_action('admin_notices', function() {
              echo '<div class="updated"><p>User approved successfully!</p></div>';
          });

          // Redirect back to the approval page
          wp_redirect(admin_url('admin.php?page=userwp-user-approval'));
          exit;
      }
  }

– **Form submission**: If the table still doesn’t show up after fixing the above issues, try confirming that the `display()` method of the `WP_List_Table` is rendering the table correctly.

### Final HTML rendering:

Here’s the part where you display the table inside the WordPress admin:

function userwp_display_pending_users() {
    $pending_users_table = new Pending_User_Approval_List();
    $pending_users_table->prepare_items();
    ?>
    <div class="wrap">
        <h2>Pending User Approvals</h2>
        <form method="get">
            <?php
                // Optionally, you can add a search box
                $pending_users_table->search_box('search', 'search_id');
                // Display the table
                $pending_users_table->display();
            ?>
        </form>
    </div>
    <?php
}

Make sure you don't have any conflicting HTML or PHP that prevents the table from being rendered properly. After fixing these changes, the table should display with the pending users and actions for approval.