ActiveDataProvide pagination for Join tables?

Yii 2.0 General Discussions
1

How i do it?


   


$MovieData = seanse::find()->innerJoinWith(['idMovie','idRoom']

        )->where(['active'=>'active'])

            ->asArray()->groupBy('name')->all();


  


        $provider = new ActiveDataProvider([

            'query' => $MovieData, 

            'pagination' => [

                'totalCount'=>5, // count all record? 

                'pageSize' => 1,

I have pagination widget but he don’t working


<?php

echo \yii\widgets\LinkPager::widget([

    'pagination' => $provider->pagination

])


    ?>
2

$MovieData has to be an ActiveQuery instance.

So




$MovieData = seanse::find()->innerJoinWith(['idMovie','idRoom']

        )->where(['active'=>'active'])->groupBy('name');
3

But if i don’t give ->all() i gets Trying to get property of non-object

view




     <?php if (empty($MovieData)) echo 'Dziś brak filmów!';?>

    <?php foreach ($MovieData as $item):


        ?>





        <div class="row -align-center">

            <div class="col-sm-6 col-md-4 col-lg-offset-4">

                <div class="thumbnail">

                    <?= Html::img( Yii::$app->urlManagerBackend->baseUrl.'/uploads/'.$item->idMovie->images->src,[])?>

                    <div class="caption">


                        <p class="center-block" style="font-size:10px; color:#03225C;"><?= $item->idMovie->name?></p>

                        <p style="font-size:10px; color;"><?= $item['idMovie']['title']?></p>

                        <p style="font-size:10px; color;">

                        <p style="font-size:10px; color;">Czas Trwania:<?= $item->idMovie->length?>min</p>

                        <p style="font-size:10px; color;">Wiek:<?= $item->idMovie->requirments?></p>

                         <?php foreach ($date as $items):?>

                        <?php if (!Yii::$app->user->isGuest && $items['idMovie']==$item->idMovie && $items['data']>=date('Y-m-d')) echo Html::a($items['data'],['repertuar/rezerwuj','id' =>$items['id_seans']],['class'=>'btn btn-primary btn-xs'])?></p>

                        <?php endforeach;?>

                    </div>

                </div>

            </div>

        </div>

    <?php endforeach;?>

</div>

<?php

echo \yii\widgets\LinkPager::widget([

    'pagination' => $provider->pagination

])


    ?>

</body>
4

Where do you use ActiveDataProvider ?

5

I thought it working with LinkerPage. I would like create pagination witchout using listView/GridView etc. So i Should use ? http://www.yiiframework.com/doc-2.0/yii-data-pagination.html this?