Entry Point for Admin and Extensions to change Exported Data

[Hanmac]

Feature Request

• i got Fields with DateTime data. And i use Sonata-intl to change the timezone it displays to my defined one. (php timezone is UTC, while intl one is "Europe/Berlin")
• I also changed the Filter to use the intl timezone was view_timezone so the Form used in the filter shows the intl time while still using the php time for the query (would be nice to better automate that, but that's a problem for later)
• But that doesn't work for the Export Fields, i currently see no easy way to change the time getting exported from the php timezone to the intl one

so it would be nice to have a way to alter the data between getting it from the query and exporting it into the Exporter for csv or xml data

[VincentLanglet]

You can implement your own DataSource, similar to https://github.com/sonata-project/SonataDoctrineORMAdminBundle/blob/4.x/src/Exporter/DataSource.php#L21 which return the custom Iterator you want based on https://github.com/sonata-project/exporter/blob/3.x/src/Source/AbstractPropertySourceIterator.php with the override needed for the method getValue.

What could be done would be to change

SonataDoctrineORMAdminBundle/src/Exporter/DataSource.php

Line 51 in 81bfbcb

return new DoctrineORMQuerySourceIterator($query->getDoctrineQuery(), $fields);

in SonataDoctrineORMAdminBundle to

$this->dataSourceIteratorFactory->createIterator($query->getDoctrineQuery(), $field);

in order to introduce a new extension point.

I move this to SonataDoctrineORMAdminBundle

[Hanmac]

Interesting point out to the SourceIterator ... i especially find the DateTimeFormat interesting that maybe could be extended with DateTimeTimezone

[Hanmac]

Hm one thing that confuses me is why DoctrineORMQuerySourceIterator is part of the exporter module and not part of the SonataDoctrineORMAdminBundle 🤷

[VincentLanglet]

Hm one thing that confuses me is why DoctrineORMQuerySourceIterator is part of the exporter module and not part of the SonataDoctrineORMAdminBundle 🤷

Because like any other sourceIterator (https://github.com/sonata-project/exporter/tree/1877816a03b96cadf1be03d1857d9ef11088778a/src/Source), it can be used without sonataAdmin

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.