@foreach($checked as $id)
@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)
->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)
->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)
->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)
->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)
->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
@endforeach