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