Changeset 61 for trunk/lib

Timestamp:

03/17/09 19:11:33 (15 years ago)

Author:

nanardon

Message:

• improve admin page

Location:

trunk/lib/Vote

Files:

• Controller/Admin.pm (modified) (1 diff)
• Model/Vote.pm (modified) (1 diff)

trunk/lib/Vote/Controller/Admin.pm

@@ -70 +70 @@
                 and $vote->db->commit;
         } elsif ($c->req->param('label')) {
+            if ($c->req->param('dstart')) {
+                $c->req->param('start',
+                    $c->req->param('dstart') . ' ' . ($c->req->param('hstart') || '')
+                );
+            }
+            if ($c->req->param('dend')) {
+                $c->req->param('end',
+                    $c->req->param('dend') . ' ' . ($c->req->param('hend') || '')
+                );
+            }
             $vote->vote_param(
                 $id,

trunk/lib/Vote/Model/Vote.pm

@@ -165 +165 @@
     my $sth = $self->db->prepare_cached(
         q{
-        select * from poll where id = ?
+        select *,
+        to_char("start", 'DD/MM/YYYY') as dstart,
+        to_char("start", 'HH24:MI:SS') as hstart,
+        to_char("end", 'DD/MM/YYYY') as dend,
+        to_char("end", 'HH24:MI:SS') as hend
+        from poll where id = ?
         }
     );