bot-28/tests/Integration/AdminRealtimeTest.php

<?php

namespace Tests\Integration;

use App\Http\Controllers\admin\PaymentOrder as PaymentOrderController;
use App\Http\Controllers\admin\Withdraw as WithdrawController;
use App\Models\PaymentOrder;
use App\Models\User;
use App\Models\Withdraw;
use App\Services\AdminRealtime\AdminRealtime;
use App\Services\AdminRealtime\AdminRealtimeExchangeList;
use App\Services\AdminRealtime\AdminRealtimeFeed;
use App\Services\AdminRealtime\AdminRealtimeRows;
use App\Services\AdminRealtime\AdminRealtimeAccess;
use App\Services\JwtService;
use App\Http\Controllers\admin\Realtime as RealtimeController;
use Illuminate\Broadcasting\BroadcastManager;
use Illuminate\Contracts\Broadcasting\Factory as BroadcastingFactory;
use Carbon\Carbon;
use Illuminate\Cache\ArrayStore;
use Illuminate\Cache\Repository as CacheRepository;
use Illuminate\Config\Repository;
use Illuminate\Database\Capsule\Manager;
use Illuminate\Database\DatabaseTransactionsManager;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Events\Dispatcher;
use Illuminate\Foundation\Application;
use Illuminate\Http\JsonResponse;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Facade;
use Illuminate\Support\Facades\Schema;
use Illuminate\Translation\ArrayLoader;
use Illuminate\Translation\Translator;
use Illuminate\Validation\Factory;
use PHPUnit\Framework\TestCase;
use Illuminate\Support\Facades\Broadcast;
use Symfony\Component\Console\Tester\CommandTester;

class AdminRealtimeTest extends TestCase
{
    private Application $app;
    private object $log;

    protected function setUp(): void
    {
        Carbon::setTestNow(Carbon::parse('2026-10-31 10:00:00', 'Asia/Shanghai'));
        Facade::clearResolvedInstances();
        Model::clearBootedModels();
        $this->app = new Application(dirname(__DIR__, 2));
        $this->app->instance('config', new Repository([
            'app' => ['locale' => 'zh', 'timezone' => 'Asia/Shanghai'],
            'admin_realtime' => ['enabled' => true, 'connection' => 'reverb', 'batch_size' => 200, 'gap_seconds' => 60, 'replay_limit' => 1000,
                'permission_cache_seconds' => 60, 'online_scan_seconds' => 15, 'retention_hours' => 72],
        ]));
        Facade::setFacadeApplication($this->app);
        $events = new Dispatcher($this->app); $this->app->instance('events', $events);
        $db = new Manager($this->app); $db->addConnection(['driver' => 'sqlite', 'database' => ':memory:', 'prefix' => 'bot_']);
        $db->setEventDispatcher($events); $db->setAsGlobal(); $db->bootEloquent();
        $db->getConnection()->setTransactionManager(new DatabaseTransactionsManager());
        $this->app->instance('db', $db->getDatabaseManager());
        $this->app->bind('db.schema', fn () => $db->schema());
        $translator = new Translator(new ArrayLoader(), 'zh'); $this->app->instance('translator', $translator);
        $this->app->instance('validator', new Factory($translator, $this->app));
        $this->log = new class {
            public array $records = [];
            public function channel($name = null) { return $this; }
            public function __call($level, $args) { $this->records[] = [$level, $args[0] ?? '']; }
        };
        $this->app->instance('log', $this->log);
        $this->app->instance('cache', new CacheRepository(new ArrayStore()));
        $this->app->instance(\Illuminate\Contracts\Routing\ResponseFactory::class, new \Tests\Support\JsonResponseFactory());
        Request::macro('validate', function (array $rules) { return app('validator')->make($this->all(), $rules)->validate(); });
        $this->app->instance('request', Request::create('/admin/realtime/events', 'GET'));

        (require dirname(__DIR__, 2) . '/database/migrations/2026_10_31_160000_create_admin_realtime_events.php')->up();
        (require dirname(__DIR__, 2) . '/database/migrations/2026_10_31_210000_add_seq_to_admin_realtime_events.php')->up();
        (require dirname(__DIR__, 2) . '/database/migrations/2026_11_01_000000_add_delivery_state_to_admin_realtime_events.php')->up();
        Schema::create('users', function (Blueprint $t) {
            $t->id(); $t->string('member_id'); $t->string('user_id')->default(''); $t->string('account')->nullable(); $t->string('first_name')->default('');
            $t->string('admin_note')->nullable(); $t->string('language')->nullable(); $t->integer('recharge_channel_group_id')->nullable(); $t->string('real_name', 64)->nullable(); $t->timestamps();
        });
        Schema::create('withdraws', function (Blueprint $t) {
            $t->id(); $t->string('member_id'); $t->decimal('amount', 20, 10)->default(0); $t->decimal('service_charge', 20, 10)->default(0);
            $t->decimal('to_account', 20, 10)->default(0); $t->string('address')->default(''); $t->decimal('exchange_rate', 20, 10)->default(0);
            $t->integer('status')->default(0); $t->decimal('after_balance', 20, 10)->default(0); $t->string('remark')->nullable();
            $t->string('admin_note')->nullable(); $t->integer('is_locked')->default(0); $t->integer('is_send')->default(0); $t->timestamps();
        });
        DB::table('users')->insert(['member_id' => '9001', 'user_id' => 'u9001', 'first_name' => 'Alice', 'admin_note' => 'vip', 'real_name' => '王小明']);
    }

