{{-- 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}}
{{-- Consolited Staff Report {{$currentDate}} --}}

{{--

--}} @php $_colorPckerFirst = 0; $_colorPckerSecond = 0; $slNo = 0; $total = 0; $total = $pksf + $nonPKSF + $general; @endphp @foreach ($projectsType as $key => $type) @php $data = DB::table('hr_emp_org_info') ->where([['project_type_id_fk', '=', $type->id], ['terminate_resignation_date', '>=', $endDate]]) ->orWhere([['project_type_id_fk', '=', $type->id], ['terminate_resignation_date', '=', '0000-00-00']]) ->count('id'); $total = $total + $data; @endphp @if ($_colorPckerFirst == 1) @php $_colorPckerFirst = 0; @endphp @else @php $_colorPckerFirst = 1; @endphp @endif @endforeach {{-- --}}

SL No.	Project/ Program Name	Number of Staff as per HR & Admin Department
{{++$slNo}}	MFP (PKSF-Branch)	{{$pksf}}
{{++$slNo}}	MFP (Non-PKSF-Branch)	{{$nonPKSF}}
{{++$slNo}}	HO (PKSF-{{$pksf}}, Non-PKSF-{{$nonPKSF}}, General-{{$general}} = Total-{{$pksf + $nonPKSF + $general}})	{{$pksf + $nonPKSF + $general}}
{{++$slNo}}	{{$type->name}}	{{$data}}
{{++$slNo}}	{{$type->name}}	{{$data}}
Total		{{$total}}
	NGO Forum
	PRMFC

@endif