/** * 获取账户列表. * * @param int $pageSize 分页大小 * * @return \Illuminate\Pagination\Paginator */ public function lists($filter, $sorter, $page, $pageSize) { // $user = DB::table('users'); // /* // * 构建过滤条件 // */ // if (is_array($filter) && count($filter) > 0) { // // foreach ( $filter as $key => $value ) { // // //用户名 // if (strcasecmp($key, 'username') == 0 ) { // $user->where('username', 'LIKE', "%{$value}%"); // } // // } // } // // //构建排序条件 // if (is_array($sorter) && count($sorter) > 0) { // foreach ($sorter as $key => $value) { // //ID排序 // if (strcasecmp($key, 'ID') == 0) { // $sort = $value ? 'asc' : 'desc'; // $user->orderBy('id', $sort); // } // } // } return $this->model->orderBy('id', 'desc')->paginate($pageSize); }
public function index() { if (Auth::user()->admin) { $users = User::orderBy('name')->get(); return view('admin.users', ['users' => $users]); } }
public function postIndex(Request $request) { // first retrieve the user list $users = \App\User::orderBy('last_name')->orderBy('first_name')->get(); // now filter the collection as needed based on user input //first filter on name / email if user entered a string $umatch = strtolower($request->input('user')); if (isset($umatch) && $umatch != '') { $filtered = $users->filter(function ($item) use($umatch) { return is_int(strpos(strtolower($item->last_name), $umatch)) || is_int(strpos(strtolower($item->email), $umatch)); }); $users = $filtered; } // now filter by category $role = $request->input('role'); if (isset($role) && $role != '') { $filtered = $users->filter(function ($item) use($role) { return $item->role == $role; }); $users = $filtered; } // now return the view with the filtered list $request->session()->put('users', $users); $ucol = $request->session()->get('ucol'); return view('users', ['sortOrder' => $ucol], ['users' => $users]); }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { $web = Web::find($id); $users = User::orderBy('nombre')->lists('nombre', 'id'); $categorias = Category::orderBy('nombre')->lists('nombre', 'id'); return view('admin.web.edit', compact('web', 'users', 'categorias')); }
public function index() { $user = \Auth::user(); $time = $this->formatDate(); $action = 'home'; $r = Signin::where('user_id', \Auth::user()->id)->first(); $count = 0; $signined = false; if ($r) { $count = $r['count']; if (substr(Carbon::now(), 0, 10) == substr($r['last_signin'], 0, 10)) { $signined = true; } } $signinList = Signin::where('last_signin', 'like', substr(Carbon::now(), 0, 10) . '%')->orderBy('last_signin', 'desc')->get(); foreach ($signinList as &$item) { $item['last_signin'] = substr($item['last_signin'], 11, 8); } $cates = Cate::orderBy('count', 'desc')->limit(6)->get(); $authors = User::orderBy('score', 'desc')->limit(6)->get(); $teams = Team::limit(3)->get(); $recommendedArticles = Article::orderBy('recommend', 'deac')->limit(4)->get(); $phpArticles = Article::where('cate_id', 1)->limit(5)->get(); $todayHotArticles = Article::where('published_at', '>=', Carbon::now()->subDay(1))->where('published_at', '<=', Carbon::now())->orderBy('view', 'deac')->limit(6)->get(); $weekHotArticles = Article::where('published_at', '>=', Carbon::now()->subDay(7))->where('published_at', '<=', Carbon::now())->orderBy('view', 'deac')->limit(6)->get(); return view('home', compact('user', 'time', 'action', 'signin', 'minus', 'count', 'signined', 'signinList', 'cates', 'authors', 'teams', 'recommendedArticles', 'phpArticles', 'todayHotArticles', 'weekHotArticles')); }
/** * Create a new user instance after a valid registration. * * @param array $data * @return User */ protected function create(array $data) { $new_id = User::all()->count() > 0 ? User::orderBy('id', 'desc')->first()->id + 1 : 2400; DB::connection('member')->table('tb_user')->insert(['mid' => $data['name'], 'password' => $data['password'], 'pwd' => Hash::make($data['password']), 'idnum' => $new_id]); DB::connection('account')->table('accounts')->insert(['id' => $new_id, 'username' => $data['name'], 'password' => $data['password']]); return User::create(['id' => $new_id, 'username' => $data['name'], 'password' => Hash::make($data['password']), 'role' => 'member']); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { if (!\Auth::getUser()->is_admin) { return redirect(route('profile')); } return view('user/index')->with(['list' => \App\User::orderBy('is_active', 'ASC')->orderBy('is_admin', 'DESC')->orderBy('name', 'ASC')->paginate(20), 'page_title' => 'Пользователи']); }
public function getTeam(Request $request) { if ($request->ajax() || $request->wantsJson) { return User::orderBy('lastname')->orderBy('firstname')->get(['firstname', 'lastname', 'email', 'id']); } abort(404); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // $title = "Staff"; $data = User::orderBy('id', 'desc')->get(); return view('html.staff.list', compact('data', 'title')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $users = User::orderBy('id', 'ASC')->paginate(10); return view('admin.users.index')->with('users', $users); /*$users = User::orderBy('id', 'ASC')->paginate(5); return view('admin.users.index')->with('users', $users);*/ }
/** * Show the form for creating a new Cruiseline. * * @return View */ public function edit($id) { $article = Article::find($id); $tags = Tag::lists('name', 'id'); $users = User::orderBy('name', 'ASC')->lists('name', 'id'); return view('articles.edit', compact('article', 'tags', 'users')); }
public function users() { $users = User::orderBy('level_id', 'asc')->get(); $level = Level::lists('name', 'id'); $ppk = Ppk::lists('name', 'id'); return View('admin.preset.users', compact('users', 'level', 'ppk')); }
public function destroy($id) { $user = User::find($id); $user->delete(); Flash::warning('El usuario ' . $user->name . ' ha sido eliminado de forma exitosa'); $users = User::orderBy('id', 'ASC')->paginate(10); return view('admin.users.index')->with('users', $users); }
public static function htmlSelectAll() { $res = []; foreach (User::orderBy('name')->get() as $u) { $res[$u->id] = $u->name . ' (' . $u->email . ')'; } return $res; }
public function index() { if (!\Auth::user()->admin()) { return redirect()->route('agenda.index'); } $users = User::orderBy('type', 'DESC')->orderBy('name', 'ASC')->get(); return view('admin.users.index')->with('users', $users); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { /* $users = User::all(); $listings = Listing::all();*/ $users = User::orderBy('created_at', 'desc')->limit(10)->get(); $listings = Listing::orderBy('created_at', 'desc')->limit(10)->get(); return view('admin.page.index', compact('users', 'listings')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // $users = User::orderBy('created_at', 'asc')->get(); $templates = Template::orderBy('created_at', 'asc')->get(); $i = 0; return view('admin.index', ['users' => $users, 'templates' => $templates, 'i' => $i]); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $user = Auth::user(); $user_name = $user->name; $bank = Bank::where('name', '=', $user_name)->first(); $users = User::orderBy('money', 'desc')->take(5)->get(); return view('bank.bank', compact('user', 'user_name', 'bank', 'users')); }
/** * Display a listing of the resource. *@param Request $request * @return Response */ public function getIndex(Request $request) { $mod = User::orderBy('created_at', 'desc'); $this->userSearch($mod, $request); $users = $mod->paginate(15); $this->assign('users', $users); return $this->display('admin.user.index'); }
public function lastUpdated() { $query = User::orderBy('updated_at', 'DESC')->first(); if ($query) { return $query->updated_at->format('Y-m-d H:i:s'); } return date("Y-m-d H:i:s"); }
public function getUsersWithPaginate(Request $request) { $perPage = $request->get('num'); if (!is_numeric($perPage) || $perPage < 1 || $perPage > 30) { $perPage = 15; } $users = User::orderBy('id', 'desc')->paginate($perPage); return $this->buildResponse(trans('api.user.paginate.success'), Tools::toArray($users)); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(City $city) { $users = User::orderBy('name_first', 'asc')->where('city_id', '=', $city->id)->get(); foreach ($users as $user) { $user->user_events_count = Event::futureEventsByCityId($city->id)->where('user_id', '=', $user->id)->count(); } $users->sortBy('user_events_count'); return view('users.index', compact('users')); }
public function getSuggestions(Request $request) { $username = $request->username; try { //$user1ID = User::where('username', $username)->get(); //return response()->json(['status' => 200, 'suggestions' => $user1ID], 200); $userId = User::where('username', $username)->get(['id'])[0]->id; $userPreferences = self::userPreferences($userId); $orientation = User::where('username', $username)->get()[0]->orientation; $gender = User::where('username', $username)->get()[0]->gender; $location = $userPreferences[0]->location; $minage = $userPreferences[0]->mixage; $maxage = $userPreferences[0]->maxage; $status = $userPreferences[0]->status; $shortterm = $userPreferences[0]->shortterm; $longterm = $userPreferences[0]->longtterm; $causalsex = $userPreferences[0]->casualsex; //$result = User::orderBy(\DB::raw('RAND()'))->limit(3)->get(); $users = User::orderBy(\DB::raw('RAND()'))->limit(3)->get(); $suggestedUsers = []; foreach ($users as $user) { //changed id /// $id = 1; $takenUserPreferences = self::userPreferences($id); $usernameT = User::where('id', $id)->get()[0]->username; $orientationT = User::where('id', $id)->get()[0]->orientation; $genderT = User::where('id', $id)->get()[0]->gender; if ($orientation == $orientationT && $gender == $genderT && $username == $usernameT) { break; } $locationT = $takenUserPreferences[0]->location; $minageT = $takenUserPreferences[0]->mixage; $maxageT = $takenUserPreferences[0]->maxage; $statusT = $takenUserPreferences[0]->status; $shorttermT = $takenUserPreferences[0]->shortterm; $longtermT = $takenUserPreferences[0]->longterm; $causalsexT = $takenUserPreferences[0]->casualsex; $locationMatch = self::matchLocation($userId, $id, $location, $locationT); $ageMatch = self::matchAge($minage, $maxage, $minageT, $maxageT); $statusMatch = self::matchStatus($status, $statusT); $shortTermMatch = self::matchLongTermRel($shortterm, $shorttermT); $longTermMatch = self::matchShortTermRel($longterm, $longtermT); $casualSexMatch = self::matchCasualSex($causalsex, $causalsexT); $matchPercentage = self::calculateMatchPercentage($locationMatch, $ageMatch, $statusMatch, $longTermMatch, $shortTermMatch, $casualSexMatch); if ($matchPercentage >= 0.45) { array_push($suggestedUsers, $user); } } if ($suggestedUsers) { return response()->json(['status' => 200, 'suggestions' => $suggestedUsers], 200); } else { return response()->json(['status' => 200, 'suggestions' => null], 200); } } catch (Illuminate\Database\QueryException $e) { return response()->json(['status' => 200], 200); } }
/** * Display a listing of the resource. * * @return Response */ public function index(Request $request) { if (Request::isMethod('get')) { $users = User::orderBy('id', 'desc')->paginate(50); return view('admin.users.list', array('users' => $users)); } $idUser = Request::input('data'); User::destroy($idUser); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $multas = Multa::orderBy('descripcion', 'ASC')->lists('descripcion', 'id'); $usuarios = User::orderBy('nombre', 'ASC')->lists('nombre', 'id'); $estados = Estado::orderBy('descripcion', 'ASC')->lists('descripcion', 'id'); $libros = Libro::orderBy('nombre', 'ASC')->lists('nombre', 'id'); $prestamo = Prestamo::find($id); return view('admin.prestamos.edit')->with('multas', $multas)->with('usuarios', $usuarios)->with('estados', $estados)->with('libros', $libros)->with('prestamo', $prestamo); }
public function index() { if (Gate::denies('user-list')) { abort(403); } $usuarios = User::orderBy('name', 'asc')->get(); return $usuarios; //return User::all(); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // mirar aquí: http://laravel.com/docs/5.1/pagination $users = User::orderBy('id', 'ASC')->paginate(5); // para pasar datos a una vista, 2 formas: //return view('admin.users.index', $users); return view('admin.users.index')->with('users', $users); // esta sería la opción recomendada. }
public function listagem() { /** * Usando a Trait PageHeaderTrait, retorna o nome do Título da Pagina e sua descrição no topo da mesma */ $headerInfo = $this->headerPageName(Route::currentRouteName()); $usuarios = User::orderBy('name', 'asc')->get(); return view('usuarios.listagem', compact('usuarios', 'headerInfo')); }
public static function usersForDropdown() { $users = \App\User::orderBy('name', 'ASC')->get(); $users_for_dropdown = []; foreach ($users as $user) { $users_for_dropdown[$user->id] = $user->name; } return $users_for_dropdown; }
public function rank($useId) { $users = User::orderBy('score', 'desc')->get(); foreach ($users as $key => $user) { if ($user->id == $useId) { return $key + 1; } } }