activerecord - Yii2如何在活动记录中使用内置的mysql功能

Question

Yii2活动记录中如何使用内置的MySQL功能？这是我想在活动记录中隐藏的查询。

以及如何实现相同的SearchModel？

SELECT * FROM `dts_track` where concat(date_received,time_received) != concat(date_released,time_released)

标签： activerecordyii2

Answer 1

您可以使用字符串格式作为 where

public function search($params)
{
    $query = YourModel::find();

    $dataProvider = new ActiveDataProvider([
        'query' => $query,
    ]);

    if (!($this->load($params) && $this->validate())) {
        return $dataProvider;
    }

    $query->andWhere('concat(date_received,time_received) != concat(date_released,time_released)');

    return $dataProvider;
}