Changeset 251

Timestamp:

12/05/09 15:31:04 (15 years ago)

Author:

nanardon

Message:

• first page don't show anymore poll list, a form allow to ask for a reminder about people poll

Location:

trunk

Files:

• . (modified) (1 prop)
• lib/Epoll/Controller/Root.pm (modified) (1 diff)
• lib/Epoll/DB.pm (modified) (1 diff)
• root/mail/poll_reminder_voting.tt (added)
• root/static/vote.css (modified) (1 diff)
• root/templates/default.tt (modified) (1 diff)
• root/templates/includes/footer.tt (modified) (1 diff)

trunk/lib/Epoll/Controller/Root.pm

@@ -35 +35 @@
     my ( $self, $c ) = @_;
     $c->stash->{page}{title} = 'Epoll ' . $Epoll::DB::VERSION;
+    if ($c->req->param('mailvoting')) {
+        my @polls_voting = $c->model('Vote')->find_poll_by_notyet_voting(
+            $c->req->param('mailvoting')
+        );
+        my @polls_owner = $c->model('Vote')->find_poll_by_owner(
+            $c->req->param('mailvoting')
+        );
+
+        if (scalar(@polls_voting) || scalar(@polls_owner)) {
+            $c->forward(
+                q'Epoll::View::Mail', 'render',
+                [ 'poll_reminder_voting.tt', {
+                    To => $c->req->param('mailvoting'),
+                    Subject => 'Poll request reminder',
+                    mail => {
+                        label => 'Poll request reminder',
+                        polls_owner => \@polls_owner,
+                        polls_voting => \@polls_voting,
+                    },
+                }]
+            );
+            $c->stash->{sendvoting} = $c->req->param('mailvoting');
+        } else {
+            $c->stash->{novoting} = $c->req->param('mailvoting');
+        }
+    }
 }
 

trunk/lib/Epoll/DB.pm

@@ -212 +212 @@
 }
 
+sub find_poll_by_voting {
+    my ($self, $mail) = @_;
+    $mail or return;
+    my $finder = $self->db->prepare_cached(
+        q{select poll, date from voting left join signing
+          on voting.key = signing.key
+          where mail = lower($1)
+          order by date desc
+        }
+    );
+    $finder->execute($mail);
+    my @results;
+    while (my $res = $finder->fetchrow_hashref) {
+        push(@results, $res);
+    }
+    @results
+}
+
+sub find_poll_by_notyet_voting {
+    my ($self, $mail) = @_;
+    $mail or return;
+    my $finder = $self->db->prepare_cached(
+        q{select poll from voting where
+          key not in (select key from signing)
+            and
+          poll in (select id from poll where "end" > now())
+            and
+          mail = lower($1)
+        }
+    );
+    $finder->execute($mail);
+    my @results;
+    while (my $res = $finder->fetchrow_hashref) {
+        push(@results, $res);
+    }
+    @results
+}
+
+sub find_poll_by_owner {
+    my ($self, $mail) = @_;
+    $mail or return;
+    my $finder = $self->db->prepare_cached(
+        q{select id, "end" > now() as terminated from poll where owner = lower($1)
+          order by "end" desc}
+    );
+    $finder->execute($mail);
+    my @results;
+    while (my $res = $finder->fetchrow_hashref) {
+        push(@results, $res);
+    }
+    @results
+}
+
 =head1 AUTHOR
 

trunk/root/static/vote.css

@@ -175 +175 @@
 
 #poll_confirm {}
+
+div.reminder {
+    font-size: 75%;
+    border: outset;
+    padding: 0.2em;
+}
+
+input.reminder {
+    font-size: 75%
+}

trunk/root/templates/default.tt

@@ -2 +2 @@
 [% vote = c.model('Vote') %]
 
-[% FOREACH id = vote.list_running_vote %]
-[% IF loop.first %]
-<div id="global_poll">
-<div id="open_poll">
-<h1>Vote en cours</h1>
-<table>
-<tbody>
+<div style="float: right; width: 33%;" class="reminder">
+<form action="[% c.uri_for %]" method="POST">
+[% IF novoting %]
+<p class="warning">Aucun vote en cours ne concerne [% novoting | html %].</p>
 [% END %]
-<tr>
-<td><lu><li><a href="[% c.uri_for( '/vote', vote.poll(id).uid ) %]">[% c.model('Vote').poll(id).info('label') | html %]</a></lu></td></td>
-<td>&gt;<a href="[% c.uri_for( '/ballot', vote.poll(id).uid ) %]"> Voter</a></td>
-</tr>
-[% IF loop.last %]
-</tbody>
-</table>
-</div>
-[% END %]
+[% IF sendvoting %]
+Un mail a été envoyé à [% sendvoting %]
 [% END %]
 
-[% FOREACH id = vote.list_comming_vote %]
-[% IF loop.first %]
-<div id="comming_poll">
-<h1>Vote à venir</h1>
-<table>
-<tbody>
-[% END %]
-<tr>
-<td><lu><li><a href="[% c.uri_for( 'vote', vote.poll(id).uid ) %]">[% c.model('Vote').poll(id).info('label') | html %]</a></li></lu></td>
-<td>&gt;<a href="[% c.uri_for( '/admin', vote.poll(id).uid ) %]"> Administrer</a></td>
-</tr>
-[% IF loop.last %]
-</tbody>
-</table>
+<p>Pour retrouver les votes qui vous concerne, indiquez votre adresse mail:</p>
+<input type="text" name="mailvoting" class="reminder">
+<input type="submit" class="reminder" value=">">
+</form>
 </div>
-[% END %]
-[% END %]
-
-
-[% FOREACH id = vote.list_closed_vote %]
-[% IF loop.first %]
-<div id="closed_poll">
-<h1>Vote Ferm&eacute;</h1>
-<table>
-<tbody>
-[% END %]
-<tr>
-<td><lu><li><a href="[% c.uri_for( 'vote', vote.poll(id).uid ) %]">[% c.model('Vote').poll(id).info('label') | html %]</a></lu></td>
-</tr>
-[% IF loop.last %]
-</tbody>
-</table>
-</div>
-</div>
-[% END %]
-[% END %]

trunk/root/templates/includes/footer.tt

@@ -1 +1 @@
 <!-- $Id$ -->
-<div id="footer">
+<div id="footer" style="clear: both">
 <a href="http://forge.ipsl.jussieu.fr/epoll"> Epoll [% Vote.VERSION | html %]</a>
 <a href="http://www.catalystframework.org/"><img src="[% c.uri_for('/static', 'images', 'btn_88x31_powered_shadow.png') %]"></a>