{{-- div for Company --}} @php $company = DB::table('gnr_company') ->where('id', Auth::user()->company_id_fk) ->select('name', 'address') ->first(); @endphp {{ $company->name }}
{{ $company->address }}
Total Staff List ({{ $subTitle }})

{{--

--}} @php $sl = 1; @endphp @foreach ($branches as $branch) @php $branchEmployees = $employees->where('branch_id_fk', $branch->id)->sortBy('position_order'); if (count($branchEmployees) == 0) { continue; } $areaName = @$areas ->filter(function ($area) use ($branch) { // replace stristr with your choice of matching function return false !== stristr($area->branchId, '"' . $branch->id . '"'); }) ->first()->name; if ($branch->id == 1) { $areaName = 'Head Office'; } @endphp @foreach ($branchEmployees as $employee) @endforeach @endforeach

SL No.	Name	ID #	Designation	Area/Dist.	Branch	Male	Female	Total (M + F)
{{ $sl++ }}	{{ $employee->emp_name_english }}	{{ $employee->emp_id }}	{{ $employee->position_name }}	{{ $areaName }}	{{ $branch->name }}	{{ $employee->sex == 'Male' ? 1 : 0 }}	{{ $employee->sex == 'Female' ? 1 : 0 }}	1
Sub Total						{{ $branchEmployees->where('sex', 'Male')->count() }}	{{ $branchEmployees->where('sex', 'Female')->count() }}	{{ $branchEmployees->count() }}
Total						{{ $employees->where('sex', 'Male')->count() }}	{{ $employees->where('sex', 'Female')->count() }}	{{ $employees->count() }}