public function allPosts(Request $request) { $posts = Posts::get(); return $posts; }
}); /** * API */ Route::get('api/users', ['middleware' => 'cors', function () { return \Response::json(\App\User::get(), 200); }]); Route::get('api/markers', ['middleware' => 'cors', function () { return \Response::json(\App\Mark::get(), 200); }]); Route::post('api/markers', ['middleware' => 'cors', function () { return \Response::json(\App\Mark::get(), 200); }]); Route::get('api/contributors', ['middleware' => 'cors', function () { return \Response::json(\App\Contributor::get(), 200); }]); Route::get('api/posts', ['middleware' => 'cors', function () { return \Response::json(\App\Posts::get(), 200); }]); Route::get('api/news', ['middleware' => 'cors', function () { return \Response::json(\App\Posts::get(), 200); }]); Route::post('oauth/access_token', function () { return Response::json(Authorizer::issueAccessToken()); }); Route::get('email', function () { Mail::raw('Novo voluntário cadastrado', function ($m) { $m->to('*****@*****.**', 'Marilia sem Dengue')->bcc('*****@*****.**', 'Marilia sem Dengue')->subject('Novo voluntário cadastrado no site'); }); return \Redirect::to('/home'); });
break; case "delete": if (!Permission::sufficient('staff')) { Response::fail(); } if (!$Database->whereEp($Episode)->delete('episodes')) { Response::dbError(); } Logs::action('episodes', array('action' => 'del', 'season' => $Episode->season, 'episode' => $Episode->episode, 'twoparter' => $Episode->twoparter, 'title' => $Episode->title, 'airs' => $Episode->airs)); $CGDb->where('name', "s{$Episode->season}e{$Episode->episode}")->delete('tags'); Response::success('Episode deleted successfuly', array('upcoming' => Episodes::getSidebarUpcoming(NOWRAP))); break; case "requests": case "reservations": $only = $action === 'requests' ? ONLY_REQUESTS : ONLY_RESERVATIONS; $posts = Posts::get($Episode, $only); switch ($only) { case ONLY_REQUESTS: $rendered = Posts::getRequestsSection($posts); break; case ONLY_RESERVATIONS: $rendered = Posts::getReservationsSection($posts); break; } Response::done(array('render' => $rendered)); break; case "vote": if (isset($_REQUEST['detail'])) { $VoteCountQuery = $Database->rawQuery("SELECT count(*) as value, vote as label\n\t\t\t\tFROM episodes__votes v\n\t\t\t\tWHERE season = ? && episode = ?\n\t\t\t\tGROUP BY v.vote\n\t\t\t\tORDER BY v.vote ASC", array($Episode->season, $Episode->episode)); $VoteCounts = array('labels' => array(), 'datasets' => array(array('data' => array()))); foreach ($VoteCountQuery as $row) {