<?php

namespace App\Imports;

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

class KeaktifanImport implements ToModel, WithHeadingRow, WithCalculatedFormulas
{
    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        return new Keaktifan([
            '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'],
        'jumlah'=> $row['jumlah'],
        'kesimpulan'=> $row['kesimpulan'],
        ]);
    }
}