<?php

namespace App\Imports;

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

class KehadiranImport implements ToModel, WithHeadingRow, WithCalculatedFormulas
{
    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        return new Kehadiran([
            'nim' => $row['nim'],
            'nama' => $row['nama'],
            'kodeprak' => $row['praktikum'],
            'hadir' => $row['total_hadir'],
            'takhadir' => $row['total_tidak_hadir'],
            'kesimpulan' => $row['kesimpulan'],
        ]);
    }
}