/**
* Show the application dashboard.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
// get user id
// connect to farmbook and get default database
$database = Auth::user()->getDatabase();
//change database dynamically to user set database
$street = new Street();
$street->changeConnection($database);
$streets = Street::on($database)->orderBy('strStreetName', 'ASC')->lists('strStreetName', 'id');
$complexes = Complex::on($database)->orderBy('strComplexName', 'ASC')->lists('strComplexName', 'id');
// $owners = Owner::on($database )->orderBy('NAME','DESC')->lists('NAME', 'id');
$owners = Property::on($database)->orderBy('strOwners', 'DESC')->groupBy('strOwners')->lists('strOwners', 'id');
$properties = Property::on($database)->orderBy('strKey', 'ASC')->lists('strkey', 'id');
$erfs = Note::on($database)->orderBy('numErf', 'ASC')->lists('numErf', 'id');
return view('search', compact('streets', 'complexes', 'owners', 'properties', 'erfs'));
}
public function index(Request $request)
{
// set database
$database = Auth::user()->getDatabase();
//change database for Street
$street = new Street();
$street->changeConnection($database);
//change database for Street
$property = new Property();
$property->changeConnection($database);
// get inputs
$Input = $request->input('input');
$Select = $request->input('selected');
//$updatesonly = $request->input('updates');
//dd($updatesonly);
//dd( $streetInput,$streetSelect);
// check if input or select
// if input ignore select
if (strlen($Input) > 0) {
// search
$search = $Input;
$properties = Property::on($database)->like('strStreetName', $search)->orderby('strStreetName', 'ASC')->orderby('numStreetNo', 'ASC')->get();
} else {
// search
$street = Street::on($database)->where('id', $Select)->first();
$search = $street->strStreetName;
$properties = Property::on($database)->where('strStreetName', $search)->orderby('strStreetName', 'ASC')->orderby('numStreetNo', 'ASC')->get();
}
Session::put('search', $Select);
Session::put('controllerroute', '/street');
// view properties
// return with error if no result
if ($properties->count()) {
return view('streets', compact('properties', 'search'));
} else {
Session::flash('flash_message', '' . "No properties matching search criteria.");
Session::flash('flash_type', 'alert-danger');
return Redirect::back();
}
}
