我有一个名为'Team'的实体,其中有一个属性'budget'。 我只想打印出团队的属性,并希望预算最高的团队首先出现,其次是第二,第三... (降序)。
但是使用此代码时,它不起作用,我不明白为什么。
indexAction(控制器)
$em = $this->getDoctrine()->getManager();
$teams = $em->getRepository('FootballBundle:Team')->getAllTeamsSortedByDescBudget();
return $this->render('FootballBundle:Default:index.html.twig', array(
'teams' => $teams,
));
TeamRepository
public function getAllTeamsSortedByDescBudget()
{
$q = $this->createQueryBuilder('a');
$q->select()->from('FootballBundle:Team', 't')->orderBy('t.budget', 'DESC');
return $q->getQuery()->getResult();
}
twig view
<h1>Teams list</h1>
<ul>
{% for team in teams %}
<li>{{ team.name }} - {{ team.championship }} - {{ team.budget|number_format(2, '.', ',') }}£</li>
{% endfor %}
<br/>
</ul>
Team.php实体
/**
* @var integer
*
* @ORM\Column(name="budget", type="integer")
*/
private $budget;
在这里,结果呈现如下...
Teams list
Manchester City FC - Premier League - 100,000,000.00£
Arsenal FC - Premier League - 50,000,000.00£
Leicester City - Premier League - 20,000,000.00£
Crystal Palace FC - Premier League - 5,000,000.00£
Chelsea FC - Premier League - 100,000,000.00£
切尔西...哈哈
编辑:已更正!请看takeit的评论。
budget
属性和映射是怎样的? - takeitpublic function getAllTeamsSortedByDescBudget() { $q = $this->createQueryBuilder('t')->orderBy('t.budget', 'DESC'); return $q->getQuery()->getResult(); }
- takeitfindBy()
中的第二个数组来对结果进行排序呢?$teams = $em->getRepository('FootballBundle:Team')->findBy(array(), array('budget' => 'DESC'));
- Egg