在Symfony2中只显示与当前用户id相等的结果


Show only results equal to current user id in Symfony2

我有一个Gecko包,它在index.html.twig文件中循环并显示数据库中的所有Gecko,它工作得很好,没有问题。

然而,我想做的是只显示与当前用户id相同的用户id链接到它们的壁虎。

索引文件如下:

{% extends '::base.html.twig' %}
{% block body -%}
    <h1>Gecko list</h1>
    <table class="records_list">
        <thead>
            <tr>
                <th>Id</th>
                <th>Name</th>
                <th>Aquisitiondate</th>
                <th>Morph</th>
                <th>Sex</th>
                <th>Genetics</th>
                <th>Bio</th>
                <th>Bred</th>
                <th>Hatchling</th>
                <th>Clutch</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
        {% for entity in entities %}
            <tr>
                <td><a href="{{ path('gecko_show', { 'name': entity.name }) }}">{{ entity.name }}</a></td>
                <td>{{ entity.name }}</td>
                <td>{% if entity.aquisitionDate %}{{ entity.aquisitionDate|date('Y-m-d H:i:s') }}{% endif %}</td>
                <td>{{ entity.morph }}</td>
                <td>{{ entity.sex }}</td>
                <td>{{ entity.genetics }}</td>
                <td>{{ entity.bio }}</td>
                <td>{{ entity.bred }}</td>
                <td>{{ entity.hatchling }}</td>
                <td>{{ entity.clutch }}</td>
                <td>
                <ul>
                    <li>
                        <a href="{{ path('gecko_show', { 'name': entity.name }) }}">show</a>
                    </li>
                    <li>
                        <a href="{{ path('gecko_edit', { 'name': entity.name }) }}">edit</a>
                    </li>
                </ul>
                </td>
            </tr>
        {% endfor %}
        </tbody>
    </table>
        <ul>
        <li>
            <a href="{{ path('gecko_new') }}">
                Create a new entry
            </a>
        </li>
    </ul>
    {% endblock %}

如何限制视图?

编辑:

Gecko控制器:

<?php
namespace Breedr'GeckoBundle'Controller;
use Symfony'Component'HttpFoundation'Request;
use Symfony'Bundle'FrameworkBundle'Controller'Controller;
use Sensio'Bundle'FrameworkExtraBundle'Configuration'Method;
use Sensio'Bundle'FrameworkExtraBundle'Configuration'Route;
use Sensio'Bundle'FrameworkExtraBundle'Configuration'Template;
use Breedr'GeckoBundle'Entity'Gecko;
use Breedr'GeckoBundle'Form'GeckoType;
/**
 * Gecko controller.
 *
 * @Route("/gecko")
 */
