/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Property $property) { // $apartments = Apartment::with(['property' => function ($q) { $q->orderBy('name'); }])->where('property_id', $property->id)->orderBy('number')->get(); //$apartments = $apartments->property()->orderBy('properties.name')->get(); return view('apartments.index', ['title' => $property->name . ': Apartments', 'property' => $property, 'apartments' => $apartments]); }
public function getAllAppartments() { $query = Apartment::with('images')->with('accessories')->get(); return Response::json($query); }
public function getLook(Request $request) { $file = \App\MeterFile::where('active', 1)->first(); if (!$file) { return back()->withErrors('Необходимо активировать базу.'); } $searching = !empty($request->input('street', '')) || !empty($request->input('building', '')) || !empty($request->input('apartment', '')) || !empty($request->input('ls', '')); if ($searching) { if (!empty($request->input('ls', ''))) { $apartments = \App\Apartment::where('ls', 'like', '%' . $request->input('ls') . '%')->with('building.street')->paginate(30); } else { $apartment = $request->input('apartment', false); $building = $request->input('building', false); $street = $request->input('street', false); $apartments = \App\Apartment::where('number', $apartment)->whereHas('building', function ($query) use($building) { $query->where('number', $building); })->with('building.street')->paginate(30); $apartments = \App\Apartment::query(); if ($apartment) { $apartments->where('number', $apartment); } if ($building) { $apartments->whereHas('building', function ($query) use($building) { $query->where('number', $building); }); } if ($street) { $apartments->whereHas('building.street', function ($query) use($street) { $query->where('name', 'like', '%' . $street . '%'); }); } $apartments = $apartments->with('building.street')->paginate(30); } } else { $apartments = \App\Apartment::with('building.street')->paginate(30); } return view('admin.look', ['apartments' => $apartments, 'searching' => $searching]); }