SearchExpense Tool

SearchExpenses.php

    public function handle(Request $request): Stringable|string
    {
        $query = Expense::where('budget_id', $this->budgetId);

        if ($request['name'] ?? null) {
            $query->where('name', 'ilike', '%' . $request['name'] . '%');
        }

        if ($request['category'] ?? null) {
            $query->where('category', 'ilike', '%' . $request['category'] . '%');
        }

        $expenses = $query->get(['name', 'amount', 'category', 'created_at']);

        if ($expenses->isEmpty()) {
            return 'No se encontraron gastos con esos criterios.';
        }

        $total = $expenses->sum('amount');

        return "Gastos encontrados ({$expenses->count()}):\n" .
        $expenses->map(function ($e) {
            $cat = $e->category ? $e->category->label() : 'Sin categoría';
            return "- {$e->name}: \${$e->amount} ({$cat})";
        })->implode("\n") .
        "\n\nTotal: \${$total}";
    }