public function search($input) { $query = Municipio::query(); $columns = Schema::getColumnListing('municipios'); $attributes = array(); foreach ($columns as $attribute) { if (isset($input[$attribute])) { $query->where($attribute, $input[$attribute]); $attributes[$attribute] = $input[$attribute]; } else { $attributes[$attribute] = null; } } return [$query->get(), $attributes]; }
/** * Display a listing of the Post. * * @param Request $request * * @return Response */ public function index(Request $request) { $query = Municipio::query(); $columns = Schema::getColumnListing('$TABLE_NAME$'); $attributes = array(); foreach ($columns as $attribute) { if ($request[$attribute] == true) { $query->where($attribute, $request[$attribute]); $attributes[$attribute] = $request[$attribute]; } else { $attributes[$attribute] = null; } } $municipios = $query->get(); return view('municipios.index')->with('municipios', $municipios)->with('attributes', $attributes); }