=head1 NAME
-Gruntmaster::Data::Result::Contest
+Gruntmaster::Data::Result::Contest - List of contests
=cut
data_type: 'integer'
is_nullable: 0
+Unix time when contest starts
+
=head2 stop
data_type: 'integer'
is_nullable: 0
+Unix time when contest ends
+
=head2 owner
data_type: 'text'
{ cascade_copy => 0, cascade_delete => 0 },
);
+=head2 contest_statuses
+
+Type: has_many
+
+Related object: L<Gruntmaster::Data::Result::ContestStatus>
+
+=cut
+
+__PACKAGE__->has_many(
+ "contest_statuses",
+ "Gruntmaster::Data::Result::ContestStatus",
+ { "foreign.contest" => "self.id" },
+ { cascade_copy => 0, cascade_delete => 0 },
+);
+
=head2 jobs
Type: has_many
"owner",
"Gruntmaster::Data::Result::User",
{ id => "owner" },
- { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "NO ACTION" },
);
=head2 problems
__PACKAGE__->many_to_many("problems", "contest_problems", "problem");
-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-03-06 12:41:16
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:T5tUpU1TOahLKzx9iVie3A
+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2014-12-19 16:54:00
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IxxZqQwKisBwDabCNUD55Q
+
+use Class::Method::Modifiers qw/after/;
+use List::Util qw/sum/;
+
+after qw/insert update delete/ => sub {
+ my ($self) = @_;
+ Gruntmaster::Data::purge '/ct/';
+ Gruntmaster::Data::purge '/ct/' . $self->id;
+};
sub is_pending {
my ($self, $time) = @_;
!$self->is_pending($time) && !$self->is_finished($time)
}
+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) = @_;
+ my $ct = $self->id;
+
+ my @problems = map { $_->rawproblem } $self->contest_problems->search({contest => $ct}, {qw/join problem order_by problem.level/});
+ my (%scores, %tries, %opens);
+ $opens{$_->rawproblem, $_->rawowner} = $_ for $self->opens->search({contest => $ct});
+ for my $job ($self->jobs->search({contest => $ct}, {qw/order_by me.id prefetch/ => [qw/problem/]})) {
+ my $open = $opens{$job->rawproblem, $job->rawowner};
+ my $time = $job->date - ($open ? $open->time : $self->start);
+ next if $time < 0;
+ my $value = $job->problem->value;
+ my $factor = $job->result ? 0 : 1;
+ $factor = $1 / 100 if $job->result_text =~ /^(\d+ )/s;
+ $scores{$job->rawowner}{$job->rawproblem} = int ($factor * calc_score ($value, $time, $tries{$job->rawowner}{$job->rawproblem}++, $self->stop - $self->start));
+ }
+
+ my %user_to_name = map { $_->id => $_->name } $self->result_source->schema->users->all;
+
+ my @st = sort { $b->{score} <=> $a->{score} or $a->{user} cmp $b->{user} } map { ## no critic (ProhibitReverseSortBlock)
+ my $user = $_;
+ +{
+ user => $user,
+ user_name => $user_to_name{$user},
+ score => sum (values %{$scores{$user}}),
+ scores => [map { $scores{$user}{$_} // '-'} @problems],
+ }
+ } keys %scores;
+
+ $st[0]->{rank} = 1;
+ $st[$_]->{rank} = $st[$_ - 1]->{rank} + ($st[$_]->{score} < $st[$_ - 1]->{score}) for 1 .. $#st;
+ @st
+}
+
1;
__END__