@php $totalOfficers = 0; $totalStaffs = 0; $totalOfficerAmounts = 0; $totalStaffAmounts = 0; $grandTotalEmp = 0; $grandTotalEmpAmount = 0; @endphp @foreach($data as $list) @php $totalEmp = $list->total_officer + $list->total_staff; $totalEmpAmount = $list->total_net_amount_officer + $list->total_net_amount_staff; $totalOfficers += $list->total_officer; $totalStaffs += $list->total_staff; $totalOfficerAmounts += $list->total_net_amount_officer; $totalStaffAmounts += $list->total_net_amount_staff; $grandTotalEmp += $totalEmp; $grandTotalEmpAmount += $totalEmpAmount; @endphp @endforeach

Sl	Status	Total Officer	Officer’s Amount	Total Staff	Staff’s Amount	Total Employee	Total Amount
{{ $loop->iteration }}	{{ $list->emp_status }}	{{ $list->total_officer }}	{{ number_format($list->total_net_amount_officer, 2) }}	{{ $list->total_staff }}	{{ number_format($list->total_net_amount_staff, 2) }}	{{ $totalEmp }}	{{ number_format($totalEmpAmount, 2) }}
Total		{{ $totalOfficers }}	{{ number_format($totalOfficerAmounts, 2) }}	{{ $totalStaffs }}	{{ number_format($totalStaffAmounts, 2) }}	{{ $grandTotalEmp }}	{{ number_format($grandTotalEmpAmount, 2) }}

{{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- @php $totalEmp=0; $totalEmpAmount = 0; $grandTotalEmp=0; $grandTotalEmpAmount = 0; @endphp--}} {{-- @foreach($data as $list)--}} {{-- @php--}} {{-- $totalEmp = $list->total_officer + $list->total_staff;--}} {{-- $totalEmpAmount = $list->total_net_amount_officer + $list->total_net_amount_staff;--}} {{-- $grandTotalEmp = $grandTotalEmp + $totalEmp;--}} {{-- $grandTotalEmpAmount = $grandTotalEmpAmount + $totalEmpAmount;--}} {{-- @endphp--}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- @endforeach--}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{--

Sl	Status	Total Officer	Officer Amount	Total Staff	Staff Amount	Total Employee	Total Amount
{{ $loop->iteration }}	{{ $list->emp_status }}	{{ $list->total_officer }}	{{ $list->total_net_amount_officer }}	{{ $list->total_staff }}	{{ $list->total_net_amount_staff }}	{{ $totalEmp }}	{{ $totalEmpAmount }}
Total				{{ $grandTotalEmp }}	{{ $grandTotalEmpAmount }}

--}}