How to list query result in form (EntityType)

Viewed 1412

In my project I use data form one table (user task) to describe data to create Reservation record (reservation table). In form I try received select list.

When run it's error :

Expected argument of type "Doctrine\ORM\QueryBuilder", "array" given

Why "array" data is wrong? What change?

My code:

Form:

<?php
namespace AppBundle\Form;
use AppBundle\Repository\TaskRepository;
use Symfony\Bridge\Doctrine\Form\Type\EntityType;
use Symfony\Component\Form\AbstractType;
use Symfony\Component\Form\FormBuilderInterface;
use Symfony\Component\OptionsResolver\OptionsResolver;

/**
 * Class ReservationType
 *
 * @package AppBundle\Form
 */
class ReservationType extends AbstractType
{
  /**
   * {@inheritdoc}
   */
  public function buildForm( FormBuilderInterface $builder, array $options )
  {
    $builder
      ->add( 'taskId', EntityType::class, [
        'class' => 'AppBundle:Task',
        'query_builder' => function (TaskRepository $tr) use ($options) {
          return $tr->TaskUserListQuery( $options['userId']);
        },
        'attr' => [
          'data-type' => 'text',
          'class' => 'table-select',
          'disabled' => true
        ],
        'required' => false
      ])
    ;
  }

  /**
   * {@inheritdoc}
   */
  public function configureOptions( OptionsResolver $resolver )
  {
    $resolver->setDefaults( [
                  'data_class' => 'AppBundle\Entity\Task',
                  'userId'  => null,
                ] );
  }


  /**
   * {@inheritdoc}
   */
  public function getBlockPrefix()
  {
    return 'appbundle_reservation';
  }
}

Repository:

<?php
namespace AppBundle\Repository;
use \Doctrine\ORM\EntityRepository;

/**
 * TaskRepository
 */
class TaskRepository extends EntityRepository
{
  /**
   * Function TaskUserListQuery
   * @return array
   */
  public function TaskUserListQuery( $userId )
  {
    return $this->createQueryBuilder( 't' )
      ->select(
        't.id',
        't.taskName'
      )
      ->orderBy( 't.id', 'ASC' )
      ->where( 't.userId = :par1' )
      ->setParameter( 'par1', $userId )
      ->getQuery()
      ->getResult();
  }
}

Controller:

<?php

namespace AppBundle\Controller;

use AppBundle\Entity\Reservation;
use Symfony\Bundle\FrameworkBundle\Controller\Controller;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Method;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
use Symfony\Component\HttpFoundation\Request;

/**
 * Reservation controller.
 *
 * @Route("/re")
 */
class ReservationController extends Controller
{

  /**
   * Creates a new reservation entity.
   *
   * @Route("/new", name="r_new")
   * @Method({"GET", "POST"})
   */
  public function newAction( Request $request )
  {
    $userId = 1;

    $reservation = new Reservation();
    $tableForm = $this->createForm( 'AppBundle\Form\ReservationType', $reservation, [
      'userId' => $userId,
    ] );
    $form = $tableForm->createView();
    $form->handleRequest( $request );

    if ($form->isSubmitted() && $form->isValid()) {
      $em = $this->getDoctrine()->getManager();
      $em->persist( $reservation );
      $em->flush();

      return $this->redirectToRoute( 'r_show', [ 'id' => $reservation->getId() ] );
    }

    return $this->render( 'reservation/new.html.twig', [
      'reservation'  => $reservation,
      'form'     => $form->createView(),
    ] );
  }

   // (... more)

}

When I make mistake?

I'm learn form example and run on Symfony 3.2. Please help me.

2 Answers
Related