@php $totalOfficers = 0; $totalOfficerAmount = 0; $totalStaffs = 0; $totalStaffAmount = 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; $totalOfficerAmount += $list->total_net_amount_officer; $totalStaffs += $list->total_staff; $totalStaffAmount += $list->total_net_amount_staff; $grandTotalEmp += $totalEmp; $grandTotalEmpAmount += $totalEmpAmount; @endphp @endforeach

Sl	Department Name	Total Officer	Officer’s Amount	Total Staff	Staff’s Amount	Total Employee	Total Amount
{{ $loop->iteration }}	{{ $list->department_name }}	{{ $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($totalOfficerAmount, 2) }}	{{ $totalStaffs }}	{{ number_format($totalStaffAmount, 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	Department Name	Total Officer	Officer Amount	Total Staff	Staff Amount	Total Employee	Total Amount
{{ $loop->iteration }}	{{ $list->department_name }}	{{ $list->total_officer }}	{{ $list->total_net_amount_officer }}	{{ $list->total_staff }}	{{ $list->total_net_amount_staff }}	{{ $totalEmp }}	{{ $totalEmpAmount }}

--}}