public function getMethod(Request $request, Builder $htmlBuilder) { if ($request->ajax()) { return Datatables::of(User::select(['id', 'name', 'email', 'created_at', 'updated_at']))->make(true); } $html = $htmlBuilder->addColumn(['data' => 'id', 'name' => 'id', 'title' => 'Id'])->addColumn(['data' => 'name', 'name' => 'name', 'title' => 'Name'])->addColumn(['data' => 'email', 'name' => 'email', 'title' => 'Email'])->addColumn(['data' => 'created_at', 'name' => 'created_at', 'title' => 'Created At'])->addColumn(['data' => 'updated_at', 'name' => 'updated_at', 'title' => 'Updated At']); return view('datatables.html.method', compact('html')); }
public function data() { $users = User::select(['id', 'first_name', 'last_name', 'email']); return Datatables::of($users)->add_column('actions', '<a href="{{ route(\'admin.users.show\', $id) }}"><i class="livicon" data-name="info" data-size="18" data-loop="true" data-c="#428BCA" data-hc="#428BCA" title="view user"></i></a> <a href="{{ route(\'admin.users.edit\', $id) }}"><i class="livicon" data-name="edit" data-size="18" data-loop="true" data-c="#428BCA" data-hc="#428BCA" title="update user"></i></a> ')->make(true); }
/** * Display a listing of the resource. * Display every conversation/topics with the first Thread related * @return Response */ public function index(Request $request) { $Threads = array(); $Result = array(); $count = 0; $admin = Role::select('id')->where('description', '=', 'admin')->firstorFail(); // if we are admin we want to see everything if (\Auth::id() == $admin->id) { $Conversations = User::select('*')->join('conversations', 'conversations.user_id', '=', 'users.id')->get(); } else { // we are not admin but we want to see published messages and the status of our posted messages if (\Auth::guest()) { $Conversations = User::select('*')->join('conversations', 'conversations.user_id', '=', 'users.id')->where('conversations.Pending', '=', 0)->get(); } else { $Conversations = User::select('*')->join('conversations', 'conversations.user_id', '=', 'users.id')->where('conversations.Pending', '=', 0)->orwhere('conversations.user_id', '=', \Auth::id())->get(); } } // we recover the first Thread according to the conversations which passed the previous tests foreach ($Conversations as $Conversation) { $Threads[$count] = Thread::where('conversation_id', '=', $Conversation->id)->firstOrFail(); $Result[$count] = array($Conversation, $Threads[$count]); $count++; } return view('dashboard')->with(['dashboard' => $Result, 'adminID' => $admin]); }
/** * Поиск пользователя * @param Request $request * @return array */ public function show(Request $request) { $s = $request->get('s'); return ['results' => User::select('name', 'id')->where('id', '!=', $this->user->id)->where(function ($q) use($s) { $q->where('name', 'LIKE', "%{$s}%")->orWhere('id', 'LIKE', "%{$s}%"); })->get()]; }
/** * @param Request $request * @param $id * @return \Illuminate\Http\JsonResponse */ public function update(Request $request, $id) { $user_id = $request->input('user_id'); $user = User::find($user_id); $change = User::find($id); if ($user && $user->access < 5) { return response()->json(['notPermission' => true, 'message' => $user->first_name . ' não possui permissão!']); } if ($request->has('access') && $user->access < $request->input('access')) { return response()->json(['notPermission' => true, 'message' => 'Você não possui acesso para dar uma permissão maior que a sua!']); } if ($user->access < $change->access) { return response()->json(['notPermission' => true, 'message' => 'Você não possui acesso para dar uma permissão maior que a sua!']); } $change->username = $request->has('username') ? $request->input('username') : $change->username; $change->email = $request->has('email') ? $request->input('email') : $change->email; $change->first_name = $request->has('first_name') ? $request->input('first_name') : $change->first_name; $change->last_name = $request->has('last_name') ? $request->input('last_name') : $change->last_name; $change->role = $request->has('role') ? $request->input('role') : $change->role; $change->access = $request->has('access') ? $request->input('access') : $change->access; if ($change->save()) { return User::select('users.id', 'users.username', 'users.email', 'users.first_name', 'users.last_name', 'users.role', 'users.access', 'permissions.permission', 'users.created_at')->join('permissions', 'users.access', '=', 'permissions.id')->where('users.id', $id)->first(); } else { return response()->json(['error' => true, 'message' => 'Ocorreu um error inexperado!']); } }
public function index() { $professores = User::select('users.id', 'users.name')->where('tipo_usuario', '=', 1)->get(); $turmas = Turma::all(); // Show the page return view('admin.professorturmas.index', compact('professores', 'turmas')); }
public function getProfile() { $users = \App\User::select('id', 'name')->where('id', '!=', \Auth::user()->id)->get(); $resHours = count(\App\ReservedHours::where('user_id', \Auth::user()->id)->get()); $finHours = count(\App\FinishedHour::where('user_id', \Auth::user()->id)->get()); return view('users.index', ['users' => $users, 'resHours' => $resHours, 'finHours' => $finHours]); }
public function ListaCoach() { $users = User::select('users.id', 'roles.display_name', 'users.name', 'users.last_name', 'users.email')->join('role_user', 'users.id', '=', 'role_user.user_id')->join('roles', 'roles.id', '=', 'role_user.role_id')->whereIn('roles.id', array(2, 5)); // coach $filter = DataFilter::source($users); $filter->attributes(array('class' => 'form-inline')); //$filter->add('user_id','Buscar por ID', 'text'); $filter->add('user.name', 'Buscar por Nombre', 'text'); $filter->add('email', 'Buscar por Email', 'text'); $filter->add('created_at', 'Fecha de Ingreso', 'daterange')->format('d/m/Y', 'es'); $filter->add('cuenta_activa', 'Usuarios Activos', 'select')->options(array('1' => 'Activos', '0' => 'Inactivos')); $filter->submit('Buscar'); $filter->reset('Limpiar'); $grid = DataGrid::source($filter); $grid->attributes(array("class" => "table table-hover")); $grid->add('id', 'ID', true); $grid->add('display_name', 'Rol', true); $grid->add('name', 'Nombre', true); $grid->add('last_name', 'Apellido', true); $grid->add('email', 'Email', true); $grid->add('{!! ("<a href=# data-id=$id class=reset_pass >Reset</a>") !!}', 'Resetear Contraseña'); $grid->edit(url('/') . '/coach/edit', 'Editar/Borrar', 'modify|delete'); $grid->link('/coach/create', 'Crear Coach', 'TR'); //$grid->orderBy('role.id','desc'); $grid->paginate(10); return view('coach.lista', compact('filter', 'grid')); }
public function index() { $alunos = User::select('users.id', 'users.name')->where('tipo_usuario', '=', 0)->get(); $turmas = Turma::select('turmas.id', 'turmas.nome')->get(); // Show the page return view('admin.alunosturmas.index', compact('alunos', 'turmas')); }
/** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { if ($this->auth->guest()) { if ($request->ajax()) { return response('Unauthorized.', 401); } else { return redirect()->guest('auth/login'); } } elseif (session('role_id') == 3) { $route = $request->route(); $routeName = $route->getName(); if ($routeName == 'activity.show') { $activityId = $route->getParameter('activity'); $orgId = Activity::select('organization_id')->find($activityId)->organization_id; } elseif ($routeName == 'organization.show') { $orgId = $route->getParameter('organization'); } else { $orgId = session('org_id'); } if ($orgId && $this->auth->user()->isSuperAdmin()) { $userId = User::select('id')->where('org_id', $orgId)->where('role_id', 1)->first()->id; app(OrganizationController::class)->masqueradeOrganization($orgId, $userId); } elseif (!$orgId && !isSuperAdminRoute()) { return redirect(config('app.super_admin_dashboard')); } } elseif (isSuperAdminRoute()) { $response = ['type' => 'warning', 'code' => ['message', ['message' => "You don't have correct privilege"]]]; return redirect(config('app.admin_dashboard'))->withResponse($response); } return $next($request); }
public function users() { $term = Input::get('term'); $m = User::select('id', 'name')->where('name', 'LIKE', '%' . $term . '%')->orWhere('identification', 'LIKE', '%' . $term . '%')->orWhere('email', 'LIKE', '%' . $term . '%'); $query = $this->paginateQuery($m); return $query; }
public function getSortableUsers($sort = 'name', $direction = 'asc') { if (!in_array($sort, ['name', 'created_at'])) { $sort = 'name'; } return User::select('users.id', 'users.name', 'users.created_at')->orderBy($sort, $direction)->paginate(10); }
public function getGrid() { $users = User::select(['id', 'name', 'email', 'role', 'created_at', 'updated_at']); return Datatables::of($users)->addColumn('action', function ($user) { return '<a href="/admin/users/edit/' . $user->id . '" class="btn btn-xs btn-primary"><i class="glyphicon glyphicon-edit"></i> Edit</a> <a href="/admin/users/delete/' . $user->id . '" class="btn btn-xs btn-primary delete-button"><i class="glyphicon glyphicon-remove"></i> Delete</a>'; })->make(true); }
/** * Display a listing of the resource. * * @param Request $request * @return Datatables */ public function index(Request $request) { $users = User::select(['id', 'photo', 'first_name', 'last_name', 'is_active', 'created_at']); // super admin visibility if (config('laravel-user-module.non_visibility.super_admin') && !Sentinel::getUser()->is_super_admin) { $users->where('is_super_admin', false); } // if is filter action if ($request->has('action') && $request->input('action') === 'filter') { $users->filter($request); } $addColumns = ['addUrls' => $this->urls, 'status' => function ($model) { return $model->is_active; }, 'fullname' => function ($model) { return $model->fullname; }]; $editColumns = ['photo' => function ($model) { $photoKey = array_keys(config('laravel-user-module.user.uploads.photo.thumbnails')); return $model->getPhoto([], $photoKey[0], true); }, 'created_at' => function ($model) { return $model->created_at_table; }]; $removeColumns = ['is_active', 'first_name', 'last_name']; return $this->getDatatables($users, $addColumns, $editColumns, $removeColumns); }
public function enviar_email(\Illuminate\Http\Request $request) { $input = $request->except(array('_token')); //não levar o token $buscar = \App\Models\pessoas::select('razaosocial', 'empresas_id', 'empresas_clientes_cloud_id')->where('emailprincipal', $input["email"])->get(); if ($buscar->count() > 0) { $usuario = User::select('id')->where('email', $input["email"])->where('password', bcrypt($input["password"]))->get(); if ($usuario->count() > 0) { return redirect()->guest('login'); } else { //criar usuario //Gera token qualquer $dados = str_random(30); $data = $input; $retorno = User::create(['name' => $buscar[0]->razaosocial, 'email' => $input["email"], 'password' => bcrypt($input["password"]), 'confirmation_code' => $dados]); usuario::create(['id' => $retorno->id, 'empresas_id' => $buscar[0]->razaosocial, 'empresas_clientes_cloud_id' => $input["email"]]); \Mail::send('emails.link_newuser', ['key' => $dados], function ($message) use($data) { $message->from('*****@*****.**', 'Sigma3'); $message->subject('Link para validação SIGMA3 - Área do Membro'); $message->to($data['email']); $message->bcc('*****@*****.**'); }); $conteudo = ['mensagem' => 'Verifique sua conta de email para validar o acesso ao sistema.']; } } else { $credentials = array('email' => $input["email"], 'password' => $input["password"]); if (Auth::attempt($credentials, true)) { Auth::login(Auth::user(), true); Auth::guard('web')->login($credentials); //return redirect('login'); return \Redirect::intended('login'); } } //return view('tutoriais.minhaigreja', ['conteudo'=>$conteudo]); }
public function index() { $usuarios = User::select('*')->orderBy('father_last_name')->get(); $trabajos = Trabajo::join('users as u1', 'u1.id', '=', 'user_id')->join('users as t', 't.id', '=', 'tutor_id')->join('LineaInvestigacion as l', 'l.id', '=', 'linea_id')->select('trabajo.id', 'titulo', 'u1.first_name as uname', 'u1.father_last_name as uf', 'u1.mother_last_name as um', 't.first_name as tname', 't.father_last_name as tf', 't.mother_last_name as tm', 'l.Categoria as cat', 'trabajo.Descripcion', 'trabajo.created_at as fecha')->get(); $lineas = LineaInvestigacion::all(); return view('Admin/Reportes/index', compact('usuarios', 'trabajos', 'lineas')); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $users = User::select(array('id', 'created_at', 'name', 'surname', 'email', 'username')); return \Datatables::of($users)->addColumn('actions', ' ')->make(true); }
public function data() { $users = User::select(['id', 'first_name', 'last_name', 'email']); return Datatables::of($users)->add_column('actions', '<a href="{{ route(\'users.show\', $id) }}"><i class="livicon" data-name="info" data-size="18" data-loop="true" data-c="#428BCA" data-hc="#428BCA" title="view user"></i></a> <a href="{{ route(\'users.update\', $id) }}"><i class="livicon" data-name="edit" data-size="18" data-loop="true" data-c="#428BCA" data-hc="#428BCA" title="update user"></i></a> <a href="{{ route(\'confirm-delete/user\', $id) }}" data-toggle="modal" data-target="#delete_confirm"><i class="livicon" data-name="user-remove" data-size="18" data-loop="true" data-c="#f56954" data-hc="#f56954" title="delete user"></i></a> ')->make(true); }
public function getUsers($query = '') { $q = User::select('id', 'name'); if ($query) { $q->where('name', 'LIKE', '%' . $query . '%'); } return Response::json($q->get()); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $users = User::select(array('id', 'created_at', 'name', 'surname', 'email', 'username', 'cellphone')); return \Datatables::of($users)->addColumn('actions', '<a class="btn btn-xs btn-alt" data-toggle="modal" onClick="launchUpdateUserModal({{$id}});" data-target=".modalEditUser" >Edit</a> ')->make(true); }
public static function getFirstName($id) { $query = User::select('first_name')->where('id', '=', $id)->get(); if (count($query) == 0) { return 1; } // Nav ierakstu return [0 => 2, 'first_name' => $query[0]->first_name]; }
public function getIndex() { $users = User::select(['id', 'name', 'surname', 'email'])->live()->orderBy('id', 'DESC'); return Datatables::of($users)->add_column('groups', function ($user) { return implode(', ', $user->Groups()->lists('name')->all()); })->add_column('actions', function ($row) { return permshtml('settings/users/' . $row->id . '/edit', '<a href="' . url('settings/users/' . $row->id . '/edit') . '" class="btn btn-xs btn-default">' . trans('app.edit') . '</a>') . " " . permshtml('settings/users/' . $row->id, '<a href="' . url('settings/users/' . $row->id) . '" data-token="' . csrf_token() . '" class="del-item btn btn-xs btn-danger">' . trans('app.delete') . '</a>', "delete"); })->removeColumn('id')->make(); }
public function run() { $faker = Faker::create(); //Category for ($i = 0; $i < 10; $i++) { $user = User::select(['id'])->where('id', rand(1, User::count()))->first(); $address = Address::create(['user_id' => $i <= 2 ? 4 : $user->id, 'default' => 0, 'line1' => $faker->streetAddress, 'line2' => $faker->streetAddress, 'phone' => $faker->e164PhoneNumber, 'name_contact' => $faker->streetName, 'zipcode' => $faker->postcode, 'city' => $faker->city, 'country' => $faker->country, 'state' => $faker->state]); } }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $breadcrumb = array(array('label' => 'Dashboard', 'url' => '/', 'class' => 'entypo-home'), array('label' => 'Manage Campaigns', 'url' => '/campaigns', 'class' => ''), array('label' => 'Edit', 'url' => '/campaigns/edit/' . $id, 'class' => '')); $users = Users::select()->where('account_type', 'client')->pluck('username', 'id')->toArray(); $gsmNumber = GsmNumber::all()->pluck('gsm_number', 'gsm_number')->toArray(); $campaigns = Campaigns::findOrFail($id); //print_r($campaigns); return view('admin.campaigns.edit')->with('users', $users)->with('gsmNumber', $gsmNumber)->with('campaign', $campaigns)->with('breadcrumb', $breadcrumb); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $arr = ['id' => 'id', 'username' => 'username', 'joined' => 'created_at', 'post_count' => 'post_count']; //paginate //tiny avatars? $this->data['users'] = App\User::select('users.*', \DB::raw('COUNT(posts.id) as post_count'))->join('posts', 'posts.user_id', '=', 'users.id')->groupBy('users.id')->paginate(20); $pagination = $this->data['users']->appends(array('order' => $by)); return view('forum.users.index', $this->data); }
/** * Display a listing of the resource. * * @return Response */ public function indexAction() { $this->name = Input::get('name'); $this->email = Input::get('email'); $this->status = Input::get('status'); $this->user = User::select('id', 'name', 'email', 'status')->where('name', 'like', '%' . $this->name . '%')->where('email', 'like', '%' . $this->email . '%')->where('status', 'like', '%' . $this->status . '%')->Paginate(2); return View::make('admin/user/user_list', ['Users' => $this->user]); // $this->user = User::paginate(3); /* MyHelper::debug($this->user->toArray(),1);*/ }
public function user_data() { \DB::statement(\DB::raw('set @rownum=0')); $users = User::select([\DB::raw('@rownum := @rownum + 1 AS rownum'), 'id', 'employee_name', 'nip', 'address']); return Datatables::of($users)->addColumn('action', function ($user) { return '<a href="./user/edit/' . $user->id . '" class="btn btn-xs btn-primary"><i class="glyphicon glyphicon-edit"></i> Edit</a> <button id="btn-delete" class="btn btn-xs btn-danger" data-remote="./user/destroy/' . $user->id . '">Delete</button> '; })->make(true); }
public function run() { $faker = Faker::create(); $actions = ActionType::get(); $users = User::select('id')->get(); //Category foreach (range(1, 20) as $void) { Log::create(['user_id' => $users->random(1)->id, 'action_type_id' => $actions->random(1)->id, 'source_id' => $faker->numberBetween(50, 1000000), 'details' => $faker->text(50)]); } }
/** * Get user details * * @param int $user_id * @param null $this_user * @return object */ public function userDetails($user_id, $this_user = NULL) { $user = User::select('id', 'first_name', 'last_name', 'email', 'role', 'phone_number', 'birthday'); if (is_null($this_user)) { $user = $user->where('id', '!=', $user_id)->get(); } else { $user = $user->where('id', $user_id)->first(); } return $user; }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // $users = User::select('id')->get(); $products = Product::select('id')->get(); $categories = Category::select('id')->get(); $areas = Area::select('id')->get(); $orders = Order::select('id')->get(); return view('admin.dashboard', compact('users', 'products', 'categories', 'areas', 'orders')); }