/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { if (Auth::guest()) { return Redirect::route('/'); } else { $users = array(); $usuarios = \Ermtool\User::all(); $i = 0; foreach ($usuarios as $user) { //obtenemos roles $roles = array(); $roles1 = DB::table('system_role_user')->join('system_roles', 'system_roles.id', '=', 'system_role_user.system_role_id')->where('system_role_user.user_id', '=', $user->id)->select('system_roles.role')->get(); $j = 0; foreach ($roles1 as $rol) { $roles[$j] = $rol->role; $j += 1; } $created_at = new DateTime($user->created_at); $created_at = date_format($created_at, 'd-m-Y'); $users[$i] = ['id' => $user->id, 'dv' => $user->dv, 'name' => $user->name, 'surnames' => $user->surnames, 'email' => $user->email, 'created_at' => $created_at, 'roles' => $roles]; $i += 1; } if (Session::get('languaje') == 'en') { return view('en.usuarios.index', ['users' => $users]); } else { return view('usuarios.index', ['users' => $users]); } } }