@can('Admin')

Profile --}} {{-- start library --}} {{--

--}} {{-- end library --}} {{-- --}} {{-- start DataEntry --}} {{--

--}} {{-- end DataEntry --}} {{-- user-management start --}}

@endcan @php // Get distinct years for income $incomeYears = App\Models\ExpenseCalculation::selectRaw('DISTINCT YEAR(created_at) as year') ->where('types', 'income') ->get() ->pluck('year'); // Get total income for each year $incomeData = []; foreach ($incomeYears as $year) { $totalIncome = App\Models\ExpenseCalculation::where('types', 'income') ->whereYear('created_at', $year) ->sum('amount'); $incomeData[$year] = $totalIncome; } // Get distinct years for expense $expenseYears = App\Models\ExpenseCalculation::selectRaw('DISTINCT YEAR(created_at) as year') ->where('types', 'expense') ->get() ->pluck('year'); // Get total expense for each year $expenseData = []; foreach ($expenseYears as $year) { $totalExpense = App\Models\ExpenseCalculation::where('types', 'expense') ->whereYear('created_at', $year) ->sum('amount'); $expenseData[$year] = $totalExpense; } @endphp @foreach ($incomeYears->merge($expenseYears)->unique() as $year) @endforeach

Year	Income	Expense
{{ $year }}	{{ $incomeData[$year] ?? 0 }}	{{ $expenseData[$year] ?? 0 }}