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);
}
