/** * Show the form for creating a new resource. * * @return Response */ public function importDosen() { $fileExcel = Input::file('excel'); if (empty($fileExcel)) { return Redirect::to('administrator/dosen')->with('msge', 'Input tidak boleh kosong!'); } else { $excels = Excel::selectSheetsByIndex(0)->load($fileExcel, function ($reader) { })->get(); #validation data $rules = array('nik' => 'required', 'nama_dosen' => 'required', 'field_studi' => 'required', 'alumni' => 'required', 'status_dosen' => 'required', 'alamat_email' => 'required'); $counter = 0; foreach ($excels as $key => $excel) { $validator = Validator::make($excel->toArray(), $rules); $cekada = Dosen::find($excel->nik); if ($cekada) { continue; } if ($validator->fails()) { continue; } $dosens = array('nik' => $excel->nik, 'nama_dosen' => $excel->nama_dosen, 'field_studi' => $excel->field_studi, 'alumni' => $excel->alumni, 'status_dosen' => $excel->status_dosen, 'alamat_email' => $excel->alamat_email); $tambah = Dosen::create($dosens); if ($tambah) { $counter++; } } if ($counter > 0) { return Redirect::to('administrator/dosen')->with('msgs', ' <b>' . $counter . '</b> Data dosen berhasil di import!'); } else { return Redirect::to('administrator/dosen')->with('msge', 'Ada kesalahan, silahkan mencoba kembali dan perhatikan ketentuan yang berlaku!'); } } }
/** * Show the form for creating a new resource. * * @return Response */ public function importMatakuliah() { $fileExcel = Input::file('excel'); if (empty($fileExcel)) { return Redirect::to('administrator/matakuliah')->with('msge', 'Input tidak boleh kosong!'); } else { $excels = Excel::selectSheetsByIndex(0)->load($fileExcel, function ($reader) { })->get(); $rules = array('kode_matakuliah' => 'required', 'kode_prodi' => 'required', 'nama_matakuliah' => 'required', 'sks_teori' => 'required', 'sks_praktek' => 'required', 'sks_praktikum' => 'required'); $counter = 0; foreach ($excels as $key => $excel) { $validator = Validator::make($excel->toArray(), $rules); $cekada = Matakuliah::find($excel->kode_matakuliah); if ($cekada) { continue; } if ($validator->fails()) { continue; } $matakuliah = array('kode_matakuliah' => $excel->kode_matakuliah, 'kode_prodi' => $excel->kode_prodi, 'nama_matakuliah' => $excel->nama_matakuliah, 'sks_teori' => $excel->sks_teori, 'sks_praktek' => $excel->sks_praktek, 'sks_praktikum' => $excel->sks_praktikum); $tambah = Matakuliah::create($matakuliah); if ($tambah) { $counter++; } } if ($counter > 0) { return Redirect::to('administrator/matakuliah')->with('msgs', '<b>' . $counter . '</b> Data matakuliah berhasil diimport !'); } else { return Redirect::to('administrator/matakuliah')->with('msge', 'Ada kesalahan, silahkan mencoba kembali dan perhatikan ketentuan yang berlaku'); } } }
/** * Show the form for creating a new resource. * * @return Response */ public function importMahasiswa() { $fileExcel = Input::file('excel'); if (empty($fileExcel)) { return Redirect::to('administrator/mahasiswa')->with('msge', 'Input tidak boleh kosong.'); } else { $excels = Excel::selectSheetsByIndex(0)->load($fileExcel, function ($reader) { })->get(); #validation data $rules = array('nim' => 'required', 'nama_mahasiswa' => 'required', 'tempat_lahir' => 'required', 'tanggal_lahir' => 'required', 'alamat' => 'required', 'telepon' => 'required', 'jenis_kelamin' => 'required', 'agama' => 'required', 'angkatan' => 'required', 'kode_prodi' => ' required'); $counter = 0; foreach ($excels as $key => $excel) { $validation = Validator::make($excel->toArray(), $rules); $cekada = Mahasiswa::find($excel->nim); if ($cekada) { continue; } if ($validation->fails()) { continue; } $mahasiswa = array('nim' => $excel->nim, 'nama_mahasiswa' => $excel->nama_mahasiswa, 'tempat_lahir' => $excel->tempat_lahir, 'tanggal_lahir' => $excel->tanggal_lahir, 'alamat' => $excel->alamat, 'telepon' => $excel->telepon, 'jenis_kelamin' => $excel->jenis_kelamin, 'agama' => $excel->agama, 'angkatan' => $excel->angkatan, 'kode_prodi' => $excel->kode_prodi); $tambah = Mahasiswa::create($mahasiswa); if ($tambah) { $counter++; } } if ($counter > 0) { return Redirect::to('administrator/mahasiswa')->with('msgs', '<b>' . $counter . '</b> Data mahasiswa berhasil diimport.'); } else { return Redirect::to('administrator/mahasiswa')->with('msge', 'Tidak ada data yang di import.'); } } }
/** * Show the form for creating a new resource. * * @return Response */ public function importKrs() { $fileExcel = Input::file('excel'); if (empty($fileExcel)) { return Redirect::to('administrator/krs')->with('msge', 'Inputan tidak boleh kosong.'); } else { $excels = Excel::selectSheetsByIndex(0)->load($fileExcel, function ($reader) { })->get(); #validasi data $rules = array('nim' => 'required', 'semester' => 'required', 'kode_matakuliah' => 'required', 'status_krs' => 'required'); $counter = 0; foreach ($excels as $key => $excel) { $Validator = Validator::make($excel->toArray(), $rules); $cekada = Krs::find($excel->id_krs); if ($cekada) { continue; } if ($Validator->fails()) { continue; } $krs = array('nim' => $excel->nim, 'semester' => $excel->semester, 'kode_matakuliah' => $excel->kode_matakuliah, 'status_krs' => $excel->status_krs); $tambah = Krs::create($krs); if ($tambah) { $counter++; } } if ($counter > 0) { return Redirect::to('administrator/krs')->with('msgs', 'Berhasil import <b>' . $counter . '</b> data krs'); } else { return Redirect::to('administrator/krs')->with('msge', 'Ada kesalahan, silahkan mencoba kembali dan perhatikan ketentuan yang berlaku'); } } }
/** * Select sheets by index * * @param array $sheets * @return $this * @static */ public static function selectSheetsByIndex($sheets = array()) { return \Maatwebsite\Excel\Excel::selectSheetsByIndex($sheets); }