$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");
发表回复