SonataDoctrineORMAdminBundle

To manage a One-to-Many relationship (e.g., a Gallery containing multiple Media items), use the Sonata\Form\Type\CollectionType.

You can customize the collection behavior using these options in the field definition:

• edit: Set to inline or standard. inline mode allows adding new rows directly.
• inline: Set to table or standard. table displays fields in a table format.
• sortable: Set to the name of the field (e.g., 'position') to enable drag-and-drop sorting.
• limit: An integer that limits the number of elements that can be added. Once the limit is reached, the "Add new" button is hidden.

Important: You must implement a setMedias method in your model and ensure cascading persistence is configured for the relationship.

namespace Sonata\MediaBundle\Admin;

use Sonata\AdminBundle\Admin\AbstractAdmin;
use Sonata\AdminBundle\Form\FormMapper;
use Sonata\Form\Type\CollectionType;

final class GalleryAdmin extends AbstractAdmin
{
    protected function configureFormFields(FormMapper $form): void
    {
        $form
            ->add('code')
            ->add('enabled')
            ->add('name')
            ->add('defaultFormat')
            ->add('galleryHasMedias', CollectionType::class, [
                    'by_reference' => false,
                ],
                [
                    'edit' => 'inline',
                    'inline' => 'table',
                    'sortable' => 'position',
                    'limit' => 3,
                ]);
    }
}

The ProxyQuery object wraps a standard Doctrine QueryBuilder to provide additional features and convenience methods required by Sonata Admin.

Key enhancements include:

• Direct Execution: Use the execute() method directly instead of calling getQuery()->getResult().
• Sorting: Provides simplified setSortBy() and sort order options.
• Optimized Joins: Automatically handles preselecting IDs on left join queries so that setMaxResults() (limit) is applied to the primary entity rather than the entire result set, simulating Doctrine 1 behavior.
• Duplicate Prevention: By default, Sonata uses the DISTINCT SQL keyword when fetching identifiers for listings to prevent duplicates caused by joins. If you are certain no duplicates will occur and want to improve performance, you can disable this using setDistinct(false).

use Sonata\AdminBundle\Datagrid\ORM\ProxyQuery;

$queryBuilder = $this->em->createQueryBuilder();
$queryBuilder->from('Post', 'p');

$proxyQuery = new ProxyQuery($queryBuilder);
$proxyQuery->leftJoin('p.tags', 't');
$proxyQuery->setSortBy('name');
$proxyQuery->setMaxResults(10);

$results = $proxyQuery->execute();

When a model has a Many-to-One relationship (e.g., many Post entities linked to one User), you can choose between two primary Sonata types to handle the relation:

1. Sonata\AdminBundle\Form\Type\ModelType: Displays the list in a select widget with an Add button to create a new related object.
2. Sonata\AdminBundle\Form\Type\ModelListType: Displays the list in a searchable model where you can select and delete related objects.

ModelListType Options:

• btn_add: Custom label for the add button.
• btn_list: Translation key for the list button.
• btn_delete: Set to false to hide the delete button.
• btn_edit: Custom label for the edit button (shows when a value is set).
• btn_catalogue: Custom translation domain for the buttons.

namespace Sonata\NewsBundle\Admin;

use Sonata\AdminBundle\Admin\AbstractAdmin;
use Sonata\AdminBundle\Form\FormMapper;
use Sonata\AdminBundle\Form\Type\ModelListType;
use Sonata\AdminBundle\Form\Type\ModelType;

final class PostAdmin extends AbstractAdmin
{
    protected function configureFormFields(FormMapper $form): void
    {
        $form
            ->with('General')
                ->add('enabled', null, ['required' => false])
                ->add('author', ModelListType::class, [
                    'btn_add'       => 'Add author',
                    'btn_list'      => 'button.list',
                    'btn_delete'    => false,
                    'btn_edit'      => 'Edit',
                    'btn_catalogue' => 'SonataNewsBundle',
                ], [
                    'placeholder' => 'No author selected',
                ])
                ->add('title')
                ->add('abstract')
                ->add('content')
            ->end()
            ->with('Tags')
                ->add('tags', ModelType::class, ['expanded' => true])
            ->end()
            ->with('Options', ['collapsed' => true])
                ->add('commentsCloseAt')
                ->add('commentsEnabled', null, ['required' => false])
                ->add('commentsDefaultStatus', 'choice', [
                    'choices' => Comment::getStatusList()
                ])
            ->end();
    }
}