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