Show birthdays in menu

[ndwebbie.git] / lib / NDWeb / Controller / Root.pm

diff --git a/lib/NDWeb/Controller/Root.pm b/lib/NDWeb/Controller/Root.pm
index a7a59de1bc07e08e6f107a9f6df78081f6493fd1..a1eac62c9f76b8cf7bd932a97dd14a4ba56d4c83 100644 (file)
--- a/lib/NDWeb/Controller/Root.pm
+++ b/lib/NDWeb/Controller/Root.pm
@@ -60,7 +60,9 @@ sub login : Local {
                $log->execute($c->user->id,$c->req->address
                        ,$country,$c->sessionid,$remember);
 
-               $c->res->redirect($c->req->referer);
+               my $ref = $c->req->referer;
+               $ref =~ s/^http:/https:/ unless $c->debug;
+               $c->res->redirect($ref);
                return;
        }
 }
@@ -117,16 +119,17 @@ sub listAlliances : Private {
        $c->stash(alliances => \@alliances);
 }
 
+sub sslurl {
+       return $_[0];
+}
+
 sub auto : Private {
        my ($self, $c) = @_;
        my $dbh = $c ->model;
 
        $c->stash(dbh => $dbh);
 
-       $c->stash(sslurl => sub {
-                       $_[0]->scheme('https') unless $c->debug;
-                       return $_[0];
-               });
+       $c->stash(sslurl => \&sslurl);
 
        $dbh->do(q{SET timezone = 'GMT'});
 
@@ -195,6 +198,15 @@ sub end : ActionClass('RenderView') {
                                        || $c->check_user_roles(qw/no_fleet_update/)))),
                $c->forward('listTargets');
        }
+       if ($c->res->status == 200){
+               my $birthdays = $dbh->prepare(q{SELECT username
+                       ,date_part('year',age(birthday)) AS age
+                       FROM users WHERE birthday IS NOT NULL
+                               AND mmdd(birthday) = mmdd(CURRENT_DATE)
+               });
+               $birthdays->execute;
+               $c->stash(birthdays => $birthdays->fetchall_arrayref({}));
+       }
 }
 
 =head1 AUTHOR