Symfony - 按定义状态呈现视图

Question

I defined status field in my db table like

        $newPlay->setStatus(Plays::STATUS_PUBLISHED);

that is now saved in that db table.

I need to render a view with fields that have that status.

I made an api call for that but I keep getting an error

Controller "AppBundle\Website\Controller\PublishedTicketsController::publishedTicketsAction()" requires that you provide a value for the "$status" argument. Either the argument is nullable and no null value has been provided, no default value has been provided or because there is a non optional argument after this one.

This is my api call..

    /**
 * @Route("/published-tickets", name="published_tickets")
 * @param Request $request
 * @return \Symfony\Component\HttpFoundation\Response
 * @throws \Exception
 */

public function publishedTicketsAction(Request $request, $status)
{

    $query = $this->getDoctrine()
        ->getRepository('AppBundle:Plays')->findBy(['status' => $status]);

    return $this->render('@FrontTemplates/pages/published-tickets.html.twig', array(
        'query' => $query,
        'status' => $status
    ));
}

Answer 1

I have done it like this..

In my service..

    public function publishedTicket()
{
    $query = $this->getPlaysRepository()
        ->createQueryBuilder('t')
        ->select('t')
        ->where('t.status =:status')
        ->setParameter('status', Plays::STATUS_PUBLISHED)
        ->getQuery()
        ->getResult();

    return $query;
}

and in my controller

$playPublish = $this->container->get('publish.tickets')->publishedTicket();

    return $this->render('@FrontTemplates/pages/published-tickets.html.twig', array(
        'playPublish' => $playPublish
    ));

this is the part I could't figure out..

->setParameter('status', Plays::STATUS_PUBLISHED)