public function winnerListCSV()
{
$table = Winner::orderBy('time', 'DESC')->get();
$output = 'id,username,prize,time' . "\n";
foreach ($table as $row) {
$output .= implode(",", $row->toArray()) . "\n";
}
$headers = ['Content-Type' => 'text/csv', 'Content-Disposition' => 'attachment; filename="winnerlist.csv"'];
return Response::make(rtrim($output, "\n"), 200, $headers);
}
}
$twig = Twig::get();
$template = $twig->loadTemplate('managers-winners.html');
echo $template->render(array());
});
$app->get('/managers/winners/request/', function () use($app) {
// AUTHENTICATION FIRST
if (!Sentry::check()) {
// User is not logged in, or is not activated
$app->status(401);
}
$user = Sentry::getUser();
if (!$user->isSuperUser()) {
$app->status(401);
}
$data = array();
$counter = 0;
$draws = Winner::orderBy('id', 'desc')->get()->toArray();
foreach ($draws as $draw) {
$data[$counter]['id'] = $draw['id'];
$data[$counter]['draw_id'] = $draw['draw_id'];
$data[$counter]['winning_numbers'] = $draw['winning_numbers'];
$data[$counter]['winning_price'] = number_format($draw['winning_price'], 2);
$data[$counter]['ticket_number'] = $draw['ticket_number'];
$data[$counter]['security_code'] = $draw['security_code'];
$data[$counter]['draw_date'] = $draw['draw_date'];
$counter++;
}
header("Content-Type:text/json");
echo json_encode(array(array('per_page' => 25, 'total_entries' => count($data), 'total_pages' => ceil(count($data) / 25), 'page' => 1), $data), JSON_NUMERIC_CHECK);
});
