/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $validasi = Validator::make($request->all(), Kelas::$rulesbaru, Kelas::$pesan); if ($validasi->fails()) { return Redirect::back()->withInput()->WithErrors($validasi); } else { $kode = $request->input('kode') . '-' . $request->input('jurusan') . '-' . $request->input('sub'); $cek = Kelas::where('kd_kelas', $kode)->count(); if ($cek > 0) { Session::flash('pesan', "Kode kelas sudah digunakan"); return Redirect::back(); } $kelas = new Kelas(); $kelas->kd_kelas = $request->input('kode') . '-' . $request->input('jurusan') . '-' . $request->input('sub'); $kelas->kelas = $request->input('kode'); $kelas->kode_jurusan = $request->input('jurusan'); $kelas->sub_kelas = $request->input('sub'); $kelas->save(); Session::flash('pesan', "Data Berhasil disimpan"); return Redirect::to('admin/kelas'); } }
public function tambah_ruang($id) { $jadwal = Jadwal::find($id); $kelas = Kelas::where('kode_jurusan', $jadwal->kode_jurusan)->get(); //$ruang=DB::select("select * from ruang_ujian where id_ruang not in(select detail_jadwal.id_ruang from detail_jadwal // where id_jadwal='$id' and ruang_ujian.id_ruang=detail_jadwal.id_ruang)"); $ruang = DB::select("select * from ruang_ujian where ruang_ujian.id_ruang not in(\n select view_detail_jadwal.id_ruang from view_detail_jadwal where view_detail_jadwal.id_ruang=ruang_ujian.id_ruang\n and view_detail_jadwal.tgl_ujian='{$jadwal->tgl_ujian}'\n and view_detail_jadwal.jam >= '{$jadwal->jam}'\n and view_detail_jadwal.selesai <= '{$jadwal->selesai}')"); $pengawas = DB::select("select * from pengawas where pengawas.nip not in(\n select view_detail_jadwal.pengawas from view_detail_jadwal where view_detail_jadwal.pengawas=pengawas.nip\n and view_detail_jadwal.tgl_ujian='{$jadwal->tgl_ujian}'\n and view_detail_jadwal.jam >= '{$jadwal->jam}'\n and view_detail_jadwal.selesai <= '{$jadwal->selesai}')"); return View('admin.jadwal.tambah_ruang')->with('kelas', $kelas)->with('ruang', $ruang)->with('pengawas', $pengawas)->with('jadwal', $jadwal); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $jurusan = Jurusan::find($id); $kelas = Kelas::where('kode_jurusan', $id)->count(); if ($kelas > 0) { $html = "Data Tidak dapat dihapus"; } else { $html = "Data berhasil dihapus"; $jurusan->delete(); } Session::flash('pesan', $html); return Redirect::to('admin/jurusan'); }