<?php

namespace App\Http\Controllers\Dashboard;

use Illuminate\Http\Request;
use App\Http\Controllers\Controller;

use App\User;
use App\Models\Users_nilai;

class Peserta_controller extends Controller
{
    public function index(){
        $title = 'Data peserta';
        $data = User::withCount('biodata_r')->whereNull('role')->orderBy('name','asc')->get();

        return view('dashboard.peserta.index',compact('title','data'));
    }

    public function export($id){
        $dt = User::find($id);
        $title = 'Data Peserta '.$dt->name;
        // dd($dt);
        \Excel::create($title, function($excel) use($dt,$title) {
            $excel->sheet('Sheetname', function($sheet) use($dt,$title) {

                $sheet->loadView('dashboard.peserta.excel')->with('dt',$dt)->with('title',$title);

            });
        })->export('xls');
    }

    public function excel(Request $request){
        if($request->hasFile('sample_file')){
            $path = $request->file('sample_file')->getRealPath();
            $data = \Excel::load($path)->get();
            // dd($data);
            if($data->count()){
                // $uuid = \Uuid::generate(4);
                // $gr = $this->create_header_gr();
                // dd($gr);
                foreach ($data as $key => $vl) {
                    $nisn = (String)$vl->nisn;
                    $nilai_baca_quran = (Int)$vl->nilai_baca_quran;
                    $nilai_test_akademik = (Int)$vl->nilai_test_akademik;

                    Users_nilai::insert([
                        'nisn'=>$nisn,
                        'nilai_baca_quran'=>$nilai_baca_quran,
                        'nilai_test_akademik'=>$nilai_test_akademik,
                        'created_at'=>date('Y-m-d H:i:s'),
                        'updated_at'=>date('Y-m-d H:i:s')
                    ]);
                }
            }
        }
        \Session::flash('sukses','Nilai berhasil di import');
        return redirect()->back();
    }

    public function diverifikasi(){
        $title = 'Data peserta yang sudah di verifikasi';
        $data = User::withCount('biodata_r')->where('is_verifikasi',1)->orderBy('name','asc')->get();

        return view('dashboard.peserta.index',compact('title','data'));
    }

    public function belum_verifikasi(){
        $title = 'Data peserta yang belum di verifikasi';
        $data = User::withCount('biodata_r')->whereNull('is_verifikasi')->orderBy('name','asc')->get();

        return view('dashboard.peserta.index',compact('title','data'));
    }

    public function edit($id){
        $title = 'Edit Data peserta';
        $dt = User::with('biodata_r')->find($id);

        return view('dashboard.peserta.edit',compact('title','dt'));
    }

    public function delete($id){
        try {
            User::where('id',$id)->delete();
            \Session::flash('sukses','Data berhasil dihapus');
        } catch (\Exception $e) {
            \Session::flash('gagal',$e->getMessage());
        }

        return redirect()->back();
    }

    public function lulus($id){
        try {
            User::where('id',$id)->update([
                'is_lulus'=>1
            ]);

            \Session::flash('sukses','Peserta Diterima');
        } catch (\Exception $e) {
            \Session::flash('gagal',$e->getMessage());
        }

        return redirect('peserta');
    }
}