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