/** * Get all visits * * @return \Illuminate\Http\JsonResponse */ public function json() { $visits = Visit::with('content', 'user')->addSelect(DB::raw('visits.*, count(id) as visits'))->groupBy('http_url', 'user_id', 'content_id')->orderBy('created_at', 'desc')->get(); return response()->json(['data' => $visits]); }