/**
* @param Builder $query
*
* @return Builder
*/
public function scopeSearch($query)
{
if (Input::has('q')) {
$q = Input::get('q');
$model = $this;
$query->where(function ($query2) use($q, $model) {
foreach ($model->getColumns() as $searchColumn) {
$table = $model->getTable();
$searchColumnExplode = explode('.', $searchColumn);
if (count($searchColumnExplode) > 1) {
$table = $searchColumnExplode[0];
$searchColumn = $searchColumnExplode[1];
}
switch (Schema::getColumnType($table, $searchColumn)) {
case 'integer':
case 'bigint':
case 'smallint':
case 'float':
if (is_numeric($q)) {
$query2->orWhere($table . '.' . $searchColumn, '=', (int) $q);
}
break;
case 'string':
case 'text':
$query2->orWhere($table . '.' . $searchColumn, 'ilike', "%{$q}%");
break;
}
}
});
}
return $query;
}
