Gecko [ thecigaretteboxes.com ]

Name	Size	Permission
AgentRawDataImport.php	3.55 KB	-rw-r--r--
ClientsImport.php	1.07 KB	-rw-r--r--
ContactsImport.php	2.99 KB	-rw-r--r--
LeadsImport.php	561 B	-rw-r--r--

Code Editor : ContactsImport.php

<?php
namespace App\Imports;

use App\Models\Contact;
use App\Models\ContactDetail;
use Maatwebsite\Excel\Row;
use Maatwebsite\Excel\Concerns\OnEachRow;
use Maatwebsite\Excel\Concerns\WithHeadingRow;

class ContactsImport implements OnEachRow, WithHeadingRow
{
    public function onRow(Row $row)
    {
        $r = $row->toArray();

$contact = Contact::create([
            'contact_full_name'        => $r['contact_full_name'] ?? null,
            'first_name'        => $r['first_name'] ?? null,
            'last_name'        => $r['last_name'] ?? null,
            'middle_name'        => $r['middle_name'] ?? null,
            'title'        => $r['title'] ?? null,
            'company_name_cleaned'        => $r['company_name_cleaned'] ?? null,
            'website'                     => $r['website'] ?? null,
            'contact_li_profile_url'      => $r['contact_li_profile_url'] ?? null,
            'contact_city'                => $r['contact_city'] ?? null,
            'contact_state'               => $r['contact_state'] ?? null,
            'contact_state_abbr'          => $r['contact_state_abbr'] ?? null,
            'contact_country'             => $r['contact_country'] ?? null,
            'contact_country_alpha_3'     => $r['contact_country_alpha_3'] ?? null,
            'contact_location'            => $r['contact_location'] ?? null,
            'company_location'            => $r['company_location'] ?? null,
            'company_city'                => $r['company_city'] ?? null,
            'company_state'               => $r['company_state'] ?? null,
            'company_state_abbr'          => $r['company_state_abbr'] ?? null,
            'company_post_code'           => $r['company_post_code'] ?? null,
            'company_country'             => $r['company_country'] ?? null,
            'company_country_alpha_3'     => $r['company_country_alpha_3'] ?? null,
            'company_annual_revenue'      => $r['company_annual_revenue'] ?? null,
            'company_description'         => $r['company_description'] ?? null,
        ]);

// Save emails
        foreach (['email_1', 'email_2', 'personal_email'] as $field) {
            if (!empty($r[$field])) {
                ContactDetail::create([
                    'contact_id' => $contact->id,
                    'type'       => 'email',
                    'value'      => $r[$field],
                    'category'   => $field,
                ]);
            }
        }

// Save phone numbers
        foreach (['contact_phone_1', 'company_phone_1', 'contact_phone_2', 'company_phone_2', 'contact_phone_3', 'company_phone_3', 'contact_mobile_phone', 'contact_mobile_phone_2', 'contact_mobile_phone_3'] as $field) {
            if (!empty($r[$field])) {
                ContactDetail::create([
                    'contact_id' => $contact->id,
                    'type'       => 'phone',
                    'value'      => $r[$field],
                    'category'   => $field,
                ]);
            }
        }
    }
}

${this.title}

Code Editor : ContactsImport.php