php - How to use order by field in yii framework

Question

How to splice order by field in yii into orderBy? Now the sql is printed out, and the sql I need is like this. Please tell me how to solve this problem. This is based on the order by field(id,5,3 in mysql). ,8) Another point, in the Yii framework, I want to implement a certain field...

三叔 · Answer

->orderBy(["FIELD(step, 'star', 'person', 'team')" => true]) is OK, but I didn't look at the underlying code carefully. . . But it should solve the problem

/**
     * @param array $columns
     * @return string the ORDER BY clause built from [[Query::$orderBy]].
     */
    public function buildOrderBy($columns)
    {
        if (empty($columns)) {
            return '';
        }
        $orders = [];
        foreach ($columns as $name => $direction) {
            if ($direction instanceof Expression) {
                $orders[] = $direction->expression;
            } else {
                $orders[] = $this->db->quoteColumnName($name) . ($direction === SORT_DESC ? ' DESC' : '');
            }
        }

        return 'ORDER BY ' . implode(', ', $orders);
    }

This is a method to generate an orderby statement, so true has no real effect, but it is not equal to SORT_DESC and then becomes empty,

The more official way of writing it is like this:

orderBy([new Expression("FIELD(step, 'star', 'person', 'team')")])