<?php

namespace App\Imports;

use App\Models\Chart_data;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithHeadingRow;

class ImportChartData implements ToModel, WithHeadingRow
{
    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        return new Chart_data([
            'position_no'                   => @$row['position_no'],
            'reporting_to_position_no'      => @$row['reporting_to_position_no'], 
            'n_level'                       => @$row['n_level'],
            'position_code'                 => @$row['position_code'],
            'reporting_to_position_code'    => @$row['reporting_to_position_code'], 
            'group_n1'                      => @$row['group_n1'],
            'sub_division_n3'               => @$row['sub_divison_n3'],
            'department_n4'                 => @$row['department_n4']
        ]);
    }
}