+
+ my $jobs = $db->select('job_entry', '*', {contest => $ct->{id}}, 'id');
+
+ while (my $job = $jobs->hash) {
+ my $open = $opens{$job->{problem}, $job->{owner}} // $ct->{start};
+ my $time = $job->{date} - $open;
+ next if $time < 0; # uncoverable branch true job sent before contest is deprecated
+ my $value = $values{$job->{problem}};
+ my $factor = $job->{result} ? 0 : 1;
+ $factor = $1 / 100 if $job->{result_text} =~ /^(\d+ )/s;
+ $scores{$job->{owner}}{$job->{problem}} = int ($factor * _calc_score ($value, $time, $tries{$job->{owner}}{$job->{problem}}++, $ct->{stop} - $ct->{start}));
+ }
+
+ my @st = sort { $b->{score} <=> $a->{score} or $a->{user} cmp $b->{user} } map { ## no critic (ProhibitReverseSortBlock)
+ my $user = $_;
+ +{
+ user => $user,
+ user_name => _object_name(users => $user),
+ score => sum (values %{$scores{$user}}),
+ scores => [map { $scores{$user}{$_->{id}} // '-'} @problems],
+ }
+ } keys %scores;
+
+ $st[0]->{rank} = 1 if @st;
+ $st[$_]->{rank} = $st[$_ - 1]->{rank} + ($st[$_]->{score} < $st[$_ - 1]->{score}) for 1 .. $#st;
+
+ \@st
+}
+
+sub update_status {
+ my $jobs = $db->select('jobs', 'id,owner,problem,result', {-not_bool => 'private'}, 'id');
+
+ my %hash;
+ while ($jobs->into(my ($id, $owner, $problem, $result))) {
+ $hash{$problem, $owner} = [$id, $result ? 0 : 1];
+ }
+
+ my @problem_statuses = map { [split ($;), @{$hash{$_}} ] } keys %hash;
+
+ my @contest_statuses = map {
+ my $ct = $_;
+ map { [$ct, $_->{user}, $_->{score}, $_->{rank}] } @{standings $ct}
+ } $db->select('contests', 'id')->flat;
+
+ $db->begin;
+ $db->delete('problem_status');
+ $db->query('INSERT INTO problem_status (problem,owner,job,solved) VALUES (??)', @$_) for @problem_statuses;
+ $db->delete('contest_status');
+ $db->query('INSERT INTO contest_status (contest,owner,score,rank) VALUES (??)', @$_) for @contest_statuses;
+ $db->commit
+}
+
+sub rerun_problem {
+ my ($problem) = @_;
+ _query rerun_problem_sth => $problem;
+ purge '/log/';
+}
+
+sub rerun_job {
+ my ($id) = @_;
+ _query rerun_job_sth => $id;
+ purge '/log/';
+ purge "/log/$id";
+}
+
+sub take_job {
+ my ($daemon) = @_;
+ my $id = _query(take_job_sth => $daemon)->list;
+ return unless $id;
+ purge '/log/';
+ purge "/log/$id";
+ db->select(jobs => '*', {id => $id})->hash
+}
+
+sub finish_job {
+ my ($job, $private, %args) = @_;
+ db->update(jobs => \%args, {id => $job->{id}});
+ purge '/log/';
+ purge '/log/' . $job->{id};
+ return if $private;
+ my $status = {
+ problem => $job->{problem},
+ owner => $job->{owner},
+ job => $job->{id},
+ solved => ($args{result} ? 0 : 1),
+ };
+ eval {
+ db->insert(problem_status => $status)
+ } or db->update(problem_status => $status, {owner => $job->{owner}, problem => $job->{problem}});
+ purge '/us/' . $job->{owner};
+}
+
+sub open_problem {
+ my ($contest, $problem, $owner, $time) = @_;
+ my $ct = contest_entry($contest);
+ return unless $ct->{id} && $time >= $ct->{start} && $time < $ct->{stop}; ## no critic (ProhibitNegativeExpressionsInUnlessAndUntilConditions)
+ eval { db->insert(opens => { ## no critic (RequireCheckingReturnValueOfEval)
+ contest => $contest,
+ problem => $problem,
+ owner => $owner,
+ time => $time}) };
+}
+
+my @PURGE_HOSTS = exists $ENV{PURGE_HOSTS} ? split ' ', $ENV{PURGE_HOSTS} : ();
+my $ht = HTTP::Tiny->new;
+
+sub purge {
+ $ht->request(PURGE => "http://$_$_[0]") for @PURGE_HOSTS;