public function delete(Request $request) { $this->validate($request, ['id' => 'required|exists:jurusan,id']); $check = Kelas::where('id_jurusan', $request->id)->count(); if ($check) { $responseText = "Jurusan batal dihapus: ada kelas yang terdaftar dengan jurusan ini."; if ($request->ajax()) { return response($responseText, 422); } else { return redirect()->route('kelas.jurusan')->with('message', $responseText); } } $responseText = ""; $responseCode = 0; $jurusan = Jurusan::findOrFail($request->id); if ($jurusan->delete()) { $responseText = "Jurusan berhasil dihapus."; $responseCode = 200; } else { $responseText = "Jurusan gagal dihapus."; $responseCode = 422; } if ($request->ajax()) { return response($responseText, $responseCode); } else { return redirect()->route('kelas.jurusan')->with('message', $responseText); } }
public function mass(Request $request) { $this->validate($request, ['tingkat' => 'required|integer', 'kelas' => 'required', 'angkatan' => 'required|integer']); $jurusan = Jurusan::all(); $fails = []; foreach ($jurusan as $j) { try { $new = new Kelas(); $new->tingkat = $request->tingkat; $new->id_jurusan = $j->id; $new->kelas = $request->kelas; $new->angkatan = $request->angkatan; $new->save(); } catch (\Illuminate\Database\QueryException $e) { $fails[] = "{$request->tingkat} {$j->singkat} {$request->kelas}"; } } if (count($fails) == count($jurusan)) { return response("Operasi gagal; mungkin kelasnya sudah ada.", 422); } elseif (count($fails) > 0) { $responseText = "Kelas berhasil ditambahkan kecuali kelas: "; foreach ($fails as $f) { $responseText .= "{$f}, "; } return response(rtrim($responseText, ', '), 422); } else { return response(count($jurusan) . " kelas berhasil ditambahkan.", 200); } }
/** * Run the database seeds. */ public function run() { $faker = Faker\Factory::create('id_ID'); for ($i = 1; $i <= 120; ++$i) { $kelas = 1; if ($i > 30) { $kelas = 2; } if ($i > 60) { $kelas = 3; } if ($i > 90) { $kelas = 4; } $gender = $faker->randomElement(array('male', 'female')); $jk = $gender == 'male' ? 'L' : 'P'; $alamat = $faker->address; $kota = $faker->city; $kelas_menerima = 'X ' . Jurusan::find(Kelas::find($kelas)->id_jurusan)->lengkap . ' ' . Kelas::find($kelas)->kelas; App\Siswa::create(['nama' => strtoupper($faker->firstName($gender) . ' ' . $faker->lastName), 'nis' => ($kelas <= 2 ? '14' : '15') . str_pad($i, 7, '0', STR_PAD_LEFT), 'nisn' => '999' . str_pad($i, 7, '0', STR_PAD_LEFT), 'tempat_lahir' => strtoupper($kota), 'tanggal_lahir' => $faker->date('Y-m-d', '1999-12-31'), 'jenis_kelamin' => $jk, 'agama' => 'Islam', 'anak_ke' => $faker->numberBetween(1, 4), 'alamat_siswa' => $alamat, 'nomor_telepon_rumah_siswa' => null, 'sekolah_asal' => strtoupper('SMP Negeri ' . $faker->numberBetween(1, 9) . ' ' . $kota), 'id_kelas' => $kelas, 'diterima_di_kelas' => $kelas_menerima, 'tanggal_diterima' => '2013-07-15', 'nama_ayah' => strtoupper($faker->name('male')), 'nama_ibu' => strtoupper($faker->name('female')), 'alamat_orang_tua' => $alamat, 'nomor_telepon_rumah_orang_tua' => null, 'pekerjaan_ayah' => 'Wirausaha', 'pekerjaan_ibu' => 'Ibu rumah tangga', 'nama_wali' => null, 'nomor_telepon_rumah_wali' => null, 'pekerjaan_wali' => null]); } }
/** * Halaman utama bagi staf. */ public function index() { // Ambil data semester yang aktif $pass['semester'] = Semester::get_active_semester(); // Pengecekan // 0 = fine // 1 = warning // 2 = error // Cek apakah ada jurusan tercatat $pass['jurusan'] = Jurusan::all()->count(); // Cek apakah kelas tingkat 1 sudah dibuat $kelas = Kelas::check_firstyears(); $pass['kelas'] = $kelas; if ($kelas['total'] == 0) { $pass['kelas']['cek'] = 2; } elseif ($kelas['count'] < $kelas['jurusan']) { $pass['kelas']['cek'] = 1; } else { $pass['kelas']['cek'] = 0; } // Cek apakah ada kelas tingkat 1 yang kosong $siswa = Siswa::check_firstyears(); $pass['siswa'] = $siswa; if ($siswa['siswa_tingkat_x'] <= 0) { $pass['siswa']['cek'] = 2; } elseif ($siswa['kelas_kosong'] > 0) { $pass['siswa']['cek'] = 1; } else { $pass['siswa']['cek'] = 0; } // Cek apakah semua mapel sudah memiliki angka KB untuk semester ini $pass['kb'] = KetuntasanBelajar::check(); // Cek apakah ada guru yang belum mendapat asosiasi pengajaran $pass['mengajar'] = Mengajar::check(); return view('panel', $pass); }
public function upload(Request $request) { $this->validate($request, ['id_kelas' => 'required|exists:kelas,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; foreach ($objPHPExcel->getWorksheetIterator() as $sheet) { $highestRow = $sheet->getHighestRow(); $highestColumn = $sheet->getHighestColumn(); $start = false; $id_kelas = $request->input('id_kelas'); 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; } // Kelas set foreach ($rowData[0] as $colNum => $colVal) { if (strpos(strtolower($colVal), 'kelas:') !== FALSE) { $kcheck = explode(" ", $rowData[0][$colNum + 1]); if (count($kcheck) < 3) { continue; } $kc_kelas = array_pop($kcheck); $kc_tingkat = array_shift($kcheck); if (!is_numeric($kc_tingkat)) { $kc_tingkat = array('X' => 1, 'XI' => 2, 'XII' => 3, 'XIV' => 4)[$kc_tingkat]; } $kc_jurusan = strtolower(implode(" ", $kcheck)); $jc = Jurusan::whereRaw("LOWER(lengkap) LIKE '{$kc_jurusan}'")->orWhereRaw("LOWER(singkat) LIKE '{$kc_jurusan}'")->first(); if (!$jc) { continue; } $kc_jurusan = $jc->id; $c = Kelas::where('tingkat', $kc_tingkat)->where('kelas', $kc_kelas)->where('id_jurusan', $kc_jurusan)->first(); if ($c) { $id_kelas = $c->id; } } } } if ($start) { $siswa = null; $data_count++; if (!empty($rowData[0][1])) { $siswa = Siswa::where('nis', $rowData[0][1])->first(); if ($siswa) { $siswa = Siswa::find($siswa->id); } else { $siswa = new Siswa(); } } if (!$siswa) { $errors++; continue; } $siswa->nis = $rowData[0][1]; $siswa->nisn = $rowData[0][2]; $siswa->nama = $rowData[0][3]; $siswa->id_kelas = $id_kelas; $siswa->tempat_lahir = $rowData[0][4]; $sheet->getStyle('F' . $row)->getNumberFormat()->setFormatCode('dd/mm/yyyy'); $siswa->tanggal_lahir = $this->id2sql_date_convert($sheet->getCellByColumnAndRow(5, $row)->getFormattedValue()); $siswa->jenis_kelamin = substr($rowData[0][6], 0, 1); $siswa->agama = $rowData[0][7]; $siswa->status_dalam_keluarga = str_replace('anak ', '', strtolower($rowData[0][8])); $siswa->anak_ke = $rowData[0][9]; $siswa->alamat_siswa = $rowData[0][10]; $siswa->nomor_telepon_rumah_siswa = $rowData[0][11]; $siswa->sekolah_asal = $rowData[0][12]; $siswa->diterima_di_kelas = $rowData[0][13]; $sheet->getStyle('O' . $row)->getNumberFormat()->setFormatCode('dd/mm/yyyy'); $siswa->tanggal_diterima = $this->id2sql_date_convert($sheet->getCellByColumnAndRow(14, $row)->getFormattedValue()); $siswa->nama_ayah = $rowData[0][15]; $siswa->nama_ibu = $rowData[0][16]; $siswa->alamat_orang_tua = $rowData[0][17]; $siswa->nomor_telepon_rumah_orang_tua = $rowData[0][18]; $siswa->pekerjaan_ayah = $rowData[0][19]; $siswa->pekerjaan_ibu = $rowData[0][20]; $siswa->nama_wali = $rowData[0][21]; $siswa->alamat_wali = $rowData[0][22]; $siswa->nomor_telepon_rumah_wali = $rowData[0][23]; $siswa->pekerjaan_wali = $rowData[0][24]; try { $siswa->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('siswa')->with('message', $message); }
public static function check_firstyears() { return ['total' => self::where('tingkat', '1')->get()->count(), 'jurusan' => Jurusan::all()->count(), 'count' => self::select(DB::raw('count(*)'))->where('kelas.tingkat', '1')->groupBy('kelas.id_jurusan')->get()->count()]; }
public function index(Jurusan $jurusan) { $resource = $jurusan->all(); return $this->respondWithCollection($resource, new JurusanTransformer()); }