@php
foreach ($checked as $id) {
$student = App\User::find($id);
$national = DB::table('scores')
->join('lessons', 'scores.lesson_id', '=', 'lessons.id')
->select('scores.knowledge_score','scores.knowledge_ranking','scores.skill_score','scores.skill_ranking','scores.attitude_ranking', 'lessons.name', 'lessons.kkm')
->where('lessons.category',1)
->where('scores.user_id',$student->id)
->where('scores.year_id',session('s_year'))
->where('scores.classroom_id',session('s_classroom'))
->where('scores.semester',session('s_semester'))
->get();
$area = DB::table('scores')
->join('lessons', 'scores.lesson_id', '=', 'lessons.id')
->select('scores.knowledge_score','scores.knowledge_ranking','scores.skill_score','scores.skill_ranking','scores.attitude_ranking', 'lessons.name', 'lessons.kkm')
->where('lessons.category',2)
->where('scores.user_id',$student->id)
->where('scores.year_id',session('s_year'))
->where('scores.classroom_id',session('s_classroom'))
->where('scores.semester',session('s_semester'))
->get();
$interestc3 = DB::table('scores')
->join('lessons', 'scores.lesson_id', '=', 'lessons.id')
->select('scores.knowledge_score','scores.knowledge_ranking','scores.skill_score','scores.skill_ranking','scores.attitude_ranking', 'lessons.name', 'lessons.kkm')
->where('lessons.category',3)
->where('lessons.subcategory',3)
->where('scores.user_id',$student->id)
->where('scores.year_id',session('s_year'))
->where('scores.classroom_id',session('s_classroom'))
->where('scores.semester',session('s_semester'))
->get();
$count = count($national) + count($area) + count($interestc3);
$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 Pleajaran Siswa |
KKM |
Pengetahuan (KI 3) |
Pengetahuan (KI 4) |
Sikap Spiritual (KI 1) & Sosial (KI 2) |
| Angka |
Predikat |
Angka |
Predikat |
Predikat |
Antar Mata Pelajaran |
| 1-100 |
|
1-100 |
|
| A |
MUATAN NASIONAL |
|
|
|
|
|
|
|
@php
$i = 1;
$kkm_total = 0;
$knowledge_total = 0;
$skill_total = 0;
//$count = 0;
@endphp
@foreach($national as $rows)
| {{ $i }} |
{{ $rows->name }} |
{{ $rows->kkm }} |
{{ $rows->knowledge_score }} |
{{ $rows->knowledge_ranking }} |
{{ $rows->skill_score }} |
{{ $rows->skill_ranking }} |
{{ textRanking($rows->attitude_ranking) }} |
@php
$i++;
$kkm_total = $kkm_total + $rows->kkm;
$knowledge_total = $knowledge_total + $rows->knowledge_score;
$skill_total = $skill_total + $rows->skill_score;
//$count++;
@endphp
@endforeach
|
| B |
MUATAN KEWILAYAHAN |
|
|
|
|
|
|
@php $i = 1; @endphp
@foreach($area as $rows)
| {{ $i }} |
{{ $rows->name }} |
{{ $rows->kkm }} |
{{ $rows->knowledge_score }} |
{{ $rows->knowledge_ranking }} |
{{ $rows->skill_score }} |
{{ $rows->skill_ranking }} |
{{ textRanking($rows->attitude_ranking) }} |
@php
$i++;
$kkm_total = $kkm_total + $rows->kkm;
$knowledge_total = $knowledge_total + $rows->knowledge_score;
$skill_total = $skill_total + $rows->skill_score;
//$count++;
@endphp
@endforeach
|
| C3 |
DASAR KOMPETENSI KEAHLIAN |
|
|
|
|
|
|
@php $i = 1; @endphp
@foreach($interestc3 as $rows)
| {{ $i }} |
{{ $rows->name }} |
{{ $rows->kkm }} |
{{ $rows->knowledge_score }} |
{{ $rows->knowledge_ranking }} |
{{ $rows->skill_score }} |
{{ $rows->skill_ranking }} |
{{ textRanking($rows->attitude_ranking) }} |
@php
$i++;
$kkm_total = $kkm_total + $rows->kkm;
$knowledge_total = $knowledge_total + $rows->knowledge_score;
$skill_total = $skill_total + $rows->skill_score;
//$count++;
@endphp
@endforeach
|
| Jumlah Nilai |
{{ $kkm_total }} |
{{ $knowledge_total }} |
|
{{ $skill_total }} |
|
|
| Rata-Rata |
{{ ceil($kkm_total / $count)}} |
{{ ceil($knowledge_total / $count)}} |
{{ checkRanking(ceil($knowledge_total / $count)) }} |
{{ ceil($skill_total / $count)}} |
{{ checkRanking(ceil($skill_total / $count)) }} |
|
| 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. Kegiatan Ekstrakurikuler
| 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, {{ dateIndo(DATE('d-m-Y')) }}
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)
| {{ $i }} |
{{ $rows->name }} |
Pengetahuan |
sudah menunjukkan sikap baik dalam penguasaan kompetensi pengetahuan |
| 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)
| {{ $i }} |
{{ $rows->name }} |
Pengetahuan |
sudah menunjukkan sikap baik dalam penguasaan kompetensi pengetahuan |
| 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
|
| C3 |
DASAR KOMPETENSI KEAHLIAN |
@php
$i = 1;
@endphp
@foreach($interestc3 as $rows)
| {{ $i }} |
{{ $rows->name }} |
Pengetahuan |
sudah menunjukkan sikap baik dalam penguasaan kompetensi pengetahuan |
| 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
Mengetahui
Orang Tua / Wali
(_____________________________)
Tangerang Selatan, {{ dateIndo(DATE('d-m-Y')) }}
Wali Kelas,
{{ $class->wali->name }}, {{ $class->wali->last_study }}
@php } @endphp