/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // Busca no banco de dados os todos users, ordenados pelo nome e cria paginação $users = User::orderBy('name')->paginate(10); // Retorna a view com os users return view('users.index', compact('users')); }
public function edit(Request $request, $id) { $users = User::orderBy('created_at', 'DESC')->paginate(7); $page_title = 'Edit User'; $user = User::findOrFail($id); return view('admin.users.edit', compact('users', 'user', 'page_title')); }
/** * Display a listing of the User. * GET|HEAD /users * * @return Response */ public function index(Request $request) { $offset = $request->page ? $request->page : 1; $limit = $request->limit ? $request->limit : 12; $offset = ($offset - 1) * $limit; $posts = User::orderBy('id', 'desc')->offset($offset)->limit($limit)->get(); return response()->json($posts); }
public function getUsers($user_id = null) { if ($user_id) { return view('admin.stat.user_details', ['orders' => Order::where('user_id', $user_id)->paginate(15), 'user' => User::find($user_id)->first()]); } else { return view('admin.stat.users', ['users' => User::orderBy('email')->paginate(15)]); } }
/** * Shows the details page of a meal */ public function show($id) { $meal = Meal::find($id); if (!$meal) { App::abort(404, "Maaltijd niet gevonden"); } return $this->setPageContent(view('meal/show', ['meal' => $meal, 'users' => User::orderBy('name')->get()])); }
public function getUsers(Request $request) { if (Session::has('Admin')) { $users = User::orderBy('id', 'desc')->paginate(20); return view('admin.user', ['users' => $users]); } else { return redirect("admin"); } }
public function index() { $users = User::orderBy('created_at', 'DESC')->paginate(5); $majors = Major::orderBy('created_at', 'DESC')->paginate(5); $subjects = Subject::orderBy('created_at', 'DESC')->paginate(5); $classrooms = Classroom::orderBy('created_at', 'DESC')->paginate(5); $announcements = Announcement::orderBy('created_at', 'DESC')->paginate(5); return view('admin.home.home', compact('users', 'majors', 'subjects', 'classrooms', 'announcements')); }
public function run() { $faker = Faker\Factory::create(); DB::table('favorites')->truncate(); foreach (range(1, 30) as $index) { $ads = Advertisement::orderBy(DB::raw('RAND()'))->first(); User::orderBy(DB::raw('RAND()'))->first()->favorites()->attach($ads->id); } }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $users = User::orderBy('seen', 'asc')->orderBy('created_at', 'desc')->paginate($this->itemPerPage); $roles = Role::all(); $counts['total'] = User::count(); foreach ($roles as $role) { $slug = $role->slug; $counts[$slug] = User::whereHas('role', function ($q) use($slug) { $q->whereSlug($slug); })->count(); } return view('admin.users.index', compact('users', 'roles', 'counts')); }
/** * @param array $options * @return mixed */ public function getUsers(array $options) { // set input options $this->setOptions($options); // filtration users if ($this->type !== 'all') { // if needs online users if ($this->type == 'online') { $this->user->where('status', '=', true); } else { $this->user->where('status', '=', false); } } // sorted users if ($this->sort) { if (isset($this->sort['date'])) { // sort by date added $this->user->orderBy('created_at', $this->sort['date']); } // sort by username if (isset($this->sort['username'])) { $this->user->orderBy('username', $this->sort['username']); } // sort by email if (isset($this->sort['email'])) { $this->user->orderBy('email', $this->sort['email']); } } // set offset if ($this->offset > 0) { $this->user->skip($this->offset); } // get users collection with fields $users = $this->user->take($this->limit)->get($this->fields); // return collection return $users; }
public function index() { $search['text'] = Input::get('search_text'); $search['type'] = Input::get('search_type'); if ($search['type'] == 'user') { $list = User::User($search['text'])->orderBy('id', 'desc')->paginate(15); } else { if ($search['type'] == 'email') { $list = User::Email($search['text'])->orderBy('id', 'desc')->paginate(15); } else { $list = User::orderBy('id', 'desc')->paginate(15); } } return View::make('admin.user_list')->withlist($list)->withsearch($search); }
/** * @param Request $request * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View */ public function index(Request $request) { $users = User::orderBy('id', 'desc'); if ($request->input('id')) { $users = $users->where('id', '=', $request->input('id')); } if ($request->input('email')) { $users = $users->where('email', 'LIKE', '%' . $request->input('email') . '%'); } if ($request->input('user_name')) { $users = $users->where('name', 'LIKE', '%' . $request->input('user_name') . '%'); } $users = $users->paginate(10); return view('admin.user.index', ['users' => $users, 'f_id' => $request->input('id'), 'f_email' => $request->input('email'), 'f_user_name' => $request->input('user_name')]); }
public function showList() { $user = new User(); $all = $user->orderBy('created_at')->get()->toArray(); $age_categories = $user->age_categories; $belts = $user->belt_colours; $weights = $user->weights; usort($all, function ($a, $b) { $belt_order = array('white', 'blue', 'purple', 'brown', 'black'); $i1 = array_search($a['belt'], $belt_order); $i2 = array_search($b['belt'], $belt_order); return $i1 < $i2 ? -1 : 1; }); $data['all'] = $all; return view('userlist')->with('data', $data); }
public function indexAjax(Request $r) { // Para saber que variables llegan por parte // del control DataTable ver: // https://datatables.net/manual/server-side $limit = $r->input('length', 10); $page = $r->input('start') / $limit + 1; $column = $r->input('order')[0]['column']; $column = $r->input('columns')[$column]['data']; $direction = $r->input('order')[0]['dir']; $pattern = $r->input('search')['value']; // select * // from users // where email like '%algunapatron%' // order by [columna] asc|desc $users = User::orderBy($column, $direction)->where('email', 'like', "%{$pattern}%")->paginate($limit, ['*'], 'start', $page); $result = ['draw' => $r->input('draw'), 'recordsTotal' => $users->total(), 'recordsFiltered' => $users->total(), 'data' => $users->all()]; return response()->json($result); }
public function index() { $name = Input::get('name', ''); $email = Input::get('email', ''); $onlyActive = Input::get('only_active', ''); $perPage = Input::get('per_page', 50); $users = User::orderBy('created_at'); $users->whereRole('user'); if ($name) { $users->where('name', 'like', '%' . $name . '%'); } if ($email) { $users->where('email', 'like', '%' . $email . '%'); } if ($onlyActive) { $users->where('is_active', 1); } $users = $users->with('profile')->paginate($perPage); return view('admin.pages.user.index', compact('users', 'onlyActive', 'name', 'email')); }
public static function addOrModify($data, $id = null) { $user = new User(); if ($id != null) { $user = User::find($id); } $user->nama = $data['nama']; $user->username = $data['username']; $user->email = $data['username']; $user->password = bcrypt($data['password']); $user->role_id = 2; $user->save(); $d = parent::addOrModify($data, $id); $d->id = User::orderBy('id', 'desc')->first()->id; $d->nip = $data['nip']; $d->instansi_id = $data['instansi_id']; $d->nuptk = $data['nuptk']; $d->alamat = $data['alamat']; $d->no_telp = $data['no_telp']; $d->save(); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { // show only active users // TODO: this currently produces duplicates... if ($request->has('active')) { $user1 = Role::find(4)->users()->get(); $users = Role::find(5)->users()->get(); foreach ($user1 as $value) { $users->prepend($value); } $heading = 'Show Active Users'; return view($this->view_all, ['users' => $users, 'heading' => $heading, 'roles' => Role::get(), 'instruments' => Instrument::get()]); } // get all users in the requested order (default by id) $users = User::orderBy(isset($request->orderby) ? $request->orderby : 'id', isset($request->order) ? $request->order : 'asc'); $heading = 'User Management'; // check if user selected a filter if ($request->has('filterby') && $request->has('filtervalue') && $request->filtervalue != 'all') { if ($request->filterby == 'role') { // get all -- USERS -- with this specific role id $role = Role::find($request->filtervalue); $users = $role->users(); $heading = 'User Management - Show ' . ucfirst($role->name) . 's'; } else { if ($request->filterby == 'instrument') { // get all -- USERS -- with this specific instrument id $instrument = Instrument::find($request->filtervalue); $users = $instrument->users(); $heading = 'User Management - Show users playing ' . ucfirst($instrument->name); } else { $users = $users->where($request->filterby, $request->filtervalue); } } } return view($this->view_all, ['users' => $users->get(), 'heading' => $heading, 'roles' => Role::get(), 'instruments' => Instrument::get()]); }
/** * Show the leaderboard * * @return Response */ public function getIndex() { $Users = User::orderBy('count_followers', 'DESC')->get(); return \View::make("home")->with("Users", $Users); }
public static function getLastPort() { $user = User::orderBy('port', 'desc')->first(); if ($user == null) { return 1024; // @todo } return $user->port; }
/** * PLAN DETAILS form * * @param int $id * @param int $new_item_id indicates a newly inserted item * @return \Illuminate\Http\Response */ public function edit($id) { // find a single plan by ID $plan = Plan::with(['items' => function ($query) { $query->withTrashed()->orderBy('seq_no'); }])->find($id); if ($plan) { // get list of service types $types = Type::get(); // get list of users $users = User::orderBy('first_name')->get(); // get list of trashed items (if any) $trashedItemsCount = Item::onlyTrashed()->where('plan_id', $id)->count(); // check if a new item was just now inserted (used for highlighing in the view) $newest_item_id = 0; if (session()->has('newest_item_id')) { $newest_item_id = session()->get('newest_item_id'); session()->forget('newest_item_id'); } // get service times from plan dates $plan->start = Carbon::instance($plan->date)->toTimeString(); // for backwards compatibility, we allowed for null as end date if ($plan->date_end) { $plan->end = Carbon::instance($plan->date_end)->toTimeString(); } else { $plan->end = "23:59"; } return view($this->view_one, array('plan' => $plan, 'types' => $types, 'users' => $users, 'versionsEnum' => json_decode(env('BIBLE_VERSIONS')), 'newest_item_id' => $newest_item_id, 'trashedItemsCount' => $trashedItemsCount)); } flashError('Plan with id "' . $id . '" not found'); return \Redirect::route($this->view_idx); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { return view('admin.users.list', ['users' => User::orderBy('id', 'desc')->paginate(20)]); }
/** * @param string $per_page * @param string $order_by * @param string $sort * @return mixed * @internal param $ */ public function getAllUsers($per_page, $order_by = 'id', $sort = 'asc') { return User::orderBy($order_by, $sort)->paginate($per_page); }
public function getIndex() { return view('admin.users.index', ['users' => User::orderBy('created_at', 'desc')->paginate(10)]); }
public function users() { $users = User::orderBy('created_at', 'desc')->whereDoesntHave('roles', function ($query) { $query->where('id', 1); })->get(); return view('admin.users')->with('users', $users); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { // find a single resource by ID $type = Type::find($id); if ($type) { // get the resources table $resources = Resource::get(); // also get the users table $users = User::orderBy('first_name')->get(); // return the view with all the data return view('admin.type', ['type' => $type, 'users' => $users, 'resources' => $resources]); } // $message = 'Error! Type with id "' . $id . '" not found'; return \Redirect::route('types.index')->with(['status' => $message]); }
public function index() { $users = User::orderBy('created_at')->paginate(config('wyshop.page_size')); return view('admin.user.index', ['users' => $users]); }
/** * @param string $order_by * @param string $sort * @return mixed */ public function getAllUsers($order_by = 'id', $sort = 'asc') { return User::orderBy($order_by, $sort)->get(); }
/** * 排名 * @return [type] [description] */ public function getTop() { $users = User::orderBy('score', 'desc')->whereNotNull('score')->with('openid')->take(10)->get(); return $users; }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $users = User::orderBy('name')->paginate(20); return view('users.index', compact('users')); }
public function search() { $keyword = Input::get('keyword'); $filter = Input::get('filter'); $result = User::orderBy('created_at', 'asc'); if ($keyword != NULL) { if ($filter == "kode" || $filter == NULL) { $result = $result->where('id', '=', $keyword); } else { if ($filter == "nama") { $result = $result->where('display_name', 'LIKE', '%' . $keyword . '%'); } else { if ($filter == "email") { $result = $result->where('email', 'LIKE', '%' . $keyword . '%'); } else { if ($filter == "username") { $result = $result->where('username', 'LIKE', '%' . $keyword . '%'); } else { if ($filter == "level") { $result = $result->where('level', '=', $keyword); } } } } } } $data = ['title' => '', 'page_title' => 'User', 'panel_title' => 'Search View', 'location' => 'search', 'table' => $result->paginate(6)]; return View::make('user.view', $data); }