yii2 ActiveRecord通过计算查找订单 [英] yii2 ActiveRecord Find OrderBy with calculation
本文介绍了yii2 ActiveRecord通过计算查找订单的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
尝试从我的数据库中获取描述. 该查询返回结果,但我想对结果进行排序,以仅显示投票率最高的结果.
Trying to fetch a description from my database. The query returns the result but I would like to order the result to only show the one with the highest vote.
投票应通过upvoted
列减去downvoted
列
$description = UnitDescription::find()
->where(['id_unit' => $model->id])
->orderBy([
'upvoted - downvoted' => SORT_DESC //Need this line to be fixed
])
->one();
我希望有人可以写出查询的这一部分-谢谢
I was hoping someone might have a way to write this part of the query - Thanks
推荐答案
您应该尝试:
$description = UnitDescription::find()
->where(['id_unit' => $model->id])
->orderBy(['(upvoted - downvoted)' => SORT_DESC])
->one();
这篇关于yii2 ActiveRecord通过计算查找订单的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文