/** * 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'); }