{{-- 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 Employee List - {{ $month }} (With Salary)

@php $slNo = 1; $currentDate = date("Y-m-d"); @endphp @foreach($branches as $branch) @php $tempEmployees = $employees->where('branch_id_fk', $branch->id); @endphp @foreach($tempEmployees as $employee) @php $education = $data['easycode']->getCurrentEducationInfo($employee->emp_id_fk); $joiningDate = date("Y-m-d",strtotime($employee->joining_date)); $joiningDateF = date_create($joiningDate); $currentDateF = date_create($currentDate); // Calculates the difference between DateTime objects $interval = date_diff($joiningDateF, $currentDateF); // Printing result in years & months format $jobDuration = $interval->format('%y years %m months'); $branch = $branches->where('id', $employee->branch_id_fk)->first(); $branchName = ($branch) ? str_pad($branch->branchCode, 3, "0", STR_PAD_LEFT ).'-'.$branch->name : ''; @endphp @endforeach @endforeach

SL#	Employee Basic Information																Joining Date	Job Duration	Grade	Level	Increment Year	Branch	Recruitment Type	Salary
SL#	Name	Employee Id	Email	Mobile Number	Designation	National Id	Date Of Birth	Gender	Father Name	Mother Name	Marital Status	Spouse Name	Religion	Education	Present Address	Permanent Address	Joining Date	Job Duration	Grade	Level	Increment Year	Branch	Recruitment Type	Salary
{{ $slNo++ }}	{{ $employee->emp_name_english }}	{{ $employee->emp_id }}	{{ $employee->email }}	{{ $employee->mobile_number }}	{{ $employee->position_name }}	{{ strval($employee->nid_no) }}	{{ date('d-m-Y', strtotime($employee->date_of_birth)) }}	{{ $employee->sex }}	{{ $employee->father_name_english }}	{{ $employee->mother_name_english }}	{{ $employee->maritial_status }}	{{ $employee->husbend_wife_name }}	{{ $employee->religion }}	{{ ($education != null) ? $education->name : '' }}	{{ $employee->present_address }}	{{ $employee->permanent_address }}	{{ date("d-m-Y", strtotime($employee->joining_date)) }}	{{ $jobDuration }}	{{ @$grades->where("id",$employee->grade)->first()->name ?? ""}}	{{ @$levels->where("id",$employee->level_id_fk)->first()->name ?? "" }}	{{ $employee->salary_increment_year }}	{{ $branchName }}	{{ $types->where("id", $employee->recruitment_type)->first()->name ?? ""}}	{{ number_format($salaryInfo[$employee->emp_id_fk]->salary['gross_salary'],2) }}