/** * Display the specified resource. * * @param House $house * @return \Illuminate\View\View */ public function show(House $house) { $houseModel = new House(); $housesRelation = $houseModel->getHouses()->saleType($house->sale_type)->limit(3)->get(); $contactInfo = User::join('profiles', 'users.id', '=', 'profiles.user_id')->where('user_id', $house->user_id)->first(); $preview = $houseModel->saleType($house->sale_type)->where('houses.id', '<', $house->id)->first(); $next = $houseModel->saleType($house->sale_type)->where('houses.id', '>', $house->id)->first(); return view('front.houses.show', compact('house', 'housesRelation', 'contactInfo', 'preview', 'next')); }