public function getResults(Request $request) { $requests = Auth::user()->friendRequest(); $query = $request->input('query'); if (!$query) { return redirect()->route('home'); } $users = User::where(DB::raw("CONCAT(first_name, ' ' ,last_name)"), 'LIKE', "%{$query}%")->orWhere('email', 'LIKE', "{$query}")->orWhere('phone', 'LIKE', "{$query}")->get(); return view('search.results')->with('users', $users)->with('requests', $requests); }
public function getProfile($id) { $user = User::where('id', $id)->first(); $requests = Auth::user()->friendRequest(); if (!$user) { abort(404); } $posts = Posts::notReply()->where('user_id', $id)->orderBy('created_at', 'desc')->paginate(10); $posts_pub = Posts::notReply()->where('user_id', $id)->where('isPublic', true)->orderBy('created_at', 'desc')->paginate(10); /* * $posts_pub= Posts::notReply()->where('user_id',$id)->orWhere(function($query){ $query->where('isPublic',true);})->orderBy('created_at', 'desc') ->paginate(10); * */ //dd($posts); return view('profile.index')->with('user', $user)->with('posts', $posts)->with('requests', $requests)->with('posts_pub', $posts_pub)->with('authUserIsFriend', Auth::user()->isFriendWith($user)); }
public function getDelete($id) { $user = User::where('id', $id)->first(); Auth::user()->deleteFriend($user); return redirect()->back(); }