/** * 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!'); } } }
public function store() { $item = Dosen::create(request()->all()); }