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 static function copy($previousSemester = null, $currentSemester = null) { $previousSemester = $previousSemester ? $previousSemester : Semester::get_previous_semester()->id; $currentSemester = $currentSemester ? $currentSemester : Semester::get_active_semester()->id; $now = \Carbon\Carbon::now(); $prevKB = KetuntasanBelajar::where('id_semester', '=', $previousSemester)->get()->toArray(); $fail = 0; $success = 0; foreach ($prevKB as $KB) { try { KetuntasanBelajar::where('id_mapel', $KB['id_mapel'])->where('id_semester', $currentSemester)->delete(); KetuntasanBelajar::insert(['id_mapel' => $KB['id_mapel'], 'id_semester' => $currentSemester, 'kb_tingkat_1p' => $KB['kb_tingkat_1p'], 'kb_tingkat_1k' => $KB['kb_tingkat_1k'], 'kb_tingkat_2p' => $KB['kb_tingkat_2p'], 'kb_tingkat_2k' => $KB['kb_tingkat_2k'], 'kb_tingkat_3p' => $KB['kb_tingkat_3p'], 'kb_tingkat_3k' => $KB['kb_tingkat_3k']]); } catch (\Illuminate\Database\QueryException $e) { $fail++; continue; } $success++; } return ['fail' => $fail, 'success' => $success]; }
/** * Halaman utama bagi staf. */ public function index() { // Ambil data semester yang aktif $pass['semester'] = Semester::get_active_semester(); // Pengecekan // 0 = fine // 1 = warning // 2 = error // Cek apakah ada jurusan tercatat $pass['jurusan'] = Jurusan::all()->count(); // Cek apakah kelas tingkat 1 sudah dibuat $kelas = Kelas::check_firstyears(); $pass['kelas'] = $kelas; if ($kelas['total'] == 0) { $pass['kelas']['cek'] = 2; } elseif ($kelas['count'] < $kelas['jurusan']) { $pass['kelas']['cek'] = 1; } else { $pass['kelas']['cek'] = 0; } // Cek apakah ada kelas tingkat 1 yang kosong $siswa = Siswa::check_firstyears(); $pass['siswa'] = $siswa; if ($siswa['siswa_tingkat_x'] <= 0) { $pass['siswa']['cek'] = 2; } elseif ($siswa['kelas_kosong'] > 0) { $pass['siswa']['cek'] = 1; } else { $pass['siswa']['cek'] = 0; } // Cek apakah semua mapel sudah memiliki angka KB untuk semester ini $pass['kb'] = KetuntasanBelajar::check(); // Cek apakah ada guru yang belum mendapat asosiasi pengajaran $pass['mengajar'] = Mengajar::check(); return view('panel', $pass); }
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.'; }