如何在yii2 queryParams中设置OR条件？

Question

I've this code

  public function actionIndex() {
    $model = new Out();
    $searchModel = new VatoutFakturOutSearch();
    if (Yii::$app->request->post('hasEditable')) {

    $userId = Yii::$app->user->id;
    $searchModel->user_id = $userId;
$searchModel->parent_id = $userId;
    $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
    $dataProvider->pagination->pageSize = 100;

    return $this->render('index', [
                'searchModel' => $searchModel,
                'model' => $model,
                'dataProvider' => $dataProvider,
    ]);
}

for actionIndex, for showing my index page. with code above it will show data which has user_id==$userId AND parent_id==$userId.

But that's not what I need, what I need is the page show data which has user_id==$userId OR parent_id==$userId.

How do I can do that?

How do I can set OR condition in queryParams?

Thanks

Answer 1

In your search() method just simply add andWhere() condition:

$query->andWhere(['or',
        ['user_id' => $this->user_id],
        ['parent_id' => $this->user_id],
]);

Or in controller:

$dataProvider->query->andWhere(['or',
        ['user_id' => $userId],
        ['parent_id' => $userId],
]);