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 : ClientsImport.php

<?php

namespace App\Imports;

use App\Models\Client;
use Maatwebsite\Excel\Concerns\ToModel;

class ClientsImport implements ToModel
{
    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {   
        if($row[0] != "Name"){
            $client = Client::create([
                'name' => $row[0],
                'company_name' => $row[1],
                'address' => $row[4],
                'billing_name' => $row[5],
                'billing_address' => $row[6],
                'status' => "active",
            ]);
            $email_arr = explode(',', $row[2]);
            $phone_arr = explode(',', $row[3]);
            foreach($email_arr as $email){
                $client->emailPhoneDetails()->create(['value' => $email , 'type' => 'email']);
            }
            foreach($phone_arr as $phone){
                $client->emailPhoneDetails()->create(['value' => $phone , 'type' => 'phone_no']);
            }
            
            return $client;
            
        }
        
    }
}

${this.title}

Code Editor : ClientsImport.php