src/Form/Slave/AssignTechnicianType.php line 11

Open in your IDE?
  1. <?php
  3. namespace App\Form\Slave;
  5. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  6. use Symfony\Component\Form\AbstractType;
  7. use Symfony\Component\Form\FormBuilderInterface;
  8. use Symfony\Component\OptionsResolver\OptionsResolver;
  9. use Doctrine\ORM\EntityRepository;
  11. class AssignTechnicianType extends AbstractType
  12. {
  13.     public function buildForm(FormBuilderInterface $builder, array $options)
  14.     {
  15.         $builder
  16.             ->add('technician', EntityType::class, array(
  17.                 'class' => 'App\Entity\Slave\User',
  18.                 'query_builder' => function (EntityRepository $er) { 
  19.                     return $er->createQueryBuilder('u')
  20.                     ->leftJoin('u.accountType', 'a')
  21.                     ->leftJoin('u.profile', 'p')
  22.                     ->leftJoin('a.category', 'atc')
  23.                     ->where('u.role != :roleAdmin')
  24.                     ->andWhere('atc.slug = :acTech1 OR atc.slug = :acTech2')
  25.                     ->andWhere('u.companyActive = 1')
  26.                     ->addOrderBy('p.surname', 'ASC')
  27.                     ->addOrderBy('p.name', 'ASC')
  28.                     ->setParameters(array('roleAdmin' => 'ROLE_ADMIN', 'acTech1' => 'tech-internal', 'acTech2' => 'tech-external'));
  29.                 },
  30.                 'choice_label' => function ($f) { return $f->displayNameAndCountTickets(); },
  31.                 'expanded' => false,
  32.                 'multiple' => false,
  33.                 'placeholder' => '',
  34.                 'mapped' => false
  35.             ));
  36.     }
  38.     public function configureOptions(OptionsResolver $resolver)
  39.     {
  40.         $resolver->setDefaults(array(
  41.             'data_class' => 'App\Form\Model\AssignTechnician',
  42.             'validation_groups' => array('assign_technician')
  43.         ));
  44.     }
  45. }