php微信公眾平臺(tái)開發(fā)之微信群發(fā)信息
688
2024-01-26
本文實(shí)例分析了thinkPHP統(tǒng)計(jì)排行與分頁(yè)顯示功能。分享給大家供大家參考，具體如下：
1.分頁(yè)參數(shù)
count 總數(shù) firstRow 起始行 listRows 每一次獲取記錄數(shù) list 每一頁(yè)的記錄（要與count對(duì)應(yīng)一致就行）
2.分頁(yè)對(duì)象
可以針對(duì)真實(shí)的數(shù)據(jù)表
也可以針對(duì)統(tǒng)計(jì)出來(lái)的數(shù)據(jù)表，或者說(shuō)是虛擬的表
因?yàn)長(zhǎng)IMIT是最后執(zhí)行的，哪怕你進(jìn)行g(shù)roup操作，哪怕你進(jìn)行子查詢
html
<include file="Public:head" title="" />
<style type="text/css">
.top {
font-size: 18px;
border-bottom: #ddd 1px solid;
margin-bottom: -1px;
font-weight: bold;
}
.top .title {
margin:10px;
border:1px solid #EF6C00;
display:-webkit-box;
border-radius: 3px;
}
.top .title .title_child {
width: 50%;
line-height:40px;
-webkit-box-flex:1;
display:block;
color:#EF6C00;
text-decoration:none;
}
.top .title .title_child.active {
color:#FFF;
background:#EF6C00;
}
.page{
margin-right: 10px;
}
.ranknum{
font-weight: bold;
color:#F92672;
}
#myrank{
color: #FFF;
font-weight:bold;
background-color: #FBC853;
}
</style>
<script type="text/javascript">
</script>
<body>
<div class="top text-center">
<div class="title">
<a class="title_child <if condition='$type neq 1'>active</if>" , array('type' => 0))}">月排行</a>
<a class="title_child <if condition='$type eq 1'>active</if>" , array('type' => 1))}">總排行</a>
</div>
</div>
<div id="myrank" class="alert alert-danger text-center">
我的商戶數(shù):{sh:$my_user_count} 當(dāng)前排名: {sh:$my_rank}
</div>
<div id="datalist">
<table class="table table-hover">
<thead>
<tr>
<th> #</th>
<th>姓名</th>
<th>商戶數(shù)</th>
</tr>
</thead>
<tbody>
<volist name="list" id="vo">
<tr>
<th scope="row" class="ranknum">
<if condition="$vo.rank eq 1"><img src="http://www.gimoo.net/t/1807/{sh::RES}public/img/gold.png" style="width: 30px;">
<elseif condition="$vo.rank eq 2"/><img src="http://www.gimoo.net/t/1807/{sh::RES}public/img/silver.png" style="width: 30px;">
<elseif condition="$vo.rank eq 3"/><img src="http://www.gimoo.net/t/1807/{sh::RES}public/img/copper.png" style="width: 30px;">
<else />
{sh:$vo.rank}
</if>
</th>
<td>{sh:$vo.name}</td>
<td>{sh:$vo.usercount}</td>
</tr>
</volist>
</tbody>
</table>
<div class="page text-right">
{sh:$page}
</div>
</div>
</body>
</html>
php
// 排行榜
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();
}
// 獲取上一月開始與結(jié)束日期
private function getLastMonthStartEndDay(){
$thismonth = date('m');
$thisyear = date('Y');
if ($thismonth == 1) {
$lastmonth = 12;
$lastyear = $thisyear - 1;
} else {
$lastmonth = $thismonth - 1;
$lastyear = $thisyear;
}
$lastStartDay = $lastyear . '-' . $lastmonth . '-1';
$lastEndDay = $lastyear . '-' . $lastmonth . '-' . date('t', strtotime($lastStartDay)); //t 給定月份所應(yīng)有的天數(shù),28到31
return array('lastStartDay'=>$lastStartDay,'lastEndDay'=>$lastEndDay);
}
這里用的是thinkphp的分頁(yè)類實(shí)現(xiàn)的。
案例效果
更多關(guān)于thinkPHP相關(guān)內(nèi)容感興趣的讀者可查看本站專題：《ThinkPHP入門教程》、《thinkPHP模板操作技巧總結(jié)》、《ThinkPHP常用方法總結(jié)》、《codeigniter入門教程》、《CI(CodeIgniter)框架進(jìn)階教程》、《Zend FrameWork框架入門教程》、《smarty模板入門基礎(chǔ)教程》及《PHP模板技術(shù)總結(jié)》。
希望本文所述對(duì)大家基于ThinkPHP框架的PHP程序設(shè)計(jì)有所幫助。
