public function cetak_ujian() { $rombel = Input::get('tahun') . '-' . Input::get('kelas'); $kelas = Input::get('kelas'); $tahun = Input::get('tahun'); $nip = Input::get('nip'); $mapel = Input::get('mapel'); $semester = Input::get('semester'); $koderombel = Rombel::find($rombel); $cari = DB::table('nilai_ujian')->where('kd_rombel', '=', $rombel)->where('kd_mapel', '=', $mapel)->where('semester', '=', $semester)->join('siswa', 'siswa.nis', '=', 'nilai_ujian.nis'); $cekNilai = $cari->count(); if ($cekNilai > 0) { $nilai = $cari->get(); return View::make('laporan.cetak_ujian')->with('title', 'Laporan Nilai Ujian')->with('nilai', $nilai)->with('kelas', $kelas)->with('tahun', $tahun)->with('mapel', $mapel)->with('semester', $semester)->with('kode', $koderombel); } else { Session::flash('pesan', "<div class='alert alert-danger'>\n Data tidak ditemukan</div>"); return Redirect::back(); } }
public function cetak_raport() { $rombel = Input::get('rombel'); $semester = Input::get('semester'); $siswa = Siswa::where('nis', Sentry::getUser()->username)->first(); $setting = DB::table('setting')->first(); $nilai = DB::table('nilai_ujian')->where('kd_rombel', '=', $rombel)->where('nis', $siswa->nis)->where('semester', $semester)->groupBy('kd_mapel')->get(); $kelas = Rombel::find($rombel); return View::make('hal_siswa.cetak_raport')->with('nilai', $nilai)->with('rombel', $rombel)->with('nis', $siswa)->with('kelas', $kelas)->with('semester', $semester)->with('setting', $setting)->with('title', 'Laporan Nilai Raport'); }
public function view() { if (Request::ajax()) { $rombel = Rombel::find(Input::get('rombel')); $jadwal = DB::table('jadwal')->where('kd_rombel', '=', $rombel->kd_rombel)->get(); $mapel = Mapel::all(); return View::make('hal_siswa.view_jadwal')->with('rombel', $rombel)->with('mapel', $mapel); } }
public function cetak_n_ujian() { $cekrombel = DB::table('rombel')->where('kd_rombel', Input::get('kelas'))->count(); if ($cekrombel > 0) { $setting = Setting::first(); $guru = Guru::find(Sentry::getUser()->username); $kelas = Input::get('kelas'); $semester = Input::get('semester'); $rombel = Rombel::find($kelas); $mengajar = DB::table('mengajar')->where('id_guru', '=', Sentry::getUser()->username)->where('thn_ajaran', '=', $setting->dari_tahun . '-' . $setting->sampai_tahun)->first(); $cari = DB::table('nilai_ujian')->where('kd_rombel', '=', $kelas)->where('semester', '=', $semester)->where('kd_mapel', '=', $mengajar->kd_mapel)->join('siswa', 'nilai_ujian.nis', '=', 'siswa.nis'); if ($cari->count() > 0) { return View::make('hal_guru.cetak_ujian')->with('title', 'Laporan Nilai Ujian')->with('semester', $semester)->with('guru', $guru)->with('rombel', $rombel)->with('mengajar', $mengajar)->with('cari', $cari); } else { Session::flash('pesan', "<div class='alert alert-danger'>\n Data tidak ditemukan</div>"); return Redirect::back(); } } else { Session::flash('pesan', "<div class='alert alert-danger'>\n Data Rombel belum ada, hubungi administrator untuk setting Rombel</div>"); return Redirect::back(); } }
public function tambah_siswa($id) { $rombel = Rombel::find($id); $siswa = Siswa::all(); $detail = DB::table('siswa_rombel')->where('kd_rombel', '=', $id)->join('siswa', 'siswa.nis', '=', 'siswa_rombel.nis')->get(); return View::make('rombel.tambah_siswa')->with('rombel', $rombel)->with('siswa', $siswa)->with('detail', $detail); }