获取用于querybuilder的实体中的用户电子邮件 - Symfony

Question

How I can get the logged user email in entity for query builder to select items which has been created by current user?

My entity field:

->add('rfqitem', 'entity', array(
    'label'         => 'RFQ Items',
    'class'         => 'RFQ\IronilBundle\Entity\RFQItem',
    'multiple'      => true,
    'expanded'      => false,
    'attr'          => array(
        'class'         => 'rfq-item-choser'),
    'query_builder' => function ($eer){
        return $eer
            ->createQueryBuilder('a')
            ->where('a.user_email = :email')
            ->setParameter('email', 'LOGGED USER EMAIL');},
))

Create form method:

$user = $this->get('security.context')->getToken();
$form = $this->createForm(new RFQType(), $user, $entity, array(
   'action' => $this->generateUrl('rfq_create'),
   'method' => 'POST',
   'user' => $this->getUser()
));

Answer 1

For that you will have to pass the logged in user to the form.

To pass the user as an option to your Form class, you can do this:

public function buildForm(FormBuilderInterface $builder, array $options)
{
    $user = $options['user'];

    $builder
        ->add('rfqitem', 'entity', array(
            /** other options **/
            'query_builder' => function ($eer) use ($user) {
                return $eer
                    ->createQueryBuilder('a')
                    ->where('a.user_email = :email')
                    ->setParameter('email', $user->getEmail());
            },
        ))
    ;
}

public function setDefaultOptions(OptionsResolverInterface $resolver)
{
    /** lot's of code **/

    $resolver->setRequired(array(
        'user',
    ));
}

Then, when you create the form on the controller, you pass the logged in user this way:

$form = $this->createForm(new YourFormType(), $yourObject, array('user' => $this->getUser()));

Update: For your code, it should be like this:

$user = $this->get('security.context')->getToken();
$form = $this->createForm(new RFQType(), $entity, array(
   'action' => $this->generateUrl('rfq_create'),
   'method' => 'POST',
   'user' => $user,
));