Также как в ActiveDataProvider
$query = new \yii\db\Query;
$dataProvider = new \yii\data\ArrayDataProvider([
'allModels' => $query->from('o_oem_detal')
->select('id')
->andWhere(['or LIKE', 'oem', '%'.$out_oem.'%', false])
->andWhere(['between', 'date(date)', $time, $time2])
->all(),
]);
И даже полнотекстовый поиск массивом
$oem = [11, 17, sdsdf, qwerrt ];
$query = new \yii\db\Query;
$data = new \yii\data\ArrayDataProvider([
'allModels' => $query->from('oem')
->andWhere("MATCH(naim) AGAINST ('$oem' IN BOOLEAN MODE)")
->limit(10)
->all(),
]);