/**
* 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]);
}
