phalcon使用model搜索時(shí)如果實(shí)現(xiàn)distinct功能？

使用構(gòu)建器:

先搞個(gè)基礎(chǔ):

$queryBuilder = $this->getDI()->getModelsManager()
    ->createBuilder()
    ->addFrom('tableName', 't');

直接用Distinct:

$queryBuilder->distinct('t.id');

用列方法也可以, 不推薦：

$queryBuilder->columns('DISTINCT(t.id) AS id')

使用嚴(yán)格模型:

// we are waiting for it, but may still not be implemented
TableModel::find(array('distinct' => 'id'))
For count:

TableModel::count(array("distinct" => "id"));
And less recommended way according to previous answer:

TableModel::find(array('columns' => 'distinct(id)'))

抄襲自so
https://stackoverflow.com/a/3...