@foreach($checked as $id) @php $student = App\User::find($id); $national = App\Lesson::where('category',1) ->where('active',1) ->where('year_id',$year->id) ->where('study_major_id',$class->study_major_id) ->where('study_program_id',$class->study_program_id) ->where('study_competency_id',$class->study_competency_id) ->groupBy('name') ->orderBy('urutan') ->get(); $area = App\Lesson::where('category',2) ->where('active',1) ->where('year_id',$year->id) ->where('study_major_id',$class->study_major_id) ->where('study_program_id',$class->study_program_id) ->where('study_competency_id',$class->study_competency_id) ->groupBy('name') ->orderBy('urutan') ->get(); $interestc1 = App\Lesson::where('category',3) ->where('subcategory',1) ->where('active',1) ->where('year_id',$year->id) ->where('study_major_id',$class->study_major_id) ->where('study_program_id',$class->study_program_id) ->where('study_competency_id',$class->study_competency_id) ->groupBy('name') ->orderBy('urutan') ->get(); $interestc2 = App\Lesson::where('category',3) ->where('subcategory',2) ->where('active',1) ->where('year_id',$year->id) ->where('study_major_id',$class->study_major_id) ->where('study_program_id',$class->study_program_id) ->where('study_competency_id',$class->study_competency_id) ->groupBy('name') ->orderBy('urutan') ->get(); $interestc3 = App\Lesson::where('category',3) ->where('subcategory',3) ->where('active',1) ->where('year_id',$year->id) ->where('study_major_id',$class->study_major_id) ->where('study_program_id',$class->study_program_id) ->where('study_competency_id',$class->study_competency_id) ->groupBy('name') ->orderBy('urutan') ->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

DAFTAR NILAI

SEKOLAH MENENGAH KEJURUAN

TAHUN PELAJARAN {{ $year->name }}

