@foreach($companies as $row) {{-- Force ZIP code to be text in Excel to preserve leading zeros --}} @endforeach

Created Date	Expiry Date	Owner Operator	Monthly Billing	Clearinghouse	Readi Collect	Company Name	Electronic Client ID	Org Id	Location Id	Quest No	USDOTNO	i3Screen Account Number	Billing First Name	Billing Last Name	Billing Email	Billing Address	City	State	Zipcode	Po Box	Billing Phone	Billing Mobile	Fax	Referred by	Primary DER Name	Primary DER Email	Primary DER Phone	Primary DER Mobile	Alternate DER Name	Alternate DER Email	Alternate DER Phone	Alternate DER Mobile	Terms	Preferred Delivery Method	Status
{{ \Carbon\Carbon::parse($row->created_at)->format('m-d-Y') }}	{{ $row->enrollment_expiry_on ? \Carbon\Carbon::parse($row->enrollment_expiry_on)->format('m-d-Y') : '-' }}	{{ $row->is_owner_operator ? 'YES' : 'NO' }}	{{ $row->is_monthly_billing_company ? 'YES' : 'NO' }}	{{ $row->is_clearinghouse_management ? 'YES' : 'NO' }}	{{ $row->is_readi_collect ? 'YES' : 'NO' }}	{{ $row->company_name ?? '-' }}	{{ $row->electronic_client_id ?? '-' }}	{{ $row->org_id ?? '-' }}	{{ $row->location_id ?? '-' }}	{{ $row->quest_no ?? '-' }}	{{ $row->usdot_no ?? '-' }}	{{ $row->i3screen_account_number ?? '-' }}	{{ $row->billing_first_name ?? '-' }}	{{ $row->billing_last_name ?? '-' }}	{{ $row->primary_email ?? '-' }}	{{ preg_replace('/\s+/', ' ', $row->billing_address ?? '-') }}	{{ $row->city ?? '-' }}	{{ $row->states->statename ?? '-' }}	{{ str_pad(preg_replace('/\s+/', '', (string) ($row->zipcode ?? '')), 5, '0', STR_PAD_LEFT) ?: '-' }}	{{ $row->pobox_number ?? '-' }}	{{ preg_replace('/[\s\-\(\)]+/', '', $row->phone_number ?? '-') ?: '-' }}	{{ preg_replace('/[\s\-\(\)]+/', '', $row->mobile_number ?? '-') ?: '-' }}	{{ preg_replace('/[\s\-\(\)]+/', '', $row->fax ?? '-') ?: '-' }}	{{ $row->refered_by ?? '' }}	{{ $row->primary_der_name ?? '' }}	{{ $row->primary_der_email ?? '' }}	{{ preg_replace('/[\s\-\(\)]+/', '', $row->primary_der_phone1 ?? '-') ?: '' }}	{{ preg_replace('/[\s\-\(\)]+/', '', $row->primary_der_phone2 ?? '-') ?: '' }}	{{ $row->alt_der_name ?? '' }}	{{ $row->alt_der_email ?? '' }}	{{ preg_replace('/[\s\-\(\)]+/', '', $row->alt_der_phone1 ?? '-') ?: '' }}	{{ preg_replace('/[\s\-\(\)]+/', '', $row->alt_der_phone2 ?? '-') ?: '' }}	Net 10	Email	{{ ($row->is_account_close != true) ? 'Active' : (($row->active == true) ? 'Closed' : '-') }}