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