public function getProfile($fullname)
{
$user = User::where(DB::raw("CONCAT(first_name, ' ', last_name)"), 'LIKE', "%{$fullname}%")->first();
if (!$user) {
abort(404);
}
$notes = Note::where('user_id', $user->id)->orderBy('created_at', 'desc')->paginate(4);
return view('profile.index')->with('mainuser', $user)->with('notes', $notes);
}
public function getResults(Request $request)
{
$query = $request->input('query');
if (!$query) {
return redirect()->route('home');
}
$users = User::where(DB::raw("CONCAT(first_name, ' ', last_name)"), 'LIKE', "%{$query}%")->get();
$courses = Course::where('c_code', 'LIKE', "%{$query}%")->orWhere('c_name', 'LIKE', "%{$query}%")->get();
return view('search.results')->with('users', $users)->with('courses', $courses);
}
public function getRemove($username)
{
$user = User::where(DB::raw("CONCAT(first_name, ' ', last_name)"), 'LIKE', "%{$username}%")->first();
if (!$user) {
return redirect()->route('home')->with('info', 'That user could not be found.');
}
if (!Auth::user()->isFollowing($user)) {
return redirect()->route('profile.index', ['fullname' => $user->getName()])->with('info', 'You are already not following this user.');
}
Auth::user()->unFollowUser($user);
//define in user model
return redirect()->route('profile.index', ['fullname' => $user->getName()]);
}
public function emailofWriter()
{
return User::where('id', $this->user_id)->first()->getEmail();
}
