首页 > 解决方案 > 单页中的多个分页 - yii2 framewrok

问题描述

控制器 =>

public function getPagination($query, $pageSize) {

    $queryDataCount = new Pagination(['totalCount' => $query->count()]);

    $queryDataCount->setPageSize($pageSize);

    $paginatedData = $query->offset($queryDataCount->offset)
    ->limit($queryDataCount->limit)
    ->all();   

    return array($paginatedData, $queryDataCount);
}

$queryMonthly   = QuizLeaderboard::find()
->select(['SUM(score) as totalScore', 'SUM(time) as totalTime', 'userId'])
->where(['between', 'currentDate', $monthStart, $monthEnd])
->asArray();

$paginatedQueryMonthly = $this->getPagination($queryMonthly, 10);       
//$paginatedQueryMonthly[1]->pageParam = 'list1Page';

$queryWeekly   = QuizLeaderboard::find()
->select(['SUM(score) as totalScore', 'SUM(time) as totalTime', 'userId'])
->where(['between', 'currentDate', $monthStartSec, $monthEndSec])
->asArray();

 $paginatedQueryWeekly =$this->getPagination($queryWeekly, 10);
 $paginatedQueryWeekly[1]->pageParam = 'list2Page';



$queryTwoWeeks   = QuizLeaderboard::find()
 ->select(['SUM(score) as totalScore', 'SUM(time) as totalTime', 'userId'])
 ->where(['between', 'currentDate', $monthStartTh, $monthEndTh])
 ->asArray();

 $paginatedQueryTwoWeeks =$this->getPagination($queryTwoWeeks, 10);
 $paginatedQueryTwoWeeks[1]->pageParam = 'list3Page';

这就是我向视图发送数据的方式=>

 return $this->render('summarize-report', [

            'queryMonthly' => $paginatedQueryMonthly[0],
            'pagesQueryMonthly' => $paginatedQueryMonthly[1],

            'queryWeekly' => $paginatedQueryWeekly[0],
            'pagesQueryWeekly' => $paginatedQueryWeekly[1],

            'queryTwoWeeks' => $paginatedQueryTwoWeeks[0],
            'pagesQueryTwoWeeks' => $paginatedQueryTwoWeeks[1],
            'reports' => $query,
   ]);

查看=>

echo LinkPager::widget([‘pagination’ => $pagesQueryWeekly,]);

echo LinkPager::widget([‘pagination’ => $pagesQueryTwoWeeks,]);

echo LinkPager::widget([ ‘pagination’ => $pagesQueryMonthly,]);

我在一页中有三个分页器。我为每个分页设置了不同的 pageParam。但是,分页不会改变页面。谁能帮我找出问题所在?

标签: phpyii2

解决方案


推荐阅读