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|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|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|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|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|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|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|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|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|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

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>

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?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

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

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

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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