@foreach($checked as $id) @php $student = App\User::find($id); $national = App\Lesson::where('category',1) ->where('active',1) ->where('study_major_id',$class->study_major_id) ->where('study_program_id',$class->study_program_id) ->where('study_competency_id',$class->study_competency_id) ->get(); $area = App\Lesson::where('category',2) ->where('active',1) ->where('study_major_id',$class->study_major_id) ->where('study_program_id',$class->study_program_id) ->where('study_competency_id',$class->study_competency_id) ->get(); $interestc1 = App\Lesson::where('category',3) ->where('subcategory',1) ->where('active',1) ->where('study_major_id',$class->study_major_id) ->where('study_program_id',$class->study_program_id) ->where('study_competency_id',$class->study_competency_id) ->get(); $interestc2 = App\Lesson::where('category',3) ->where('subcategory',2) ->where('active',1) ->where('study_major_id',$class->study_major_id) ->where('study_program_id',$class->study_program_id) ->where('study_competency_id',$class->study_competency_id) ->get(); $interestc3 = App\Lesson::where('category',3) ->where('subcategory',3) ->where('active',1) ->where('study_major_id',$class->study_major_id) ->where('study_program_id',$class->study_program_id) ->where('study_competency_id',$class->study_competency_id) ->get(); $count = count($national) + count($area) + count($interestc1) + count($interestc2) + count($interestc3); $count_real = $count; if(count($interestc1)) { $count = $count + 1; } if(count($interestc2)) { $count = $count + 1; } $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

SEKOLAH MENENGAH KEJURUAN

TAHUN PELAJARAN {{ $year->name }}

Nama : {{ $student->name }}
Tempat / Tanggal Lahir : @if($student->birthplace) {{ $student->birthplace }},{{ $student->birthdate }} @else - @endif
Nomor Induk Siswa : {{ $student->code }}
Nomor Induk Siswa Nasional : @if($student->nisn) {{ $student->nisn }} @else - @endif
Program Studi Keahlian : {{ $class->program->name }}
Kompetensi Keahlian : {{ $class->competency->name }}
@php $i = 1; $count_mu = 0; $sum_mu = 0; @endphp @foreach($national as $rows) @php $score = App\Transcript::where('active',1) ->where('lesson_id',$rows->id) ->where('user_id',$student->id) ->first(); @endphp @php $i++; $count_mu++; if($score){ $sum_mu = $sum_mu + $score->final_score; } @endphp @endforeach @php $i = 1; $count_mk = 0; $sum_mk = 0; $score_kwu = 0; @endphp @foreach($area as $rows) @php if($rows->name != 'Kewirausahaan') { $score = App\Transcript::where('active',1) ->where('lesson_id',$rows->id) ->where('user_id',$student->id) ->first(); @endphp @php $i++; $count_mk++; if($score){ $sum_mk = $sum_mk + $score->final_score; } } else { $score = App\Transcript::where('active',1) ->where('lesson_id',$rows->id) ->where('user_id',$student->id) ->first(); $score_kwu = $score->final_score; } @endphp @endforeach @if(count($interestc1)) @php $i = 1; $count_c1 = 0; $sum_c1 = 0; @endphp @foreach($interestc1 as $rows) @php $score = App\Transcript::where('active',1) ->where('lesson_id',$rows->id) ->where('user_id',$student->id) ->first(); @endphp @php $i++; $count_c1++; if($score){ $sum_c1 = $sum_c1 + $score->final_score; } @endphp @endforeach @endif @if(count($interestc2)) @php $i = 1; $count_c2 = 0; $sum_c2 = 0; $score_c2 = 0; foreach($interestc2 as $rows) { $score = App\Transcript::where('active',1) ->where('lesson_id',$rows->id) ->where('user_id',$student->id) ->first(); $count_c2++; if($score){ $sum_c2 = $sum_c2 + $score->final_score; } } $score_c2 = ceil($sum_c2 / $count_c2); @endphp @endif @if(count($interestc3)) @php $i = 1; $count_c3 = 0; $sum_c3 = 0; $score_c3 = 0; $score_praktek = 0; foreach($interestc3 as $rows) { if($rows->name != 'Produk Kreatif dan Kewirausahaan') { $score = App\Transcript::where('active',1) ->where('lesson_id',$rows->id) ->where('user_id',$student->id) ->first(); $count_c3++; if($score) { $sum_c3 = $sum_c3 + $score->final_score; } } else { $score = App\Transcript::where('active',1) ->where('lesson_id',$rows->id) ->where('user_id',$student->id) ->first(); $score_praktek = ($score->final_score + $score_kwu) / 2; } } $score_c3 = ceil($sum_c3 / $count_c3); @endphp @endif @php $scount = ceil(($score_c3 + $score_c2 + $sum_c1 + $sum_mk + $sum_mu + $score_praktek) / (3 + $count_c1 + $count_mk + $count_mu)); @endphp
No Mata Pelajaran
(Kurikulum 2013 Revisi)		 Nilai Ujian Sekolah
A MUATAN NASIONAL
{{ $i }} {{ $rows->name }} @if($score) {{ $score->final_score }} @endif
B MUATAN KEWILAYAHAN
{{ $i }} {{ $rows->name }} @if($score) {{ $score->final_score }} @endif
C1 DASAR BIDANG KEAHLIAN
{{ $i }} {{ $rows->name }} @if($score) {{ $score->final_score }} @endif
C2 DASAR PROGRAM KEAHLIAN
{{ $i }} Dasar Program Keahlian {{ $score_c2 }}
C3 DASAR KOMPETENSI KEAHLIAN
1 Kompetensi Keahlian {{ $score_c3 }}
2 Produk Kreatif dan Kewirausahaan {{ $score_praktek }}
Rata-rata {{ $scount }}

Tangerang Selatan, @if(session('date_mangsa')){{ dateIndo(session('date_mangsa')) }}@else{{ dateIndo(DATE('Y-m-d')) }}@endif
Kepala Sekolah,



{{ $setting->headmaster }}

@endforeach