public static function apiDownload(Request $r)
{
self::authenticateRequest($r);
self::validateStats($r);
// Get our runs
$relevant_columns = array("run_id", "guid", "language", "status", "verdict", "runtime", "penalty", "memory", "score", "contest_score", "time", "submit_delay", "Users.username", "Problems.alias");
try {
$runs = RunsDAO::search(new Runs(array("contest_id" => $r["contest"]->getContestId())), "time", "DESC", $relevant_columns);
} catch (Exception $e) {
// Operation failed in the data layer
throw new InvalidDatabaseOperationException($e);
}
$zip = new ZipStream($r["contest_alias"] . '.zip');
// Add runs to zip
$table = "guid,user,problem,verdict,points\n";
foreach ($runs as $run) {
$zip->add_file_from_path("runs/" . $run->getGuid(), RunController::getSubmissionPath($run));
$columns[0] = 'username';
$columns[1] = 'alias';
$usernameProblemData = $run->asFilteredArray($columns);
$table .= $run->getGuid() . "," . $usernameProblemData['username'] . "," . $usernameProblemData['alias'] . "," . $run->getVerdict() . "," . $run->getContestScore();
$table .= "\n";
}
$zip->add_file("summary.csv", $table);
// Add problem cases to zip
$contest_problems = ContestProblemsDAO::GetRelevantProblems($r["contest"]->getContestId());
foreach ($contest_problems as $problem) {
$zip->add_file_from_path($problem->getAlias() . "_cases.zip", PROBLEMS_PATH . "/" . $problem->getAlias() . "/cases.zip");
}
// Return zip
$zip->finish();
die;
}
public static function RefreshScoreboardCache($contest_id)
{
try {
$contest = ContestsDAO::getByPK($contest_id);
$contest_runs = RunsDAO::GetContestRuns($contest_id);
// Get all distinct contestants participating in the contest given contest_id
$raw_contest_users = RunsDAO::GetAllRelevantUsers($contest_id, true, null);
// Get all problems given contest_id
$raw_contest_problems = ContestProblemsDAO::GetRelevantProblems($contest_id);
} catch (Exception $e) {
throw new InvalidDatabaseOperationException($e);
}
$problem_mapping = array();
$order = 0;
foreach ($raw_contest_problems as $problem) {
$problem_mapping[$problem->problem_id] = array('order' => $order++, 'alias' => $problem->alias);
}
$scoreboardLimit = Scoreboard::getScoreboardTimeLimitUnixTimestamp($contest);
// Cache scoreboard until the contest ends (or forever if it has already ended).
$timeout = max(0, strtotime($contest->getFinishTime()) - time());
$contestantScoreboardCache = new Cache(Cache::CONTESTANT_SCOREBOARD_PREFIX, $contest_id);
$contestantScoreboard = Scoreboard::getScoreboardFromRuns($contest_runs, $raw_contest_users, $problem_mapping, $contest->getPenalty(), $scoreboardLimit, $contest, false, false);
$contestantScoreboardCache->set($contestantScoreboard, $timeout);
$adminScoreboardCache = new Cache(Cache::ADMIN_SCOREBOARD_PREFIX, $contest_id);
$scoreboardLimit = Scoreboard::getScoreboardTimeLimitUnixTimestamp($contest, true);
$adminScoreboard = Scoreboard::getScoreboardFromRuns($contest_runs, $raw_contest_users, $problem_mapping, $contest->getPenalty(), $scoreboardLimit, $contest, true, false);
$adminScoreboardCache->set($adminScoreboard, $timeout);
$contestantEventCache = new Cache(Cache::CONTESTANT_SCOREBOARD_EVENTS_PREFIX, $contest_id);
$contestantEventCache->set(Scoreboard::calculateEvents($contest, $contest_runs, $raw_contest_users, $problem_mapping, false), $timeout);
$adminEventCache = new Cache(Cache::ADMIN_SCOREBOARD_EVENTS_PREFIX, $contest_id);
$adminEventCache->set(Scoreboard::calculateEvents($contest, $contest_runs, $raw_contest_users, $problem_mapping, true), $timeout);
// Try to broadcast the updated scoreboards:
$log = Logger::getLogger('Scoreboard');
try {
$grader = new Grader();
$log->debug('Sending updated scoreboards');
$grader->broadcast($contest->alias, json_encode(array('message' => '/scoreboard/update/', 'scoreboard' => $adminScoreboard)), false, -1, false);
$grader->broadcast($contest->alias, json_encode(array('message' => '/scoreboard/update/', 'scoreboard' => $contestantScoreboard)), true, -1, true);
} catch (Exception $e) {
$log->error('Error broadcasting scoreboard: ' . $e);
}
}
public static function apiDownload(Request $r)
{
self::authenticateRequest($r);
self::validateStats($r);
// Get our runs
$relevant_columns = array('run_id', 'guid', 'language', 'status', 'verdict', 'runtime', 'penalty', 'memory', 'score', 'contest_score', 'time', 'submit_delay', 'Users.username', 'Problems.alias');
try {
$runs = RunsDAO::search(new Runs(array('contest_id' => $r['contest']->getContestId())), 'time', 'DESC', $relevant_columns);
} catch (Exception $e) {
// Operation failed in the data layer
throw new InvalidDatabaseOperationException($e);
}
$zip = new ZipStream($r['contest_alias'] . '.zip');
// Add runs to zip
$table = "guid,user,problem,verdict,points\n";
foreach ($runs as $run) {
$zip->add_file_from_path('runs/' . $run->getGuid(), RunController::getSubmissionPath($run));
$columns[0] = 'username';
$columns[1] = 'alias';
$usernameProblemData = $run->asFilteredArray($columns);
$table .= $run->getGuid() . ',' . $usernameProblemData['username'] . ',' . $usernameProblemData['alias'] . ',' . $run->getVerdict() . ',' . $run->getContestScore();
$table .= "\n";
}
$zip->add_file('summary.csv', $table);
// Add problem cases to zip
$contest_problems = ContestProblemsDAO::GetRelevantProblems($r['contest']->getContestId());
foreach ($contest_problems as $problem) {
$zip->add_file_from_path($problem->getAlias() . '_cases.zip', PROBLEMS_PATH . '/' . $problem->getAlias() . '/cases.zip');
}
// Return zip
$zip->finish();
die;
}
