public static function appendOrder(QueryBuilder $queryBuilder, DataTablesWrapperInterface $dtWrapper) {

        foreach ($dtWrapper->getRequest()->getOrder() as $dtOrder) {

            $dtColumn = array_values($dtWrapper->getColumns())[$dtOrder->getColumn()];
            if (false === $dtColumn->getOrderable()) {
                continue;
            }

            $queryBuilder->addOrderBy($dtColumn->getMapping()->getAlias(), $dtOrder->getDir());
        }
    }