m\modules\v1\controllers\OrderController::actionIndex PHP Method

    public function actionIndex()
    {
        $count = Yii::$app->db->createCommand('SELECT COUNT(*) FROM {{%order}} WHERE user_id=:uid AND status<>:deleted', [':uid' => Yii::$app->user->id, ':deleted' => Order::STATUS_DELETED])->queryScalar();
        $dataProvider = new SqlDataProvider(['sql' => 'SELECT t0.id, t0.order_sn, t0.status, t0.real_fee, t0.created_at, t1.name AS store_name, t2.cover AS first_cover FROM {{%order}} AS t0 LEFT JOIN {{%store}} AS t1 ON t0.store_id=t1.id LEFT JOIN {{%order_goods}} AS t2 ON t2.id=(SELECT MIN(t2.id) FROM {{%order_goods}} AS t2 WHERE t0.id=t2.order_id) WHERE t0.user_id=:uid AND t0.status<>:deleted ORDER BY t0.id DESC', 'params' => [':uid' => Yii::$app->user->id, ':deleted' => Order::STATUS_DELETED], 'totalCount' => (int) $count, 'pagination' => ['pageSize' => 10]]);
        return $dataProvider;
    }