public function home() { $data['users'] = User::get()->count(); $data['fusers'] = User::whereSex('female')->get()->count(); $data['posts'] = Post::get()->count(); $data['cposts'] = Post::whereType('0')->get()->count(); $data['cpoll'] = Question::orderBy('id', 'desc')->first(); $data['vfcpoll'] = UsersAnswer::whereQuestionId($data['cpoll']->id)->get()->count(); $posts = PostReport::select(DB::raw('post_id, count(*) as rcount'))->groupBy(['post_id'])->orderBy('rcount', 'desc')->get(); $data['rposts'] = ''; $i = 0; foreach ($posts as $key) { $post = Post::find($key->post_id); $data['rposts'][$i++] = ['id' => $post->id, 'text' => $post->post, 'uid' => $post->user_id, 'disable' => User::find($post->user_id)->disable, 'type' => $post->type, 'total' => $key->rcount, 'r1' => PostReport::wherePostId($post->id)->whereReportId(1)->get()->count(), 'r2' => PostReport::wherePostId($post->id)->whereReportId(2)->get()->count(), 'r3' => PostReport::wherePostId($post->id)->whereReportId(3)->get()->count()]; } return View::make('admin.home', $data); }
public function createReport() { try { $post_report = PostReport::wherePostId(Input::get('pid'))->whereUserId(Auth::user()->id)->whereReportId(Input::get('rid'))->first(); if ($post_report) { return 'false'; } $post_report = new PostReport(); $post_report->post_id = Input::get('pid'); $post_report->user_id = Auth::user()->id; $post_report->report_id = Input::get('rid'); if ($post_report->save()) { return 'true'; } else { return 'false'; } } catch (Exception $e) { return 'false'; } }