    protected function tearDown(): void { Carbon::setTestNow(); DB::disconnect(); Model::unsetEventDispatcher(); Model::clearBootedModels(); Facade::clearResolvedInstances(); parent::tearDown(); }

    private function events(): array
    {
        return DB::table('admin_realtime_events')->orderBy('id')->get()->map(fn ($r) => "{$r->resource}:{$r->resource_id}:{$r->action}")->all();
    }

    private function consume(int $cursor): array
    {
        $batch = AdminRealtimeFeed::next($cursor);
        AdminRealtimeFeed::acknowledge($batch['ids']);
        return $batch;
    }

    public function test_exchange_list_changes_coalesce_and_can_be_replayed(): void
    {
        Schema::create('admin_exchange_list_changes', fn (Blueprint $table) => $table->id());
        $changes = DB::table('admin_exchange_list_changes');
        $changes->insert([['id' => 2], ['id' => 3]]);

        $batch = AdminRealtimeFeed::next(0);
        $this->assertCount(1, $batch['events']);
        $event = $batch['events'][0];
        $this->assertSame(AdminRealtimeExchangeList::CHANNEL, $event['channel']);
        $this->assertSame('exchange_list.updated', $event['event']);
        $this->assertSame(['scope' => 'all'], $event['key']);
        $this->assertNull($event['data']);
        $broadcast = new \App\Events\AdminRealtimeBroadcast($event);
        $this->assertSame('private-admin.operation.exchange_list', $broadcast->broadcastOn()[0]->name);
        $this->assertSame($event['event'], $broadcast->broadcastAs());
        $this->assertSame(0, $changes->count());
        $this->assertSame($batch, AdminRealtimeFeed::next($batch['cursor']));
        AdminRealtimeFeed::acknowledge($batch['ids']);

        // An earlier buffer ID can become visible after a later ID has been broadcast.
        $changes->insert(['id' => 1]);
        $second = $this->consume($batch['cursor']);
        $this->assertCount(1, $second['events']);
        $this->assertSame($second['events'], AdminRealtimeFeed::replay($event['seq'], [$event['channel']])['events']);
        $this->assertSame([], AdminRealtimeFeed::replay(0, ['admin.users'])['events']);
        $this->assertSame([], $this->consume($second['cursor'])['events']);
    }

    public function test_record_waits_for_commit_and_drops_on_rollback(): void
    {
        AdminRealtime::record('withdraws', 1);
        $this->assertSame(['withdraws:1:updated'], $this->events());

        DB::beginTransaction();
        AdminRealtime::record('withdraws', [2, 2, 3], 'created');
        $this->assertCount(1, $this->events(), '事务内不写入');
        DB::commit();
        $this->assertSame(['withdraws:1:updated', 'withdraws:2:created', 'withdraws:3:created'], $this->events());

        DB::beginTransaction();
        AdminRealtime::record('withdraws', 4);
        DB::rollBack();
        $this->assertCount(3, $this->events(), '回滚后丢弃');

        $this->app['config']->set('admin_realtime.enabled', false);
        AdminRealtime::record('withdraws', 5);
        $this->assertCount(3, $this->events(), '关闭时不登记');
    }

    public function test_record_failure_never_breaks_business_transaction(): void
    {
        Schema::drop('admin_realtime_events');
        DB::transaction(function () {
            Withdraw::create(['member_id' => '9001', 'amount' => 10]);
        });
        $this->assertSame(1, Withdraw::count(), '事件表缺失也不影响主业务');
        $this->assertSame('error', $this->log->records[0][0] ?? null);
    }

    public function test_model_hooks_capture_orders_and_new_users_only(): void
    {
        $withdraw = Withdraw::create(['member_id' => '9001', 'amount' => 10]);
        $withdraw->update(['is_send' => 1]);
        $withdraw->update(['status' => 1]);
        $user = User::query()->create(['member_id' => '9002', 'first_name' => 'Bob']);
        $user->first_name = 'Bobby'; $user->save();
        $withdraw->delete();

        $this->assertSame([
            "withdraws:{$withdraw->id}:created", "withdraws:{$withdraw->id}:updated",
            "users:{$user->id}:created", "withdraws:{$withdraw->id}:deleted",
        ], $this->events());
    }

