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

$user = App\Models\User::find(1);
$limits = $user->limits;
$earned = $user->transactions()->where('type', 'earned')->groupBy('feature_name')->selectRaw('feature_name, sum(amount) as total')->pluck('total', 'feature_name');
$spent = $user->transactions()->where('type', 'spent')->groupBy('feature_name')->selectRaw('feature_name, sum(amount) as total')->pluck('total', 'feature_name');

$creditUsage = [];
foreach (array_keys($limits) as $feature) {
    $creditUsage[$feature] = [
        'earned' => (float)($earned[$feature] ?? 0),
        'spent' => abs((float)($spent[$feature] ?? 0)),
        'balance' => $limits[$feature],
    ];
}

echo json_encode([
    'limits' => $limits,
    'earned' => $earned,
    'spent' => $spent,
    'credit_usage' => $creditUsage
], JSON_PRETTY_PRINT);