@foreach($najmadirectory as $data) {{-- @foreach($data->coordinators as $coordinator) @foreach($data->sobs as $sob) @foreach($data->emiratess as $emirates) @foreach($data->countries as $country) @foreach($data->categories as $category) @foreach($data->marketingactions as $marketingaction) --}} {{-- @endforeach @endforeach @endforeach @endforeach @endforeach @endforeach --}} @endforeach

Date time	Date Contracted	Employee Enrollment	Coordinator	Company Name	Website	Scope of Business	Emirates	Area	Country	Gender	Person Name	Contact Number	Email	Contact Person Position	Category	Remarks	Marketing Action	Marketking Vendor Registration	Marketing Status	Marketing Date followup Action	Marketing Remarks	Sales Action	Sales Date Followup Action	Sales Status	Sales Remarks	Sales Latest Updated Date	Sales Status Latest	Sales Latest Date Followup Action	Customer Care Action	Customer Care Date Followup Required	Customer Care Action Status	Customer Care Remarks	Inquiry Id	Proposal Type
{{ $data->datetime }}	{{ date('d-m-Y', strtotime($data->datecontracted)) }}	{{ App\Models\User::where('id','=',$data->coordinator)->pluck('empenrollment')->first() }}	{{ App\Models\User::where('id','=',$data->coordinator)->pluck('username')->first() }}	{{ $data->companyname }}	{{ $data->website }}	{{ App\Models\ScopeOfBusiness::where('id','=',$data->sob)->pluck('name')->first() }}	{{ App\Models\Emirate::where('id','=',$data->emirates)->pluck('name')->first() }}	{{ $data->area }}	{{ App\Models\Country::where('id','=',$data->country)->pluck('name')->first() }}	@if ($data->gender == 1) Male @elseif($data->gender == 2) Female @endif	{{ $data->personname }}	{{ $data->contactno }}	{{ $data->email }}	{{ $data->contact_person_position }}	{{ App\Models\Category::where('id','=',$data->category)->pluck('name')->first() }}	{{ $data->remarks }}	{{ App\Models\MarketingAction::where('id','=',$data->marketingaction)->pluck('name')->first() }}	{{ App\Models\VendorRegistration::where('id','=',$data->marketking_vendor_registration)->pluck('name')->first() }}	{{ App\Models\MarketingStatus::where('id','=',$data->marketingstatus)->pluck('name')->first() }}	{{ date('d-m-Y', strtotime($data->marketing_datefollowup_action)) }}	{{ $data->marketingremarks }}	{{ App\Models\SalesAction::where('id','=',$data->salesaction)->pluck('name')->first() }}	{{ date('d-m-Y', strtotime($data->sales_date_followup_action)) }}	{{ App\Models\SalesStatus::where('id','=',$data->salesstatus)->pluck('name')->first() }}	{{ $data->salesremarks }}	{{ date('d-m-Y', strtotime($data->sales_latest_updated_date)) }}	{{ App\Models\SalesStatusLatest::where('id','=',$data->sales_status_latest)->pluck('name')->first() }}	{{ date('d-m-Y', strtotime($data->sales_latest_date_followup_action)) }}	{{ App\Models\CustomerCareAction::where('id','=',$data->customercare_action)->pluck('name')->first() }}	{{ date('d-m-Y', strtotime($data->customercare_datefollowup_required)) }}	{{ App\Models\CustomerCareActionStatus::where('id','=',$data->customercare_actionstatus)->pluck('name')->first() }}	{{ $data->customercare_remarks }}	{{ $data->inquiryid }}	@if($data->proposal_type == 1) Proposal @elseif($data->proposal_type == 2) Discussion @elseif($data->proposal_type == 3) Not In Service @elseif($data->proposal_type == 4) FAP Proposal @elseif($data->proposal_type == 5) OST Proposal @elseif($data->proposal_type == 6) OSC Proposal @elseif($data->proposal_type == 7) AC Proposal @elseif($data->proposal_type == 8) HRC Proposal @else Pending @endif