public function save(Request $request)
{
$this->validate($request, ['id_siswa' => 'required|exists:siswa,id', 'mitra' => 'required', 'lokasi' => 'required', 'lama' => 'required|integer', 'keterangan' => 'required']);
$siswa = Siswa::find($request->input('id_siswa'));
if (!$siswa) {
return response('NIS siswa tidak dapat ditemukan.', 422);
}
$created = null;
$check = Pkl::where('mitra', $request->input('mitra'))->where('lokasi', $request->input('lokasi'))->where('id_siswa', $siswa->id)->where('id_semester', Semester::get_active_semester()->id);
$old = $check->first();
if ($old) {
$created = $old->created_at;
$check->delete();
}
$new = new Pkl();
$new->mitra = $request->input('mitra');
$new->lokasi = $request->input('lokasi');
$new->lama = $request->input('lama');
$new->keterangan = $request->input('keterangan');
$new->id_siswa = $siswa->id;
$new->id_semester = Semester::get_active_semester()->id;
if ($created) {
$new->created_at = $created;
}
try {
$save = $new->save();
} catch (\Illuminate\Database\QueryException $e) {
return response($e . 'Operasi gagal. Coba cek kembali, mungkin ada kesalahan pada data yang dimasukkan.', 422);
}
if ($request->ajax()) {
return 'Catatan PKL berhasil ditambahkan.';
} else {
return redirect()->route('nilai.prestasi')->with('message', 'Catatan PKL berhasil ditambahkan.');
}
}
public function detail(Request $request)
{
if ($request->ajax()) {
$np = Prestasi::find($request->input('id'));
$siswa = Siswa::find($np->id_siswa);
$detail = ['id' => $request->input('id'), 'nis' => $siswa->nis, 'nama' => $siswa->nama, 'prestasi' => $np->prestasi, 'keterangan' => $np->keterangan];
return json_encode($detail);
} else {
abort(404);
}
}
public function detail(Request $request)
{
if (!$request->ajax()) {
abort(404);
}
$this->validate($request, ['id_siswa' => 'required|exists:siswa,id']);
$siswa = Siswa::find($request->input('id_siswa'));
$absensi = Absensi::get_absensi($request->input('id_siswa'));
$detail = ['sakit' => $absensi ? $absensi->sakit : null, 'izin' => $absensi ? $absensi->izin : null, 'alpa' => $absensi ? $absensi->alpa : null];
$detail = array_merge($detail, ['nis' => $siswa->nis, 'nama' => $siswa->nama]);
return json_encode($detail);
}
public function detail(Request $request)
{
if (!$request->ajax()) {
abort(404);
}
$this->validate($request, ['id_siswa' => 'required|exists:siswa,id']);
$siswa = Siswa::find($request->input('id_siswa'));
$nilai = NilaiSikap::get_nilai($request->input('id_siswa'), $request->input('id_semester'));
$detail['sikap'] = $nilai ? $nilai->sikap : '';
$detail = array_merge($detail, ['nis' => $siswa->nis, 'nama' => $siswa->nama]);
return json_encode($detail);
}
public function detail(Request $request)
{
if (!$request->ajax()) {
abort(404);
}
$this->validate($request, ['id_siswa' => 'required|exists:siswa,id', 'id_mapel' => 'required|exists:mapel,id']);
$siswa = Siswa::find($request->input('id_siswa'));
$nilai = NilaiAkhir::get_nilai($request->input('id_siswa'), $request->input('id_mapel'), $request->input('id_semester'));
if ($nilai) {
$detail = ['nilai_pengetahuan' => $nilai->nilai_pengetahuan, 'deskripsi_pengetahuan' => $nilai->deskripsi_pengetahuan, 'nilai_keterampilan' => $nilai->nilai_keterampilan, 'deskripsi_keterampilan' => $nilai->deskripsi_keterampilan];
} else {
$detail = ['nilai_pengetahuan' => null, 'deskripsi_pengetahuan' => null, 'nilai_keterampilan' => null, 'deskripsi_keterampilan' => null];
}
$detail = array_merge($detail, ['nis' => $siswa->nis, 'nama' => $siswa->nama]);
return json_encode($detail);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
Siswa::find($id)->delete();
return redirect(url('siswa'));
}
public function delete(Request $request)
{
$siswa = Siswa::find($request->id);
if ($siswa) {
$siswa->delete();
return redirect()->route('siswa')->with('message', 'Data siswa telah dihapus.');
} else {
return redirect()->route('siswa');
}
}
public function pkl_datalist(Request $request)
{
$this->validate($request, ['id_siswa' => 'required|exists:siswa,id', 'id_semester' => 'required|exists:semester,id']);
$data = Pkl::get_all_catatan($request->input('id_siswa'), $request->input('id_semester'));
$siswa = Siswa::find($request->input('id_siswa'));
$tbody = '';
if (count($data) < 1) {
$tbody = "<tr><td colspan='99'><center>Tidak ada catatan PKL.</center></td></tr>";
} else {
foreach ($data as $i) {
$tbody .= '<tr><td>' . $i->mitra . '</td>' . '<td>' . $i->lokasi . '</td>' . '<td>' . $i->lama . '</td>' . '<td>' . $i->keterangan . '</td>' . "<td><span class='nobr'>[ <a href=\"javascript:lihat('" . $request->input('id_siswa') . "','" . htmlspecialchars($i->mitra) . "','" . htmlspecialchars($i->lokasi) . "','" . htmlspecialchars($request->input('id_semester')) . "')\">Lihat</a> ]</span> " . "</tr>";
}
}
return ['data' => $tbody, 'siswa' => $siswa->nama];
}
