public function save(Request $request)
{
$this->validate($request, ['semester' => 'required', 'tahun_ajaran' => 'required', 'password' => 'required']);
if (!\Hash::check($request->input('password'), \Auth::user()->password)) {
return redirect()->route('semester')->with('message', "Password tidak tepat.");
}
$check = Semester::where('semester', $request->input('semester'))->where('tahun_ajaran', $request->input('tahun_ajaran'))->first();
if ($check) {
return redirect()->route('semester')->with('message', "Semester sudah ada.");
}
$old = Semester::get_active_semester();
Semester::where('aktif', 1)->update(['aktif' => 0]);
try {
$new = new Semester();
$new->semester = $request->input('semester');
$new->tahun_ajaran = $request->input('tahun_ajaran');
$new->aktif = 1;
$new->save();
} catch (\Illuminate\Database\QueryException $e) {
$old->aktif = 1;
$old->save();
}
// Naik kelas
if ($request->input('semester') == 1) {
$all_kelas = Kelas::get();
foreach ($all_kelas as $kelas) {
$kelas->tingkat = $kelas->tingkat + 1;
$kelas->save();
}
}
// AUTO
// Buat kelas X
if ($request->input('autoKelas')) {
$all_kelas = Kelas::where('tingkat', '=', 2)->get();
foreach ($all_kelas as $kelas) {
$new = new Kelas();
$new->tingkat = 1;
$new->id_jurusan = $kelas->id_jurusan;
$new->kelas = $kelas->kelas;
$new->angkatan = $kelas->angkatan;
$new->save();
}
}
// Ketuntasan Belajar
if ($request->input('autoKB')) {
KetuntasanBelajar::copy();
}
// Asosiasi Mengajar
if ($request->input('autoMengajar')) {
Mengajar::copy();
}
return redirect()->route('panel_utama')->with('message', "Semester telah berhasil dimajukan.");
}
public function mass(Request $request)
{
if (!$request->ajax()) {
abort(404);
}
$this->validate($request, ['type' => 'required|integer']);
$semester = Semester::get_active_semester()->id;
if (!($prevSemester = Semester::get_previous_semester())) {
return response("Semester sebelumnya tidak dapat ditemukan.", 422);
}
$prevSemester = $prevSemester->id;
if ($request->type == 1 || $request->type == 2) {
$targets = Mapel::get_unset_kb();
foreach ($targets as $target) {
$new = new KetuntasanBelajar();
$new->id_mapel = $target->id;
$new->id_semester = $semester;
if ($target->kelompok == 'A' | $target->kelompok == 'B' | $target->kelompok == 'C1') {
$n = 60;
} elseif ($target->kelompok == 'C2' | $target->kelompok == 'C3') {
$n = 70;
}
$new->kb_tingkat_1p = $n;
$new->kb_tingkat_2p = $n;
$new->kb_tingkat_3p = $n;
$new->kb_tingkat_1k = $n;
$new->kb_tingkat_2k = $n;
$new->kb_tingkat_3k = $n;
$new->save();
}
}
if ($request->type == 2) {
$targets = Mapel::get_set_kb();
foreach ($targets as $target) {
$new = KetuntasanBelajar::where('id_mapel', '=', $target->id)->where('id_semester', '=', $semester)->first();
$new->id_semester = $semester;
if ($target->kelompok == 'A' | $target->kelompok == 'B' | $target->kelompok == 'C1') {
$n = 60;
} elseif ($target->kelompok == 'C2' | $target->kelompok == 'C3') {
$n = 70;
}
KetuntasanBelajar::where('id_mapel', '=', $target->id)->where('id_semester', '=', $semester)->update(['kb_tingkat_1p' => $n, 'kb_tingkat_2p' => $n, 'kb_tingkat_3p' => $n, 'kb_tingkat_1k' => $n, 'kb_tingkat_2k' => $n, 'kb_tingkat_3k' => $n]);
}
}
if ($request->input('type') == 3) {
$copy = null;
try {
$copy = KetuntasanBelajar::copy($prevSemester, $semester);
} catch (Exception $e) {
return response("Penyalinan aturan ketuntasan belajar dari semester sebelumnya gagal dilakukan.", 422);
}
}
return 'KB berhasil diubah secara massal.';
}
