10. Export / DataSource

When using an admins export feature you might want to modify how values, such as dates, times and enumerations are exported. This is done by calling convenience methods like setDateTimeFormat() and useBackedEnumValue() on the data source iterator.

Here’s one way to do it:

Decorate the default SonataDoctrineORMAdminBundleExporterDataSource with your own and calls there.:

namespace App\Service\Admin;

use Sonata\AdminBundle\Datagrid\ProxyQueryInterface;
use Sonata\AdminBundle\Exporter\DataSourceInterface;
use Sonata\DoctrineORMAdminBundle\Exporter\DataSource;
use Sonata\Exporter\Source\DoctrineORMQuerySourceIterator;

class DecoratingDataSource implements DataSourceInterface
{
    private DataSource $dataSource;

    public function __construct(DataSource $dataSource)
    {
        $this->dataSource = $dataSource;
    }

    public function createIterator(ProxyQueryInterface $query, array $fields): \Iterator
    {
        /** @var DoctrineORMQuerySourceIterator $iterator */
        $iterator = $this->dataSource->createIterator($query, $fields);

        $iterator->setDateTimeFormat('Y-m-d H:i:s');
        $iterator->useBackedEnumValue(false);

        return $iterator;
    }
}

Add the your service in the config/services.yaml definition.:

services:
    ...
    App\Service\Admin\DecoratingDataSource:
        decorates: 'sonata.admin.data_source.orm'