    public function test_agent_application_audit_lists_push_rows_and_member_submissions(): void
    {
        Schema::create('agents', function (Blueprint $t) {
            $t->id(); $t->integer('type')->default(1); $t->string('username'); $t->string('real_name')->default('');
            $t->decimal('balance', 20, 4)->default(0); $t->decimal('margin_amount', 20, 4)->default(0);
        });
        // 用真实迁移建表：Eloquent 按模型类缓存可批量赋值的列，手写缺列的表会影响后续测试
        foreach (['2026_10_29_140000_create_agent_applications.php', '2026_11_08_150000_add_type_to_agent_applications.php'] as $file) {
            (require dirname(__DIR__, 2) . '/database/migrations/' . $file)->up();
        }
        Schema::create('agent_profit_commission_profiles', function (Blueprint $t) { $t->id(); $t->string('name'); $t->unsignedBigInteger('owner_agent_id')->nullable(); $t->timestamps(); });
        Schema::create('agent_plan_applications', function (Blueprint $t) {
            $t->id(); $t->unsignedBigInteger('agent_id'); $t->unsignedBigInteger('profile_id'); $t->string('profile_name')->default('');
            $t->string('status')->default('pending'); $t->string('remark')->default(''); $t->string('reject_reason')->default('');
            $t->unsignedBigInteger('reviewed_by')->nullable(); $t->dateTime('reviewed_at')->nullable(); $t->timestamps();
        });
        DB::table('agent_applications')->insert(['user_id' => 1, 'username' => 'old']);
        $this->consume(0); // 首轮只记下游标，不补推历史申请
        $this->assertSame([], $this->events());

        // 会员前台（melbet_sport-api）直接插表
        DB::table('agent_applications')->insert(['user_id' => 1, 'username' => 'newagent', 'type' => 2, 'created_at' => '2026-10-31 10:00:00']);
        DB::table('agents')->insert(['id' => 5, 'username' => 'joint5']);
        DB::table('agent_profit_commission_profiles')->insert(['id' => 3, 'name' => 'A方案']);
        $plan = \App\Models\Agent\AgentPlanApplication::create(['agent_id' => 5, 'profile_id' => 3, 'profile_name' => 'A方案', 'status' => 'pending']);
        $batch = $this->consume(0);
        $events = collect($batch['events'])->keyBy('channel');
        $app = $events['admin.agents.applications'];
        $this->assertSame(['application.created', 'created', ['id' => 2], 'melbet_sport-api'], [$app['event'], $app['action'], $app['key'], $app['source']]);
        $this->assertSame('9001', $app['data']['member_id']);
        $this->assertSame('入股', $app['data']['type_text']);
        $this->assertSame(['application.created', ['id' => $plan->id]], [$events['admin.agents.plan_applications']['event'], $events['admin.agents.plan_applications']['key']]);
        $this->assertSame('joint5', $events['admin.agents.plan_applications']['data']['agent']['username']);
        $this->assertSame('待审核', $events['admin.agents.plan_applications']['data']['status_text']);

        // 后台审核（经模型）推 updated
        \App\Models\Agent\AgentApplication::find(2)->update(['status' => 'rejected', 'reject_reason' => 'no']);
        $plan->update(['status' => 'approved', 'reviewed_by' => 1]);
        $updated = collect($this->consume($batch['cursor'])['events'])->keyBy('channel');
        $this->assertSame(['application.updated', 'rejected'], [$updated['admin.agents.applications']['event'], $updated['admin.agents.applications']['data']['status']]);
        $this->assertSame('已通过', $updated['admin.agents.plan_applications']['data']['status_text']);

        $channels = AdminRealtimeAccess::allowedChannels(1);
        $this->assertContains('admin.agents.applications', $channels);
        $this->assertContains('admin.agents.plan_applications', $channels);
    }

    public function test_feed_resolves_rows_with_the_list_endpoint_shape(): void
    {
        $this->assertSame(0, AdminRealtimeFeed::startCursor());
        $this->assertSame(['cursor' => 0, 'ids' => [], 'events' => [], 'has_more' => false], $this->consume(0));

        $withdraw = Withdraw::create(['member_id' => '9001', 'amount' => 12.5, 'to_account' => 12.5]);
        $withdraw->update(['status' => 1]);
        Withdraw::create(['member_id' => '9001', 'amount' => 3]);
        $result = $this->consume(0);

        $this->assertSame(3, $result['cursor']);
        $this->assertSame([1, 2, 3], DB::table('admin_realtime_events')->orderBy('id')->pluck('seq')->map(fn ($v) => (int) $v)->all());
        $this->assertCount(2, $result['events'], '同一记录一批内合并');
        $first = $result['events'][0];
        $this->assertSame(['seq' => 2, 'id' => 2, 'channel' => 'admin.orders.withdraw', 'event' => 'order.created', 'action' => 'created', 'key' => ['id' => 1]],
            array_intersect_key($first, array_flip(['seq', 'id', 'channel', 'event', 'action', 'key'])));

        $listRequest = Request::create('/admin/withdraw', 'GET');
        $this->app->instance('request', $listRequest);
        $list = (new WithdrawController())->index()->getData(true)['data']['data'];
        $row = collect($list)->firstWhere('id', 1);
        $this->assertSame($row, $first['data'], '推送行与列表接口返回的行一致');
        $this->assertSame('Alice', $first['data']['first_name']);
        $this->assertSame('王小明', $first['data']['real_name']);
        $this->assertSame(1, $first['data']['status']);

        $withdraw->delete();
        $deleted = $this->consume(3)['events'];
        $this->assertSame([['seq' => 4, 'channel' => 'admin.orders.withdraw', 'action' => 'deleted', 'key' => ['id' => 1], 'data' => null]],
            array_map(fn ($e) => array_intersect_key($e, array_flip(['seq', 'channel', 'action', 'key', 'data'])), $deleted));
        $this->assertSame(4, AdminRealtimeFeed::startCursor(), '重启后从上次广播到的 id 继续');
        $this->assertNotEmpty(array_filter($this->log->records, fn ($r) => $r[1] === 'admin_realtime_online_scan_failed'),
            'SQLite 不支持在线判定 SQL，扫描失败只记日志不影响广播');
    }

