php按照,php 按照排名来分页的功能

最新推荐文章于 2021-11-03 14:17:57 发布

weixin_39611070

最新推荐文章于 2021-11-03 14:17:57 发布

阅读量123

点赞数

文章标签： php按照

该博客介绍了如何使用PHP实现商户的排行榜功能，包括获取上月的数据统计，并展示商户的用户数量排名。代码中涉及了时间条件查询、分组、排序以及LIMIT分页操作，同时展示了如何获取当前登录商户的排名和用户数量。

摘要由CSDN通过智能技术生成

// 排行榜

public function ranklist(){

$type = $this->_get('type','trim');

$this->assign('type',$type);

$opener_id = $this->opener_id;

if($type == 0){ // 上月排行

$arrLastMonth = $this->getLastMonthStartEndDay();

$lastStartDay = $arrLastMonth['lastStartDay'];

$lastEndDay = $arrLastMonth['lastEndDay'].' 23:59:59';

$b_time = strtotime($lastStartDay);

$e_time = strtotime($lastEndDay);

$where['b.addtime'] = array(array('gt',$b_time),array('lt',$e_time),'and');

}

$where['a.status'] = array('eq','1');

M()->query('SET @rank =0;');

$subQuery = M()->table('sh_opener a')->join('sh_user b on a.id = b.opener_id')->where($where)->group('a.id')->order('usercount desc')->field('a.id,count(b.id) as usercount,a.name')->select(false);

$all = M()->table(''.$subQuery.' a')->getField('a.id,a.usercount,a.name,(@rank:=IFNULL(@rank,0)+1) as rank');

$count = count($all);

$Page = new Page($count, 10);

$list = M()->table('sh_opener a')->join('sh_user b on a.id = b.opener_id')->where($where)->group('a.id')->order('usercount desc')->limit($Page->firstRow.','.$Page->listRows)->field('count(b.id) as usercount,a.name,a.id')->select();

foreach ($list as $k => $v) {

$list[$k]['rank'] = $k + 1 + $Page->firstRow;

}

// 我的商户

$my_user_count = $all[$opener_id]['usercount']?$all[$opener_id]['usercount']:0;

$my_rank = $all[$opener_id]['rank']?$all[$opener_id]['rank']:'-';

$this->assign('my_user_count',$my_user_count);

$this->assign('my_rank',$my_rank);

$this->assign('page',$Page->show());

$this->assign('list', $list);

$this->display();

}