@foreach ($data as $key => $item) @php $trainingGivenBy = null; if ( !empty($item->training_user_type) && $item->training_user_type == 'employee' ) { $trainingGivenBy = $item->employeeGivenByName ?? null; } else { $trainingGivenBy = $item->userGivenByName ?? null; } @endphp @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') }}	Profile Photo Link	{{ 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') }}	Group {{ 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	Role	Work Station	Category	Grade	{{ trans('employee/employee.department') }}	{{ trans('employee/employee.sub_department') }}	{{ trans('employee/employee.designation') }}	{{ trans('employee/employee.shift') }}	Additional Shifts	{{ 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') }}	{{ trans('employee/employee.is_bus_allowed') }}	{{ trans('employee/employee.bus_name') }}	{{ trans('employee/employee.zone') }}	Flexi Hours	Nationality	Religion	Payment Mode	Qualification	Country	State	City	Experience	Standred Working Hour	Is Auto Shift	Is Auto Inactive	{{ trans('employee/employee.inactivation_date') }}	Remarks	Created At
{{ $loop->iteration }}	{{ $item->device_person_id }}	{{ $item->image ? 'Yes' : 'No' }}	{{ $item->image }}	{{ $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->group_joining_date }}	{{ @$item->card_no }}	{{ @$item->companyCode->number }}	{{ @$item->companyPfCode->number }}	{{ @$item->bank_name }}	{{ $item->bank_account_no ? "=\"" . $item->bank_account_no . "\"" : '' }}	{{ @$item->bank_account_holder_name }}	{{ @$item->bank_ifsc }}	{{ $item->uan_number ? "=\"" . $item->uan_number . "\"" : '' }}	@if (Auth::user()->can_role('On-Roll Employees Add')) {{ $item->aadhar_number ? "=\"" . $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->role->name }} {{ $showMasterLabel && @$item->role->organization_id && $item->role->organization_id != $organization->id ? ' (Master)' : ''}}	{{ @$item->workstation->name }} {{ $showMasterLabel && @$item->workstation->organization_id && $item->workstation->organization_id != $organization->id ? ' (Master)' : ''}}	{{ @$item->category->name }} {{ $showMasterLabel && @$item->category->organization_id && $item->category->organization_id != $organization->id ? ' (Master)' : ''}}	{{ @$item->grade->name }} {{ $showMasterLabel && @$item->grade->organization_id && $item->grade->organization_id != $organization->id ? ' (Master)' : ''}}	{{ @$item->department->name }} {{ $showMasterLabel && @$item->department->organization_id && $item->department->organization_id != $organization->id ? ' (Master)' : ''}}	{{ @$item->subDepartment->name }} {{ $showMasterLabel && @$item->subDepartment->organization_id && $item->subDepartment->organization_id != $organization->id ? ' (Master)' : ''}}	{{ @$item->designation->name }} {{ $showMasterLabel && @$item->designation->organization_id && $item->designation->organization_id != $organization->id ? ' (Master)' : ''}}	{{ @$item->shift->name }}	{{ @$item->additionalShifts->pluck('name')->implode(', ') }}	{{ @$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' }}	{{ $trainingGivenBy ? $trainingGivenBy->name : 'N/A' }}	{{ @$item->training_type }}	{{ @$item->training_user_type }}	{{ @$item->external_trainer_name }}	{{ @$item->external_trainer_email }}	{{ @$item->training_date }}	{{ @$item->training_status }}	{{ @$item->is_bus_allowed == 1 ? 'Yes' : 'No' }}	{{ @$item->bus->name }}	{{ @$item->zone->name }}	{{ @$item->flexi_hours == 1 ? 'Yes' : 'No' }}	{{ @$item->nationality }}	{{ @$item->religion }}	{{ @$item->mode_of_payment }}	{{ @$item->qualification }}	{{ @$item->country->name }}	{{ @$item->state->name }}	{{ @$item->city->name }}	{{ @$item->experience }}	{{ @$item->configData['standred_working_hour'] ?? '-' }}	{{ @$item->is_auto_shift }}	{{ @$item->configData['is_auto_inactive'] == 1 ? 'Yes' : 'No' }}	{{ @$item->inactivation_date}}	{{ @$item->remarks }}	{{ date('d/m/Y H:i:s', strtotime(@$item->created_at)) }}