public function sedang_ujian(Request $request, $jadwal, $detail)
 {
     $infojadwal = Jadwal::find($jadwal);
     //hitung jam
     $awal = date('H:i:s');
     $akhir = date('H:i:s', strtotime($infojadwal->selesai));
     list($h, $m, $s) = explode(":", $awal);
     $dtawal = mktime($h, $m, $s, "1", "1", "1");
     list($h2, $m2, $s2) = explode(":", $akhir);
     $dtakhir = mktime($h2, $m2, $s2, "1", "1", "1");
     $dtselisih = $dtakhir - $dtawal;
     $totaldetik = $dtselisih;
     //end hitung jam
     $detailsoal = DB::Table('soal_siswa')->where('nis', $this->getNis())->where('id_jadwal', $jadwal)->where('id_detail_jadwal', $detail)->orderBy('soal_ke', 'asc')->get();
     return View('siswa.ujian_berlangsung')->with('detail', $detailsoal)->with('jadwal', $jadwal)->with('detailjadwal', $detail)->with('detik', $totaldetik);
 }
 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($idjadwal)
 {
     $kelas = Jadwal::find($idjadwal);
     $kelas->delete();
     return Redirect::to('/administrator/jadwal')->with('msgs', $kelas->krs->mahasiswa->nama_mahasiswa . ' berhasil dihapus dari kelas ' . '<b>' . $kelas->kelas->kelas . '<b/>');
 }
 public function tambah_ruang($id)
 {
     $jadwal = Jadwal::find($id);
     $kelas = Kelas::all();
     $ruang = Ruang::all();
     $pengawas = Pengawas::all();
     return View('admin.jadwal.tambah_ruang')->with('kelas', $kelas)->with('ruang', $ruang)->with('pengawas', $pengawas)->with('jadwal', $jadwal);
 }
 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);
 }