+sub job_list {
+ my ($self, %args) = @_;
+ $args{page} //= 1;
+ my %where = (
+ maybe contest => $args{contest},
+ maybe owner => $args{owner},
+ maybe problem => $args{problem},
+ maybe result => $args{result},
+ );
+ $where{private} = 0 unless $args{private};
+
+ my $rows = $self->{dbis}->select('job_entry', 'COUNT(*)', \%where)->list;
+ my $pages = int (($rows + JOBS_PER_PAGE - 1) / JOBS_PER_PAGE);
+ my ($stmt, @bind) = $self->{dbis}->abstract->select('job_entry', '*', \%where, {-desc => 'id'});
+ my $jobs = $self->{dbis}->query("$stmt LIMIT " . JOBS_PER_PAGE . ' OFFSET ' . ($args{page} - 1) * JOBS_PER_PAGE, @bind)->hashes;
+ my %ret = (
+ log => $jobs,
+ current_page => $args{page},
+ last_page => $pages,
+ );
+ $self->add_names($ret{log});
+ $ret{previous_page} = $args{page} - 1 if $args{page} - 1;
+ $ret{next_page} = $args{page} + 1 if $args{page} < $pages;
+
+ \%ret;
+}
+
+sub job_entry {
+ my ($self, $id) = @_;
+ my $ret = $self->query(job_entry_sth => $id)->hash;
+ $ret->{results} &&= decode_json $ret->{results};
+ $self->add_names($ret);
+}
+
+sub job_full {
+ my ($self, $id) = @_;
+ scalar $self->query(job_full_sth => $id)->hash
+}
+
+sub create_job {
+ my ($self, %args) = @_;
+ $self->{dbis}->update('users', {lastjob => time});
+ purge '/log/';
+ scalar $self->{dbis}->insert('jobs', \%args, {returning => 'id'})->list
+}
+
+sub calc_score {
+ my ($mxscore, $time, $tries, $totaltime) = @_;
+ my $score = $mxscore;
+ $time = 0 if $time < 0;
+ $time = 300 if $time > $totaltime;
+ $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 ($self, $ct) = @_;
+ $ct = $self->contest_entry($ct);
+
+ my @problems = $self->query(contest_problems_sth => $ct->{id})->flat;
+ my $pblist = $self->problem_list;
+ my %values = $self->query('problem_values_sth')->map;
+# $values{$_} = $values{$_}->{value} for keys %values;
+
+ my (%scores, %tries, %opens);
+ my $opens = $self->query(opens_sth => $ct->{id});
+ while ($opens->into(my ($problem, $owner, $time))) {
+ $opens{$problem, $owner} = $time;
+ }
+
+ my $jobs = $self->{dbis}->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;
+ 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 => $self->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 { [ $_, $self->object_name(problems => $_)] } @problems],
+ }
+}
+
+sub update_status_orig {