/**
* Create a new user instance after a valid registration.
*
* @param array $data
* @return User
*/
protected function create(array $data)
{
return User::create(['name' => $data['name'], 'email' => $data['email'], 'password' => bcrypt($data['password'])]);
}
/**
* Import the excel document
*
* @Post("config/importar")
*/
public function importUser(Request $request)
{
\Storage::disk('public')->put('file.csv', \File::get($request->file));
$importFile = \Storage::disk('public')->get('file.csv');
if (!preg_match('/,/', $importFile)) {
\Config::set('excel.csv.delimiter', ';');
}
try {
$password = $request->password;
Excel::load('file.csv', function ($reader) use($password) {
foreach ($reader->get() as $file) {
User::create(['name' => $file->nombre, 'phone' => $file->telefono, 'email' => $file->email, 'password' => bcrypt($password), 'sex' => $file->sexo == "hombre" ? "male" : "female", 'avatar' => null, 'birthdate' => date_format(date_create_from_format('j/m/Y', $file->nacimiento), 'Y-m-d'), 'type_id' => 3]);
}
});
} catch (\Illuminate\Database\QueryException $e) {
Session::flash('error_BD', true);
return Redirect::to("config/usuarios");
} catch (\Exception $e) {
Session::flash('error_syntax', true);
return Redirect::to("config/usuarios");
}
\Storage::disk('public')->delete('file.csv');
Session::flash('message', 'La exportación de los datos se ha realizado de forma satisfactoria');
return Redirect::to("config/usuarios");
}
