// Step 1: Approve all existing users (run once on load)
function approve_existing_users() {
    $users = get_users(array(
        'meta_key' => 'is_approved',
        'meta_compare' => 'NOT EXISTS'
    ));

    foreach ($users as $user) {
        update_user_meta($user->ID, 'is_approved', 1);
    }
}
approve_existing_users();

// Step 2: Add approval status to newly registered users
function add_user_approval_meta($user_id) {
    if (!get_user_meta($user_id, 'is_approved', true)) {
        add_user_meta($user_id, 'is_approved', 0, true);
    }
}
add_action('user_register', 'add_user_approval_meta');

// Step 3: Prevent non-approved users from logging in
function prevent_non_approved_user_login($user, $username, $password) {
    $user_data = get_user_by('login', $username);

    if ($user_data && get_user_meta($user_data->ID, 'is_approved', true) != 1) {
        wp_redirect('https://filenewcreate.com/account-panding/');
        exit;
    }
    return $user;
}
add_filter('authenticate', 'prevent_non_approved_user_login', 30, 3);

// Step 4: Add "Approval Status" column in admin user list
function add_approval_column($columns) {
    $columns['approval_status'] = __('Approval Status');
    return $columns;
}
add_filter('manage_users_columns', 'add_approval_column');

// Step 5: Show approval status and approve button
function show_approval_status($value, $column_name, $user_id) {
    if ('approval_status' == $column_name) {
        $is_approved = get_user_meta($user_id, 'is_approved', true);
        if ($is_approved == 1) {
            return __('Approved');
        } else {
            $current_url_param = (isset($_GET['is_approved']) && $_GET['is_approved'] === 'pending') ? '&is_approved=pending' : '';
return '<a href="' . admin_url('users.php?approve_user=' . $user_id . $current_url_param) . '" style="display: inline-block; padding: 5px 10px; background-color: #0073aa; color: white; text-decoration: none; border-radius: 3px;">Approve</a>';

        }
    }
    return $value;
}
add_filter('manage_users_custom_column', 'show_approval_status', 10, 3);

// Step 6: Handle approval action
function approve_user() {
    if (isset($_GET['approve_user']) && current_user_can('manage_options')) {
        $user_id = intval($_GET['approve_user']);
        update_user_meta($user_id, 'is_approved', 1);

        // Check if we're coming from the pending filter tab
        $redirect_url = admin_url('users.php');
        if (isset($_GET['is_approved']) && $_GET['is_approved'] === 'pending') {
            $redirect_url = add_query_arg('is_approved', 'pending', $redirect_url);
        }

        wp_redirect($redirect_url);
        exit;
    }
}

add_action('admin_init', 'approve_user');

// Step 7: Notify users when approved
function notify_user_approval($user_id) {
    $user = get_userdata($user_id);
    $email = $user->user_email;
    $subject = 'Your account has been approved!';
    $message = 'Congratulations! Your account on ' . get_bloginfo('name') . ' has been approved. You can now <a href="https://filenewcreate.com/register-basic-2/">log in</a>.';

    $headers = array(
        'From: ' . get_bloginfo('name') . ' <no-reply@' . $_SERVER['SERVER_NAME'] . '>',
        'Content-Type: text/html; charset=UTF-8'
    );

    wp_mail($email, $subject, $message, $headers);
}
function maybe_notify_user($meta_id, $user_id, $meta_key, $meta_value) {
    if ($meta_key == 'is_approved' && $meta_value == 1) {
        notify_user_approval($user_id);
    }
}
add_action('updated_user_meta', 'maybe_notify_user', 10, 4);

// Step 8: Make Approval Status column sortable
function make_approval_column_sortable($columns) {
    $columns['approval_status'] = 'approval_status';
    return $columns;
}
add_filter('manage_users_sortable_columns', 'make_approval_column_sortable');

// Step 9: Handle sorting logic
function approval_status_orderby($query) {
    if (!is_admin()) {
        return;
    }

    $orderby = $query->get('orderby');
    if ($orderby == 'approval_status') {
        $query->set('meta_key', 'is_approved');
        $query->set('orderby', 'meta_value');
    }
}
add_action('pre_get_users', 'approval_status_orderby');

// Step 10: Add "Pending" filter to Users list in admin
function add_pending_filter_to_users($views) {
    $pending_count = count_users_by_meta_key('is_approved', '0');
    $current = (isset($_GET['is_approved']) && $_GET['is_approved'] === 'pending') ? 'current' : '';
    $views['pending'] = '<a href="' . admin_url('users.php?is_approved=pending') . '" class="' . $current . '">'
        . __('Pending') . ' <span class="count">(' . $pending_count . ')</span></a>';
    return $views;
}
add_filter('views_users', 'add_pending_filter_to_users');

// Step 11: Filter users by "Pending" status in admin
function filter_users_by_pending_status($query) {
    if (is_admin() && isset($_GET['is_approved']) && $_GET['is_approved'] === 'pending') {
        $query->set('meta_key', 'is_approved');
        $query->set('meta_value', '0');
    }
}
add_action('pre_get_users', 'filter_users_by_pending_status');

// Step 12: Helper function to count users by meta key/value
function count_users_by_meta_key($meta_key, $meta_value) {
    global $wpdb;
    $query = $wpdb->prepare("
        SELECT COUNT(*)
        FROM $wpdb->usermeta
        WHERE meta_key = %s AND meta_value = %s
    ", $meta_key, $meta_value);
    return (int) $wpdb->get_var($query);
}