/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { //dd($request); foreach ($request->id as $nikData) { $data = ['idk' => $nikData, 'angkatan' => $request->angkatan]; $dataR = ['id' => $nikData]; $sl8 = new Itc($data); $raport = Raport::where('id', $dataR)->update(['issl8' => 1]); $sl8->save(); $request->session()->flash('alert-success', 'Input data sukses'); } return Redirect::back(); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function showId($id, $jenis) { $xid = ""; if ($jenis === "id") { $xid = "id"; $student = Raport::where($xid, \Crypt::decrypt($id))->first(); //$evabul = null; //$nilaiitc = null; return view('/admin.student.showStudent')->with('student', $student); } else { $xid = "nik"; $student = Raport::where($xid, \Crypt::decrypt($id))->first(); $nilaiitc = Itc::leftjoin('raports', 'raports.nik', '=', 'itc.nik')->where('raports.' . $xid, \Crypt::decrypt($id))->first(); $nilaievabul = Evabul::leftjoin('raports', 'raports.nik', '=', 'evabul.idk')->where('raports.' . $xid, \Crypt::decrypt($id))->first(); if ($nilaievabul === null) { $isevabul = 0; } else { $isevabul = 1; } if ($nilaiitc === null) { $isitc = 0; } else { $isitc = 1; } return view('/admin.student.showStudent')->with('student', $student)->with('nilaiitc', $nilaiitc)->with('nilaievabul', $nilaievabul)->with('isitc', $isitc)->with('isevabul', $isevabul); } }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($angkatan) { $raport = Raport::where('angkatan', $angkatan)->paginate(10); $jumlah = Raport::where('angkatan', $angkatan)->count(); $lulus = Raport::where('lulus', '=', 'LULUS')->where('angkatan', $angkatan)->count(); $nlulus = Raport::where('lulus', '=', 'TIDAK LULUS')->where('angkatan', $angkatan)->count(); $nnlulus = Raport::where('lulus', '=', 'PENDING KONTRAK')->where('angkatan', $angkatan)->count(); $nnnlulus = Raport::where('lulus', '=', 'PENDING TRAINING')->where('angkatan', $angkatan)->count(); $nnnnlulus = Raport::where('lulus', '=', 'OUT')->where('angkatan', $angkatan)->count(); $nnnnnlulus = Raport::where('lulus', '=', 'MENGUNDURKAN DIRI')->where('angkatan', $angkatan)->count(); $npm = Raport::where('jabatan', '=', 'PRAMUNIAGA')->where('lulus', '=', 'LULUS')->where('angkatan', $angkatan)->count(); $nks = Raport::where('jabatan', '=', 'KASIR')->where('lulus', '=', 'LULUS')->where('angkatan', $angkatan)->count(); $nsbm = Raport::where('jabatan', '=', 'SBM')->where('lulus', '=', 'LULUS')->where('angkatan', $angkatan)->count(); $nopen = Raport::where('jabatan', '=', 'OPENING')->where('lulus', '=', 'LULUS')->where('angkatan', $angkatan)->count(); return view('/admin.raport.raportAngkatan', ['raport' => $raport, 'jumlah' => $jumlah, 'lulus' => $lulus, 'nlulus' => $nlulus, 'nnlulus' => $nnlulus, 'nnnlulus' => $nnnlulus, 'nnnnlulus' => $nnnnlulus, 'nnnnnlulus' => $nnnnnlulus, 'npm' => $npm, 'nks' => $nks, 'nsbm' => $nsbm, 'nopen' => $nopen])->with('angkat', $angkatan); }