public static function check($semester = null)
{
$mapel = Mapel::where('kelompok', '!=', 'WK')->get()->count();
if ($mapel < 1) {
return -1;
}
$kb = self::where('id_semester', $semester ? $semester : Semester::get_active_semester()->id)->get()->count();
return $mapel - $kb;
}
public function setup(Request $request)
{
// Set semester
$new = new Semester();
$new->semester = $request->input('semester');
$new->tahun_ajaran = $request->input('tahun_ajaran');
$new->aktif = 1;
$new->save();
$input = $request->except(['_token', 'semester', 'tahun_ajaran']);
// Set pengaturan
foreach ($input as $key => $value) {
Pengaturan::vset($key, $value);
}
// Cek apakah mata pelajaran wali kelas sudah ada, kalau belum, tambah
$wk = Mapel::where('kelompok', 'WK')->get();
if (!$wk) {
App\Mapel::create(['nama' => 'Wali kelas', 'singkat' => 'WALI', 'kelompok' => 'WK']);
}
return redirect()->route('kelas.jurusan')->with('message', "Data semester dan informasi sekolah telah dikonfigurasi.");
}
public function upload_save(Request $request)
{
$this->validate($request, ['id_mapel' => 'required|exists:mapel,id', 'excel' => 'required']);
$inputFileName = $request->excel;
try {
$inputFileType = PHPExcel_IOFactory::identify($inputFileName);
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($inputFileName);
} catch (Exception $e) {
die('Error loading file "' . pathinfo($inputFileName, PATHINFO_BASENAME) . '": ' . $e->getMessage());
}
$data_count = 0;
$errors = 0;
$semester = Semester::get_active_semester()->id;
foreach ($objPHPExcel->getWorksheetIterator() as $sheet) {
$highestRow = $sheet->getHighestRow();
$highestColumn = $sheet->getHighestColumn();
$start = false;
$id_mapel = $request->input('id_mapel');
for ($row = 1; $row <= $highestRow; $row++) {
$rowData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE);
if (!$start) {
// Start check
if ($rowData[0][0] == "1" || $rowData[0][0] == "1.") {
$start = true;
}
// Mapel set
foreach ($rowData[0] as $colNum => $colVal) {
if (strpos(strtolower($colVal), 'mata pelajaran:') !== FALSE || strpos(strtolower($colVal), 'mapel:') !== FALSE) {
$c = Mapel::where('nama', 'LIKE', $rowData[0][$colNum + 1])->first();
if ($c) {
$id_mapel = $c->id;
}
}
}
}
if ($start) {
$id_siswa = null;
$data_count++;
if (!empty($rowData[0][1])) {
$siswa = Siswa::where('nis', $rowData[0][1])->first();
if (!$siswa) {
$errors++;
$id_siswa = null;
continue;
}
$id_siswa = $siswa->id;
}
if (!$id_siswa) {
continue;
}
$new = new NilaiAkhir();
$created = null;
$check = NilaiAkhir::where('id_mapel', $id_mapel)->where('id_siswa', $id_siswa)->where('id_semester', $semester);
$old = $check->first();
if ($old) {
$created = $old->created_at;
$check->delete();
}
$new->id_siswa = $id_siswa;
$new->id_mapel = $id_mapel;
$new->id_semester = $semester;
$new->nilai_pengetahuan = $rowData[0][3] ? $rowData[0][3] : null;
$new->deskripsi_pengetahuan = $rowData[0][4] ? $rowData[0][4] : null;
$new->nilai_keterampilan = $rowData[0][5] ? $rowData[0][5] : null;
$new->deskripsi_keterampilan = $rowData[0][6] ? $rowData[0][6] : null;
if ($created) {
$new->created_at = $created;
}
try {
$new->save();
} catch (\Illuminate\Database\QueryException $e) {
$errors++;
}
}
}
}
$message = "Upload file selesai. Terbaca ada {$data_count} data. ";
$message .= $errors > 0 ? "Ada masalah dengan {$errors} data, dan tidak dapat dimasukkan ke dalam database." : "Semua data berhasil ditambahkan.";
return redirect()->route('nilai.akhir')->with('message', $message);
}
