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) {
