@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

Transkrip Nilai

Nama : {{ $student->name }}
Tempat / Tanggal Lahir : @if($student->birthplace) {{ $student->birthplace }},{{ $student->birthdate }} @else - @endif
NISN : {{ $student->code }}
Bidang Studi Keahlian : {{ $class->major->name }}
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; @endphp @foreach($area as $rows) @php $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; } @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; @endphp @foreach($interestc2 as $rows) @php $score = App\Transcript::where('active',1) ->where('lesson_id',$rows->id) ->where('user_id',$student->id) ->first(); @endphp @php $i++; $count_c2++; if($score){ $sum_c2 = $sum_c2 + $score->final_score; } @endphp @endforeach @endif @if(count($interestc3)) @php $i = 1; $count_c3 = 0; $sum_c3 = 0; @endphp @foreach($interestc3 as $rows) @php $score = App\Transcript::where('active',1) ->where('lesson_id',$rows->id) ->where('user_id',$student->id) ->first(); @endphp @php $i++; $count_c3++; if($score) { $sum_c3 = $sum_c3 + $score->final_score; } @endphp @endforeach @endif @php $ukk = App\ScoreUkk::where('active',1) ->where('user_id',$student->id) ->where('year_id',session('s_year')) ->where('classroom_id',session('s_classroom')) ->first(); if($ukk) { $score_ukk = $ukk->ukk_score; $score_rpl = $ukk->rpl_score; } else { $score_ukk = null; $score_rpl = null; } @endphp
No Program Pendidikan dan Pelatihan
(Kopetensi)		 Nilai Semester Nilai Nilai Akhir
1 2 3 4 5 6 Rata-rata Sekolah SKL UKK
A MUATAN NASIONAL
{{ $i }} {{ $rows->name }} @if($score) {{ $score->semester_one }} @endif @if($score) {{ $score->semester_two }} @endif @if($score) {{ $score->semester_three }} @endif @if($score) {{ $score->semester_four }} @endif @if($score) {{ $score->semester_five }} @endif @if($score) {{ $score->semester_six }} @endif @if($score) {{ $score->average_score }} @endif @if($score) {{ $score->school_score }} @endif @if($score) {{ $score->un_score }} @endif @if($score) {{ $score->final_score }} @endif
B MUATAN KEWILAYAHAN
{{ $i }} {{ $rows->name }} @if($score) {{ $score->semester_one }} @endif @if($score) {{ $score->semester_two }} @endif @if($score) {{ $score->semester_three }} @endif @if($score) {{ $score->semester_four }} @endif @if($score) {{ $score->semester_five }} @endif @if($score) {{ $score->semester_six }} @endif @if($score) {{ $score->average_score }} @endif @if($score) {{ $score->school_score }} @endif @if($score) {{ $score->un_score }} @endif @if($score) {{ $score->final_score }} @endif
C1 DASAR BIDANG KEAHLIAN
{{ $i }} {{ $rows->name }} @if($score) {{ $score->semester_one }} @endif @if($score) {{ $score->semester_two }} @endif @if($score) {{ $score->semester_three }} @endif @if($score) {{ $score->semester_four }} @endif @if($score) {{ $score->semester_five }} @endif @if($score) {{ $score->semester_six }} @endif @if($score) {{ $score->average_score }} @endif @if($score) {{ $score->school_score }} @endif @if($score) {{ $score->un_score }} @endif @if($score) {{ $score->final_score }} @endif
C2 DASAR PROGRAM KEAHLIAN
{{ $i }} {{ $rows->name }} @if($score) {{ $score->semester_one }} @endif @if($score) {{ $score->semester_two }} @endif @if($score) {{ $score->semester_three }} @endif @if($score) {{ $score->semester_four }} @endif @if($score) {{ $score->semester_five }} @endif @if($score) {{ $score->semester_six }} @endif @if($score) {{ $score->average_score }} @endif @if($score) {{ $score->school_score }} @endif @if($score) {{ $score->un_score }} @endif @if($score) {{ $score->final_score }} @endif
C3 DASAR KOMPETENSI KEAHLIAN
{{ $i }} {{ $rows->name }} @if($score) {{ $score->semester_one }} @endif @if($score) {{ $score->semester_two }} @endif @if($score) {{ $score->semester_three }} @endif @if($score) {{ $score->semester_four }} @endif @if($score) {{ $score->semester_five }} @endif @if($score) {{ $score->semester_six }} @endif @if($score) {{ $score->average_score }} @endif @if($score) {{ $score->school_score }} @endif @if($score) {{ $score->un_score }} @endif @if($score) {{ $score->final_score }} @endif
{{ $i+1 }} Nilai UKK {{ $score_ukk }} {{ $score_ukk }}
{{ $i+2 }} Nilai Praktik Kerja Industri {{ $score_rpl }} {{ $score_rpl }}
@php $scount = ceil(($sum_c3 + $sum_c2 + $sum_c1 + $sum_mk + $sum_mu + $score_ukk + $score_rpl) / ($count_c3 + $count_c2 + $count_c1 + $count_mk + $count_mu + 2)); @endphp
Rata-rata Nilai Akhir: {{ $scount }}
Tangerang Selatan, @if(session('date_mangsa')){{ dateIndo(session('date_mangsa')) }}@else{{ dateIndo(DATE('Y-m-d')) }}@endif
Kepala Sekolah,

{{ $setting->headmaster }}
@endforeach