Extending Cashify

return [
    // Add your custom defaults
    [
        'name' => 'Freelance Work',
        'type' => 'income',
        'color' => 'emerald',
        'icon' => 'laptop'
    ],
    [
        'name' => 'Coffee',
        'type' => 'expense',
        'color' => 'amber',
        'icon' => 'coffee-cup'
    ],
    // ... existing categories
];

protected function applyAccountFilter(Builder $query): void
{
    if ($this->request->filled('accounts')) {
        $accountIds = $this->request->input('accounts');
        $query->whereIn('account_id', $accountIds);
    }
}

protected function applyCustomDateFilter(Builder $query): void
{
    if ($this->request->filled('preset_range')) {
        $preset = $this->request->input('preset_range');
        
        match($preset) {
            'today' => $query->whereDate('created_at', today()),
            'this_week' => $query->whereBetween('created_at', [
                now()->startOfWeek(),
                now()->endOfWeek()
            ]),
            'this_month' => $query->whereMonth('created_at', now()->month),
            'this_year' => $query->whereYear('created_at', now()->year),
            default => null,
        };
    }
}

public function apply(Builder $query): Builder
{
    $this->applyTypeFilter($query);
    $this->applyCategoryFilter($query);
    $this->applyAccountFilter($query);  // New filter
    $this->applyCustomDateFilter($query);  // New filter
    $this->applyAmountFilter($query);
    $this->applyTitleFilter($query);
    $this->applyDetailsFilter($query);
    $this->applyDateRangeFilter($query);

    return $query;
}

<?php

namespace App\Charts;

use App\Models\Transaction;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;

class IncomeVsExpenseChart
{
    public function build(): array
    {
        $monthlyData = Transaction::query()
            ->select(
                DB::raw('DATE_FORMAT(created_at, "%Y-%m") as month'),
                DB::raw('SUM(CASE WHEN categories.type = "income" THEN amount ELSE 0 END) as income'),
                DB::raw('SUM(CASE WHEN categories.type = "expense" THEN ABS(amount) ELSE 0 END) as expense')
            )
            ->join('categories', 'transactions.category_id', '=', 'categories.id')
            ->where('transactions.user_id', Auth::id())
            ->groupBy('month')
            ->orderBy('month')
            ->limit(12)
            ->get();

        return [
            'labels' => $monthlyData->pluck('month')->toArray(),
            'income' => $monthlyData->pluck('income')->toArray(),
            'expense' => $monthlyData->pluck('expense')->toArray(),
        ];
    }
}

public function __invoke(IncomeVsExpenseChart $chart)
{
    $chartData = $chart->build();
    
    return view('dashboard', [
        'chartData' => $chartData,
    ]);
}

<?php

namespace App\Http\Middleware;

use Closure;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;

class CheckSpendingLimit
{
    public function handle(Request $request, Closure $next)
    {
        $user = Auth::user();
        
        // Get monthly spending
        $monthlySpending = abs(
            $user->transactions()
                ->whereHas('category', fn($q) => $q->where('type', 'expense'))
                ->whereMonth('created_at', now()->month)
                ->sum('amount')
        );
        
        $limit = $user->monthly_limit ?? 10000; // Default limit
        
        if ($monthlySpending >= $limit) {
            session()->flash('warning', 'You have reached your monthly spending limit!');
        }
        
        return $next($request);
    }
}

Route::middleware(['auth', 'verified', 'spending.limit'])->group(function () {
    // Your routes
});

<?php

namespace App\Traits;

trait HasNotifications
{
    public function sendBudgetAlert(string $categoryName, float $spent, float $budget)
    {
        $percentage = ($spent / $budget) * 100;
        
        if ($percentage >= 90) {
            flashToast('warning', 
                __("You've spent :percent% of your :category budget!", [
                    'percent' => round($percentage),
                    'category' => $categoryName
                ])
            );
        }
    }
}

class User extends Authenticatable
{
    use HasFactory, Notifiable, HasNotifications;
    
    // ...
}

if (!function_exists('formatCurrency')) {
    function formatCurrency(float $amount, string $currency = 'BGN'): string
    {
        return Number::currency($amount, in: $currency, locale: app()->getLocale());
    }
}

if (!function_exists('getMonthlySpending')) {
    function getMonthlySpending(?int $userId = null): float
    {
        $userId = $userId ?? Auth::id();
        
        return abs(
            Transaction::where('user_id', $userId)
                ->whereHas('category', fn($q) => $q->where('type', 'expense'))
                ->whereMonth('created_at', now()->month)
                ->sum('amount')
        );
    }
}

if (!function_exists('calculateSavingsRate')) {
    function calculateSavingsRate(?int $userId = null): float
    {
        $userId = $userId ?? Auth::id();
        
        $income = Transaction::where('user_id', $userId)
            ->whereHas('category', fn($q) => $q->where('type', 'income'))
            ->whereMonth('created_at', now()->month)
            ->sum('amount');
            
        $expenses = abs(
            Transaction::where('user_id', $userId)
                ->whereHas('category', fn($q) => $q->where('type', 'expense'))
                ->whereMonth('created_at', now()->month)
                ->sum('amount')
        );
        
        if ($income == 0) return 0;
        
        return (($income - $expenses) / $income) * 100;
    }
}