Nested CollectionType Form

Example of nested collection forms

class TemplateType extends AbstractType

    public function buildForm(FormBuilderInterface $builder, array $options): void

            ->add('name', TextType::class, [
                'label' => "Template Name",
                'required' => true,
                'attr' => [
                    'class' => 'form-control',
            ->add('sentences', CollectionType::class, [
                'entry_type' => SentenceType::class,
                'entry_options' => ['label' => false],
                'label' => false,
                'allow_add' => true,
                'allow_delete' => true,
                'delete_empty' => true,
                'by_reference' => false,
                'prototype' => true,
                'prototype_name' => '__sentence__',
            ->add('submit', SubmitType::class, [
                'label' => 'Update',
                'attr' => [
                    'class' => "btn btn-sm btn-primary"


    public function configureOptions(OptionsResolver $resolver): void
            'data_class' => Template::class,
            'csrf_protection' => false,

Continue reading “Nested CollectionType Form”

Get all duplicate records in table

Slow variant:

FROM table t1
WHERE t1.domain_id = 1569
AND t1.is_active = 1
AND (t1.field IN (SELECT t2.field
				 FROM table t2
				 WHERE t2.is_active = 1
				 GROUP BY t2.field
				 HAVING COUNT(t2.field) > 1))

Faster variant:

SELECT l0_.*
FROM table l0_
inner join table n2 on n2.field = l0_.field
where <>
AND l0_.is_active = 1
Group By


	->innerJoin(Table::class,'table', Query\Expr\Join::WITH, 'entity.field = table.field')
	->andWhere(' <>')
	->andWhere('table.isActive = 1')

Nested Queries with Query Builder

$queryBuilder = $this->createQueryBuilder('account_event');
            ->select(' AS AE_id', 'IDENTITY(account_event.event) AS event_id', 'account_event.dueDate as due_date', 'IDENTITY(account_event.account) AS account_id')
                        ->andWhere('ae2.event IN (:events)')
                        ->andWhere('ae2.account IN (:accounts)')
                        ->andWhere('ae2.dueDate > DATE(:date)')
            ->setParameter('events', $events)
            ->setParameter('accounts', $accounts)
            ->setParameter('date', $date->format('Y-m-d'))

Fast Setup Virtual Machine and Symfony

sudo dpkg --configure -a
sudo apt-get install mysql-server
apt-cache pkgnames | grep php7.3
php -r "copy('', 'composer-setup.php');"
php -r "if (hash_file('sha384', 'composer-setup.php') === 'a5c698ffe4b8e849a443b120cd5ba38043260d5c4023dbf93e1558871f1f07f58274fc6f4c93bcfd858c6bd0775cd8d1') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"
php composer-setup.php
php -r "unlink('composer-setup.php');"
sudo mv composer.phar /usr/local/bin/composer

# run this if you are building a traditional web application

composer create-project symfony/skeleton ./ 

# run this if you are building a microservice, console application or API

composer create-project symfony/website-skeleton ./

Current folder should be empty!!!

Continue reading “Fast Setup Virtual Machine and Symfony”

RabbitMQ Work Queue with Symfony

Add to .env


Add to services.yaml

        arguments: ['%env(RABBITMQ_HOST)%', '%env(RABBITMQ_PORT)%', '%env(RABBITMQ_USERNAME)%', '%env(RABBITMQ_PASSWORD)%', '%env(RABBITMQ_QUEUE_NAME)%']

            arguments: ['%env(RABBITMQ_HOST)%', '%env(RABBITMQ_PORT)%', '%env(RABBITMQ_USERNAME)%', '%env(RABBITMQ_PASSWORD)%', '%env(RABBITMQ_QUEUE_NAME)%']

Continue reading “RabbitMQ Work Queue with Symfony”

Symfony – Create a service – the right way

Always create service interface for your service. This way you will have better structured code and phpunit testing will be real pleasure.
Also use dependency injection for your repositories in the service.

Service Interface Example

interface UserServiceInterface{
  public function getUsername();
  public function viewAll();

Service Example

class UserService implements UserServiceInterface

  private $entityManager;
  private $userRepository;

  public function __construct(EntityManager $entityManager, UserRepository $userRepository)
    $this->entityManager = $entityManager;
    $this->userRepository = $userRepository;

  public function viewAll()
    return $this->userRepository->findAll();

Repository Example

class UserRepository extends \Doctrine\ORM\EntityRepository
  public function __construct(EntityManager $em, Mapping\ClassMetadata $metadata = null)
      $metadata == null ?
      new Mapping\ClassMetadata(User::class) :

Symfony Security Authorization

There are several way to make authorization on your site with Symfony.
First is in your security.yml on the same level as firewalls tag:

        - { path: ^/admin, roles: ROLE_USER }

This will block all users that don’t have ‘ROLE_USER’ to admin page.

Second option is to use Controller. Inside Method insert:

            throw $this->createAccessDeniedException('GET OUT!');

Or like this:


This will deny access to all users that don’t have ‘ROLE_ADMIN’ to this method.

You can also use annotations:

* @Security("is_granted('ROLE_ADMIN')")

Annotations also work if you add them to the Class. So they will block all users that don’t have ‘ROLE_ADMIN’ to this class.

Continue reading “Symfony Security Authorization”