protected function importUsers()
 {
     $users = DB::connection('oldissue')->select('select * from users');
     foreach ($users as $user) {
         $newUser = new User();
         $newUser->id = $user->id;
         $newUser->name = $user->name;
         $newUser->email = $user->email;
         $newUser->password = $user->password;
         if ($user->banned === 'N' && $user->active === 'Y') {
             $newUser->active = true;
         } else {
             $newUser->active = false;
         }
         if ($user->profilesId === '1') {
             $newUser->type = 'admin';
         } elseif ($user->profilesId === '2') {
             $newUser->type = 'editor';
         } elseif ($user->profilesId === '4') {
             $newUser->type = 'client';
         }
         $newUser->save();
     }
     return print_r('Au fost importati: ' . User::count() . ' useri.' . "\n");
 }
 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @return \Illuminate\Http\Response
  */
 public function store(UserRequest $request)
 {
     if (Gate::denies('store-users')) {
         abort(403);
     }
     $user = new User();
     $password = str_random(10);
     $user->fill($request->all());
     $user->password = Hash::make($password);
     $user->save();
     $user->syncSubscription($request->input('subscription'));
     $this->endDateGtStartDate($request, $user->subscription);
     $this->sendNewUserEmail($user, $password);
     return $user;
 }