Yii2 关联子查询

$dataProvider->query
            ->andWhere(['>=', 'rf_agency_cupboard.status', StatusEnum::DISABLED])
            ->joinWith([
                'point',
                'memberCabinet' => function (ActiveQuery $query){
                    return $query->joinWith(
                        [
                            'member' => function (ActiveQuery $query){
                                return $query
                                    ->andFilterWhere(['realname'=>Yii::$app->request->get('realname')])
                                    ->andFilterWhere(['mobile'=>Yii::$app->request->get('mobile')]);
                            }
                        ]
                    );
                }
            ]);
0
0

发表回复

Your email address will not be published. Required fields are marked *.

*
*