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