/**
* 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);
}
