<?php

namespace App\Imports;

use App\Models\Tugas;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use Maatwebsite\Excel\Concerns\WithCalculatedFormulas;

class TugasImport implements ToModel, WithHeadingRow, WithCalculatedFormulas
{
    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        return new Tugas([
            'nim'=> $row['nim'],
        'nama'=> $row['nama'],
        'kodeprak'=> $row['praktikum'],
        'satu'=> $row['1'],
        'dua'=> $row['2'],
        'tiga'=> $row['3'],
        'empat'=> $row['4'],
        'lima'=> $row['5'],
        'enam'=> $row['6'],
        'tujuh'=> $row['7'],
        'delapan'=> $row['8'],
        'sembilan'=> $row['9'],
        'sepuluh'=> $row['10'],
        'rerata'=> $row['rerata'],
        ]);
    }
}