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'));
}
