From Redis to Postgres - Part 1 (Getting started)

[gruntmaster-page.git] / lib / Gruntmaster / Page / St.pm

diff --git a/lib/Gruntmaster/Page/St.pm b/lib/Gruntmaster/Page/St.pm
index dafd5df249e21b1604441d1ba0033e12b4a3080c..2d7b23831f29cb08420ae5d04f90dc1b9d07279c 100644 (file)
--- a/lib/Gruntmaster/Page/St.pm
+++ b/lib/Gruntmaster/Page/St.pm
@@ -1,50 +1,60 @@
 package Gruntmaster::Page::St;
 
-use 5.014000;
-use strict;
-use warnings;
 use Gruntmaster::Page::Base st => 'Standings';
-our @ISA = qw/Gruntmaster::Page::Base/;
-our $VERSION = '0.001';
-
-use constant => TEMPLATES => {
-       en => <<'HTML',
-<table border>
-<thead>
-<tr><th>Username<tmpl_loop problems><th><tmpl_var _></tmpl_loop><th>Total
-<tbody>
-<tmpl_loop st><tr><td><tmpl_var user>
-<tmpl_loop scores><td><tmpl_var _>
-</tmpl_loop><td><tmpl_var score>
-</tmpl_loop>
-</table>
-HTML
+
+use constant LEVEL_VALUES => {
+       beginner => 100,
+       easy => 250,
+       medium => 500,
+       hard => 1000,
 };
 
+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 _generate{
-       my ($self, $htc, $path, $lang) = @_;
+       my ($self, $htc, $lang, $env, $ct) = @_;
+       debug $env => "language is '$lang' and contest is '$ct'";
 
-       local $Gruntmaster::Data::contest = ($path =~ m,^ct/([^/]+)/,)[0];
+       $ct &&= db($env)->contest($ct);
 
-       my @problems = sort problems;
-       my %scores;
-       for (1 .. jobcard) {
-               if (job_result_text =~ m/^(\d+)/) {
-                       $scores{job_user()}{job_problem()} = $1;
+       my @problems = map { $_->problem } db($env)->contest_problems->search({contest => $ct->id}, {qw/join problem order_by problem.level/});
+       my (%scores, %tries);
+       for my $job (db($env)->jobs->search({contest => $ct->id})) {
+
+               if ($ct) {
+                       my $time = $job->date - $ct->start;
+                       next if $time < 0;
+                       my $value = $job->problem->value // LEVEL_VALUES->{$job->problem->level};
+                       $scores{$job->owner->id}{$job->problem->id} = $job->result ? 0 : calc_score ($value, $time, $tries{$job->owner}{$job->problem}, $ct->stop - $ct->start);
+                       $tries{$job->owner->id}{$job->problem->id}++;
                } else {
-                       $scores{job_user()}{job_problem()} = job_result() ? 0 : 100;
+                       no warnings 'numeric';
+                       $scores{$job->owner->id}{$job->problem->id} = 0 + $job->result_text || ($job->result ? 0 : 100)
                }
        }
 
-       my @st = sort { $b->{score} <=> $a->{score} } map {
+       my @st = sort { $b->{score} <=> $a->{score} or $a->{user} cmp $b->{user}} map {
                my $user = $_;
                +{
-                       user => $user,
+                       user => db($env)->user($user),
                        score => sum (values $scores{$user}),
-                       scores => [map { $scores{$user}{$_} // '-'} @problems],
+                       scores => [map { $scores{$user}{$_->id} // '-'} @problems],
+                       problems => $ct,
                }
        } keys %scores;
-       $htc->param(problems => \@problems);
+
+       $st[0]->{rank} = 1;
+       $st[$_]->{rank} = $st[$_ - 1]->{rank} + ($st[$_]->{score} < $st[$_ - 1]->{score}) for 1 .. $#st;
+       $htc->param(problems => \@problems) if $ct;
        $htc->param(st => \@st);
 }