✏️ Editing: AirportImportIATA.php

<?php

namespace Modules\Flight\Imports;

use Illuminate\Contracts\Queue\ShouldQueue;
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithBatchInserts;
use Maatwebsite\Excel\Concerns\WithChunkReading;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use Maatwebsite\Excel\Concerns\WithUpsertColumns;
use Maatwebsite\Excel\Concerns\WithUpserts;
use Modules\Flight\Models\Airport;

class AirportImportIATA implements WithChunkReading,ToModel,ShouldQueue,WithHeadingRow,WithBatchInserts,WithUpserts,WithUpsertColumns
{
    use Importable;

public function model(array $row)
    {
        $data = [
            'name' => $row['name'],
            'code' => $row['iata_code'],
            'map_lat' => $row['latitude_deg'],
            'map_lng' => $row['longitude_deg'],
            'address' => $row['municipality'],
            'country'=>$row['iso_country'],
            'status'=>'draft'
        ];
        $a =  new Airport();
        $a->fillByAttr(array_keys($data),$data);
        return $a;
    }
    /**
     * @return array
     */
    public function upsertColumns()
    {
        return ['name', 'map_lat','map_lng','address','country'];
    }

/**
     * @return string|array
     */
    public function uniqueBy()
    {
        return 'code';
    }

public function batchSize(): int
    {
        return 50;
    }

public function chunkSize(): int
    {
        return 500;
    }
}

Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team



Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team