    public function test_withdrawal_lists_filter_by_member_real_name_and_keep_legacy_rows(): void
    {
        Schema::create('payment_orders', function (Blueprint $t) {
            $t->id(); $t->integer('type'); $t->string('member_id'); $t->decimal('amount', 20, 2);
            $t->integer('status')->default(0); $t->string('account'); $t->string('bank_name'); $t->string('card_no'); $t->timestamps();
        });
        DB::table('users')->insert(['member_id' => '9002', 'account' => 'legacy', 'first_name' => '王小明']);
        foreach (['9001', '9002'] as $memberId) {
            DB::table('withdraws')->insert(['member_id' => $memberId, 'amount' => 10]);
            foreach ([2, 4] as $type) {
                DB::table('payment_orders')->insert(['type' => $type, 'member_id' => $memberId, 'amount' => 10,
                    'account' => '历史收款人', 'bank_name' => '银行', 'card_no' => '1234']);
            }
        }

        $controller = new WithdrawController();
        foreach ([['index', '/admin/withdraw', []], ['rmb', '/admin/withdraw/rmb', ['type' => 2]], ['rmb', '/admin/withdraw/rmb', ['type' => 4]]] as [$method, $path, $filters]) {
            $this->app->instance('request', Request::create($path, 'GET', $filters));
            $all = $controller->{$method}()->getData(true)['data'];
            $this->assertSame(2, $all['total']);
            $this->assertNull(collect($all['data'])->firstWhere('member_id', '9002')['real_name']);

            $this->app->instance('request', Request::create($path, 'GET', $filters + ['real_name' => ' 小明 ']));
            $filtered = $controller->{$method}()->getData(true)['data'];
            $this->assertSame(1, $filtered['total']);
            $this->assertSame(['9001'], array_column($filtered['data'], 'member_id'));
            $this->assertSame('王小明', $filtered['data'][0]['real_name']);
            if ($method === 'rmb') {
                $this->assertSame('历史收款人', $filtered['data'][0]['recipient_name']);
            }
        }
    }

    public function test_manual_recharge_orders_push_to_the_payment_order_channel(): void
    {
        Schema::create('payment_orders', function (Blueprint $t) {
            $t->id(); $t->integer('type'); $t->string('order_no')->default(''); $t->string('member_id'); $t->decimal('amount', 20, 2)->default(0);
            $t->decimal('fee', 20, 2)->default(0); $t->string('channel')->default(''); $t->integer('payment_type')->default(0); $t->integer('status')->default(0);
            $t->text('pay_data')->nullable(); $t->string('remark')->nullable(); $t->text('recharge_bonus_snapshot')->nullable();
            $t->integer('is_send')->default(0); $t->integer('is_locked')->default(0); $t->timestamps();
        });
        $order = PaymentOrder::create(['type' => 3, 'order_no' => 'rgcz_1', 'member_id' => '9001', 'amount' => 50, 'channel' => 'rgcz',
            'payment_type' => 1, 'status' => 0, 'recharge_bonus_snapshot' => null]);
        $order->update(['status' => 5]);

        $events = $this->consume(0)['events'];
        $this->assertSame([['channel' => 'admin.orders.payment', 'action' => 'created', 'key' => ['id' => 1]]],
            array_map(fn ($e) => array_intersect_key($e, array_flip(['channel', 'action', 'key'])), $events), '人工充值只推「代收订单」频道');

        $this->app->instance('request', Request::create('/admin/paymentOrder', 'GET', ['channel' => 'rgcz']));
        $list = (new PaymentOrderController())->index()->getData(true)['data']['data'];
        $this->assertSame(collect($list)->firstWhere('id', 1), $events[0]['data'], '推送行与人工充值审查列表的行一致');
        $this->assertSame(5, $events[0]['data']['status']);
    }

