/** * Display a listing of the resource. * * @return Response */ public function index() { $user = Auth::user(); $books = Book::all(); $transactions = User::join('book_users', 'users.id', '=', 'book_users.user_id')->join('books', 'books.id', '=', 'book_users.book_id')->select('books.title', 'users.name', 'book_users.created_at', 'book_users.updated_at', 'book_users.status')->whereNotIn('status', ['pesan'])->get(); return view('operator.borrow.index', ['user' => $user, 'books' => $books, 'transactions' => $transactions]); }
public function getIndex() { if (Auth::check()) { $clan = User::join('grad as g', 'g.id', '=', 'korisnici.grad_id')->where('username', Auth::user()->username)->get(['korisnici.id', 'username', 'email', 'prezime', 'ime', 'adresa', 'g.naziv as grad', 'telefon', 'bio', 'foto', 'naslovna', 'ocena'])->first(); return view('administracija.admin.profil')->with('clan', $clan)->with('mojProfil', $clan->id == Auth()->user()->id ? 'true' : null); } }
/** * Post registration data * @param Request $request * @return redirect */ public function postRegister(Request $request) { $this->validate($request, ['email' => 'required|email|unique:users']); $user = User::join($request->all()); $this->userMailer->sendVerificationEmail($user); flash('Kiitos rekisteröitymisestä. Saat pian sähköpostin, jossa on varmistuslinkki sovelluksen käyttämiseksi.'); return redirect()->back(); }
/** * @param Project $project * @return \Illuminate\View\View */ public function show(Project $project) { $projectsRelation = $this->projectModel->getProjects()->limit(6)->get(); $contactInfo = User::join('profiles', 'users.id', '=', 'profiles.user_id')->where('user_id', $project->user_id)->first(); $preview = Project::isApproved(1)->where('id', '<', $project->id)->orderBy('id', 'desc')->first(); $next = Project::isApproved(1)->where('id', '>', $project->id)->orderBy('id', 'asc')->first(); return view('front.projects.show', compact('project', 'projectsRelation', 'contactInfo', 'preview', 'next')); }
public function postClanovi() { $izlaz = ['podaci' => Korisnici::join('grad as g', 'g.id', '=', 'grad_id')->join('vrsta_korisnika as v', 'v.id', '=', 'vrsta_korisnika_id')->where('vrsta_korisnika_id', 'Like', Input::get('vrsta_korisnika') == 1 ? '%%' : Input::get('vrsta_korisnika'))->where('grad_id', 'Like', Input::get('grad') == 1 ? '%%' : Input::get('grad'))->where(DB::raw('concat(ime," ",prezime)'), 'Like', '%' . Input::get('pretraga') . '%')->skip(Input::has('stranica') ? Input::get('stranica') * $this->ukupnoClanovaPretrage : 0)->take($this->ukupnoClanovaPretrage)->get(['prezime', 'ime', 'username', 'korisnici.foto', 'g.naziv as grad', 'v.naziv as vrsta'])->toArray()]; if (Input::has('init')) { $izlaz['init'] = ceil(Korisnici::join('grad as g', 'g.id', '=', 'grad_id')->join('vrsta_korisnika as v', 'v.id', '=', 'vrsta_korisnika_id')->where('vrsta_korisnika_id', 'Like', Input::get('vrsta_korisnika') == 1 ? '%%' : Input::get('vrsta_korisnika'))->where('grad_id', 'Like', Input::get('grad') == 1 ? '%%' : Input::get('grad'))->where(DB::raw('concat(prezime," ",ime)'), 'Like', '%' . Input::get('pretraga') . '%')->count() / $this->ukupnoClanovaPretrage); } return json_encode($izlaz); }
/** * Gets a user or users for the database. * * @param $id = false * @return object */ public static function getUser($id = false) { if ($id === false) { $users = User::join('role_user', 'users.id', '=', 'role_user.user_id')->join('roles', 'role_user.role_id', '=', 'roles.id')->select('users.id', 'users.name', 'users.email', 'roles.name AS role_name', 'users.photo')->groupBy('users.id')->get(); } else { $users = User::where('users.id', $id)->join('role_user', 'users.id', '=', 'role_user.user_id')->join('roles', 'role_user.role_id', '=', 'roles.id')->select('users.id', 'users.name', 'users.email', 'roles.name AS role_name', 'roles.id AS role_id', 'users.photo')->get(); } return $users; }
public function manageExisting() { $admin = \Auth::user(); $user = User::join('role_user', function ($join) { $join->on('Users.id', '=', 'role_user.user_id'); })->join('roles', 'roles.id', '=', 'role_user.role_id')->get(['Users.id', 'Users.name', 'Users.name', 'Users.email', 'Users.username', 'Users.na', 'roles.name as rolename']); $title = 'Manage Existing User'; return view('page.useradmin')->with('title', $title)->with('users', $user)->with('admin', $admin); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { //$this->authorize('user.read'); if (Gate::denies('user.read')) { return view(config('app.template') . '.error.403'); } $users = User::join('karyawans', 'users.id', '=', 'karyawans.user_id')->with(['roles'])->where('users.active', 1)->select(['users.*', 'karyawans.nama'])->get(); $data = ['users' => $users]; return view(config('app.template') . '.user.table', $data); }
/** * Display a listing of the resource. * * @return Response */ public function index(Request $request) { $id = $request->input('id'); if (!empty($id)) { $data = User::join('user_interests', 'user_id', '=', 'users.id')->where('interest_id', $id)->distance(14.5, 121, 121.024)->get(); } else { $data = User::distance(14.5, 121, 121.024)->get(); } $users = User::where('id', '!=', Auth::id())->get(); return view('account.index', compact('users', 'data')); }
public function giveUsers(Request $request, $id) { $signedUp = false; $data = $request->all(); $user = User::join('user_sessions', 'user_sessions.user_id', '=', 'users.id')->where('user_sessions.session_id', '=', $id)->where('user_sessions.status', '=', 1)->get(); foreach ($user as $key) { if ($key->user_id == $data['user_id']) { $signedUp = true; } } return response()->json(['success' => 'true', 'users' => $user, 'signed_up' => $signedUp]); }
/** * Show the form for creating a new resource. * * @return Response */ public function create() { $users = User::where('role', '=', 2)->get(); $clients = User::where('role', '=', 3)->get(); $test = User::join('assigns', function ($join) { $join->on('users.id', '=', 'assigns.id_client'); })->get(); foreach ($test as $key => $value) { $clients->forget($key); } return view('assign.create', compact('users', 'clients')); }
public function top($sort_type, $limit = 5) { $selectors = array('facebook_id', 'name'); // no type specified, fetches overall average $selector = '0'; foreach (RATING::$RATING_TYPES as $type) { $query = sprintf('sum( %s ) / count( * )', RATING::RATING_COLUMN_PREFIX . $type); $selector .= '+ ' . $query; $selectors[] = DB::raw($query . 'as ' . $type); } $selectors[] = DB::raw(sprintf('(%s)/%d as avg', $selector, count(RATING::$RATING_TYPES))); $results = User::join('ratings', 'ratings.user_id_to', '=', 'users.facebook_id')->select($selectors)->groupBy('facebook_id')->orderBy(in_array($sort_type, RATING::$RATING_TYPES) ? $sort_type : 'avg', 'desc')->take($limit)->get(); return response()->json($results); }
public function related(Request $request) { $user = User::findOrFail($request->input('id')); $skills = $user->skills; $skill_categories = $skills->lists('sub_category_id')->toArray(); $skill_categories = implode(',', $skill_categories); $info = $user->info; $city_id = $info->city_id == null ? 0 : $info->city_id; $province_id = $info->province_id == null ? 0 : $info->province_id_id; $users = User::join('skills', 'skills.user_id', '=', 'users.id')->join('infos', 'infos.user_id', '=', 'users.id')->select(DB::raw("(CASE WHEN skills.sub_category_id IN (" . $skill_categories . ") THEN 1 ELSE 0 END) +\n (CASE WHEN users.first_name LIKE '%" . $user->first_name . "%' THEN 10 ELSE 0 END) +\n (CASE WHEN users.last_name LIKE '%" . $user->last_name . "%' THEN 1 ELSE 0 END) +\n (CASE WHEN infos.city_id = " . $city_id . " THEN 10 ELSE 0 END) +\n (CASE WHEN infos.province_id = " . $province_id . " THEN 5 ELSE 0 END) +\n (CASE WHEN skills.title = " . $province_id . " THEN 5 ELSE 0 END)\n AS relevance"))->get(); dd($users); $categories = $user->skills->lists('category_id', 'sub_category_id')->toArray(); dd($categories); }
/** * Obtener la paginación de los usuarios * * @param $limit * @return mixed */ protected function paginateusers($limit, $departamento = null) { $user = Users::join('detalle_usuario', function ($join) { $join->on('detalle_usuario.id', '=', 'users.id'); })->join('roles', function ($join) { $join->on('roles.id_rol', '=', 'detalle_usuario.id_rol'); })->join('departamentos', function ($join) { $join->on('departamentos.id_departamento', '=', 'users.id_departamento'); })->select(['users.id', 'users.name AS nombre', 'users.username', 'users.email', 'users.created_at', 'departamentos.name AS departamento', DB::raw("GROUP_CONCAT(roles.name SEPARATOR ', ') AS roles"), 'users.status'])->groupBy('users.id'); if (isset($departamento)) { if ($departamento != 'todos') { $user->where('departamentos.id_departamento', $departamento); } } return $user->paginate($limit); }
public function ranking() { $users = User::join('users_stats', 'users.id', '=', 'users_stats.user_id')->orderBy('users_stats.wins', 'desc')->take(10)->paginate(); $users->setPath(''); return view('app.ranking', compact('users')); }
public function getUser() { $role = [' ' => 'Seleciona el rol']; $role += Role::lists('name', 'id')->toArray(); $challenge = [' ' => '-- Seleccionar Reto --']; $challenge += Challenge::where('active', '=', '1')->lists('name', 'id')->toArray(); $url_actual = "http://" . $_SERVER["SERVER_NAME"] . $_SERVER["REQUEST_URI"]; $url_actual = explode('?', $url_actual); $user = User::join('rb_role', 'rb_role.id', '=', 'rb_users.role_id')->select('rb_users.*', 'rb_role.name as nombre_rol')->orderBy('id', 'DESC')->paginate(env('PAG')); $user->setPath($url_actual[0]); //dd($user); return view('users.list_user', compact('user', 'role', 'challenge')); }
public function search(Request $request) { if ($request->has('email') && $request->has('cell_phone')) { //the email and cellphone has been entered $this->validate($request, ['email' => 'required|min:3', 'cell_phone' => 'required|min:6']); //begin the search process $users = User::join('infos', 'users.id', "=", 'infos.user_id')->where('users.email', '=', $request->input('email'))->where('infos.cell_phone', '=', $request->input('cell_phone'))->select('users.*')->get(); $results = $users; } elseif ($request->has('email') && !$request->has('cell_phone')) { // the email has been entered only $this->validate($request, ['email' => 'required|min:3']); $users = User::where('email', '=', $request->input('email'))->select('users.*')->get(); $results = $users; } elseif (!$request->has('email') && $request->has('cell_phone')) { $this->validate($request, ['cell_phone' => 'required|min:6']); $users = User::join('infos', 'users.id', "=", 'infos.user_id')->where('infos.cell_phone', '=', $request->input('cell_phone'))->select('users.*')->get(); $results = $users; } else { $this->validate($request, ['email' => 'required', 'cell_phone' => 'required']); } return view('profile.findFriend', compact('results'))->with(['title' => 'نتایج جستجو', 'type' => 'search']); }
public function findUsers($id) { //$usuarios = DB::table('users')->join('usuario_empresa', 'users.id', '=', 'usuario_empresa.user_id') $usuarios = User::join('usuario_empresa', 'users.id', '=', 'usuario_empresa.user_id')->join('roles', 'users.role_id', '=', 'roles.id')->where('usuario_empresa.empresa_id', '=', $id)->get(); return $usuarios; }
/** * Process datatables ajax request. * * @return \Illuminate\Http\JsonResponse */ public function dataTable() { $records = User::join('groups', 'users.group_id', '=', 'groups.id')->select(['users.id', 'users.name', 'users.email', 'groups.group_name', 'users.role', 'users.created_at']); return Datatables::of($records)->addColumn('action', function ($record) { return '<a title="View" href="/user/' . $record->id . '" class="btn btn-xs blue"><i class="fa fa-search"></i></a> <a title="Edit" href="/user/' . $record->id . '/edit" class="btn btn-xs green"><i class="fa fa-edit"></i></a>'; })->make(true); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $users = User::join('profiles_answers', 'users.id', '=', 'profiles_answers.user_id')->where('profiles_answers.user_id', '<>', Auth::user()->id)->where('profiles_answers.profile_question_id', 1)->orderBy('users.last_login', 'desc')->get(); return view('members/index', ['users' => $users]); }
public function articlesbyauthor($name) { $articles = User::join('articles', 'users.id', '=', 'articles.autor')->select('users.name as autor', 'articles.id as id', 'articles.title as title', 'articles.subtitle as subtitle', 'articles.image as image')->orderBy('articles.created_at', 'desc')->where('users.name', $name)->paginate(16); // $articles = Article::where('autor', $name)->orderBy('created_at', 'desc')->paginate(5); return \view('Link/articlesbyauthor', array('articles' => $articles, 'nom' => $name)); }
public static function getConfigCompactSidebarUserById($userid) { $navbar = User::join('configs', 'users.config_id', '=', 'configs.id')->where('users.id', $userid)->value('compactsidebar'); return $navbar; }
/** @test */ public function it_should_register_a_new_user() { $attributes = ['email' => '*****@*****.**']; $user = User::join($attributes); $this->assertEquals($user->verified, 0); }
/** * Display the specified resource. * * @param Article $article * @return Response */ public function description(Company $company) { $contact = User::join('profiles', 'users.id', '=', 'profiles.user_id')->where('user_id', $company->user_id)->first(); return view('front.designs.description', compact('company', 'contact')); }
/** * Display the specified resource. * * @param House $house * @return \Illuminate\View\View */ public function show(House $house) { $houseModel = new House(); $housesRelation = $houseModel->getHouses()->saleType($house->sale_type)->limit(3)->get(); $contactInfo = User::join('profiles', 'users.id', '=', 'profiles.user_id')->where('user_id', $house->user_id)->first(); $preview = $houseModel->saleType($house->sale_type)->where('houses.id', '<', $house->id)->first(); $next = $houseModel->saleType($house->sale_type)->where('houses.id', '>', $house->id)->first(); return view('front.houses.show', compact('house', 'housesRelation', 'contactInfo', 'preview', 'next')); }
/** * Display the specified resource. * * @param Article $article * @return Response */ public function description() { $company = Company::where('companies.user_id', '1')->first(); $banner = Banner::find(1); $contact = User::join('profiles', 'users.id', '=', 'profiles.user_id')->where('user_id', 1)->first(); return view('front.designs.description', compact('company', 'banner', 'contact')); }
public function getTypeall($type) { if (!Auth::check()) { return Redirect::to('leads/login'); } if (Auth::user()->type != "admin" && Auth::user()->type != "manager") { return Redirect::to('leads/login'); } $templeads = User::join('leads', function ($join) { $join->on('users.id', '=', 'leads.user_id'); })->where('users.aff', '=', Auth::user()->aff); if ($type == "new-leads") { $leads = $templeads->where('call', '=', false); } else { if ($type == "all-leads") { $leads = $templeads; } else { $leads = $templeads->where('status_code', '=', $type); } } return view('leads.view')->with('type', $type)->with('leads', $leads->paginate(10))->with('leads_count', $leads->count()); }
public static function searchStaff($keyword) { $users = User::join('staff', 'users.userId', '=', 'staff.userId')->where('users.name', 'LIKE', '%' . $keyword . '%')->orwhere('users.surname', 'LIKE', '%' . $keyword . '%')->get(); return $users; }
public function getGroups($user_id) { return User::join('user_token', 'users.id', '=', 'user_token.user_id')->where('id', $user_id)->select('users.id', 'user_token.create_date', 'user_token.token', 'user_token.id AS userTokenID'); }