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