class GeckoController extends Controller
{
    /**
     * Lists all Gecko entities.
     *
     * @Route("/", name="gecko")
     * @Method("GET")
     * @Template()
     */
    public function indexAction()
    {
        $em = $this->getDoctrine()->getManager();
        $entities = $em->getRepository('BreedrGeckoBundle:Gecko')->findAll();
        return array(
            'entities' => $entities,
        );
    }
    /**
     * Creates a new Gecko entity.
     *
     * @Route("/", name="gecko_create")
     * @Method("POST")
     * @Template("BreedrGeckoBundle:Gecko:new.html.twig")
     */
    public function createAction(Request $request)
    {
        $entity = new Gecko();
        $entity->setUser($this->getUser());
        $form = $this->createCreateForm($entity);
        $form->handleRequest($request);
        if ($form->isValid()) {
            $em = $this->getDoctrine()->getManager();
            $em->persist($entity);
            $em->flush();
            return $this->redirect($this->generateUrl('gecko_show', array('name' => $entity->getName())));
        }
        return array(
            'entity' => $entity,
            'form'   => $form->createView(),
        );
    }
    /**
     * Creates a form to create a Gecko entity.
     *
     * @param Gecko $entity The entity
     *
     * @return 'Symfony'Component'Form'Form The form
     */
    private function createCreateForm(Gecko $entity)
    {
        $form = $this->createForm(new GeckoType(), $entity, array(
            'action' => $this->generateUrl('gecko_create'),
            'method' => 'POST',
        ));
        $form->add('submit', 'submit', array('label' => 'Create'));
        return $form;
    }
    /**
     * Displays a form to create a new Gecko entity.
     *
     * @Route("/new", name="gecko_new")
     * @Method("GET")
     * @Template()
     */
    public function newAction()
    {
        $entity = new Gecko();
        $form   = $this->createCreateForm($entity);
        return array(
            'entity' => $entity,
            'form'   => $form->createView(),
        );
    }
    /**
     * Finds and displays a Gecko entity.
     *
     * @Route("/{name}", name="gecko_show")
     * @Method("GET")
     * @Template()
     */
    public function showAction($name)
    {
        $em = $this->getDoctrine()->getManager();
        $entity = $em->getRepository('BreedrGeckoBundle:Gecko')->findOneByName($name);
        if (!$entity) {
            throw $this->createNotFoundException('Unable to find Gecko entity.');
        }
        $deleteForm = $this->createDeleteForm($name);
        return array(
            'entity'      => $entity,
            'delete_form' => $deleteForm->createView(),
        );
    }
    /**
     * Displays a form to edit an existing Gecko entity.
     *
     * @Route("/{name}/edit", name="gecko_edit")
     * @Method("GET")
     * @Template()
     */
    public function editAction($name)
    {
        $em = $this->getDoctrine()->getManager();
        $entity = $em->getRepository('BreedrGeckoBundle:Gecko')->findOneByName($name);
        if (!$entity) {
            throw $this->createNotFoundException('Unable to find Gecko entity.');
        }
        $editForm = $this->createEditForm($entity);
        $deleteForm = $this->createDeleteForm($name);
        return array(
            'entity'      => $entity,
            'edit_form'   => $editForm->createView(),
            'delete_form' => $deleteForm->createView(),
        );
    }
    /**
    * Creates a form to edit a Gecko entity.
    *
    * @param Gecko $entity The entity
    *
    * @return 'Symfony'Component'Form'Form The form
    */
    private function createEditForm(Gecko $entity)
    {
        $form = $this->createForm(new GeckoType(), $entity, array(
            'action' => $this->generateUrl('gecko_update', array('name' => $entity->getName())),
            'method' => 'PUT',
        ));
        $form->add('submit', 'submit', array('label' => 'Update'));
        return $form;
    }
    /**
     * Edits an existing Gecko entity.
     *
     * @Route("/{name}", name="gecko_update")
     * @Method("PUT")
     * @Template("BreedrGeckoBundle:Gecko:edit.html.twig")
     */
    public function updateAction(Request $request, $name)
    {
        $em = $this->getDoctrine()->getManager();
        $entity = $em->getRepository('BreedrGeckoBundle:Gecko')->findOneByName($name);
        if (!$entity) {
            throw $this->createNotFoundException('Unable to find Gecko entity.');
        }
        $deleteForm = $this->createDeleteForm($name);
        $editForm = $this->createEditForm($entity);
        $editForm->handleRequest($request);
        if ($editForm->isValid()) {
            $em->flush();
            return $this->redirect($this->generateUrl('gecko_edit', array('name' => $name)));
        }
        return array(
            'entity'      => $entity,
            'edit_form'   => $editForm->createView(),
            'delete_form' => $deleteForm->createView(),
        );
    }
    /**
     * Deletes a Gecko entity.
     *
     * @Route("/{name}", name="gecko_delete")
     * @Method("DELETE")
     */
    public function deleteAction(Request $request, $name)
    {
        $form = $this->createDeleteForm($name);
        $form->handleRequest($request);
        if ($form->isValid()) {
            $em = $this->getDoctrine()->getManager();
            $entity = $em->getRepository('BreedrGeckoBundle:Gecko')->findOneByName($name);
            if (!$entity) {
                throw $this->createNotFoundException('Unable to find Gecko entity.');
            }
            $em->remove($entity);
            $em->flush();
        }
        return $this->redirect($this->generateUrl('gecko'));
    }
    /**
     * Creates a form to delete a Gecko entity by id.
     *
     * @param mixed $id The entity id
     *
     * @return 'Symfony'Component'Form'Form The form
     */
    private function createDeleteForm($name)
    {
        return $this->createFormBuilder()
            ->setAction($this->generateUrl('gecko_delete', array('name' => $name)))
            ->setMethod('DELETE')
            ->add('submit', 'submit', array('label' => 'Delete'))
            ->getForm()
        ;
    }
}
编辑2:

来自Gecko实体:

    /**
     * @ORM'ManyToOne(targetEntity="Breedr'UserBundle'Entity'User", inversedBy="geckos")
     * @ORM'JoinColumn(name="user_id", referencedColumnName="id")
     */
    protected $user;
class GeckoController extends Controller
{
    /**
     * Lists all Gecko entities.
     *
     * @Route("/", name="gecko")
     * @Method("GET")
     * @Template()
     */
    public function indexAction()
    {
        $em = $this->getDoctrine()->getManager();
        $user = $this->getUser();
        $entities = $em->getRepository('BreedrGeckoBundle:Gecko')->findBy('user' => $user->getId());
        return array(
            'entities' => $entities,
        );
    }

我们必须在View之前获取user,所以我们可以通过

获取它
$user = $this->getUser();
这里描述

从FOSUserBundle中登录的用户获取用户id

下一步是通过用户对象

从存储库中获取数据

根据用户对象选择

$entities = $em
        ->getRepository('BreedrGeckoBundle:Gecko')
        ->findBy(array('user' => $user), array()
    );