Environment-driven CDN host for SonataMediaBundle images in wkhtmltopdf generated with Symfony KnpSnappyBundle and TWIG

To display images in wkhtmltopdf you need to enable images:


In addition you have to use absolute paths in your twig template. But sometimes you want to use different path based on your environment. Using assets you can easily do this:


Instead of setting the CDN host statically you can use parameters.yml:

Source: https://github.com/Jolg42/sonata-sandbox/blob/master/app/config/parameters.yml.sample#L30


Then in your sonata_media.yml :

Source: https://github.com/Jolg42/sonata-sandbox/blob/master/app/config/sonata/sonata_media.yml#L33


Now you can use the Sonata Media helpers to display the images:


Using PHP YAML Extension and Unicode on Entity column with Doctrine Events

I have a Rails legacy database that uses a YAML formatted array in a column. My new App is based on Symfony2 and Doctrine2.

To make this column useable in Sonata Admin I had to (re-)convert between PHP Array and YAML.


This worked fine using Doctrine Events:


Note the YAML_UTF8_ENCODING constant when emitting. By default yaml_emit uses the YAML_ANY_ENCODING constant.

All constants can be found here:


How to inject Symfony Security into Doctrine Event Listener without Circular Reference Exception

As of Symfony 2.6, you can inject the security.token_storage into your listener. This service will contain the token as used by the SecurityContext in <=2.5.




How to use CHAR instead of VARCHAR with Doctrine ORM


How to check if Subject is New resp. action is create or edit in Sonata Admin

In your Admin Class:

In your Twig Template:

Source: https://github.com/sonata-project/SonataAdminBundle/blob/master/Resources/views/CRUD/base_edit_form.html.twig#L4



Override list view twig template in SonataAdminBundle

There are two ways to override the list view template.

1. Admin Class

2. Service Setter Injection

As described in the docs.


Then take the original twig template and change the desired block e.g. list_header:


That’s it!




Translating dynamic vars concatening object property in twig template using SonataAdminBundle

My Contract Entity has a history of states and the current state is displayed in the listView. The state is stored as a simple string e.g. “pending” in the database.


But the translation string are stored with a prefix e.g. “contracts.states.pending”:


To make the translation work inside the twig template you can concat the prefix and the property from the database like this:



Override CRUDController to add custom form elements to list template for batch action usage in SonataAdminBundle

In my use case I needed a batch action with an additional date field to be set on my Entity. I came up with the following solution.

I will not add the Entities since this post should focus on the configuration of the list template and batch action.


First of all define the custom batch action and the path to your custom list template in your Admin class:


Next enable and configure a custom CRUDController:


Then create your custom CRUDController:


Copy the original listAction from CRUDController.php and add the custom form date element:

We can use the sonata_type_date_picker which comes built-in with the SonataAdminBundle.

Next add the date picker to your template:

This should render some HTML and Javascript for the element looking like this:


In our Admin class we set ask_confirmation to true. This way we can make use of the relevancy check function to validate our new form element.

Regarding the naming conventions add a batchActionTestIsRelevant method to your CRUDController:


Finally we add the batchActionTest method:

And we’re done!



Single and Multiple Ordering To-Many Associations in Doctrine2

Associations in Doctrine2 can be ordered by default without using an extra query:


This also works for multiple ordering: