/**
* 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);
}
