迭代某些领域排序的学说集合 [英] Iterate Doctrine Collection ordered by some field

问题描述

我需要这样的东西:

        $products = Products::getTable()->find(274);
        foreach ($products->Categories->orderBy('title') as $category)
        {
            echo "{$category->title}<br />";
        }

我知道这是不可能的，但是......如果不创建 Doctrine_Query，我怎么能做这样的事情?

I know is it not possible, but... How can I do something like this without creating a Doctrine_Query?

谢谢.

推荐答案

我只是在看同样的问题.您需要将 Doctrine_Collection 转换为数组:

I was just looking at the same problem. You need to convert the Doctrine_Collection into an array:

$someDbObject = Doctrine_Query::create()...;
$children = $someDbObject->Children;
$children = $children->getData(); // convert from Doctrine_Collection to array

然后你可以创建一个自定义排序函数并调用它:

Then you can create a custom sort function and call it:

// sort children
usort($children, array(__CLASS__, 'compareChildren')); // fixed __CLASS__

compareChildren 看起来像这样:

Where compareChildren looks something like:

private static function compareChildren($a, $b) {
   // in this case "label" is the name of the database column
   return strcmp($a->label, $b->label);
}

这篇关于迭代某些领域排序的学说集合的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！