@foreach ($columns as $column) @endforeach @foreach ($leads as $lead) @foreach ($columns as $column) @endforeach @endforeach
{{ ucwords(str_replace('_', ' ', $column)) }}
@php if (in_array($column, $dynamicFields)) { $value = $lead->leadFormDynamicFieldData['data'][$column]['field_value'] ?? ''; } else { $value = match ($column) { 'lead_id' => $lead->leadId, 'passcode' => $lead->passcode, // 'full_name' => ($lead->leadFormDynamicFieldData['data']['first_name']['field_value'] ?? ''). ' ' . ($lead->leadFormDynamicFieldData['data']['middle_name']['field_value'] ?? '') . ' ' . ($lead->leadFormDynamicFieldData['data']['last_name']['field_value'] ?? ''), 'carrier_name' => $lead->carrier?->name, 'plan_name' => $lead->plan?->name, 'product_name' => $lead->product?->name, // 'face_amount' => $lead->leadFormDynamicFieldData['data']['face_amount']['field_value'] ?? '', // 'monthly_premium' => $lead->leadFormDynamicFieldData['data']['monthly_premium']['field_value'] ?? '', // 'initial_draft_date' => $lead->leadFormDynamicFieldData['data']['initial_draft_date']['field_value'] ?? '', // 'future_draft_date' => $lead->leadFormDynamicFieldData['data']['future_draft_date']['field_value'] ?? '', // 'application_date' => $lead->leadFormDynamicFieldData['data']['application_date']['field_value'] ?? '', // 'address' => $lead->leadFormDynamicFieldData['data']['address']['field_value'] ?? '', // 'city' => $lead->leadFormDynamicFieldData['data']['city']['field_value'] ?? '', // 'state' => $lead->leadFormDynamicFieldData['data']['state']['field_value'] ?? '', // 'zip_code' => $lead->leadFormDynamicFieldData['data']['zip_code']['field_value'] ?? '', 'primary_contact' => $lead->primary_contact ?? $lead->secondary_contact, 'agency_name' => optional($lead->agent?->agencies->first())->name ?? '', 'agent_id' => $lead->agent?->unique_id, 'agent_name' => $lead->agent?->name, 'marketer_unique_id' => $lead->marketer?->unique_id, 'officeadmin_name' => $lead->marketer?->officeAdmin?->name ?? $lead->officeAdmin?->name ?? '', 'disposition' => $lead->disposition, 'created_at' => $lead->created_at->format('d-m-Y'), 'updated_at' => $lead->updated_at->format('d-m-Y'), // Additional fields 'policy_number' => $lead->policy_number ?? '', // 'annual_premium' => '$' . ($lead->leadFormDynamicFieldData['data']['annual_premium']['field_value'] ?? ''), 'total_commission' => '$' . $lead->total_commission, 'received_commission' => '$' . $lead->received_commission, 'due_commission' => '$' . $lead->due_commission, 'agency_comment' => $lead->agency_comment, 'account_title' => $lead->account_title, 'account_ownership' => $lead->account_ownership, 'account_opening_state' => $lead->account_opening_state, 'account_number' => $lead->account_number, 'account_type' => $lead->account_type, 'bank_name' => $lead->bank_name, 'routing_number' => $lead->routing_number, 'agent_comment' => $lead->agent_comment, 'conservation_comment' => $lead->conservation_comment, 'marketer_name' => $lead->marketer?->name, 'charged_back_amount' => $lead->charged_back_amount, 'conservation_admin_name' => $lead->conservationAdmin?->name, 'conservation_agent_name' => $lead->conservationAgent?->name, 'ssn'=> $lead->ssn, 'secondary_contact' => $lead->secondary_contact, 'other_contact' => $lead->other_contact, default => '', }; } @endphp {{ $value }}