    public function test_an_event_that_cannot_be_resolved_does_not_block_the_manual_recharge_push(): void
    {
        Schema::create('payment_orders', function (Blueprint $t) {
            $t->id(); $t->integer('type'); $t->string('order_no')->default(''); $t->string('member_id'); $t->decimal('amount', 20, 2)->default(0);
            $t->decimal('fee', 20, 2)->default(0); $t->string('channel')->default(''); $t->integer('payment_type')->default(0); $t->integer('status')->default(0);
            $t->text('pay_data')->nullable(); $t->string('remark')->nullable(); $t->text('recharge_bonus_snapshot')->nullable();
            $t->integer('is_send')->default(0); $t->integer('is_locked')->default(0); $t->timestamps();
        });
        // third_game_orders has no table here, so resolving this event throws.
        AdminRealtime::record('third_game_orders', 1, 'created');
        PaymentOrder::create(['type' => 3, 'order_no' => 'rgcz_1', 'member_id' => '9001', 'amount' => 50, 'channel' => 'rgcz',
            'payment_type' => 1, 'status' => 0, 'recharge_bonus_snapshot' => null]);

        $batch = $this->consume(0);
        $this->assertSame([['channel' => 'admin.orders.payment', 'action' => 'created', 'key' => ['id' => 1]]],
            array_map(fn ($e) => array_intersect_key($e, array_flip(['channel', 'action', 'key'])), $batch['events']));
        $this->assertContains(['error', 'admin_realtime_resolve_failed'], $this->log->records);
        $this->assertSame([], $this->consume($batch['cursor'])['events'], '失败事件已确认，不会反复重试');
    }

    public function test_feed_delivers_late_commits_with_a_later_seq(): void
    {
        $insert = fn (int $id, string $at) => DB::table('admin_realtime_events')->insert([
            'id' => $id, 'resource' => 'withdraws', 'resource_id' => (string) $id, 'action' => 'deleted', 'source' => 'melbet', 'created_at' => $at,
        ]);
        $insert(1, '2026-10-31 09:59:59');
        $insert(3, '2026-10-31 09:59:59');
        $this->assertSame([1, 3], array_column($this->consume(0)['events'], 'id'));

        $insert(2, '2026-10-31 09:59:30');
        $insert(4, '2026-10-31 09:58:00');
        $insert(5, '2026-10-31 09:58:00');
        $batch = $this->consume(3);
        $this->assertSame([[3, 2], [4, 4], [5, 5]], array_map(fn ($e) => [$e['seq'], $e['id']], $batch['events']),
            '游标之前晚提交的 id 仍会广播，seq 按广播先后递增');
        $this->assertSame(5, $batch['cursor']);

        $insert(6, '2026-10-31 10:00:00');
        $insert(7, '2026-10-31 10:00:00');
        DB::table('admin_realtime_events')->where('id', 6)->delete();
        $this->consume(5);
        $insert(6, '2026-10-31 09:58:00');
        $this->assertSame([], $this->consume(7)['events'], '超过 gap_seconds 的晚提交不再补发');
    }

    public function test_replay_by_seq_filters_channels_and_requests_resync(): void
    {
        $withdraw = Withdraw::create(['member_id' => '9001', 'amount' => 1]);
        Withdraw::create(['member_id' => '9001', 'amount' => 2]);
        AdminRealtime::record('sport_order', 99, 'deleted');
        $withdraw->delete();
        $this->consume(0);
        $this->assertSame(4, AdminRealtimeFeed::lastSeq());

        $replay = AdminRealtimeFeed::replay(1, ['admin.orders.withdraw']);
        $this->assertFalse($replay['resync']);
        $this->assertSame(4, $replay['last_seq']);
        $this->assertSame([[2, 'order.created'], [4, 'order.deleted']], array_map(fn ($e) => [$e['seq'], $e['event']], $replay['events']),
            '只返回请求的频道，并按当前数据解析');
        $this->assertSame([], AdminRealtimeFeed::replay(4, ['admin.orders.withdraw'])['events']);
        $this->assertSame('invalid_cursor', AdminRealtimeFeed::replay(9, ['admin.orders.withdraw'])['reason']);

        $this->app['config']->set('admin_realtime.replay_limit', 2);
        $this->assertSame('too_many_events', AdminRealtimeFeed::replay(0, ['admin.orders.withdraw'])['reason']);

        DB::table('admin_realtime_events')->where('seq', 1)->delete();
        $this->assertSame('history_unavailable', AdminRealtimeFeed::replay(1, ['admin.orders.withdraw'])['reason'], '游标已被清理时重新拉列表');
    }

