public function index(Request $request)
{
// set database
$database = Auth::user()->getDatabase();
//change database for Street
$street = new Complex();
$street->changeConnection($database);
//change database for Street
$property = new Property();
$property->changeConnection($database);
// get inputs
$Input = $request->input('input');
$Select = $request->input('selected');
//dd( $Input,$Select,$request);
// check if input or select
// if input ignore select
if (strlen($Input) > 0) {
// search
$search = $Input;
$properties = Property::on($database)->like('strComplexName', $search)->orderby('strComplexName', 'ASC')->orderby('strStreetName', 'ASC')->orderby('numComplexNo', 'ASC')->get();
} else {
// search
$complex = Complex::on($database)->where('id', $Select)->first();
$search = $complex->strComplexName;
$properties = Property::on($database)->where('strComplexName', $search)->orderby('strComplexName', 'ASC')->orderby('strStreetName', 'ASC')->orderby('numComplexNo', 'ASC')->get();
}
Session::put('search', $Select);
Session::put('controllerroute', '/complex');
// view properties
// return with error if no result
if ($properties->count()) {
return view('complexes', compact('properties', 'search'));
} else {
Session::flash('flash_message', '' . "No properties matching search criteria.");
Session::flash('flash_type', 'alert-danger');
return Redirect::back();
}
}
