- my ($self, $id) = @_;
- my $job = $self->jobs->find($id, {prefetch => ['problem', 'owner', 'contest']});
- my %params = $job->get_columns;
- $params{owner_name} = $job->owner->name;
- $params{problem_name} = $job->problem->name;
- $params{contest_name} = $job->contest->name if $params{contest};
- $params{results} &&= decode_json $params{results};
- $params{size} = length $params{source};
- delete $params{source};
- \%params
+ my ($id) = @_;
+ my $ret = add_names query(job_entry_sth => $id)->hash;
+ $ret->{results} = decode_json $ret->{results} if $ret->{results};
+ $ret
+}
+
+sub job_full {
+ my ($id) = @_;
+ scalar query(job_full_sth => $id)->hash
+}
+
+sub create_job {
+ my (%args) = @_;
+ $db->update('users', {lastjob => time});
+ purge '/log/';
+ scalar $db->insert('jobs', \%args, {returning => 'id'})->list
+}
+
+sub calc_score {
+ my ($mxscore, $time, $tries, $totaltime) = @_;
+ my $score = $mxscore;
+ $time = 300 if $time > $totaltime; # uncoverable branch true does not happen anymore (only possible if opens are broken)
+ $score = ($totaltime - $time) / $totaltime * $score;
+ $score -= $tries / 10 * $mxscore;
+ $score = $mxscore * 3 / 10 if $score < $mxscore * 3 / 10;
+ int $score + 0.5
+}
+
+sub standings {
+ my ($ct) = @_;
+ $ct = contest_entry $ct;
+
+ my @problems = query(contest_problems_sth => $ct->{id})->flat;
+ my $pblist = problem_list;
+ my %values = query('problem_values_sth')->map;
+
+ my (%scores, %tries, %opens);
+ my $opens = query(opens_sth => $ct->{id});
+ while ($opens->into(my ($problem, $owner, $time))) {
+ $opens{$problem, $owner} = $time;
+ }
+
+ 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}{$_} // '-'} @problems],
+ }
+ } keys %scores;
+
+ $st[0]->{rank} = 1 if @st;
+ $st[$_]->{rank} = $st[$_ - 1]->{rank} + ($st[$_]->{score} < $st[$_ - 1]->{score}) for 1 .. $#st;
+ +{
+ st => \@st,
+ problems => [map { [ $_, object_name(problems => $_)] } @problems],
+ }