Custom Query in Symfony Form

Question

createQueryBuilder Query Working fine Form, when i try to write custom Query using EntityManager its showing warning. EntityManager not available.

Controller :

$form = $this->createForm(new ContractsType($user, $isAdmin, $securityContext), $contract, array('em' => $em, 'referring_student' => $contract->getReferringStudent()));

ContractsType

class ContractsType extends AbstractType {

$queryBuilder = function($repo) use ($user) {

return $repo->createQueryBuilder('p')
    ->leftJoin('p.employees', 'e')
    ->where('e.id = :employee_id')
    ->setParameter('employee_id', $user->getId())
    ->orderBy('p.name', 'ASC');
}
  $builder->add('store', 'entity', array(
        'class' => 'C2EducateToolsBundle:Stores',
        'label' => 'Center',
        'query_builder' => $queryBuilder,
        'property' => 'name',
        'empty_value' => 'Select')
    );
    }

createQueryBuilder working Fine, but I want to write custom Query using EntityManager, How can I make the entity Equery available here. so that I can Run the below Query.

$storesQuery = "select store_id as id,ts.name as name from tbl_employees e LEFT JOIN tbl_stores ts ON e.store_id=ts.id where e.id=:employeesId  AND ts.center_type_id!=:centerTypeId AND ts.select_option = :selectOption";
            $em = $this->getDoctrine()->getEntityManager();
            $stmt = $em->getConnection()->prepare($storesQuery);
            $stmt->bindValue('employeesId', $user->getId());
            $stmt->execute();
            $listLocations = $stmt->fetchAll(\PDO::FETCH_ASSOC);

A custom repository class?

Peppermintology
– Peppermintology

2017-02-16 11:27:11 +00:00
Commented Feb 16, 2017 at 11:27 — Peppermintology
– Peppermintology, Commented Feb 16, 2017 at 11:27
Were you able to solve your problem?

rhinosforhire
– rhinosforhire

2017-02-26 07:15:20 +00:00
Commented Feb 26, 2017 at 7:15 — rhinosforhire
– rhinosforhire, Commented Feb 26, 2017 at 7:15

rhinosforhire · Accepted Answer · 2017-02-17 07:15:23Z

1

You can inject $em by making the form type a service.

# myBundle\config\services.yml
services:
    form.type.address:
        class: myBundle\Form\AddressType
        arguments: ['@doctrine.orm.entity_manager'] # We inject our familiar $em.

Meanwhile, in our form type:

// myBundle\Form\AddressType.php
// ...
Class AddressType
{
    protected $em;

    public function __construct(\Doctrine\ORM\EntityManager $em) // Type-hint so nothing funny gets in.
    {
        $this->em = $em; // And store it on our form type during instantiation.
    }

    public function buildForm(FormBuilderInterface $builder, array $options)
    {
        // ... Then use it in here!
    }
}

answered Feb 17, 2017 at 7:15

rhinosforhire

1,34511 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Виталий Бойко · Accepted Answer · 2017-02-16 16:38:55Z

1

You can use "choices" option for EntityType form, so you just execute query not in query builder but in your form type and result set to choices like

$query = ....;
$result = $query->execute();
$builder->add('store', 'entity', array(
    'class' => 'C2EducateToolsBundle:Stores',
    'label' => 'Center',
    'choices' => $result,
    'property' => 'name',
    'empty_value' => 'Select')
);

answered Feb 16, 2017 at 16:38

Виталий Бойко

363 bronze badges

2 Comments

Mohammad Fareed Over a year ago

Yes, You are Right, i want to write the query and pass the results, but problem in Entity Manager is not avaible there, how can i configure that.?

Виталий Бойко Over a year ago

I thought you already use it, because you pass $em in options, so you can get em by $em = $options['em']; Or you can pass em in service like in @Rhono answer

Collectives™ on Stack Overflow

Custom Query in Symfony Form

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related