/**
* 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);
}
