/** * Add an order by statement for this query * * @param string $column * @param string $direction * * @return SugarQuery */ public function orderBy($column, $direction = 'DESC') { $orderBy = new SugarQuery_Builder_Orderby($this, $direction); $orderBy->addField($column); $this->order_by[] = $orderBy; return $this; }
/** * Add additional column to `ORDER BY` clause for order stability, defaults * to using the `id` column. * * @param SugarQuery_Builder_Orderby[] $orderBy List of already existing `ORDER BY` defs * @param string $column Unique column to add, defaults to `id` * @return SugarQuery_Builder_Orderby[] */ protected function applyOrderByStability(array $orderBy, $column = 'id') { $uniqueCol = new SugarQuery_Builder_Orderby($this->sugar_query); $uniqueCol->addField($column); $orderBy[] = $uniqueCol; return $orderBy; }