public static function get_table_data($request)
{
if ($request->input('semester')) {
$semester = $request->input('semester');
$ids = "siswa.id, ',', {$request->input('mapel')}, ',', {$semester}";
} else {
$semester = Semester::get_active_semester()->id;
$ids = "siswa.id, ',', {$request->input('mapel')}";
}
$data = Siswa::select(DB::raw("\n NULL as `no`,\n siswa.nis,\n siswa.nama,\n sq_nilai_akhir.nilai_pengetahuan,\n sq_nilai_akhir.nilai_keterampilan,\n CONCAT({$ids}) as `id`\n "))->leftJoin(DB::raw('(select id_siswa, nilai_pengetahuan, nilai_keterampilan FROM nilai_akhir WHERE id_semester = ' . $semester . ' AND id_mapel = ' . $request->input('mapel') . ') sq_nilai_akhir'), 'sq_nilai_akhir.id_siswa', '=', 'siswa.id')->where('siswa.id_kelas', $request->input('kelas'))->orderBy('siswa.nama', 'ASC')->get()->toArray();
return ['data' => $data];
}
public static function get_table_data($request)
{
if ($request->input('semester')) {
$semester = $request->input('semester');
$ids = "siswa.id, ',', {$semester}";
} else {
$semester = Semester::get_active_semester()->id;
$ids = "siswa.id";
}
$data = Siswa::select(DB::raw("\n NULL as `no`,\n siswa.nis,\n siswa.nama,\n CONCAT('<i class=\"fa fa-', IF(LENGTH(sq_nilai_sikap.sikap) > 0, 'check-square', 'square'), '\"></i>') as `check`,\n CONCAT({$ids}) as `id`\n "))->leftJoin(DB::raw('(select id_siswa, LEFT(sikap, 1) as `sikap` FROM nilai_sikap WHERE id_semester = ' . $semester . ') sq_nilai_sikap'), 'sq_nilai_sikap.id_siswa', '=', 'siswa.id')->where('siswa.id_kelas', $request->input('kelas'))->orderBy('siswa.nama', 'ASC')->get()->toArray();
return ['data' => $data];
}
public static function get_table_data($request)
{
$semester = Semester::get_active_semester()->id;
$ids = "siswa.id";
if ($request != null) {
if ($request->input('semester')) {
$semester = $request->input('semester');
$ids = "siswa.id, ',', {$semester}";
}
}
$data = Siswa::select(DB::raw("\n NULL as `no`,\n siswa.nis,\n siswa.nama,\n COUNT(sq_pkl.id_siswa),\n CONCAT({$ids}) as `id`\n "))->leftJoin(DB::raw('(select id_siswa FROM pkl WHERE id_semester = ' . $semester . ') sq_pkl'), 'sq_pkl.id_siswa', '=', 'siswa.id')->where('siswa.id_kelas', $request->input('kelas'))->groupBy('siswa.id')->get()->toArray();
return ['data' => $data];
}
public static function get_table_data($request)
{
$data = Siswa::select(DB::raw("\n NULL as `no`,\n siswa.nis,\n siswa.nama,\n sq_absensi.sakit,\n sq_absensi.izin,\n sq_absensi.alpa,\n siswa.id as `id`\n "))->leftJoin(DB::raw('(select id_siswa, sakit, izin, alpa FROM absensi_tu WHERE id_semester = ' . Semester::get_active_semester()->id . ') sq_absensi'), 'sq_absensi.id_siswa', '=', 'siswa.id')->where('siswa.id_kelas', $request->input('kelas'))->orderBy('siswa.nama', 'ASC')->get()->toArray();
return ['data' => $data];
}
