thinkphp 关于日排行,周排行,月排行

发表于

        $Model = M('Ranking');
        $day   = $Model->query("select *,sum(hits) from cmf_ranking where day(date)=day(now()) group by object_id order by sum(hits) desc");
        $week  = $Model->query("select *,sum(hits) from cmf_ranking where week(date)=week(now()) group by object_id order by sum(hits) desc");
        $month = $Model->query("select *,sum(hits) from cmf_ranking where month(date)=month(now()) group by object_id order by sum(hits) desc");
        $data['pro'] = $project->query("select *,sum(post_like) from cmf_project where day(FROM_UNIXTIME(add_time))=day(now()) group by id order by sum(post_like) desc");
        $week        = $project->query("select *,sum(post_like) from cmf_project where week(FROM_UNIXTIME(add_time))=week(now()) group by id order by sum(post_like) desc");
        $month       = $project->query("select *,sum(post_like) from cmf_project where month(FROM_UNIXTIME(add_time))=month(now()) group by id order by sum(post_like) desc");
$data  = $project->query("select *,sum(post_like) from cmf_project where status=1 group by id order by week(FROM_UNIXTIME(add_time)) desc,sum(post_like) desc");
 
 

评论

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注