<?php

namespace App\Http\Controllers;

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

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

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        $praktikums=Praktikum::all();
        return view('dashboards.laporan.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',
            'penglap'=> 'required',
        ]);
    
        Laporan::create($request->all());
     
        return redirect()->route('adminIndexLaporan')
                        ->with('success','Data Telah Ditambahkan.');
    }

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

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Models\Praktikum  $praktikum
     * @return \Illuminate\Http\Response
     */
    public function edit(Laporan $datalaporan)
    {
        $praktikums=Praktikum::all();
        return view ('dashboards.laporan.edit', [
                     'datalaporan'=>$datalaporan,
                     '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, Laporan $datalaporan)
    {
        $request->validate([
            'nim'=> 'required',
            'nama'=> 'required',
            'kodeprak'=> 'required',
            'penglap'=> 'required',
        ]);
    
        $datalaporan->update($request->all());
    
        return redirect()->route('adminIndexLaporan')
                        ->with('success','Data Telah Diperbaharui.');
    }

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

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

    public function deleteAll(Request $request)
    {
        $ids = $request->ids;
        Laporan::whereIn('idlaporan',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 LaporanImport, $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.');
        }
    }
}