@include('layouts.header')
@include('layouts.sidebar')

Monthly Net Profit

  1. Dashboard
  2. Monthly Net Profit
@if (auth()->user()->is_admin == '1')
@else
@endif

Monthly Net Profit Table

@php use Carbon\Carbon; @endphp @foreach ($invoicesByDay as $date => $totalSale) @php $stock = $filteredStockSellsByDay->get($date, 0); $purchase = $purchasesByDay->get($date, 0); $expense = $expensesByDay->get($date, 0); $profit = $totalSale - ($purchase + $expense); @endphp @endforeach
No. Date Stock Total Sale Total Purchase Total Expense Profit
{{ $loop->iteration }} {{ $date }} {{ number_format($stock ?? 0, 2) }} {{ number_format($totalSale ?? 0, 2) }} {{ number_format($purchase ?? 0, 2) }} {{ number_format($expense ?? 0, 2) }} {{ number_format($profit ?? 0, 2) }}
Total {{ number_format($filteredStockSellsByDay->sum() ?? 0, 2) }} {{ number_format($invoicesByDay->sum() ?? 0, 2) }} {{ number_format($purchasesByDay->sum() ?? 0, 2) }} {{ number_format($expensesByDay->sum() ?? 0, 2) }} {{ number_format($invoicesByDay->sum() - ($purchasesByDay->sum() + $expensesByDay->sum()) ?? 0, 2) }}

Monthly Net Profit Table

Date Stock Total Sale Total Purchase Total Expense Profit
{{ $invoices->isNotEmpty() && $invoices->first()->date ? Carbon::parse($invoices->first()->date)->format('F / Y') : 'No Invoices' }} {{ number_format($totalStockDeposit ?? 0, 2) }} {{ number_format($totalSum ?? 0, 2) }} {{ number_format($totalPurchase ?? 0, 2) }} {{ number_format($totalExpense ?? 0, 2) }} {{ number_format($totalSum - ($totalPurchase + $totalExpense) ?? 0, 2) }}
@include('layouts.footer')