<?php

namespace App\Http\Controllers;

use App\Models\Tugas;
use App\Models\Praktikum;
use Illuminate\Http\Request;
use App\Imports\TugasImport;
use Illuminate\Support\Facades\DB;
use Maatwebsite\Excel\Facades\Excel;
use PhpParser\Node\Stmt\TryCatch;
use Maatwebsite\Excel\Exceptions\NoTypeDetectedException;

class TugasController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $tugass=Tugas::all();
        $praktikums=Praktikum::all();
        return view ('dashboards.tugas.index', [
            'tugass'=>$tugass,
            'praktikums'=>$praktikums,
        ]);
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        $praktikums=Praktikum::all();
        return view ('dashboards.tugas.create', [
            'praktikums'=>$praktikums,
        ]);
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        $request->validate([
            'nim'=> 'required',
        'nama'=> 'required',
        'kodeprak'=> 'required',
        'satu'=> 'required',
        'dua'=> 'required',
        'tiga'=> 'required',
        'empat'=> 'required',
        'lima'=> 'required',
        'enam'=> 'required',
        'tujuh'=> 'required',
        'delapan'=> 'required',
        'sembilan'=> 'required',
        'sepuluh'=> 'required',
        'rerata'=> 'required',
        ]);
    
        Tugas::create($request->all());
     
        return redirect()->route('adminIndexTugas')
                        ->with('success','Data Telah Ditambahkan.');
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\Models\Praktikum  $praktikum
     * @return \Illuminate\Http\Response
     */
    public function show(Tugas $kehadiran)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Models\Praktikum  $praktikum
     * @return \Illuminate\Http\Response
     */
    public function edit(Tugas $datatugas)
    {
        $praktikums=Praktikum::all();
        return view ('dashboards.tugas.edit', [
                     'datatugas'=>$datatugas,
                     'praktikums'=>$praktikums,
        ]);
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Models\Praktikum  $praktikum
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Tugas $datatugas)
    {
        $request->validate([
            'nim'=> 'required',
        'nama'=> 'required',
        'kodeprak'=> 'required',
        'satu'=> 'required',
        'dua'=> 'required',
        'tiga'=> 'required',
        'empat'=> 'required',
        'lima'=> 'required',
        'enam'=> 'required',
        'tujuh'=> 'required',
        'delapan'=> 'required',
        'sembilan'=> 'required',
        'sepuluh'=> 'required',
        'rerata'=> 'required',
        ]);
    
        $datatugas->update($request->all());
    
        return redirect()->route('adminIndexTugas')
                        ->with('success','Data Telah Diperbaharui.');
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Models\Praktikum  $praktikum
     * @return \Illuminate\Http\Response
     */
    public function destroy(Tugas $datatugas)
    {

        $datatugas->delete();
    
        return redirect()->route('adminIndexTugas')
                        ->with('success','Data Telah Dihapus.');
    }

    public function deleteAll(Request $request)
    {
        $ids = $request->ids;
        Tugas::whereIn('idtugas',explode(",",$ids))->delete();
        
        return response()->json(['success'=>"Data Terpilih Telah Dihapus."]);
    }
    
    // public function destroymany(array $kodeprak)
    // {
    //     Kehadiran::destroy($kodeprak);
    //     return redirect()->route('adminIndexKehadiran')
    //                     ->with('success','Data Telah Dihapus.');
    // }

    public function import(Request $request){
        try { 
            Excel::import(new TugasImport, $request->file('file'));
            return redirect()->back()->with('success','Data Telah Diunggah.');
        } catch(\Illuminate\Database\QueryException $ex){ 
            return redirect()->back()->with('gagal','Data pada file anda mungkin bermasalah silahkan perbarui file anda atau silahkan tambahkan data praktikum terkait terlebih dahulu karena halaman ini memiliki relasi dengan kode praktikum.');
        } catch (NoTypeDetectedException $e) {
            return redirect()->back()->with('gagal','Data haruslah file excel.');
        } catch(\PhpOffice\PhpSpreadsheet\Reader\Exception $e) {
            return redirect()->back()->with('gagal','Data haruslah file excel.');
        }
    }
}