    public function test_channel_auth_signs_session_user_for_reverb(): void
    {
        $this->bindBroadcasting();
        Schema::create('admin', function (Blueprint $t) { $t->id(); $t->string('username'); $t->timestamps(); });
        DB::table('admin')->insert(['id' => 1, 'username' => 'root']);
        $exp = time() + 3600;
        $token = \Firebase\JWT\JWT::encode(['iat' => time(), 'exp' => $exp, 'sub' => 1, 'user_id' => 1], str_repeat('k', 32), 'HS256');

        $call = function (?string $token, string $channel) {
            $request = Request::create('/admin/broadcasting/auth', 'POST', ['socket_id' => '123.456', 'channel_name' => $channel]);
            if ($token) $request->headers->set('Authorization', 'Bearer ' . $token);
            $this->app->instance('request', $request);
            return (new RealtimeController())->auth(new \App\Services\AdminJwtSession(new JwtService()));
        };

        $response = $call($token, 'private-admin.orders.withdraw');
        $this->assertSame(200, $response->getStatusCode());
        $body = $response->getData(true);
        $this->assertSame(['user_id' => "1:{$exp}"], json_decode($body['channel_data'], true));
        // 与 Reverb 校验私有频道的签名算法一致（InteractsWithPrivateChannels::verify）
        $this->assertSame('app-key:' . hash_hmac('sha256', "123.456:private-admin.orders.withdraw:{$body['channel_data']}", 'app-secret'), $body['auth']);

        $this->assertSame(401, $call(null, 'private-admin.orders.withdraw')->getStatusCode());
        $this->assertSame(401, $call($token . 'x', 'private-admin.orders.withdraw')->getStatusCode());
        $this->assertSame(403, $call($token, 'private-admin.orders.unknown')->getStatusCode());
        $this->assertSame(403, $call($token, 'admin.orders.withdraw')->getStatusCode(), '只授权私有频道');
        $this->assertSame(array_keys(AdminRealtimeRows::CHANNELS), AdminRealtimeAccess::allowedChannels(1));
        DB::table('admin')->insert(['id' => 2, 'username' => 'limited']);
        $this->app['cache']->put('admin_realtime:channels:2', ['admin.users'], 60);
        $limited = \Firebase\JWT\JWT::encode(['iat' => time(), 'exp' => $exp, 'sub' => 2, 'user_id' => 2], str_repeat('k', 32), 'HS256');
        foreach (['admin.stats.platform_count', 'admin.stats.unprocessed', AdminRealtimeExchangeList::CHANNEL] as $statsChannel) {
            $this->assertSame(200, $call($token, 'private-' . $statsChannel)->getStatusCode());
            $this->assertSame(403, $call($limited, 'private-' . $statsChannel)->getStatusCode(), '统计频道也必须校验管理员权限');
        }
    }

    public function test_failed_termination_retries_without_affecting_a_newer_login(): void
    {
        $pusher = $this->fakePusher();
        $expired = time() - 10;
        $future = time() + 600;
        AdminRealtimeAccess::authorize(7, $expired, 'private-admin.orders.withdraw', '1.1');
        AdminRealtimeAccess::authorize(7, $expired, 'private-admin.users', '1.1');
        AdminRealtimeAccess::authorize(7, $future, 'private-admin.users', '2.2');
        $pusher->fail = true;
        $this->assertSame([], AdminRealtimeAccess::terminateExpiredSessions());
        $this->assertArrayHasKey("7:{$expired}", $this->app['cache']->get('admin_realtime:sessions'));
        $pusher->fail = false;
        // 模拟发出 HTTP 请求期间有另一个管理员完成授权；合并清理不能覆盖它。
        $pusher->onTerminate = static fn() => AdminRealtimeAccess::authorize(8, $future, 'private-admin.users', '3.3');
        $this->assertSame(["7:{$expired}"], AdminRealtimeAccess::terminateExpiredSessions());
        $this->assertSame([], AdminRealtimeAccess::terminateExpiredSessions(), '已断开的会话不重复处理');
        $this->assertSame(["7:{$expired}", "7:{$expired}"], $pusher->attempts);
        $this->assertSame(["7:{$future}" => $future, "8:{$future}" => $future], $this->app['cache']->get('admin_realtime:sessions'));
        $this->assertNotEmpty(array_filter($this->log->records, fn ($r) => $r[1] === 'admin_realtime_terminate_failed'),
            'Reverb 不可达时只记日志');
    }

    public function test_session_registration_failure_denies_channel_authorization(): void
    {
        $this->fakePusher();
        $this->app->instance('cache', new CacheRepository(new class extends ArrayStore {
            public function forever($key, $value) { return false; }
        }));
        Facade::clearResolvedInstance('cache');
        $this->expectException(\RuntimeException::class);
        $this->expectExceptionMessage('登记后台推送会话失败');
        AdminRealtimeAccess::authorize(7, time() + 600, 'private-admin.users', '1.1');
    }

    public function test_session_without_expiry_cannot_be_authorized(): void
    {
        $this->fakePusher();
        $this->expectException(\RuntimeException::class);
        AdminRealtimeAccess::authorize(7, null, 'private-admin.users', '1.1');
    }

