CodingActivitiesEUCodeWeekSiteImport.php

<?php

namespace App\Imports;

use App\Event;
use Carbon\Carbon;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Log;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithCustomValueBinder;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use PhpOffice\PhpSpreadsheet\Cell\DefaultValueBinder;
use PhpOffice\PhpSpreadsheet\Shared\Date;

class CodingActivitiesEUCodeWeekSiteImport extends DefaultValueBinder implements ToModel, WithCustomValueBinder, WithHeadingRow
{
    public function parseDate($date)
    {
        if(strpos($date, '.') !== false) {
            return Date::excelToDateTimeObject($date);
        }

        $return = [];

        $date = substr($date, 0, strpos($date, ' '));
        $date = trim($date);

        $arr = explode('/', $date);

        if(!empty($arr)) {
            $return[] = $arr[2].'-'.$arr[1].'-'.$arr[0];   
        }

        $time = substr($date, strpos($date, ' ') + 1);
        $time = trim($time);

        if(!empty($time)) {
            $return[] = $time;
        }

        return implode(' ', $return);
    }

    public function model(array $row): ?Model
    {

        $event = new Event([
            'status' => 'APPROVED',
            'title' => $row['activity_title'],
            'slug' => str_slug($row['activity_title']),
            'organizer' => $row['name_of_organisation'],
            'description' => $row['description'],
            'organizer_type' => $row['type_of_organisation'],
            'activity_type' => $row['activity_type'],
            'location' => isset($row['address']) ? $row['address'] : 'online',
            'event_url' => $row['organiser_website'],
            'contact_person' => !empty($row['contact_email']) ? $row['contact_email'] : '',
            'user_email' => '',
            'creator_id' => 132942,
            'country_iso' => $row['country'],
            'picture' => isset($row['image_path']) ? $row['image_path'] : '',
            'pub_date' => now(),
            'created' => now(),
            'updated' => now(),
            'codeweek_for_all_participation_code' => '',
            'start_date' => $this->parseDate($row['start_date']),
            'end_date' => $this->parseDate($row['end_date']),
            'geoposition' => $row['latitude'].','.$row['longitude'],
            'longitude' => $row['longitude'],
            'latitude' => $row['latitude'],
            'language' => $row['language'],
            'approved_by' => 19588,
            'mass_added_for' => 'Excel',
        ]);

        $event->save();

        $event->audiences()->attach(explode(',', $row['audience_comma_separated_ids']));
        $event->themes()->attach(explode(',', $row['theme_comma_separated_ids']));

        return $event;

    }
}