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