/** * Import students account data with excel * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function import(Request $request) { // get tmp xlsx file path $file_path = $request->file('studentData')->getRealPath(); // extract student data from the file uploaded $student_data = Excel::load($file_path)->toArray(); // processing & storing student data foreach ($student_data as $data) { $user = new User(); $user->username = $data['學號']; $user->password = str_random(96); $user->nickname = $data['姓名']; $user->email = $data['信箱']; $user->phone = $data['電話']; $user->group = $data['班級']; $user->save(); $user->roles()->save(Role::where('name', 'student')->first()); } return response()->json(['status' => 0]); }