One Hat Cyber Team

Your IP: 216.73.216.1
Server IP: 185.238.29.86
Server: Linux server2 6.8.12-6-pve #1 SMP PREEMPT_DYNAMIC PMX 6.8.12-6 (2024-12-19T19:05Z) x86_64
Server Software: nginx/1.18.0
PHP Version: 8.1.31
Buat File | Buat Folder

Dir : ~/var/www/muhasebe/modules/Flight/Imports/

View File Name : 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;
    }
}