笔记 · 2017-03-23 17:27 · 957 阅读

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

PHP

        $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");