@foreach ($data as $key => $item) @endforeach

{{ $organization->name }} Employees - {{ date('Y-m-d H:i:s') }}
{{ trans('employee/employee.id') }}	{{ trans('employee/employee.device_person_id') }}	{{ trans('employee/employee.employee_photo') }}	{{ trans('employee/employee.employee_code') }}	{{ trans('employee/employee.employee_name') }}	{{ trans('employee/employee.manager_name') }}	{{ trans('employee/employee.email_id') }}	{{ trans('employee/employee.fathers_name') }}	{{ trans('employee/employee.address') }}	{{ trans('employee/employee.mobile') }}	{{ trans('employee/employee.alternative_mobile') }}	{{ trans('employee/employee.gender') }}	{{ trans('employee/employee.dob') }}	{{ trans('employee/employee.doj') }}	Card Number	Company Code	Company PF Code	Bank Name	Account Number	Account Holder Name	IFSC Code	UAN Number	Aadhar Number	Pincode	PF Number	ESIC Number	PAN Number	IP Number	Valid From	Valid To	Work Station	Category	Grade	{{ trans('employee/employee.department') }}	{{ trans('employee/employee.sub_department') }}	{{ trans('employee/employee.designation') }}	{{ trans('employee/employee.shift') }}	{{ trans('employee/employee.emergency_contact_name') }}	{{ trans('employee/employee.emergency_contact_mobile') }}	{{ trans('employee/employee.emergency_contact_relation') }}	{{ trans('employee/employee.date_of_leaving') }}	Location Type	{{ trans('employee/employee.mapped_locations') }}	{{ trans('employee/employee.mapped_sublocations') }}	{{ trans('employee/employee.in_location') }}	{{ trans('employee/employee.attendance_today') }}	{{ trans('employee/employee.status') }}	{{ trans('employee/employee.app_login') }}	{{ trans('employee/employee.attendance_access') }}	{{ trans('employee/employee_create.activate_check_in') }}	{{ trans('employee/employee.training_given_by') }}	{{ trans('employee/employee.training_type') }}	{{ trans('employee/employee.training_user_type') }}	{{ trans('employee/employee.external_trainer_name') }}	{{ trans('employee/employee.external_trainer_email') }}	{{ trans('employee/employee.training_date') }}	{{ trans('employee/employee.training_status') }}	Remarks
{{ $loop->iteration }}	{{ $item->device_person_id }}	{{ $item->image ? 'Yes' : 'No' }}	{{ $item->employee_code }}	{{ $item->name }}	{{ @$item->hod->name }}	{{ @$item->email }}	{{ @$item->father_name }}	{{ @$item->geo_address }}	{{ @$item->mobile }}	{{ @$item->alternate_mobile }}	{{ @$item->gender }}	{{ @$item->dob }}	{{ @$item->date_of_joining }}	{{ @$item->card_no }}	{{ @$item->companyCode->number }}	{{ @$item->companyPfCode->number }}	{{ @$item->bank_name }}	{{ @$item->bank_account_no }}	{{ @$item->bank_account_holder_name }}	{{ @$item->bank_ifsc }}	{{ @$item->uan_number }}	@if (Auth::user()->can_role('On-Roll Employees Add')) {{ @$item->aadhar_number }} @else {{ isset($item->aadhar_number) ? 'XXXXXXXX' . substr($item->aadhar_number, -4) : '' }} @endif	{{ @$item->pin_code }}	{{ @$item->pf_no }}	{{ @$item->esic_no }}	{{ @$item->pan_no }}	{{ @$item->ip_number }}	{{ @$item->valid_from }}	{{ @$item->valid_to }}	{{ @$item->workstation->name }}	{{ @$item->category->name }}	{{ @$item->grade->name }}	{{ @$item->department->name }}	{{ @$item->subDepartment->name }}	{{ @$item->designation->name }}	{{ @$item->shift->name }}	{{ @$item->contact_person_name }}	{{ @$item->contact_person_mobile }}	{{ @$item->contact_person_relation }}	{{ @$item->date_of_leaving }}	@php $locationType = ''; switch ($item->free_location) { case "1": $locationType = 'Free Location'; break; case "2": $locationType = 'PunchIn Free Location'; break; case "3": $locationType = 'PunchOut Free Location'; break; case "0": $locationType = 'Strict Location'; break; } @endphp {{ $locationType }}	@php $mappedLocations = @$item->locations->pluck('name')->toArray(); @endphp {{ implode(',', $mappedLocations) }}	@php $mappedSubLocations = @$item->sublocations->pluck('name')->toArray(); @endphp {{ implode(',', $mappedSubLocations) }}	{{ @$item->todayAttendance->in_address['geo_address'] }}	{{ @$item->todayAttendance->in_time }} {{ @$item->todayAttendance->out_time }}	@if ($item->status == App\Helpers\ConstantHelper::ACTIVE) {{ ucfirst($item->status) }} @elseif($item->status == App\Helpers\ConstantHelper::IN_ACTIVE || $item->status == App\Helpers\ConstantHelper::BLACKLIST) {{ ucfirst($item->status) }} @else {{ ucfirst($item->status) }} @endif	{{ @$item->is_app_login == 1 ? 'Yes' : 'No' }}	{{ @$item->is_attendance_access == 1 ? 'Yes' : 'No' }}	{{ @$item->check_in == 1 ? 'Yes' : 'No' }}	{{ @$item->training_given_by }}	{{ @$item->training_type }}	{{ @$item->training_user_type }}	{{ @$item->external_trainer_name }}	{{ @$item->external_trainer_email }}	{{ @$item->training_date }}	{{ @$item->training_status }}	{{ @$item->remarks }}