    public function test_delayed_expired_subscription_is_rejected_using_verified_metadata(): void
    {
        $connection = $this->reverbConnection();
        $application = $connection->app();
        $subscription = new \Laravel\Reverb\Protocols\Pusher\Channels\ChannelConnection($connection, ['user_id' => '7:' . (time() - 10)]);
        $channel = $this->createMock(\Laravel\Reverb\Protocols\Pusher\Channels\Channel::class);
        $channel->method('find')->with($connection)->willReturn($subscription);
        $manager = $this->createMock(\Laravel\Reverb\Protocols\Pusher\Contracts\ChannelManager::class);
        $manager->method('for')->with($application)->willReturnSelf();
        $manager->method('find')->with('private-admin.users')->willReturn($channel);
        $this->app->instance(\Laravel\Reverb\Protocols\Pusher\Contracts\ChannelManager::class, $manager);
        $listener = new \App\Listeners\RejectExpiredAdminRealtimeSubscription();
        // 客户端伪造的未来时间不能替代 Reverb 已验签的过期订阅数据。
        $listener->handle(new \Laravel\Reverb\Events\MessageReceived($connection, json_encode([
            'event' => 'pusher:subscribe', 'data' => ['channel' => 'private-admin.users', 'channel_data' => json_encode(['user_id' => '7:' . (time() + 600)])],
        ])));
        $this->assertSame(1, $connection->disconnects);
    }

    public function test_valid_subscription_remains_connected(): void
    {
        $connection = $this->reverbConnection();
        $subscription = new \Laravel\Reverb\Protocols\Pusher\Channels\ChannelConnection($connection, ['user_id' => '7:' . (time() + 600)]);
        $channel = $this->createStub(\Laravel\Reverb\Protocols\Pusher\Channels\Channel::class);
        $channel->method('find')->willReturn($subscription);
        $manager = $this->createStub(\Laravel\Reverb\Protocols\Pusher\Contracts\ChannelManager::class);
        $manager->method('for')->willReturnSelf();
        $manager->method('find')->willReturn($channel);
        $this->app->instance(\Laravel\Reverb\Protocols\Pusher\Contracts\ChannelManager::class, $manager);
        (new \App\Listeners\RejectExpiredAdminRealtimeSubscription())->handle(new \Laravel\Reverb\Events\MessageReceived($connection,
            json_encode(['event' => 'pusher:subscribe', 'data' => json_encode(['channel' => 'private-admin.users'])])));
        $this->assertSame(0, $connection->disconnects);
    }

    public function test_mixed_session_identities_cannot_hide_an_expiring_channel_on_the_same_socket(): void
    {
        $this->app->bind(\Laravel\Reverb\Protocols\Pusher\Contracts\ChannelConnectionManager::class,
            \Laravel\Reverb\Protocols\Pusher\Managers\ArrayChannelConnectionManager::class);
        $manager = new \Laravel\Reverb\Protocols\Pusher\Managers\ArrayChannelManager();
        $this->app->instance(\Laravel\Reverb\Protocols\Pusher\Contracts\ChannelManager::class, $manager);
        $mixed = $this->reverbConnection('1.1');
        $newer = $this->reverbConnection('2.2');
        $later = time() + 600;
        $earlier = time() + 60;
        $subscribe = function ($connection, string $name, int $expires) use ($manager): void {
            $data = json_encode(['user_id' => "7:{$expires}"]);
            $auth = 'key:' . hash_hmac('sha256', "{$connection->id()}:{$name}:{$data}", 'secret');
            $manager->for($connection->app())->findOrCreate($name)->subscribe($connection, $auth, $data);
            (new \App\Listeners\RejectExpiredAdminRealtimeSubscription())->handle(new \Laravel\Reverb\Events\MessageReceived($connection,
                json_encode(['event' => 'pusher:subscribe', 'data' => ['channel' => $name]])));
        };
        $subscribe($mixed, 'private-admin.users', $later);
        $subscribe($mixed, 'private-admin.orders.withdraw', $earlier);
        $this->assertSame("7:{$later}", $manager->connections()['1.1']->data('user_id'), '真实 Reverb 管理器只保留首个 user_id');
        $this->assertSame(1, $mixed->disconnects, '不同到期时间不能共用同一 socket');
        $subscribe($newer, 'private-admin.users', $later);
        $subscribe($newer, 'private-admin.orders.withdraw', $later);
        $this->assertSame(0, $newer->disconnects, '独立的新登录及同一会话的多个频道保持有效');
    }

    private function reverbConnection(string $id = '1.1'): \Laravel\Reverb\Contracts\Connection
    {
        return new class($id) extends \Laravel\Reverb\Contracts\Connection {
            public int $disconnects = 0;
            public function __construct(private string $socketId) { $this->application = new \Laravel\Reverb\Application('app', 'key', 'secret', 60, 30, ['*'], 10000); }
            public function identifier(): string { return $this->socketId; }
            public function id(): string { return $this->socketId; }
            public function send(string $message): void {}
            public function control(string $type = '9'): void {}
            public function terminate(): void { $this->disconnects++; }
        };
    }

