CRUDlex\MySQLData::addSort PHP Method

addSort() protected method

Adds sorting parameters to the query.
protected addSort ( Doctrine\DBAL\Query\QueryBuilder $queryBuilder, string | null $sortField, boolean | null $sortAscending )
$queryBuilder Doctrine\DBAL\Query\QueryBuilder the query
$sortField string | null the sort field
$sortAscending boolean | null true if sort ascending, false if descending
    protected function addSort(QueryBuilder $queryBuilder, $sortField, $sortAscending)
    {
        if ($sortField !== null) {
            $type = $this->definition->getType($sortField);
            if ($type === 'many') {
                $sortField = $this->definition->getInitialSortField();
            }
            $order = $sortAscending === true ? 'ASC' : 'DESC';
            $queryBuilder->orderBy('`' . $sortField . '`', $order);
        }
    }