php - yii2 ActiveRecord 通过计算查找 OrderBy

Question

试图从我的数据库中获取描述。查询返回结果，但我想命令结果只显示得票最高的那个。

投票应由 upvoted 列减去 downvoted 列计算

$description = UnitDescription::find()
   ->where(['id_unit' => $model->id])
   ->orderBy([
      'upvoted - downvoted' => SORT_DESC //Need this line to be fixed
   ])
   ->one();

我希望有人可以编写这部分查询 - 谢谢

Answer 1

你应该尝试一下:

$description = UnitDescription::find()
    ->where(['id_unit' => $model->id])
    ->orderBy(['(upvoted - downvoted)' => SORT_DESC])
    ->one();