<?php

namespace app\common\fun;

use think\db;

class Jfrank

{

    /**

     * @param string $day 日期单位  day天 week周  month月

     * @param int $num   具体日期数字1  比如1天  1周  1月

     *  @param int $rows 返回行数

     * @return array

     */

    public function ranking($row=10,$day='week',$num=1){

        $array =[];

        $map['posttime'] = fun('time@only',$day,$num);

        $map['money']  = ['>',0];

       $rs =  Db::name('moneylog')->field('uid,SUM(money) as s_money')

            ->where($map)

            ->group('uid')

            ->order('s_money desc')

            ->limit($rows)

            ->select();

        foreach($rs As $arr){

            $uid = $arr['uid'];

            $info = Db::name('memberdata')->where('uid',$uid)->find();

            $array[] = array_merge($info,$arr);

        }

        return $array;

    }

}

<h2>本周积分排行</h2>

{volist name=":fun('Jfrank@ranking')" id="rs"}

    <div>

        <span><img src="{$rs.icon|tempdir}" width="20" height="20" /></span>&nbsp;

        <span>{$rs.username}</span>&nbsp;

        <span>本周总赚取的积分：{$rs.s_money}</span>

    </div>

{/volist}