view) { case 'contribution': /** * 计算用户贡献度 * 算法:统计句子历史记录里的用户贡献句子的数量 * TODO: * 应该祛除重复的句子,一个句子的多次修改只计算一次 * 只统计一个月内的数值 */ $result = SentHistory::select('user_uid') ->selectRaw('count(*)') ->groupBy('user_uid') ->orderBy('count','desc') ->take(10) ->get(); $userinfo = new \UserInfo(); foreach ($result as $key => $user) { # code... $user->username = $userinfo->getName($user->user_uid); } return $this->ok($result); break; default: # code... break; } } /** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { // } /** * Display the specified resource. * * @param \App\Models\SentHistory $sentHistory * @return \Illuminate\Http\Response */ public function show(SentHistory $sentHistory) { // } /** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param \App\Models\SentHistory $sentHistory * @return \Illuminate\Http\Response */ public function update(Request $request, SentHistory $sentHistory) { // } /** * Remove the specified resource from storage. * * @param \App\Models\SentHistory $sentHistory * @return \Illuminate\Http\Response */ public function destroy(SentHistory $sentHistory) { // } }