php - 单页中的多个分页 - 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。但是,分页不会改变页面。谁能帮我找出问题所在?
解决方案
推荐阅读
- jquery - 组织图 - 第二次单击父节点时,所有节点都应打开
- mysql - 在其中一个表中组合两个表和两列的 MySQL 查询
- javascript - 来自 Web 表单的数据未添加到 Firebase
- spring - Spring-JDBC-Session 与 Hibernate 多租户
- c - Why do I keep getting a segmentation dump?
- java - 这些方法有什么用?
- python - 在 for 循环中使用输入值附加列表
- c# - 设置 HttpRuntime.WebObjectActivator 会使 HttpApplication.InitModulesCommon 抛出 NullReferenceException
- react-native - 如何使文本与行对齐?
- angular - 高级 AngularFirestore2 查询