    public function test_broadcast_failure_is_retried_in_order_after_relay_restart(): void
    {
        $broadcaster = new class {
            public bool $fail = true;
            public array $attempts = [];
            public function queue($event) {
                $this->attempts[] = $event->message['seq'];
                if ($this->fail && $event->message['seq'] === 2) throw new \RuntimeException('temporary publish failure');
            }
        };
        Broadcast::swap($broadcaster);
        AdminRealtime::record('withdraws', [77, 88, 99], 'deleted');
        $run = function (): int {
            $command = new \App\Console\Commands\RelayAdminRealtimeEvents();
            $command->setLaravel($this->app);
            // 隔离测试不启动 ConsoleKernel，只验证命令投递状态；不注册进程信号。
            $previous = (new \ReflectionProperty(\Illuminate\Console\Signals::class, 'availabilityResolver'))->getValue();
            \Illuminate\Console\Signals::resolveAvailabilityUsing(static fn() => false);
            try {
                return (new CommandTester($command))->execute(['--once' => true]);
            } finally {
                \Illuminate\Console\Signals::resolveAvailabilityUsing($previous);
            }
        };
        $this->assertSame(1, $run());
        $this->assertSame([1, 2], $broadcaster->attempts, '失败后不能发送更大的 seq');
        $this->assertSame(3, DB::table('admin_realtime_events')->whereNull('published_at')->count());
        $broadcaster->fail = false;
        $this->assertSame(0, $run());
        $this->assertSame([1, 2, 1, 2, 3], $broadcaster->attempts, '新进程恢复未确认批次，允许重复但不丢失');
        $this->assertSame(0, DB::table('admin_realtime_events')->whereNull('published_at')->count());
        $this->assertSame(0, $run());
        $this->assertSame([1, 2, 1, 2, 3], $broadcaster->attempts);
    }

    public function test_pruning_all_history_never_reuses_seq_and_keeps_pending_delivery(): void
    {
        AdminRealtime::record('withdraws', 77, 'deleted');
        $first = $this->consume(0);
        DB::table('admin_realtime_events')->update(['created_at' => '2026-10-27 00:00:00']);
        $this->assertSame(1, AdminRealtimeFeed::prune());
        $this->assertSame(1, AdminRealtimeFeed::lastSeq());
        AdminRealtime::record('withdraws', 88, 'deleted');
        $second = AdminRealtimeFeed::next(AdminRealtimeFeed::startCursor());
        $this->assertSame(2, $second['events'][0]['seq']);
        $this->assertSame('history_unavailable', AdminRealtimeFeed::replay($first['events'][0]['seq'], ['admin.orders.withdraw'])['reason']);
        DB::table('admin_realtime_events')->update(['created_at' => '2026-10-27 00:00:00']);
        $this->assertSame(0, AdminRealtimeFeed::prune(), '待发送批次即使超期也不能清理');
        $retry = AdminRealtimeFeed::next(AdminRealtimeFeed::startCursor());
        $this->assertSame($second['ids'], $retry['ids']);
        $this->assertSame(array_column($second['events'], 'seq'), array_column($retry['events'], 'seq'));
        AdminRealtimeFeed::acknowledge($second['ids']);
        $this->assertSame(1, AdminRealtimeFeed::prune());
        $this->assertSame(2, AdminRealtimeFeed::lastSeq());
    }

    private function fakePusher(): \Pusher\Pusher
    {
        $pusher = new class('app-key', 'app-secret', 'app-id', ['host' => '127.0.0.1', 'port' => 1, 'scheme' => 'http', 'useTLS' => false]) extends \Pusher\Pusher {
            public bool $fail = false;
            public array $attempts = [];
            public $onTerminate = null;
            public function terminateUserConnections(string $user_id): object {
                $this->attempts[] = $user_id;
                if ($this->fail) throw new \RuntimeException('temporary termination failure');
                if ($this->onTerminate) ($this->onTerminate)();
                return (object) [];
            }
        };
        Broadcast::swap(new class($pusher) {
            public function __construct(private $pusher) {}
            public function connection($name) { return $this; }
            public function getPusher() { return $this->pusher; }
        });
        return $pusher;
    }

    private function bindBroadcasting(): void
    {
        $this->app['config']->set('broadcasting.connections.reverb', [
            'driver' => 'reverb', 'key' => 'app-key', 'secret' => 'app-secret', 'app_id' => 'app-id',
            'options' => ['host' => '127.0.0.1', 'port' => 1, 'scheme' => 'http', 'useTLS' => false],
            'client_options' => ['connect_timeout' => 1, 'timeout' => 1],
        ]);
        $this->app['config']->set('app.jwt_secret', str_repeat('k', 32));
        $this->app['config']->set('app.jwt_exp', 3600);
        $this->app->instance(BroadcastingFactory::class, new BroadcastManager($this->app));
    }
}