/**
* Get new events.
*
* @param QueryBuilder $query
* @return QueryBuilder
*/
public function scopeLatest($query)
{
return $query->orderBy('id', 'DESC');
}
/**
* Order events by date and city.
*
* @param QueryBuilder $query
* @return QueryBuilder
*/
public function scopeOrderDefault($query)
{
return $query->orderBy(DB::raw("DATE_TRUNC('day', begins_at)"), 'ASC')->orderBy('city_name', 'ASC');
}
/**
* Add an "order by" clause to the query.
*
* @param string $column
* @param string $direction
* @return $this
* @static
*/
public static function orderBy($column, $direction = 'asc')
{
//Method inherited from \Illuminate\Database\Query\Builder
return \October\Rain\Database\QueryBuilder::orderBy($column, $direction);
}
/**
* Get latest models.
*
* @param QueryBuilder $query
* @return QueryBuilder
*/
public function scopeRecentFlyers($query)
{
return $query->orderBy('created_at', 'desc');
}
/**
* Get topics with latest replies.
*
* @param QueryBuilder $query
* @return QueryBuilder
*/
public function scopeRecentPosts($query)
{
return $query->orderBy('created_at', 'asc');
}
