Informasi
Berikut adalah preview data yang akan diimpor. Silakan periksa data berikut sebelum melanjutkan.
@php
$dosens = App\Models\Dosen::whereIn('id', $pengampu_ids)->get();
@endphp
| Nama Dosen |
NIP/NIDN |
@forelse($dosens as $dosen)
| {{ $dosen->nama }} |
{{ $dosen->nip ?? 'N/A' }} |
@empty
| Tidak ada pengampu yang dipilih |
@endforelse
@foreach($preview as $sheetName => $sheetData)
@if($sheetName === 'CPMK-CPL' || $sheetName === 'FORM NILAI SIAP')
@if($sheetName === 'CPMK-CPL')
| Mata Kuliah |
{{ $sheetData[0][2] }} |
| Tahun |
{{ $sheetData[1][2] }} |
| Semester |
{{ $sheetData[2][2] }} |
| Kelas |
{{ $sheetData[3][2] }} |
| SKS |
{{ $sheetData[8][2] }} |
| Pengampu di Excel |
{{ $sheetData[5][2] }} |
| Koordinator Pengampu |
{{ $sheetData[6][2] }} |
| Kaprodi |
{{ $sheetData[9][2] }} |
| GPM |
{{ $sheetData[11][2] }} |
Data CPMK-CPL
| Kode CPMK |
Deskripsi CPMK |
Kode CPL |
@foreach(array_slice($sheetData, 18, 14) as $row)
@if(!empty($row[1]))
| {{ $row[1] }} |
{{ $row[2] }} |
{{ collect(array_slice($row, 3, 13))->search(fn($value) => $value == 1) !== false ? 'CPL' . (collect(array_slice($row, 3, 13))->search(fn($value) => $value == 1) + 1) : '-' }} |
@endif
@endforeach
@elseif($sheetName === 'FORM NILAI SIAP')
| Mata Kuliah |
{{ explode(' ', $sheetData[0][1])[0] }} |
| Tahun |
{{ substr($sheetData[1][1], 0, 4) }} |
| Semester |
{{ $sheetData[2][1] }} |
| Kelas |
{{ $sheetData[3][1] }} |
Data Nilai
| NIM |
Nama |
Semester |
Status |
Nilai Akhir Angka |
Nilai Akhir Huruf |
Bobot |
Outcome |
@php
$rowNilaiAkhirAngka = strpos(strtolower($sheetData[6][8]), 'nilai akhir angka') === 0 ? 8 : 10;
$rowNilaiAkhirHuruf = $rowNilaiAkhirAngka + 1;
$rowNilaiBobot = $rowNilaiAkhirHuruf + 1;
$rowOutcome = $rowNilaiBobot + 1;
@endphp
@foreach(array_slice($sheetData, 7) as $row)
@if(!empty($row[0]))
| {{ $row[0] }} |
{{ $row[1] }} |
{{ $row[2] }} |
{{ $row[3] }} |
{{ $row[$rowNilaiAkhirAngka] }} |
{{ $row[$rowNilaiAkhirHuruf] }} |
{{ str_replace(',', '.', $row[$rowNilaiBobot]) }} |
{{ $row[$rowOutcome] }} |
@endif
@endforeach
@endif
@endif
@endforeach