public function removeFriend() { if (Auth::check() && Input::get('id')) { $friend = Friend::whereRaw('user_id = ? AND related_user_id = ?', [Auth::user()->id, Input::get('id')])->delete(); if ($friend) { return response()->json(["result" => "success"], 200); } } return response()->json(["result" => "error"], 200); }
public function showAll() { if (Auth::check()) { $users = DB::table('user')->join('role', 'user.role_id', '=', 'role.id')->leftjoin('media', 'user.media_id', '=', 'media.id')->select('user.id', 'first_name', 'last_name', 'role.name AS role', 'media.name AS photo', 'email')->where('user.is_deleted', '=', '0')->where('user.is_enable', '=', '1')->where('user.id', '!=', Auth::user()->id)->get(); if ($users) { foreach ($users as $key => $value) { $friend = Friend::whereRaw('user_id = ? AND related_user_id = ?', [Auth::user()->id, $value->id])->first(); if ($friend) { $users[$key]->category = $friend->category->name; $users[$key]->status = $friend->status; } else { $users[$key]->category = null; $users[$key]->status = null; } } return response()->json(["data" => $users, "result" => "success"], 200); } else { return response()->json(["result" => "error_no_any_users"], 200); } } else { return response()->json(["result" => "error_access_deny"], 200); } }