blocks|key|80468|text|正如@Lighthart所示，是的，这是可能的，尽管它向控制器添加了大量脂肪并且不是干燥的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|80469|你真的应该在实体存储库中定义你自己的查询，这是简单和最佳的实践。|80470|use+Doctrine\ORM\EntityRepository;

class+UserRepository+extends+EntityRepository
{
++++public+function+findAll()
++++{
++++++++return+$this->findBy(array(),+array('username'+=>+'ASC'));
++++}
}|code-block|syntax|javascript|80471|然后，您必须告诉您的实体在存储库中查找查询：|80472|/**
+*+@ORM\Table(name="User")
+*+@ORM\Entity(repositoryClass="Acme\UserBundle\Entity\Repository\UserRepository")
+*/
class+User
{
++++...
}|80473|最后，在你的控制器中：|80474|$this->getDoctrine()->getRepository('AcmeBundle:User')->findAll();|80475|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

As @Lighthart as shown, yes it's possible, although it adds significant fat to the controller and isn't DRY.

You should really define your own query in the entity repository, it's simple and best practice.

<pre><code>use Doctrine\ORM\EntityRepository;

class UserRepository extends EntityRepository
{
 public function findAll()
 {
 return $this-&gt;findBy(array(), array('username' =&gt; 'ASC'));
 }
}
</code></pre>

Then you must tell your entity to look for queries in the repository:

<pre><code>/**
 * @ORM\Table(name="User")
 * @ORM\Entity(repositoryClass="Acme\UserBundle\Entity\Repository\UserRepository")
 */
class User
{
 ...
}
</code></pre>

Finally, in your controller:

<pre><code>$this-&gt;getDoctrine()-&gt;getRepository('AcmeBundle:User')-&gt;findAll();
</code></pre>

blocks|key|80523|text|$this->getDoctrine()->getRepository('MyBundle:MyTable')->findBy([],+['username'+=>+'ASC']);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|80524|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>$this-&gt;getDoctrine()-&gt;getRepository('MyBundle:MyTable')-&gt;findBy([], ['username' =&gt; 'ASC']);
</code></pre>

blocks|key|297845|text|简单：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|297846|$this->getDoctrine()->getRepository('AcmeBundle:User')->findBy(
++++array(),
++++array('username'+=>+'ASC')
);|code-block|syntax|javascript|297847|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Simple:

<pre><code>$this-&gt;getDoctrine()-&gt;getRepository('AcmeBundle:User')-&gt;findBy(
 array(),
 array('username' =&gt; 'ASC')
);
</code></pre>

blocks|key|80619|text|有时查看源代码是很有用的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|80620|例如，findAll实现非常简单(vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php)：|offset|length|style|CODE|80621|public+function+findAll()
{
++++return+$this->findBy(array());
}|code-block|syntax|javascript|80622|因此，我们查看findBy并找到我们需要的(orderBy)|80623|public+function+findBy(array+$criteria,+array+$orderBy+=+null,+$limit+=+null,+$offset+=+null)|80624|entityMap^0|0|3|7|H|1L|0|0|7|6|M|7|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@$D|U|E|V|F|G]|$D|W|E|X|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|Y|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|Z|8|@$D|10|E|11|F|G]|$D|12|E|13|F|G]]|9|@]|A|$]]|$1|O|3|P|5|J|7|14|8|@]|9|@]|A|$K|L]]|$1|Q|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|R|$]]

It's useful to look at source code sometimes.

For example <code>findAll</code> implementation is very simple (<code>vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php</code>):

<pre><code>public function findAll()
{
 return $this-&gt;findBy(array());
}
</code></pre>

So we look at <code>findBy</code> and find what we need (<code>orderBy</code>)

<pre><code>public function findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
</code></pre>

blocks|key|297713|text|这对我来说很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|297714|$entities+=+$em->getRepository('MyBundle:MyTable')->findBy(array(),array('name'+=>+'ASC'));|code-block|syntax|javascript|297715|保持第一个数组为空会取回所有数据，这在我的例子中是有效的。|297716|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This works for me:

<pre><code>$entities = $em-&gt;getRepository('MyBundle:MyTable')-&gt;findBy(array(),array('name' =&gt; 'ASC'));
</code></pre>

Keeping the first array empty fetches back all data, it worked in my case.

blocks|key|297591|text|您需要使用条件，例如：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|297592|<?php

namespace+Bundle\Controller;

use+Symfony\Bundle\FrameworkBundle\Controller\Controller;
use+Symfony\Component\HttpFoundation\Request;
use+Doctrine\Common\Collections\Criteria;

/**
*+Thing+controller
*/
class+ThingController+extends+Controller
{
++++public+function+thingsAction(Request+$request,+$id)
++++{
++++++++$ids=explode(',',$id);
++++++++$criteria+=+new+Criteria(null,+<<DQL+ordering+expression>>,+null,+null+);

++++++++$rep++++=+$this->getDoctrine()->getManager()->getRepository('Bundle:Thing');
++++++++$things+=+$rep->matching($criteria);
++++++++return+$this->render('Bundle:Thing:things.html.twig',+[
++++++++++++'entities'+=>+$things,
++++++++]);
++++}
}|code-block|syntax|javascript|297593|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You need to use a criteria, for example:

