yii2 Error: Call to a member fun

折腾了两个小时，翻到官方论坛。按下面的修改。

控制器代码

......
$data = (new \yii\db\Query()) //Order::find()

            ->select(['od.id as id', 'cust.realname as memname', 'mp.categary_name as catename', 'od.status as status'])

            ->from('rf_member_order od')

            ->leftJoin('rf_member as cust', 'cust.id = od.member_id')

            ->leftJoin('rf_member_myproduct as mp', 'mp.id = od.product_id')

            ->andFilterWhere(['od.merchant_id' => $this->getMerchantId()])

            ->all();

$pages = new Pagination(['totalCount' => $data->count(), 'pageSize' => $this->pageSize]); $models = $data->offset($pages->offset) ->orderBy('id desc') ->limit($pages->limit) ->all();

......

调试报错

Error: Call to a member function count()

Error: Call to a member function andFilterWhere() 

Error: Call to a member function offset() 

原因和办法

去除代码最后的->all()。

调用all方法不会得到一个ActiveQuery实例，而是一个ActiveRecord数组。即使去换调换成count($data) ，还会报offset()的错误。

At the end of $query definition, you call ->all() method, so you will not have an ActiveQuery instance but an ActiveRecord arrays.Remove ->all() at the end of $query definition to continue adding conditions.

$data = (new \yii\db\Query()) //Order::find()

            ->select(['od.id as id', 'cust.realname as memname', 'mp.categary_name as catename', 'od.status as status'])

            ->from('rf_member_order od')

            ->leftJoin('rf_member as cust', 'cust.id = od.member_id')

            ->leftJoin('rf_member_myproduct as mp', 'mp.id = od.product_id')

            ->andFilterWhere(['od.merchant_id' => $this->getMerchantId()]);

            ->all();