Changeset 43 for trunk/lib/Vote/Model

Timestamp:

03/16/09 23:01:09 (15 years ago)

Author:

nanardon

Message:

• add map ballot feature

File:

• trunk/lib/Vote/Model/Vote.pm (modified) (2 diffs)

trunk/lib/Vote/Model/Vote.pm

@@ -631 +631 @@
         select value from ballot join ballot_item
         on ballot.id = ballot_item.id
-        where poll = ? and fromlist = false
+        where poll = ? and fromlist = false and corrected is null
         group by value order by value
         }
@@ -648 +648 @@
     my $getval = $self->db->prepare_cached(
         q{
-        select value from ballot join ballot_item
+        select coalesce(corrected, value) as value from ballot join ballot_item
         on ballot.id = ballot_item.id
         where poll = ?
-        group by value order by value
+        group by coalesce(corrected, value) order by coalesce(corrected, value)
         }
     );