<pre><code>&lt;?php

namespace Bundle\Controller;

use Symfony\Bundle\FrameworkBundle\Controller\Controller;
use Symfony\Component\HttpFoundation\Request;
use Doctrine\Common\Collections\Criteria;

/**
* Thing controller
*/
class ThingController extends Controller
{
 public function thingsAction(Request $request, $id)
 {
 $ids=explode(',',$id);
 $criteria = new Criteria(null, &lt;&lt;DQL ordering expression&gt;&gt;, null, null );

 $rep = $this-&gt;getDoctrine()-&gt;getManager()-&gt;getRepository('Bundle:Thing');
 $things = $rep-&gt;matching($criteria);
 return $this-&gt;render('Bundle:Thing:things.html.twig', [
 'entities' =&gt; $things,
 ]);
 }
}
</code></pre>

blocks|key|297801|text|查看Doctrine+API源代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|297802|class+EntityRepository{
++...
++public+function+findAll(){
++++return+$this->findBy(array());
++}
++...
}|code-block|syntax|javascript|297803|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Look at the Doctrine API source-code :

<pre><code>class EntityRepository{
 ...
 public function findAll(){
 return $this-&gt;findBy(array());
 }
 ...
}
</code></pre>

blocks|key|297906|text|Symfony中的findBy方法除两个参数外。第一个是要搜索的字段数组，第二个数组是排序字段及其顺序|type|unstyled|depth|inlineStyleRanges|entityRanges|data|297907|public+function+findSorted()
++++{
++++++++return+$this->findBy(['name'=>'Jhon'],+['date'=>'DESC']);
++++}|code-block|syntax|javascript|297908|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

findBy method in Symfony excepts two parameters. First is array of fields you want to search on and second array is the the sort field and its order

<pre><code>public function findSorted()
 {
 return $this-&gt;findBy(['name'=&gt;'Jhon'], ['date'=&gt;'DESC']);
 }
</code></pre>

blocks|key|297674|text|您可以使用数组迭代器对现有的ArrayCollection进行排序。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|297675|假设$collection是由findAll()返回的ArrayCollection|297676|$iterator+=+$collection->getIterator();
$iterator->uasort(function+($a,+$b)+{
++++return+($a->getPropery()+<+$b->getProperty())+?+-1+:+1;
});
$collection+=+new+ArrayCollection(iterator_to_array($iterator));|code-block|syntax|javascript|297677|这可以很容易地转换为一个函数，您可以将其放入存储库中，以便创建findAllOrderBy()方法。|297678|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You can sort an existing ArrayCollection using an array iterator. 

assuming $collection is your ArrayCollection returned by findAll()

<pre><code>$iterator = $collection-&gt;getIterator();
$iterator-&gt;uasort(function ($a, $b) {
 return ($a-&gt;getPropery() &lt; $b-&gt;getProperty()) ? -1 : 1;
});
$collection = new ArrayCollection(iterator_to_array($iterator));
</code></pre>

This can easily be turned into a function you can put into your repository in order to create findAllOrderBy() method.

blocks|key|297726|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|297727|$em+=+$this->getDoctrine()->getManager();

$entities+=+$em->getRepository('MyBundle:MyTable')->findBy(array(),+array('username'+=>+'ASC'));|code-block|syntax|javascript|297728|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this:

<pre><code>$em = $this-&gt;getDoctrine()-&gt;getManager();

$entities = $em-&gt;getRepository('MyBundle:MyTable')-&gt;findBy(array(), array('username' =&gt; 'ASC'));
</code></pre>

blocks|key|80729|text|修改EntityRepository中的默认findAll函数，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|80730|public+function+findAll(+array+$orderBy+=+null+)
{
++++return+$this->findBy([],+$orderBy);
}|code-block|syntax|javascript|80731|这样，您就可以对任何数据表的任何查询使用''findAll'‘，并提供对查询进行排序的选项|80732|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Modify the default findAll function in EntityRepository like this:

<pre><code>public function findAll( array $orderBy = null )
{
 return $this-&gt;findBy([], $orderBy);
}
</code></pre>

That way you can use the ''findAll'' on any query for any data table with an option to sort the query

I've been reading Doctrine's documentation, but I haven't been able to find a way to sort findAll() Results. 

I'm using symfony2 + doctrine, this is the statement that I'm using inside my Controller:

<code>$this-&gt;getDoctrine()-&gt;getRepository('MyBundle:MyTable')-&gt;findAll();</code>

but I want the results to be ordered by ascending usernames.

I've been trying to pass an array as an argument this way:

<code>findAll( array('username' =&gt; 'ASC') );</code>

but it doesn't work (it doesn't complain either). 

Is there any way to do this without building a DQL query?

How to sort findAll Doctrine's method?

我一直在阅读Doctrine的文档，但我还没有找到一种对findAll()结果进行排序的方法。我使用的是symfony2 +原则，这是我在控制器中使用的语句：$this->getDoctrine()->getRepository('MyBundle:MyTable')->findAll();但我希望结果是按用户名升序排序的。我一直在尝试以这种方式传递一个数组作为参数：findAll( array(

问如何对findAll主义的方法进行排序？
EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何对findAll主义的方法进行排序？EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何对findAll主义的方法进行排序？
EN