public function postEditUser($user_id)
{
$winner = new Winner();
$winner->user_id = $user_id;
$winner->position = Input::get('position');
$winner->save();
return Redirect::route('getEditUser', $user_id);
}
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);
}
$range = range(1, 42);
shuffle($range);
$num = 6;
$r = array();
for ($i = 0; $i < $num; $i++) {
$r[] = $range[$i];
}
$shuffled = $num == 1 ? $r[0] : $r;
sort($shuffled, SORT_NUMERIC);
// SAVE THE WINNING NUMBER TO DATABASE
$draw = Draw::where("date", "=", $date)->update(array('numbers' => implode(",", $shuffled), 'status' => 'closed'));
// FIND WINNERS
$bets = Bet::where("draw_id", "=", $draw_id)->where("numbers", "=", implode(",", $shuffled));
// GET NUMBER OF WINNERS AND DIVIDED IT
$price = $draw_winning_price / $bets->count();
// WINNERS
$winners = $bets->get();
// SAVE WINNERS TO DATABASE
foreach ($winners as $winner) {
$w = new Winner();
$w->draw_id = $draw_id;
$w->winning_numbers = implode(",", $shuffled);
$w->winning_price = $price;
$w->ticket_number = $winner->ticket_number;
$w->security_code = $winner->security_code;
$w->draw_date = $date;
$w->save();
echo "Winner Saved";
}
}
}
}
$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);
});
try {
$entry = new Entry();
$entry->setEmail($email);
$entry->setName($name);
$entry->setIpAddr($_SERVER['REMOTE_ADDR']);
$em->persist($entry);
$em->flush();
} catch (Exception $e) {
die('{"status": 401, message: "Sorry, you have already entered once this round."}');
}
$query = $em->createQuery('SELECT COUNT(e.id) FROM Entry e');
$count = $query->getSingleScalarResult();
if ($count >= 3) {
$prizes = $em->getRepository('Prize')->findBy(array('awarded' => false));
$prize = $prizes[array_rand($prizes)];
$prize->setAwarded(true);
$offset = max(0, rand(0, 2));
$query = $em->createQuery('SELECT DISTINCT e FROM Entry e')->setMaxResults(1)->setFirstResult($offset);
$winningEntry = $query->getScalarResult()[0];
$winner = new Winner();
$winner->setEmail($winningEntry['e_email']);
$winner->setName($winningEntry['e_name']);
$winner->setIpAddr($winningEntry['e_ip_addr']);
$winner->setPrize($prize);
$em->persist($prize);
$em->persist($winner);
$em->flush();
$em->createQuery('DELETE FROM Entry')->execute();
}
echo '{"status": 200, message: "Thanks, your entry has been submitted!"}';
exit;
public function checkWinner($player)
{
$winner = new Winner();
$winner->checkWinner($this->board, $player);
return $winner->getWinner();
}
public function actionGetByID()
{
if ($this->getRole() != 2) {
return;
}
$request = Yii::app()->getRequest();
$wid = $request->getParam('wid');
$winner = Winner::model()->findByPk($wid);
$this->responseJSON($winner, "success");
}
public function winners()
{
$winners = Winner::with('user')->get();
return View::make('user.winners')->with('winners', $winners);
}
