How to view the result of a request in the form (EntityType)

Question

In my project, I use the data form of one table (user task) to describe the data for creating a reservation record (reservation table). In the form, I will try to get a selection list.

When starting the error:

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

Why is the "array" data incorrect? What changed?

My code is:

the 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 am I wrong?

I am learning a form example and running Symfony 3.2. Please help me.

Answer 1

Also, you cannot call a method handleRequeston an object FormView.

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

TaskRepository

public function TaskUserListQuery( $userId )
{
    return $this->createQueryBuilder( 't' )
        ->select('t') // in this way
        ->orderBy( 't.id', 'ASC' )
        ->where( 't.userId = :par1' )
        ->setParameter( 'par1', $userId );
}

, ('t.id',...) QueryBuilder

array:1 [▼
  0 => array:2 [▼
    "id" => 1
    "task_name" => "New Task"
  ]
]

EntityType ,

array:1 [▼
  0 => Task {#448 ▶}
]

, 'choice_label' => 'task_name' buildForm.

Answer 2

querybuilder query_builder . :

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