One Hat Cyber Team

Your IP: 216.73.216.142
Server IP: 217.76.53.76
Server: Linux vmi1397931.contaboserver.net 5.4.0-105-generic #119-Ubuntu SMP Mon Mar 7 18:49:24 UTC 2022 x86_64
Server Software: Apache
PHP Version: 8.2.27
Buat File | Buat Folder

Dir : ~/www/wwwroot/app.247quizshow.com/app/Imports/

View File Name : QuestionsImport.php

<?php

namespace App\Imports;

use App\Question;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithHeadingRow;

class QuestionsImport implements ToModel, WithHeadingRow
{
    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        return new Question([
            'topic_id' => $row['topic_id'], 
            'question' => $row['question'], 
            'a' => $row['a'], 
            'b' => $row['b'], 
            'c' => $row['c'], 
            'd' => $row['d'],
            'e' => $row['e'] != '' ? $row['e'] : NULL,
            'f' => $row['f'] !='' ? $row['f'] : NULL, 
            'answer' => $row['answer'], 
            'code_snippet' => $row['code_snippet'] != '' ? $row['code_snippet'] : '-', 
            'answer_exp' => $row['answer_exp'] != '' ? $row['answer_exp'] : '-',
            'question_video_link' => $row['question_video_link'] != '' ? $row['question_video_link'] : NULL,
            'question_audio' => $row['question_audio'] != '' ? $row['question_audio'] : NULL
        ]);
    }
}