<?php

namespace App\Imports;

use App\Models\Testresult;
use Maatwebsite\Excel\Concerns\ToModel;
use PhpOffice\PhpSpreadsheet\Shared\Date;
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\WithStartRow;
use Maatwebsite\Excel\Concerns\SkipsEmptyRows;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use Maatwebsite\Excel\Concerns\WithValidation;

class ImportTestresult implements ToModel, WithStartRow, WithValidation, WithHeadingRow, SkipsEmptyRows
{
	use Importable;
	public function startRow(): int
	{
		return 2;
	}

	public function rules(): array
	{
		return [
			"users_admission_id"		=> "required|exists:users_admissions,id",
			"testcode"							=> "required",
			"subject"					=> "required",
			"max_marks"				=> "required",
			"obtained_marks"	=> "nullable",
			"date"						=> "required"
		];
	}

	public function model(array $row)
	{
		return new Testresult([
			'users_admission_id'	=> $row['users_admission_id'],
			'testcode'				=> $row['testcode'],
			'subject'			=> $row['subject'],
			'max_marks'			=> $row['max_marks'],
			'obtained_marks'	=> $row['obtained_marks'],
			'date'				=> Date::excelToDateTimeObject($row['date'])->format('Y-m-d')
		]);
	}
}