@php
$total = 0;
@endphp
@foreach ($checked as $id)
@php
$total++;
@endphp
@php
$student = App\User::find($id);
$national = App\Lesson::join('lesson_details', 'lesson_details.lesson_id', '=', 'lessons.id')
->select('lessons.*')
->where('lessons.category', 1)
->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('lesson_details.urutan')
->get();
$area = App\Lesson::join('lesson_details', 'lesson_details.lesson_id', '=', 'lessons.id')
->select('lessons.*')
->where('lessons.category', 2)
->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('lesson_details.urutan')
->get();
$interestc1 = App\Lesson::join('lesson_details', 'lesson_details.lesson_id', '=', 'lessons.id')
->select('lessons.*')
->where('lessons.category', 3)
->where('lessons.subcategory', 1)
->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('lesson_details.urutan')
->get();
$interestc2 = App\Lesson::join('lesson_details', 'lesson_details.lesson_id', '=', 'lessons.id')
->select('lessons.*')
->where('lessons.category', 3)
->where('lessons.subcategory', 2)
->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('lesson_details.urutan')
->get();
$interestc3 = App\Lesson::join('lesson_details', 'lesson_details.lesson_id', '=', 'lessons.id')
->select('lessons.*')
->where('lessons.category', 3)
->where('lessons.subcategory', 3)
->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('lesson_details.urutan')
->get();
$count = count($national) + count($area) + count($interestc1) + count($interestc2) + count($interestc3);
$count_real = $count;
if (count($interestc1)) {
$count = $count + 2;
}
if (count($interestc2)) {
$count = $count + 2;
}
if (count($interestc3)) {
$count = $count + 2;
}
$count = $count + 6;
$extra = DB::table('score_extras')
->select('*')
->where('user_id', $student->id)
->where('year_id', session('s_year'))
->where('classroom_id', session('s_classroom'))
->where('semester', session('s_semester'))
->first();
@endphp
| Nama Sekolah |
: |
{{ $setting->name }} |
| Alamat |
: |
{{ $setting->address }} |
| Nama |
: |
{{ $student->name }} |
| Nomer Induk/NISN |
: |
{{ $student->code }} |
| Kelas |
: |
{{ $class->name }} |
| Semester |
: |
{{ semester(session('s_semester')) }} |
| 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 |
MUATAN NASIONAL |
|
|
|
|
|
|
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
$i = 1;
$kkm_total = 0;
$knowledge_total = 0;
$skill_total = 0;
//$count = 0;
@endphp
@foreach ($national 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
|
| B |
MUATAN KEWILAYAHAN |
|
|
|
|
|
|
@php $i = 1; @endphp
@foreach ($area 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
@if (count($interestc1))
|
| C1 |
DASAR BIDANG KEAHLIAN |
|
|
|
|
|
|
@php $i = 1; @endphp
@foreach ($interestc1 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 (count($interestc2))
|
| C2 |
DASAR PROGRAM KEAHLIAN |
|
|
|
|
|
|
@php $i = 1; @endphp
@foreach ($interestc2 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 (count($interestc3))
|
| C3 |
DASAR KOMPETENSI KEAHLIAN |
|
|
|
|
|
|
@php $i = 1; @endphp
@foreach ($interestc3 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
|
| Jumlah Nilai |
{{ $kkm_total }} |
{{ $knowledge_total }} |
|
{{ $skill_total }} |
|
|
| Rata-Rata |
{{ ceil($kkm_total / $count_real) }} |
{{ ceil($knowledge_total / $count_real) }} |
{{ checkRanking(ceil($knowledge_total / $count_real)) }} |
{{ ceil($skill_total / $count_real) }} |
{{ checkRanking(ceil($skill_total / $count_real)) }} |
|
| Nama Sekolah |
: |
{{ $setting->name }} |
| Alamat |
: |
{{ $setting->address }} |
| Nama |
: |
{{ $student->name }} |
| Nomer Induk/NISN |
: |
{{ $student->code }} |
| Kelas |
: |
{{ $class->name }} |
| Semester |
: |
{{ semester(session('s_semester')) }} |
| 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)
| 1. Ekstrakurikukuler 1 |
{{ $extra->extra_one }} |
| 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
Orang Tua / Wali
(_____________________________)
Tangerang Selatan, @if (session('date_mangsa'))
{{ dateIndo(session('date_mangsa')) }}@else{{ dateIndo(DATE('Y-m-d')) }}
@endif
Wali Kelas,
{{ $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 |
: |
{{ semester(session('s_semester')) }} |
| 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 ($national 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 ($area 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($interestc1))
|
| C1 |
DASAR BIDANG KEAHLIAN
|
@php
$i = 1;
@endphp
@foreach ($interestc1 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($interestc2))
|
| C2 |
DASAR PROGRAM KEAHLIAN
|
@php
$i = 1;
@endphp
@foreach ($interestc2 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($interestc3))
|
| C3 |
DASAR KOMPETENSI KEAHLIAN
|
@php
$i = 1;
@endphp
@foreach ($interestc3 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 (session('s_semester') == 4)
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
Kepala Sekolah,
{{ $setting->headmaster }}
@else
Wali Kelas,
{{ $class->wali->name }}, {{ $class->wali->last_study }}
Orang Tua / Wali,
(_____________________________)
@endif
@if ($total != $totalCheck)
@endif
@endforeach