/**
* Add an "order by" clause to the query.
*
* @param string $column
* @param string|int $direction
* @return Database\CollectionDelegator
*/
public function sort($column, $direction = 'asc')
{
if (is_int($direction)) {
$direction = $direction == -1 ? 'desc' : 'asc';
}
$this->query->orderBy($column, $direction);
return $this;
}
/**
* Scope for the last notifications.
*
* @param Illuminate\Database\Query\Builder $query
* @param int $limit (Default: 10)
*
* @return Illuminate\Database\Query\Builder
*/
public function scopeRecent($query, $limit = 10)
{
return $query->orderBy('created_at', 'desc')->limit($limit);
}
/**
* Builds a query scope to return object alphabetically for a dropdown list.
*
* @param Illuminate\Database\Query\Builder $query
* @param string $column (optional) to order by
* @param string $key (optional) to use in returned array
* @param string $sort (optional) direction
* @return array
*/
public function scopeListAlphabetically($query, $column = null, $key = null, $sort = 'asc')
{
$column = is_null($column) ? $this->getKeyName() : $column;
return $query->orderBy($column, $sort)->lists($column, $key)->all();
}