@php
$total = 0;
@endphp
@foreach ($checked as $id)
@php
$total++;
@endphp
@php
$student = App\User::find($id);
$kategori4 = App\Lesson::join('lesson_details', 'lesson_details.lesson_id', '=', 'lessons.id')
->select('lessons.*')
->where('lessons.category', 4)
->where('lesson_details.year_id', session('s_year'))
->where('lesson_details.classroom_id', session('s_classroom'))
->where('lessons.active', 1)
->where('lesson_details.active', 1)
->orderBy('lessons.urutan', 'asc')
->get();
$kategori5 = App\Lesson::join('lesson_details', 'lesson_details.lesson_id', '=', 'lessons.id')
->select('lessons.*')
->where('lessons.category', 5)
->where('lessons.subcategory', null)
->where('lesson_details.year_id', session('s_year'))
->where('lesson_details.classroom_id', session('s_classroom'))
->where('lessons.active', 1)
->where('lesson_details.active', 1)
->orderBy('lessons.urutan', 'asc')
->get();
$subcategori4 = App\Lesson::join('lesson_details', 'lesson_details.lesson_id', '=', 'lessons.id')
->select('lessons.*')
->where('lessons.category', 5)
->where('lessons.subcategory', 4)
->where('lesson_details.year_id', session('s_year'))
->where('lesson_details.classroom_id', session('s_classroom'))
->where('lessons.active', 1)
->where('lesson_details.active', 1)
->orderBy('lessons.urutan', 'asc')
->get();
$subcategori5 = App\Lesson::join('lesson_details', 'lesson_details.lesson_id', '=', 'lessons.id')
->select('lessons.*')
->where('lessons.category', 5)
->where('lessons.subcategory', 5)
->where('lesson_details.year_id', session('s_year'))
->where('lesson_details.classroom_id', session('s_classroom'))
->where('lessons.active', 1)
->where('lesson_details.active', 1)
->orderBy('lessons.urutan', 'asc')
->get();
$subcategori6 = App\Lesson::join('lesson_details', 'lesson_details.lesson_id', '=', 'lessons.id')
->select('lessons.*')
->where('lessons.category', 5)
->where('lessons.subcategory', 6)
->where('lesson_details.year_id', session('s_year'))
->where('lesson_details.classroom_id', session('s_classroom'))
->where('lessons.active', 1)
->where('lesson_details.active', 1)
->orderBy('lessons.urutan', 'asc')
->get();
$subcategori7 = App\Lesson::join('lesson_details', 'lesson_details.lesson_id', '=', 'lessons.id')
->select('lessons.*')
->where('lessons.category', 5)
->where('lessons.subcategory', 7)
->where('lesson_details.year_id', session('s_year'))
->where('lesson_details.classroom_id', session('s_classroom'))
->where('lessons.active', 1)
->where('lesson_details.active', 1)
->orderBy('lessons.urutan', 'asc')
->get();
$pkl = $student->pkl;
$count = count($kategori4) + count($kategori5) + count($subcategori4) + count($subcategori5) + count($subcategori6) + count($subcategori7);
$count_real = $count;
if (count($subcategori4)) {
$count = $count + 2;
}
if (count($subcategori5)) {
$count = $count + 2;
}
if (count($subcategori6)) {
$count = $count + 2;
}
$count = $count + 3;
$extra = App\ExtracurricularUser::where('user_id', $student->id)
->with('Extracurricular')
->get();
@endphp
Nama Sekolah
:
{{ $setting->name }}
Alamat
:
{{ $setting->address }}
Nama
:
{{ $student->name }}
Nomer Induk/NISN
:
{{ $student->code }}
Kelas
:
{{ $class->name }}
Semester
:
@php
//semester(session('s_semester'))
$smtr = '';
$pisah = explode(' ', $class->name);
if ($pisah[0] == 'X') {
if (semester(session('s_semester')) === 'Mid Semester 1') {
$smtr = 'Mid Semester 1';
} elseif (semester(session('s_semester')) === 'Semester 1') {
$smtr = 'Semester 1';
} elseif (semester(session('s_semester')) === 'Mid Semester 2') {
$smtr = 'Mid Semester 2';
} elseif (semester(session('s_semester')) === 'Semester 2') {
$smtr = 'Semester 2';
}
//'Mid Semester 1 Semester 1 Mid Semester 2 Semester 2 ';
} elseif ($pisah[0] == 'XI') {
if (semester(session('s_semester')) === 'Mid Semester 1') {
$smtr = 'Mid Semester 3';
} elseif (semester(session('s_semester')) === 'Semester 1') {
$smtr = 'Semester 3';
} elseif (semester(session('s_semester')) === 'Mid Semester 2') {
$smtr = 'Mid Semester 4';
} elseif (semester(session('s_semester')) === 'Semester 2') {
$smtr = 'Semester 4';
}
//'Mid Semester 3 Semester 3 Mid Semester 4 Semester 4 ';
} elseif ($pisah[0] == 'XII') {
if (semester(session('s_semester')) === 'Mid Semester 1') {
$smtr = 'Mid Semester 5';
} elseif (semester(session('s_semester')) === 'Semester 1') {
$smtr = 'Semester 5';
} elseif (semester(session('s_semester')) === 'Mid Semester 2') {
$smtr = 'Mid Semester 6';
} elseif (semester(session('s_semester')) === 'Semester 2') {
$smtr = 'Semester 6';
}
//'Mid Semester 5 Semester 5 Mid Semester 6 Semester 6 ';
}
@endphp
{{ $smtr }}
Bidang Studi Keahlian
:
{{ $class->major->name }}
Program Studi Keahlian
:
{{ $class->program->name }}
Kompetensi Keahlian
:
{{ $class->competency->name }}
Tahun Pelajaran
:
{{ $class->year }}
No
Mata Pelajaran Siswa
KKM
Pengetahuan (KI 3)
Ketrampilan (KI 4)
Sikap Spiritual (KI 1) & Sosial (KI 2)
Angka
Predikat
Angka
Predikat
Predikat
Antar Mata Pelajaran
1-100
1-100
A Kelompok Mata Pelajaran Umum
Sudah baik dalam sikap kejujuran, disiplin, toleransi, gotong royong, santun, dan percaya diri,
namun masih perlu ditingkatkan dalam sikap tanggung jawab, melalui pembiasaan penugasan mandiri
di rumah.
{{-- @php
@endphp --}}
@php
$i = 1;
$kkm_total = 0;
$knowledge_total = 0;
$skill_total = 0;
$count = 0;
@endphp
@foreach ($kategori4 as $rows)
@php
$nScore = App\Score::where('user_id', $student->id)
->where('lesson_id', $rows->id)
->where('year_id', session('s_year'))
->where('classroom_id', session('s_classroom'))
->where('semester', session('s_semester'))
->where('active', 1)
->first();
if ($nScore) {
//$nKkm = $nScore->kkm;
$nKnowledgeScore = $nScore->knowledge_score;
$nKnowledgeRanking = $nScore->knowledge_ranking;
$nSkillScore = $nScore->skill_score;
$nSkillRanking = $nScore->skill_ranking;
$nAttitudeRanking = $nScore->attitude_ranking;
} else {
//$nKkm = 0;
$nKnowledgeScore = 0;
$nKnowledgeRanking = '-';
$nSkillScore = 0;
$nSkillRanking = '-';
$nAttitudeRanking = '-';
}
@endphp
{{ $i }}
{{ $rows->name }}
{{ $rows->kkm }}
{{ $nKnowledgeScore }}
{{ $nKnowledgeRanking }}
{{ $nSkillScore }}
{{ $nSkillRanking }}
{{ textRankingNum(($nKnowledgeScore + $nSkillScore) / 2) }}
@php
$i++;
$kkm_total = $kkm_total + $rows->kkm;
$knowledge_total = $knowledge_total + $nKnowledgeScore;
$skill_total = $skill_total + $nSkillScore;
$count++;
@endphp
@endforeach
@php $i = 1; @endphp
B Kelompok Mata Pelajaran Kejuruan
@foreach ($kategori5 as $rows)
@php
$nScore = App\Score::where('user_id', $student->id)
->where('lesson_id', $rows->id)
->where('year_id', session('s_year'))
->where('classroom_id', session('s_classroom'))
->where('semester', session('s_semester'))
->where('active', 1)
->first();
if ($nScore) {
//$nKkm = $nScore->kkm;
$nKnowledgeScore = $nScore->knowledge_score;
$nKnowledgeRanking = $nScore->knowledge_ranking;
$nSkillScore = $nScore->skill_score;
$nSkillRanking = $nScore->skill_ranking;
$nAttitudeRanking = $nScore->attitude_ranking;
} else {
//$nKkm = 0;
$nKnowledgeScore = 0;
$nKnowledgeRanking = '-';
$nSkillScore = 0;
$nSkillRanking = '-';
$nAttitudeRanking = '-';
}
@endphp
{{ $i }}
{{ $rows->name }}
{{ $rows->kkm }}
{{ $nKnowledgeScore }}
{{ $nKnowledgeRanking }}
{{ $nSkillScore }}
{{ $nSkillRanking }}
{{ textRanking($nAttitudeRanking) }}
@php
$i++;
$kkm_total = $kkm_total + $rows->kkm;
$knowledge_total = $knowledge_total + $nKnowledgeScore;
$skill_total = $skill_total + $nSkillScore;
$count++;
@endphp
@endforeach
{{-- @php $i = 1; @endphp --}}
@if (count($subcategori4))
{{-- //
// --}}
{{ $i }}
Projek Ilmu Pengetahuan Alam dan Sosial
@php $i++; @endphp
@foreach ($subcategori4 as $rows)
@php
$nScore = App\Score::where('user_id', $student->id)
->where('lesson_id', $rows->id)
->where('year_id', session('s_year'))
->where('classroom_id', session('s_classroom'))
->where('semester', session('s_semester'))
->where('active', 1)
->first();
if ($nScore) {
//$nKkm = $nScore->kkm;
$nKnowledgeScore = $nScore->knowledge_score;
$nKnowledgeRanking = $nScore->knowledge_ranking;
$nSkillScore = $nScore->skill_score;
$nSkillRanking = $nScore->skill_ranking;
$nAttitudeRanking = $nScore->attitude_ranking;
} else {
//$nKkm = 0;
$nKnowledgeScore = 0;
$nKnowledgeRanking = '-';
$nSkillScore = 0;
$nSkillRanking = '-';
$nAttitudeRanking = '-';
}
@endphp
{{ $rows->name }}
{{ $rows->kkm }}
{{ $nKnowledgeScore }}
{{ $nKnowledgeRanking }}
{{ $nSkillScore }}
{{ $nSkillRanking }}
{{ textRanking($nAttitudeRanking) }}
@php
$kkm_total = $kkm_total + $rows->kkm;
$knowledge_total = $knowledge_total + $nKnowledgeScore;
$skill_total = $skill_total + $nSkillScore;
$count++;
@endphp
@endforeach
@endif
@if (count($subcategori5))
{{-- //
// --}}
{{ $i }}
Dasar-Dasar Program Keahlian
@php $i++; @endphp
@foreach ($subcategori5 as $rows)
@php
$nScore = App\Score::where('user_id', $student->id)
->where('lesson_id', $rows->id)
->where('year_id', session('s_year'))
->where('classroom_id', session('s_classroom'))
->where('semester', session('s_semester'))
->where('active', 1)
->first();
if ($nScore) {
//$nKkm = $nScore->kkm;
$nKnowledgeScore = $nScore->knowledge_score;
$nKnowledgeRanking = $nScore->knowledge_ranking;
$nSkillScore = $nScore->skill_score;
$nSkillRanking = $nScore->skill_ranking;
$nAttitudeRanking = $nScore->attitude_ranking;
} else {
//$nKkm = 0;
$nKnowledgeScore = 0;
$nKnowledgeRanking = '-';
$nSkillScore = 0;
$nSkillRanking = '-';
$nAttitudeRanking = '-';
}
@endphp
{{ $rows->name }}
{{ $rows->kkm }}
{{ $nKnowledgeScore }}
{{ $nKnowledgeRanking }}
{{ $nSkillScore }}
{{ $nSkillRanking }}
{{ textRanking($nAttitudeRanking) }}
@php
$kkm_total = $kkm_total + $rows->kkm;
$knowledge_total = $knowledge_total + $nKnowledgeScore;
$skill_total = $skill_total + $nSkillScore;
$count++;
@endphp
@endforeach
@endif
@if (count($subcategori6))
{{-- //
// --}}
{{ $i }}
Konsentrasi Keahlian
@php $i++; @endphp
@foreach ($subcategori6 as $rows)
@php
$nScore = App\Score::where('user_id', $student->id)
->where('lesson_id', $rows->id)
->where('year_id', session('s_year'))
->where('classroom_id', session('s_classroom'))
->where('semester', session('s_semester'))
->where('active', 1)
->first();
if ($nScore) {
//$nKkm = $nScore->kkm;
$nKnowledgeScore = $nScore->knowledge_score;
$nKnowledgeRanking = $nScore->knowledge_ranking;
$nSkillScore = $nScore->skill_score;
$nSkillRanking = $nScore->skill_ranking;
$nAttitudeRanking = $nScore->attitude_ranking;
} else {
//$nKkm = 0;
$nKnowledgeScore = 0;
$nKnowledgeRanking = '-';
$nSkillScore = 0;
$nSkillRanking = '-';
$nAttitudeRanking = '-';
}
@endphp
{{ $rows->name }}
{{ $rows->kkm }}
{{ $nKnowledgeScore }}
{{ $nKnowledgeRanking }}
{{ $nSkillScore }}
{{ $nSkillRanking }}
{{ textRanking($nAttitudeRanking) }}
@php
$kkm_total = $kkm_total + $rows->kkm;
$knowledge_total = $knowledge_total + $nKnowledgeScore;
$skill_total = $skill_total + $nSkillScore;
$count++;
@endphp
@endforeach
@endif
@if (count($subcategori7))
{{-- //
// --}}
{{--
{{ $i }}
Konsentrasi Keahlian
--}}
@foreach ($subcategori7 as $rows)
@php
$nScore = App\Score::where('user_id', $student->id)
->where('lesson_id', $rows->id)
->where('year_id', session('s_year'))
->where('classroom_id', session('s_classroom'))
->where('semester', session('s_semester'))
->where('active', 1)
->first();
if ($nScore) {
//$nKkm = $nScore->kkm;
$nKnowledgeScore = $nScore->knowledge_score;
$nKnowledgeRanking = $nScore->knowledge_ranking;
$nSkillScore = $nScore->skill_score;
$nSkillRanking = $nScore->skill_ranking;
$nAttitudeRanking = $nScore->attitude_ranking;
} else {
//$nKkm = 0;
$nKnowledgeScore = 0;
$nKnowledgeRanking = '-';
$nSkillScore = 0;
$nSkillRanking = '-';
$nAttitudeRanking = '-';
}
@endphp
{{ $i }}
{{ $rows->name }}
{{ $rows->kkm }}
{{ $nKnowledgeScore }}
{{ $nKnowledgeRanking }}
{{ $nSkillScore }}
{{ $nSkillRanking }}
{{ textRanking($nAttitudeRanking) }}
@php
$i++;
$kkm_total = $kkm_total + $rows->kkm;
$knowledge_total = $knowledge_total + $nKnowledgeScore;
$skill_total = $skill_total + $nSkillScore;
$count++;
@endphp
@endforeach
@endif
@if ($pkl)
{{-- //
// --}}
{{--
{{ $i }}
Konsentrasi Keahlian
--}}
@foreach ($subcategori7 as $rows)
@php
$nScore = App\Score::where('user_id', $student->id)
->where('lesson_id', $rows->id)
->where('year_id', session('s_year'))
->where('classroom_id', session('s_classroom'))
->where('semester', session('s_semester'))
->where('active', 1)
->first();
if ($nScore) {
//$nKkm = $nScore->kkm;
$nKnowledgeScore = $nScore->knowledge_score;
$nKnowledgeRanking = $nScore->knowledge_ranking;
$nSkillScore = $nScore->skill_score;
$nSkillRanking = $nScore->skill_ranking;
$nAttitudeRanking = $nScore->attitude_ranking;
} else {
//$nKkm = 0;
$nKnowledgeScore = 0;
$nKnowledgeRanking = '-';
$nSkillScore = 0;
$nSkillRanking = '-';
$nAttitudeRanking = '-';
}
@endphp
{{ $i }}
{{ $rows->name }}
{{ $rows->kkm }}
{{ $nKnowledgeScore }}
{{ $nKnowledgeRanking }}
{{ $nSkillScore }}
{{ $nSkillRanking }}
{{ textRanking($nAttitudeRanking) }}
@php
$i++;
$kkm_total = $kkm_total + $rows->kkm;
$knowledge_total = $knowledge_total + $nKnowledgeScore;
$skill_total = $skill_total + $nSkillScore;
$count++;
@endphp
@endforeach
@endif
$pkl
Jumlah Nilai {{ $kkm_total }}
{{ $knowledge_total }}
{{ $skill_total }}
Rata-Rata
{{ $count_real != 0 ? ceil($kkm_total / $count_real) : 'N/A' }}
{{ $count_real != 0 ? ceil($knowledge_total / $count_real) : 'N/A' }}
{{ $count_real != 0 ? checkRanking(ceil($knowledge_total / $count_real)) : 'N/A' }}
{{ $count_real != 0 ? ceil($skill_total / $count_real) : 'N/A' }}
{{ $count_real != 0 ? checkRanking(ceil($skill_total / $count_real)) : 'N/A' }}
Nama Sekolah
:
{{ $setting->name }}
Alamat
:
{{ $setting->address }}
Nama
:
{{ $student->name }}
Nomer Induk/NISN
:
{{ $student->code }}
Kelas
:
{{ $class->name }}
Semester
:
{{ $smtr }}
Bidang Studi Keahlian
:
{{ $class->major->name }}
Program Studi Keahlian
:
{{ $class->program->name }}
Kompetensi Keahlian
:
{{ $class->competency->name }}
Tahun Pelajaran
:
{{ $class->year }}
1. Kegiatan Ekstrakurikuler
@if ($extra)
@php
$i = 1;
@endphp
@foreach ($extra as $ext)
{{ $i }}.
{{ $ext->Extracurricular->name }}
{{ $ext->score }}
@php
$i++;
@endphp
@endforeach
{{--
2. Ekstrakurikukuler 2
{{ $extra->extra_two }}
3. Ekstrakurikukuler 3
{{ $extra->extra_three }}
4. Ekstrakurikukuler 4
{{ $extra->extra_four }}
5. Ekstrakurikukuler 5
{{ $extra->extra_five }}
--}}
@else
Tidak ada data atau belum diinput
@endif
2. Ketidakhadiran
1. Sakit
{{ $student->getPresenceCount(2) }} Kali
2. Ijin
{{ $student->getPresenceCount(3) }} Kali
3. Tanpa Keterangan
{{ $student->getPresenceCount(4) }} Kali
Mengetahui
Tangerang Selatan, @if (session('date_mangsa'))
{{ dateIndo(session('date_mangsa')) }}@else{{ dateIndo(DATE('Y-m-d')) }}
@endif
{{ $class->wali->name }}, {{ $class->wali->last_study }}
Nama Sekolah
:
{{ $setting->name }}
Alamat
:
{{ $setting->address }}
Nama
:
{{ $student->name }}
Nomer Induk/NISN
:
{{ $student->code }}
Kelas
:
{{ $class->name }}
Semester
:
{{ $smtr }}
Bidang Studi Keahlian
:
{{ $class->major->name }}
Program Studi Keahlian
:
{{ $class->program->name }}
Kompetensi Keahlian
:
{{ $class->competency->name }}
Tahun Pelajaran
:
{{ $class->year }}
DESKRIPSI
No
Mata Pelajaran Siswa
Kopetensi
Predikat
A MUATAN NASIONAL
@php
$i = 1;
@endphp
@foreach ($kategori4 as $rows)
Pengetahuan
sudah menunjukkan sikap baik dalam penguasaan
kompetensi pengetahuan
{{ $i }}
{{ $rows->name }}
Keterampilan
sudah menunjukkan sikap baik dalam penguasaan
kompetensi Keterampilan
Sosial & Spiritual
sudah menunjukkan sikap baik dalam penguasaan
kompetensi sikap sosial & spiritual
@php
$i++;
@endphp
@endforeach
B MUATAN KEWILAYAHAN
@php
$i = 1;
@endphp
@foreach ($kategori5 as $rows)
Pengetahuan
sudah menunjukkan sikap baik dalam penguasaan
kompetensi pengetahuan
{{ $i }}
{{ $rows->name }}
Keterampilan
sudah menunjukkan sikap baik dalam penguasaan
kompetensi Keterampilan
Sosial & Spiritual
sudah menunjukkan sikap baik dalam penguasaan
kompetensi sikap sosial & spiritual
@php
$i++;
@endphp
@endforeach
@if (count($subcategori4))
C1 DASAR BIDANG KEAHLIAN 2
@php
$i = 1;
@endphp
@foreach ($subcategori4 as $rows)
Pengetahuan
sudah menunjukkan sikap baik dalam penguasaan
kompetensi pengetahuan
{{ $i }}
{{ $rows->name }}
Keterampilan
sudah menunjukkan sikap baik dalam penguasaan
kompetensi Keterampilan
Sosial & Spiritual
sudah menunjukkan sikap baik dalam penguasaan
kompetensi sikap sosial & spiritual
@php
$i++;
@endphp
@endforeach
@endif
@if (count($subcategori5))
C2 DASAR PROGRAM KEAHLIAN
@php
$i = 1;
@endphp
@foreach ($subcategori5 as $rows)
Pengetahuan
sudah menunjukkan sikap baik dalam penguasaan
kompetensi pengetahuan
{{ $i }}
{{ $rows->name }}
Keterampilan
sudah menunjukkan sikap baik dalam penguasaan
kompetensi Keterampilan
Sosial & Spiritual
sudah menunjukkan sikap baik dalam penguasaan
kompetensi sikap sosial & spiritual
@php
$i++;
@endphp
@endforeach
@endif
@if (count($subcategori6))
C3 DASAR KOMPETENSI KEAHLIAN
@php
$i = 1;
@endphp
@foreach ($subcategori6 as $rows)
Pengetahuan
sudah menunjukkan sikap baik dalam penguasaan
kompetensi pengetahuan
{{ $i }}
{{ $rows->name }}
Keterampilan
sudah menunjukkan sikap baik dalam penguasaan
kompetensi Keterampilan
Sosial & Spiritual
sudah menunjukkan sikap baik dalam penguasaan
kompetensi sikap sosial & spiritual
@php
$i++;
@endphp
@endforeach
@endif
Wali Kelas,
{{ $class->wali->name }}, {{ $class->wali->last_study }}
@if ($student->class == 3 && session('s_semester') == 4)
Keputusan :
Berdasarkan hasil yang dicapai pada semester ganjil dan semester genap
serta hasil Rapat Dewan Guru, peserta didik ditetapkan :
LULUS / TIDAK LULUS
@elseif($student->class == 2 && session('s_semester') == 4)
Keputusan :
Berdasarkan hasil yang dicapai pada semester ganjil dan semester genap
serta hasil Rapat Dewan Guru, peserta didik ditetapkan :
NAIK / TIDAK NAIK Kelas
@elseif($student->class == 1 && session('s_semester') == 4)
Keputusan :
Berdasarkan hasil yang dicapai pada semester ganjil dan semester genap
serta hasil Rapat Dewan Guru, peserta didik ditetapkan :
NAIK / TIDAK NAIK Kelas
@endif
Orang Tua / Wali,
Tangerang Selatan, @if (session('date_mangsa'))
{{ dateIndo(session('date_mangsa')) }}@else{{ dateIndo(DATE('Y-m-d')) }}
@endif
{{ $setting->headmaster }}
@else
Wali Kelas,
{{ $class->wali->name }}, {{ $class->wali->last_study }}
Orang Tua / Wali,
@endif
@endforeach