<?php
/** Safe aggregate visibility for outbox events requiring operator review. */
if (!defined('ABSPATH')) {
    exit;
}
class Akkedli_V2_Outbox_Review
{
    public static function count()
    {
        global $wpdb;
        try {
            if (!Akkedli_V2_Outbox_Schema::ready()) return 0;
            $wpdb->flush();
            $count = $wpdb->get_var(
                'SELECT COUNT(*) FROM ' . Akkedli_V2_Outbox_Schema::table()
                . " WHERE (state='exhausted' AND envelope IS NOT NULL)
                    OR (state='rejected' AND last_outcome IN ('delivery_invalid','authority_lost'))"
            );
            if (!property_exists($wpdb, 'last_error') || '' !== (string) $wpdb->last_error
                || !is_numeric($count)) return 0;
            return max(0, (int) $count);
        } catch (Throwable $error) {
            unset($error);
            return 0;
        }
    }
}