<?php
require __DIR__.'/vendor/autoload.php';
$app = require_once __DIR__.'/bootstrap/app.php';
$kernel = $app->make(Illuminate\Contracts\Console\Kernel::class);
$kernel->bootstrap();

$sponsor = \App\Models\Member::where('display_name', 'companyone')->first();
$placement = \App\Models\Member::where('display_name', 'companyfour')->first();

if (!$sponsor || !$placement) {
    echo "One or both not found\n";
    exit;
}

$sponsorId = $sponsor->id;

echo "Sponsor ID: " . $sponsorId . "\n";
echo "Placement ID: " . $placement->id . "\n";
echo "Sponsor Directs Count: " . $sponsor->referrals()->count() . "\n";
echo "Is Downstream: " . ($placement->isGenealogicallyDownstreamOf($sponsorId) ? 'YES' : 'NO') . "\n";