@php /* */ @endphp
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) ->whereRaw("lessonName like '%".$rows->name."%'") ->where('user_id',$student->id) ->first(); $score = App\Transcript::where('active',1) ->whereRaw("lessonName like '%".$rows->name."%'") ->where('user_id',$student->id) ->first(); if(isset($score)){ $divide = 0; if($score->semester_one > 0) { $divide += 1; } if($score->semester_two > 0) { $divide += 1; } if($score->semester_three > 0) { $divide += 1; } if($score->semester_four > 0) { $divide += 1; } if($score->semester_five > 0) { $divide += 1; } if($score->semester_six > 0) { $divide += 1; } $avg = ($score->semester_one + $score->semester_two + $score->semester_three + $score->semester_four + $score->semester_five + $score->semester_six) / ($divide == 0 ? 1 : $divide); $final = ($avg * 0.6) + ($score->school_score * 0.4); } @endphp @php $i++; if($score){ $count_mu++; $sum_mu = $sum_mu + $final; } @endphp @endforeach @php $i = 1; $count_mk = 0; $sum_mk = 0; $score_kwu = 0; $score_qr @endphp @foreach($area as $rows) @php if($rows->name != 'Kewirausahaan' AND $rows->name != 'Baca Tulis Al-Quran/Iman dan Taqwa') { $score = App\Transcript::where('active',1) ->whereRaw("lessonName like '%".$rows->name."%'") ->where('user_id',$student->id) ->first(); if(isset($score)){ $divide = 0; if($score->semester_one > 0) { $divide += 1; } if($score->semester_two > 0) { $divide += 1; } if($score->semester_three > 0) { $divide += 1; } if($score->semester_four > 0) { $divide += 1; } if($score->semester_five > 0) { $divide += 1; } if($score->semester_six > 0) { $divide += 1; } $avg = ($score->semester_one + $score->semester_two + $score->semester_three + $score->semester_four + $score->semester_five + $score->semester_six) / ($divide == 0 ? 1 : $divide); $final = ($avg * 0.6) + ($score->school_score * 0.4); } @endphp @php $i++; if($score){ $count_mk++; $sum_mk += $final; } } elseif($rows->name == 'Baca Tulis Al-Quran/Iman dan Taqwa') { $score = App\Transcript::where('active',1) ->whereRaw("lessonName like '%".$rows->name."%'") ->where('user_id',$student->id) ->first(); if($score){ $divide = 0; if($score->semester_one > 0) { $divide += 1; } if($score->semester_two > 0) { $divide += 1; } if($score->semester_three > 0) { $divide += 1; } if($score->semester_four > 0) { $divide += 1; } if($score->semester_five > 0) { $divide += 1; } if($score->semester_six > 0) { $divide += 1; } $avg = ($score->semester_one + $score->semester_two + $score->semester_three + $score->semester_four + $score->semester_five + $score->semester_six) / ($divide == 0 ? 1 : $divide); $final = ($avg * 0.6) + ($score->school_score * 0.4); $score_qr = $final; } } else { $divide = 0; if($score->semester_one > 0) { $divide += 1; } if($score->semester_two > 0) { $divide += 1; } if($score->semester_three > 0) { $divide += 1; } if($score->semester_four > 0) { $divide += 1; } if($score->semester_five > 0) { $divide += 1; } if($score->semester_six > 0) { $divide += 1; } $avg = ($score->semester_one + $score->semester_two + $score->semester_three + $score->semester_four + $score->semester_five + $score->semester_six) / ($divide == 0 ? 1 : $divide); $final = ($avg * 0.6) + ($score->school_score * 0.4); $score_kwu = $final; } @endphp @endforeach @if($score_qr) @endif @if(count($interestc1)) @php $i = 1; $count_c1 = 0; $sum_c1 = 0; @endphp @foreach($interestc1 as $rows) @php $score = App\Transcript::where('active',1) ->whereRaw("lessonName like '%".$rows->name."%'") ->where('user_id',$student->id) ->first(); if(isset($score)){ $divide = 0; if($score->semester_one > 0) { $divide += 1; } if($score->semester_two > 0) { $divide += 1; } if($score->semester_three > 0) { $divide += 1; } if($score->semester_four > 0) { $divide += 1; } if($score->semester_five > 0) { $divide += 1; } if($score->semester_six > 0) { $divide += 1; } $avg = ($score->semester_one + $score->semester_two + $score->semester_three + $score->semester_four + $score->semester_five + $score->semester_six) / ($divide == 0 ? 1 : $divide); $final = ($avg * 0.6) + ($score->school_score * 0.4); } @endphp @php $i++; if($score){ $count_c1++; $sum_c1 += $final; } @endphp @endforeach @endif @php $score_c2 = 0; @endphp @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) ->whereRaw("lessonName like '%".$rows->name."%'") ->where('user_id',$student->id) ->first(); $count_c2++; if($score){ $divide = 0; if($score->semester_one > 0) { $divide += 1; } if($score->semester_two > 0) { $divide += 1; } if($score->semester_three > 0) { $divide += 1; } if($score->semester_four > 0) { $divide += 1; } if($score->semester_five > 0) { $divide += 1; } if($score->semester_six > 0) { $divide += 1; } $avg = ($score->semester_one + $score->semester_two + $score->semester_three + $score->semester_four + $score->semester_five + $score->semester_six) / ($divide == 0 ? 1 : $divide); $final = ($avg * 0.6) + ($score->school_score * 0.4); $sum_c2 = $sum_c2 + $final; } } $score_c2 = $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) { $score = App\Transcript::where('active',1) ->whereRaw("lessonName like '%".$rows->name."%'") ->where('user_id',$student->id) ->first(); if($score) { $count_c3++; $divide = 0; if($score->semester_one > 0) { $divide += 1; } if($score->semester_two > 0) { $divide += 1; } if($score->semester_three > 0) { $divide += 1; } if($score->semester_four > 0) { $divide += 1; } if($score->semester_five > 0) { $divide += 1; } if($score->semester_six > 0) { $divide += 1; } $avg = ($score->semester_one + $score->semester_two + $score->semester_three + $score->semester_four + $score->semester_five + $score->semester_six) / ($divide == 0 ? 1 : $divide); $final = ($avg * 0.6) + ($score->school_score * 0.4); $sum_c3 = $sum_c3 + $final; } } $score_c3 = $sum_c3 / $count_c3; @endphp @endif @php /* */ @endphp @php //$scount = ceil(($score_c3 + $score_c2 + $sum_c1 + $sum_mk + $sum_mu + $score_praktek) / (3 + $count_c1 + $count_mk + $count_mu)); $scount = ($score_c3 + $score_c2 + $sum_c1 + $sum_mk + $sum_mu) / (2 + $count_c1 + $count_mk + $count_mu); @endphp
No Mata Pelajaran Nilai Ujian Sekolah
Muatan Nasional
{{ $i }} {{ $rows->name }} @if($score) {{ number_format($final, 2) }} @endif
Muatan Kewilayahan
{{ $i }} {{ $rows->name }} @if($score) {{ number_format($final, 2) }} @endif
{{ $i }} Muatan Lokal
Baca Tulis Al-Quran/Iman dan Taqwa @if($score_qr) {{ number_format($score_qr, 2) }} @endif
Muatan Peminatan Kejuruan
{{ $i }} {{ $rows->name }} @if($score) {{ number_format($final, 2) }} @endif
{{ $i }} Dasar Program Keahlian {{ number_format($score_c2, 2) }}
{{ $i+1 }} Kompetensi Keahlian {{ number_format($score_c3, 2) }}
2 Produk Kreatif dan Kewirausahaan {{ number_format($score_praktek, 2) }}
Rata-rata {{ number_format($scount, 2) }}

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



{{ $setting->headmaster }}

@endforeach