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());
}
