<?php

namespace App\Jobs;

use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Queue\SerializesModels;
use App\Models\Word;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Storage;

class ImportCSVFileJob implements ShouldQueue
{
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;

    protected $filepath;

    /**
     * Create a new job instance.
     */
    public function __construct($filepath)
    {
        $this->filepath = $filepath;
    }

    /**
     * Execute the job.
     */
    public function handle(): void
    {
        $mapping = [
            'name' => 0, 'translation' => 1,
        ];
        $fileStream = fopen($this->filepath, 'r');
        $skipHeader = true;
        $finalarray = array();
        while ($row = fgetcsv($fileStream)) {
            if ($skipHeader) {
                $skipHeader = false;
                continue;
            }
            $finalarray[] = array(
                'name' => $row[$mapping['name']],
                'translation' => $row[$mapping['translation']],
            );
        }
        //insert multy-record in DB
        DB::table('words')->upsert($finalarray, 'name');
        //delete file from storage after upsert
        Storage::delete('new_file.csv');
    }
}